About this Dataset

MTA Subway Paths: Beginning 2019

This dataset is a table of each distinct set of stations, or path, made by all normal and extra subway trips that run in service, excepting those that skipped one or more planned stops due to service disruptions.

There is a row for each subway stop made by a stop path. These rows also contain the unique id for each path, the number of stops made by the path, the distance in miles along the path, the origin and destination stations, and the order a stop is in the stop path.
Organization: State of New York
Last updated: 2024-12-27T17:44:14.290615
Tags: lines, new-york-city-transit, nyct, schedules, service, service-patterns, subway, subway-lines

Tables

Table 1

@usgov.state_of_new_york_mta_subway_paths_beginning_2019.table_1

215.25 kB
18,635 rows
12 columns

CREATE TABLE table_1 (
  "stop_path_id" VARCHAR,
  "number_of_stops" BIGINT,
  "distance" DOUBLE,
  "origin_station_id" VARCHAR,
  "destination_station_id" VARCHAR,
  "origin_station_name" VARCHAR,
  "destination_station_name" VARCHAR,
  "station_id" VARCHAR,
  "stop_order" BIGINT,
  "line" VARCHAR,
  "direction" VARCHAR,
  "station_name" VARCHAR
);