Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
12 rows where date_of_accident = "September 2022"
This data as json, CSV (advanced)
Suggested facets: accident_id, naics_code
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000024289_1 | Accident 1 | 100000024289 | September 2022 | 17:55 | 000 Hours 03 Minutes | 31171 |
| 100000045373_1 | Accident 1 | 100000045373 | September 2022 | 08:00 | 000 Hours 28 Minutes | 32211 |
| 100000051677_1 | Accident 1 | 100000051677 | September 2022 | 06:50 | 000 Hours 10 Minutes | 311225 |
| 100000062905_2 | Accident 2 | 100000062905 | September 2022 | 15:15 | 000 Hours 48 Minutes | 32411 |
| 100000073868_1 | Accident 1 | 100000073868 | September 2022 | 15:00 | 000 Hours 01 Minutes | 32518 |
| 100000088683_1 | Accident 1 | 100000088683 | September 2022 | 18:15 | 002 Hours 59 Minutes | 32411 |
| 100000105726_3 | Accident 3 | 100000105726 | September 2022 | 18:40 | 003 Hours 00 Minutes | 32411 |
| 100000121496_1 | Accident 1 | 100000121496 | September 2022 | 12:15 | 008 Hours 00 Minutes | 311412 |
| 100000146781_1 | Accident 1 | 100000146781 | September 2022 | 09:10 | 000 Hours 01 Minutes | 325199 |
| 100000153193_3 | Accident 3 | 100000153193 | September 2022 | 06:25 | 000 Hours 01 Minutes | 42469 |
| 100000153834_1 | Accident 1 | 100000153834 | September 2022 | 00:35 | 035 Hours 00 Minutes | 325312 |
| 100000156154_1 | Accident 1 | 100000156154 | September 2022 | 21:00 | 006 Hours 18 Minutes | 115114 |
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)
);