degree_injury

Lookup table for accident_injury.degree_of_inj — the severity of the injury (fatality, hospitalized, non-hospitalized lost-time, first aid, etc.).
accident_code
OSHA-170 form code group.
accident_letter
Sub-letter within the code group.
accident_number
Code key (referenced by accident_injury.degree_of_inj).
accident_value
Human-readable severity description.
load_dt
Timestamp when this row was loaded.

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_number ▼ accident_code accident_value accident_letter load_dt
1 DEGR Fatality   2018-11-09 20:56:00+00:00
2 DEGR Hospitalized injury   2018-11-09 20:56:00+00:00
3 DEGR Non Hospitalized injury   2018-11-09 20:56:00+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "degree_injury" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);