Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
134 rows where chemical_id = 4
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 |
|---|---|---|---|---|---|
| 52 | 100000063441_1_1 | 100000063441_1 | 70.0 | 81.0 | 4 4 |
| 101 | 100000049351_1_1 | 100000049351_1 | 1225.0 | 4 4 | |
| 121 | 100000073476_1_11 | 100000073476_1 | 4 4 | ||
| 124 | 100000073476_2_2 | 100000073476_2 | 4 4 | ||
| 183 | 100000150347_1_4 | 100000150347_1 | 4 4 | ||
| 189 | 100000150347_2_4 | 100000150347_2 | 4 4 | ||
| 196 | 100000150347_3_4 | 100000150347_3 | 4 4 | ||
| 214 | 100000175847_1_1 | 100000175847_1 | 736.0 | 4 4 | |
| 236 | 100000051971_1_1 | 100000051971_1 | 992.0 | 4 4 | |
| 250 | 100000064921_1_5 | 100000064921_1 | 4 4 | ||
| 253 | 100000076552_1_1 | 100000076552_1 | 12.0 | 4 4 | |
| 264 | 100000230886_1_5 | 100000230886_1 | 4 4 | ||
| 271 | 100000164886_1_1 | 100000164886_1 | 7.0 | 4 4 | |
| 272 | 100000164886_2_1 | 100000164886_2 | 14.0 | 4 4 | |
| 348 | 100000218089_1_1 | 100000218089_1 | 2.0 | 4 4 | |
| 494 | 100000075884_1_3 | 100000075884_1 | 4 4 | ||
| 520 | 100000147842_1_1 | 100000147842_1 | 15000.0 | 4 4 | |
| 523 | 100000149804_1_1 | 100000149804_1 | 1.0 | 4 4 | |
| 525 | 100000165509_1_1 | 100000165509_1 | 173.0 | 4 4 | |
| 531 | 100000186728_1_1 | 100000186728_1 | 9000.0 | 4 4 | |
| 534 | 100000199055_1_1 | 100000199055_1 | 20.0 | 4 4 | |
| 570 | 100000165947_1_1 | 100000165947_1 | 130.0 | 4 4 | |
| 604 | 100000106164_1_5 | 100000106164_1 | 4 4 | ||
| 612 | 100000106164_2_5 | 100000106164_2 | 4 4 | ||
| 631 | 100000084375_1_2 | 100000084375_1 | 57345.0 | 4 4 | |
| 644 | 100000002230_1_5 | 100000002230_1 | 4 4 | ||
| 653 | 100000002230_2_5 | 100000002230_2 | 4 4 | ||
| 661 | 100000039157_1_3 | 100000039157_1 | 130.0 | 4 4 | |
| 673 | 100000061924_1_1 | 100000061924_1 | 50.0 | 4 4 | |
| 680 | 100000064146_1_7 | 100000064146_1 | 957.0 | 4 4 | |
| 684 | 100000064146_2_3 | 100000064146_2 | 4334.0 | 4 4 | |
| 695 | 100000064654_1_5 | 100000064654_1 | 4 4 | ||
| 738 | 100000099886_1_4 | 100000099886_1 | 4 4 | ||
| 748 | 100000105726_1_4 | 100000105726_1 | 4 4 | ||
| 754 | 100000105726_1_10 | 100000105726_1 | 4 4 | ||
| 775 | 100000137158_1_1 | 100000137158_1 | 100.0 | 4 4 | |
| 814 | 100000215215_1_4 | 100000215215_1 | 4 4 | ||
| 817 | 100000215215_2_1 | 100000215215_2 | 10.0 | 4 4 | |
| 831 | 100000167829_1_1 | 100000167829_1 | 5.0 | 4 4 | |
| 872 | 100000120772_1_1 | 100000120772_1 | 5.0 | 4 4 | |
| 873 | 100000120772_2_1 | 100000120772_2 | 13600.0 | 4 4 | |
| 879 | 100000149387_1_1 | 100000149387_1 | 1.0 | 4 4 | |
| 883 | 100000149387_5_1 | 100000149387_5 | 12000.0 | 4 4 | |
| 921 | 100000158982_1_1 | 100000158982_1 | 8190.0 | 4 4 | |
| 996 | 100000093533_1_3 | 100000093533_1 | 2.0 | 4 4 | |
| 1004 | 100000093533_2_5 | 100000093533_2 | 4 4 | ||
| 1035 | 100000073485_1_2 | 100000073485_1 | 50.0 | 4 4 | |
| 1037 | 100000073485_2_2 | 100000073485_2 | 240.0 | 4 4 | |
| 1085 | 100000207901_1_5 | 100000207901_1 | 4 4 | ||
| 1089 | 100000214813_1_1 | 100000214813_1 | 5000.0 | 4 4 | |
| 1093 | 100000214813_2_4 | 100000214813_2 | 2.0 | 4 4 | |
| 1164 | 100000063487_2_1 | 100000063487_2 | 93.0 | 4 4 | |
| 1170 | 100000151426_1_4 | 100000151426_1 | 4 4 | ||
| 1173 | 100000057733_1_1 | 100000057733_1 | 39400.0 | 4 4 | |
| 1192 | 100000129336_1_3 | 100000129336_1 | 1.0 | 22.0 | 4 4 |
| 1205 | 100000032396_1_3 | 100000032396_1 | 6555.0 | 4 4 | |
| 1233 | 100000088683_1_6 | 100000088683_1 | 4 4 | ||
| 1296 | 100000038318_1_5 | 100000038318_1 | 4 4 | ||
| 1300 | 100000055067_1_1 | 100000055067_1 | 235188.0 | 4 4 | |
| 1303 | 100000055067_1_4 | 100000055067_1 | 4 4 | ||
| 1308 | 100000055067_1_9 | 100000055067_1 | 4 4 | ||
| 1318 | 100000123591_1_3 | 100000123591_1 | 4 4 | ||
| 1336 | 100000146567_1_5 | 100000146567_1 | 4 4 | ||
| 1355 | 100000196806_1_5 | 100000196806_1 | 4 4 | ||
| 1360 | 100000213501_1_2 | 100000213501_1 | 20.0 | 4 4 | |
| 1366 | 100000239039_1_5 | 100000239039_1 | 4 4 | ||
| 1392 | 100000022557_1_2 | 100000022557_1 | 4 4 | ||
| 1396 | 100000028105_1_2 | 100000028105_1 | 4 4 | ||
| 1459 | 100000148057_1_1 | 100000148057_1 | 26899.0 | 4 4 | |
| 1534 | 100000012522_1_6 | 100000012522_1 | 160.0 | 4 4 | |
| 1551 | 100000045033_1_4 | 100000045033_1 | 7727.0 | 4 4 | |
| 1560 | 100000048986_1_3 | 100000048986_1 | 7.0 | 4 4 | |
| 1565 | 100000052159_1_2 | 100000052159_1 | 13177.0 | 4 4 | |
| 1594 | 100000057528_1_13 | 100000057528_1 | 4 4 | ||
| 1596 | 100000059214_1_1 | 100000059214_1 | 1.0 | 4 4 | |
| 1606 | 100000059214_2_7 | 100000059214_2 | 4 4 | ||
| 1623 | 100000059214_3_1 | 100000059214_3 | 6500.0 | 4 4 | |
| 1634 | 100000061764_1_5 | 100000061764_1 | 4 4 | ||
| 1642 | 100000062905_1_5 | 100000062905_1 | 4 4 | ||
| 1648 | 100000062905_2_1 | 100000062905_2 | 122.0 | 4 4 | |
| 1653 | 100000062905_3_3 | 100000062905_3 | 4 4 | ||
| 1657 | 100000063931_1_2 | 100000063931_1 | 128.0 | 4 4 | |
| 1667 | 100000067189_2_4 | 100000067189_2 | 4 4 | ||
| 1672 | 100000069515_2_2 | 100000069515_2 | 16.0 | 0.4 | 4 4 |
| 1682 | 100000069515_3_7 | 100000069515_3 | 1603.0 | 8.3 | 4 4 |
| 1694 | 100000069515_4_5 | 100000069515_4 | 4 4 | ||
| 1697 | 100000069515_5_1 | 100000069515_5 | 161.0 | 25.6 | 4 4 |
| 1705 | 100000069515_7_4 | 100000069515_7 | 4 4 | ||
| 1711 | 100000070987_3_2 | 100000070987_3 | 80.0 | 4 4 | |
| 1726 | 100000080903_1_5 | 100000080903_1 | 4 4 | ||
| 1731 | 100000081243_1_2 | 100000081243_1 | 4 4 | ||
| 1739 | 100000082796_1_5 | 100000082796_1 | 4 4 | ||
| 1743 | 100000082796_2_1 | 100000082796_2 | 50065.0 | 4 4 | |
| 1745 | 100000082796_3_2 | 100000082796_3 | 4 4 | ||
| 1762 | 100000090572_1_4 | 100000090572_1 | 30131.0 | 4 4 | |
| 1768 | 100000092142_1_5 | 100000092142_1 | 1.0 | 4 4 | |
| 1784 | 100000107886_2_3 | 100000107886_2 | 4 4 | ||
| 1794 | 100000112219_2_5 | 100000112219_2 | 4 4 | ||
| 1802 | 100000112219_3_5 | 100000112219_3 | 4 4 | ||
| 1829 | 100000115314_1_18 | 100000115314_1 | 4 4 |
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)
);