Dataset: Rail Equipment Accident/Incident Data (Form 54)

About this Dataset

Rail Equipment Accident/Incident Data (Form 54)

This dataset is in a user-friendly human-readable format. To download the source dataset that contains raw data values, go here: https://data.transportation.gov/dataset/Form-54-Source-Table/aqxq-n5hy.
Organization: Department of Transportation
Last updated: 2021-04-15T18:08:09.374221
Tags: accident, form-54, rail-accident, rail-equipment, train-accident

Tables

Table 1

@usgov.dot_gov_rail_equipment_accident_incident_data.table_1

50.71 MB
221954 rows
161 columns


CREATE TABLE table_1 (
  "reporting_railroad_code" VARCHAR,
  "reporting_railroad_name" VARCHAR,
  "year" BIGINT,
  "accident_number" VARCHAR,
  "pdf_link" VARCHAR,
  "accident_year" BIGINT,
  "accident_month" BIGINT,
  "other_railroad_code" VARCHAR,
  "other_railroad_name" VARCHAR,
  "other_accident_number" VARCHAR,
  "other_accident_year" DOUBLE,
  "other_accident_month" DOUBLE,
  "maintenance_railroad_code" VARCHAR,
  "maintenance_railroad_name" VARCHAR,
  "maintenance_accident_number" VARCHAR,
  "maintenance_accident_year" DOUBLE,
  "maintenance_accident_month" DOUBLE,
  "grade_crossing_id" VARCHAR,
  "day" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "accident_type_code" DOUBLE,
  "accident_type" VARCHAR,
  "hazmat_cars" BIGINT,
  "hazmat_cars_damaged" BIGINT,
  "hazmat_released_cars" BIGINT,
  "persons_evacuated" BIGINT,
  "subdivision" VARCHAR,
  "division_code" VARCHAR,
  "division" VARCHAR,
  "station" VARCHAR,
  "milepost" VARCHAR,
  "state_code" BIGINT,
  "state_abbreviation" VARCHAR,
  "state_name" VARCHAR,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "district" BIGINT,
  "temperature" BIGINT,
  "visibility_code" DOUBLE,
  "visibility" VARCHAR,
  "weather_condition_code" DOUBLE,
  "weather_condition" VARCHAR,
  "track_type_code" VARCHAR,
  "track_type" VARCHAR,
  "track_name" VARCHAR,
  "track_class" VARCHAR,
  "track_density" VARCHAR,
  "train_direction_code" VARCHAR,
  "train_direction" VARCHAR,
  "equipment_type_code" VARCHAR,
  "equipment_type" VARCHAR,
  "equipment_attended" VARCHAR,
  "train_number" VARCHAR,
  "train_speed" DOUBLE,
  "recorded_estimated_speed" VARCHAR,
  "maximum_speed" DOUBLE,
  "gross_tonnage" BIGINT,
  "signalization_code" DOUBLE,
  "signalization" VARCHAR,
  "method_of_operation_code" VARCHAR,
  "method_of_operation" VARCHAR,
  "adjunct_code_1" VARCHAR,
  "adjunct_name_1" VARCHAR,
  "adjunct_code_2" VARCHAR,
  "adjunct_name_2" VARCHAR,
  "adjunct_code_3" VARCHAR,
  "adjunct_name_3" VARCHAR,
  "remote_control_locomotive_code" VARCHAR,
  "remote_control_locomotive" VARCHAR,
  "first_car_initials" VARCHAR,
  "first_car_number" VARCHAR,
  "first_car_position" DOUBLE,
  "first_car_loaded" VARCHAR,
  "causing_car_initials" VARCHAR,
  "causing_car_number" DOUBLE,
  "causing_car_position" DOUBLE,
  "causing_car_loaded" VARCHAR,
  "positive_alcohol_tests" DOUBLE,
  "positive_drug_tests" DOUBLE,
  "passengers_transported" VARCHAR,
  "head_end_locomotives" BIGINT,
  "mid_train_manual_locomotives" BIGINT,
  "mid_train_remote_locomotives" BIGINT,
  "rear_end_manual_locomotives" BIGINT,
  "rear_end_remote_locomotives" BIGINT,
  "derailed_head_end_locomotives" BIGINT,
  "derailed_mid_train_manual_locomotives" BIGINT,
  "derailed_mid_train_remote_locomotives" BIGINT,
  "derailed_rear_end_manual_locomotives" BIGINT,
  "derailed_rear_end_remote_locomotives" BIGINT,
  "loaded_freight_cars" BIGINT,
  "loaded_passenger_cars" BIGINT,
  "empty_freight_cars" BIGINT,
  "empty_passenger_cars" BIGINT,
  "cabooses" BIGINT,
  "derailed_loaded_freight_cars" BIGINT,
  "derailed_loaded_passenger_cars" BIGINT,
  "derailed_empty_freight_cars" BIGINT,
  "derailed_empty_passenger_cars" BIGINT
);