Rmp Accident Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
347 rows where chemical_id = 1 and percent_weight = "100.0"
This data as json, CSV (advanced)
quantity_released_lbs >30
percent_weight 1
- 100.0 · 347 ✖
| accident_chemical_id ▼ | facility_accident_chemical_id | facility_accident_id | quantity_released_lbs | percent_weight | chemical_id |
|---|---|---|---|---|---|
| 1 | 100000024252_1_1 | 100000024252_1 | 39.0 | 100.0 | 1 1 |
| 2 | 100000024289_1_1 | 100000024289_1 | 24.0 | 100.0 | 1 1 |
| 3 | 100000024289_2_1 | 100000024289_2 | 20.0 | 100.0 | 1 1 |
| 5 | 100000035678_2_1 | 100000035678_2 | 2.0 | 100.0 | 1 1 |
| 9 | 100000150034_2_1 | 100000150034_2 | 100.0 | 100.0 | 1 1 |
| 20 | 100000050044_1_1 | 100000050044_1 | 851.0 | 100.0 | 1 1 |
| 21 | 100000051926_1_1 | 100000051926_1 | 1500.0 | 100.0 | 1 1 |
| 22 | 100000052541_1_1 | 100000052541_1 | 1164.0 | 100.0 | 1 1 |
| 25 | 100000065225_1_1 | 100000065225_1 | 494.0 | 100.0 | 1 1 |
| 32 | 100000099877_2_1 | 100000099877_2 | 49.0 | 100.0 | 1 1 |
| 36 | 100000103693_1_1 | 100000103693_1 | 20933.0 | 100.0 | 1 1 |
| 39 | 100000138246_1_1 | 100000138246_1 | 873.0 | 100.0 | 1 1 |
| 44 | 100000192864_1_1 | 100000192864_1 | 32110.0 | 100.0 | 1 1 |
| 50 | 100000052998_1_1 | 100000052998_1 | 8.0 | 100.0 | 1 1 |
| 51 | 100000054772_1_1 | 100000054772_1 | 2.0 | 100.0 | 1 1 |
| 70 | 100000171164_1_1 | 100000171164_1 | 2.0 | 100.0 | 1 1 |
| 77 | 100000238548_1_1 | 100000238548_1 | 197.0 | 100.0 | 1 1 |
| 78 | 100000001650_1_1 | 100000001650_1 | 321.0 | 100.0 | 1 1 |
| 79 | 100000043106_1_1 | 100000043106_1 | 900.0 | 100.0 | 1 1 |
| 85 | 100000108279_1_1 | 100000108279_1 | 50.0 | 100.0 | 1 1 |
| 86 | 100000132215_1_1 | 100000132215_1 | 972.0 | 100.0 | 1 1 |
| 87 | 100000132215_2_1 | 100000132215_2 | 1150.0 | 100.0 | 1 1 |
| 88 | 100000133526_1_1 | 100000133526_1 | 10600.0 | 100.0 | 1 1 |
| 92 | 100000214886_1_1 | 100000214886_1 | 900.0 | 100.0 | 1 1 |
| 94 | 100000029346_1_1 | 100000029346_1 | 363.0 | 100.0 | 1 1 |
| 96 | 100000043259_1_1 | 100000043259_1 | 1300.0 | 100.0 | 1 1 |
| 97 | 100000044819_1_1 | 100000044819_1 | 240.0 | 100.0 | 1 1 |
| 105 | 100000058171_1_1 | 100000058171_1 | 1050.0 | 100.0 | 1 1 |
| 107 | 100000066974_1_1 | 100000066974_1 | 720.0 | 100.0 | 1 1 |
| 110 | 100000072379_1_1 | 100000072379_1 | 50.0 | 100.0 | 1 1 |
| 139 | 100000075571_1_1 | 100000075571_1 | 3.0 | 100.0 | 1 1 |
| 141 | 100000080832_1_1 | 100000080832_1 | 5461.0 | 100.0 | 1 1 |
| 142 | 100000083358_1_1 | 100000083358_1 | 3422.0 | 100.0 | 1 1 |
| 157 | 100000114574_1_1 | 100000114574_1 | 926.0 | 100.0 | 1 1 |
| 159 | 100000117777_1_1 | 100000117777_1 | 305.0 | 100.0 | 1 1 |
| 163 | 100000123573_1_1 | 100000123573_1 | 12000.0 | 100.0 | 1 1 |
| 165 | 100000127276_1_1 | 100000127276_1 | 6783.0 | 100.0 | 1 1 |
| 166 | 100000127347_1_1 | 100000127347_1 | 1.0 | 100.0 | 1 1 |
| 169 | 100000138059_1_1 | 100000138059_1 | 2.0 | 100.0 | 1 1 |
| 172 | 100000142543_1_1 | 100000142543_1 | 158.0 | 100.0 | 1 1 |
| 173 | 100000143249_1_1 | 100000143249_1 | 23.0 | 100.0 | 1 1 |
| 176 | 100000145112_1_1 | 100000145112_1 | 2335.0 | 100.0 | 1 1 |
| 178 | 100000145844_1_1 | 100000145844_1 | 109.0 | 100.0 | 1 1 |
| 201 | 100000153139_1_1 | 100000153139_1 | 2100.0 | 100.0 | 1 1 |
| 204 | 100000156154_1_1 | 100000156154_1 | 10952.0 | 100.0 | 1 1 |
| 209 | 100000164092_1_1 | 100000164092_1 | 10.0 | 100.0 | 1 1 |
| 212 | 100000171128_1_1 | 100000171128_1 | 75.0 | 100.0 | 1 1 |
| 213 | 100000174269_1_1 | 100000174269_1 | 30000.0 | 100.0 | 1 1 |
| 215 | 100000177211_1_1 | 100000177211_1 | 767.0 | 100.0 | 1 1 |
| 217 | 100000198074_1_1 | 100000198074_1 | 1.0 | 100.0 | 1 1 |
| 219 | 100000210434_1_1 | 100000210434_1 | 924.0 | 100.0 | 1 1 |
| 220 | 100000210782_1_1 | 100000210782_1 | 4601.0 | 100.0 | 1 1 |
| 221 | 100000213404_1_1 | 100000213404_1 | 200.0 | 100.0 | 1 1 |
| 222 | 100000213404_2_1 | 100000213404_2 | 217.0 | 100.0 | 1 1 |
| 223 | 100000214555_1_1 | 100000214555_1 | 1245.0 | 100.0 | 1 1 |
| 225 | 100000215625_1_1 | 100000215625_1 | 90.0 | 100.0 | 1 1 |
| 226 | 100000215732_1_1 | 100000215732_1 | 689.0 | 100.0 | 1 1 |
| 227 | 100000220557_1_1 | 100000220557_1 | 3000.0 | 100.0 | 1 1 |
| 228 | 100000229807_1_1 | 100000229807_1 | 56.0 | 100.0 | 1 1 |
| 229 | 100000238227_1_1 | 100000238227_1 | 225.0 | 100.0 | 1 1 |
| 230 | 100000238511_1_1 | 100000238511_1 | 16.0 | 100.0 | 1 1 |
| 258 | 100000139735_1_1 | 100000139735_1 | 767.0 | 100.0 | 1 1 |
| 259 | 100000180298_1_1 | 100000180298_1 | 41.0 | 100.0 | 1 1 |
| 285 | 100000104585_1_1 | 100000104585_1 | 243.0 | 100.0 | 1 1 |
| 289 | 100000003792_1_1 | 100000003792_1 | 2.0 | 100.0 | 1 1 |
| 296 | 100000037006_1_1 | 100000037006_1 | 35.0 | 100.0 | 1 1 |
| 305 | 100000056226_1_1 | 100000056226_1 | 72.0 | 100.0 | 1 1 |
| 312 | 100000073742_1_1 | 100000073742_1 | 30.0 | 100.0 | 1 1 |
| 317 | 100000082938_1_1 | 100000082938_1 | 750.0 | 100.0 | 1 1 |
| 318 | 100000082938_2_1 | 100000082938_2 | 81.0 | 100.0 | 1 1 |
| 321 | 100000096479_1_1 | 100000096479_1 | 5.0 | 100.0 | 1 1 |
| 323 | 100000115715_1_1 | 100000115715_1 | 4000.0 | 100.0 | 1 1 |
| 326 | 100000144532_1_1 | 100000144532_1 | 60.0 | 100.0 | 1 1 |
| 343 | 100000173297_1_1 | 100000173297_1 | 12.0 | 100.0 | 1 1 |
| 346 | 100000187148_1_1 | 100000187148_1 | 10800.0 | 100.0 | 1 1 |
| 347 | 100000194292_1_1 | 100000194292_1 | 12961.0 | 100.0 | 1 1 |
| 353 | 100000050758_1_1 | 100000050758_1 | 99.0 | 100.0 | 1 1 |
| 367 | 100000100482_1_1 | 100000100482_1 | 3593.0 | 100.0 | 1 1 |
| 368 | 100000100856_1_1 | 100000100856_1 | 212.0 | 100.0 | 1 1 |
| 370 | 100000130798_1_1 | 100000130798_1 | 826.0 | 100.0 | 1 1 |
| 375 | 100000155716_1_1 | 100000155716_1 | 4456.0 | 100.0 | 1 1 |
| 381 | 100000212469_1_1 | 100000212469_1 | 1700.0 | 100.0 | 1 1 |
| 382 | 100000222109_1_1 | 100000222109_1 | 46.0 | 100.0 | 1 1 |
| 384 | 100000243676_1_1 | 100000243676_1 | 428.0 | 100.0 | 1 1 |
| 389 | 100000003907_1_1 | 100000003907_1 | 1.0 | 100.0 | 1 1 |
| 391 | 100000004817_1_1 | 100000004817_1 | 1.0 | 100.0 | 1 1 |
| 394 | 100000012871_3_1 | 100000012871_3 | 359.0 | 100.0 | 1 1 |
| 395 | 100000012871_4_1 | 100000012871_4 | 830.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 |
| 411 | 100000079684_1_1 | 100000079684_1 | 2.0 | 100.0 | 1 1 |
| 413 | 100000085374_1_1 | 100000085374_1 | 1288.0 | 100.0 | 1 1 |
| 417 | 100000092222_1_1 | 100000092222_1 | 1018.0 | 100.0 | 1 1 |
| 423 | 100000096638_1_1 | 100000096638_1 | 5.0 | 100.0 | 1 1 |
| 424 | 100000099519_1_1 | 100000099519_1 | 1.0 | 100.0 | 1 1 |
| 425 | 100000099751_1_1 | 100000099751_1 | 300.0 | 100.0 | 1 1 |
| 426 | 100000099797_1_1 | 100000099797_1 | 5.0 | 100.0 | 1 1 |
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)
);