Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

36 rows where time_accident_began = "10:00"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, naics_code

time_accident_began 1

  • 10:00 · 36 ✖
facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000019071_1 Accident 1 100000019071 December 2001 10:00 000 Hours 01 Minutes 211112
100000024074_1 Accident 1 100000024074 July 2022 10:00 000 Hours 18 Minutes 21113
100000028418_1 Accident 1 100000028418 November 1995 10:00 000 Hours 30 Minutes 22131
100000028668_1 Accident 1 100000028668 July 2005 10:00 000 Hours 10 Minutes 339991
100000036061_1 Accident 1 100000036061 June 2000 10:00 001 Hours 00 Minutes 42491
100000045257_1 Accident 1 100000045257 April 1995 10:00 000 Hours 05 Minutes 22131
100000046915_1 Accident 1 100000046915 August 2010 10:00 000 Hours 21 Minutes 32211
100000048897_3 Accident 3 100000048897 September 1997 10:00 000 Hours 30 Minutes 331315
100000053737_1 Accident 1 100000053737 April 2015 10:00 000 Hours 45 Minutes 111199
100000058331_1 Accident 1 100000058331 September 1998 10:00 000 Hours 25 Minutes 22131
100000063646_1 Accident 1 100000063646 October 2006 10:00 000 Hours 01 Minutes 22132
100000070497_1 Accident 1 100000070497 February 2022 10:00 000 Hours 01 Minutes 42491
100000086382_1 Accident 1 100000086382 January 1996 10:00 000 Hours 01 Minutes 32511
100000087808_2 Accident 2 100000087808 January 2020 10:00 012 Hours 44 Minutes 32211
100000091866_2 Accident 2 100000091866 November 2015 10:00 000 Hours 01 Minutes 32511
100000092918_2 Accident 2 100000092918 January 2018 10:00 000 Hours 05 Minutes 32211
100000099519_1 Accident 1 100000099519 January 2021 10:00 000 Hours 02 Minutes 42491
100000099877_3 Accident 3 100000099877 May 2017 10:00 000 Hours 01 Minutes 325311
100000101481_1 Accident 1 100000101481 March 1996 10:00 001 Hours 00 Minutes 325188
100000101846_1 Accident 1 100000101846 March 2010 10:00 010 Hours 00 Minutes 325998
100000108867_1 Accident 1 100000108867 November 2019 10:00 000 Hours 01 Minutes 22131
100000109857_1 Accident 1 100000109857 May 1998 10:00 008 Hours 00 Minutes 22131
100000113432_1 Accident 1 100000113432 March 2018 10:00 000 Hours 01 Minutes 22131
100000125937_1 Accident 1 100000125937 October 2000 10:00 000 Hours 01 Minutes 332813
100000127276_1 Accident 1 100000127276 March 2011 10:00 056 Hours 00 Minutes 311423
100000132581_2 Accident 2 100000132581 March 2020 10:00 000 Hours 05 Minutes 32212
100000137283_2 Accident 2 100000137283 November 1996 10:00 000 Hours 20 Minutes 11232
100000145372_1 Accident 1 100000145372 April 1999 10:00 000 Hours 01 Minutes 325199
100000149387_2 Accident 2 100000149387 April 1998 10:00 000 Hours 01 Minutes 32411
100000150347_2 Accident 2 100000150347 April 2020 10:00 000 Hours 22 Minutes 32411
100000151444_2 Accident 2 100000151444 April 2018 10:00 000 Hours 01 Minutes 325211
100000157732_1 Accident 1 100000157732 July 1998 10:00 000 Hours 01 Minutes 22132
100000157849_1 Accident 1 100000157849 August 1996 10:00 000 Hours 01 Minutes 22131
100000173867_1 Accident 1 100000173867 July 2013 10:00 000 Hours 20 Minutes 42471
100000178979_1 Accident 1 100000178979 September 2011 10:00 000 Hours 01 Minutes 311513
100000207732_1 Accident 1 100000207732 August 2017 10:00 000 Hours 01 Minutes 22131

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