Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
22 rows where release_duration = "003 Hours 00 Minutes"
This data as json, CSV (advanced)
Suggested facets: facility_id, naics_code
date_of_accident 22
- April 1997 1
- April 2009 1
- April 2011 1
- April 2015 1
- April 2017 1
- April 2020 1
- February 2019 1
- February 2021 1
- January 2003 1
- January 2017 1
- January 2023 1
- June 2019 1
- March 1999 1
- May 1997 1
- May 2005 1
- May 2024 1
- November 2022 1
- October 1995 1
- October 2015 1
- October 2018 1
- September 2016 1
- September 2022 1
time_accident_began 21
release_duration 1
- 003 Hours 00 Minutes · 22 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000022922_2 | Accident 2 | 100000022922 | May 1997 | 14:00 | 003 Hours 00 Minutes | 325188 |
| 100000046915_2 | Accident 2 | 100000046915 | May 2005 | 15:00 | 003 Hours 00 Minutes | 32211 |
| 100000048254_1 | Accident 1 | 100000048254 | April 2015 | 18:30 | 003 Hours 00 Minutes | 42459 |
| 100000049734_2 | Accident 2 | 100000049734 | September 2016 | 14:30 | 003 Hours 00 Minutes | 32532 |
| 100000059651_2 | Accident 2 | 100000059651 | April 1997 | 23:30 | 003 Hours 00 Minutes | 32211 |
| 100000061452_1 | Accident 1 | 100000061452 | April 2011 | 08:30 | 003 Hours 00 Minutes | 42491 |
| 100000075508_2 | Accident 2 | 100000075508 | February 2019 | 23:00 | 003 Hours 00 Minutes | 32211 |
| 100000091571_1 | Accident 1 | 100000091571 | October 2018 | 06:30 | 003 Hours 00 Minutes | 42491 |
| 100000097824_1 | Accident 1 | 100000097824 | October 2015 | 07:25 | 003 Hours 00 Minutes | 32518 |
| 100000105726_3 | Accident 3 | 100000105726 | September 2022 | 18:40 | 003 Hours 00 Minutes | 32411 |
| 100000111425_1 | Accident 1 | 100000111425 | January 2023 | 16:30 | 003 Hours 00 Minutes | 325199 |
| 100000113058_2 | Accident 2 | 100000113058 | January 2003 | 04:45 | 003 Hours 00 Minutes | 31211 |
| 100000144658_1 | Accident 1 | 100000144658 | March 1999 | 08:30 | 003 Hours 00 Minutes | 22132 |
| 100000151444_1 | Accident 1 | 100000151444 | June 2019 | 02:00 | 003 Hours 00 Minutes | 325211 |
| 100000151444_4 | Accident 4 | 100000151444 | January 2017 | 05:45 | 003 Hours 00 Minutes | 325211 |
| 100000158116_1 | Accident 1 | 100000158116 | October 1995 | 21:30 | 003 Hours 00 Minutes | 11131 |
| 100000172181_1 | Accident 1 | 100000172181 | February 2021 | 22:20 | 003 Hours 00 Minutes | 22131 |
| 100000175464_1 | Accident 1 | 100000175464 | April 2020 | 17:30 | 003 Hours 00 Minutes | 22131 |
| 100000189529_4 | Accident 4 | 100000189529 | April 2017 | 13:00 | 003 Hours 00 Minutes | 31161 |
| 100000201701_1 | Accident 1 | 100000201701 | November 2022 | 02:25 | 003 Hours 00 Minutes | 21111 |
| 100000213501_1 | Accident 1 | 100000213501 | April 2009 | 14:20 | 003 Hours 00 Minutes | 211112 |
| 100000241026_1 | Accident 1 | 100000241026 | May 2024 | 00:05 | 003 Hours 00 Minutes | 21113 |
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)
);