Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

62 rows where release_duration = "000 Hours 02 Minutes"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id

time_accident_began >30

release_duration 1

  • 000 Hours 02 Minutes · 62 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000007707_1 Accident 1 100000007707 February 2017 14:00 000 Hours 02 Minutes 42491
100000011505_1 Accident 1 100000011505 February 2020 10:55 000 Hours 02 Minutes 42469
100000033475_1 Accident 1 100000033475 March 2014 17:00 000 Hours 02 Minutes 11115
100000039157_1 Accident 1 100000039157 November 2021 00:30 000 Hours 02 Minutes 32411
100000045159_1 Accident 1 100000045159 August 2012 07:10 000 Hours 02 Minutes 22131
100000045159_2 Accident 2 100000045159 July 2012 08:30 000 Hours 02 Minutes 22131
100000046684_1 Accident 1 100000046684 August 2013 10:54 000 Hours 02 Minutes 42469
100000049351_1 Accident 1 100000049351 September 2018 18:00 000 Hours 02 Minutes 48821
100000050749_1 Accident 1 100000050749 November 1995 11:15 000 Hours 02 Minutes 32411
100000050865_1 Accident 1 100000050865 January 1999 04:00 000 Hours 02 Minutes 33122
100000050972_1 Accident 1 100000050972 November 2019 07:58 000 Hours 02 Minutes 32211
100000053997_1 Accident 1 100000053997 January 2013 03:20 000 Hours 02 Minutes 325211
100000056217_2 Accident 2 100000056217 November 1997 08:15 000 Hours 02 Minutes 325311
100000057323_4 Accident 4 100000057323 June 2018 16:25 000 Hours 02 Minutes 49319
100000057323_5 Accident 5 100000057323 December 2016 22:30 000 Hours 02 Minutes 49319
100000057537_4 Accident 4 100000057537 July 1998 15:00 000 Hours 02 Minutes 325188
100000071227_1 Accident 1 100000071227 December 2001 21:50 000 Hours 02 Minutes 22131
100000072048_1 Accident 1 100000072048 August 1997 11:15 000 Hours 02 Minutes 22132
100000072609_9 Accident 9 100000072609 June 2017 05:00 000 Hours 02 Minutes 325211
100000079684_1 Accident 1 100000079684 August 2011 12:00 000 Hours 02 Minutes 311511
100000086186_2 Accident 2 100000086186 September 2018 09:26 000 Hours 02 Minutes 42491
100000086809_1 Accident 1 100000086809 January 2020 07:00 000 Hours 02 Minutes 325998
100000087176_1 Accident 1 100000087176 February 2021 11:23 000 Hours 02 Minutes 311612
100000091223_1 Accident 1 100000091223 July 2020 17:04 000 Hours 02 Minutes 32615
100000094293_1 Accident 1 100000094293 June 2010 10:30 000 Hours 02 Minutes 22132
100000099298_2 Accident 2 100000099298 January 2019 09:00 000 Hours 02 Minutes 32519
100000099519_1 Accident 1 100000099519 January 2021 10:00 000 Hours 02 Minutes 42491
100000109269_1 Accident 1 100000109269 June 2019 13:45 000 Hours 02 Minutes 322121
100000110293_1 Accident 1 100000110293 May 2023 02:00 000 Hours 02 Minutes 327212
100000110293_2 Accident 2 100000110293 May 2023 02:00 000 Hours 02 Minutes 327212
100000111425_3 Accident 3 100000111425 February 2022 05:20 000 Hours 02 Minutes 325199
100000112219_2 Accident 2 100000112219 January 2017 13:25 000 Hours 02 Minutes 211111
100000112219_3 Accident 3 100000112219 January 2017 11:23 000 Hours 02 Minutes 211111
100000115341_2 Accident 2 100000115341 May 2021 09:45 000 Hours 02 Minutes 32518
100000115948_1 Accident 1 100000115948 November 1999 01:30 000 Hours 02 Minutes 32511
100000121174_1 Accident 1 100000121174 January 2020 12:40 000 Hours 02 Minutes 32518
100000124732_1 Accident 1 100000124732 March 2023 07:20 000 Hours 02 Minutes 325199
100000125429_1 Accident 1 100000125429 June 2023 23:30 000 Hours 02 Minutes 32518
100000127347_1 Accident 1 100000127347 August 2024 08:45 000 Hours 02 Minutes 21239
100000127506_10 Accident 10 100000127506 July 2015 12:08 000 Hours 02 Minutes 325211
100000134507_2 Accident 2 100000134507 March 2000 09:00 000 Hours 02 Minutes 325211
100000138987_1 Accident 1 100000138987 May 2018 14:08 000 Hours 02 Minutes 11511
100000144015_1 Accident 1 100000144015 February 2022 15:35 000 Hours 02 Minutes 32518
100000144355_2 Accident 2 100000144355 April 2001 17:45 000 Hours 02 Minutes 32512
100000146585_2 Accident 2 100000146585 March 1997 09:15 000 Hours 02 Minutes 325199
100000147842_1 Accident 1 100000147842 October 1996 06:00 000 Hours 02 Minutes 32411
100000149715_1 Accident 1 100000149715 April 2020 11:04 000 Hours 02 Minutes 21113
100000153139_1 Accident 1 100000153139 May 2024 09:40 000 Hours 02 Minutes 42491
100000164886_2 Accident 2 100000164886 April 2012 13:56 000 Hours 02 Minutes 33999
100000164966_1 Accident 1 100000164966 July 1997 15:00 000 Hours 02 Minutes 211112
100000167883_1 Accident 1 100000167883 May 1998 16:30 000 Hours 02 Minutes 22132
100000170744_1 Accident 1 100000170744 January 1999 04:00 000 Hours 02 Minutes 331111
100000171583_1 Accident 1 100000171583 October 2017 09:00 000 Hours 02 Minutes 42491
100000181117_2 Accident 2 100000181117 July 2003 16:32 000 Hours 02 Minutes 221112
100000189182_1 Accident 1 100000189182 October 2021 19:00 000 Hours 02 Minutes 42471
100000193346_1 Accident 1 100000193346 June 2015 03:00 000 Hours 02 Minutes 331314
100000193346_2 Accident 2 100000193346 August 2014 14:30 000 Hours 02 Minutes 331314
100000193382_1 Accident 1 100000193382 September 2007 11:00 000 Hours 02 Minutes 211112
100000195059_1 Accident 1 100000195059 August 2017 09:40 000 Hours 02 Minutes 21113
100000227471_2 Accident 2 100000227471 August 2014 13:00 000 Hours 02 Minutes 48422
100000233213_1 Accident 1 100000233213 June 2017 16:00 000 Hours 02 Minutes 311411
100000241623_1 Accident 1 100000241623 February 2022 05:52 000 Hours 02 Minutes 325211

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