Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
2 rows where city = "Corpus Christi" and facility_name = "CITGO Corpus Christi Refinery East Plant"
This data as json, CSV (advanced)
facility_name 1
- CITGO Corpus Christi Refinery East Plant · 2 ✖
facility_address 1
city 1
- Corpus Christi · 2 ✖
| accident_chemical_id ▼ | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | chemical_name | quantity_released_lbs | percent_weight |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1907 | Accident 1 | 100000139566 | CITGO Corpus Christi Refinery East Plant | 1801 Nueces Bay Blvd. | Corpus Christi | TX | Nueces | March 2023 | Hydrogen sulfide | 6.0 | 100.0 |
| 1908 | Accident 2 | 100000139566 | CITGO Corpus Christi Refinery East Plant | 1801 Nueces Bay Blvd. | Corpus Christi | TX | Nueces | December 2019 | Hydrogen | 1.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);