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

No description provided

3 commits160,218 rows14.1MBcsv
HEAD 25B4KZ5  add a title
10 months ago
Readme

nyc-transit-data/turnstile_daily_counts_2017

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

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.47 MB
160,218
6,588
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.77503612017-01-0165777311
2Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-0282537555
3Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-031622114358
4Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-041717813485
5Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-051739914924
6Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-061722014624
7Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-0790338391
8Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-0870597010
9Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-091622114095
10Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-101711014579
11Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-111745015306
12Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-121784115363
13Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-131793215193
14Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-1499408668
15Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-1579647886
16Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-161120510715
17Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-171709814901
18Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-181730715243
19Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-191772015032
20Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-201742514682
21Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-211148010182
22Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-2272997868
23Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-231586813921
24Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-241616014171
25Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-251766115155
26Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-261750215339
27Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-271743114543
28Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-28105019531
29Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-2979798177
30Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-301690314850
31Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-01-311731615270
32Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-011798115787
33Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-021811215181
34Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-031781715172
35Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-04105849377
36Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-0575377615
37Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-061716015277
38Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-071758215169
39Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-081840415481
40Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-0996749400
41Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-101756814494
42Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-111131910063
43Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-1269627557
44Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-131714814629
45Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-141793115358
46Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-151817615382
47Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-161776215228
48Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-171766714754
49Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-18109049554
50Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-1987278422
51Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-20108629698
52Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-211628614142
53Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-221673014342
54Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-231696414890
55Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-241701414536
56Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-25103899178
57Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-2677277736
58Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-271697014203
59Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-02-281760314840
60Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-011772014964
61Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-021782814435
62Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-031768914596
63Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-04102759120
64Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-0572657146
65Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-061707013582
66Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-071741614732
67Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-081800815276
68Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-091808315356
69Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-101703013902
70Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-11101199496
71Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-1273757936
72Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-131732614278
73Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-145641465
74Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-151706614197
75Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-161855615849
76Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-171881715891
77Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-18105219552
78Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-1983328414
79Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-201739415282
80Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-211792815264
81Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-221791214964
82Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-231821715357
83Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-241794515150
84Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-251138910107
85Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-2683978655
86Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-271694314782
87Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-281732914941
88Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-291819915947
89Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-301837615615
90Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-03-311724814532
91Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-01107829599
92Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-0284218510
93Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-031749815013
94Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-041769415071
95Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-051852615916
96Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-061750814956
97Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-071802614828
98Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-08114019739
99Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-0986628401
100Astoria - Ditmars BlvdN WBMTAstoriaQElevated-73.91203440.77503612017-04-101671914432
Previewing 100 of 160,218 rows