Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
21 rows where facility_address = "6701 FM 119" and facility_name = "Valero McKee Refinery"
This data as json, CSV (advanced)
Suggested facets: accident_id, date_of_accident
| accident_chemical_id ▼ | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | chemical_name | quantity_released_lbs | percent_weight |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1916 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Flammable Mixture | 624.0 | |
| 1917 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Isopentane [Butane, 2-methyl-] | ||
| 1918 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Ethane | ||
| 1919 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Propane | ||
| 1920 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Isobutane [Propane, 2-methyl] | ||
| 1921 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Butane | ||
| 1922 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Pentane | ||
| 1923 | Accident 1 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | March 2021 | Propylene [1-Propene] | ||
| 1924 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Flammable Mixture | 12.0 | |
| 1925 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Isopentane [Butane, 2-methyl-] | ||
| 1926 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Methane | ||
| 1927 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Ethane | ||
| 1928 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Propane | ||
| 1929 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Isobutane [Propane, 2-methyl] | ||
| 1930 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Butane | ||
| 1931 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | 1-Butene | ||
| 1932 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | 2-Butene | ||
| 1933 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Pentane | ||
| 1934 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Propylene [1-Propene] | ||
| 1935 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Hydrogen | ||
| 1936 | Accident 2 | 100000147913 | Valero McKee Refinery | 6701 FM 119 | Sunray | TX | Moore | December 2020 | Ethylene [Ethene] |
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);