Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

34 rows where time_accident_began = "09:00"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, naics_code

time_accident_began 1

  • 09:00 · 34 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000003738_3 Accident 3 100000003738 May 2020 09:00 000 Hours 10 Minutes 49312
100000020176_1 Accident 1 100000020176 April 1996 09:00 000 Hours 01 Minutes 42291
100000021175_2 Accident 2 100000021175 December 1995 09:00 000 Hours 30 Minutes 22131
100000026492_1 Accident 1 100000026492 April 2020 09:00 000 Hours 01 Minutes 42491
100000033983_1 Accident 1 100000033983 May 2005 09:00 000 Hours 20 Minutes 42491
100000041634_1 Accident 1 100000041634 July 2001 09:00 000 Hours 01 Minutes 22131
100000048496_1 Accident 1 100000048496 September 1998 09:00 000 Hours 08 Minutes 49312
100000050277_1 Accident 1 100000050277 June 1996 09:00 000 Hours 30 Minutes 42291
100000065216_1 Accident 1 100000065216 July 2015 09:00 000 Hours 01 Minutes 32615
100000072609_1 Accident 1 100000072609 March 2020 09:00 000 Hours 05 Minutes 325211
100000074439_1 Accident 1 100000074439 October 2020 09:00 000 Hours 01 Minutes 32518
100000084384_1 Accident 1 100000084384 December 2019 09:00 000 Hours 10 Minutes 32211
100000084972_1 Accident 1 100000084972 August 2001 09:00 000 Hours 10 Minutes 212324
100000086989_1 Accident 1 100000086989 May 2024 09:00 000 Hours 05 Minutes 32411
100000092918_1 Accident 1 100000092918 February 2018 09:00 001 Hours 20 Minutes 32211
100000096068_1 Accident 1 100000096068 August 1999 09:00 000 Hours 30 Minutes 32522
100000099298_2 Accident 2 100000099298 January 2019 09:00 000 Hours 02 Minutes 32519
100000106789_1 Accident 1 100000106789 July 2020 09:00 000 Hours 05 Minutes 311991
100000111924_1 Accident 1 100000111924 January 2013 09:00 000 Hours 30 Minutes 22132
100000130994_1 Accident 1 100000130994 December 2005 09:00 000 Hours 15 Minutes 325211
100000134507_1 Accident 1 100000134507 September 2003 09:00 000 Hours 05 Minutes 325211
100000134507_2 Accident 2 100000134507 March 2000 09:00 000 Hours 02 Minutes 325211
100000136756_1 Accident 1 100000136756 March 2023 09:00 000 Hours 01 Minutes 325199
100000144444_1 Accident 1 100000144444 October 2020 09:00 000 Hours 04 Minutes 325199
100000154129_4 Accident 4 100000154129 June 2019 09:00 000 Hours 05 Minutes 32518
100000156047_1 Accident 1 100000156047 March 2001 09:00 000 Hours 01 Minutes 325211
100000162138_1 Accident 1 100000162138 April 2022 09:00 000 Hours 01 Minutes 22131
100000162441_1 Accident 1 100000162441 June 2015 09:00 001 Hours 30 Minutes 42491
100000166955_2 Accident 2 100000166955 September 2003 09:00 000 Hours 15 Minutes 22131
100000171583_1 Accident 1 100000171583 October 2017 09:00 000 Hours 02 Minutes 42491
100000178513_1 Accident 1 100000178513 May 2014 09:00 000 Hours 01 Minutes 42491
100000199723_1 Accident 1 100000199723 March 2023 09:00 000 Hours 23 Minutes 311513
100000232198_1 Accident 1 100000232198 June 2012 09:00 000 Hours 20 Minutes 32532
100000236158_1 Accident 1 100000236158 December 2021 09:00 001 Hours 50 Minutes 21111

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