Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
1 row where city = "Corpus Christi" and facility_name = "Valero Corpus Christi Refineries - East Plant"
This data as json, CSV (advanced)
facility_name 1
- Valero Corpus Christi Refineries - East Plant · 1 ✖
facility_address 1
city 1
- Corpus Christi · 1 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 204 | 100000045033_1 | Accident 1 | 100000045033 | Valero Corpus Christi Refineries - East Plant | 1300 Cantwell Lane | Corpus Christi | TX | Nueces | November 2022 | 05:50 | 084 Hours 55 Minutes | 32411 | Flammable Mixture, Isopentane [Butane, 2-methyl-], Methane, Ethane, Propane, Isobutane [Propane, 2-methyl], Butane, 1-Butene, Pentane, 2-Methylpropene [1-Propene, 2-methyl-], 2-Butene-cis, 2-Butene-trans [2-Butene, (E)], Hydrogen, Propylene [1-Propene], Ethylene [Ethene], 2,2-Dimethylpropane [Propane, 2,2-dimethyl-], Butene | 27.812861 | -97.439917 | {"title":"Valero Corpus Christi Refineries - East Plant","description":"1300 Cantwell Lane, Corpus Christi, TX Nueces","link":"/risk-management-plans/facility_accidents_view/204"} |
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);