Name: MTA Subway Schedules: 2025
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

MTA Subway Schedules: 2025

This dataset includes data for subway schedules, both the base schedule and the supplement schedule in effect. It includes rows for each scheduled stop on a trip.
Organization: State of New York
Last updated: 2025-07-26T18:20:01.223453
Tags: lines, new-york-city-transit, nyct, schedules, service, service-patterns, subway, subway-lines, subway-schedules

Tables

Table 1

@usgov.state_of_new_york_mta_subway_schedules_2025.table_1

377.04 MB
31524261 rows
23 columns


CREATE TABLE table_1 (
  "service_date" TIMESTAMP,
  "service_code" BIGINT,
  "train_id" VARCHAR,
  "line" VARCHAR,
  "trip_line" VARCHAR,
  "direction" VARCHAR,
  "stop_order" BIGINT,
  "gtfs_stop_id" VARCHAR,
  "arrival_time" VARCHAR,
  "departure_time" VARCHAR,
  "date_difference" BIGINT,
  "track" VARCHAR,
  "division" VARCHAR,
  "revenue_service" BIGINT,
  "timepoint" BIGINT,
  "trip_type" VARCHAR,
  "path_id" VARCHAR,
  "next_trip_type" VARCHAR,
  "next_trip_time" VARCHAR,
  "supplement_schedule_number" BIGINT,
  "schedule_file_number" BIGINT,
  "origin_gtfs_stop_id" VARCHAR,
  "destination_gtfs_stop_id" VARCHAR
);