Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
68 rows where release_duration = "000 Hours 15 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id
time_accident_began >30
date_of_accident >30
- May 2014 3
- August 2021 2
- February 2018 2
- February 2022 2
- March 1997 2
- May 2004 2
- May 2023 2
- October 1998 2
- September 2016 2
- April 1999 1
- April 2001 1
- April 2016 1
- April 2019 1
- April 2023 1
- August 1996 1
- August 2001 1
- August 2003 1
- August 2013 1
- December 2005 1
- December 2019 1
- February 2019 1
- January 2019 1
- January 2024 1
- July 1996 1
- July 1997 1
- July 2022 1
- June 1999 1
- June 2013 1
- June 2016 1
- June 2018 1
- …
release_duration 1
- 000 Hours 15 Minutes · 68 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000012871_1 | Accident 1 | 100000012871 | February 2022 | 00:00 | 000 Hours 15 Minutes | 311999 |
| 100000037747_1 | Accident 1 | 100000037747 | August 1996 | 19:30 | 000 Hours 15 Minutes | 31142 |
| 100000040635_1 | Accident 1 | 100000040635 | March 2024 | 09:30 | 000 Hours 15 Minutes | 311412 |
| 100000046363_1 | Accident 1 | 100000046363 | May 2004 | 05:00 | 000 Hours 15 Minutes | 42491 |
| 100000047184_1 | Accident 1 | 100000047184 | June 2013 | 10:10 | 000 Hours 15 Minutes | 22131 |
| 100000047601_1 | Accident 1 | 100000047601 | May 2003 | 19:00 | 000 Hours 15 Minutes | 42469 |
| 100000051926_1 | Accident 1 | 100000051926 | September 2005 | 00:10 | 000 Hours 15 Minutes | 311615 |
| 100000057323_1 | Accident 1 | 100000057323 | September 2020 | 11:30 | 000 Hours 15 Minutes | 49319 |
| 100000057902_1 | Accident 1 | 100000057902 | August 2001 | 11:30 | 000 Hours 15 Minutes | 32615 |
| 100000058331_4 | Accident 4 | 100000058331 | May 1995 | 20:40 | 000 Hours 15 Minutes | 22132 |
| 100000058616_1 | Accident 1 | 100000058616 | October 2016 | 12:20 | 000 Hours 15 Minutes | 325314 |
| 100000061522_1 | Accident 1 | 100000061522 | June 2018 | 00:06 | 000 Hours 15 Minutes | 42491 |
| 100000065378_1 | Accident 1 | 100000065378 | February 2019 | 02:30 | 000 Hours 15 Minutes | 311513 |
| 100000067376_1 | Accident 1 | 100000067376 | March 1997 | 11:30 | 000 Hours 15 Minutes | 99999 |
| 100000067606_1 | Accident 1 | 100000067606 | April 2001 | 06:00 | 000 Hours 15 Minutes | 11199 |
| 100000073154_4 | Accident 4 | 100000073154 | April 1999 | 15:45 | 000 Hours 15 Minutes | 32212 |
| 100000073154_7 | Accident 7 | 100000073154 | October 1998 | 16:00 | 000 Hours 15 Minutes | 32212 |
| 100000078596_1 | Accident 1 | 100000078596 | May 2002 | 17:27 | 000 Hours 15 Minutes | 42491 |
| 100000079489_2 | Accident 2 | 100000079489 | November 2004 | 03:29 | 000 Hours 15 Minutes | 325199 |
| 100000081458_1 | Accident 1 | 100000081458 | August 2003 | 18:30 | 000 Hours 15 Minutes | 56221 |
| 100000081537_2 | Accident 2 | 100000081537 | May 2014 | 10:30 | 000 Hours 15 Minutes | 32551 |
| 100000084703_1 | Accident 1 | 100000084703 | October 2013 | 17:15 | 000 Hours 15 Minutes | 22131 |
| 100000084981_1 | Accident 1 | 100000084981 | March 2007 | 02:00 | 000 Hours 15 Minutes | 311612 |
| 100000085828_1 | Accident 1 | 100000085828 | August 2021 | 06:00 | 000 Hours 15 Minutes | 331314 |
| 100000093533_1 | Accident 1 | 100000093533 | June 2024 | 13:25 | 000 Hours 15 Minutes | 32411 |
| 100000093864_1 | Accident 1 | 100000093864 | January 2024 | 09:15 | 000 Hours 15 Minutes | 311511 |
| 100000100026_1 | Accident 1 | 100000100026 | June 2016 | 08:30 | 000 Hours 15 Minutes | 42469 |
| 100000102364_1 | Accident 1 | 100000102364 | May 2014 | 15:30 | 000 Hours 15 Minutes | 32513 |
| 100000109508_1 | Accident 1 | 100000109508 | June 2020 | 23:05 | 000 Hours 15 Minutes | 31152 |
| 100000115029_1 | Accident 1 | 100000115029 | September 2012 | 08:12 | 000 Hours 15 Minutes | 56221 |
| 100000115412_3 | Accident 3 | 100000115412 | February 2018 | 10:15 | 000 Hours 15 Minutes | 325211 |
| 100000115412_5 | Accident 5 | 100000115412 | May 2014 | 06:00 | 000 Hours 15 Minutes | 325211 |
| 100000116581_1 | Accident 1 | 100000116581 | October 2022 | 05:15 | 000 Hours 15 Minutes | 32411 |
| 100000120451_1 | Accident 1 | 100000120451 | May 2019 | 13:00 | 000 Hours 15 Minutes | 32518 |
| 100000121879_1 | Accident 1 | 100000121879 | March 1997 | 17:15 | 000 Hours 15 Minutes | 562211 |
| 100000127711_2 | Accident 2 | 100000127711 | August 2021 | 08:00 | 000 Hours 15 Minutes | 212391 |
| 100000130994_1 | Accident 1 | 100000130994 | December 2005 | 09:00 | 000 Hours 15 Minutes | 325211 |
| 100000136131_2 | Accident 2 | 100000136131 | February 2018 | 19:00 | 000 Hours 15 Minutes | 311612 |
| 100000136131_4 | Accident 4 | 100000136131 | March 2016 | 13:30 | 000 Hours 15 Minutes | 311612 |
| 100000136523_3 | Accident 3 | 100000136523 | November 2019 | 08:06 | 000 Hours 15 Minutes | 325199 |
| 100000137283_1 | Accident 1 | 100000137283 | July 1997 | 15:20 | 000 Hours 15 Minutes | 11232 |
| 100000139183_2 | Accident 2 | 100000139183 | March 2009 | 23:20 | 000 Hours 15 Minutes | 31151 |
| 100000144417_1 | Accident 1 | 100000144417 | June 1999 | 10:30 | 000 Hours 15 Minutes | 325311 |
| 100000145559_1 | Accident 1 | 100000145559 | May 2023 | 20:00 | 000 Hours 15 Minutes | 22132 |
| 100000145844_1 | Accident 1 | 100000145844 | March 2021 | 12:40 | 000 Hours 15 Minutes | 311513 |
| 100000147824_1 | Accident 1 | 100000147824 | July 1996 | 00:30 | 000 Hours 15 Minutes | 22132 |
| 100000148057_1 | Accident 1 | 100000148057 | September 2016 | 16:46 | 000 Hours 15 Minutes | 42471 |
| 100000149715_3 | Accident 3 | 100000149715 | August 2013 | 16:00 | 000 Hours 15 Minutes | 211112 |
| 100000150882_1 | Accident 1 | 100000150882 | June 2022 | 01:20 | 000 Hours 15 Minutes | 311211 |
| 100000157126_1 | Accident 1 | 100000157126 | March 2020 | 21:00 | 000 Hours 15 Minutes | 325199 |
| 100000159366_1 | Accident 1 | 100000159366 | December 2019 | 11:10 | 000 Hours 15 Minutes | 49312 |
| 100000166955_1 | Accident 1 | 100000166955 | May 2004 | 10:05 | 000 Hours 15 Minutes | 22131 |
| 100000166955_2 | Accident 2 | 100000166955 | September 2003 | 09:00 | 000 Hours 15 Minutes | 22131 |
| 100000171128_1 | Accident 1 | 100000171128 | October 1998 | 09:50 | 000 Hours 15 Minutes | 49313 |
| 100000183071_1 | Accident 1 | 100000183071 | September 2016 | 07:40 | 000 Hours 15 Minutes | 311513 |
| 100000185694_2 | Accident 2 | 100000185694 | October 2018 | 12:15 | 000 Hours 15 Minutes | 311911 |
| 100000188888_1 | Accident 1 | 100000188888 | March 2012 | 13:05 | 000 Hours 15 Minutes | 31134 |
| 100000200935_2 | Accident 2 | 100000200935 | January 2019 | 01:00 | 000 Hours 15 Minutes | 42469 |
| 100000200953_2 | Accident 2 | 100000200953 | October 2019 | 21:00 | 000 Hours 15 Minutes | 49319 |
| 100000200953_3 | Accident 3 | 100000200953 | April 2019 | 01:30 | 000 Hours 15 Minutes | 49319 |
| 100000201462_1 | Accident 1 | 100000201462 | July 2022 | 01:05 | 000 Hours 15 Minutes | 32599 |
| 100000202121_1 | Accident 1 | 100000202121 | May 2018 | 20:20 | 000 Hours 15 Minutes | 325193 |
| 100000214886_1 | Accident 1 | 100000214886 | April 2016 | 14:30 | 000 Hours 15 Minutes | 31151 |
| 100000226659_2 | Accident 2 | 100000226659 | April 2023 | 10:15 | 000 Hours 15 Minutes | 31199 |
| 100000227248_1 | Accident 1 | 100000227248 | May 2017 | 15:00 | 000 Hours 15 Minutes | 21111 |
| 100000230886_1 | Accident 1 | 100000230886 | March 2022 | 16:50 | 000 Hours 15 Minutes | 21113 |
| 100000234007_1 | Accident 1 | 100000234007 | May 2023 | 08:30 | 000 Hours 15 Minutes | 32411 |
| 100000241623_2 | Accident 2 | 100000241623 | February 2022 | 06:45 | 000 Hours 15 Minutes | 325211 |
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)
);