Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
98 rows where chemical_id = 5
This data as json, CSV (advanced)
quantity_released_lbs 25
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 91 | 100000173867_1_1 | 100000173867_1 | 3.0 | 5 5 | |
| 116 | 100000073476_1_6 | 100000073476_1 | 5 5 | ||
| 125 | 100000073476_2_3 | 100000073476_2 | 5 5 | ||
| 144 | 100000091713_1_1 | 100000091713_1 | 24938.0 | 5 5 | |
| 184 | 100000150347_1_5 | 100000150347_1 | 5 5 | ||
| 190 | 100000150347_2_5 | 100000150347_2 | 5 5 | ||
| 197 | 100000150347_3_5 | 100000150347_3 | 5 5 | ||
| 232 | 100000247155_1_1 | 100000247155_1 | 20.0 | 5 5 | |
| 252 | 100000064921_1_7 | 100000064921_1 | 5 5 | ||
| 266 | 100000230886_1_7 | 100000230886_1 | 5 5 | ||
| 276 | 100000072841_1_3 | 100000072841_1 | 5 5 | ||
| 383 | 100000234061_1_1 | 100000234061_1 | 7850.0 | 5 5 | |
| 448 | 100000210979_1_3 | 100000210979_1 | 5 5 | ||
| 496 | 100000075884_1_5 | 100000075884_1 | 5 5 | ||
| 606 | 100000106164_1_7 | 100000106164_1 | 5 5 | ||
| 614 | 100000106164_2_7 | 100000106164_2 | 5 5 | ||
| 646 | 100000002230_1_7 | 100000002230_1 | 5 5 | ||
| 655 | 100000002230_2_7 | 100000002230_2 | 5 5 | ||
| 662 | 100000039157_1_4 | 100000039157_1 | 556.0 | 5 5 | |
| 679 | 100000064146_1_6 | 100000064146_1 | 143.0 | 5 5 | |
| 687 | 100000064146_2_6 | 100000064146_2 | 1344.0 | 5 5 | |
| 697 | 100000064654_1_7 | 100000064654_1 | 5 5 | ||
| 739 | 100000099886_1_5 | 100000099886_1 | 5 5 | ||
| 750 | 100000105726_1_6 | 100000105726_1 | 5 5 | ||
| 756 | 100000105726_1_12 | 100000105726_1 | 5 5 | ||
| 816 | 100000215215_1_6 | 100000215215_1 | 5 5 | ||
| 1006 | 100000093533_2_7 | 100000093533_2 | 5 5 | ||
| 1012 | 100000116581_1_2 | 100000116581_1 | 5 5 | ||
| 1018 | 100000116581_2_2 | 100000116581_2 | 5 5 | ||
| 1060 | 100000189182_1_1 | 100000189182_1 | 5262.0 | 5 5 | |
| 1087 | 100000207901_1_7 | 100000207901_1 | 5 5 | ||
| 1091 | 100000214813_2_2 | 100000214813_2 | 1.0 | 5 5 | |
| 1203 | 100000032396_1_1 | 100000032396_1 | 12489.0 | 5 5 | |
| 1235 | 100000088683_1_8 | 100000088683_1 | 5 5 | ||
| 1297 | 100000038318_1_6 | 100000038318_1 | 5 5 | ||
| 1310 | 100000055067_1_11 | 100000055067_1 | 5 5 | ||
| 1320 | 100000123591_1_5 | 100000123591_1 | 5 5 | ||
| 1328 | 100000123591_2_4 | 100000123591_2 | 5 5 | ||
| 1338 | 100000146567_1_7 | 100000146567_1 | 5 5 | ||
| 1357 | 100000196806_1_7 | 100000196806_1 | 5 5 | ||
| 1368 | 100000239039_1_7 | 100000239039_1 | 5 5 | ||
| 1393 | 100000022557_1_3 | 100000022557_1 | 5 5 | ||
| 1449 | 100000205191_1_4 | 100000205191_1 | 5 5 | ||
| 1533 | 100000012522_1_5 | 100000012522_1 | 140.0 | 5 5 | |
| 1556 | 100000045033_1_9 | 100000045033_1 | 4762.0 | 5 5 | |
| 1561 | 100000048986_1_4 | 100000048986_1 | 4.0 | 5 5 | |
| 1566 | 100000052159_1_3 | 100000052159_1 | 11776.0 | 5 5 | |
| 1591 | 100000057528_1_10 | 100000057528_1 | 5 5 | ||
| 1598 | 100000059214_1_3 | 100000059214_1 | 1.0 | 5 5 | |
| 1608 | 100000059214_2_9 | 100000059214_2 | 5 5 | ||
| 1625 | 100000059214_3_3 | 100000059214_3 | 20000.0 | 5 5 | |
| 1636 | 100000061764_1_7 | 100000061764_1 | 5 5 | ||
| 1644 | 100000062905_1_7 | 100000062905_1 | 5 5 | ||
| 1650 | 100000062905_2_3 | 100000062905_2 | 109.0 | 5 5 | |
| 1656 | 100000063931_1_1 | 100000063931_1 | 143.0 | 5 5 | |
| 1662 | 100000067189_1_4 | 100000067189_1 | 5 5 | ||
| 1669 | 100000067189_2_6 | 100000067189_2 | 5 5 | ||
| 1686 | 100000069515_3_11 | 100000069515_3 | 15.0 | 0.1 | 5 5 |
| 1695 | 100000069515_4_6 | 100000069515_4 | 5 5 | ||
| 1700 | 100000069515_5_4 | 100000069515_5 | 3.0 | 0.5 | 5 5 |
| 1706 | 100000069515_7_5 | 100000069515_7 | 5 5 | ||
| 1710 | 100000070987_3_1 | 100000070987_3 | 350.0 | 5 5 | |
| 1728 | 100000080903_1_7 | 100000080903_1 | 5 5 | ||
| 1732 | 100000081243_1_3 | 100000081243_1 | 5 5 | ||
| 1741 | 100000082796_1_7 | 100000082796_1 | 5 5 | ||
| 1747 | 100000082796_3_4 | 100000082796_3 | 5 5 | ||
| 1761 | 100000090572_1_3 | 100000090572_1 | 25165.0 | 5 5 | |
| 1786 | 100000107886_2_5 | 100000107886_2 | 5 5 | ||
| 1796 | 100000112219_2_7 | 100000112219_2 | 5 5 | ||
| 1804 | 100000112219_3_7 | 100000112219_3 | 5 5 | ||
| 1819 | 100000115314_1_8 | 100000115314_1 | 5 5 | ||
| 1840 | 100000116634_1_4 | 100000116634_1 | 119.0 | 5 5 | |
| 1848 | 100000116812_1_3 | 100000116812_1 | 571.0 | 5 5 | |
| 1870 | 100000129693_1_7 | 100000129693_1 | 5 5 | ||
| 1888 | 100000137372_1_9 | 100000137372_1 | 5 5 | ||
| 1911 | 100000146905_1_2 | 100000146905_1 | 5 5 | ||
| 1921 | 100000147913_1_6 | 100000147913_1 | 5 5 | ||
| 1930 | 100000147913_2_7 | 100000147913_2 | 5 5 | ||
| 1954 | 100000157297_1_5 | 100000157297_1 | 5 5 | ||
| 1959 | 100000157297_2_3 | 100000157297_2 | 5 5 | ||
| 1966 | 100000162343_2_3 | 100000162343_2 | 453.0 | 5 5 | |
| 1973 | 100000163244_1_6 | 100000163244_1 | 5 5 | ||
| 2017 | 100000215288_1_4 | 100000215288_1 | 5 5 | ||
| 2020 | 100000218775_1_1 | 100000218775_1 | 1300.0 | 5 5 | |
| 2030 | 100000225785_1_7 | 100000225785_1 | 5 5 | ||
| 2048 | 100000234007_1_1 | 100000234007_1 | 36.0 | 5 5 | |
| 2056 | 100000234007_3_5 | 100000234007_3 | 5 5 | ||
| 2066 | 100000238174_1_5 | 100000238174_1 | 5 5 | ||
| 2076 | 100000242882_1_7 | 100000242882_1 | 5 5 | ||
| 2111 | 100000156948_1_5 | 100000156948_1 | 5 5 | ||
| 2177 | 100000099252_1_19 | 100000099252_1 | 5 5 | ||
| 2211 | 100000141401_1_2 | 100000141401_1 | 5 5 | ||
| 2244 | 100000020577_1_7 | 100000020577_1 | 5 5 | ||
| 2260 | 100000227541_1_1 | 100000227541_1 | 4006.0 | 5 5 | |
| 2274 | 100000137434_1_7 | 100000137434_1 | 5 5 | ||
| 2280 | 100000149715_1_5 | 100000149715_1 | 5 5 | ||
| 2289 | 100000149715_3_7 | 100000149715_3 | 5 5 | ||
| 2297 | 100000149715_4_7 | 100000149715_4 | 5 5 |
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)
);