I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove from the map those that were subsequently abandoned. My data would look something like this (assuming the end date of the visualization was the year 1650)
PLACE FOUNDED ABANDONED City_1 1585 1650 City_2 1600 1625 City_3 1615 1620 City_4 1630 1650
As it stands, I have the choice of (a) having the cities appear/disappear according to their foundation date or (b) having all of the cities accumulate on the map. Neither of these solutions work because for a given year (i.e. 1622), I will either show cities that no longer existed or hide some that continued to be there. I know that there is a similar discussion on this matter here, but the solution of adding a row for each year is not feasible in my case.