end_use

Lookup table for accident.const_end_use — for construction accidents, the end use of the building or facility being constructed (residential, commercial, industrial, highway, etc.).
accident_code
OSHA-170 form code group.
accident_letter
Letter key (referenced by accident.const_end_use).
accident_number
Code key.
accident_value
Human-readable end-use description.
load_dt
Timestamp when this row was loaded.

17 rows

✎ View and edit SQL

Suggested facets: load_dt (date)

accident_letter ▼ accident_code accident_number accident_value load_dt
A ENDU   Single family or duplex dwelling 2018-11-09 20:56:00+00:00
B ENDU   Multi-family dwelling 2018-11-09 20:56:00+00:00
C ENDU   Commercial building 2018-11-09 20:56:00+00:00
D ENDU   Manufacturing plant 2018-11-09 20:56:00+00:00
E ENDU   Refinery 2018-11-09 20:56:00+00:00
F ENDU   Powerplant 2018-11-09 20:56:00+00:00
G ENDU   Sewer/water treatment plant 2018-11-09 20:56:00+00:00
H ENDU   Other building 2018-11-09 20:56:00+00:00
I ENDU   Highway, road, street 2018-11-09 20:56:00+00:00
J ENDU   Bridge 2018-11-09 20:56:00+00:00
K ENDU   Tower, tank, storage elevator 2018-11-09 20:56:00+00:00
L ENDU   Shoreline development, dam, reservoir 2018-11-09 20:56:00+00:00
M ENDU   Pipeline 2018-11-09 20:56:00+00:00
N ENDU   Excavation, landfill 2018-11-09 20:56:00+00:00
O ENDU   Powerline, transmission line 2018-11-09 20:56:00+00:00
P ENDU   Other heavy construction 2018-11-09 20:56:00+00:00
Q ENDU   Contractor's yard/facility 2018-11-09 20:56:00+00:00

Download this data

CSV · JSON

Table schema 
CREATE TABLE end_use(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter VARCHAR, load_dt VARCHAR, PRIMARY KEY(accident_letter));