home / risk-management-plans / rmp_facility_accidents

Menu

rmp_facility_accidents

12 rows where naics_code = 311513

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id, release_duration

facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000065378_1 Accident 1 100000065378 February 2019 02:30 000 Hours 15 Minutes 311513
100000065378_2 Accident 2 100000065378 August 2013 09:15 000 Hours 05 Minutes 311513
100000065396_1 Accident 1 100000065396 August 2020 13:55 024 Hours 00 Minutes 311513
100000066359_1 Accident 1 100000066359 November 2020 19:35 000 Hours 29 Minutes 311513
100000066527_1 Accident 1 100000066527 May 2019 15:55 009 Hours 00 Minutes 311513
100000101971_1 Accident 1 100000101971 May 2021 14:28 000 Hours 18 Minutes 311513
100000145844_1 Accident 1 100000145844 March 2021 12:40 000 Hours 15 Minutes 311513
100000160274_1 Accident 1 100000160274 May 2022 21:20 005 Hours 40 Minutes 311513
100000178979_1 Accident 1 100000178979 September 2011 10:00 000 Hours 01 Minutes 311513
100000183071_1 Accident 1 100000183071 September 2016 07:40 000 Hours 15 Minutes 311513
100000199723_1 Accident 1 100000199723 March 2023 09:00 000 Hours 23 Minutes 311513
100000214127_1 Accident 1 100000214127 June 2021 06:30 002 Hours 00 Minutes 311513

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)
    );
Powered by Datasette · Queries took 1.2ms