Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

14 rows where facility_accident_id = "100000069515_3"

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 14

percent_weight 9

accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
1676 100000069515_3_1 100000069515_3 1358.0 7.1 11 11
1677 100000069515_3_2 100000069515_3 4041.0 21.0 10 10
1678 100000069515_3_3 100000069515_3 5794.0 30.1 44 44
1679 100000069515_3_4 100000069515_3 11.0 0.1 14 14
1680 100000069515_3_5 100000069515_3 1.0   94 94
1681 100000069515_3_6 100000069515_3 5765.0 30.0 17 17
1682 100000069515_3_7 100000069515_3 1603.0 8.3 4 4
1683 100000069515_3_8 100000069515_3 62.0 0.3 32 32
1684 100000069515_3_9 100000069515_3 525.0 2.7 85 85
1685 100000069515_3_10 100000069515_3 12.0 0.1 84 84
1686 100000069515_3_11 100000069515_3 15.0 0.1 5 5
1687 100000069515_3_12 100000069515_3 24.0 0.1 6 6
1688 100000069515_3_13 100000069515_3 8.0   76 76
1689 100000069515_3_14 100000069515_3 29.0 0.2 16 16

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