nyc-transit-data/turnstile_daily_counts_2020

NYC Subway Turnstile Counts - 2020

62,631 entries
5.22 MB size
CSV format
latest commit: 8 days ago
Readme

nyc-transit-data/turnstile_daily_counts_2020

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

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

Spurious Data in early versions

Versions prior to QmPkGqJ318gcok69Noj3gw3coby8FDrab3x1hBisFcU3Yq were built with a pipeline that had a major error, causing inaccurate numbers near the transition between weekly input files.

Meta

Theme

none

Keywords

NYC
transit
subway
turnstiles
mobility

Description

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

Body Preview
stop_namedaytime_routesdivisionlineboroughstructuregtfs_longitudegtfs_latitudecomplex_iddateentriesexits
1Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-0170247060
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-021523412171
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-031568714586
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-04932410309
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-0576598371
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-061665812689
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-071730813896
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-081759215980
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-091751014937
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-101720815684
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-111025011554
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1280258602
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-131656712380
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-141725215102
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-151774015427
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-161738015115
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-171672615233
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1885239736
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1973107282
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-20103339089
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-211690113138
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-221725614900
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-231736414965
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-241712915531
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-2584549671
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-2673037080
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-271649312139
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-281766414761
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-291785015995
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-301798115437
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-311722915388
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-01921310266
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0272917819
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-031685911926
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-041764815540
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-051791316004
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-061786715182
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-071720415760
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-08959910638
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0975227670
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-101664012408
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-111762914597
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-121764915940
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-131780015078
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-141703215937
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-1589179770
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-1672657331
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-17103039005
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-181623112655
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-191662914688
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-201658314553
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-211561015011
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-22949510079
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-2375717871
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-241661712271
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-251740315417
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-261742415129
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-271784315408
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-281706815807
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-29921310441
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-0171787600
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-021662912075
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-031749315219
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-041732515380
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-051764915327
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-061643315614
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-07930410415
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-0874698210
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-091622013393
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-101616914563
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-111542014192
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-121373613076
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-131131311079
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1457286198
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1538034188
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1668056482
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1753825457
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1847004774
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1938944183
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2034873766
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2117732032
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2211741311
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2318182135
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2419692256
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2517221984
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2617321996
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2716501901
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-289101221
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-29671856
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-3013671524
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-3112681504
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0112911454
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0211851492
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0311621342
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-04686970
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-05573750
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0610891273
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0710561295
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0810241185
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0910201261
Previewing 100 of 62,631 entries