home / risk_management_plans

Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

16 rows where naics_code = 325188

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id

time_accident_began 14

  • 15:00 2
  • 21:30 2
  • 01:00 1
  • 01:20 1
  • 03:00 1
  • 04:30 1
  • 05:30 1
  • 10:00 1
  • 10:30 1
  • 12:00 1
  • 13:35 1
  • 14:00 1
  • 18:38 1
  • 23:00 1

date_of_accident 13

  • December 1995 2
  • July 1998 2
  • March 1999 2
  • August 2008 1
  • February 2007 1
  • January 2003 1
  • July 1997 1
  • June 1998 1
  • March 1995 1
  • March 1996 1
  • March 1997 1
  • May 1997 1
  • September 2005 1

release_duration 10

  • 000 Hours 01 Minutes 5
  • 001 Hours 00 Minutes 2
  • 004 Hours 00 Minutes 2
  • 000 Hours 02 Minutes 1
  • 000 Hours 05 Minutes 1
  • 000 Hours 08 Minutes 1
  • 001 Hours 35 Minutes 1
  • 002 Hours 00 Minutes 1
  • 003 Hours 00 Minutes 1
  • 005 Hours 00 Minutes 1
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000022922_2 Accident 2 100000022922 May 1997 14:00 003 Hours 00 Minutes 325188
100000057537_1 Accident 1 100000057537 March 1999 23:00 005 Hours 00 Minutes 325188
100000057537_2 Accident 2 100000057537 March 1999 05:30 000 Hours 05 Minutes 325188
100000057537_3 Accident 3 100000057537 July 1998 15:00 000 Hours 01 Minutes 325188
100000057537_4 Accident 4 100000057537 July 1998 15:00 000 Hours 02 Minutes 325188
100000057537_5 Accident 5 100000057537 June 1998 04:30 004 Hours 00 Minutes 325188
100000057537_6 Accident 6 100000057537 July 1997 12:00 000 Hours 01 Minutes 325188
100000057537_7 Accident 7 100000057537 March 1997 21:30 001 Hours 00 Minutes 325188
100000057537_8 Accident 8 100000057537 December 1995 01:00 002 Hours 00 Minutes 325188
100000074634_1 Accident 1 100000074634 September 2005 03:00 000 Hours 01 Minutes 325188
100000101481_1 Accident 1 100000101481 March 1996 10:00 001 Hours 00 Minutes 325188
100000129684_1 Accident 1 100000129684 December 1995 13:35 004 Hours 00 Minutes 325188
100000130832_1 Accident 1 100000130832 January 2003 21:30 000 Hours 01 Minutes 325188
100000132171_1 Accident 1 100000132171 March 1995 10:30 000 Hours 08 Minutes 325188
100000138601_1 Accident 1 100000138601 February 2007 18:38 001 Hours 35 Minutes 325188
100000152416_1 Accident 1 100000152416 August 2008 01:20 000 Hours 01 Minutes 325188

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 20.718ms · Data license: ODbL · Data source: EDGI Cloud Portal