home / risk_management_plans

Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

9 rows where city = "Port Arthur" and facility_address = "1801 S. Gulfway Drive"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: quantity_released_lbs

facility_name 1

  • Valero Port Arthur Refinery 9

facility_address 1

  • 1801 S. Gulfway Drive · 9 ✖

city 1

  • Port Arthur · 9 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
1837 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Pentane 43.0  
1838 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Isopentane [Butane, 2-methyl-] 119.0  
1839 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Isobutane [Propane, 2-methyl] 42.0  
1840 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Butane 119.0  
1841 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Propane 113.0  
1842 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Ethane 229.0  
1843 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Methane 1997.0  
1844 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Hydrogen 941.0  
1845 Accident 1 100000116634 Valero Port Arthur Refinery 1801 S. Gulfway Drive Port Arthur TX Jefferson April 2023 Hydrogen sulfide 801.0 12.5

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);
Powered by Datasette · Queries took 1125.605ms · Data license: ODbL · Data source: EDGI Cloud Portal