Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
102 rows where chemical_id = 3
This data as json, CSV (advanced)
quantity_released_lbs >30
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 68 | 100000134204_1_1 | 100000134204_1 | 16000.0 | 3 3 | |
| 112 | 100000073476_1_2 | 100000073476_1 | 783.0 | 3 3 | |
| 123 | 100000073476_2_1 | 100000073476_2 | 41000.0 | 3 3 | |
| 180 | 100000150347_1_1 | 100000150347_1 | 30.0 | 3 3 | |
| 186 | 100000150347_2_1 | 100000150347_2 | 25309.0 | 3 3 | |
| 193 | 100000150347_3_1 | 100000150347_3 | 5407.0 | 3 3 | |
| 246 | 100000064921_1_1 | 100000064921_1 | 20.0 | 3 3 | |
| 260 | 100000230886_1_1 | 100000230886_1 | 382.0 | 3 3 | |
| 274 | 100000072841_1_1 | 100000072841_1 | 5312.0 | 3 3 | |
| 446 | 100000210979_1_1 | 100000210979_1 | 43642.0 | 3 3 | |
| 492 | 100000075884_1_1 | 100000075884_1 | 50222.0 | 3 3 | |
| 600 | 100000106164_1_1 | 100000106164_1 | 17000.0 | 3 3 | |
| 608 | 100000106164_2_1 | 100000106164_2 | 8700.0 | 3 3 | |
| 640 | 100000002230_1_1 | 100000002230_1 | 6.0 | 3 3 | |
| 649 | 100000002230_2_1 | 100000002230_2 | 216665.0 | 3 3 | |
| 691 | 100000064654_1_1 | 100000064654_1 | 100.0 | 100.0 | 3 3 |
| 728 | 100000089548_1_1 | 100000089548_1 | 50.0 | 3 3 | |
| 735 | 100000099886_1_1 | 100000099886_1 | 9500.0 | 3 3 | |
| 743 | 100000099886_2_1 | 100000099886_2 | 25000.0 | 3 3 | |
| 746 | 100000105726_1_2 | 100000105726_1 | 6000000.0 | 3 3 | |
| 752 | 100000105726_1_8 | 100000105726_1 | 2300000.0 | 3 3 | |
| 764 | 100000126446_1_2 | 100000126446_1 | 907.0 | 3 3 | |
| 784 | 100000146834_1_1 | 100000146834_1 | 11.0 | 3 3 | |
| 811 | 100000215215_1_1 | 100000215215_1 | 100.0 | 3 3 | |
| 823 | 100000253771_1_1 | 100000253771_1 | 71.0 | 3 3 | |
| 868 | 100000110319_1_1 | 100000110319_1 | 180000.0 | 3 3 | |
| 1000 | 100000093533_2_1 | 100000093533_2 | 505.0 | 3 3 | |
| 1011 | 100000116581_1_1 | 100000116581_1 | 100.0 | 3 3 | |
| 1017 | 100000116581_2_1 | 100000116581_2 | 2818.0 | 3 3 | |
| 1023 | 100000143285_1_1 | 100000143285_1 | 300.0 | 3 3 | |
| 1024 | 100000143285_1_2 | 100000143285_1 | 3 3 | ||
| 1081 | 100000207901_1_1 | 100000207901_1 | 250.0 | 3 3 | |
| 1115 | 100000202121_1_1 | 100000202121_1 | 16247.0 | 3 3 | |
| 1167 | 100000151426_1_1 | 100000151426_1 | 4.0 | 3 3 | |
| 1207 | 100000032396_1_5 | 100000032396_1 | 7753.0 | 3 3 | |
| 1208 | 100000032396_1_6 | 100000032396_1 | 3 3 | ||
| 1220 | 100000066894_1_1 | 100000066894_1 | 1.0 | 3 3 | |
| 1228 | 100000088683_1_1 | 100000088683_1 | 91969.0 | 3 3 | |
| 1292 | 100000038318_1_1 | 100000038318_1 | 193000.0 | 3 3 | |
| 1301 | 100000055067_1_2 | 100000055067_1 | 458951.0 | 3 3 | |
| 1304 | 100000055067_1_5 | 100000055067_1 | 154407.0 | 3 3 | |
| 1316 | 100000123591_1_1 | 100000123591_1 | 99000.0 | 3 3 | |
| 1325 | 100000123591_2_1 | 100000123591_2 | 60000.0 | 3 3 | |
| 1332 | 100000146567_1_1 | 100000146567_1 | 40000.0 | 3 3 | |
| 1351 | 100000196806_1_1 | 100000196806_1 | 1131.0 | 3 3 | |
| 1362 | 100000239039_1_1 | 100000239039_1 | 370.0 | 3 3 | |
| 1391 | 100000022557_1_1 | 100000022557_1 | 800.0 | 3 3 | |
| 1395 | 100000028105_1_1 | 100000028105_1 | 8000.0 | 3 3 | |
| 1446 | 100000205191_1_1 | 100000205191_1 | 400.0 | 3 3 | |
| 1582 | 100000057528_1_1 | 100000057528_1 | 70000.0 | 3 3 | |
| 1600 | 100000059214_2_1 | 100000059214_2 | 132536.0 | 3 3 | |
| 1630 | 100000061764_1_1 | 100000061764_1 | 54000.0 | 3 3 | |
| 1638 | 100000062905_1_1 | 100000062905_1 | 244000.0 | 3 3 | |
| 1652 | 100000062905_3_2 | 100000062905_3 | 10898.0 | 3 3 | |
| 1659 | 100000067189_1_1 | 100000067189_1 | 630.0 | 3 3 | |
| 1664 | 100000067189_2_1 | 100000067189_2 | 2800.0 | 3 3 | |
| 1690 | 100000069515_4_1 | 100000069515_4 | 2798320.0 | 100.0 | 3 3 |
| 1702 | 100000069515_7_1 | 100000069515_7 | 70054.0 | 100.0 | 3 3 |
| 1722 | 100000080903_1_1 | 100000080903_1 | 53000.0 | 3 3 | |
| 1730 | 100000081243_1_1 | 100000081243_1 | 2935803.0 | 3 3 | |
| 1735 | 100000082796_1_1 | 100000082796_1 | 12721.0 | 3 3 | |
| 1744 | 100000082796_3_1 | 100000082796_3 | 472886.0 | 3 3 | |
| 1771 | 100000093445_1_1 | 100000093445_1 | 44000.0 | 3 3 | |
| 1779 | 100000107886_1_1 | 100000107886_1 | 3000.0 | 3 3 | |
| 1783 | 100000107886_2_2 | 100000107886_2 | 10466.0 | 3 3 | |
| 1790 | 100000112219_2_1 | 100000112219_2 | 50.0 | 3 3 | |
| 1798 | 100000112219_3_1 | 100000112219_3 | 50.0 | 3 3 | |
| 1807 | 100000112781_1_2 | 100000112781_1 | 63300.0 | 3 3 | |
| 1812 | 100000115314_1_1 | 100000115314_1 | 11337920.0 | 3 3 | |
| 1864 | 100000129693_1_1 | 100000129693_1 | 114968.0 | 3 3 | |
| 1872 | 100000129693_2_1 | 100000129693_2 | 20800.0 | 3 3 | |
| 1880 | 100000137372_1_1 | 100000137372_1 | 645600.0 | 3 3 | |
| 1904 | 100000137835_1_1 | 100000137835_1 | 3434.0 | 100.0 | 3 3 |
| 1910 | 100000146905_1_1 | 100000146905_1 | 5.0 | 3 3 | |
| 1916 | 100000147913_1_1 | 100000147913_1 | 624.0 | 3 3 | |
| 1924 | 100000147913_2_1 | 100000147913_2 | 12.0 | 3 3 | |
| 1950 | 100000157297_1_1 | 100000157297_1 | 251.0 | 3 3 | |
| 1957 | 100000157297_2_1 | 100000157297_2 | 185.0 | 3 3 | |
| 1968 | 100000163244_1_1 | 100000163244_1 | 8000.0 | 3 3 | |
| 1981 | 100000176953_1_1 | 100000176953_1 | 4.0 | 3 3 | |
| 1996 | 100000201364_1_1 | 100000201364_1 | 7800.0 | 3 3 | |
| 2001 | 100000201701_2_2 | 100000201701_2 | 1590.0 | 3 3 | |
| 2005 | 100000201701_3_1 | 100000201701_3 | 53.0 | 3 3 | |
| 2014 | 100000215288_1_1 | 100000215288_1 | 612.0 | 3 3 | |
| 2024 | 100000225785_1_1 | 100000225785_1 | 71755.0 | 3 3 | |
| 2045 | 100000231643_1_1 | 100000231643_1 | 2100.0 | 3 3 | |
| 2049 | 100000234007_2_1 | 100000234007_2 | 1.0 | 3 3 | |
| 2052 | 100000234007_3_1 | 100000234007_3 | 2690.0 | 3 3 | |
| 2059 | 100000235612_2_1 | 100000235612_2 | 500000.0 | 3 3 | |
| 2062 | 100000238174_1_1 | 100000238174_1 | 1036.0 | 3 3 | |
| 2070 | 100000242882_1_1 | 100000242882_1 | 19959.0 | 3 3 | |
| 2080 | 100000248984_1_1 | 100000248984_1 | 100.0 | 3 3 | |
| 2089 | 100000020327_2_1 | 100000020327_2 | 15790.0 | 3 3 | |
| 2107 | 100000156948_1_1 | 100000156948_1 | 10530.0 | 93.0 | 3 3 |
| 2163 | 100000099252_1_5 | 100000099252_1 | 4100.0 | 3 3 | |
| 2210 | 100000141401_1_1 | 100000141401_1 | 39000.0 | 3 3 | |
| 2238 | 100000020577_1_1 | 100000020577_1 | 1165.0 | 3 3 | |
| 2268 | 100000137434_1_1 | 100000137434_1 | 1.0 | 3 3 | |
| 2276 | 100000149715_1_1 | 100000149715_1 | 91.0 | 3 3 | |
| 2281 | 100000149715_2_1 | 100000149715_2 | 25.0 | 3 3 |
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)
);