nyc-transit-data/turnstiles_station_list
   0
 52
NYC Turnstiles Station List
Dataset published by nyc-transit-data 

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

2 commits511 rows66.6KBcsv
HEAD wxAQkbq  add readme and meta
a year ago
Readme

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.

CSV
65.09 KB
511
30
2

CSV Configuration

This table contains a header row
This table uses different quotes to indicate strings

Schema

titletypedescription
ogc_fid
integer
station_id
integer
complex_id
integer
gtfs_stop_id
string
division
string
line
string
stop_name
string
borough
string
daytime_routes
string
structure
string
gtfs_latitude
number
gtfs_longitude
number
north_direction_label
string
south_direction_label
string
Body Preview
qri-row-numberogc_fidstation_idcomplex_idgtfs_stop_iddivisionlinestop_nameboroughdaytime_routesstructuregtfs_latitudegtfs_longitudenorth_direction_labelsouth_direction_label
1111R01BMTAstoriaAstoria - Ditmars BlvdQN WElevated40.775036-73.912034Manhattan
2222R03BMTAstoriaAstoria BlvdQN WElevated40.770258-73.917843Ditmars BlvdManhattan
3333R04BMTAstoria30 AvQN WElevated40.766779-73.921479Astoria - Ditmars BlvdManhattan
4444R05BMTAstoriaBroadwayQN WElevated40.76182-73.925508Astoria - Ditmars BlvdManhattan
5555R06BMTAstoria36 AvQN WElevated40.756804-73.929575Astoria - Ditmars BlvdManhattan
6666R08BMTAstoria39 AvQN WElevated40.752882-73.932755Astoria - Ditmars BlvdManhattan
777613R11BMTAstoriaLexington Av/59 StMN W RSubway40.76266-73.967258QueensDowntown & Brooklyn
8888R13BMTAstoria5 Av/59 StMN W RSubway40.764811-73.973347QueensDowntown & Brooklyn
9999R14BMTBroadway - Brighton57 St - 7 AvMN Q R WSubway40.764664-73.980658Uptown & QueensDowntown & Brooklyn
10101010R15BMTBroadway - Brighton49 StMN R WSubway40.759901-73.984139Uptown & QueensDowntown & Brooklyn
111111611R16BMTBroadway - BrightonTimes Sq - 42 StMN Q R WSubway40.754672-73.986754Uptown & QueensDowntown & Brooklyn
121212607R17BMTBroadway - Brighton34 St - Herald SqMN Q R WSubway40.749567-73.98795Uptown & QueensDowntown & Brooklyn
13131313R18BMTBroadway - Brighton28 StMR WSubway40.745494-73.988691Uptown & QueensDowntown & Brooklyn
14141414R19BMTBroadway - Brighton23 StMR WSubway40.741303-73.989344Uptown & QueensDowntown & Brooklyn
151515602R20BMTBroadway - Brighton14 St - Union SqMN Q R WSubway40.735736-73.990568Uptown & QueensDowntown & Brooklyn
16161616R21BMTBroadway - Brighton8 St - NYUMR WSubway40.730328-73.992629Uptown & QueensDowntown & Brooklyn
17171717R22BMTBroadway - BrightonPrince StMR WSubway40.724329-73.997702Uptown & QueensDowntown & Brooklyn
181818623R23BMTBroadwayCanal StMR WSubway40.719527-74.001775Uptown & QueensDowntown & Brooklyn
191919623Q01BMTManhattan BridgeCanal StMN QSubway40.718383-74.00046Uptown & QueensDowntown & Brooklyn
20202020R24BMTBroadwayCity HallMR WSubway40.713282-74.006978Uptown & QueensDowntown & Brooklyn
212121624R25BMTBroadwayCortlandt StMR WSubway40.710668-74.011029Uptown & QueensDowntown & Brooklyn
22222222R26BMTBroadwayRector StMR WSubway40.70722-74.013342Uptown & QueensDowntown & Brooklyn
232323635R27BMTBroadwayWhitehall StMR WSubway40.703087-74.012994Uptown & QueensBrooklyn
242424620R28BMTBroadwayCourt StBkRSubway40.6941-73.991777ManhattanBay Ridge - 95 St
252525636R29BMTBroadwayJay St - MetroTechBkRSubway40.69218-73.985942ManhattanBay Ridge - 95 St
26262626R30BMTBroadway - BrightonDeKalb AvBkB Q RSubway40.690635-73.981824ManhattanConey Island - Bay Ridge
272727617R31BMT4th AvAtlantic Av - Barclays CtrBkD N RSubway40.683666-73.97881ManhattanConey Island - Bay Ridge
28282828R32BMT4th AvUnion StBkRSubway40.677316-73.98311ManhattanBay Ridge - 95 St
292929608R33BMT4th Av9 StBkRSubway40.670847-73.988302ManhattanBay Ridge - 95 St
30303030R34BMT4th AvProspect AvBkRSubway40.665414-73.992872ManhattanBay Ridge - 95 St
31313131R35BMT4th Av25 StBkRSubway40.660397-73.998091ManhattanBay Ridge - 95 St
32323232R36BMT4th Av36 StBkD N RSubway40.655144-74.003549ManhattanConey Island - Bay Ridge
33333333R39BMT4th Av45 StBkRSubway40.648939-74.010006ManhattanBay Ridge - 95 St
34343434R40BMT4th Av53 StBkRSubway40.645069-74.014034ManhattanBay Ridge - 95 St
35353535R41BMT4th Av59 StBkN RSubway40.641362-74.017881ManhattanConey Island - Bay Ridge
36363636R42BMT4th AvBay Ridge AvBkRSubway40.634967-74.023377Manhattan95 St
37373737R43BMT4th Av77 StBkRSubway40.629742-74.02551Manhattan95 St
38383838R44BMT4th Av86 StBkRSubway40.622687-74.028398Manhattan95 St
39393939R45BMT4th AvBay Ridge - 95 StBkRSubway40.616622-74.030876Manhattan
404040617D24BMTBroadway - BrightonAtlantic Av - Barclays CtrBkB QSubway40.68446-73.97689ManhattanBrighton Beach & Coney Island
41414141D25BMTBroadway - Brighton7 AvBkB QSubway40.67705-73.972367ManhattanBrighton Beach & Coney Island
42424242D26BMTBroadway - BrightonProspect ParkBkB QOpen Cut40.661614-73.962246Manhattan & Franklin AvBrighton Beach & Coney Island
43434343D27BMTBroadway - BrightonParkside AvBkB QOpen Cut40.655292-73.961495ManhattanBrighton Beach & Coney Island
44444444D28BMTBroadway - BrightonChurch AvBkB QOpen Cut40.650527-73.962982ManhattanBrighton Beach & Coney Island
45454545D29BMTBroadway - BrightonBeverley RdBkB QOpen Cut40.644031-73.964492ManhattanBrighton Beach & Coney Island
46464646D30BMTBroadway - BrightonCortelyou RdBkB QOpen Cut40.640927-73.963891ManhattanBrighton Beach & Coney Island
47474747D31BMTBroadway - BrightonNewkirk PlazaBkB QOpen Cut40.635082-73.962793ManhattanBrighton Beach & Coney Island
48484848D32BMTBroadway - BrightonAvenue HBkB QOpen Cut40.62927-73.961639ManhattanBrighton Beach & Coney Island
49494949D33BMTBroadway - BrightonAvenue JBkB QOpen Cut40.625039-73.960803ManhattanBrighton Beach & Coney Island
50505050D34BMTBroadway - BrightonAvenue MBkB QOpen Cut40.617618-73.959399ManhattanBrighton Beach & Coney Island
51515151D35BMTBroadway - BrightonKings HwyBkB QOpen Cut40.60867-73.957734ManhattanBrighton Beach & Coney Island
52525252D37BMTBroadway - BrightonAvenue UBkB QOpen Cut40.5993-73.955929ManhattanBrighton Beach & Coney Island
53535353D38BMTBroadway - BrightonNeck RdBkB QOpen Cut40.595246-73.955161ManhattanBrighton Beach & Coney Island
54545454D39BMTBroadway - BrightonSheepshead BayBkB QOpen Cut40.586896-73.954155ManhattanBrighton Beach & Coney Island
55555555D40BMTBroadway - BrightonBrighton BeachBkB QElevated40.577621-73.961376ManhattanConey Island
56565656D41BMTBroadway - BrightonOcean PkwyBkQElevated40.576312-73.968501ManhattanStillwell Av
57575757D42BMTBroadway - BrightonW 8 St - NY AquariumBkF QElevated40.576127-73.975939ManhattanStillwell Av
58585858D43BMTSea Beach / West End / Culver / BrightonConey Island - Stillwell AvBkD F N QViaduct40.577422-73.981233Manhattan
59595959B12BMTWest End9 AvBkDOpen Cut40.646292-73.994324ManhattanConey Island
60606060B13BMTWest EndFort Hamilton PkwyBkDElevated40.640914-73.994304ManhattanConey Island
61616161B14BMTWest End50 StBkDElevated40.63626-73.994791ManhattanConey Island
62626262B15BMTWest End55 StBkDElevated40.631435-73.995476ManhattanConey Island
636363615B16BMTWest End62 StBkDElevated40.626472-73.996895ManhattanConey Island
64646464B17BMTWest End71 StBkDElevated40.619589-73.998864ManhattanConey Island
65656565B18BMTWest End79 StBkDElevated40.613501-74.00061ManhattanConey Island
66666666B19BMTWest End18 AvBkDElevated40.607954-74.001736ManhattanConey Island
67676767B20BMTWest End20 AvBkDElevated40.604556-73.998168ManhattanConey Island
68686868B21BMTWest EndBay PkwyBkDElevated40.601875-73.993728ManhattanConey Island
69696969B22BMTWest End25 AvBkDElevated40.597704-73.986829ManhattanConey Island
70707070B23BMTWest EndBay 50 StBkDElevated40.588841-73.983765ManhattanConey Island
71717171N02BMTSea Beach8 AvBkNOpen Cut40.635064-74.011719ManhattanConey Island
72727272N03BMTSea BeachFort Hamilton PkwyBkNOpen Cut40.631386-74.005351ManhattanConey Island
737373615N04BMTSea BeachNew Utrecht AvBkNOpen Cut40.624842-73.996353ManhattanConey Island
74747474N05BMTSea Beach18 AvBkNOpen Cut40.620671-73.990414ManhattanConey Island
75757575N06BMTSea Beach20 AvBkNOpen Cut40.61741-73.985026ManhattanConey Island
76767676N07BMTSea BeachBay PkwyBkNOpen Cut40.611815-73.981848ManhattanConey Island
77777777N08BMTSea BeachKings HwyBkNOpen Cut40.603923-73.980353ManhattanConey Island
78787878N09BMTSea BeachAvenue UBkNOpen Cut40.597473-73.979137ManhattanConey Island
79797979N10BMTSea Beach86 StBkNOpen Cut40.592721-73.97823ManhattanConey Island
80808080J12BMTJamaica121 StQJ ZElevated40.700492-73.828294JamaicaManhattan
81818181J13BMTJamaica111 StQJElevated40.697418-73.836345JamaicaManhattan
82828282J14BMTJamaica104 StQJ ZElevated40.695178-73.84433JamaicaManhattan
83838383J15BMTJamaicaWoodhaven BlvdQJ ZElevated40.693879-73.851576JamaicaManhattan
84848484J16BMTJamaica85 St - Forest PkwyQJElevated40.692435-73.86001JamaicaManhattan
85858585J17BMTJamaica75 StQJ ZElevated40.691324-73.867139JamaicaManhattan
86868686J19BMTJamaicaCypress HillsBkJElevated40.689941-73.87255JamaicaManhattan
87878787J20BMTJamaicaCrescent StBkJ ZElevated40.683194-73.873785JamaicaManhattan
88888888J21BMTJamaicaNorwood AvBkJ ZElevated40.68141-73.880039JamaicaManhattan
89898989J22BMTJamaicaCleveland StBkJElevated40.679947-73.884639JamaicaManhattan
90909090J23BMTJamaicaVan Siclen AvBkJ ZElevated40.678024-73.891688JamaicaManhattan
91919191J24BMTJamaicaAlabama AvBkJElevated40.676992-73.898654JamaicaManhattan
929292621J27BMTJamaicaBroadway JctBkJ ZElevated40.679498-73.904512JamaicaManhattan
93939393J28BMTJamaicaChauncey StBkJ ZElevated40.682893-73.910456JamaicaManhattan
94949494J29BMTJamaicaHalsey StBkJElevated40.68637-73.916559JamaicaManhattan
95959595J30BMTJamaicaGates AvBkJ ZElevated40.68963-73.92227JamaicaManhattan
96969696J31BMTJamaicaKosciuszko StBkJElevated40.693342-73.928814JamaicaManhattan
97979797M11BMTJamaicaMyrtle AvBkJ M ZElevated40.697207-73.935657Jamaica - Middle VillageManhattan
98989898M12BMTJamaicaFlushing AvBkJ MElevated40.70026-73.941126Jamaica - Middle VillageManhattan
99999999M13BMTJamaicaLorimer StBkJ MElevated40.703869-73.947408Jamaica - Middle VillageManhattan
100100100100M14BMTJamaicaHewes StBkJ MElevated40.70687-73.953431Jamaica - Middle VillageManhattan
Previewing 100 of 511 rows