About this Dataset

MTA Subway Stations

A dataset listing all subway and Staten Island Railway stations, with information on their locations, Station Master Reference Number (MRN), Complex MRN, GTFS Stop ID, the services that stop there, the type of structure the station is on or in, whether the station is in Manhattan’s Central Business District (CBD), and their ADA-accessibility status.
Organization: State of New York
Last updated: 2023-10-06T09:45:20.856411
Tags: coordinates, new-york-city-transit, nyct, sir, staten-island-railway, stations, subway, subway-stations

Tables

Table 1

@usgov.state_of_new_york_mta_subway_stations.table_1

46.09 kB
496 rows
19 columns

CREATE TABLE table_1 (
  "gtfs_stop_id" VARCHAR,
  "station_id" BIGINT,
  "complex_id" BIGINT,
  "division" VARCHAR,
  "line" VARCHAR,
  "stop_name" VARCHAR,
  "borough" VARCHAR,
  "cbd" BOOLEAN,
  "daytime_routes" VARCHAR,
  "structure" VARCHAR,
  "gtfs_latitude" DOUBLE,
  "gtfs_longitude" DOUBLE,
  "north_direction_label" VARCHAR,
  "south_direction_label" VARCHAR,
  "ada" BIGINT,
  "ada_northbound" BIGINT,
  "ada_southbound" BIGINT,
  "ada_notes" VARCHAR,
  "georeference" VARCHAR
);