home / osha_enforcement / body_part

body_part

Lookup table for accident_injury.part_of_body — which body part was injured (e.g., hand, head, back, eye).
accident_code
OSHA-170 form code group.
accident_letter
Sub-letter within the code group.
accident_number
Code key (referenced by accident_injury.part_of_body).
accident_value
Human-readable body-part description.
load_dt
Timestamp when this row was loaded.

31 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_number ▼ accident_code accident_value accident_letter load_dt
1 BD ABDOMEN   2018-11-09 20:56:00+00:00
2 BD ARM-MULT   2018-11-09 20:56:00+00:00
3 BD BACK   2018-11-09 20:56:00+00:00
4 BD BODYSYSTEM   2018-11-09 20:56:00+00:00
5 BD CHEST   2018-11-09 20:56:00+00:00
6 BD EAR(S)   2018-11-09 20:56:00+00:00
7 BD ELBOW(S)   2018-11-09 20:56:00+00:00
8 BD EYE(S)   2018-11-09 20:56:00+00:00
9 BD FACE   2018-11-09 20:56:00+00:00
10 BD FINGER(S)   2018-11-09 20:56:00+00:00
11 BD FOOT/ANKLE   2018-11-09 20:56:00+00:00
12 BD HAND(S)   2018-11-09 20:56:00+00:00
13 BD HEAD   2018-11-09 20:56:00+00:00
14 BD HIP(S)   2018-11-09 20:56:00+00:00
15 BD KNEE(S)   2018-11-09 20:56:00+00:00
16 BD LEGS   2018-11-09 20:56:00+00:00
17 BD LOWER ARM   2018-11-09 20:56:00+00:00
18 BD LOWER LEG   2018-11-09 20:56:00+00:00
19 BD MULTIPLE   2018-11-09 20:56:00+00:00
20 BD NECK   2018-11-09 20:56:00+00:00
21 BD SHOULDER   2018-11-09 20:56:00+00:00
22 BD UPPER ARM   2018-11-09 20:56:00+00:00
23 BD UPPER LEG   2018-11-09 20:56:00+00:00
24 BD WRIST(S)   2018-11-09 20:56:00+00:00
25 BD BLOOD   2018-11-09 20:56:00+00:00
26 BD KIDNEY   2018-11-09 20:56:00+00:00
27 BD LIVER   2018-11-09 20:56:00+00:00
28 BD LUNG   2018-11-09 20:56:00+00:00
29 BD NERVE SYST   2018-11-09 20:56:00+00:00
30 BD REPROD-SYS   2018-11-09 20:56:00+00:00
31 BD OTHBODYSYS   2018-11-09 20:56:00+00:00

Advanced export

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

CSV options:

CREATE TABLE "body_part" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
Powered by Datasette · Queries took 1.2ms