event_type

Lookup table for accident_injury.event_type — the kind of event that caused the injury (struck by object, fall from elevation, caught in machinery, etc.). One row per code.
accident_code
OSHA-170 form code group.
accident_letter
Sub-letter within the code group.
accident_number
Code key (referenced by accident_injury.event_type).
accident_value
Human-readable event description.
load_dt
Timestamp when this row was loaded.

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_number ▼ accident_code accident_value accident_letter load_dt
1 FT STRUCK BY   2018-11-09 20:56:00+00:00
2 FT CAUGHT IN OR BETWEEN   2018-11-09 20:56:00+00:00
3 FT BITE/STING/SCRATCH   2018-11-09 20:56:00+00:00
4 FT FALL(SAME LEVEL)   2018-11-09 20:56:00+00:00
5 FT FALL(FROM ELEVATION)   2018-11-09 20:56:00+00:00
6 FT STRUCK AGAINST   2018-11-09 20:56:00+00:00
7 FT RUBBED/ABRADED   2018-11-09 20:56:00+00:00
8 FT INHALATION   2018-11-09 20:56:00+00:00
9 FT INGESTION   2018-11-09 20:56:00+00:00
10 FT ABSORPTION   2018-11-09 20:56:00+00:00
11 FT REP. MOTION/PRESURE   2018-11-09 20:56:00+00:00
12 FT CARD-VASC/RESP FAIL.   2018-11-09 20:56:00+00:00
13 FT SHOCK   2018-11-09 20:56:00+00:00
14 FT OTHER   2018-11-09 20:56:00+00:00

Advanced export

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

CSV options: 

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