nyc-transit-data/turnstile_daily_counts_2021
   1
 98
NYC Subway Turnstile Counts - 2021
Dataset published by nyc-transit-data 

NYC Subway Turnstile Counts Data aggregated by day and station complex for the year 2020. Updated weekly.

25 commits93,298 rows8.2MBcsv
HEAD gLV7rVo  update data for week ending July 31, 2021
2 months 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
7.79 MB
93,298
3,768
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
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2730213983
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-02-2822413106
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0146665738
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0249215995
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0351486394
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0450856271
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0550666294
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0633494190
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0724763418
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0848925957
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-0951056326
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1051296197
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1151356325
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1253666664
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1334904636
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1425123625
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1547755923
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1649006254
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1749886205
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1847155670
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-1951446448
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2035214643
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2127383741
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2249806078
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2352096426
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2450916235
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2551796480
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2653266529
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2738104687
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2821353035
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-2948476087
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-3051556595
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-03-3147756344
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0150576361
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0247916246
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0335324472
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0423373369
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0549856166
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0653826815
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0753886702
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0855376673
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-0955446661
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612021-04-1036844859
Previewing 100 of 93,298 rows