Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
43 rows where chemical_id = 24
This data as json, CSV (advanced)
quantity_released_lbs 23
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 76 | 100000201462_1_1 | 100000201462_1 | 86.0 | 100.0 | 24 24 |
| 486 | 100000050749_1_1 | 100000050749_1 | 58.0 | 100.0 | 24 24 |
| 671 | 100000061069_1_1 | 100000061069_1 | 13.0 | 75.0 | 24 24 |
| 712 | 100000085061_1_1 | 100000085061_1 | 45.0 | 100.0 | 24 24 |
| 713 | 100000085061_2_1 | 100000085061_2 | 871.0 | 19.0 | 24 24 |
| 715 | 100000085061_3_1 | 100000085061_3 | 46.0 | 86.0 | 24 24 |
| 716 | 100000085061_4_1 | 100000085061_4 | 48.0 | 100.0 | 24 24 |
| 717 | 100000085061_5_1 | 100000085061_5 | 36.0 | 100.0 | 24 24 |
| 718 | 100000085061_6_1 | 100000085061_6 | 153.0 | 100.0 | 24 24 |
| 719 | 100000085061_7_1 | 100000085061_7 | 18.0 | 100.0 | 24 24 |
| 720 | 100000085061_8_1 | 100000085061_8 | 1.0 | 49.0 | 24 24 |
| 721 | 100000085061_9_1 | 100000085061_9 | 4.0 | 5.0 | 24 24 |
| 722 | 100000085061_10_1 | 100000085061_10 | 1.0 | 100.0 | 24 24 |
| 723 | 100000085061_11_1 | 100000085061_11 | 31.0 | 100.0 | 24 24 |
| 724 | 100000085061_12_1 | 100000085061_12 | 42.0 | 100.0 | 24 24 |
| 725 | 100000085061_13_1 | 100000085061_13 | 1.0 | 49.0 | 24 24 |
| 726 | 100000085061_14_1 | 100000085061_14 | 1.0 | 100.0 | 24 24 |
| 864 | 100000096086_1_1 | 100000096086_1 | 1.0 | 70.0 | 24 24 |
| 865 | 100000096086_2_1 | 100000096086_2 | 49.0 | 70.0 | 24 24 |
| 880 | 100000149387_2_1 | 100000149387_2 | 1.0 | 100.0 | 24 24 |
| 881 | 100000149387_3_1 | 100000149387_3 | 1.0 | 100.0 | 24 24 |
| 882 | 100000149387_4_1 | 100000149387_4 | 1.0 | 100.0 | 24 24 |
| 884 | 100000149387_6_1 | 100000149387_6 | 1.0 | 100.0 | 24 24 |
| 1163 | 100000063487_1_1 | 100000063487_1 | 1.0 | 100.0 | 24 24 |
| 1165 | 100000063487_2_2 | 100000063487_2 | 1.0 | 1.0 | 24 24 |
| 1245 | 100000110293_1_1 | 100000110293_1 | 1.0 | 1.0 | 24 24 |
| 1246 | 100000110293_2_1 | 100000110293_2 | 1.0 | 1.0 | 24 24 |
| 1247 | 100000110293_3_1 | 100000110293_3 | 10.0 | 10.0 | 24 24 |
| 1248 | 100000110293_4_1 | 100000110293_4 | 1.0 | 1.0 | 24 24 |
| 1249 | 100000110293_5_1 | 100000110293_5 | 2.0 | 2.0 | 24 24 |
| 1404 | 100000050865_1_1 | 100000050865_1 | 1.0 | 70.0 | 24 24 |
| 1429 | 100000098191_1_1 | 100000098191_1 | 1.0 | 70.0 | 24 24 |
| 1435 | 100000130244_1_1 | 100000130244_1 | 1.0 | 100.0 | 24 24 |
| 1442 | 100000170744_1_1 | 100000170744_1 | 1.0 | 70.0 | 24 24 |
| 1546 | 100000034312_1_1 | 100000034312_1 | 1.0 | 100.0 | 24 24 |
| 1571 | 100000055307_1_1 | 100000055307_1 | 4946.0 | 100.0 | 24 24 |
| 1628 | 100000059214_3_6 | 100000059214_3 | 140.0 | 100.0 | 24 24 |
| 1713 | 100000070987_4_1 | 100000070987_4 | 74.0 | 100.0 | 24 24 |
| 1717 | 100000078818_1_1 | 100000078818_1 | 3500.0 | 40.0 | 24 24 |
| 1782 | 100000107886_2_1 | 100000107886_2 | 945.0 | 0.7 | 24 24 |
| 1806 | 100000112781_1_1 | 100000112781_1 | 11100.0 | 15.0 | 24 24 |
| 2038 | 100000229068_1_1 | 100000229068_1 | 1.0 | 50.0 | 24 24 |
| 2088 | 100000020327_1_1 | 100000020327_1 | 1.0 | 100.0 | 24 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);