home / risk-management-plans / rmp_facility_accidents

Menu

rmp_facility_accidents

17 rows where naics_code = 221112

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id, date_of_accident, release_duration

facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000049654_1 Accident 1 100000049654 May 1998 07:30 001 Hours 10 Minutes 221112
100000049654_2 Accident 2 100000049654 April 1997 02:40 000 Hours 20 Minutes 221112
100000055156_1 Accident 1 100000055156 December 2022 15:00 001 Hours 30 Minutes 221112
100000055156_2 Accident 2 100000055156 January 2022 12:55 000 Hours 30 Minutes 221112
100000064397_1 Accident 1 100000064397 June 2013 08:00 000 Hours 05 Minutes 221112
100000086845_1 Accident 1 100000086845 June 2010 16:40 001 Hours 00 Minutes 221112
100000086845_2 Accident 2 100000086845 April 2010 12:31 000 Hours 06 Minutes 221112
100000108787_1 Accident 1 100000108787 April 2010 21:00 000 Hours 01 Minutes 221112
100000177006_1 Accident 1 100000177006 May 2019 02:35 000 Hours 01 Minutes 221112
100000178354_1 Accident 1 100000178354 August 2008 10:30 001 Hours 00 Minutes 221112
100000178942_1 Accident 1 100000178942 November 2011 06:30 024 Hours 00 Minutes 221112
100000181117_1 Accident 1 100000181117 April 2007 19:07 000 Hours 01 Minutes 221112
100000181117_2 Accident 2 100000181117 July 2003 16:32 000 Hours 02 Minutes 221112
100000181625_1 Accident 1 100000181625 December 2021 04:00 001 Hours 00 Minutes 221112
100000181625_2 Accident 2 100000181625 December 2021 20:00 001 Hours 00 Minutes 221112
100000184748_1 Accident 1 100000184748 June 2014 10:02 000 Hours 07 Minutes 221112
100000185881_1 Accident 1 100000185881 August 2016 05:14 001 Hours 06 Minutes 221112

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