home / risk_management_plans

Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

18 rows where city = "Billings"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id, chemical_name, quantity_released_lbs

facility_name 2

  • Par Montana Billings Refinery 17
  • Loveland Products, Inc.-Billings 1

facility_address 2

  • 700 Par Montana Road 17
  • 1525 Lockwood Road 1

city 1

  • Billings · 18 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
991 Accident 1 100000038773 Loveland Products, Inc.-Billings 1525 Lockwood Road Billings MT Yellowstone November 2015 Dimethylamine [Methanamine, N-methyl-] 1.0  
994 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Ethane 3.0  
995 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Methane 4.0  
996 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Propane 2.0  
997 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Ethylene [Ethene] 1.0  
998 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Hydrogen sulfide 1.0 0.1
999 Accident 1 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone June 2024 Hydrogen 6.0  
1000 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Flammable Mixture 505.0  
1001 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Isopentane [Butane, 2-methyl-]    
1002 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Methane    
1003 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Ethane    
1004 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Propane    
1005 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Isobutane [Propane, 2-methyl]    
1006 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Butane    
1007 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 1,3-Butadiene    
1008 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Pentane    
1009 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Propylene [1-Propene]    
1010 Accident 2 100000093533 Par Montana Billings Refinery 700 Par Montana Road Billings MT Yellowstone March 2022 Ethylene [Ethene]    

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