Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
81 rows where release_duration = "000 Hours 30 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id
time_accident_began >30
date_of_accident >30
- February 2021 3
- March 1995 3
- January 2002 2
- January 2013 2
- June 1996 2
- May 2021 2
- November 2002 2
- April 1997 1
- April 2011 1
- April 2021 1
- August 1995 1
- August 1996 1
- August 1999 1
- August 2016 1
- August 2018 1
- December 1995 1
- December 2018 1
- December 2019 1
- December 2022 1
- February 1995 1
- February 1996 1
- February 1997 1
- February 2010 1
- February 2011 1
- February 2015 1
- February 2024 1
- January 1995 1
- January 1996 1
- January 2008 1
- January 2010 1
- …
release_duration 1
- 000 Hours 30 Minutes · 81 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000002230_1 | Accident 1 | 100000002230 | July 2018 | 03:40 | 000 Hours 30 Minutes | 32411 |
| 100000006343_1 | Accident 1 | 100000006343 | February 2011 | 14:00 | 000 Hours 30 Minutes | 42491 |
| 100000009661_1 | Accident 1 | 100000009661 | February 2021 | 14:30 | 000 Hours 30 Minutes | 311611 |
| 100000012522_1 | Accident 1 | 100000012522 | October 2019 | 02:30 | 000 Hours 30 Minutes | 21113 |
| 100000014986_2 | Accident 2 | 100000014986 | November 2011 | 11:00 | 000 Hours 30 Minutes | 42491 |
| 100000018651_2 | Accident 2 | 100000018651 | September 2001 | 03:00 | 000 Hours 30 Minutes | 22132 |
| 100000019026_1 | Accident 1 | 100000019026 | July 2000 | 01:30 | 000 Hours 30 Minutes | 42491 |
| 100000019099_1 | Accident 1 | 100000019099 | April 2011 | 14:30 | 000 Hours 30 Minutes | 11115 |
| 100000021175_2 | Accident 2 | 100000021175 | December 1995 | 09:00 | 000 Hours 30 Minutes | 22131 |
| 100000021175_3 | Accident 3 | 100000021175 | March 1995 | 09:30 | 000 Hours 30 Minutes | 22131 |
| 100000022557_1 | Accident 1 | 100000022557 | January 2024 | 07:15 | 000 Hours 30 Minutes | 339999 |
| 100000024092_1 | Accident 1 | 100000024092 | January 2002 | 13:50 | 000 Hours 30 Minutes | 32512 |
| 100000027124_1 | Accident 1 | 100000027124 | July 2019 | 18:00 | 000 Hours 30 Minutes | 22132 |
| 100000028418_1 | Accident 1 | 100000028418 | November 1995 | 10:00 | 000 Hours 30 Minutes | 22131 |
| 100000030156_1 | Accident 1 | 100000030156 | October 2012 | 21:22 | 000 Hours 30 Minutes | 42491 |
| 100000031191_1 | Accident 1 | 100000031191 | September 2017 | 18:15 | 000 Hours 30 Minutes | 49312 |
| 100000033545_2 | Accident 2 | 100000033545 | December 2022 | 08:30 | 000 Hours 30 Minutes | 32211 |
| 100000040635_2 | Accident 2 | 100000040635 | September 2023 | 00:30 | 000 Hours 30 Minutes | 311412 |
| 100000043302_1 | Accident 1 | 100000043302 | March 2019 | 15:00 | 000 Hours 30 Minutes | 33141 |
| 100000046096_2 | Accident 2 | 100000046096 | June 2019 | 16:00 | 000 Hours 30 Minutes | 311612 |
| 100000048897_1 | Accident 1 | 100000048897 | November 1998 | 08:40 | 000 Hours 30 Minutes | 331315 |
| 100000048897_10 | Accident 10 | 100000048897 | January 1995 | 01:30 | 000 Hours 30 Minutes | 331315 |
| 100000048897_2 | Accident 2 | 100000048897 | September 1998 | 16:30 | 000 Hours 30 Minutes | 331315 |
| 100000048897_3 | Accident 3 | 100000048897 | September 1997 | 10:00 | 000 Hours 30 Minutes | 331315 |
| 100000048897_4 | Accident 4 | 100000048897 | June 1996 | 14:00 | 000 Hours 30 Minutes | 331315 |
| 100000048897_5 | Accident 5 | 100000048897 | January 1996 | 15:30 | 000 Hours 30 Minutes | 331315 |
| 100000048897_6 | Accident 6 | 100000048897 | June 1995 | 08:45 | 000 Hours 30 Minutes | 331315 |
| 100000048897_7 | Accident 7 | 100000048897 | March 1995 | 21:45 | 000 Hours 30 Minutes | 331315 |
| 100000048897_8 | Accident 8 | 100000048897 | March 1995 | 17:00 | 000 Hours 30 Minutes | 331315 |
| 100000048897_9 | Accident 9 | 100000048897 | February 1995 | 09:20 | 000 Hours 30 Minutes | 331315 |
| 100000050277_1 | Accident 1 | 100000050277 | June 1996 | 09:00 | 000 Hours 30 Minutes | 42291 |
| 100000055156_2 | Accident 2 | 100000055156 | January 2022 | 12:55 | 000 Hours 30 Minutes | 221112 |
| 100000056226_1 | Accident 1 | 100000056226 | October 2004 | 04:30 | 000 Hours 30 Minutes | 49312 |
| 100000056823_1 | Accident 1 | 100000056823 | May 2014 | 12:30 | 000 Hours 30 Minutes | 42491 |
| 100000061069_1 | Accident 1 | 100000061069 | February 2024 | 14:00 | 000 Hours 30 Minutes | 32512 |
| 100000062031_1 | Accident 1 | 100000062031 | June 2013 | 20:30 | 000 Hours 30 Minutes | 11199 |
| 100000069515_2 | Accident 2 | 100000069515 | January 2008 | 19:45 | 000 Hours 30 Minutes | 325211 |
| 100000072119_1 | Accident 1 | 100000072119 | April 1997 | 16:30 | 000 Hours 30 Minutes | 42269 |
| 100000072609_5 | Accident 5 | 100000072609 | May 2019 | 04:10 | 000 Hours 30 Minutes | 325211 |
| 100000075697_1 | Accident 1 | 100000075697 | June 2023 | 13:15 | 000 Hours 30 Minutes | 42491 |
| 100000081635_1 | Accident 1 | 100000081635 | July 2020 | 20:45 | 000 Hours 30 Minutes | 22132 |
| 100000082117_1 | Accident 1 | 100000082117 | March 2000 | 20:04 | 000 Hours 30 Minutes | 22131 |
| 100000082466_1 | Accident 1 | 100000082466 | May 2021 | 21:26 | 000 Hours 30 Minutes | 311612 |
| 100000083544_1 | Accident 1 | 100000083544 | February 2015 | 19:15 | 000 Hours 30 Minutes | 325211 |
| 100000096068_1 | Accident 1 | 100000096068 | August 1999 | 09:00 | 000 Hours 30 Minutes | 32522 |
| 100000096111_2 | Accident 2 | 100000096111 | January 2010 | 14:05 | 000 Hours 30 Minutes | 42491 |
| 100000099555_3 | Accident 3 | 100000099555 | July 2003 | 08:25 | 000 Hours 30 Minutes | 56179 |
| 100000102364_2 | Accident 2 | 100000102364 | January 2013 | 06:15 | 000 Hours 30 Minutes | 32513 |
| 100000105646_1 | Accident 1 | 100000105646 | February 2010 | 12:10 | 000 Hours 30 Minutes | 42469 |
| 100000107341_2 | Accident 2 | 100000107341 | July 2007 | 06:30 | 000 Hours 30 Minutes | 42491 |
| 100000107797_1 | Accident 1 | 100000107797 | April 2021 | 08:30 | 000 Hours 30 Minutes | 22131 |
| 100000110293_5 | Accident 5 | 100000110293 | May 2017 | 15:00 | 000 Hours 30 Minutes | 327212 |
| 100000111924_1 | Accident 1 | 100000111924 | January 2013 | 09:00 | 000 Hours 30 Minutes | 22132 |
| 100000112763_2 | Accident 2 | 100000112763 | October 1995 | 12:00 | 000 Hours 30 Minutes | 31152 |
| 100000115779_2 | Accident 2 | 100000115779 | February 2021 | 03:40 | 000 Hours 30 Minutes | 32511 |
| 100000126482_1 | Accident 1 | 100000126482 | February 1997 | 08:00 | 000 Hours 30 Minutes | 56173 |
| 100000130459_2 | Accident 2 | 100000130459 | September 2016 | 06:45 | 000 Hours 30 Minutes | 32518 |
| 100000132652_1 | Accident 1 | 100000132652 | May 1995 | 19:10 | 000 Hours 30 Minutes | 22131 |
| 100000137835_1 | Accident 1 | 100000137835 | October 1994 | 11:32 | 000 Hours 30 Minutes | 325199 |
| 100000140625_1 | Accident 1 | 100000140625 | January 2014 | 10:30 | 000 Hours 30 Minutes | 42491 |
| 100000147307_1 | Accident 1 | 100000147307 | July 1995 | 11:00 | 000 Hours 30 Minutes | 32592 |
| 100000148627_1 | Accident 1 | 100000148627 | November 2002 | 06:45 | 000 Hours 30 Minutes | 42491 |
| 100000149387_5 | Accident 5 | 100000149387 | February 1996 | 12:15 | 000 Hours 30 Minutes | 32411 |
| 100000151881_3 | Accident 3 | 100000151881 | May 2020 | 00:00 | 000 Hours 30 Minutes | 49311 |
| 100000151881_5 | Accident 5 | 100000151881 | December 2019 | 14:00 | 000 Hours 30 Minutes | 49311 |
| 100000154904_1 | Accident 1 | 100000154904 | March 2013 | 22:00 | 000 Hours 30 Minutes | 311999 |
| 100000157849_2 | Accident 2 | 100000157849 | August 1995 | 00:00 | 000 Hours 30 Minutes | 22131 |
| 100000159017_1 | Accident 1 | 100000159017 | October 2002 | 20:30 | 000 Hours 30 Minutes | 325211 |
| 100000163244_1 | Accident 1 | 100000163244 | August 1996 | 16:50 | 000 Hours 30 Minutes | 211112 |
| 100000165402_1 | Accident 1 | 100000165402 | December 2018 | 09:40 | 000 Hours 30 Minutes | 22131 |
| 100000169015_2 | Accident 2 | 100000169015 | May 1999 | 17:45 | 000 Hours 30 Minutes | 311421 |
| 100000169275_1 | Accident 1 | 100000169275 | November 2023 | 22:10 | 000 Hours 30 Minutes | 11115 |
| 100000174376_1 | Accident 1 | 100000174376 | August 2018 | 14:15 | 000 Hours 30 Minutes | 49312 |
| 100000182447_1 | Accident 1 | 100000182447 | January 2002 | 04:00 | 000 Hours 30 Minutes | 42251 |
| 100000187077_1 | Accident 1 | 100000187077 | May 2021 | 01:30 | 000 Hours 30 Minutes | 311611 |
| 100000187237_3 | Accident 3 | 100000187237 | November 2002 | 21:00 | 000 Hours 30 Minutes | 311615 |
| 100000193471_2 | Accident 2 | 100000193471 | July 2009 | 15:30 | 000 Hours 30 Minutes | 32512 |
| 100000200935_4 | Accident 4 | 100000200935 | August 2016 | 17:20 | 000 Hours 30 Minutes | 42469 |
| 100000226659_4 | Accident 4 | 100000226659 | February 2021 | 08:30 | 000 Hours 30 Minutes | 31199 |
| 100000231536_3 | Accident 3 | 100000231536 | January 2018 | 00:15 | 000 Hours 30 Minutes | 32518 |
| 100000232795_1 | Accident 1 | 100000232795 | September 2020 | 06:15 | 000 Hours 30 Minutes | 325314 |
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)
);