About this Dataset

Highway-Rail Grade Crossing Incident Data (Form 57)

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/Form57-Source-Table/icqf-xf4w.
Organization: Department of Transportation
Last updated: 2021-05-08T19:46:02.559107
Tags: accident, form-57, grade-crossing, grade-crossing-incident, highway-rail, highway-rail-grade-crossing, highway-rail-incident, incident, incidents

Tables

Table 1

@usgov.dot_gov_highway_rail_grade_crossing_accident_data.table_1

30.88 MB
248908 rows
160 columns


CREATE TABLE table_1 (
  "railroad_code" VARCHAR,
  "railroad_name" VARCHAR,
  "report_year" BIGINT,
  "incident_number" VARCHAR,
  "incident_year" BIGINT,
  "incident_month" BIGINT,
  "other_railroad_code" VARCHAR,
  "other_railroad_name" VARCHAR,
  "other_incident_number" VARCHAR,
  "other_incident_year" DOUBLE,
  "other_incident_month" DOUBLE,
  "maintenance_railroad_code" VARCHAR,
  "maintenance_railroad_name" VARCHAR,
  "maintainance_incident_number" VARCHAR,
  "maintenance_incident_year" DOUBLE,
  "maintenance_incident_month" DOUBLE,
  "grade_crossing_id" VARCHAR,
  "date" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "am_pm" VARCHAR,
  "time" VARCHAR,
  "nearest_station" VARCHAR,
  "division" VARCHAR,
  "subdivision" VARCHAR,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "state_code" DOUBLE,
  "state_name" VARCHAR,
  "city_name" VARCHAR,
  "highway_name" VARCHAR,
  "public_private_code" VARCHAR,
  "public_private" VARCHAR,
  "highway_user_code" VARCHAR,
  "highway_user" VARCHAR,
  "estimated_vehicle_speed" DOUBLE,
  "vehicle_direction_code" VARCHAR,
  "vehicle_direction" VARCHAR,
  "highway_user_position_code" DOUBLE,
  "highway_user_position" VARCHAR,
  "equipment_involved_code" VARCHAR,
  "equipment_involved" VARCHAR,
  "railroad_car_unit_position" DOUBLE,
  "equipment_struck_code" DOUBLE,
  "equipment_struck" VARCHAR,
  "hazmat_involvement_code" DOUBLE,
  "hazmat_involvement" VARCHAR,
  "hazmat_released_by_code" DOUBLE,
  "hazmat_released_by" VARCHAR,
  "hazmat_released_name" VARCHAR,
  "hazmat_released_quantity" VARCHAR,
  "hazmat_released_measure" VARCHAR,
  "temperature" DOUBLE,
  "visibility_code" DOUBLE,
  "visibility" VARCHAR,
  "weather_condition_code" DOUBLE,
  "weather_condition" VARCHAR,
  "equipment_type_code" VARCHAR,
  "equipment_type" VARCHAR,
  "track_type_code" DOUBLE,
  "track_type" VARCHAR,
  "track_name" VARCHAR,
  "track_class" VARCHAR,
  "number_of_locomotive_units" DOUBLE,
  "number_of_cars" DOUBLE,
  "train_speed" DOUBLE,
  "estimated_recorded_speed" VARCHAR,
  "train_direction_code" VARCHAR,
  "train_direction" VARCHAR,
  "crossing_warning_expanded_code_1" DOUBLE,
  "crossing_warning_expanded_code_2" DOUBLE,
  "crossing_warning_expanded_code_3" DOUBLE,
  "crossing_warning_expanded_code_4" DOUBLE,
  "crossing_warning_expanded_code_5" DOUBLE,
  "crossing_warning_expanded_code_6" DOUBLE,
  "crossing_warning_expanded_code_7" DOUBLE,
  "crossing_warning_expanded_code_8" DOUBLE,
  "crossing_warning_expanded_code_9" VARCHAR,
  "crossing_warning_expanded_code_10" VARCHAR,
  "crossing_warning_expanded_code_11" VARCHAR,
  "crossing_warning_expanded_code_12" VARCHAR,
  "crossing_warning_expanded_1" VARCHAR,
  "crossing_warning_expanded_2" VARCHAR,
  "crossing_warning_expanded_3" VARCHAR,
  "crossing_warning_expanded_4" VARCHAR,
  "crossing_warning_expanded_5" VARCHAR,
  "crossing_warning_expanded_6" VARCHAR,
  "crossing_warning_expanded_7" VARCHAR,
  "crossing_warning_expanded_8" VARCHAR,
  "crossing_warning_expanded_9" VARCHAR,
  "crossing_warning_expanded_10" VARCHAR,
  "crossing_warning_expanded_11" VARCHAR,
  "crossing_warning_expanded_12" VARCHAR,
  "signaled_crossing_warning_code" VARCHAR,
  "signaled_crossing_warning" VARCHAR,
  "crossing_warning_explanation_code" VARCHAR,
  "crossing_warning_explanation" VARCHAR,
  "roadway_condition_code" VARCHAR
);