Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
16 rows where date_of_accident = "October 2019"
This data as json, CSV (advanced)
Suggested facets: accident_id, facility_id
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000012522_1 | Accident 1 | 100000012522 | October 2019 | 02:30 | 000 Hours 30 Minutes | 21113 |
| 100000033545_3 | Accident 3 | 100000033545 | October 2019 | 11:30 | 000 Hours 10 Minutes | 32211 |
| 100000033545_4 | Accident 4 | 100000033545 | October 2019 | 18:30 | 000 Hours 05 Minutes | 32211 |
| 100000052863_1 | Accident 1 | 100000052863 | October 2019 | 09:35 | 001 Hours 56 Minutes | 311611 |
| 100000080574_2 | Accident 2 | 100000080574 | October 2019 | 01:00 | 000 Hours 20 Minutes | 331314 |
| 100000095461_1 | Accident 1 | 100000095461 | October 2019 | 08:02 | 001 Hours 44 Minutes | 311612 |
| 100000108279_1 | Accident 1 | 100000108279 | October 2019 | 11:00 | 000 Hours 10 Minutes | 49312 |
| 100000116812_1 | Accident 1 | 100000116812 | October 2019 | 20:00 | 006 Hours 30 Minutes | 32511 |
| 100000151426_1 | Accident 1 | 100000151426 | October 2019 | 23:52 | 000 Hours 26 Minutes | 32411 |
| 100000158054_3 | Accident 3 | 100000158054 | October 2019 | 19:30 | 001 Hours 45 Minutes | 331314 |
| 100000200953_1 | Accident 1 | 100000200953 | October 2019 | 17:45 | 000 Hours 20 Minutes | 49319 |
| 100000200953_2 | Accident 2 | 100000200953 | October 2019 | 21:00 | 000 Hours 15 Minutes | 49319 |
| 100000214243_1 | Accident 1 | 100000214243 | October 2019 | 10:01 | 000 Hours 09 Minutes | 311991 |
| 100000229068_1 | Accident 1 | 100000229068 | October 2019 | 01:55 | 000 Hours 01 Minutes | 32518 |
| 100000230626_3 | Accident 3 | 100000230626 | October 2019 | 13:49 | 000 Hours 07 Minutes | 325199 |
| 100000242061_2 | Accident 2 | 100000242061 | October 2019 | 19:30 | 000 Hours 01 Minutes | 311615 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE rmp_facility_accidents (
facility_accident_id TEXT PRIMARY KEY,
accident_id TEXT,
facility_id TEXT,
date_of_accident TEXT,
time_accident_began TEXT,
release_duration TEXT,
naics_code TEXT,
FOREIGN KEY (facility_id) REFERENCES rmp_facility(epa_facility_id),
FOREIGN KEY (naics_code) REFERENCES rmp_naics(naics_code)
);