Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
29 rows where release_duration = "000 Hours 45 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id, facility_id, naics_code
date_of_accident 29
- April 2015 1
- August 1997 1
- August 2002 1
- August 2023 1
- December 1997 1
- December 2001 1
- December 2016 1
- December 2019 1
- February 2009 1
- February 2017 1
- February 2021 1
- January 2006 1
- January 2024 1
- July 2013 1
- July 2018 1
- July 2019 1
- July 2020 1
- June 2006 1
- March 2003 1
- November 2012 1
- November 2014 1
- November 2015 1
- November 2020 1
- October 1996 1
- October 2008 1
- October 2012 1
- October 2014 1
- October 2015 1
- September 2013 1
time_accident_began 27
release_duration 1
- 000 Hours 45 Minutes · 29 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000014986_1 | Accident 1 | 100000014986 | November 2012 | 08:10 | 000 Hours 45 Minutes | 42491 |
| 100000021905_1 | Accident 1 | 100000021905 | October 2012 | 15:45 | 000 Hours 45 Minutes | 42491 |
| 100000025849_1 | Accident 1 | 100000025849 | February 2021 | 10:17 | 000 Hours 45 Minutes | 326299 |
| 100000039022_1 | Accident 1 | 100000039022 | March 2003 | 20:45 | 000 Hours 45 Minutes | 32512 |
| 100000047166_1 | Accident 1 | 100000047166 | November 2015 | 06:00 | 000 Hours 45 Minutes | 42459 |
| 100000053737_1 | Accident 1 | 100000053737 | April 2015 | 10:00 | 000 Hours 45 Minutes | 111199 |
| 100000058616_2 | Accident 2 | 100000058616 | September 2013 | 03:14 | 000 Hours 45 Minutes | 325314 |
| 100000074091_1 | Accident 1 | 100000074091 | November 2014 | 15:00 | 000 Hours 45 Minutes | 31192 |
| 100000085061_1 | Accident 1 | 100000085061 | January 2024 | 01:00 | 000 Hours 45 Minutes | 32518 |
| 100000091982_1 | Accident 1 | 100000091982 | August 1997 | 05:00 | 000 Hours 45 Minutes | 42291 |
| 100000092375_1 | Accident 1 | 100000092375 | February 2017 | 19:06 | 000 Hours 45 Minutes | 22131 |
| 100000109848_1 | Accident 1 | 100000109848 | December 1997 | 16:00 | 000 Hours 45 Minutes | 49312 |
| 100000112362_1 | Accident 1 | 100000112362 | October 1996 | 13:15 | 000 Hours 45 Minutes | 31161 |
| 100000115145_1 | Accident 1 | 100000115145 | January 2006 | 03:35 | 000 Hours 45 Minutes | 311612 |
| 100000124741_1 | Accident 1 | 100000124741 | August 2002 | 10:35 | 000 Hours 45 Minutes | 22131 |
| 100000124956_1 | Accident 1 | 100000124956 | July 2019 | 03:50 | 000 Hours 45 Minutes | 311511 |
| 100000127506_3 | Accident 3 | 100000127506 | July 2018 | 12:54 | 000 Hours 45 Minutes | 325211 |
| 100000130271_1 | Accident 1 | 100000130271 | July 2020 | 09:45 | 000 Hours 45 Minutes | 11232 |
| 100000145728_1 | Accident 1 | 100000145728 | August 2023 | 05:55 | 000 Hours 45 Minutes | 49312 |
| 100000151131_1 | Accident 1 | 100000151131 | October 2008 | 19:00 | 000 Hours 45 Minutes | 311612 |
| 100000151881_2 | Accident 2 | 100000151881 | November 2020 | 10:15 | 000 Hours 45 Minutes | 49311 |
| 100000151881_4 | Accident 4 | 100000151881 | December 2019 | 06:30 | 000 Hours 45 Minutes | 49311 |
| 100000152078_1 | Accident 1 | 100000152078 | July 2013 | 06:15 | 000 Hours 45 Minutes | 311411 |
| 100000153763_1 | Accident 1 | 100000153763 | June 2006 | 07:00 | 000 Hours 45 Minutes | 31151 |
| 100000166777_1 | Accident 1 | 100000166777 | October 2015 | 10:30 | 000 Hours 45 Minutes | 311813 |
| 100000179326_1 | Accident 1 | 100000179326 | December 2001 | 20:45 | 000 Hours 45 Minutes | 311612 |
| 100000189529_6 | Accident 6 | 100000189529 | October 2014 | 04:00 | 000 Hours 45 Minutes | 31161 |
| 100000191017_1 | Accident 1 | 100000191017 | December 2016 | 07:45 | 000 Hours 45 Minutes | 311111 |
| 100000213404_2 | Accident 2 | 100000213404 | February 2009 | 05:00 | 000 Hours 45 Minutes | 311999 |
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)
);