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

No description provided

9 commits25,180 rows2.2MBcsv
HEAD 9gnP5oh  update data for week ending February 27
3 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
2.1 MB
25,180
973
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
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-0929143804
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1021313026
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1144605483
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1247645806
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1346875702
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1443684517
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1550926884
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1629173714
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1721792994
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1837214763
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-1946735742
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2044755550
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2147455739
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2248375797
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2319863468
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2420392821
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2545045531
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2645835587
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2747935829
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2847155805
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-2941485262
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-3027303489
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-01-3119732690
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0111751486
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0229613571
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0348836119
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0451136369
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0549956091
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0631554135
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0717542399
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0845055621
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-0948996030
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1049476158
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1148786194
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1248536045
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1330703924
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1422863113
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1533374353
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1646435745
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1747496060
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1837874864
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-1942675418
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2032214095
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2124003202
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2243235394
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2348585986
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2449766340
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2551266288
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2651166130
5849 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0119282625
5949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0227353875
6049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0317082330
6149 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0428684032
6249 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0529853991
6349 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0629264026
6449 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0729633859
6549 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0829854091
6649 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-0923313325
6749 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1015812434
6849 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1128213717
6949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1229723972
7049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1328443860
7149 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1430303928
7249 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1530274074
7349 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1623173392
7449 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1717982412
7549 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1823693307
7649 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-1928824012
7749 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2028143715
7849 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2129353859
7949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2230864342
8049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2321923159
8149 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2416652455
8249 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2528223876
8349 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2628383716
8449 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2728874031
8549 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2829234030
8649 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-2927153844
8749 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-3020963110
8849 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-01-3114152164
8949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0112041661
9049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0217532616
9149 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0329304008
9249 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0430114100
9349 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0530274251
9449 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0623513490
9549 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0712671820
9649 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0827293693
9749 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-0929644064
9849 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-1029834184
9949 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-1130204118
10049 StN R WBMTBroadway - BrightonMSubway-73.98413940.759901102021-02-1232384556
Previewing 100 of 25,180 rows