Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
18 rows where time_accident_began = "06:30"
This data as json, CSV (advanced)
Suggested facets: accident_id, naics_code
date_of_accident 17
- October 2018 2
- April 2022 1
- August 2015 1
- December 2019 1
- February 2021 1
- July 1995 1
- July 2007 1
- July 2016 1
- July 2017 1
- June 1997 1
- June 2021 1
- March 2020 1
- March 2022 1
- November 1999 1
- November 2011 1
- November 2014 1
- October 2002 1
release_duration 14
- 000 Hours 01 Minutes 3
- 002 Hours 00 Minutes 2
- 024 Hours 00 Minutes 2
- 000 Hours 16 Minutes 1
- 000 Hours 30 Minutes 1
- 000 Hours 45 Minutes 1
- 001 Hours 00 Minutes 1
- 001 Hours 30 Minutes 1
- 002 Hours 30 Minutes 1
- 003 Hours 00 Minutes 1
- 004 Hours 15 Minutes 1
- 007 Hours 33 Minutes 1
- 008 Hours 00 Minutes 1
- 048 Hours 00 Minutes 1
time_accident_began 1
- 06:30 · 18 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000023583_1 | Accident 1 | 100000023583 | August 2015 | 06:30 | 002 Hours 30 Minutes | 42491 |
| 100000030227_1 | Accident 1 | 100000030227 | June 1997 | 06:30 | 001 Hours 30 Minutes | 42291 |
| 100000047889_1 | Accident 1 | 100000047889 | October 2018 | 06:30 | 024 Hours 00 Minutes | 42469 |
| 100000056217_9 | Accident 9 | 100000056217 | July 1995 | 06:30 | 002 Hours 00 Minutes | 325311 |
| 100000058689_2 | Accident 2 | 100000058689 | November 2014 | 06:30 | 000 Hours 16 Minutes | 32512 |
| 100000059054_1 | Accident 1 | 100000059054 | April 2022 | 06:30 | 048 Hours 00 Minutes | 42491 |
| 100000077105_2 | Accident 2 | 100000077105 | March 2022 | 06:30 | 000 Hours 01 Minutes | 325199 |
| 100000077999_1 | Accident 1 | 100000077999 | July 2017 | 06:30 | 000 Hours 01 Minutes | 32518 |
| 100000087808_1 | Accident 1 | 100000087808 | March 2020 | 06:30 | 007 Hours 33 Minutes | 32211 |
| 100000091571_1 | Accident 1 | 100000091571 | October 2018 | 06:30 | 003 Hours 00 Minutes | 42491 |
| 100000107341_2 | Accident 2 | 100000107341 | July 2007 | 06:30 | 000 Hours 30 Minutes | 42491 |
| 100000126446_1 | Accident 1 | 100000126446 | February 2021 | 06:30 | 001 Hours 00 Minutes | 325311 |
| 100000147272_1 | Accident 1 | 100000147272 | October 2002 | 06:30 | 004 Hours 15 Minutes | 22132 |
| 100000151881_4 | Accident 4 | 100000151881 | December 2019 | 06:30 | 000 Hours 45 Minutes | 49311 |
| 100000161086_1 | Accident 1 | 100000161086 | November 1999 | 06:30 | 000 Hours 01 Minutes | 311812 |
| 100000166802_1 | Accident 1 | 100000166802 | July 2016 | 06:30 | 008 Hours 00 Minutes | 42491 |
| 100000178942_1 | Accident 1 | 100000178942 | November 2011 | 06:30 | 024 Hours 00 Minutes | 221112 |
| 100000214127_1 | Accident 1 | 100000214127 | June 2021 | 06:30 | 002 Hours 00 Minutes | 311513 |
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)
);