Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

14 rows where city = "Superior"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_of_accident

facility_address 2

city 1

  • Superior · 14 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
2210 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Flammable Mixture 39000.0  
2211 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Butane    
2212 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Propane    
2213 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Ethane    
2214 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Methane    
2215 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Isopentane [Butane, 2-methyl-]    
2216 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Pentane    
2217 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Isobutane [Propane, 2-methyl]    
2218 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 2-Butene-trans [2-Butene, (E)]    
2219 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 2-Butene-cis    
2220 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 1-Butene    
2221 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Propylene [1-Propene]    
2222 Accident 1 100000141401 Superior Refining Company LLC 2407 Stinson Avenue Superior WI Douglas April 2018 Ethylene [Ethene]    
2223 Accident 1 100000150472 City of Superior Wastewater Div. Of Public Works 51 East First Street Superior WI Douglas April 2007 Chlorine 1.0 100.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);