home / risk_management_plans

Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

14 rows where facility_name = "Huntsman Advanced Materials Americas, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, date_of_accident, chemical_name

facility_name 1

  • Huntsman Advanced Materials Americas, LLC · 14 ✖

facility_address 1

  • 240 West Emerling Avenue 14

city 1

  • Akron 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
1260 Accident 1 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit April 2019 1,3-Butadiene 55.0  
1261 Accident 1 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit April 2019 Acrylonitrile [2-Propenenitrile] 42.0 100.0
1262 Accident 2 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit March 2019 1,3-Butadiene 31.0  
1263 Accident 3 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit July 2018 1,3-Butadiene 14750.0  
1264 Accident 4 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit October 2017 1,3-Butadiene 15.0  
1265 Accident 5 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit September 2017 Acrylonitrile [2-Propenenitrile] 181.0 100.0
1266 Accident 5 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit September 2017 1,3-Butadiene 46.0  
1267 Accident 6 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit June 2017 1,3-Butadiene 4924.0  
1268 Accident 6 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit June 2017 Acrylonitrile [2-Propenenitrile] 2101.0 100.0
1269 Accident 7 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit April 2017 1,3-Butadiene 14.0  
1270 Accident 8 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit February 2016 1,3-Butadiene 22.0  
1271 Accident 8 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit February 2016 Acrylonitrile [2-Propenenitrile] 143.0 100.0
1272 Accident 9 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit September 2015 1,3-Butadiene 388.0  
1273 Accident 10 100000127506 Huntsman Advanced Materials Americas, LLC 240 West Emerling Avenue Akron OH Summit July 2015 1,3-Butadiene 286.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);
Powered by Datasette · Queries took 410.625ms · Data license: ODbL · Data source: EDGI Cloud Portal