home / risk_management_plans

Accident Chemicals View

Data table with 2,301 records and 12 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

8 rows where city = "Beaumont" and facility_address = "No. 1 Gulf States Road"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: percent_weight

facility_name 1

  • Neches Terminal 8

facility_address 1

  • No. 1 Gulf States Road · 8 ✖

city 1

  • Beaumont · 8 ✖
accident_chemical_id ▼ accident_id facility_id facility_name facility_address city state county date_of_accident chemical_name quantity_released_lbs percent_weight
1574 Accident 1 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson September 2020 Ammonia (anhydrous) 89.0 100.0
1575 Accident 2 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson February 2019 Ammonia (anhydrous) 79.0 100.0
1576 Accident 3 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson July 2018 Ammonia (anhydrous) 26.0 100.0
1577 Accident 4 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson June 2018 Ammonia (anhydrous) 11.0 100.0
1578 Accident 5 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson December 2016 Ammonia (anhydrous) 613.0 100.0
1579 Accident 6 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson October 2014 Ammonia (anhydrous) 175.0 100.0
1580 Accident 7 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson November 2012 Ammonia (anhydrous) 2070.0 100.0
1581 Accident 8 100000057323 Neches Terminal No. 1 Gulf States Road Beaumont TX Jefferson June 2008 Ammonia (anhydrous) 250.0 99.9

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