Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
8 rows where date_of_accident = "January 2024"
This data as json, CSV (advanced)
release_duration 8
date_of_accident 1
- January 2024 · 8 ✖
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000022557_1 | Accident 1 | 100000022557 | January 2024 | 07:15 | 000 Hours 30 Minutes | 339999 |
| 100000033545_1 | Accident 1 | 100000033545 | January 2024 | 04:30 | 000 Hours 10 Minutes | 32211 |
| 100000085061_1 | Accident 1 | 100000085061 | January 2024 | 01:00 | 000 Hours 45 Minutes | 32518 |
| 100000093864_1 | Accident 1 | 100000093864 | January 2024 | 09:15 | 000 Hours 15 Minutes | 311511 |
| 100000132215_1 | Accident 1 | 100000132215 | January 2024 | 12:40 | 002 Hours 00 Minutes | 311514 |
| 100000147851_1 | Accident 1 | 100000147851 | January 2024 | 09:20 | 000 Hours 01 Minutes | 32511 |
| 100000177211_1 | Accident 1 | 100000177211 | January 2024 | 10:30 | 002 Hours 07 Minutes | 312113 |
| 100000246824_1 | Accident 1 | 100000246824 | January 2024 | 12:10 | 000 Hours 41 Minutes | 42469 |
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)
);