Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
29 rows where release_duration = "000 Hours 03 Minutes"
This data as json, CSV (advanced)
Suggested facets: accident_id, facility_id
time_accident_began 27
date_of_accident 27
- January 2020 2
- May 2024 2
- April 1997 1
- April 2020 1
- August 2002 1
- August 2007 1
- August 2014 1
- December 2022 1
- December 2023 1
- February 1997 1
- February 1999 1
- July 2000 1
- July 2018 1
- June 2000 1
- June 2015 1
- June 2018 1
- March 2019 1
- May 1994 1
- May 2000 1
- May 2021 1
- November 2015 1
- November 2018 1
- October 2016 1
- September 2005 1
- September 2012 1
- September 2022 1
- September 2023 1
release_duration 1
- 000 Hours 03 Minutes · 29 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000003505_1 | Accident 1 | 100000003505 | June 2000 | 11:49 | 000 Hours 03 Minutes | 42291 |
| 100000020577_1 | Accident 1 | 100000020577 | September 2023 | 12:20 | 000 Hours 03 Minutes | 21113 |
| 100000022977_1 | Accident 1 | 100000022977 | March 2019 | 18:45 | 000 Hours 03 Minutes | 325211 |
| 100000024289_1 | Accident 1 | 100000024289 | September 2022 | 17:55 | 000 Hours 03 Minutes | 31171 |
| 100000033395_3 | Accident 3 | 100000033395 | May 1994 | 10:17 | 000 Hours 03 Minutes | 22131 |
| 100000038853_4 | Accident 4 | 100000038853 | July 2000 | 20:45 | 000 Hours 03 Minutes | 331314 |
| 100000057323_3 | Accident 3 | 100000057323 | July 2018 | 07:15 | 000 Hours 03 Minutes | 49319 |
| 100000069294_1 | Accident 1 | 100000069294 | September 2012 | 11:30 | 000 Hours 03 Minutes | 11511 |
| 100000069515_6 | Accident 6 | 100000069515 | September 2005 | 12:49 | 000 Hours 03 Minutes | 325211 |
| 100000071762_1 | Accident 1 | 100000071762 | June 2018 | 20:00 | 000 Hours 03 Minutes | 42491 |
| 100000076026_2 | Accident 2 | 100000076026 | November 2015 | 03:37 | 000 Hours 03 Minutes | 325211 |
| 100000076339_1 | Accident 1 | 100000076339 | May 2024 | 01:00 | 000 Hours 03 Minutes | 32513 |
| 100000076865_1 | Accident 1 | 100000076865 | April 1997 | 09:35 | 000 Hours 03 Minutes | 331312 |
| 100000085061_9 | Accident 9 | 100000085061 | May 2021 | 17:45 | 000 Hours 03 Minutes | 325998 |
| 100000092222_1 | Accident 1 | 100000092222 | August 2007 | 10:50 | 000 Hours 03 Minutes | 311612 |
| 100000099403_2 | Accident 2 | 100000099403 | June 2015 | 08:15 | 000 Hours 03 Minutes | 11511 |
| 100000106556_1 | Accident 1 | 100000106556 | August 2002 | 02:30 | 000 Hours 03 Minutes | 42491 |
| 100000108554_1 | Accident 1 | 100000108554 | May 2000 | 01:10 | 000 Hours 03 Minutes | 325181 |
| 100000115412_4 | Accident 4 | 100000115412 | August 2014 | 00:30 | 000 Hours 03 Minutes | 325211 |
| 100000119187_1 | Accident 1 | 100000119187 | May 2024 | 09:10 | 000 Hours 03 Minutes | 325211 |
| 100000130707_1 | Accident 1 | 100000130707 | December 2022 | 11:50 | 000 Hours 03 Minutes | 311615 |
| 100000132527_1 | Accident 1 | 100000132527 | February 1999 | 11:00 | 000 Hours 03 Minutes | 334412 |
| 100000136523_2 | Accident 2 | 100000136523 | April 2020 | 00:00 | 000 Hours 03 Minutes | 325199 |
| 100000146683_1 | Accident 1 | 100000146683 | January 2020 | 22:30 | 000 Hours 03 Minutes | 33141 |
| 100000146683_3 | Accident 3 | 100000146683 | October 2016 | 01:00 | 000 Hours 03 Minutes | 33141 |
| 100000153415_1 | Accident 1 | 100000153415 | December 2023 | 11:20 | 000 Hours 03 Minutes | 42469 |
| 100000154129_2 | Accident 2 | 100000154129 | January 2020 | 09:30 | 000 Hours 03 Minutes | 32518 |
| 100000172225_1 | Accident 1 | 100000172225 | February 1997 | 06:00 | 000 Hours 03 Minutes | 22132 |
| 100000201701_3 | Accident 3 | 100000201701 | November 2018 | 12:20 | 000 Hours 03 Minutes | 21111 |
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)
);