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

descending

✎ View and edit SQL

accident_letter ▼	accident_code	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

Download this data

CSV · JSON

Table schema

CREATE TABLE "cost"(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter VARCHAR, load_dt VARCHAR, PRIMARY KEY(accident_letter));