injury
- accident_code
- OSHA-170 form code group.
- accident_letter
- Sub-letter within the code group.
- accident_number
- Code key (referenced by accident_injury.nature_of_inj).
- accident_value
- Human-readable injury-nature description.
- load_dt
- Timestamp when this row was loaded.
22 rows
This data as json, CSV (advanced)
| accident_number ▼ | accident_code | accident_value | accident_letter | load_dt |
|---|---|---|---|---|
| 1 | IN | Amputation | 2018-11-09 20:56:00+00:00 | |
| 2 | IN | Asphyxia | 2018-11-09 20:56:00+00:00 | |
| 3 | IN | Bruise/Contus/Abras | 2018-11-09 20:56:00+00:00 | |
| 4 | IN | Burn(Chemical) | 2018-11-09 20:56:00+00:00 | |
| 5 | IN | Burn/Scald(Heat) | 2018-11-09 20:56:00+00:00 | |
| 6 | IN | Concussion | 2018-11-09 20:56:00+00:00 | |
| 7 | IN | Cut/Laceration | 2018-11-09 20:56:00+00:00 | |
| 8 | IN | Dermatitis | 2018-11-09 20:56:00+00:00 | |
| 9 | IN | Dislocation | 2018-11-09 20:56:00+00:00 | |
| 10 | IN | Electric Shock | 2018-11-09 20:56:00+00:00 | |
| 11 | IN | Foreign Body Ineye | 2018-11-09 20:56:00+00:00 | |
| 12 | IN | Fracture | 2018-11-09 20:56:00+00:00 | |
| 13 | IN | Freezing/Frost Bite | 2018-11-09 20:56:00+00:00 | |
| 14 | IN | Hearing Loss | 2018-11-09 20:56:00+00:00 | |
| 15 | IN | Heat Exhaustion | 2018-11-09 20:56:00+00:00 | |
| 16 | IN | Hernia | 2018-11-09 20:56:00+00:00 | |
| 17 | IN | Poisoning(Systemic) | 2018-11-09 20:56:00+00:00 | |
| 18 | IN | Puncture | 2018-11-09 20:56:00+00:00 | |
| 19 | IN | Radiation Effects | 2018-11-09 20:56:00+00:00 | |
| 20 | IN | Strain/Sprain | 2018-11-09 20:56:00+00:00 | |
| 21 | IN | Other | 2018-11-09 20:56:00+00:00 | |
| 22 | IN | Cancer | 2018-11-09 20:56:00+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "injury" ( [accident_code] TEXT, [accident_number] INTEGER PRIMARY KEY, [accident_value] TEXT, [accident_letter] INTEGER, [load_dt] TEXT );