environmental
- accident_code
- OSHA-170 form code group.
- accident_letter
- Sub-letter within the code group.
- accident_number
- Code key (referenced by accident_injury.evn_factor).
- accident_value
- Human-readable environmental-factor description.
- load_dt
- Timestamp when this row was loaded.
35 rows
Suggested facets: load_dt (date)
| accident_number ▼ | accident_code | accident_value | accident_letter | load_dt |
|---|---|---|---|---|
| 1 | EN | PINCH POINT ACTION | 2018-11-09 20:56:00+00:00 | |
| 2 | EN | CATCH POINT/PUNCTURE ACTION | 2018-11-09 20:56:00+00:00 | |
| 3 | EN | SHEAR POINT ACTION | 2018-11-09 20:56:00+00:00 | |
| 4 | EN | SQUEEZE POINT ACTION | 2018-11-09 20:56:00+00:00 | |
| 5 | EN | FLYING OBJECT ACTION | 2018-11-09 20:56:00+00:00 | |
| 6 | EN | OVERHEAD MOVING/FALLING OBJ AC | 2018-11-09 20:56:00+00:00 | |
| 7 | EN | GAS/VAPOR/MIST/FUME/SMOKE/DUST | 2018-11-09 20:56:00+00:00 | |
| 8 | EN | MATERIALS HANDLG EQUIP./METHOD | 2018-11-09 20:56:00+00:00 | |
| 9 | EN | CHEMICAL ACTION/REACTION EXPOS | 2018-11-09 20:56:00+00:00 | |
| 10 | EN | FLAMMABLE LIQ/SOLID EXPOSURE | 2018-11-09 20:56:00+00:00 | |
| 11 | EN | TEMPERATURE +/- TOLERANCE LEV. | 2018-11-09 20:56:00+00:00 | |
| 12 | EN | RADIATION CONDITION | 2018-11-09 20:56:00+00:00 | |
| 13 | EN | WORK-SURFACE/FACIL-LAYOUT COND | 2018-11-09 20:56:00+00:00 | |
| 14 | EN | ILLUMINATION | 2018-11-09 20:56:00+00:00 | |
| 15 | EN | OVERPRESSURE/UNDERPRESSURE | 2018-11-09 20:56:00+00:00 | |
| 16 | EN | SOUND LEVEL | 2018-11-09 20:56:00+00:00 | |
| 17 | EN | WEATHER, EARTHQUAKE, ETC. | 2018-11-09 20:56:00+00:00 | |
| 18 | EN | OTHER | 2018-11-09 20:56:00+00:00 | |
| 19 | ENDU | Other heavy construction | P | 2018-11-09 20:56:00+00:00 |
| 20 | ENDU | Contractor's yard/facility | Q | 2018-11-09 20:56:00+00:00 |
| 21 | ENDU | Excavation, landfill | N | 2018-11-09 20:56:00+00:00 |
| 22 | ENDU | Pipeline | M | 2018-11-09 20:56:00+00:00 |
| 23 | ENDU | Shoreline development, dam, reservoir | L | 2018-11-09 20:56:00+00:00 |
| 24 | ENDU | Tower, tank, storage elevator | K | 2018-11-09 20:56:00+00:00 |
| 25 | ENDU | Bridge | J | 2018-11-09 20:56:00+00:00 |
| 26 | ENDU | Highway, road, street | I | 2018-11-09 20:56:00+00:00 |
| 27 | ENDU | Other building | H | 2018-11-09 20:56:00+00:00 |
| 28 | ENDU | Sewer/water treatment plant | G | 2018-11-09 20:56:00+00:00 |
| 29 | ENDU | Powerplant | F | 2018-11-09 20:56:00+00:00 |
| 30 | ENDU | Refinery | E | 2018-11-09 20:56:00+00:00 |
| 31 | ENDU | Manufacturing plant | D | 2018-11-09 20:56:00+00:00 |
| 32 | ENDU | Commercial building | C | 2018-11-09 20:56:00+00:00 |
| 33 | ENDU | Multi-family dwelling | B | 2018-11-09 20:56:00+00:00 |
| 34 | ENDU | Single family or duplex dwelling | A | 2018-11-09 20:56:00+00:00 |
| 35 | ENDU | Powerline, transmission line | O | 2018-11-09 20:56:00+00:00 |
Table schema
CREATE TABLE environmental(accident_code VARCHAR, accident_number BIGINT, accident_value VARCHAR, accident_letter VARCHAR, load_dt VARCHAR, PRIMARY KEY(accident_number));