Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

15 rows where chemical_id = 1, percent_weight = "100.0" and quantity_released_lbs = "2.0"

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 1

  • 2.0 · 15 ✖

percent_weight 1

  • 100.0 · 15 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
5 100000035678_2_1 100000035678_2 2.0 100.0 1 1
51 100000054772_1_1 100000054772_1 2.0 100.0 1 1
70 100000171164_1_1 100000171164_1 2.0 100.0 1 1
169 100000138059_1_1 100000138059_1 2.0 100.0 1 1
289 100000003792_1_1 100000003792_1 2.0 100.0 1 1
411 100000079684_1_1 100000079684_1 2.0 100.0 1 1
571 100000177006_1_1 100000177006_1 2.0 100.0 1 1
789 100000156127_2_1 100000156127_2 2.0 100.0 1 1
983 100000122048_1_1 100000122048_1 2.0 100.0 1 1
1150 100000148164_1_1 100000148164_1 2.0 100.0 1 1
1371 100000027384_1_1 100000027384_1 2.0 100.0 1 1
1496 100000136131_2_1 100000136131_2 2.0 100.0 1 1
2224 100000151881_1_1 100000151881_1 2.0 100.0 1 1
2225 100000151881_2_1 100000151881_2 2.0 100.0 1 1
2226 100000151881_3_1 100000151881_3 2.0 100.0 1 1

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