About this Dataset

Injury/Illness Summary - Operational Data (Form 55)

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-55-Source-Table/unww-uhxd.
Organization: Department of Transportation
Last updated: 2021-05-08T19:46:55.291754
Tags: form-55, miles, operational-data, passenger-miles, safety

Tables

Table 1

@usgov.dot_gov_injury_illness_summary_operational_data.table_1

10.12 MB
384,794 rows
28 columns

CREATE TABLE table_1 (
  "railroad_code" VARCHAR,
  "railroad_name" VARCHAR,
  "report_month" BIGINT,
  "year" DOUBLE,
  "state_code" VARCHAR,
  "state_name" VARCHAR,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "freight_train_miles" DOUBLE,
  "passenger_train_miles" DOUBLE,
  "yard_switching_miles" DOUBLE,
  "other_train_miles" DOUBLE,
  "total_miles" BIGINT,
  "employee_man_hours" DOUBLE,
  "passenger_miles" DOUBLE,
  "passengers_transported" DOUBLE,
  "locomotive_train_miles" BIGINT,
  "motor_train_miles" BIGINT,
  "railroad_type" VARCHAR,
  "district" DOUBLE,
  "narrative" VARCHAR,
  "reporting_railroad_company_grouping" VARCHAR,
  "reporting_railroad_smt_grouping" VARCHAR,
  "reporting_railroad_class" VARCHAR,
  "reporting_parent_railroad_code" VARCHAR,
  "reporting_parent_railroad_name" VARCHAR,
  "reporting_railroad_holding_company" VARCHAR,
  "report_key" VARCHAR
);