Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

13 rows where percent_weight = "100.0" and quantity_released_lbs = "100.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

quantity_released_lbs 1

  • 100.0 · 13 ✖

percent_weight 1

  • 100.0 · 13 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
9 100000150034_2_1 100000150034_2 100.0 100.0 1 1
10 100000011505_1_1 100000011505_1 100.0 100.0 2 2
511 100000125517_1_1 100000125517_1 100.0 100.0 7 7
538 100000207616_2_1 100000207616_2 100.0 100.0 1 1
691 100000064654_1_1 100000064654_1 100.0 100.0 3 3
794 100000165402_1_1 100000165402_1 100.0 100.0 2 2
970 100000017064_2_1 100000017064_2 100.0 100.0 13 13
1113 100000200169_1_1 100000200169_1 100.0 100.0 2 2
1227 100000085169_1_1 100000085169_1 100.0 100.0 63 63
1348 100000172225_1_1 100000172225_1 100.0 100.0 2 2
1461 100000086845_1_1 100000086845_1 100.0 100.0 1 1
1937 100000148048_1_1 100000148048_1 100.0 100.0 2 2
2115 100000193382_1_1 100000193382_1 100.0 100.0 10 10

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE rmp_accident_chemicals (
        accident_chemical_id INTEGER PRIMARY KEY,
        facility_accident_chemical_id TEXT,
        facility_accident_id TEXT,
        quantity_released_lbs TEXT,
        percent_weight TEXT,
        chemical_id INTEGER,
        FOREIGN KEY (facility_accident_id) REFERENCES rmp_facility_accidents(facility_accident_id),
        FOREIGN KEY (chemical_id) REFERENCES rmp_chemical(chemical_id)
    );