Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

17 rows where time_accident_began = "07:00"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, naics_code

time_accident_began 1

  • 07:00 · 17 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000034269_1 Accident 1 100000034269 February 2005 07:00 000 Hours 10 Minutes 311612
100000037355_1 Accident 1 100000037355 September 2023 07:00 005 Hours 00 Minutes 22131
100000054273_1 Accident 1 100000054273 August 1998 07:00 002 Hours 00 Minutes 31212
100000060836_1 Accident 1 100000060836 April 2021 07:00 001 Hours 00 Minutes 32552
100000070987_1 Accident 1 100000070987 December 2023 07:00 005 Hours 05 Minutes 32411
100000086809_1 Accident 1 100000086809 January 2020 07:00 000 Hours 02 Minutes 325998
100000087808_3 Accident 3 100000087808 September 2019 07:00 011 Hours 40 Minutes 32211
100000098985_1 Accident 1 100000098985 September 2002 07:00 000 Hours 05 Minutes 22131
100000123573_1 Accident 1 100000123573 September 2020 07:00 005 Hours 00 Minutes 49312
100000126133_1 Accident 1 100000126133 October 2011 07:00 000 Hours 01 Minutes 22131
100000129737_1 Accident 1 100000129737 January 2019 07:00 002 Hours 00 Minutes 22132
100000135481_1 Accident 1 100000135481 August 2016 07:00 000 Hours 01 Minutes 325199
100000146585_1 Accident 1 100000146585 August 1998 07:00 000 Hours 05 Minutes 325199
100000153353_1 Accident 1 100000153353 March 2015 07:00 000 Hours 20 Minutes 325199
100000153763_1 Accident 1 100000153763 June 2006 07:00 000 Hours 45 Minutes 31151
100000200935_1 Accident 1 100000200935 August 2021 07:00 000 Hours 01 Minutes 42469
100000201827_1 Accident 1 100000201827 August 2011 07:00 000 Hours 10 Minutes 331491

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