Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
9 rows where city = "Port Arthur" and facility_address = "1801 S. Gulfway Drive"
This data as json, CSV (advanced)
Suggested facets: quantity_released_lbs
| accident_chemical_id ▼ | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | chemical_name | quantity_released_lbs | percent_weight |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1837 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Pentane | 43.0 | |
| 1838 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Isopentane [Butane, 2-methyl-] | 119.0 | |
| 1839 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Isobutane [Propane, 2-methyl] | 42.0 | |
| 1840 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Butane | 119.0 | |
| 1841 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Propane | 113.0 | |
| 1842 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Ethane | 229.0 | |
| 1843 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Methane | 1997.0 | |
| 1844 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Hydrogen | 941.0 | |
| 1845 | Accident 1 | 100000116634 | Valero Port Arthur Refinery | 1801 S. Gulfway Drive | Port Arthur | TX | Jefferson | April 2023 | Hydrogen sulfide | 801.0 | 12.5 |
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);