Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

18 rows where release_duration = "002 Hours 30 Minutes"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id, naics_code

time_accident_began 17

release_duration 1

  • 002 Hours 30 Minutes · 18 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000023583_1 Accident 1 100000023583 August 2015 06:30 002 Hours 30 Minutes 42491
100000025803_1 Accident 1 100000025803 September 1995 14:30 002 Hours 30 Minutes 31133
100000072609_10 Accident 10 100000072609 June 2017 07:45 002 Hours 30 Minutes 325211
100000072609_6 Accident 6 100000072609 April 2019 01:20 002 Hours 30 Minutes 325211
100000073485_2 Accident 2 100000073485 June 1996 11:06 002 Hours 30 Minutes 32562
100000073868_4 Accident 4 100000073868 August 2016 08:34 002 Hours 30 Minutes 32518
100000092339_1 Accident 1 100000092339 May 2020 05:15 002 Hours 30 Minutes 42491
100000100856_1 Accident 1 100000100856 July 2022 21:45 002 Hours 30 Minutes 311615
100000102202_1 Accident 1 100000102202 March 2012 09:30 002 Hours 30 Minutes 11511
100000106333_1 Accident 1 100000106333 June 2008 20:30 002 Hours 30 Minutes 22132
100000111425_4 Accident 4 100000111425 December 2019 17:30 002 Hours 30 Minutes 325199
100000112424_1 Accident 1 100000112424 June 1995 15:30 002 Hours 30 Minutes 22131
100000128113_1 Accident 1 100000128113 July 2000 21:00 002 Hours 30 Minutes 22132
100000156948_1 Accident 1 100000156948 December 1997 04:20 002 Hours 30 Minutes 211112
100000158054_1 Accident 1 100000158054 June 2023 15:30 002 Hours 30 Minutes 331314
100000167151_1 Accident 1 100000167151 July 2023 21:35 002 Hours 30 Minutes 31161
100000175847_1 Accident 1 100000175847 August 2013 16:40 002 Hours 30 Minutes 32615
100000242061_1 Accident 1 100000242061 February 2022 20:42 002 Hours 30 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)
    );