nyc-transit-data/turnstile_daily_counts_2019
   1
 132
NYC Subway Turnstile Counts - 2019
Dataset published by nyc-transit-data 

NYC Subway Turnstile Counts Data aggregated by day and station complex for the year 2019.

7 commits159,384 rows18.0MBcsv
HEAD g181EwM  update readme with details about 2-hour offset
a year ago
Readme

nyc-transit-data/turnstile_daily_counts_2019

NYC Subway Turnstile Counts Data aggregated by day and station complex for the year 2019.

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.

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 Qmf4eqGyPAC3SeesxwZtRU5VQ63fyN2kB4WpKBBMHUwvUG were built with a pipeline that had a major error, causing inaccurate numbers near the transition between weekly input files.

CSV
17.16 MB
159,384
5,851
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
integer
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.77503612019-01-0158965319
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-02144729702
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-031567412234
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-041553413489
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-0578138937
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-0666856913
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-071523111000
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-081604413083
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-091598114019
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-101603613984
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-111572314876
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-1283159236
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-1364927125
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-141496511510
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-151597014540
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-161588314894
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-171626314761
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-181517814488
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-1981429422
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-2055736415
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-2171636868
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-221443410921
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-231520713061
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-241497513939
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-251536013785
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-2685589837
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-2767407050
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-281504311814
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-291424114095
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-301517914801
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-01-311355312807
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-011470915716
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-02851010277
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-0368747787
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-041480610038
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-051566613016
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-061615713892
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-071618814531
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-081592114763
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-0988729903
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-1066677066
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-11155789688
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-121433012113
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-131607811248
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-141642012644
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-151574212291
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-1614144706
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-17059
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-1881764639
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-19133998614
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-201410111829
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-211513010507
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-221458811639
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-2313504628
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-24068
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-25142137568
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-261551611472
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-271574312269
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-02-281611111684
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-011556111495
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-0276768025
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-0364036267
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-04122507613
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-051590210714
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-061587211819
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-071596911734
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-081605012674
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-0990109417
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-1060856751
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-111583012114
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-121673914260
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-131667414498
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-141665713782
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-151628414114
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-1610794220
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-17395
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-181748612948
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-191926516549
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-201941317609
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-211896316110
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-221848116076
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-2311504596
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-24159
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-251787813158
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-261952916642
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-271960217286
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-281981617292
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-291918116502
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-301010310452
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-03-3171117406
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-011868014510
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-021964917017
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-032002116859
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-041982417305
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-051931216639
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-0611244274
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-070146
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-081847513477
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-091956017138
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612019-04-101994717193
Previewing 100 of 159,384 rows