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 city = "La Porte"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, facility_id, date_of_accident, chemical_name, quantity_released_lbs, percent_weight

facility_name 6

  • Kuraray La Porte 3
  • La Porte Plant 3
  • Oxy Vinyls, LP - La Porte VCM Plant 3
  • INEOS O&P USA LLC - Battleground Manufacturing 2
  • Mitsubishi Chemical La Porte 2
  • Chemours La Porte Plant 1

facility_address 6

  • 12342 Strang Road 3
  • 12501 Strang Road 3
  • 2400 Miller Cut-Off Road 3
  • 12220 Strang Road 2
  • 1230 Independence Parkway South 2
  • 12350 Strang Road 1

city 1

  • La Porte · 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
1718 Accident 1 100000079489 Oxy Vinyls, LP - La Porte VCM Plant 2400 Miller Cut-Off Road La Porte TX Harris August 2008 Hydrochloric acid (conc 37% or greater) 11751.0 100.0
1719 Accident 1 100000079489 Oxy Vinyls, LP - La Porte VCM Plant 2400 Miller Cut-Off Road La Porte TX Harris August 2008 Vinyl chloride [Ethene, chloro-] 2.0 100.0
1720 Accident 2 100000079489 Oxy Vinyls, LP - La Porte VCM Plant 2400 Miller Cut-Off Road La Porte TX Harris November 2004 Hydrochloric acid (conc 37% or greater) 2600.0 100.0
1850 Accident 1 100000117438 Mitsubishi Chemical La Porte 12220 Strang Road La Porte TX Harris February 2017 Vinyl acetylene [1-Buten-3-yne] 12856.0  
1851 Accident 1 100000117438 Mitsubishi Chemical La Porte 12220 Strang Road La Porte TX Harris February 2017 Ethylene [Ethene] 72.0  
1940 Accident 1 100000148912 La Porte Plant 12501 Strang Road La Porte TX Harris November 2014 Methyl mercaptan [Methanethiol] 23649.0 100.0
1941 Accident 1 100000148912 La Porte Plant 12501 Strang Road La Porte TX Harris November 2014 Sulfur dioxide (anhydrous) 36.0 100.0
1942 Accident 2 100000148912 La Porte Plant 12501 Strang Road La Porte TX Harris March 2011 Chlorine 1.0 6.0
1981 Accident 1 100000176953 INEOS O&P USA LLC - Battleground Manufacturing 1230 Independence Parkway South La Porte TX Harris January 2018 Flammable Mixture 4.0  
1982 Accident 1 100000176953 INEOS O&P USA LLC - Battleground Manufacturing 1230 Independence Parkway South La Porte TX Harris January 2018 Propylene [1-Propene]    
2032 Accident 1 100000225909 Kuraray La Porte 12342 Strang Road La Porte TX Harris January 2018 Ethylene [Ethene] 150.0  
2033 Accident 2 100000225909 Kuraray La Porte 12342 Strang Road La Porte TX Harris April 2017 Ethylene [Ethene] 226.0  
2034 Accident 3 100000225909 Kuraray La Porte 12342 Strang Road La Porte TX Harris September 2016 Ethylene [Ethene] 625.0  
2038 Accident 1 100000229068 Chemours La Porte Plant 12350 Strang Road La Porte TX Harris October 2019 Hydrogen fluoride/Hydrofluoric acid (conc 50% or greater) [Hydrofluoric acid] 1.0 50.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 2330.434ms · Data license: ODbL · Data source: EDGI Cloud Portal