Rmp Facility Accidents

Data table with 1,554 records and 7 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

33 rows where naics_code = 42469

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id

time_accident_began 29

facility_accident_id ▼ accident_id facility_id date_of_accident time_accident_began release_duration naics_code
100000011505_1 Accident 1 100000011505 February 2020 10:55 000 Hours 02 Minutes 42469
100000014691_1 Accident 1 100000014691 August 2013 17:35 072 Hours 00 Minutes 42469
100000018269_1 Accident 1 100000018269 July 2004 06:15 004 Hours 00 Minutes 42469
100000043963_1 Accident 1 100000043963 April 2013 16:00 001 Hours 00 Minutes 42469
100000046684_1 Accident 1 100000046684 August 2013 10:54 000 Hours 02 Minutes 42469
100000047601_1 Accident 1 100000047601 May 2003 19:00 000 Hours 15 Minutes 42469
100000047889_1 Accident 1 100000047889 October 2018 06:30 024 Hours 00 Minutes 42469
100000080299_1 Accident 1 100000080299 May 2021 13:00 000 Hours 05 Minutes 42469
100000083517_1 Accident 1 100000083517 May 2024 05:30 000 Hours 05 Minutes 42469
100000083642_1 Accident 1 100000083642 March 2022 09:42 000 Hours 05 Minutes 42469
100000083811_1 Accident 1 100000083811 July 2021 13:15 000 Hours 40 Minutes 42469
100000083973_1 Accident 1 100000083973 November 2019 07:20 000 Hours 05 Minutes 42469
100000084473_1 Accident 1 100000084473 May 2022 14:45 000 Hours 05 Minutes 42469
100000100026_1 Accident 1 100000100026 June 2016 08:30 000 Hours 15 Minutes 42469
100000105646_1 Accident 1 100000105646 February 2010 12:10 000 Hours 30 Minutes 42469
100000133875_1 Accident 1 100000133875 August 2018 15:15 000 Hours 05 Minutes 42469
100000137318_1 Accident 1 100000137318 July 2001 06:25 000 Hours 01 Minutes 42469
100000137318_2 Accident 2 100000137318 September 1999 10:15 000 Hours 01 Minutes 42469
100000153193_1 Accident 1 100000153193 September 2023 08:25 000 Hours 01 Minutes 42469
100000153193_2 Accident 2 100000153193 July 2023 10:30 000 Hours 01 Minutes 42469
100000153193_3 Accident 3 100000153193 September 2022 06:25 000 Hours 01 Minutes 42469
100000153193_4 Accident 4 100000153193 July 2021 18:30 000 Hours 05 Minutes 42469
100000153415_1 Accident 1 100000153415 December 2023 11:20 000 Hours 03 Minutes 42469
100000181359_1 Accident 1 100000181359 September 2009 22:30 018 Hours 00 Minutes 42469
100000200935_1 Accident 1 100000200935 August 2021 07:00 000 Hours 01 Minutes 42469
100000200935_2 Accident 2 100000200935 January 2019 01:00 000 Hours 15 Minutes 42469
100000200935_3 Accident 3 100000200935 August 2017 21:45 000 Hours 01 Minutes 42469
100000200935_4 Accident 4 100000200935 August 2016 17:20 000 Hours 30 Minutes 42469
100000205869_1 Accident 1 100000205869 March 2023 11:00 001 Hours 00 Minutes 42469
100000219925_1 Accident 1 100000219925 September 2016 07:05 042 Hours 00 Minutes 42469
100000236531_1 Accident 1 100000236531 June 2017 13:15 002 Hours 00 Minutes 42469
100000246646_1 Accident 1 100000246646 March 2021 11:00 004 Hours 00 Minutes 42469
100000246824_1 Accident 1 100000246824 January 2024 12:10 000 Hours 41 Minutes 42469

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