Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
22 rows where time_accident_began = "15:00"
This data as json, CSV (advanced)
Suggested facets: accident_id, facility_id, naics_code
date_of_accident 18
- August 2018 2
- July 1998 2
- May 2017 2
- November 2014 2
- April 2004 1
- August 2002 1
- December 2021 1
- December 2022 1
- July 1997 1
- July 2007 1
- June 2021 1
- March 2019 1
- May 2005 1
- May 2018 1
- May 2022 1
- May 2023 1
- October 2018 1
- September 2022 1
release_duration 14
- 000 Hours 01 Minutes 6
- 000 Hours 02 Minutes 2
- 000 Hours 30 Minutes 2
- 001 Hours 30 Minutes 2
- 000 Hours 05 Minutes 1
- 000 Hours 10 Minutes 1
- 000 Hours 15 Minutes 1
- 000 Hours 45 Minutes 1
- 001 Hours 00 Minutes 1
- 001 Hours 03 Minutes 1
- 001 Hours 45 Minutes 1
- 003 Hours 00 Minutes 1
- 010 Hours 30 Minutes 1
- 052 Hours 02 Minutes 1
time_accident_began 1
- 15:00 · 22 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000037435_1 | Accident 1 | 100000037435 | October 2018 | 15:00 | 010 Hours 30 Minutes | 332111 |
| 100000043302_1 | Accident 1 | 100000043302 | March 2019 | 15:00 | 000 Hours 30 Minutes | 33141 |
| 100000045113_1 | Accident 1 | 100000045113 | July 2007 | 15:00 | 001 Hours 30 Minutes | 49313 |
| 100000046915_2 | Accident 2 | 100000046915 | May 2005 | 15:00 | 003 Hours 00 Minutes | 32211 |
| 100000055156_1 | Accident 1 | 100000055156 | December 2022 | 15:00 | 001 Hours 30 Minutes | 221112 |
| 100000057537_3 | Accident 3 | 100000057537 | July 1998 | 15:00 | 000 Hours 01 Minutes | 325188 |
| 100000057537_4 | Accident 4 | 100000057537 | July 1998 | 15:00 | 000 Hours 02 Minutes | 325188 |
| 100000071762_2 | Accident 2 | 100000071762 | May 2018 | 15:00 | 000 Hours 05 Minutes | 42491 |
| 100000073868_1 | Accident 1 | 100000073868 | September 2022 | 15:00 | 000 Hours 01 Minutes | 32518 |
| 100000074091_1 | Accident 1 | 100000074091 | November 2014 | 15:00 | 000 Hours 45 Minutes | 31192 |
| 100000110293_5 | Accident 5 | 100000110293 | May 2017 | 15:00 | 000 Hours 30 Minutes | 327212 |
| 100000125517_1 | Accident 1 | 100000125517 | June 2021 | 15:00 | 001 Hours 00 Minutes | 32518 |
| 100000130477_1 | Accident 1 | 100000130477 | August 2018 | 15:00 | 000 Hours 01 Minutes | 31152 |
| 100000136783_1 | Accident 1 | 100000136783 | August 2002 | 15:00 | 000 Hours 01 Minutes | 325199 |
| 100000137372_1 | Accident 1 | 100000137372 | May 2023 | 15:00 | 052 Hours 02 Minutes | 32511 |
| 100000164966_1 | Accident 1 | 100000164966 | July 1997 | 15:00 | 000 Hours 02 Minutes | 211112 |
| 100000169462_1 | Accident 1 | 100000169462 | December 2021 | 15:00 | 001 Hours 45 Minutes | 32511 |
| 100000183062_1 | Accident 1 | 100000183062 | April 2004 | 15:00 | 000 Hours 01 Minutes | 311612 |
| 100000197949_1 | Accident 1 | 100000197949 | November 2014 | 15:00 | 001 Hours 03 Minutes | 325311 |
| 100000218089_1 | Accident 1 | 100000218089 | August 2018 | 15:00 | 000 Hours 01 Minutes | 48821 |
| 100000227248_1 | Accident 1 | 100000227248 | May 2017 | 15:00 | 000 Hours 15 Minutes | 21111 |
| 100000250097_1 | Accident 1 | 100000250097 | May 2022 | 15:00 | 000 Hours 10 Minutes | 22131 |
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)
);