Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
118 rows where release_duration = "000 Hours 05 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id
time_accident_began >30
date_of_accident >30
- April 2019 3
- August 2018 3
- February 2004 3
- July 2019 3
- June 2015 3
- June 2019 3
- March 2020 3
- October 2007 3
- April 2018 2
- April 2023 2
- August 2009 2
- February 2019 2
- June 2013 2
- March 2014 2
- May 2017 2
- May 2018 2
- May 2019 2
- May 2024 2
- November 2019 2
- November 2020 2
- April 1995 1
- April 2010 1
- April 2021 1
- April 2024 1
- August 1998 1
- August 2001 1
- August 2013 1
- August 2016 1
- August 2022 1
- December 1994 1
- …
release_duration 1
- 000 Hours 05 Minutes · 118 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000000768_1 | Accident 1 | 100000000768 | January 1996 | 02:15 | 000 Hours 05 Minutes | 22131 |
| 100000003738_2 | Accident 2 | 100000003738 | November 2020 | 15:55 | 000 Hours 05 Minutes | 311611 |
| 100000003792_1 | Accident 1 | 100000003792 | March 2014 | 17:30 | 000 Hours 05 Minutes | 31171 |
| 100000007191_1 | Accident 1 | 100000007191 | October 2007 | 18:30 | 000 Hours 05 Minutes | 42491 |
| 100000017698_1 | Accident 1 | 100000017698 | August 2018 | 20:15 | 000 Hours 05 Minutes | 322121 |
| 100000024252_1 | Accident 1 | 100000024252 | August 2016 | 08:30 | 000 Hours 05 Minutes | 31171 |
| 100000026795_1 | Accident 1 | 100000026795 | March 2005 | 10:15 | 000 Hours 05 Minutes | 32551 |
| 100000033395_1 | Accident 1 | 100000033395 | December 1994 | 13:48 | 000 Hours 05 Minutes | 22131 |
| 100000033395_2 | Accident 2 | 100000033395 | September 1994 | 16:00 | 000 Hours 05 Minutes | 22131 |
| 100000033545_4 | Accident 4 | 100000033545 | October 2019 | 18:30 | 000 Hours 05 Minutes | 32211 |
| 100000035678_1 | Accident 1 | 100000035678 | June 2016 | 15:01 | 000 Hours 05 Minutes | 31171 |
| 100000036301_1 | Accident 1 | 100000036301 | June 1999 | 14:00 | 000 Hours 05 Minutes | 22131 |
| 100000038853_2 | Accident 2 | 100000038853 | October 2002 | 04:00 | 000 Hours 05 Minutes | 331314 |
| 100000042937_1 | Accident 1 | 100000042937 | November 1994 | 09:05 | 000 Hours 05 Minutes | 22132 |
| 100000043099_1 | Accident 1 | 100000043099 | April 2021 | 00:15 | 000 Hours 05 Minutes | 32552 |
| 100000045257_1 | Accident 1 | 100000045257 | April 1995 | 10:00 | 000 Hours 05 Minutes | 22131 |
| 100000045989_2 | Accident 2 | 100000045989 | December 2019 | 08:30 | 000 Hours 05 Minutes | 32512 |
| 100000048183_1 | Accident 1 | 100000048183 | August 2001 | 12:45 | 000 Hours 05 Minutes | 71311 |
| 100000048986_1 | Accident 1 | 100000048986 | January 2012 | 05:51 | 000 Hours 05 Minutes | 211112 |
| 100000049734_1 | Accident 1 | 100000049734 | July 2019 | 13:00 | 000 Hours 05 Minutes | 32532 |
| 100000050491_1 | Accident 1 | 100000050491 | April 2023 | 07:40 | 000 Hours 05 Minutes | 325199 |
| 100000050605_1 | Accident 1 | 100000050605 | January 2020 | 02:00 | 000 Hours 05 Minutes | 325211 |
| 100000050605_2 | Accident 2 | 100000050605 | June 2013 | 08:00 | 000 Hours 05 Minutes | 325211 |
| 100000050605_3 | Accident 3 | 100000050605 | August 2009 | 16:10 | 000 Hours 05 Minutes | 325211 |
| 100000051409_1 | Accident 1 | 100000051409 | September 1997 | 14:20 | 000 Hours 05 Minutes | 311615 |
| 100000051819_1 | Accident 1 | 100000051819 | June 2021 | 12:00 | 000 Hours 05 Minutes | 32541 |
| 100000055138_1 | Accident 1 | 100000055138 | December 2007 | 16:28 | 000 Hours 05 Minutes | 332912 |
| 100000056217_3 | Accident 3 | 100000056217 | October 1997 | 23:20 | 000 Hours 05 Minutes | 325311 |
| 100000057323_2 | Accident 2 | 100000057323 | February 2019 | 04:00 | 000 Hours 05 Minutes | 49319 |
| 100000057537_2 | Accident 2 | 100000057537 | March 1999 | 05:30 | 000 Hours 05 Minutes | 325188 |
| 100000061997_1 | Accident 1 | 100000061997 | May 2003 | 11:00 | 000 Hours 05 Minutes | 42491 |
| 100000062647_1 | Accident 1 | 100000062647 | April 2010 | 23:30 | 000 Hours 05 Minutes | 32211 |
| 100000063441_1 | Accident 1 | 100000063441 | October 2007 | 19:00 | 000 Hours 05 Minutes | 339999 |
| 100000064351_1 | Accident 1 | 100000064351 | June 2022 | 10:30 | 000 Hours 05 Minutes | 21113 |
| 100000064397_1 | Accident 1 | 100000064397 | June 2013 | 08:00 | 000 Hours 05 Minutes | 221112 |
| 100000065378_2 | Accident 2 | 100000065378 | August 2013 | 09:15 | 000 Hours 05 Minutes | 311513 |
| 100000065822_1 | Accident 1 | 100000065822 | April 2019 | 14:00 | 000 Hours 05 Minutes | 325199 |
| 100000069515_5 | Accident 5 | 100000069515 | December 2005 | 05:50 | 000 Hours 05 Minutes | 32511 |
| 100000071646_1 | Accident 1 | 100000071646 | June 2002 | 14:50 | 000 Hours 05 Minutes | 42291 |
| 100000071762_2 | Accident 2 | 100000071762 | May 2018 | 15:00 | 000 Hours 05 Minutes | 42491 |
| 100000072155_1 | Accident 1 | 100000072155 | November 2017 | 20:49 | 000 Hours 05 Minutes | 32512 |
| 100000072609_1 | Accident 1 | 100000072609 | March 2020 | 09:00 | 000 Hours 05 Minutes | 325211 |
| 100000072609_12 | Accident 12 | 100000072609 | June 2015 | 11:45 | 000 Hours 05 Minutes | 325211 |
| 100000072609_13 | Accident 13 | 100000072609 | June 2015 | 11:45 | 000 Hours 05 Minutes | 325211 |
| 100000072609_2 | Accident 2 | 100000072609 | March 2020 | 21:02 | 000 Hours 05 Minutes | 325211 |
| 100000072609_3 | Accident 3 | 100000072609 | February 2020 | 21:01 | 000 Hours 05 Minutes | 325211 |
| 100000072609_4 | Accident 4 | 100000072609 | July 2019 | 15:35 | 000 Hours 05 Minutes | 325211 |
| 100000072609_7 | Accident 7 | 100000072609 | February 2019 | 00:02 | 000 Hours 05 Minutes | 325211 |
| 100000072609_8 | Accident 8 | 100000072609 | October 2018 | 08:15 | 000 Hours 05 Minutes | 325211 |
| 100000072912_1 | Accident 1 | 100000072912 | May 2002 | 09:45 | 000 Hours 05 Minutes | 22131 |
| 100000073868_3 | Accident 3 | 100000073868 | April 2018 | 01:30 | 000 Hours 05 Minutes | 32518 |
| 100000075508_1 | Accident 1 | 100000075508 | June 2019 | 17:30 | 000 Hours 05 Minutes | 32211 |
| 100000077034_1 | Accident 1 | 100000077034 | December 1998 | 06:00 | 000 Hours 05 Minutes | 331312 |
| 100000080119_1 | Accident 1 | 100000080119 | November 2008 | 17:30 | 000 Hours 05 Minutes | 32518 |
| 100000080299_1 | Accident 1 | 100000080299 | May 2021 | 13:00 | 000 Hours 05 Minutes | 42469 |
| 100000080574_1 | Accident 1 | 100000080574 | November 2019 | 08:00 | 000 Hours 05 Minutes | 331315 |
| 100000082938_1 | Accident 1 | 100000082938 | December 2002 | 12:40 | 000 Hours 05 Minutes | 325312 |
| 100000083517_1 | Accident 1 | 100000083517 | May 2024 | 05:30 | 000 Hours 05 Minutes | 42469 |
| 100000083642_1 | Accident 1 | 100000083642 | March 2022 | 09:42 | 000 Hours 05 Minutes | 42469 |
| 100000083973_1 | Accident 1 | 100000083973 | November 2019 | 07:20 | 000 Hours 05 Minutes | 42469 |
| 100000084473_1 | Accident 1 | 100000084473 | May 2022 | 14:45 | 000 Hours 05 Minutes | 42469 |
| 100000085631_1 | Accident 1 | 100000085631 | January 2019 | 20:00 | 000 Hours 05 Minutes | 311612 |
| 100000086989_1 | Accident 1 | 100000086989 | May 2024 | 09:00 | 000 Hours 05 Minutes | 32411 |
| 100000089316_1 | Accident 1 | 100000089316 | April 2024 | 19:30 | 000 Hours 05 Minutes | 32532 |
| 100000092918_2 | Accident 2 | 100000092918 | January 2018 | 10:00 | 000 Hours 05 Minutes | 32211 |
| 100000098985_1 | Accident 1 | 100000098985 | September 2002 | 07:00 | 000 Hours 05 Minutes | 22131 |
| 100000099555_1 | Accident 1 | 100000099555 | February 2004 | 11:00 | 000 Hours 05 Minutes | 56179 |
| 100000099555_2 | Accident 2 | 100000099555 | February 2004 | 11:15 | 000 Hours 05 Minutes | 56179 |
| 100000099877_2 | Accident 2 | 100000099877 | August 2018 | 08:57 | 000 Hours 05 Minutes | 325311 |
| 100000099902_1 | Accident 1 | 100000099902 | February 2012 | 21:45 | 000 Hours 05 Minutes | 325311 |
| 100000100623_1 | Accident 1 | 100000100623 | November 2022 | 07:15 | 000 Hours 05 Minutes | 22132 |
| 100000101846_2 | Accident 2 | 100000101846 | October 2007 | 10:30 | 000 Hours 05 Minutes | 325998 |
| 100000105478_1 | Accident 1 | 100000105478 | April 2023 | 14:30 | 000 Hours 05 Minutes | 22131 |
| 100000105717_2 | Accident 2 | 100000105717 | February 2016 | 10:37 | 000 Hours 05 Minutes | 33111 |
| 100000106789_1 | Accident 1 | 100000106789 | July 2020 | 09:00 | 000 Hours 05 Minutes | 311991 |
| 100000109269_2 | Accident 2 | 100000109269 | May 2019 | 10:25 | 000 Hours 05 Minutes | 22131 |
| 100000111425_2 | Accident 2 | 100000111425 | December 2022 | 05:00 | 000 Hours 05 Minutes | 325199 |
| 100000112273_1 | Accident 1 | 100000112273 | February 2024 | 23:55 | 000 Hours 05 Minutes | 32513 |
| 100000114547_1 | Accident 1 | 100000114547 | May 2017 | 10:47 | 000 Hours 05 Minutes | 32518 |
| 100000115172_1 | Accident 1 | 100000115172 | March 2003 | 13:00 | 000 Hours 05 Minutes | 22132 |
| 100000115412_2 | Accident 2 | 100000115412 | May 2018 | 08:10 | 000 Hours 05 Minutes | 325211 |
| 100000115412_6 | Accident 6 | 100000115412 | March 2014 | 08:00 | 000 Hours 05 Minutes | 325211 |
| 100000122404_1 | Accident 1 | 100000122404 | September 2013 | 11:15 | 000 Hours 05 Minutes | 331314 |
| 100000129693_2 | Accident 2 | 100000129693 | March 2019 | 03:30 | 000 Hours 05 Minutes | 21111 |
| 100000132581_2 | Accident 2 | 100000132581 | March 2020 | 10:00 | 000 Hours 05 Minutes | 32212 |
| 100000133875_1 | Accident 1 | 100000133875 | August 2018 | 15:15 | 000 Hours 05 Minutes | 42469 |
| 100000134507_1 | Accident 1 | 100000134507 | September 2003 | 09:00 | 000 Hours 05 Minutes | 325211 |
| 100000136131_5 | Accident 5 | 100000136131 | November 2015 | 01:15 | 000 Hours 05 Minutes | 311612 |
| 100000136131_6 | Accident 6 | 100000136131 | October 2014 | 20:30 | 000 Hours 05 Minutes | 311612 |
| 100000136168_1 | Accident 1 | 100000136168 | October 2022 | 06:50 | 000 Hours 05 Minutes | 21112 |
| 100000136168_2 | Accident 2 | 100000136168 | April 2018 | 12:00 | 000 Hours 05 Minutes | 21112 |
| 100000138825_1 | Accident 1 | 100000138825 | June 2011 | 15:15 | 000 Hours 05 Minutes | 32212 |
| 100000139405_1 | Accident 1 | 100000139405 | October 1995 | 13:05 | 000 Hours 05 Minutes | 331315 |
| 100000143114_1 | Accident 1 | 100000143114 | October 2008 | 10:30 | 000 Hours 05 Minutes | 213112 |
| 100000143249_1 | Accident 1 | 100000143249 | May 2019 | 13:30 | 000 Hours 05 Minutes | 311511 |
| 100000144426_1 | Accident 1 | 100000144426 | June 2023 | 14:05 | 000 Hours 05 Minutes | 32512 |
| 100000146585_1 | Accident 1 | 100000146585 | August 1998 | 07:00 | 000 Hours 05 Minutes | 325199 |
| 100000148137_1 | Accident 1 | 100000148137 | April 2019 | 07:45 | 000 Hours 05 Minutes | 325311 |
| 100000148146_1 | Accident 1 | 100000148146 | July 2019 | 13:00 | 000 Hours 05 Minutes | 42491 |
| 100000150034_1 | Accident 1 | 100000150034 | February 2004 | 18:35 | 000 Hours 05 Minutes | 325311 |
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)
);