Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
3 rows where city = "La Porte" and facility_name = "Oxy Vinyls, LP - La Porte VCM Plant"
This data as json, CSV (advanced)
Suggested facets: date_of_accident, chemical_name
| accident_chemical_id ▼ | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | chemical_name | quantity_released_lbs | percent_weight |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1718 | Accident 1 | 100000079489 | Oxy Vinyls, LP - La Porte VCM Plant | 2400 Miller Cut-Off Road | La Porte | TX | Harris | August 2008 | Hydrochloric acid (conc 37% or greater) | 11751.0 | 100.0 |
| 1719 | Accident 1 | 100000079489 | Oxy Vinyls, LP - La Porte VCM Plant | 2400 Miller Cut-Off Road | La Porte | TX | Harris | August 2008 | Vinyl chloride [Ethene, chloro-] | 2.0 | 100.0 |
| 1720 | Accident 2 | 100000079489 | Oxy Vinyls, LP - La Porte VCM Plant | 2400 Miller Cut-Off Road | La Porte | TX | Harris | November 2004 | Hydrochloric acid (conc 37% or greater) | 2600.0 | 100.0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE accident_chemicals_view (
accident_chemical_id INTEGER PRIMARY KEY,
accident_id TEXT,
facility_id TEXT,
facility_name TEXT,
facility_address TEXT,
city TEXT,
state TEXT,
county TEXT,
date_of_accident TEXT,
chemical_name TEXT,
quantity_released_lbs TEXT,
percent_weight TEXT
);
CREATE INDEX idx_chemical_id ON accident_chemicals_view(accident_chemical_id);