degree_injury
- 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
Suggested facets: load_dt (date)
| 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 |
Table schema
CREATE TABLE degree_injury(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter BIGINT, load_dt VARCHAR, PRIMARY KEY(accident_number));