Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

12 rows where facility_address = "25923 US Highway 81, P.O. Box 29" and facility_name = "MEDFORD FRACTIONATOR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_name

facility_name 1

  • MEDFORD FRACTIONATOR · 12 ✖

facility_address 1

  • 25923 US Highway 81, P.O. Box 29 · 12 ✖

city 1

accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
1300 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Propane 235188.0  
1301 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Flammable Mixture 458951.0  
1302 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Ethane    
1303 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Propane    
1304 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Flammable Mixture 154407.0  
1305 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Isopentane [Butane, 2-methyl-]    
1306 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Methane    
1307 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Ethane    
1308 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Propane    
1309 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Isobutane [Propane, 2-methyl]    
1310 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 Butane    
1311 Accident 1 100000055067 MEDFORD FRACTIONATOR 25923 US Highway 81, P.O. Box 29 Medford OK Grant July 2022 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);