injury_source

Lookup table for accident_injury.src_of_injury — the source object or substance that caused the injury (e.g., ladder, vehicle, chemical, machinery).
accident_code
OSHA-170 form code group.
accident_letter
Sub-letter within the code group.
accident_number
Code key (referenced by accident_injury.src_of_injury).
accident_value
Human-readable injury-source description.
load_dt
Timestamp when this row was loaded.

48 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_number ▼ accident_code accident_value accident_letter load_dt
1 SO AIRCRAFT   2018-11-09 20:56:02+00:00
2 SO AIR PRESSURE   2018-11-09 20:56:02+00:00
3 SO ANIMAL/INS/REPT/ETC.   2018-11-09 20:56:02+00:00
4 SO BOAT   2018-11-09 20:56:02+00:00
5 SO BODILY MOTION   2018-11-09 20:56:02+00:00
6 SO BOILER/PRESS VESSEL   2018-11-09 20:56:02+00:00
7 SO BOXES/BARRELS, ETC.   2018-11-09 20:56:02+00:00
8 SO BUILDINGS/STRUCTURES   2018-11-09 20:56:02+00:00
9 SO CHEM LIQUIDS/VAPORS   2018-11-09 20:56:02+00:00
10 SO CLEANING COMPOUND   2018-11-09 20:56:02+00:00
11 SO COLD (ENVIR/MECH)   2018-11-09 20:56:02+00:00
12 SO DIRT/SAND/STONE   2018-11-09 20:56:02+00:00
13 SO DRUGS/ALCOHOL   2018-11-09 20:56:02+00:00
14 SO DUST/PARTICLES/CHIPS   2018-11-09 20:56:02+00:00
15 SO ELEC APPARAT/WIRING   2018-11-09 20:56:02+00:00
16 SO FIRE/SMOKE   2018-11-09 20:56:02+00:00
17 SO FOOD   2018-11-09 20:56:02+00:00
18 SO FURNITURE/FURNISHING   2018-11-09 20:56:02+00:00
19 SO GASES   2018-11-09 20:56:02+00:00
20 SO GLASS   2018-11-09 20:56:02+00:00
21 SO HAND TOOL (POWERED)   2018-11-09 20:56:02+00:00
22 SO HAND TOOL (MANUAL)   2018-11-09 20:56:02+00:00
23 SO HEAT (ENVIR/MECH)   2018-11-09 20:56:02+00:00
24 SO HOISTING APPARATUS   2018-11-09 20:56:02+00:00
25 SO LADDER   2018-11-09 20:56:02+00:00
26 SO MACHINE   2018-11-09 20:56:02+00:00
27 SO MATERIALS HANDLG EQ.   2018-11-09 20:56:02+00:00
28 SO METAL PRODUCTS   2018-11-09 20:56:02+00:00
29 SO MOTOR VEHICLE (HWY)   2018-11-09 20:56:02+00:00
30 SO MOTOR VEHICLE(INDUS)   2018-11-09 20:56:02+00:00
31 SO MOTORCYCLE   2018-11-09 20:56:02+00:00
32 SO WIND/LIGHTNING, ETC.   2018-11-09 20:56:02+00:00
33 SO FIREARM   2018-11-09 20:56:02+00:00
34 SO PERSON   2018-11-09 20:56:02+00:00
35 SO PETROLEUM PRODUCTS   2018-11-09 20:56:02+00:00
36 SO PUMP/PRIME MOVER   2018-11-09 20:56:02+00:00
37 SO RADIATION   2018-11-09 20:56:02+00:00
38 SO TRAIN/RAILROAD EQUIP   2018-11-09 20:56:02+00:00
39 SO VEGETATION   2018-11-09 20:56:02+00:00
40 SO WASTE PRODUCTS   2018-11-09 20:56:02+00:00
41 SO WATER   2018-11-09 20:56:02+00:00
42 SO WORKING SURFACE   2018-11-09 20:56:02+00:00
43 SO OTHER   2018-11-09 20:56:02+00:00
44 SO FUME   2018-11-09 20:56:02+00:00
45 SO MISTS   2018-11-09 20:56:02+00:00
46 SO VIBRATION   2018-11-09 20:56:02+00:00
47 SO NOISE   2018-11-09 20:56:02+00:00
48 SO BIOLOGICAL AGENT   2018-11-09 20:56:02+00:00

Advanced export

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

CSV options: 

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