Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
3 rows where city = "La Porte" and facility_name = "Kuraray La Porte"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1466 | 100000225909_1 | Accident 1 | 100000225909 | Kuraray La Porte | 12342 Strang Road | La Porte | TX | Harris | January 2018 | 02:20 | 002 Hours 25 Minutes | 325199 | Acetaldehyde, Vinyl acetate monomer [Acetic acid ethenyl ester], Ethylene [Ethene] | 29.699833 | -95.035889 | {"title":"Kuraray La Porte","description":"12342 Strang Road, La Porte, TX Harris","link":"/risk-management-plans/facility_accidents_view/1466"} |
| 1467 | 100000225909_2 | Accident 2 | 100000225909 | Kuraray La Porte | 12342 Strang Road | La Porte | TX | Harris | April 2017 | 16:51 | 002 Hours 15 Minutes | 325199 | Acetaldehyde, Vinyl acetate monomer [Acetic acid ethenyl ester], Ethylene [Ethene] | 29.699833 | -95.035889 | {"title":"Kuraray La Porte","description":"12342 Strang Road, La Porte, TX Harris","link":"/risk-management-plans/facility_accidents_view/1467"} |
| 1468 | 100000225909_3 | Accident 3 | 100000225909 | Kuraray La Porte | 12342 Strang Road | La Porte | TX | Harris | September 2016 | 18:18 | 002 Hours 22 Minutes | 325199 | Acetaldehyde, Vinyl acetate monomer [Acetic acid ethenyl ester], Ethylene [Ethene] | 29.699833 | -95.035889 | {"title":"Kuraray La Porte","description":"12342 Strang Road, La Porte, TX Harris","link":"/risk-management-plans/facility_accidents_view/1468"} |
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);