About this Dataset

MTA Capital Project Schedules: Beginning 2018

The MTA Capital Program is comprised of a series of five-year capital investment plans. These capital plans describe the capital investments—or projects—to which the MTA will commit funding over a specified five-year period. This dataset contains a detailed breakdown of the schedule milestones for each capital project including current and historical data.
Organization: State of New York
Last updated: 2025-10-11T19:56:55.788264
Tags: asset-conditions, bridges-tunnels, bt, bus, capital-dashboard, capital-plan, capital-plan-dashboard, capital-program, cd, construction-development, lirr, long-island-rail-road, metro-north, metro-north-railroad, mnr, mta-bridges-tunnels, mta-bus, mta-construction-development, mta-pd, mta-police, mta-police-department, mtabc, new-york-city-transit, nyct, projects, sir, staten-island-railway, subway

Tables

Table 1

@usgov.state_of_new_york_mta_capital_project_schedules_beginning_2018.table_1

15.2 kB
164 rows
12 columns

CREATE TABLE table_1 (
  "project_id" BIGINT,
  "phase" VARCHAR,
  "phase_sequence" BIGINT,
  "phase_state" VARCHAR,
  "phase_est_actual_start_date" TIMESTAMP  -- Phase Est / Actual Start Date,
  "phase_est_actual_end_date" TIMESTAMP  -- Phase Est / Actual End Date,
  "activity_title" VARCHAR,
  "activity_description" VARCHAR,
  "activity_date" TIMESTAMP,
  "activity_flag" DOUBLE,
  "url" VARCHAR,
  "update_date" TIMESTAMP
);