Rmp Facility Accidents
Data license: ODbL · Data source: EDGI Cloud Portal
73 rows where naics_code = 325211
This data as json, CSV (advanced)
Suggested facets: accident_id
time_accident_began >30
date_of_accident >30
- June 2017 3
- April 2018 2
- April 2019 2
- February 2022 2
- January 2008 2
- January 2018 2
- June 2015 2
- March 2019 2
- March 2020 2
- May 2018 2
- November 2020 2
- October 2020 2
- April 2004 1
- April 2017 1
- August 2000 1
- August 2009 1
- August 2014 1
- August 2021 1
- December 1997 1
- December 2005 1
- February 2015 1
- February 2016 1
- February 2017 1
- February 2018 1
- February 2019 1
- February 2020 1
- February 2023 1
- January 2013 1
- January 2017 1
- January 2020 1
- …
release_duration 26
- 000 Hours 01 Minutes 14
- 000 Hours 05 Minutes 14
- 000 Hours 02 Minutes 5
- 000 Hours 03 Minutes 5
- 000 Hours 10 Minutes 4
- 000 Hours 15 Minutes 4
- 000 Hours 30 Minutes 4
- 000 Hours 04 Minutes 2
- 002 Hours 30 Minutes 2
- 003 Hours 00 Minutes 2
- 000 Hours 08 Minutes 1
- 000 Hours 14 Minutes 1
- 000 Hours 16 Minutes 1
- 000 Hours 17 Minutes 1
- 000 Hours 20 Minutes 1
- 000 Hours 22 Minutes 1
- 000 Hours 28 Minutes 1
- 000 Hours 40 Minutes 1
- 000 Hours 45 Minutes 1
- 000 Hours 54 Minutes 1
- 001 Hours 30 Minutes 1
- 001 Hours 41 Minutes 1
- 005 Hours 13 Minutes 1
- 005 Hours 30 Minutes 1
- 006 Hours 00 Minutes 1
- 012 Hours 18 Minutes 1
| facility_accident_id ▼ | accident_id | facility_id | date_of_accident | time_accident_began | release_duration | naics_code |
|---|---|---|---|---|---|---|
| 100000021923_1 | Accident 1 | 100000021923 | March 1996 | 14:15 | 000 Hours 10 Minutes | 325211 |
| 100000022977_1 | Accident 1 | 100000022977 | March 2019 | 18:45 | 000 Hours 03 Minutes | 325211 |
| 100000049609_1 | Accident 1 | 100000049609 | May 2018 | 04:30 | 000 Hours 01 Minutes | 325211 |
| 100000049645_1 | Accident 1 | 100000049645 | November 2020 | 13:55 | 001 Hours 41 Minutes | 325211 |
| 100000050605_1 | Accident 1 | 100000050605 | January 2020 | 02:00 | 000 Hours 05 Minutes | 325211 |
| 100000050605_2 | Accident 2 | 100000050605 | June 2013 | 08:00 | 000 Hours 05 Minutes | 325211 |
| 100000050605_3 | Accident 3 | 100000050605 | August 2009 | 16:10 | 000 Hours 05 Minutes | 325211 |
| 100000053997_1 | Accident 1 | 100000053997 | January 2013 | 03:20 | 000 Hours 02 Minutes | 325211 |
| 100000069515_1 | Accident 1 | 100000069515 | January 2008 | 19:33 | 000 Hours 28 Minutes | 325211 |
| 100000069515_2 | Accident 2 | 100000069515 | January 2008 | 19:45 | 000 Hours 30 Minutes | 325211 |
| 100000069515_6 | Accident 6 | 100000069515 | September 2005 | 12:49 | 000 Hours 03 Minutes | 325211 |
| 100000072609_1 | Accident 1 | 100000072609 | March 2020 | 09:00 | 000 Hours 05 Minutes | 325211 |
| 100000072609_10 | Accident 10 | 100000072609 | June 2017 | 07:45 | 002 Hours 30 Minutes | 325211 |
| 100000072609_11 | Accident 11 | 100000072609 | November 2016 | 02:00 | 000 Hours 01 Minutes | 325211 |
| 100000072609_12 | Accident 12 | 100000072609 | June 2015 | 11:45 | 000 Hours 05 Minutes | 325211 |
| 100000072609_13 | Accident 13 | 100000072609 | June 2015 | 11:45 | 000 Hours 05 Minutes | 325211 |
| 100000072609_2 | Accident 2 | 100000072609 | March 2020 | 21:02 | 000 Hours 05 Minutes | 325211 |
| 100000072609_3 | Accident 3 | 100000072609 | February 2020 | 21:01 | 000 Hours 05 Minutes | 325211 |
| 100000072609_4 | Accident 4 | 100000072609 | July 2019 | 15:35 | 000 Hours 05 Minutes | 325211 |
| 100000072609_5 | Accident 5 | 100000072609 | May 2019 | 04:10 | 000 Hours 30 Minutes | 325211 |
| 100000072609_6 | Accident 6 | 100000072609 | April 2019 | 01:20 | 002 Hours 30 Minutes | 325211 |
| 100000072609_7 | Accident 7 | 100000072609 | February 2019 | 00:02 | 000 Hours 05 Minutes | 325211 |
| 100000072609_8 | Accident 8 | 100000072609 | October 2018 | 08:15 | 000 Hours 05 Minutes | 325211 |
| 100000072609_9 | Accident 9 | 100000072609 | June 2017 | 05:00 | 000 Hours 02 Minutes | 325211 |
| 100000073751_1 | Accident 1 | 100000073751 | August 2021 | 23:30 | 012 Hours 18 Minutes | 325211 |
| 100000076026_2 | Accident 2 | 100000076026 | November 2015 | 03:37 | 000 Hours 03 Minutes | 325211 |
| 100000078523_1 | Accident 1 | 100000078523 | September 2023 | 19:35 | 000 Hours 01 Minutes | 325211 |
| 100000083544_1 | Accident 1 | 100000083544 | February 2015 | 19:15 | 000 Hours 30 Minutes | 325211 |
| 100000085203_1 | Accident 1 | 100000085203 | January 2022 | 12:15 | 000 Hours 10 Minutes | 325211 |
| 100000091697_1 | Accident 1 | 100000091697 | July 2000 | 11:51 | 000 Hours 40 Minutes | 325211 |
| 100000094211_1 | Accident 1 | 100000094211 | February 2023 | 22:45 | 000 Hours 01 Minutes | 325211 |
| 100000115118_1 | Accident 1 | 100000115118 | November 2020 | 18:40 | 000 Hours 01 Minutes | 325211 |
| 100000115412_1 | Accident 1 | 100000115412 | October 2020 | 17:00 | 000 Hours 20 Minutes | 325211 |
| 100000115412_2 | Accident 2 | 100000115412 | May 2018 | 08:10 | 000 Hours 05 Minutes | 325211 |
| 100000115412_3 | Accident 3 | 100000115412 | February 2018 | 10:15 | 000 Hours 15 Minutes | 325211 |
| 100000115412_4 | Accident 4 | 100000115412 | August 2014 | 00:30 | 000 Hours 03 Minutes | 325211 |
| 100000115412_5 | Accident 5 | 100000115412 | May 2014 | 06:00 | 000 Hours 15 Minutes | 325211 |
| 100000115412_6 | Accident 6 | 100000115412 | March 2014 | 08:00 | 000 Hours 05 Minutes | 325211 |
| 100000117438_1 | Accident 1 | 100000117438 | February 2017 | 05:06 | 000 Hours 54 Minutes | 325211 |
| 100000119187_1 | Accident 1 | 100000119187 | May 2024 | 09:10 | 000 Hours 03 Minutes | 325211 |
| 100000127506_1 | Accident 1 | 100000127506 | April 2019 | 19:50 | 000 Hours 01 Minutes | 325211 |
| 100000127506_10 | Accident 10 | 100000127506 | July 2015 | 12:08 | 000 Hours 02 Minutes | 325211 |
| 100000127506_2 | Accident 2 | 100000127506 | March 2019 | 21:27 | 000 Hours 04 Minutes | 325211 |
| 100000127506_3 | Accident 3 | 100000127506 | July 2018 | 12:54 | 000 Hours 45 Minutes | 325211 |
| 100000127506_4 | Accident 4 | 100000127506 | October 2017 | 17:59 | 000 Hours 04 Minutes | 325211 |
| 100000127506_5 | Accident 5 | 100000127506 | September 2017 | 03:23 | 000 Hours 01 Minutes | 325211 |
| 100000127506_6 | Accident 6 | 100000127506 | June 2017 | 01:02 | 000 Hours 08 Minutes | 325211 |
| 100000127506_7 | Accident 7 | 100000127506 | April 2017 | 22:19 | 000 Hours 14 Minutes | 325211 |
| 100000127506_8 | Accident 8 | 100000127506 | February 2016 | 14:33 | 000 Hours 17 Minutes | 325211 |
| 100000127506_9 | Accident 9 | 100000127506 | September 2015 | 06:53 | 005 Hours 13 Minutes | 325211 |
| 100000129648_1 | Accident 1 | 100000129648 | March 2002 | 10:15 | 000 Hours 01 Minutes | 325211 |
| 100000130994_1 | Accident 1 | 100000130994 | December 2005 | 09:00 | 000 Hours 15 Minutes | 325211 |
| 100000132073_1 | Accident 1 | 100000132073 | August 2000 | 05:00 | 001 Hours 30 Minutes | 325211 |
| 100000134507_1 | Accident 1 | 100000134507 | September 2003 | 09:00 | 000 Hours 05 Minutes | 325211 |
| 100000134507_2 | Accident 2 | 100000134507 | March 2000 | 09:00 | 000 Hours 02 Minutes | 325211 |
| 100000137407_1 | Accident 1 | 100000137407 | December 1997 | 05:05 | 000 Hours 10 Minutes | 325211 |
| 100000144266_1 | Accident 1 | 100000144266 | April 2004 | 22:45 | 325211 | |
| 100000144471_1 | Accident 1 | 100000144471 | October 2020 | 09:30 | 000 Hours 22 Minutes | 325211 |
| 100000151444_1 | Accident 1 | 100000151444 | June 2019 | 02:00 | 003 Hours 00 Minutes | 325211 |
| 100000151444_2 | Accident 2 | 100000151444 | April 2018 | 10:00 | 000 Hours 01 Minutes | 325211 |
| 100000151444_3 | Accident 3 | 100000151444 | April 2018 | 19:50 | 000 Hours 01 Minutes | 325211 |
| 100000151444_4 | Accident 4 | 100000151444 | January 2017 | 05:45 | 003 Hours 00 Minutes | 325211 |
| 100000156047_1 | Accident 1 | 100000156047 | March 2001 | 09:00 | 000 Hours 01 Minutes | 325211 |
| 100000156127_1 | Accident 1 | 100000156127 | June 2024 | 06:25 | 000 Hours 01 Minutes | 325211 |
| 100000159017_1 | Accident 1 | 100000159017 | October 2002 | 20:30 | 000 Hours 30 Minutes | 325211 |
| 100000159017_2 | Accident 2 | 100000159017 | May 2001 | 17:30 | 000 Hours 10 Minutes | 325211 |
| 100000167204_1 | Accident 1 | 100000167204 | May 2017 | 06:31 | 005 Hours 30 Minutes | 325211 |
| 100000176953_1 | Accident 1 | 100000176953 | January 2018 | 14:24 | 000 Hours 01 Minutes | 325211 |
| 100000197379_1 | Accident 1 | 100000197379 | July 2006 | 04:10 | 006 Hours 00 Minutes | 325211 |
| 100000217151_1 | Accident 1 | 100000217151 | January 2018 | 09:38 | 000 Hours 16 Minutes | 325211 |
| 100000241384_1 | Accident 1 | 100000241384 | June 2016 | 10:03 | 000 Hours 01 Minutes | 325211 |
| 100000241623_1 | Accident 1 | 100000241623 | February 2022 | 05:52 | 000 Hours 02 Minutes | 325211 |
| 100000241623_2 | Accident 2 | 100000241623 | February 2022 | 06:45 | 000 Hours 15 Minutes | 325211 |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);