nyc-transit-data/remote_complex_lookupcsv
   0
 30
MTA Turnstiles Remote-Complex Lookup
Dataset published by nyc-transit-data 

A lookup table for joining "remote unit" identifiers found in the NY MTA Turnstile Data with station complex ids found in the MTA station list.

3 commits776 rows26.3KBcsv
HEAD Zm2Xm6N  remove station ids for JFK airtrain, fix mapping for penn station, other mapping fixes
a year ago
Readme

MTA Turnstiles Remote-Complex Lookup

A lookup table for joining “remote unit” identifiers found in the NY MTA Turnstile Data with station complex ids found in the MTA station list.

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.

Origins

This table is based on Remote Unit/Control Area/Station Name Key, published alongside the turnstile data at http://web.mta.info/developers/turnstile.html

Complex ids were manually added by associating station and line information with records in the MTA Station Locations dataset.

CSV
25.72 KB
776
36
2

CSV Configuration

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

Schema

titletypedescription
remote
string
booth
string
complex_id
integer
station
string
line_name
string
division
string
Body Preview
qri-row-numberremoteboothcomplex_idstationline_namedivision
1R001A060635WHITEHALL STR1BMT
2R001A058635WHITEHALL STR1BMT
3R001R101S635SOUTH FERRYR1IRT
4R002A077628FULTON STACJZ2345BMT
5R002A081628FULTON STACJZ2345BMT
6R002A082628FULTON STACJZ2345BMT
7R003J02586CYPRESS HILLSJBMT
8R004J02885ELDERTS LANEJZBMT
9R005J03084FOREST PARKWAYJBMT
10R006J03183WOODHAVEN BLVDJZBMT
11R006J03283WOODHAVEN BLVDJZBMT
12R007J03482104 STJZBMT
13R008J03581111 STJBMT
14R009J03780121 STJZBMT
15R010N062A61142 ST-PA BUS TEACENQRS1237IND
16R010N06061142 ST-PA BUS TEACENQRS1237IND
17R011N063A61142 ST-PA BUS TEACENQRS1237IND
18R011N06261142 ST-PA BUS TEACENQRS1237IND
19R011N06361142 ST-PA BUS TEACENQRS1237IND
20R012N06716434 ST-PENN STAACEIND
21R012N06516434 ST-PENN STAACEIND
22R012N06816434 ST-PENN STAACEIND
23R012N07016434 ST-PENN STAACEIND
24R012N07216434 ST-PENN STAACEIND
25R013N07116434 ST-PENN STAACEIND
26R013N06916434 ST-PENN STAACEIND
27R013N07316434 ST-PENN STAACEIND
28R014N095628FULTON STACJZ2345IND
29R014R205628FULTON STACJZ2345IRT
30R014R206628FULTON ST2345ACJZIRT
31R014R208628FULTON ST2345ACJZIRT
32R014R205A628FULTON ST2345ACJZIRT
33R015N3032765 AVE-53 STEMIND
34R015N3042765 AVE-53 STEMIND
35R016N305A613LEXINGTON-53 STEM6IND
36R017N306613LEXINGTON-53 STEM6IND
37R017N305613LEXINGTON-53 STEM6IND
38R018N324616ROOSEVELT AVEEFMR7IND
39R018N323616ROOSEVELT AVEEFMR7IND
40R018R52561674 ST-BROADWAYEFMR7IRT
41R019N343254JAMAICA-179 STFIND
42R019N342254JAMAICA-179 STFIND
43R020N50022547-50 ST-ROCKBDFMIND
44R020N50122547-50 ST-ROCKBDFMIND
45R020N501A22547-50 ST-ROCKBDFMIND
46R021N50360942 ST-BRYANT PKBDFM7IND
47R021N50260942 ST-BRYANT PKBDFM7IND
48R021N50460942 ST-BRYANT PKBDFM7IND
49R022N50660734 ST-HERALD SQBDFMNQRIND
50R022A02260734 ST-HERALD SQBDFMNQRBMT
51R022N50560734 ST-HERALD SQBDFMNQRIND
52R023N50760734 ST-HERALD SQBDFMNQRIND
53R023A02560734 ST-HERALD SQBDFMNQRBMT
54R024N605279SUTPHIN BLVDEJZIND
55R025N606278JAMAICA CENTEREJZIND
56R025N607278JAMAICA CENTEREJZIND
57R027R111333WALL ST23IRT
58R027R110333WALL ST23IRT
59R027R112333WALL ST23IRT
60R027R112A333WALL ST23IRT
61R028R113A628FULTON ST2345ACJZIRT
62R028R113628FULTON ST2345ACJZIRT
63R028R114628FULTON ST2345ACJZIRT
64R029R115624PARK PLACE23ACEIRT
65R029N094624WORLD TRADE CTR23ACEIND
66R029N091624CHAMBERS STACE23IND
67R029N092624CHAMBERS STACE23IND
68R030R116327CHAMBERS ST123IRT
69R031R14131834 ST-PENN STA123IRT
70R031R13531834 ST-PENN STA123IRT
71R031R13731834 ST-PENN STA123IRT
72R031R13931834 ST-PENN STA123IRT
73R032R14561142 ST-TIMES SQ1237ACENQRSIRT
74R032A02161142 ST-TIMES SQ1237ACENQRSBMT
75R032R14361142 ST-TIMES SQACENQRS1237IRT
76R032R14661142 ST-TIMES SQ1237ACENQRSIRT
77R033R15161142 ST-TIMES SQ1237ACENQRSIRT
78R033R14861142 ST-TIMES SQ1237ACENQRSIRT
79R033R15061142 ST-TIMES SQ1237ACENQRSIRT
80R033R15361142 ST-TIMES SQ1237ACENQRSIRT
81R033R14761142 ST-TIMES SQ1237ACENQRSIRT
82R034R174306125 ST1IRT
83R035R182605168 ST-BROADWAY1ACIRT
84R035N012605168 ST-BROADWAY1ACIND
85R035N013605168 ST-BROADWAYAC1IND
86R036R186299DYCKMAN ST1IRT
87R037R188298207 ST1IRT
88R038R190297215 ST1IRT
89R039R192296MARBLE HILL-2251IRT
90R040R194295231 ST1IRT
91R041R201414BOWLING GREEN45IRT
92R041R200A414BOWLING GREEN45IRT
93R042R202414BOWLING GREEN45IRT
94R043R203413WALL ST45IRT
95R043R203A413WALL ST45IRT
96R043R204413WALL ST45IRT
97R043R204A413WALL ST45IRT
98R044R210622BROOKLYN BRIDGE456JZIRT
99R044A069622CHAMBERS ST456JZBMT
100R044A071622CHAMBERS STJZ456BMT
Previewing 100 of 776 rows