Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

11 rows where city = "Crane" and facility_address = "13 mi. S of I-20 on FM1053"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accident_id, date_of_accident, chemical_name

facility_name 1

facility_address 1

  • 13 mi. S of I-20 on FM1053 · 11 ✖

city 1

  • Crane · 11 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
1659 Accident 1 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane February 2020 Flammable Mixture 630.0  
1660 Accident 1 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane February 2020 Isopentane [Butane, 2-methyl-]    
1661 Accident 1 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane February 2020 Isobutane [Propane, 2-methyl]    
1662 Accident 1 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane February 2020 Butane    
1663 Accident 1 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane February 2020 Pentane    
1664 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Flammable Mixture 2800.0  
1665 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Methane    
1666 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Ethane    
1667 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Propane    
1668 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Isobutane [Propane, 2-methyl]    
1669 Accident 2 100000067189 Sand Hills Plant 13 mi. S of I-20 on FM1053 Crane TX Crane September 2018 Butane    

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);