Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
17 rows where date_of_accident = "May 2023"
This data as json, CSV (advanced)
Suggested facets: facility_id
time_accident_began 15
release_duration 14
- 000 Hours 01 Minutes 2
- 000 Hours 02 Minutes 2
- 000 Hours 15 Minutes 2
- 000 Hours 10 Minutes 1
- 000 Hours 13 Minutes 1
- 000 Hours 18 Minutes 1
- 000 Hours 35 Minutes 1
- 000 Hours 51 Minutes 1
- 001 Hours 00 Minutes 1
- 002 Hours 00 Minutes 1
- 002 Hours 11 Minutes 1
- 007 Hours 45 Minutes 1
- 052 Hours 02 Minutes 1
- 154 Hours 00 Minutes 1
date_of_accident 1
- May 2023 · 17 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000070987_3 | Accident 3 | 100000070987 | May 2023 | 09:35 | 154 Hours 00 Minutes | 32411 |
| 100000073476_1 | Accident 1 | 100000073476 | May 2023 | 06:20 | 000 Hours 35 Minutes | 32411 |
| 100000075642_1 | Accident 1 | 100000075642 | May 2023 | 10:15 | 007 Hours 45 Minutes | 32512 |
| 100000110293_1 | Accident 1 | 100000110293 | May 2023 | 02:00 | 000 Hours 02 Minutes | 327212 |
| 100000110293_2 | Accident 2 | 100000110293 | May 2023 | 02:00 | 000 Hours 02 Minutes | 327212 |
| 100000115341_1 | Accident 1 | 100000115341 | May 2023 | 12:20 | 000 Hours 51 Minutes | 32518 |
| 100000123591_2 | Accident 2 | 100000123591 | May 2023 | 08:20 | 002 Hours 11 Minutes | 32411 |
| 100000124812_1 | Accident 1 | 100000124812 | May 2023 | 14:10 | 000 Hours 18 Minutes | 31141 |
| 100000136934_1 | Accident 1 | 100000136934 | May 2023 | 09:50 | 000 Hours 13 Minutes | 33141 |
| 100000137372_1 | Accident 1 | 100000137372 | May 2023 | 15:00 | 052 Hours 02 Minutes | 32511 |
| 100000145559_1 | Accident 1 | 100000145559 | May 2023 | 20:00 | 000 Hours 15 Minutes | 22132 |
| 100000151792_1 | Accident 1 | 100000151792 | May 2023 | 13:50 | 000 Hours 01 Minutes | 42491 |
| 100000185499_1 | Accident 1 | 100000185499 | May 2023 | 10:30 | 002 Hours 00 Minutes | 42491 |
| 100000198074_1 | Accident 1 | 100000198074 | May 2023 | 12:15 | 000 Hours 10 Minutes | 311411 |
| 100000218784_1 | Accident 1 | 100000218784 | May 2023 | 19:30 | 001 Hours 00 Minutes | 21113 |
| 100000232768_1 | Accident 1 | 100000232768 | May 2023 | 10:15 | 000 Hours 01 Minutes | 22132 |
| 100000234007_1 | Accident 1 | 100000234007 | May 2023 | 08:30 | 000 Hours 15 Minutes | 32411 |
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)
);