Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
24 rows where chemical_id = 17
This data as json, CSV (advanced)
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 90 | 100000164813_1_1 | 100000164813_1 | 40000.0 | 17 17 | |
| 122 | 100000073476_1_12 | 100000073476_1 | 17 17 | ||
| 137 | 100000073476_2_15 | 100000073476_2 | 17 17 | ||
| 740 | 100000099886_1_6 | 100000099886_1 | 17 17 | ||
| 1009 | 100000093533_2_10 | 100000093533_2 | 17 17 | ||
| 1015 | 100000116581_1_5 | 100000116581_1 | 17 17 | ||
| 1021 | 100000116581_2_5 | 100000116581_2 | 17 17 | ||
| 1340 | 100000146567_1_9 | 100000146567_1 | 17 17 | ||
| 1593 | 100000057528_1_12 | 100000057528_1 | 17 17 | ||
| 1605 | 100000059214_2_6 | 100000059214_2 | 17 17 | ||
| 1674 | 100000069515_2_4 | 100000069515_2 | 21.0 | 0.5 | 17 17 |
| 1681 | 100000069515_3_6 | 100000069515_3 | 5765.0 | 30.0 | 17 17 |
| 1698 | 100000069515_5_2 | 100000069515_5 | 462.0 | 73.6 | 17 17 |
| 1769 | 100000092142_1_6 | 100000092142_1 | 1.0 | 17 17 | |
| 1830 | 100000115314_1_19 | 100000115314_1 | 17 17 | ||
| 1833 | 100000115779_1_1 | 100000115779_1 | 291.0 | 17 17 | |
| 1893 | 100000137372_1_14 | 100000137372_1 | 17 17 | ||
| 1923 | 100000147913_1_8 | 100000147913_1 | 17 17 | ||
| 1934 | 100000147913_2_11 | 100000147913_2 | 17 17 | ||
| 1982 | 100000176953_1_2 | 100000176953_1 | 17 17 | ||
| 2013 | 100000201863_1_6 | 100000201863_1 | 1.0 | 17 17 | |
| 2019 | 100000217151_1_1 | 100000217151_1 | 744.0 | 17 17 | |
| 2167 | 100000099252_1_9 | 100000099252_1 | 17 17 | ||
| 2221 | 100000141401_1_12 | 100000141401_1 | 17 17 |
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)
);