rmp_facility_accidents

9 rows where naics_code = 311511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: time_accident_began, release_duration

facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000010203_1 Accident 1 100000010203 June 2011 11:17 002 Hours 32 Minutes 311511
100000079684_1 Accident 1 100000079684 August 2011 12:00 000 Hours 02 Minutes 311511
100000093864_1 Accident 1 100000093864 January 2024 09:15 000 Hours 15 Minutes 311511
100000109116_1 Accident 1 100000109116 October 2024 12:00 001 Hours 36 Minutes 311511
100000124956_1 Accident 1 100000124956 July 2019 03:50 000 Hours 45 Minutes 311511
100000143249_1 Accident 1 100000143249 May 2019 13:30 000 Hours 05 Minutes 311511
100000165812_1 Accident 1 100000165812 November 2003 06:10 000 Hours 10 Minutes 311511
100000220209_1 Accident 1 100000220209 May 2012 09:05 000 Hours 20 Minutes 311511
100000221985_1 Accident 1 100000221985 December 2011 14:30 000 Hours 10 Minutes 311511

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
    );