project_type
- accident_code
- OSHA-170 form code group.
- accident_letter
- Letter key (referenced by accident.project_type).
- accident_number
- Code key.
- accident_value
- Human-readable project-type description.
- load_dt
- Timestamp when this row was loaded.
5 rows
Suggested facets: load_dt (date)
| accident_letter ▼ | accident_code | accident_number | accident_value | load_dt |
|---|---|---|---|---|
| A | PTYP | New project or new addition | 2018-11-09 20:56:02+00:00 | |
| B | PTYP | Alteration or rehabilitation | 2018-11-09 20:56:02+00:00 | |
| C | PTYP | Maintenance or repair | 2018-11-09 20:56:02+00:00 | |
| D | PTYP | Demolition | 2018-11-09 20:56:02+00:00 | |
| E | PTYP | Other | 2018-11-09 20:56:02+00:00 |
Table schema
CREATE TABLE project_type(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter VARCHAR, load_dt VARCHAR, PRIMARY KEY(accident_letter));