home / osha_enforcement / operator

operator

Lookup table for accident_injury.const_op and const_op_cause — the construction operation being performed when the injury occurred (e.g., trenching, welding, scaffold erection).
accident_code
OSHA-170 form code group.
accident_letter
Sub-letter within the code group.
accident_number
Code key (referenced by accident_injury.const_op / const_op_cause).
accident_value
Human-readable operation description.
load_dt
Timestamp when this row was loaded.

71 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_number ▼ accident_code accident_value accident_letter load_dt
1 OPER Backfilling and compacting   2018-11-09 20:56:02+00:00
2 OPER Bituminous concrete placement   2018-11-09 20:56:02+00:00
3 OPER Construction of playing fields, tennis courts   2018-11-09 20:56:02+00:00
4 OPER Cutting concrete pavement   2018-11-09 20:56:02+00:00
5 OPER Demolition   2018-11-09 20:56:02+00:00
6 OPER Dredging   2018-11-09 20:56:02+00:00
7 OPER Elevator, escalator installation   2018-11-09 20:56:02+00:00
8 OPER Emplacing reinforcing steel   2018-11-09 20:56:02+00:00
9 OPER Erecting structural steel   2018-11-09 20:56:02+00:00
10 OPER Erection of coffer dams, caissons   2018-11-09 20:56:02+00:00
11 OPER Excavation   2018-11-09 20:56:02+00:00
12 OPER Exterior masonry   2018-11-09 20:56:02+00:00
13 OPER Exterior cladding   2018-11-09 20:56:02+00:00
14 OPER Exterior carpentry   2018-11-09 20:56:02+00:00
15 OPER Exterior painting   2018-11-09 20:56:02+00:00
16 OPER Fencing, installing lights, signs, etc.   2018-11-09 20:56:02+00:00
17 OPER Fireproofing   2018-11-09 20:56:02+00:00
18 OPER Forming   2018-11-09 20:56:02+00:00
19 OPER Forming for piers or pylons   2018-11-09 20:56:02+00:00
20 OPER Installing interior walls, ceilings, doors   2018-11-09 20:56:02+00:00
21 OPER Installing metal siding   2018-11-09 20:56:02+00:00
22 OPER Installing windows and doors, glazing   2018-11-09 20:56:02+00:00
23 OPER Installing culverts and incidental drainage   2018-11-09 20:56:02+00:00
24 OPER Installing equipment (HVAC and other)   2018-11-09 20:56:02+00:00
25 OPER Installing plumbing, lighting fixtures   2018-11-09 20:56:02+00:00
26 OPER Installing underground plumbing conduit   2018-11-09 20:56:02+00:00
27 OPER Interior tile work (ceramic, vinyl, acoustic)   2018-11-09 20:56:02+00:00
28 OPER Interior masonry   2018-11-09 20:56:02+00:00
29 OPER Interior plumbing, ducting, electrical work   2018-11-09 20:56:02+00:00
30 OPER Interior carpentry   2018-11-09 20:56:02+00:00
31 OPER Interior painting and decorating   2018-11-09 20:56:02+00:00
32 OPER Landscaping   2018-11-09 20:56:02+00:00
33 OPER Loading dock forming and pouring   2018-11-09 20:56:02+00:00
34 OPER Paving   2018-11-09 20:56:02+00:00
35 OPER Pile driving   2018-11-09 20:56:02+00:00
36 OPER Placing bridge deck   2018-11-09 20:56:02+00:00
37 OPER Placing bridge girders and beams   2018-11-09 20:56:02+00:00
38 OPER Plastering   2018-11-09 20:56:02+00:00
39 OPER Pouring or installing floor decks   2018-11-09 20:56:02+00:00
40 OPER Pouring concrete floor at grade   2018-11-09 20:56:02+00:00
41 OPER Pouring concrete for piers, and pylons   2018-11-09 20:56:02+00:00
42 OPER Pouring concrete foundations and walls   2018-11-09 20:56:02+00:00
43 OPER Roofing   2018-11-09 20:56:02+00:00
44 OPER Seawall construction, riprap placement   2018-11-09 20:56:02+00:00
45 OPER Site clearing and grubbing   2018-11-09 20:56:02+00:00
46 OPER Site grading and rock removal   2018-11-09 20:56:02+00:00
47 OPER Stripping and curing concrete   2018-11-09 20:56:02+00:00
48 OPER Surveying   2018-11-09 20:56:02+00:00
49 OPER Swimming pool construction   2018-11-09 20:56:02+00:00
50 OPER Temporary work (buildings, facilities)   2018-11-09 20:56:02+00:00
51 OPER Traffic protection   2018-11-09 20:56:02+00:00
52 OPER Trenching, installing pipe   2018-11-09 20:56:02+00:00
53 OPER Waterproofing   2018-11-09 20:56:02+00:00
54 OPER Steel Erection Of Solid Web-Connecting   2018-11-09 20:56:02+00:00
55 OPER Steel Erection Of Solid Web-Bolting-Up/Detail Work   2018-11-09 20:56:02+00:00
56 OPER Steel Erection Of Solid Web-Welding/Burning/Grindi   2018-11-09 20:56:02+00:00
57 OPER Steel Erection Of Solid Web-Plumbing-Up   2018-11-09 20:56:02+00:00
58 OPER Steel Erection Of Solid Web-Moving Point To Point   2018-11-09 20:56:02+00:00
59 OPER Steel Erection Of Solid Web-Landing Materials (Hoi   2018-11-09 20:56:02+00:00
60 OPER Steel Erection Of Open Web Steel Joists-Connecting   2018-11-09 20:56:02+00:00
61 OPER Steel Erection Of Open Web Steel Joists-Bolting-Up   2018-11-09 20:56:02+00:00
62 OPER Steel Erection Of Open Web Steel Joists-Welding/Bu   2018-11-09 20:56:02+00:00
63 OPER Steel Erection Of Open Web Steel Joists-Plumbing-U   2018-11-09 20:56:02+00:00
64 OPER Steel Erection Of Open Web Steel Joists-Moving Poi   2018-11-09 20:56:02+00:00
65 OPER Steel Erection Of Open Web Steel Joists-Landing Ma   2018-11-09 20:56:02+00:00
66 OPER Installation Of Decking-Initial Laying Deck (Incl   2018-11-09 20:56:02+00:00
67 OPER Installation Of Decking-Final Attachment Deck (Wel   2018-11-09 20:56:02+00:00
68 OPER Installation Of Decking-Flashing Of Decking   2018-11-09 20:56:02+00:00
69 OPER Installation Of Decking-Hoisting Bundles   2018-11-09 20:56:02+00:00
70 OPER Other Activities-Installing Ornamental And Archite   2018-11-09 20:56:02+00:00
71 OPER Other Activities-Post Decking Detail Work   2018-11-09 20:56:02+00:00

Advanced export

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

CSV options:

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