Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

17 rows where chemical_id = 8 and percent_weight = "100.0"

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 14

percent_weight 1

  • 100.0 · 17 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
237 100000057537_1_1 100000057537_1 266.0 100.0 8 8
238 100000057537_2_1 100000057537_2 1.0 100.0 8 8
239 100000057537_3_1 100000057537_3 1.0 100.0 8 8
240 100000057537_4_1 100000057537_4 1.0 100.0 8 8
241 100000057537_5_1 100000057537_5 1.0 100.0 8 8
243 100000057537_7_1 100000057537_7 165.0 100.0 8 8
244 100000057537_8_1 100000057537_8 500.0 100.0 8 8
345 100000183641_1_1 100000183641_1 160.0 100.0 8 8
795 100000169462_1_1 100000169462_1 6809.0 100.0 8 8
798 100000169462_2_2 100000169462_2 743.0 100.0 8 8
799 100000169462_3_1 100000169462_3 994.0 100.0 8 8
1198 100000153656_1_1 100000153656_1 710.0 100.0 8 8
1259 100000119686_1_1 100000119686_1 1890.0 100.0 8 8
1402 100000045989_1_1 100000045989_1 6.0 100.0 8 8
1718 100000079489_1_1 100000079489_1 11751.0 100.0 8 8
1720 100000079489_2_1 100000079489_2 2600.0 100.0 8 8
1860 100000125429_2_2 100000125429_2 275.0 100.0 8 8

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