Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
5 rows where city = "Willoughby" and facility_address = "4901 Campbell Rd"
This data as json, CSV (advanced)
Suggested facets: date_of_accident, time_accident_began
| id ▼ | facility_accident_id | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | time_accident_began | release_duration | naics_code | chemical_names | latitude | longitude | popup |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 808 | 100000110293_1 | Accident 1 | 100000110293 | Willoughby Quartz Plant | 4901 Campbell Rd | Willoughby | OH | Lake | May 2023 | 02:00 | 000 Hours 02 Minutes | 327212 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 41.62584 | -81.447156 | {"title":"Willoughby Quartz Plant","description":"4901 Campbell Rd, Willoughby, OH Lake","link":"/risk-management-plans/facility_accidents_view/808"} |
| 809 | 100000110293_2 | Accident 2 | 100000110293 | Willoughby Quartz Plant | 4901 Campbell Rd | Willoughby | OH | Lake | May 2023 | 02:00 | 000 Hours 02 Minutes | 327212 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 41.62584 | -81.447156 | {"title":"Willoughby Quartz Plant","description":"4901 Campbell Rd, Willoughby, OH Lake","link":"/risk-management-plans/facility_accidents_view/809"} |
| 810 | 100000110293_3 | Accident 3 | 100000110293 | Willoughby Quartz Plant | 4901 Campbell Rd | Willoughby | OH | Lake | June 2020 | 09:15 | 000 Hours 01 Minutes | 327212 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 41.62584 | -81.447156 | {"title":"Willoughby Quartz Plant","description":"4901 Campbell Rd, Willoughby, OH Lake","link":"/risk-management-plans/facility_accidents_view/810"} |
| 811 | 100000110293_4 | Accident 4 | 100000110293 | Willoughby Quartz Plant | 4901 Campbell Rd | Willoughby | OH | Lake | September 2017 | 08:30 | 000 Hours 01 Minutes | 327212 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 41.62584 | -81.447156 | {"title":"Willoughby Quartz Plant","description":"4901 Campbell Rd, Willoughby, OH Lake","link":"/risk-management-plans/facility_accidents_view/811"} |
| 812 | 100000110293_5 | Accident 5 | 100000110293 | Willoughby Quartz Plant | 4901 Campbell Rd | Willoughby | OH | Lake | May 2017 | 15:00 | 000 Hours 30 Minutes | 327212 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 41.62584 | -81.447156 | {"title":"Willoughby Quartz Plant","description":"4901 Campbell Rd, Willoughby, OH Lake","link":"/risk-management-plans/facility_accidents_view/812"} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE facility_accidents_view (
id INTEGER PRIMARY KEY AUTOINCREMENT,
facility_accident_id TEXT,
accident_id TEXT,
facility_id TEXT,
facility_name TEXT,
facility_address TEXT,
city TEXT,
state TEXT,
county TEXT,
date_of_accident TEXT,
time_accident_began TEXT,
release_duration TEXT,
naics_code TEXT,
chemical_names TEXT,
latitude REAL,
longitude REAL
, popup TEXT);
CREATE INDEX idx_accident_id ON facility_accidents_view(facility_accident_id);