Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
1 row where city = "El Dorado" and facility_address = "324 Southfield Cutoff"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672 | 100000092384_1 | Accident 1 | 100000092384 | Lanxess South Plant | 324 Southfield Cutoff | El Dorado | AR | Union | August 2023 | 14:00 | 000 Hours 01 Minutes | 32518 | Ammonia (anhydrous), Bromine, Chlorine, Propylene oxide [Oxirane, methyl-], Sulfur dioxide (anhydrous), Sulfur trioxide, Oleum (Fuming Sulfuric acid) [Sulfuric acid, mixture with sulfur trioxide] | 33.111389 | -92.675556 | {"title":"Lanxess South Plant","description":"324 Southfield Cutoff, El Dorado, AR Union","link":"/risk-management-plans/facility_accidents_view/672"} |
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);