Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
20 rows where time_accident_began = "16:00"
This data as json, CSV (advanced)
Suggested facets: accident_id, facility_id
date_of_accident 19
- February 1999 2
- April 2007 1
- April 2013 1
- April 2019 1
- August 2013 1
- December 1997 1
- February 2019 1
- January 2023 1
- July 2015 1
- July 2023 1
- June 2017 1
- June 2019 1
- March 2011 1
- March 2015 1
- March 2019 1
- November 1996 1
- October 1998 1
- September 1994 1
- September 2017 1
release_duration 13
time_accident_began 1
- 16:00 · 20 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000003907_1 | Accident 1 | 100000003907 | January 2023 | 16:00 | 000 Hours 01 Minutes | 311611 |
| 100000032939_1 | Accident 1 | 100000032939 | July 2015 | 16:00 | 001 Hours 45 Minutes | 311411 |
| 100000033395_2 | Accident 2 | 100000033395 | September 1994 | 16:00 | 000 Hours 05 Minutes | 22131 |
| 100000043963_1 | Accident 1 | 100000043963 | April 2013 | 16:00 | 001 Hours 00 Minutes | 42469 |
| 100000045989_1 | Accident 1 | 100000045989 | July 2023 | 16:00 | 000 Hours 01 Minutes | 32512 |
| 100000046096_2 | Accident 2 | 100000046096 | June 2019 | 16:00 | 000 Hours 30 Minutes | 311612 |
| 100000059214_3 | Accident 3 | 100000059214 | March 2011 | 16:00 | 016 Hours 00 Minutes | 32411 |
| 100000059535_5 | Accident 5 | 100000059535 | November 1996 | 16:00 | 000 Hours 01 Minutes | 22132 |
| 100000062291_1 | Accident 1 | 100000062291 | March 2015 | 16:00 | 000 Hours 20 Minutes | 311411 |
| 100000073154_6 | Accident 6 | 100000073154 | February 1999 | 16:00 | 000 Hours 10 Minutes | 32211 |
| 100000073154_7 | Accident 7 | 100000073154 | October 1998 | 16:00 | 000 Hours 15 Minutes | 32212 |
| 100000073948_1 | Accident 1 | 100000073948 | March 2019 | 16:00 | 000 Hours 01 Minutes | 32532 |
| 100000109848_1 | Accident 1 | 100000109848 | December 1997 | 16:00 | 000 Hours 45 Minutes | 49312 |
| 100000131519_1 | Accident 1 | 100000131519 | February 1999 | 16:00 | 000 Hours 01 Minutes | 322122 |
| 100000135043_2 | Accident 2 | 100000135043 | April 2007 | 16:00 | 000 Hours 34 Minutes | 325131 |
| 100000148137_2 | Accident 2 | 100000148137 | April 2019 | 16:00 | 001 Hours 10 Minutes | 325311 |
| 100000149715_3 | Accident 3 | 100000149715 | August 2013 | 16:00 | 000 Hours 15 Minutes | 211112 |
| 100000230626_5 | Accident 5 | 100000230626 | February 2019 | 16:00 | 000 Hours 01 Minutes | 325199 |
| 100000231858_1 | Accident 1 | 100000231858 | September 2017 | 16:00 | 000 Hours 01 Minutes | 49312 |
| 100000233213_1 | Accident 1 | 100000233213 | June 2017 | 16:00 | 000 Hours 02 Minutes | 311411 |
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)
);