Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

42 rows where naics_code = 311615

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id

time_accident_began >30

facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000007878_1 Accident 1 100000007878 December 2022 00:25 035 Hours 00 Minutes 311615
100000007878_2 Accident 2 100000007878 March 2019 12:30 001 Hours 00 Minutes 311615
100000010766_1 Accident 1 100000010766 June 1998 11:00 000 Hours 10 Minutes 311615
100000020915_1 Accident 1 100000020915 January 2019 20:00 000 Hours 01 Minutes 311615
100000037747_2 Accident 2 100000037747 January 1996 14:35 000 Hours 10 Minutes 311615
100000041242_1 Accident 1 100000041242 August 2016 17:15 000 Hours 29 Minutes 311615
100000048209_1 Accident 1 100000048209 April 2018 18:41 000 Hours 10 Minutes 311615
100000050044_1 Accident 1 100000050044 April 2021 10:51 000 Hours 20 Minutes 311615
100000050758_1 Accident 1 100000050758 June 2013 02:07 001 Hours 30 Minutes 311615
100000050758_2 Accident 2 100000050758 March 2013 19:05 000 Hours 10 Minutes 311615
100000051052_1 Accident 1 100000051052 September 2019 20:30 002 Hours 36 Minutes 311615
100000051409_1 Accident 1 100000051409 September 1997 14:20 000 Hours 05 Minutes 311615
100000051409_2 Accident 2 100000051409 June 1997 05:05 000 Hours 01 Minutes 311615
100000051445_1 Accident 1 100000051445 June 2021 17:00 014 Hours 00 Minutes 311615
100000051926_1 Accident 1 100000051926 September 2005 00:10 000 Hours 15 Minutes 311615
100000052541_1 Accident 1 100000052541 May 2020 05:20 001 Hours 30 Minutes 311615
100000052998_1 Accident 1 100000052998 August 2023 10:20 000 Hours 01 Minutes 311615
100000054772_1 Accident 1 100000054772 September 2019 08:45 000 Hours 01 Minutes 311615
100000064841_1 Accident 1 100000064841 June 2007 03:43 005 Hours 17 Minutes 311615
100000065225_1 Accident 1 100000065225 January 2012 14:55 000 Hours 42 Minutes 311615
100000100856_1 Accident 1 100000100856 July 2022 21:45 002 Hours 30 Minutes 311615
100000101123_1 Accident 1 100000101123 July 2000 09:17 000 Hours 24 Minutes 311615
100000103185_1 Accident 1 100000103185 February 2019 13:00 000 Hours 25 Minutes 311615
100000103693_1 Accident 1 100000103693 October 2018 05:25 003 Hours 30 Minutes 311615
100000104585_1 Accident 1 100000104585 July 2017 17:01 000 Hours 20 Minutes 311615
100000122048_1 Accident 1 100000122048 August 2018 16:25 000 Hours 06 Minutes 311615
100000127061_1 Accident 1 100000127061 January 2018 08:37 001 Hours 04 Minutes 311615
100000129755_1 Accident 1 100000129755 June 2019 15:45 000 Hours 08 Minutes 311615
100000130707_1 Accident 1 100000130707 December 2022 11:50 000 Hours 03 Minutes 311615
100000136131_1 Accident 1 100000136131 July 2023 21:30 000 Hours 07 Minutes 311615
100000138059_1 Accident 1 100000138059 May 2012 05:45 000 Hours 10 Minutes 311615
100000138246_1 Accident 1 100000138246 June 2015 21:13 004 Hours 00 Minutes 311615
100000155716_1 Accident 1 100000155716 January 2022 19:55 000 Hours 11 Minutes 311615
100000170968_1 Accident 1 100000170968 January 2011 14:30 005 Hours 30 Minutes 311615
100000171164_1 Accident 1 100000171164 December 2014 14:45 000 Hours 05 Minutes 311615
100000187237_1 Accident 1 100000187237 May 2005 17:00 009 Hours 00 Minutes 311615
100000187237_2 Accident 2 100000187237 November 2003 13:50 000 Hours 34 Minutes 311615
100000187237_3 Accident 3 100000187237 November 2002 21:00 000 Hours 30 Minutes 311615
100000193881_1 Accident 1 100000193881 November 2016 11:47 001 Hours 28 Minutes 311615
100000199224_1 Accident 1 100000199224 December 2021 21:20 000 Hours 01 Minutes 311615
100000242061_1 Accident 1 100000242061 February 2022 20:42 002 Hours 30 Minutes 311615
100000242061_2 Accident 2 100000242061 October 2019 19:30 000 Hours 01 Minutes 311615

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