Dataset: Monthly Modal Time Series

About this Dataset

Monthly Modal Time Series

Modal Service data and Safety & Security (S&S;) public transit time series data delineated by transit/agency/mode/year/month. Includes all Full Reporters--transit agencies operating modes with more than 30 vehicles in maximum service--to the National Transit Database (NTD). This dataset will be updated monthly. The monthly ridership data is released one month after the month in which the service is provided. Records with null monthly service data reflect late reporting. The S&S; statistics provided include both Major and Non-Major Events where applicable. Events occurring in the past three months are excluded from the corresponding monthly ridership rows in this dataset while they undergo validation. This dataset is the only NTD publication in which all Major and Non-Major S&S; data are presented without any adjustment for historical continuity.
Organization: Department of Transportation
Last updated: 2020-11-12T12:37:15.744242
Tags: collisions, ridership, safety, security, service, time-series, unlinked-passenger-trips, vehicle-revenue-hours, vehicle-revenue-miles

Tables

Table 1

@usgov.dot_gov_monthly_modal_time_series.table_1

1.57 MB
170781 rows
75 columns


CREATE TABLE table_1 (
  "ntd_id" BIGINT,
  "agency" VARCHAR,
  "organization_type" VARCHAR,
  "mode" VARCHAR,
  "type_of_service" VARCHAR,
  "rail_true_false" BOOLEAN,
  "primary_uza_uace_code" DOUBLE,
  "primary_uza_name" VARCHAR,
  "primary_uza_sq_miles" DOUBLE,
  "primary_uza_population" DOUBLE,
  "service_area_sq_miles" DOUBLE,
  "service_area_population" DOUBLE,
  "year" BIGINT,
  "month" VARCHAR,
  "month_year_timestamp" BIGINT,
  "voms" DOUBLE,
  "vehicle_revenue_miles" DOUBLE,
  "vehicle_revenue_hours" DOUBLE,
  "unlinked_passenger_trips" DOUBLE,
  "collisions_with_motor_vehicle" DOUBLE,
  "collisions_with_person" DOUBLE,
  "collisions_with_fixed_object" DOUBLE,
  "collisions_with_rail_vehicle" DOUBLE,
  "collisions_with_bus_vehicle" DOUBLE,
  "collisions_with_other" DOUBLE,
  "total_collisions" DOUBLE,
  "total_derailments" DOUBLE,
  "total_fires" DOUBLE,
  "total_security_events" DOUBLE,
  "total_events_not_otherwise_classified" DOUBLE,
  "total_events" DOUBLE,
  "passenger_fatalities" DOUBLE,
  "people_waiting_or_leaving_fatalities" DOUBLE,
  "operator_fatalities" DOUBLE,
  "other_employee_fatalities" DOUBLE,
  "total_employee_fatalities" DOUBLE,
  "other_worker_fatalities" DOUBLE,
  "bicyclist_fatalities" DOUBLE,
  "pedestrian_in_crosswalk_fatalities" DOUBLE,
  "pedestrian_not_in_crosswalk_fatalities" DOUBLE,
  "pedestrian_crossing_tracks_fatalities" DOUBLE,
  "pedestrian_walking_along_tracks_fatalities" DOUBLE,
  "other_vehicle_occupant_fatalities" DOUBLE,
  "other_fatalities" DOUBLE,
  "trespasser_fatalities" DOUBLE,
  "suicide_fatalities" DOUBLE,
  "total_other_fatalities" DOUBLE,
  "total_fatalities" DOUBLE,
  "passenger_injuries" DOUBLE,
  "people_waiting_or_leaving_injuries" DOUBLE,
  "operator_injuries" DOUBLE,
  "other_employee_injuries" DOUBLE,
  "total_employee_injuries" DOUBLE,
  "other_worker_injuries" DOUBLE,
  "bicyclist_injuries" DOUBLE,
  "pedestrian_in_crosswalk_injuries" DOUBLE,
  "pedestrian_not_in_crosswalk_injuries" DOUBLE,
  "pedestrian_crossing_tracks_injuries" DOUBLE,
  "pedestrian_walking_along_tracks_injuries" DOUBLE,
  "other_vehicle_occupant_injuries" DOUBLE,
  "other_injuries" DOUBLE,
  "trespasser_injuries" DOUBLE,
  "suicide_injuries" DOUBLE,
  "total_other_injuries" DOUBLE,
  "total_injuries" DOUBLE,
  "non_major_physical_assaults_on_operators" DOUBLE,
  "non_major_non_physical_assaults_on_operators" DOUBLE,
  "non_major_physical_assaults_on_other_transit_workers" DOUBLE,
  "non_major_non_physical_assaults_on_other_transit_workers" DOUBLE,
  "major_physical_assaults_on_operators" DOUBLE,
  "major_non_physical_assaults_on_operators" DOUBLE,
  "major_physical_assaults_on_other_transit_workers" DOUBLE,
  "major_non_physical_assaults_on_other_transit_workers" DOUBLE,
  "total_assaults_on_transit_workers" DOUBLE,
  "moyr" BIGINT
);