Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
2 rows where city = "Chicago" and facility_name = "Sawyer Water Purification Plant (SWPP)"
This data as json, CSV (advanced)
facility_name 1
- Sawyer Water Purification Plant (SWPP) · 2 ✖
facility_address 1
city 1
- Chicago · 2 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 206 | 100000045159_1 | Accident 1 | 100000045159 | Sawyer Water Purification Plant (SWPP) | 3300 East Cheltenham Place | Chicago | IL | Cook | August 2012 | 07:10 | 000 Hours 02 Minutes | 22131 | Chlorine | 41.758136 | -87.542459 | {"title":"Sawyer Water Purification Plant (SWPP)","description":"3300 East Cheltenham Place, Chicago, IL Cook","link":"/risk-management-plans/facility_accidents_view/206"} |
| 207 | 100000045159_2 | Accident 2 | 100000045159 | Sawyer Water Purification Plant (SWPP) | 3300 East Cheltenham Place | Chicago | IL | Cook | July 2012 | 08:30 | 000 Hours 02 Minutes | 22131 | Chlorine | 41.758136 | -87.542459 | {"title":"Sawyer Water Purification Plant (SWPP)","description":"3300 East Cheltenham Place, Chicago, IL Cook","link":"/risk-management-plans/facility_accidents_view/207"} |
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);