Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
4 rows where city = "Boca Raton"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348 | 100000058331_1 | Accident 1 | 100000058331 | City of Boca Raton Utility Services | 1401 Glades Road | Boca Raton | FL | Palm Beach | September 1998 | 10:00 | 000 Hours 25 Minutes | 22131 | Chlorine | 26.3675 | -80.111778 | {"title":"City of Boca Raton Utility Services","description":"1401 Glades Road, Boca Raton, FL Palm Beach","link":"/risk-management-plans/facility_accidents_view/348"} |
| 349 | 100000058331_2 | Accident 2 | 100000058331 | City of Boca Raton Utility Services | 1401 Glades Road | Boca Raton | FL | Palm Beach | May 1997 | 10:30 | 000 Hours 01 Minutes | 22131 | Chlorine | 26.3675 | -80.111778 | {"title":"City of Boca Raton Utility Services","description":"1401 Glades Road, Boca Raton, FL Palm Beach","link":"/risk-management-plans/facility_accidents_view/349"} |
| 350 | 100000058331_3 | Accident 3 | 100000058331 | City of Boca Raton Utility Services | 1401 Glades Road | Boca Raton | FL | Palm Beach | May 1996 | 08:15 | 000 Hours 01 Minutes | 22132 | Chlorine | 26.3675 | -80.111778 | {"title":"City of Boca Raton Utility Services","description":"1401 Glades Road, Boca Raton, FL Palm Beach","link":"/risk-management-plans/facility_accidents_view/350"} |
| 351 | 100000058331_4 | Accident 4 | 100000058331 | City of Boca Raton Utility Services | 1401 Glades Road | Boca Raton | FL | Palm Beach | May 1995 | 20:40 | 000 Hours 15 Minutes | 22132 | Chlorine | 26.3675 | -80.111778 | {"title":"City of Boca Raton Utility Services","description":"1401 Glades Road, Boca Raton, FL Palm Beach","link":"/risk-management-plans/facility_accidents_view/351"} |
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);