cost

Lookup table for accident.project_cost — for construction accidents, the cost bracket of the construction project (e.g., under $50k, $50k-$250k, etc.).
accident_code
OSHA-170 form code group.
accident_letter
Letter key (referenced by accident.project_cost).
accident_number
Code key.
accident_value
Human-readable cost-bracket description.
load_dt
Timestamp when this row was loaded.

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

accident_letter ▼ accident_code accident_number accident_value load_dt
A COST   Under $50,000 2018-11-09 20:56:00+00:00
B COST   $50,000 to $250,000 2018-11-09 20:56:00+00:00
C COST   $250,000 to $500,000 2018-11-09 20:56:00+00:00
D COST   $500,000 to $1,000,000 2018-11-09 20:56:00+00:00
E COST   $1,000,000 to $5,000,000 2018-11-09 20:56:00+00:00
F COST   $5,000,000 to $20,000,000 2018-11-09 20:56:00+00:00
G COST   $20,000,000 and over 2018-11-09 20:56:00+00:00

Advanced export

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

CSV options: 

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