Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

27 rows where chemical_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 21

percent_weight 8

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
242 100000057537_6_1 100000057537_6 10.0 38.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
555 100000090536_1_2 100000090536_1 1447.0 15.0 8 8
776 100000137407_1_1 100000137407_1 431.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
1075 100000124652_1_1 100000124652_1 250.0 10.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
1454 100000250097_1_1 100000250097_1 1.0 1.0 8 8
1455 100000250097_2_1 100000250097_2 1.0 1.0 8 8
1522 100000229718_1_1 100000229718_1 14.0 30.0 8 8
1557 100000047889_1_1 100000047889_1 147.0 29.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
2040 100000230626_1_2 100000230626_1 6.0 0.1 8 8
2256 100000129684_1_1 100000129684_1 1470.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)
    );