nyc-transit-data/turnstile_daily_counts_2020
   11
 279
NYC Subway Turnstile Counts - 2020
Dataset published by nyc-transit-data 

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

52 commits144,055 rows12.6MBcsv
HEAD KynC5VU  update data for week ending November 21, 2020
5 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, 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

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.

CSV
11.99 MB
144,055
274
2

CSV Configuration

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

Schema

titletypedescription
stop_name
string
the name associated with the station, based on lookup from nyc-transit-data/turnstile-station-list
daytime_routes
string
the daytime routes associated with the station, based on lookup from nyc-transit-data/turnstile-station-list
division
string
the subway division of the station, based on lookup from nyc-transit-data/turnstile-station-list
line
string
the subway line of the station, based on lookup from nyc-transit-data/turnstile-station-list
borough
string
the single letter borough identifier for the station, based on lookup from nyc-transit-data/turnstile-station-list
structure
string
the structure type of the station, based on lookup from nyc-transit-data/turnstile-station-list
gtfs_longitude
number
the wgs84 longitude of the station, based on lookup from nyc-transit-data/turnstile-station-list
gtfs_latitude
number
the wgs84 latitude of the station, based on lookup from nyc-transit-data/turnstile-station-list
complex_id
string
the complex id. If not a complex, the station id
date
string
the calendar date
entries
integer
the sum of entires for all turnstile observation windows associated with this station/complex that ended on this calendar date
exits
integer
the sum of exits for all turnstile observation windows associated with this station/complex that ended on this calendar date
Body Preview
qri-row-numberstop_namedaytime_routesdivisionlineboroughstructuregtfs_longitudegtfs_latitudecomplex_iddateentriesexits
1Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-0158126659
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-021550614307
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-031595914500
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-0492659161
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-0571917743
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-061681014919
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-071743614765
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-081757515340
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-091755415112
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-101752915250
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-11103049816
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1274188157
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-131666614610
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-141726015130
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-151784215694
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-161737514756
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-171690515036
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1883687794
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-1970827003
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-20103589986
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-211707114786
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-221715715027
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-231748815108
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-241743414791
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-2582697832
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-2668906989
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-271661114417
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-281774315371
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-291787115906
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-301800915059
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-01-311752414967
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0191688525
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0269007224
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-031692515106
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-041765715675
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-051795915787
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-061790715396
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-071740514806
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0896229017
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-0970807324
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-101676414678
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-111774015284
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-121762715704
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-131784715420
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-141727014514
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-1587358250
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-1670697231
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-17103489650
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-181619314555
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-191673915033
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-201649814432
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-211592814069
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-2294858619
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-2370707375
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-241676514930
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-251744615347
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-261750615433
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-271787015501
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-281726214978
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-02-2991138647
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-0168527206
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-021672614589
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-031745615510
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-041747515587
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-051763415018
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-061655514934
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-0793968925
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-0869367601
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-091633214662
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-101608914641
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-111538414135
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-121370312504
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-131137610536
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1455795473
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1536323844
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1667476522
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1753355287
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1846904703
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-1938684126
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2034663687
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2117281907
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2211151278
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2318282169
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2419772271
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2517062012
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2617451938
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-2716361917
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-288721120
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-29660840
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-3013941612
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-03-3112751476
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0112761446
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0211881481
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0311571361
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-04666904
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-05563759
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0611021323
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0710641273
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0810231212
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612020-04-0910291242
Previewing 100 of 144,055 rows