Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
21 rows where chemical_id = 24 and quantity_released_lbs = "1.0"
This data as json, CSV (advanced)
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 720 | 100000085061_8_1 | 100000085061_8 | 1.0 | 49.0 | 24 24 |
| 722 | 100000085061_10_1 | 100000085061_10 | 1.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 |
| 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 |
| 1248 | 100000110293_4_1 | 100000110293_4 | 1.0 | 1.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 |
| 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)
);