About this Dataset

2022 - 2023 NTD Annual Data - Service (by Mode And Time Period)

This represents the Service data reported to the NTD by transit agencies to the NTD.

In versions of the data tables from before 2014, you can find data on service in the file called "Transit Operating Statistics: Service Supplied and Consumed."

If you have any other questions about this table, please contact the NTD Help Desk at NTDHelp@dot.gov.
Organization: Department of Transportation
Last updated: 2020-11-12T13:01:19.445736
Tags: service, transit

Tables

Table 1

@usgov.dot_gov_service_flat_file.table_1

1.08 MB
25,755 rows
69 columns

CREATE TABLE table_1 (
  "agency" VARCHAR,
  "ntd_id" BIGINT,
  "reporter_type" VARCHAR,
  "organization_type" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "report_year" BIGINT,
  "agency_voms" BIGINT,
  "mode" VARCHAR,
  "mode_name" VARCHAR,
  "type_of_service" VARCHAR,
  "mode_voms" DOUBLE,
  "mode_voms_questionable" VARCHAR,
  "uace_code" DOUBLE,
  "uza_name" VARCHAR,
  "uza_area_sq_miles" DOUBLE,
  "uza_population" DOUBLE,
  "service_area_sq_miles" DOUBLE,
  "service_area_population" DOUBLE,
  "time_period" VARCHAR,
  "time_service_begins" VARCHAR,
  "time_service_ends" VARCHAR,
  "actual_vehicle_passenger_car_miles" BIGINT,
  "vehicle_miles_questionable" VARCHAR,
  "actual_vehicle_passenger_car_revenue_miles" BIGINT,
  "vehicle_revenue_miles_questionable" VARCHAR,
  "actual_vehicle_passenger_deadhead_miles" BIGINT  -- Actual Vehicle/ Passenger Deadhead Miles,
  "deadhead_miles_questionable" VARCHAR,
  "scheduled_vehicle_passenger_car_revenue_miles" BIGINT,
  "scheduled_revenue_miles_questionable" VARCHAR,
  "actual_vehicles_passenger_car_hours" BIGINT  -- Actual Vehicles/ Passenger Car Hours,
  "vehicle_hours_questionable" VARCHAR,
  "actual_vehicle_passenger_car_revenue_hours" BIGINT,
  "vehicle_revenue_hours_questionable" VARCHAR,
  "actual_vehicle_passenger_car_deadhead_hours" BIGINT,
  "deadhead_hours_questionable" VARCHAR,
  "charter_service_hours" DOUBLE,
  "school_bus_hours" DOUBLE,
  "trains_in_operation" BIGINT,
  "trains_in_operation_questionable" VARCHAR,
  "train_miles" BIGINT,
  "train_miles_questionable" VARCHAR,
  "train_revenue_miles" BIGINT,
  "train_revenue_miles_questionable" VARCHAR,
  "train_deadhead_miles" DOUBLE,
  "train_hours" BIGINT,
  "train_hours_questionable" VARCHAR,
  "train_revenue_hours" BIGINT,
  "train_revenue_hours_questionable" VARCHAR,
  "train_deadhead_hours" DOUBLE,
  "unlinked_passenger_trips_upt" BIGINT  -- Unlinked Passenger Trips (UPT),
  "unlinked_passenger_trips_questionable" VARCHAR,
  "ada_upt" DOUBLE,
  "sponsored_service_upt" DOUBLE,
  "passenger_miles_traveled" BIGINT,
  "passenger_miles_questionable" VARCHAR,
  "directional_route_miles" DOUBLE,
  "directional_route_miles_questionable" VARCHAR,
  "brt_non_statutory_mixed_traffic_miles" DOUBLE,
  "mixed_traffic_right_of_way_miles" DOUBLE,
  "days_of_service_operated" DOUBLE,
  "days_not_operated_strikes" DOUBLE  -- Days Not Operated - Strikes,
  "days_not_operated_emergencies" DOUBLE  -- Days Not Operated - Emergencies,
  "average_revenue_speed" DOUBLE,
  "average_revenue_speed_questionable" VARCHAR,
  "average_passenger_trip_length_aptl" DOUBLE  -- Average Passenger Trip Length (APTL),
  "aptl_questionable" VARCHAR,
  "passengers_per_vehicle_revenue_hour" BIGINT,
  "passengers_per_hour_questionable" VARCHAR
);