Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

12 rows where chemical_id = 14

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 9

percent_weight 2

accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
536 100000205869_1_1 100000205869_1 5.0   14 14
933 100000249402_1_1 100000249402_1 1.0   14 14
1125 100000034385_1_1 100000034385_1 2.0 100.0 14 14
1157 100000200935_1_1 100000200935_1 1.0   14 14
1158 100000200935_2_1 100000200935_2 3.0   14 14
1159 100000200935_3_1 100000200935_3 1.0   14 14
1160 100000200935_4_1 100000200935_4 10.0   14 14
1222 100000072155_1_1 100000072155_1 52.0   14 14
1679 100000069515_3_4 100000069515_3 11.0 0.1 14 14
1884 100000137372_1_5 100000137372_1     14 14
2061 100000236531_1_1 100000236531_1 8500.0   14 14
2152 100000075642_1_1 100000075642_1 918.0   14 14

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