MTA Subway Turnstile Usage Data: 2017 by US Government | Transportation and Logistics

About this Dataset

MTA Subway Turnstile Usage Data: 2017

This retired dataset contains information on entry/exit values for individual control areas and is posted purely for archival purposes. More detailed subway ridership data is now supported through the Subway hourly dataset (https://data.ny.gov/Transportation/MTA-Subway-Hourly-Ridership-Beginning-February-202/wujg-7c2s).
Organization: State of New York
Last updated: 2020-11-12T04:00:32.790493
Tags: airtrain, airtrain-jfk, customers, fares, metrocard, new-york-city-transit, nyct, passengers, path, port-authority-trans-hudson, ridership, roosevelt-island-tramway, sir, staten-island-railway, stations, subway, subway-stations, tram, turnstiles, weekly

Tables

Table 1

@usgov.state_of_new_york_turnstile_usage_data_2017.table_1

182.63 MB
8878203 rows
11 columns


CREATE TABLE table_1 (
  "c_a" VARCHAR,
  "unit" VARCHAR,
  "scp" VARCHAR,
  "station" VARCHAR,
  "line_name" VARCHAR,
  "division" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "description" VARCHAR,
  "entries" BIGINT,
  "exits" BIGINT
);