nyc-transit-data/daily_counts_2015
   0
 33
NYC Subway Turnstile Counts Data aggregated by day and station complex for the year 2015.
Dataset published by nyc-transit-data 

No description provided

3 commits159,319 rows14.1MBcsv
HEAD PWh5VjB  add title
10 months ago
Readme

nyc-transit-data/turnstile_daily_counts_2015

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

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

CSV
13.41 MB
159,319
6,675
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.77503612015-01-0170147934
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-021336712113
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-0390847892
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-0461155991
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-051637614893
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-061655014995
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-071641314575
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-081612614330
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-091630511925
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-1095658173
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-1169276899
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-121633215012
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-131724115297
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-141699315465
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-151723615275
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-161758015188
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-17105769669
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-1867977189
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-191144611052
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-201723315364
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-211748115505
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-221717414997
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-231774914579
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-2499329211
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-2583458648
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-261449013562
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-2744484096
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-281749314928
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-291788915664
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-301795315375
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-01-31104319578
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-0183758604
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-021486712649
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-031717715365
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-041800415770
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-051776515665
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-061788514992
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-071118110487
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-0879748840
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-091686415067
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-101786915430
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-111803215803
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-121753215314
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-131735714878
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-1419874005
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-1560386476
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-1697598733
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-171583514470
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-181674415371
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-191594914576
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-201546313466
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-2197929266
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-2278208047
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-231675414653
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-241721315558
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-251705215077
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-261750215652
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-271790615379
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-02-28108269877
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-0173777864
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-021717215391
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-031761815937
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-041649915592
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-051555414485
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-061815915507
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-071143310568
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-0883838915
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-091742016033
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-101810016175
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-111833116401
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-121837016237
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-131864016256
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-141072110136
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-1582658839
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-161748016001
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-171828216308
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-181801916426
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-191820616415
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-201756115571
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-211168710686
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-2283629039
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-231735415607
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-241795216180
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-251778816194
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-261789315841
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-271830615819
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-281163210415
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-2996699895
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-301749216046
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-03-311814416543
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-011805016436
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-021823215888
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-031528413582
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-0499148287
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-0568306761
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-061582714794
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-071650915555
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-081673215326
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-091667915316
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612015-04-101663914985
Previewing 100 of 159,319 rows