Transit System Time Series

data.transportation.gov | Last Updated 6 Nov 2018

Data set containing broad modal and financial data for all agencies reporting to the NTD for report years 2014 through 2017.

Tags: transit, financial

This dataset has the following 159 columns:

Column NameAPI Column NameData TypeSample Values
5 digit NTD ID_5_digit_ntd_idtext
4 digit NTD ID_4_digit_ntd_idtext
Agencyagencytext
Reporter Typereporter_typetext
Subrecipient Typesubrecipient_typetext
Organization Typeorganization_typetext
Agency Total Fleet Vehiclesagency_total_fleet_vehiclesnumber
Primary UZA Codeprimary_uza_codenumber
Primary UZA Nameprimary_uza_nametext
Primary UZA Area SQ Milesprimary_uza_area_sq_milesnumber
Primary UZA Populationprimary_uza_populationnumber
Service Area SQ Milesservice_area_sq_milesnumber
Service Area Populationservice_area_populationnumber
Fiscal Year End Datefiscal_year_end_datecalendar_date
Yearyearnumber
Volunteer Driversvolunteer_driversnumber
Personal Vehiclespersonal_vehiclesnumber
ARartext
CBcbtext
CCcctext
CRcrtext
DRdrtext
DTdttext
FBfbtext
HRhrtext
IPiptext
JTjttext
LRlrtext
MBmbtext
MGmgtext
ORortext
PBpbtext
RBrbtext
SRsrtext
TBtbtext
TRtrtext
VPvptext
YRyrtext
Total Vehicle Operations Costtotal_vehicle_operations_costnumber
Total Vehicle Maintenance Costtotal_vehicle_maintenance_costnumber
Total Facility Maintenance Costtotal_facility_maintenance_costnumber
Total General Administration Costtotal_general_administration_costnumber
Total Operating Expensestotal_operating_expensesnumber
Total ADA Costtotal_ada_costnumber
Total Capital Expensestotal_capital_expensesnumber
Total DO Mode Farestotal_do_mode_faresnumber
Total PT Mode Farestotal_pt_mode_faresnumber
Total of Farestotal_of_faresnumber
Park and Ride Revenue (Earned Only)park_and_ride_revenue_earned_onlynumber
Other Transportation Revenue (Earned Only)other_transportation_revenue_earned_onlynumber
Auxiliary Revenue-Concessions (Earned Only)auxiliary_revenue_concessions_earned_onlynumber
Auxiliary Revenue-Advertising (Earned Only)auxiliary_revenue_advertising_earned_onlynumber
Auxiliary Revenue-Other (Earned Only)auxiliary_revenue_other_earned_onlynumber
Total Auxiliary Revenue (Earned Only, N-P)total_auxiliary_revenue_earned_only_n_pnumber
Non-Transportation Revenue (Earned Only)non_transportation_revenue_earned_onlynumber
Total Park & Ride, Other Trans., Auxiliary, & Non-Trans. Expenditures (K-S)total_park_ride_other_trans_auxiliary_non_trans_expenditures_k_stext
PT Agmt with NTD Reporter Revenuept_agmt_with_ntd_reporter_revenuenumber
PT Agmt with Non-NTD Reporter Revenuept_agmt_with_non_ntd_reporter_revenuenumber
Contributed Servicescontributed_servicesnumber
Subsidy from Other Sector Amountsubsidy_from_other_sector_amountnumber
Donations Amount (RR)donations_amount_rrnumber
Contract Revenue Amount (RR)contract_revenue_amount_rrnumber
Other Directly Generated Fundsother_directly_generated_fundsnumber
Revenue from General Fundrevenue_from_general_fundnumber
Income Taxes (Earned Only)income_taxes_earned_onlynumber
Sales Taxes (Earned Only)sales_taxes_earned_onlynumber
Property Taxes (Earned Only)property_taxes_earned_onlynumber
Gasoline Taxes (Earned Only)gasoline_taxes_earned_onlynumber
Other Taxes (Earned Only)other_taxes_earned_onlynumber
Bridge, Tunnel, and Highway Tolls (Earned Only)bridge_tunnel_and_highway_tolls_earned_onlynumber
High Occupancy Tolls (Earned Only)high_occupancy_tolls_earned_onlynumber
Other Dedicated Funds (Earned Only)other_dedicated_funds_earned_onlynumber
State/Local Other Fundsstate_local_other_fundsnumber
RR Fundsrr_fundsnumber
RR Other Fundsrr_other_fundsnumber
FTA Capital Program Funds (5309)fta_capital_program_funds_5309number
ARRA Fixed Guideway Modernization Funds (5309)arra_fixed_guideway_modernization_funds_5309number
ARRA Major Capital Investment (New Starts) Funds (5309)arra_major_capital_investment_new_starts_funds_5309number
MAP-21 State of Good Repair (5337)map_21_state_of_good_repair_5337number
MAP-21 Bus and Bus Facilities Formula (5339)map_21_bus_and_bus_facilities_formula_5339number
FTA Urbanized Area Formula (UAFP) program (5307)fta_urbanized_area_formula_uafp_program_5307number
5307 - Capital Assistance Spent On Operations (Including Maintenance)_5307_capital_assistance_spent_on_operations_including_maintenancenumber
ARRA Urbanized Area Program Funds (5307)arra_urbanized_area_program_funds_5307number
ARRA Urbanized Area Program Funds (5307) Capital assistance spent on operations (including maintenance)arra_urbanized_area_program_funds_5307_capital_assistance_spent_on_operations_including_maintenancenumber
FTA Special Needs of Elderly Individuals and Individuals with Disabilities Formula Program (5310)fta_special_needs_of_elderly_individuals_and_individuals_with_disabilities_formula_program_5310number
5310 - capital assistance spent on operations (including maintenance expenses)_5310_capital_assistance_spent_on_operations_including_maintenance_expensesnumber
FTA Other Than Urbanized Area (5311)fta_other_than_urbanized_area_5311number
FTA Other than Urbanized Area Program funds (5311) - capital assistance spent on operations (including maintenance)fta_other_than_urbanized_area_program_funds_5311_capital_assistance_spent_on_operations_including_maintenancenumber
FTA ARRA Other than Urbanized Area Program funds (5311)fta_arra_other_than_urbanized_area_program_funds_5311number
FTA ARRA other than Urbanized Area Program funds (5311) - capital assistance spent on operations (including maintenance)fta_arra_other_than_urbanized_area_program_funds_5311_capital_assistance_spent_on_operations_including_maintenancenumber
ARRA Tribal Transit funds (5311)arra_tribal_transit_funds_5311number
FTA Tribal Transit funds (5311)fta_tribal_transit_funds_5311number
FTA Job Access and Reverse Commute Formula Program (5316)fta_job_access_and_reverse_commute_formula_program_5316number
FTA New Freedom Program (5317)fta_new_freedom_program_5317number
5317 - capital assistance spent on operations (including maintenance)_5317_capital_assistance_spent_on_operations_including_maintenancenumber
FTA Metropolitan Planning (5303)fta_metropolitan_planning_5303number
FTA Clean Fuels Program (5308)fta_clean_fuels_program_5308number
FTA Transit in the Park (5320)fta_transit_in_the_park_5320number
ARRA TIGGER (Greenhouse Gas and Energy Reduction) Fundsarra_tigger_greenhouse_gas_and_energy_reduction_fundsnumber
Other FTA Fundsother_fta_fundsnumber
Other FTA funds - capital assistance spent on operations (including maintenance)other_fta_funds_capital_assistance_spent_on_operations_including_maintenancenumber
ARRA TIGER Multimodal Discretionary Fundsarra_tiger_multimodal_discretionary_fundsnumber
Funds Received from other USDOT Grant Programsfunds_received_from_other_usdot_grant_programsnumber
Other Federal Fundsother_federal_fundsnumber
Total Vehicles/Passenger Cars Available for Maximum Servicetotal_vehicles_passenger_cars_available_for_maximum_servicenumber
Total Actual Vehicle/Passenger Car Revenue Milestotal_actual_vehicle_passenger_car_revenue_milesnumber
Total Actual Vehicle/Passenger Car Revenue Hourstotal_actual_vehicle_passenger_car_revenue_hoursnumber
Total Train Revenue Milestotal_train_revenue_milesnumber
Total Train Revenue Hourstotal_train_revenue_hoursnumber
Total Unlinked Passenger Trips (UPT)total_unlinked_passenger_trips_uptnumber
Total ADA UPTtotal_ada_uptnumber
Total Passenger Milestotal_passenger_milesnumber
Total Mixed Traffic Right of Way (ROW) Directional Route Milestotal_mixed_traffic_right_of_way_row_directional_route_milesnumber
Total Directional Route Milestotal_directional_route_milesnumber
Total Hours Workedtotal_hours_workednumber
Total Employee Counttotal_employee_countnumber
Maintenance facilities Less than 200 vehiclesmaintenance_facilities_less_than_200_vehiclesnumber
Maintenance facilities Between 200 and 300 vehiclesmaintenance_facilities_between_200_and_300_vehiclesnumber
Maintenance facilities Greater than 300 vehiclesmaintenance_facilities_greater_than_300_vehiclesnumber
Heavy Maintenance Facilitiesheavy_maintenance_facilitiesnumber
Total Maintenance Facilitiestotal_maintenance_facilitiesnumber
ADA Accessible Stationsada_accessible_stationsnumber
Non-ADA Accessible Stationsnon_ada_accessible_stationsnumber
Total Stationstotal_stationsnumber
Multi-Modal Stationsmulti_modal_stationsnumber
Escalatorsescalatorsnumber
Elevatorselevatorsnumber
Total Track Milestotal_track_milesnumber
Total Crossingstotal_crossingsnumber
Total Bus Lane Milestotal_bus_lane_milesnumber
Major mechanical system failuresmajor_mechanical_system_failuresnumber
Other mechanical system failuresother_mechanical_system_failuresnumber
Total Revenue Vehicle System Failurestotal_revenue_vehicle_system_failuresnumber
Interest Expense - Funds Appliedinterest_expense_funds_appliednumber
Leases and Rentals - Funds Appliedleases_and_rentals_funds_appliednumber
Purchase Lease Agreement - Funds Appliedpurchase_lease_agreement_funds_appliednumber
Related Parties Lease Agreement - Funds Appliedrelated_parties_lease_agreement_funds_appliednumber
Depreciation - Funds Applieddepreciation_funds_appliednumber
Amortization of Intangibles - Funds Appliedamortization_of_intangibles_funds_appliednumber
Other Reconciling Items - Funds Appliedother_reconciling_items_funds_appliednumber
ADA-Related Reconciling Items - Funds Appliedada_related_reconciling_items_funds_appliednumber
Interest Expense - Funds Not Appliedinterest_expense_funds_not_appliednumber
Leases and Rentals - Funds Not Appliedleases_and_rentals_funds_not_appliednumber
Purchase Lease Agreement - Funds Not Appliedpurchase_lease_agreement_funds_not_appliednumber
Related Parties Lease Agreement - Funds Not Appliedrelated_parties_lease_agreement_funds_not_appliednumber
Depreciation - Funds Not Applieddepreciation_funds_not_appliednumber
Amortization of Intangibles - Funds Not Appliedamortization_of_intangibles_funds_not_appliednumber
Other Reconciling Items - Funds Not Appliedother_reconciling_items_funds_not_appliednumber
ADA-Related Reconciling Items - Funds Not Appliedada_related_reconciling_items_funds_not_appliednumber
Assets: Cash and Receivablesassets_cash_and_receivablesnumber
Assets: Investmentsassets_investmentsnumber
Assets: Special Fundsassets_special_fundsnumber
Other Assetsother_assetsnumber
Total Assetstotal_assetsnumber
Liabilities: Long Term Debtliabilities_long_term_debtnumber
Estimated Long-Term Pension Liabilitiesestimated_long_term_pension_liabilitiesnumber
Other Estimated Liabilitiesother_estimated_liabilitiesnumber
Other Liabilitiesother_liabilitiesnumber
Total Liabilitiestotal_liabilitiesnumber