Injury/Illness Summary - Casualty Data (Form 55a) by US Government | Demographics and Population Studies

About this Dataset

Injury/Illness Summary - Casualty Data (Form 55a)

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/Form55a-Source-Table/kuvg-3uwp.
Organization: Department of Transportation
Last updated: 2025-01-16T20:41:21.349589
Tags: casualty, fatality, illness, injury, railroad-employee, trespasser, worker-on-duty

Tables

Table 1

@usgov.dot_gov_injury_illness_summary_casualty_data_form_55a.table_1

84.67 MB
1141554 rows
64 columns


CREATE TABLE table_1 (
  "railroad_code" VARCHAR,
  "railroad_name" VARCHAR,
  "pdf_report" VARCHAR,
  "incident_number" VARCHAR,
  "incident_year" BIGINT,
  "incident_month" BIGINT,
  "incident_day" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "state_code" DOUBLE,
  "state_name" VARCHAR,
  "type_of_person_code" VARCHAR,
  "type_of_person" VARCHAR,
  "employee_job_code" VARCHAR,
  "employee_job_description" VARCHAR,
  "age_of_person" DOUBLE,
  "positive_alcohol_tests" VARCHAR,
  "positive_drug_tests" VARCHAR,
  "injury_illness_code" VARCHAR,
  "nature_of_injury" VARCHAR,
  "location_of_injury_on_body" VARCHAR,
  "specific_location" VARCHAR,
  "injury_illness" VARCHAR,
  "physical_act_circumstances_code" VARCHAR,
  "physical_act_circumstances" VARCHAR,
  "general_location_of_person_code" VARCHAR,
  "general_location_of_person" VARCHAR,
  "on_track_equipment_code" DOUBLE,
  "on_track_equipment" VARCHAR,
  "specific_location_of_person_code" VARCHAR,
  "specific_location_of_person" VARCHAR,
  "event_code" DOUBLE,
  "event" VARCHAR,
  "tools_code" VARCHAR,
  "tools" VARCHAR,
  "injury_cause_code" VARCHAR,
  "injury_cause" VARCHAR,
  "days_away_from_work" DOUBLE,
  "days_restricted_activity" DOUBLE,
  "hazmat_exposure" VARCHAR,
  "covered_data_code" VARCHAR,
  "covered_data_reason" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "narrative" VARCHAR,
  "employee_suspension" VARCHAR,
  "district" DOUBLE,
  "fatality" VARCHAR,
  "form_57_filed" VARCHAR,
  "form_54_filed" VARCHAR,
  "class_code" VARCHAR,
  "class" VARCHAR,
  "casualty_occurrence_code" VARCHAR,
  "equipment_movement_code" VARCHAR,
  "report_key" VARCHAR,
  "reporting_railroad_company_grouping" VARCHAR,
  "reporting_railroad_smt_grouping" VARCHAR,
  "reporting_parent_railroad_code" VARCHAR,
  "reporting_parent_railroad_name" VARCHAR,
  "reporting_railroad_holding_company" VARCHAR,
  "geocode" VARCHAR,
  "incident_key" VARCHAR
);