home / risk_management_plans

Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

27 rows where release_duration = "001 Hours 30 Minutes"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: facility_id

date_of_accident 26

  • July 2022 2
  • April 2012 1
  • April 2016 1
  • April 2023 1
  • August 2000 1
  • August 2017 1
  • August 2022 1
  • December 1997 1
  • December 2022 1
  • July 1998 1
  • July 2007 1
  • June 1996 1
  • June 1997 1
  • June 1998 1
  • June 2013 1
  • June 2015 1
  • March 1997 1
  • March 2019 1
  • March 2024 1
  • May 2008 1
  • May 2020 1
  • November 2021 1
  • October 1996 1
  • October 2002 1
  • September 1996 1
  • September 1997 1

time_accident_began 24

  • 07:30 2
  • 13:00 2
  • 15:00 2
  • 01:30 1
  • 02:07 1
  • 03:00 1
  • 03:45 1
  • 04:50 1
  • 05:00 1
  • 05:15 1
  • 05:20 1
  • 06:30 1
  • 08:00 1
  • 09:00 1
  • 10:10 1
  • 10:20 1
  • 10:30 1
  • 11:05 1
  • 11:15 1
  • 11:30 1
  • 12:15 1
  • 13:30 1
  • 13:35 1
  • 20:30 1

release_duration 1

  • 001 Hours 30 Minutes · 27 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000030227_1 Accident 1 100000030227 June 1997 06:30 001 Hours 30 Minutes 42291
100000042651_1 Accident 1 100000042651 April 2012 08:00 001 Hours 30 Minutes 32519
100000044819_1 Accident 1 100000044819 May 2008 20:30 001 Hours 30 Minutes 42491
100000045113_1 Accident 1 100000045113 July 2007 15:00 001 Hours 30 Minutes 49313
100000045578_1 Accident 1 100000045578 July 2022 13:00 001 Hours 30 Minutes 22131
100000050758_1 Accident 1 100000050758 June 2013 02:07 001 Hours 30 Minutes 311615
100000052541_1 Accident 1 100000052541 May 2020 05:20 001 Hours 30 Minutes 311615
100000055156_1 Accident 1 100000055156 December 2022 15:00 001 Hours 30 Minutes 221112
100000057564_1 Accident 1 100000057564 September 1996 03:00 001 Hours 30 Minutes 22132
100000057564_2 Accident 2 100000057564 June 1996 13:00 001 Hours 30 Minutes 22132
100000059651_1 Accident 1 100000059651 December 1997 10:30 001 Hours 30 Minutes 32211
100000068133_1 Accident 1 100000068133 October 2002 01:30 001 Hours 30 Minutes 311421
100000073485_1 Accident 1 100000073485 September 1997 10:10 001 Hours 30 Minutes 32562
100000080903_1 Accident 1 100000080903 June 1998 10:20 001 Hours 30 Minutes 211112
100000084204_1 Accident 1 100000084204 August 2017 13:30 001 Hours 30 Minutes 42491
100000085061_6 Accident 6 100000085061 July 2022 12:15 001 Hours 30 Minutes 325199
100000107886_1 Accident 1 100000107886 August 2022 03:45 001 Hours 30 Minutes 32411
100000108732_1 Accident 1 100000108732 October 1996 11:15 001 Hours 30 Minutes 22132
100000116581_2 Accident 2 100000116581 March 2019 13:35 001 Hours 30 Minutes 32411
100000116634_1 Accident 1 100000116634 April 2023 11:05 001 Hours 30 Minutes 32411
100000132073_1 Accident 1 100000132073 August 2000 05:00 001 Hours 30 Minutes 325211
100000141866_1 Accident 1 100000141866 April 2016 11:30 001 Hours 30 Minutes 115112
100000143882_1 Accident 1 100000143882 July 1998 05:15 001 Hours 30 Minutes 49312
100000154496_2 Accident 2 100000154496 November 2021 04:50 001 Hours 30 Minutes 311612
100000159428_1 Accident 1 100000159428 March 2024 07:30 001 Hours 30 Minutes 49312
100000162441_1 Accident 1 100000162441 June 2015 09:00 001 Hours 30 Minutes 42491
100000165947_1 Accident 1 100000165947 March 1997 07:30 001 Hours 30 Minutes 333613

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)
    );
Powered by Datasette · Queries took 1357.467ms · Data license: ODbL · Data source: EDGI Cloud Portal