Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
311 rows where release_duration = "000 Hours 01 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id
time_accident_began >30
date_of_accident >30
- April 2019 6
- March 2019 6
- September 2023 6
- August 2023 4
- July 2023 4
- June 1997 4
- May 2017 4
- November 2020 4
- September 2017 4
- April 1998 3
- April 2007 3
- April 2016 3
- August 2017 3
- August 2018 3
- December 2019 3
- December 2021 3
- December 2022 3
- February 2021 3
- January 2018 3
- July 1997 3
- July 1998 3
- July 2019 3
- March 2022 3
- May 1996 3
- May 2002 3
- May 2018 3
- May 2022 3
- November 2013 3
- October 2017 3
- September 2022 3
- …
release_duration 1
- 000 Hours 01 Minutes · 311 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000000722_1 | Accident 1 | 100000000722 | July 1996 | 05:45 | 000 Hours 01 Minutes | 22131 |
| 100000000722_2 | Accident 2 | 100000000722 | June 1995 | 08:30 | 000 Hours 01 Minutes | 22131 |
| 100000003907_1 | Accident 1 | 100000003907 | January 2023 | 16:00 | 000 Hours 01 Minutes | 311611 |
| 100000009162_1 | Accident 1 | 100000009162 | June 2002 | 14:00 | 000 Hours 01 Minutes | 42491 |
| 100000009947_1 | Accident 1 | 100000009947 | November 2013 | 07:45 | 000 Hours 01 Minutes | 42491 |
| 100000011989_1 | Accident 1 | 100000011989 | May 2018 | 07:30 | 000 Hours 01 Minutes | 42491 |
| 100000014432_1 | Accident 1 | 100000014432 | April 1996 | 04:30 | 000 Hours 01 Minutes | 22132 |
| 100000014432_2 | Accident 2 | 100000014432 | June 1994 | 18:20 | 000 Hours 01 Minutes | 22132 |
| 100000019017_1 | Accident 1 | 100000019017 | October 2013 | 08:20 | 000 Hours 01 Minutes | 11115 |
| 100000019071_1 | Accident 1 | 100000019071 | December 2001 | 10:00 | 000 Hours 01 Minutes | 211112 |
| 100000019151_1 | Accident 1 | 100000019151 | July 2015 | 09:40 | 000 Hours 01 Minutes | 31311 |
| 100000019712_1 | Accident 1 | 100000019712 | November 1998 | 17:00 | 000 Hours 01 Minutes | 42291 |
| 100000020176_1 | Accident 1 | 100000020176 | April 1996 | 09:00 | 000 Hours 01 Minutes | 42291 |
| 100000020327_1 | Accident 1 | 100000020327 | November 2018 | 01:35 | 000 Hours 01 Minutes | 32411 |
| 100000020782_1 | Accident 1 | 100000020782 | April 2022 | 17:30 | 000 Hours 01 Minutes | 11199 |
| 100000020915_1 | Accident 1 | 100000020915 | January 2019 | 20:00 | 000 Hours 01 Minutes | 311615 |
| 100000023379_1 | Accident 1 | 100000023379 | December 1997 | 16:30 | 000 Hours 01 Minutes | 325311 |
| 100000024671_1 | Accident 1 | 100000024671 | November 2004 | 08:45 | 000 Hours 01 Minutes | 42491 |
| 100000026107_1 | Accident 1 | 100000026107 | July 2023 | 02:30 | 000 Hours 01 Minutes | 325311 |
| 100000026492_1 | Accident 1 | 100000026492 | April 2020 | 09:00 | 000 Hours 01 Minutes | 42491 |
| 100000027133_1 | Accident 1 | 100000027133 | April 2019 | 11:30 | 000 Hours 01 Minutes | 31152 |
| 100000027384_1 | Accident 1 | 100000027384 | July 2019 | 10:09 | 000 Hours 01 Minutes | 311411 |
| 100000028105_1 | Accident 1 | 100000028105 | December 2016 | 22:50 | 000 Hours 01 Minutes | 32411 |
| 100000031048_1 | Accident 1 | 100000031048 | March 2016 | 11:45 | 000 Hours 01 Minutes | 42491 |
| 100000031921_1 | Accident 1 | 100000031921 | June 1997 | 13:00 | 000 Hours 01 Minutes | 49313 |
| 100000032993_1 | Accident 1 | 100000032993 | March 2022 | 09:30 | 000 Hours 01 Minutes | 42491 |
| 100000033901_1 | Accident 1 | 100000033901 | December 1994 | 11:50 | 000 Hours 01 Minutes | 32212 |
| 100000034045_1 | Accident 1 | 100000034045 | August 2018 | 15:45 | 000 Hours 01 Minutes | 32615 |
| 100000034312_1 | Accident 1 | 100000034312 | November 2020 | 17:50 | 000 Hours 01 Minutes | 32512 |
| 100000034385_1 | Accident 1 | 100000034385 | August 1995 | 23:00 | 000 Hours 01 Minutes | 32512 |
| 100000035972_2 | Accident 2 | 100000035972 | July 2003 | 02:15 | 000 Hours 01 Minutes | 22131 |
| 100000036187_1 | Accident 1 | 100000036187 | December 2020 | 09:15 | 000 Hours 01 Minutes | 325311 |
| 100000036187_2 | Accident 2 | 100000036187 | April 2019 | 20:00 | 000 Hours 01 Minutes | 325311 |
| 100000036301_2 | Accident 2 | 100000036301 | June 1997 | 10:45 | 000 Hours 01 Minutes | 22131 |
| 100000037783_1 | Accident 1 | 100000037783 | June 2022 | 13:00 | 000 Hours 01 Minutes | 32213 |
| 100000038853_3 | Accident 3 | 100000038853 | May 2002 | 10:40 | 000 Hours 01 Minutes | 331314 |
| 100000039175_1 | Accident 1 | 100000039175 | February 2021 | 02:00 | 000 Hours 01 Minutes | 11511 |
| 100000041634_1 | Accident 1 | 100000041634 | July 2001 | 09:00 | 000 Hours 01 Minutes | 22131 |
| 100000042232_1 | Accident 1 | 100000042232 | November 1998 | 03:45 | 000 Hours 01 Minutes | 311313 |
| 100000044846_1 | Accident 1 | 100000044846 | February 2023 | 09:45 | 000 Hours 01 Minutes | 22131 |
| 100000045195_1 | Accident 1 | 100000045195 | November 2009 | 14:30 | 000 Hours 01 Minutes | 22131 |
| 100000045989_1 | Accident 1 | 100000045989 | July 2023 | 16:00 | 000 Hours 01 Minutes | 32512 |
| 100000046096_1 | Accident 1 | 100000046096 | July 2022 | 11:00 | 000 Hours 01 Minutes | 311612 |
| 100000047326_1 | Accident 1 | 100000047326 | July 1997 | 02:30 | 000 Hours 01 Minutes | 322121 |
| 100000047898_1 | Accident 1 | 100000047898 | December 2022 | 16:50 | 000 Hours 01 Minutes | 42491 |
| 100000048496_3 | Accident 3 | 100000048496 | February 1995 | 08:30 | 000 Hours 01 Minutes | 22132 |
| 100000048717_1 | Accident 1 | 100000048717 | September 1998 | 12:00 | 000 Hours 01 Minutes | 22131 |
| 100000049609_1 | Accident 1 | 100000049609 | May 2018 | 04:30 | 000 Hours 01 Minutes | 325211 |
| 100000050366_1 | Accident 1 | 100000050366 | July 2021 | 18:34 | 000 Hours 01 Minutes | 32211 |
| 100000051409_2 | Accident 2 | 100000051409 | June 1997 | 05:05 | 000 Hours 01 Minutes | 311615 |
| 100000052998_1 | Accident 1 | 100000052998 | August 2023 | 10:20 | 000 Hours 01 Minutes | 311615 |
| 100000053924_1 | Accident 1 | 100000053924 | March 2017 | 13:30 | 000 Hours 01 Minutes | 42491 |
| 100000054772_1 | Accident 1 | 100000054772 | September 2019 | 08:45 | 000 Hours 01 Minutes | 311615 |
| 100000055307_1 | Accident 1 | 100000055307 | December 2019 | 05:14 | 000 Hours 01 Minutes | 32518 |
| 100000055799_1 | Accident 1 | 100000055799 | July 2021 | 00:40 | 000 Hours 01 Minutes | 22132 |
| 100000056217_10 | Accident 10 | 100000056217 | October 1994 | 05:30 | 000 Hours 01 Minutes | 325311 |
| 100000056217_4 | Accident 4 | 100000056217 | February 1997 | 22:00 | 000 Hours 01 Minutes | 325311 |
| 100000056217_5 | Accident 5 | 100000056217 | January 1997 | 15:05 | 000 Hours 01 Minutes | 53111 |
| 100000056217_7 | Accident 7 | 100000056217 | June 1996 | 12:50 | 000 Hours 01 Minutes | 325311 |
| 100000056217_8 | Accident 8 | 100000056217 | May 1996 | 03:30 | 000 Hours 01 Minutes | 325311 |
| 100000057154_1 | Accident 1 | 100000057154 | December 2019 | 08:00 | 000 Hours 01 Minutes | 32615 |
| 100000057207_1 | Accident 1 | 100000057207 | May 2002 | 14:00 | 000 Hours 01 Minutes | 325199 |
| 100000057396_1 | Accident 1 | 100000057396 | July 2003 | 10:45 | 000 Hours 01 Minutes | 22131 |
| 100000057537_3 | Accident 3 | 100000057537 | July 1998 | 15:00 | 000 Hours 01 Minutes | 325188 |
| 100000057537_6 | Accident 6 | 100000057537 | July 1997 | 12:00 | 000 Hours 01 Minutes | 325188 |
| 100000058082_1 | Accident 1 | 100000058082 | November 2007 | 14:00 | 000 Hours 01 Minutes | 22132 |
| 100000058331_2 | Accident 2 | 100000058331 | May 1997 | 10:30 | 000 Hours 01 Minutes | 22131 |
| 100000058331_3 | Accident 3 | 100000058331 | May 1996 | 08:15 | 000 Hours 01 Minutes | 22132 |
| 100000059214_1 | Accident 1 | 100000059214 | May 2017 | 17:09 | 000 Hours 01 Minutes | 32411 |
| 100000059535_10 | Accident 10 | 100000059535 | May 1994 | 09:30 | 000 Hours 01 Minutes | 22132 |
| 100000059535_2 | Accident 2 | 100000059535 | July 1997 | 11:15 | 000 Hours 01 Minutes | 22132 |
| 100000059535_5 | Accident 5 | 100000059535 | November 1996 | 16:00 | 000 Hours 01 Minutes | 22132 |
| 100000059535_8 | Accident 8 | 100000059535 | May 1995 | 03:45 | 000 Hours 01 Minutes | 22132 |
| 100000061746_1 | Accident 1 | 100000061746 | October 2016 | 12:15 | 000 Hours 01 Minutes | 22132 |
| 100000061924_1 | Accident 1 | 100000061924 | May 2022 | 11:20 | 000 Hours 01 Minutes | 42471 |
| 100000063003_1 | Accident 1 | 100000063003 | June 2013 | 11:00 | 000 Hours 01 Minutes | 331314 |
| 100000063646_1 | Accident 1 | 100000063646 | October 2006 | 10:00 | 000 Hours 01 Minutes | 22132 |
| 100000064654_1 | Accident 1 | 100000064654 | September 1998 | 13:30 | 000 Hours 01 Minutes | 211112 |
| 100000064921_1 | Accident 1 | 100000064921 | April 2015 | 00:12 | 000 Hours 01 Minutes | 211112 |
| 100000065216_1 | Accident 1 | 100000065216 | July 2015 | 09:00 | 000 Hours 01 Minutes | 32615 |
| 100000066894_1 | Accident 1 | 100000066894 | November 2013 | 22:00 | 000 Hours 01 Minutes | 562211 |
| 100000067125_1 | Accident 1 | 100000067125 | October 1994 | 08:45 | 000 Hours 01 Minutes | 211112 |
| 100000067189_1 | Accident 1 | 100000067189 | February 2020 | 05:15 | 000 Hours 01 Minutes | 21111 |
| 100000070013_1 | Accident 1 | 100000070013 | May 1996 | 08:00 | 000 Hours 01 Minutes | 42291 |
| 100000070228_1 | Accident 1 | 100000070228 | October 2002 | 11:00 | 000 Hours 01 Minutes | 42491 |
| 100000070497_1 | Accident 1 | 100000070497 | February 2022 | 10:00 | 000 Hours 01 Minutes | 42491 |
| 100000070497_2 | Accident 2 | 100000070497 | November 2021 | 08:55 | 000 Hours 01 Minutes | 42491 |
| 100000070987_4 | Accident 4 | 100000070987 | May 2021 | 15:15 | 000 Hours 01 Minutes | 32411 |
| 100000071227_2 | Accident 2 | 100000071227 | November 1999 | 19:30 | 000 Hours 01 Minutes | 22131 |
| 100000071325_1 | Accident 1 | 100000071325 | August 2023 | 14:00 | 000 Hours 01 Minutes | 42491 |
| 100000071334_1 | Accident 1 | 100000071334 | December 2004 | 06:43 | 000 Hours 01 Minutes | 32532 |
| 100000072315_1 | Accident 1 | 100000072315 | April 1999 | 14:45 | 000 Hours 01 Minutes | 22132 |
| 100000072609_11 | Accident 11 | 100000072609 | November 2016 | 02:00 | 000 Hours 01 Minutes | 325211 |
| 100000073065_1 | Accident 1 | 100000073065 | September 2003 | 11:30 | 000 Hours 01 Minutes | 331112 |
| 100000073528_1 | Accident 1 | 100000073528 | November 2015 | 08:00 | 000 Hours 01 Minutes | 42491 |
| 100000073868_1 | Accident 1 | 100000073868 | September 2022 | 15:00 | 000 Hours 01 Minutes | 32518 |
| 100000073948_1 | Accident 1 | 100000073948 | March 2019 | 16:00 | 000 Hours 01 Minutes | 32532 |
| 100000074091_2 | Accident 2 | 100000074091 | August 2011 | 15:40 | 000 Hours 01 Minutes | 31192 |
| 100000074439_1 | Accident 1 | 100000074439 | October 2020 | 09:00 | 000 Hours 01 Minutes | 32518 |
| 100000074475_1 | Accident 1 | 100000074475 | December 2018 | 12:40 | 000 Hours 01 Minutes | 32599 |
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)
);