Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
6 rows where city = "Texas City" and facility_address = "2401 5th Avenue South"
This data as json, CSV (advanced)
Suggested facets: accident_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1708 | Accident 1 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | December 2023 | Sulfur dioxide (anhydrous) | 10356.0 | 100.0 |
| 1709 | Accident 2 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | June 2023 | Sulfur dioxide (anhydrous) | 18543.0 | 100.0 |
| 1710 | Accident 3 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | May 2023 | Butane | 350.0 | |
| 1711 | Accident 3 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | May 2023 | Propane | 80.0 | |
| 1712 | Accident 3 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | May 2023 | Pentane | 900.0 | |
| 1713 | Accident 4 | 100000070987 | Blanchard Refining Company LLC - Galveston Bay Ref | 2401 5th Avenue South | Texas City | TX | Galveston | May 2021 | Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] | 74.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);