Accident Chemicals View
Data license: ODbL · Data source: EDGI Cloud Portal
8 rows where city = "Beaumont" and facility_address = "No. 1 Gulf States Road"
This data as json, CSV (advanced)
Suggested facets: percent_weight
| accident_chemical_id ▼ | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | chemical_name | quantity_released_lbs | percent_weight |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1574 | Accident 1 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | September 2020 | Ammonia (anhydrous) | 89.0 | 100.0 |
| 1575 | Accident 2 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | February 2019 | Ammonia (anhydrous) | 79.0 | 100.0 |
| 1576 | Accident 3 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | July 2018 | Ammonia (anhydrous) | 26.0 | 100.0 |
| 1577 | Accident 4 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | June 2018 | Ammonia (anhydrous) | 11.0 | 100.0 |
| 1578 | Accident 5 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | December 2016 | Ammonia (anhydrous) | 613.0 | 100.0 |
| 1579 | Accident 6 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | October 2014 | Ammonia (anhydrous) | 175.0 | 100.0 |
| 1580 | Accident 7 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | November 2012 | Ammonia (anhydrous) | 2070.0 | 100.0 |
| 1581 | Accident 8 | 100000057323 | Neches Terminal | No. 1 Gulf States Road | Beaumont | TX | Jefferson | June 2008 | Ammonia (anhydrous) | 250.0 | 99.9 |
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);