Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

3 rows where city = "PORT NECHES" and facility_address = "MAIN GATE PNO SITE, 6001 HIGHWAY 366"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, date_of_accident

facility_address 1

  • MAIN GATE PNO SITE, 6001 HIGHWAY 366 · 3 ✖

city 1

  • PORT NECHES · 3 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
1833 Accident 1 100000115779 Indorama Ventures Oxides - PORT NECHES OPERATIONS MAIN GATE PNO SITE, 6001 HIGHWAY 366 PORT NECHES TX Jefferson April 2021 Propylene [1-Propene] 291.0  
1834 Accident 1 100000115779 Indorama Ventures Oxides - PORT NECHES OPERATIONS MAIN GATE PNO SITE, 6001 HIGHWAY 366 PORT NECHES TX Jefferson April 2021 Propylene oxide [Oxirane, methyl-] 971.0 8.0
1835 Accident 2 100000115779 Indorama Ventures Oxides - PORT NECHES OPERATIONS MAIN GATE PNO SITE, 6001 HIGHWAY 366 PORT NECHES TX Jefferson February 2021 Ethylenediamine [1,2-Ethanediamine] 44.0 7.0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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