About this Dataset

MTA Key Performance Indicators: 2008-2021

This dataset combines Key Performance Indicator data that was reported starting with the creation of the MTA Stat performance metric dashboard in 2008 through 2021. Most of the metrics in the dataset available elsewhere on the open data portal.
Organization: State of New York
Last updated: 2020-11-12T03:59:49.623659
Tags: aar, access-a-ride, accessibility, availability, bridges-tunnels, bt, bus, collisions, commuter-rail, delays, delivered-service, deployments, elevators, employees, escalators, fleet, incidents, injuries, lirr, long-island-rail-road, lost-time-accidents, lost-time-accidents-rate, mdbf, mean-distance-between-failures, metro-north, metro-north-railroad, mnr, mta-bridges-tunnels, mta-bus, mtabc, new-york-city-transit, nyct, on-time-performance, otp, outages, paratransit, performance, ramps, reliability, rolling-stock, safety, scheduled-service, service, sir, staten-island-railway, step-free-access, subway, traffic, wait-assessment, wait-time, waiting-time, wheelchairs

Tables

Table 1

@usgov.state_of_new_york_metropolitan_transportation_authorit_a64e0af7.table_1

134.15 KB
15991 rows
17 columns


CREATE TABLE table_1 (
  "indicator_sequence" BIGINT,
  "parent_sequence" BIGINT,
  "agency_name" VARCHAR,
  "indicator_name" VARCHAR,
  "description" VARCHAR,
  "category" VARCHAR,
  "frequency" VARCHAR,
  "desired_change" VARCHAR,
  "indicator_unit" VARCHAR,
  "decimal_places" BIGINT,
  "period_year" BIGINT,
  "period_month" BIGINT,
  "ytd_target" DOUBLE,
  "ytd_actual" DOUBLE,
  "monthly_target" DOUBLE,
  "monthly_actual" DOUBLE,
  "period" TIMESTAMP
);