home / risk_management_plans

Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

8 rows where city = "Midkiff", facility_address = "10649 FM 1555" and facility_name = "Sonora Gas Plant"

✎ View and edit SQL

This data as json, CSV (advanced)

facility_name 1

  • Sonora Gas Plant · 8 ✖

facility_address 1

  • 10649 FM 1555 · 8 ✖

city 1

  • Midkiff · 8 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
2024 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Flammable Mixture 71755.0  
2025 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Isopentane [Butane, 2-methyl-]    
2026 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Methane    
2027 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Ethane    
2028 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Propane    
2029 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Isobutane [Propane, 2-methyl]    
2030 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Butane    
2031 Accident 1 100000225785 Sonora Gas Plant 10649 FM 1555 Midkiff TX Upton April 2020 Pentane    

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 1117.917ms · Data license: ODbL · Data source: EDGI Cloud Portal