nyc-transit-data/turnstile_daily_counts_2021
   1
 2
turnstile_daily_counts_2021
Dataset published by nyc-transit-data 

No description provided

2 commits3,533 rows308.6KBcsv
HEAD yKaDDAM  add a readme (based on the 2020 dataset)
6 days ago
Readme

nyc-transit-data/turnstile_daily_counts_2021

NYC Subway Turnstile Counts Data aggregated by day and station complex for the year 2021. Updated weekly, usually on Monday mornings. (The pipeline is mostly automated, but must be manually triggered)

Where the Data Came From

This aggregation was created from weekly raw turnstile counts published by the New York MTA at http://web.mta.info/developers/turnstile.html

The raw data were imported into a postgresql database for processing, and aggregated to calendar days for each station complex.

The process is outlined in this blog post, and the code for the data pipeline is available on github.

Caveats

This aggregation is a best-effort to make a clean and usable dataset of station-level counts. There were some assumptions and important decisions made to arrive at the finished product.

  • The dataset excludes turnstile observation windows (4 hours) that resulted in entries or exits of over 10,000. This threshold excludes the obviously spurious numbers that come from the counters rolling over, but could include false readings that are within the threshold.

  • The turnstile counts were aggregated to calendar day using the timestamp of the end of the 4-hour observation window + 2 hours. An observation window that ends at 2am would count for the same day, but a window ending between midnight and 1:59am would count for the previous day.

  • The last date in the dataset contains a small number of entries and exits that will be aggregated into the next week’s worth of data, and should not be used.

PATH and Roosevelt Island Tramway

The dataset also includes turnstile counts for the PATH train system and the Roosevelt Island Tramway

CSV
301.38 KB
3,533
136
2

CSV Configuration

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

Schema

titletypedescription
stop_name
string
daytime_routes
string
division
string
line
string
borough
string
structure
string
gtfs_longitude
number
gtfs_latitude
number
complex_id
integer
date
string
entries
integer
exits
integer
Body Preview
qri-row-numberstop_namedaytime_routesdivisionlineboroughstructuregtfs_longitudegtfs_latitudecomplex_iddateentriesexits
1Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0114592129
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0227813475
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0316862330
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0444965346
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0546595682
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0646435402
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0745725596
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0847295767
949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0119282625
1049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0227353875
1149 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0317082330
1249 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0428684032
1349 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0529853991
1449 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0629264026
1549 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0729633859
1649 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0829854091
17Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-01380551
18Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-02481697
19Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-03457618
20Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-049991132
21Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-059891138
22Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-0610851240
23Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-0710681254
24Hewes StJ MBMTJamaicaBkElevated-73.95343140.706871002021-01-089371118
25Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0115132078
26Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0218072678
27Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0315552080
28Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0438704640
29Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0539424655
30Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0639924663
31Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0739294709
32Marcy AvJ M ZBMTJamaicaBkElevated-73.95775740.7083591012021-01-0834744281
33BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-014691002
34BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-029081825
35BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-036181262
36BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-047661318
37BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-057501250
38BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-067061268
39BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-077751347
40BoweryJ ZBMTJamaicaMSubway-73.99391540.720281032021-01-087551386
41Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-01365375
42Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-02562549
43Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-03328329
44Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-041353784
45Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-051398786
46Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-061390781
47Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-071392806
48Broad StJ ZBMTJamaicaMSubway-74.01105640.7064761072021-01-081136682
49Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-01380580
50Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-02653875
51Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-03431628
52Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-0416501764
53Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-0516231846
54Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-0616601788
55Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-0715761710
56Middle Village - Metropolitan AvMBMTMyrtle AvQElevated-73.88960140.7113961082021-01-0815831705
57Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-01674901
58Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0211231481
59Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-037401015
60Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0423172940
61Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0523702997
62Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0624172947
63Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0722912953
64Fresh Pond RdMBMTMyrtle AvQElevated-73.89587740.7061861092021-01-0822972437
65Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-01432512
66Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-02650692
67Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-03452567
68Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-0416031491
69Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-0517201575
70Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-0617111652
71Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-0716851644
72Forest AvMBMTMyrtle AvQElevated-73.90307740.7044231102021-01-0815861334
73Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-01320475
74Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-02451592
75Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-03321475
76Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-049921299
77Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-0510841332
78Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-0611811360
79Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-0711411370
80Seneca AvMBMTMyrtle AvQElevated-73.9077440.7027621112021-01-0810401134
81Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-01502790
82Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-028261045
83Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-03575727
84Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-0415381985
85Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-0514771982
86Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-0616052159
87Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-0715291997
88Knickerbocker AvMBMTMyrtle AvBkElevated-73.91971140.6986641132021-01-0815631816
89Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-01385502
90Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-02545581
91Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-03356528
92Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-0411721370
93Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-0511721442
94Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-0611981457
95Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-0711911539
96Central AvMBMTMyrtle AvBkElevated-73.92739740.6978571142021-01-0812171310
973 AvLBMTCanarsieMSubway-73.98612240.7328491182021-01-01618801
983 AvLBMTCanarsieMSubway-73.98612240.7328491182021-01-0210781443
993 AvLBMTCanarsieMSubway-73.98612240.7328491182021-01-03750999
1003 AvLBMTCanarsieMSubway-73.98612240.7328491182021-01-0415561759
Previewing 100 of 3,533 rows