Accident Chemicals View

Data license: ODbL · Data source: EDGI Cloud Portal

17 rows where facility_address = "PO Box 207, 6 miles E on Hwy 67" and facility_name = "Big Lake Treating Facility"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, date_of_accident, chemical_name, quantity_released_lbs

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);