About this Dataset

MTA Subway Turnstile Usage Data: 2022

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: 2023-05-12T06:44:04.761180
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_2022.table_1

130.71 MB
10,963,251 rows
10 columns

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