MDOT Performance Dashboard - Annual Data
State of Maryland
@usgov.state_of_maryland_mdot_performance_dashboard_annual_data
State of Maryland
@usgov.state_of_maryland_mdot_performance_dashboard_annual_data
Set of annual MDOT perfromance data including port, transit, bridge and highway condition, and MVA branch office wait time data.
Organization: State of Maryland
Last updated: 2020-11-10T17:24:11.371688
CREATE TABLE table_1 (
"date_for_fiscal_year" VARCHAR,
"year" VARCHAR,
"md_port_administration_total_general_cargo_tonnage_mil_e2b186b8" DOUBLE -- MD Port Administration Total General Cargo Tonnage (millions) (by Fiscal Year),
"cargo_tonnage_forecast_millions" DOUBLE -- Cargo Tonnage Forecast (millions),
"mta_core_bus_ridership_fy" DOUBLE -- MTA - Core Bus Ridership (FY),
"mta_baltimore_metro_ridership_fy" DOUBLE -- MTA - Baltimore Metro Ridership (FY),
"mta_light_rail_ridership_fy" DOUBLE -- MTA - Light Rail Ridership (FY),
"mta_mobility_paratransit_ridership_fy" DOUBLE -- MTA - Mobility Paratransit Ridership (FY),
"mta_call_a_ride_ridership_formerly_taxi_access_fy" DOUBLE -- MTA - Call A Ride Ridership (formerly Taxi Access) (FY),
"mta_marc_ridership_fy" DOUBLE -- MTA - MARC Ridership (FY),
"mta_commuter_bus_ridership_contracted_to_balt_wash_fy" DOUBLE -- MTA - Commuter Bus Ridership (Contracted To Balt & Wash) (FY),
"total_mta_ridership_fy" DOUBLE -- Total MTA Ridership (FY),
"locally_owned_transit_systems_lots_ridership_fy" DOUBLE -- Locally Owned Transit Systems (LOTS) Ridership (FY),
"washington_metropolitan_area_transit_authority_ridersh_007f8e05" DOUBLE -- Washington Metropolitan Area Transit Authority Ridership (Maryland Only) (FY),
"total_maryland_transit_ridership_mta_lots_wmata_fy" DOUBLE -- Total Maryland Transit Ridership (MTA, LOTS & WMATA) (FY),
"average_mva_branch_office_customer_wait_time_in_minutes_fy" DOUBLE -- Average MVA Branch Office Customer Wait Time (in Minutes) (FY),
"percentage_of_the_md_state_highway_administration_high_35ad035a" DOUBLE -- Percentage Of The MD State Highway Administration Highway Network In Overall Preferred Maintenance Condition (CY),
"percentage_of_state_bridges_that_are_structurally_deficient_cy" DOUBLE -- Percentage Of State Bridges That Are Structurally Deficient (CY),
"date_for_calendar_year" VARCHAR
);Anyone who has the link will be able to view this.