Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
183 rows where percent_weight = "100.0" 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 |
|---|---|---|---|---|---|
| 12 | 100000033545_1_1 | 100000033545_1 | 1.0 | 100.0 | 15 15 |
| 14 | 100000033545_3_1 | 100000033545_3 | 1.0 | 100.0 | 15 15 |
| 15 | 100000033545_4_1 | 100000033545_4 | 1.0 | 100.0 | 15 15 |
| 17 | 100000046915_1_1 | 100000046915_1 | 1.0 | 100.0 | 15 15 |
| 18 | 100000046915_2_1 | 100000046915_2 | 1.0 | 100.0 | 15 15 |
| 29 | 100000081092_1_1 | 100000081092_1 | 1.0 | 100.0 | 21 21 |
| 49 | 100000047558_2_1 | 100000047558_2 | 1.0 | 100.0 | 2 2 |
| 56 | 100000092384_1_1 | 100000092384_1 | 1.0 | 100.0 | 45 45 |
| 59 | 100000107895_1_1 | 100000107895_1 | 1.0 | 100.0 | 15 15 |
| 61 | 100000107895_3_1 | 100000107895_3 | 1.0 | 100.0 | 2 2 |
| 67 | 100000112282_1_1 | 100000112282_1 | 1.0 | 100.0 | 26 26 |
| 81 | 100000058082_1_1 | 100000058082_1 | 1.0 | 100.0 | 2 2 |
| 84 | 100000106592_1_1 | 100000106592_1 | 1.0 | 100.0 | 88 88 |
| 95 | 100000043099_1_1 | 100000043099_1 | 1.0 | 100.0 | 16 16 |
| 143 | 100000086382_1_1 | 100000086382_1 | 1.0 | 100.0 | 2 2 |
| 148 | 100000099555_1_1 | 100000099555_1 | 1.0 | 100.0 | 2 2 |
| 149 | 100000099555_2_1 | 100000099555_2 | 1.0 | 100.0 | 2 2 |
| 152 | 100000105478_1_1 | 100000105478_1 | 1.0 | 100.0 | 2 2 |
| 160 | 100000119187_1_1 | 100000119187_1 | 1.0 | 100.0 | 23 23 |
| 166 | 100000127347_1_1 | 100000127347_1 | 1.0 | 100.0 | 1 1 |
| 167 | 100000127711_1_1 | 100000127711_1 | 1.0 | 100.0 | 2 2 |
| 175 | 100000144658_1_1 | 100000144658_1 | 1.0 | 100.0 | 7 7 |
| 179 | 100000147824_1_1 | 100000147824_1 | 1.0 | 100.0 | 2 2 |
| 217 | 100000198074_1_1 | 100000198074_1 | 1.0 | 100.0 | 1 1 |
| 224 | 100000214715_1_1 | 100000214715_1 | 1.0 | 100.0 | 2 2 |
| 238 | 100000057537_2_1 | 100000057537_2 | 1.0 | 100.0 | 8 8 |
| 239 | 100000057537_3_1 | 100000057537_3 | 1.0 | 100.0 | 8 8 |
| 240 | 100000057537_4_1 | 100000057537_4 | 1.0 | 100.0 | 8 8 |
| 241 | 100000057537_5_1 | 100000057537_5 | 1.0 | 100.0 | 8 8 |
| 280 | 100000102364_1_1 | 100000102364_1 | 1.0 | 100.0 | 2 2 |
| 281 | 100000102364_2_1 | 100000102364_2 | 1.0 | 100.0 | 2 2 |
| 282 | 100000102364_2_2 | 100000102364_2 | 1.0 | 100.0 | 65 65 |
| 284 | 100000102364_4_1 | 100000102364_4 | 1.0 | 100.0 | 2 2 |
| 292 | 100000018651_2_1 | 100000018651_2 | 1.0 | 100.0 | 2 2 |
| 313 | 100000075508_1_1 | 100000075508_1 | 1.0 | 100.0 | 15 15 |
| 314 | 100000075508_2_1 | 100000075508_2 | 1.0 | 100.0 | 15 15 |
| 328 | 100000153193_1_1 | 100000153193_1 | 1.0 | 100.0 | 2 2 |
| 329 | 100000153193_2_1 | 100000153193_2 | 1.0 | 100.0 | 2 2 |
| 330 | 100000153193_3_1 | 100000153193_3 | 1.0 | 100.0 | 2 2 |
| 331 | 100000153193_4_1 | 100000153193_4 | 1.0 | 100.0 | 2 2 |
| 351 | 100000020639_1_1 | 100000020639_1 | 1.0 | 100.0 | 15 15 |
| 389 | 100000003907_1_1 | 100000003907_1 | 1.0 | 100.0 | 1 1 |
| 391 | 100000004817_1_1 | 100000004817_1 | 1.0 | 100.0 | 1 1 |
| 397 | 100000036187_1_1 | 100000036187_1 | 1.0 | 100.0 | 1 1 |
| 398 | 100000036187_2_1 | 100000036187_2 | 1.0 | 100.0 | 1 1 |
| 399 | 100000039175_1_1 | 100000039175_1 | 1.0 | 100.0 | 1 1 |
| 405 | 100000070497_1_1 | 100000070497_1 | 1.0 | 100.0 | 1 1 |
| 410 | 100000075919_1_1 | 100000075919_1 | 1.0 | 100.0 | 1 1 |
| 412 | 100000084703_1_1 | 100000084703_1 | 1.0 | 100.0 | 2 2 |
| 424 | 100000099519_1_1 | 100000099519_1 | 1.0 | 100.0 | 1 1 |
| 431 | 100000110998_1_1 | 100000110998_1 | 1.0 | 100.0 | 2 2 |
| 433 | 100000114976_1_1 | 100000114976_1 | 1.0 | 100.0 | 1 1 |
| 437 | 100000151792_1_1 | 100000151792_1 | 1.0 | 100.0 | 1 1 |
| 445 | 100000189627_1_1 | 100000189627_1 | 1.0 | 100.0 | 1 1 |
| 451 | 100000228915_1_1 | 100000228915_1 | 1.0 | 100.0 | 1 1 |
| 477 | 100000024369_1_1 | 100000024369_1 | 1.0 | 100.0 | 1 1 |
| 481 | 100000045159_1_1 | 100000045159_1 | 1.0 | 100.0 | 2 2 |
| 482 | 100000045159_2_1 | 100000045159_2 | 1.0 | 100.0 | 2 2 |
| 541 | 100000031921_1_1 | 100000031921_1 | 1.0 | 100.0 | 1 1 |
| 561 | 100000129489_1_1 | 100000129489_1 | 1.0 | 100.0 | 53 53 |
| 563 | 100000136756_1_1 | 100000136756_1 | 1.0 | 100.0 | 105 105 |
| 564 | 100000136756_2_1 | 100000136756_2 | 1.0 | 100.0 | 105 105 |
| 567 | 100000145372_1_1 | 100000145372_1 | 1.0 | 100.0 | 2 2 |
| 575 | 100000234249_1_1 | 100000234249_1 | 1.0 | 100.0 | 2 2 |
| 627 | 100000193346_1_1 | 100000193346_1 | 1.0 | 100.0 | 2 2 |
| 628 | 100000193346_2_1 | 100000193346_2 | 1.0 | 100.0 | 2 2 |
| 633 | 100000091866_2_1 | 100000091866_2 | 1.0 | 100.0 | 2 2 |
| 634 | 100000097156_1_1 | 100000097156_1 | 1.0 | 100.0 | 1 1 |
| 639 | 100000207732_1_1 | 100000207732_1 | 1.0 | 100.0 | 2 2 |
| 722 | 100000085061_10_1 | 100000085061_10 | 1.0 | 100.0 | 24 24 |
| 726 | 100000085061_14_1 | 100000085061_14 | 1.0 | 100.0 | 24 24 |
| 778 | 100000140199_1_1 | 100000140199_1 | 1.0 | 100.0 | 37 37 |
| 792 | 100000156127_5_1 | 100000156127_5 | 1.0 | 100.0 | 48 48 |
| 818 | 100000231536_1_1 | 100000231536_1 | 1.0 | 100.0 | 2 2 |
| 827 | 100000047184_1_1 | 100000047184_1 | 1.0 | 100.0 | 2 2 |
| 829 | 100000115029_1_1 | 100000115029_1 | 1.0 | 100.0 | 2 2 |
| 836 | 100000053899_1_1 | 100000053899_1 | 1.0 | 100.0 | 2 2 |
| 837 | 100000053899_2_1 | 100000053899_2 | 1.0 | 100.0 | 2 2 |
| 838 | 100000053899_2_2 | 100000053899_2 | 1.0 | 100.0 | 7 7 |
| 839 | 100000113432_1_1 | 100000113432_1 | 1.0 | 100.0 | 2 2 |
| 856 | 100000042232_1_1 | 100000042232_1 | 1.0 | 100.0 | 7 7 |
| 858 | 100000056841_1_1 | 100000056841_1 | 1.0 | 100.0 | 2 2 |
| 859 | 100000061746_1_1 | 100000061746_1 | 1.0 | 100.0 | 2 2 |
| 866 | 100000100026_1_1 | 100000100026_1 | 1.0 | 100.0 | 7 7 |
| 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 |
| 916 | 100000126133_1_1 | 100000126133_1 | 1.0 | 100.0 | 2 2 |
| 917 | 100000138139_1_1 | 100000138139_1 | 1.0 | 100.0 | 7 7 |
| 918 | 100000148128_1_1 | 100000148128_1 | 1.0 | 100.0 | 1 1 |
| 926 | 100000173769_1_1 | 100000173769_1 | 1.0 | 100.0 | 2 2 |
| 927 | 100000173769_2_1 | 100000173769_2 | 1.0 | 100.0 | 2 2 |
| 938 | 100000031048_1_1 | 100000031048_1 | 1.0 | 100.0 | 1 1 |
| 951 | 100000074634_1_1 | 100000074634_1 | 1.0 | 100.0 | 2 2 |
| 954 | 100000098985_1_1 | 100000098985_1 | 1.0 | 100.0 | 2 2 |
| 962 | 100000180216_1_1 | 100000180216_1 | 1.0 | 100.0 | 1 1 |
| 1033 | 100000065216_1_1 | 100000065216_1 | 1.0 | 100.0 | 70 70 |
| 1040 | 100000093301_1_1 | 100000093301_1 | 1.0 | 100.0 | 2 2 |
| 1047 | 100000130994_1_1 | 100000130994_1 | 1.0 | 100.0 | 71 71 |
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)
);