NYC Turnstiles Station List
A table of station details for stations found in the turnstiles dataset, including NYC Transit Subway, PATH Train, and the Roosevelt Island Tramway. Based on the MTA station locations dataset found at http://web.mta.info/developers/data/nyct/subway/Stations.csv
This dataset is used in the data pipeline for creating aggregated turnstile counts datasets (2019, 2020)
The process is outlined in this blog post, and the code for the data pipeline is available on github.
Details about the PATH train stations and the two Roosevelt Island Tramway stations were added to this table of subway stations so that a single lookup could be done to append stop name, lat, lon, etc to the aggregated daily turnstile counts.
Future work may include consolidating the station complex rows into a single row for each complex, with a better name, and a better lat/lon coordinate for the complex. Right now, the data pipeline uses the first match, which may not accurately describe the entire station complex.