About this Dataset

Metropolitan Transportation Authority (MTA) Capital Dashboard Agencies Summary - All Load Dates

The dataset provides information about projects in the MTA's 5- Year Capital Programs from 2005 - 2009 to the current one. It provides quarterly updates to budgets, scopes, and schedules for planned and ongoing projects.
Organization: State of New York
Last updated: 2020-11-12T03:59:55.226274
Tags: capital-program, capital-projects, mta-capital-plan

Tables

Table 1

@usgov.state_of_new_york_metropolitan_transportation_authorit_9162bdec.table_1

4.02 MB
80,552 rows
44 columns

CREATE TABLE table_1 (
  "proj_num" VARCHAR,
  "capital_plan" VARCHAR,
  "loaddate" BIGINT,
  "plan_rev_keys" VARCHAR,
  "plan_rev_display_keys" VARCHAR,
  "agency_code" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "project" VARCHAR,
  "mega_project" VARCHAR,
  "agency_name" VARCHAR,
  "category_description" VARCHAR,
  "element_description" VARCHAR,
  "proj_description" VARCHAR,
  "scope_objective" VARCHAR,
  "phase" VARCHAR,
  "needs_code" VARCHAR,
  "original_budget" BIGINT,
  "latest_approved_budget" DOUBLE,
  "current_budget" DOUBLE,
  "original_budget_vs_current_budget" BIGINT,
  "lastest_approved_budget_vs_current_budget" DOUBLE,
  "scope_change" VARCHAR,
  "overall_scope_change" VARCHAR,
  "original_start_mm" VARCHAR,
  "original_start_yyyy" VARCHAR,
  "current_start_mm" VARCHAR,
  "current_start_yyyy" DOUBLE,
  "original_completion_mm" VARCHAR,
  "original_completion_yyyy" VARCHAR,
  "current_completion_mm" DOUBLE,
  "current_completion_yyyy" DOUBLE,
  "milestone_design_start_mm" DOUBLE,
  "milestone_design_start_yyyy" DOUBLE,
  "milestone_design_completion_mm" DOUBLE,
  "milestone_design_completion_yyyy" DOUBLE,
  "milestone_construction_start_mm" DOUBLE,
  "milestone_construction_start_yyyy" DOUBLE,
  "milestone_construction_completion_mm" DOUBLE,
  "milestone_construction_completion_yyyy" DOUBLE,
  "percentage_complete" BIGINT,
  "location_indicator" VARCHAR,
  "ada_flag" VARCHAR,
  "resiliency_flag" VARCHAR
);