Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

151 rows where chemical_id = 2 and quantity_released_lbs = "1.0"

✎ View and edit SQL

This data as json, CSV (advanced)

percent_weight 9

quantity_released_lbs 1

  • 1.0 · 151 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
19 100000048717_1_1 100000048717_1 1.0   2 2
41 100000145425_1_1 100000145425_1 1.0   2 2
49 100000047558_2_1 100000047558_2 1.0 100.0 2 2
61 100000107895_3_1 100000107895_3 1.0 100.0 2 2
81 100000058082_1_1 100000058082_1 1.0 100.0 2 2
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
167 100000127711_1_1 100000127711_1 1.0 100.0 2 2
179 100000147824_1_1 100000147824_1 1.0 100.0 2 2
224 100000214715_1_1 100000214715_1 1.0 100.0 2 2
269 100000072912_1_1 100000072912_1 1.0   2 2
280 100000102364_1_1 100000102364_1 1.0 100.0 2 2
281 100000102364_2_1 100000102364_2 1.0 100.0 2 2
284 100000102364_4_1 100000102364_4 1.0 100.0 2 2
292 100000018651_2_1 100000018651_2 1.0 100.0 2 2
325 100000137318_2_1 100000137318_2 1.0   2 2
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
332 100000154129_1_1 100000154129_1 1.0 99.0 2 2
333 100000154129_2_1 100000154129_2 1.0 99.0 2 2
334 100000154129_3_1 100000154129_3 1.0 99.0 2 2
335 100000154129_4_1 100000154129_4 1.0 99.0 2 2
336 100000154129_5_1 100000154129_5 1.0 99.0 2 2
337 100000154129_6_1 100000154129_6 1.0 99.0 2 2
338 100000154129_7_1 100000154129_7 1.0 99.0 2 2
339 100000154129_8_1 100000154129_8 1.0 99.0 2 2
412 100000084703_1_1 100000084703_1 1.0 100.0 2 2
431 100000110998_1_1 100000110998_1 1.0 100.0 2 2
461 100000087808_4_1 100000087808_4 1.0 1.0 2 2
481 100000045159_1_1 100000045159_1 1.0 100.0 2 2
482 100000045159_2_1 100000045159_2 1.0 100.0 2 2
485 100000048183_1_1 100000048183_1 1.0   2 2
514 100000139405_1_1 100000139405_1 1.0   2 2
552 100000072315_1_1 100000072315_1 1.0   2 2
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
639 100000207732_1_1 100000207732_1 1.0 100.0 2 2
672 100000061069_1_2 100000061069_1 1.0 2.0 2 2
710 100000084927_1_1 100000084927_1 1.0 0.1 2 2
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
839 100000113432_1_1 100000113432_1 1.0 100.0 2 2
851 100000130299_1_1 100000130299_1 1.0   2 2
852 100000130299_2_1 100000130299_2 1.0   2 2
853 100000130299_3_1 100000130299_3 1.0   2 2
854 100000130299_4_1 100000130299_4 1.0   2 2
858 100000056841_1_1 100000056841_1 1.0 100.0 2 2
859 100000061746_1_1 100000061746_1 1.0 100.0 2 2
916 100000126133_1_1 100000126133_1 1.0 100.0 2 2
926 100000173769_1_1 100000173769_1 1.0 100.0 2 2
927 100000173769_2_1 100000173769_2 1.0 100.0 2 2
951 100000074634_1_1 100000074634_1 1.0 100.0 2 2
954 100000098985_1_1 100000098985_1 1.0 100.0 2 2
1040 100000093301_1_1 100000093301_1 1.0 100.0 2 2
1052 100000157849_1_1 100000157849_1 1.0 98.0 2 2
1062 100000232768_1_1 100000232768_1 1.0 100.0 2 2
1105 100000083517_1_1 100000083517_1 1.0 99.0 2 2
1120 100000008662_1_1 100000008662_1 1.0 100.0 2 2
1121 100000014432_1_1 100000014432_1 1.0   2 2
1122 100000014432_2_1 100000014432_2 1.0   2 2
1126 100000043302_1_1 100000043302_1 1.0 100.0 2 2
1128 100000057396_1_1 100000057396_1 1.0   2 2
1129 100000059535_1_1 100000059535_1 1.0 100.0 2 2
1133 100000059535_5_1 100000059535_5 1.0 100.0 2 2
1134 100000059535_6_1 100000059535_6 1.0 100.0 2 2
1135 100000059535_7_1 100000059535_7 1.0   2 2
1136 100000059535_8_1 100000059535_8 1.0 100.0 2 2
1137 100000059535_9_1 100000059535_9 1.0 100.0 2 2
1138 100000059535_10_1 100000059535_10 1.0 100.0 2 2
1139 100000059535_11_1 100000059535_11 1.0 100.0 2 2
1143 100000085828_1_1 100000085828_1 1.0 100.0 2 2
1174 100000115172_1_1 100000115172_1 1.0   2 2
1178 100000044846_1_1 100000044846_1 1.0 1.0 2 2
1181 100000063003_1_1 100000063003_1 1.0 100.0 2 2
1184 100000108821_1_1 100000108821_1 1.0 100.0 2 2
1186 100000109269_2_1 100000109269_2 1.0 100.0 2 2
1189 100000115341_2_1 100000115341_2 1.0 100.0 2 2
1201 100000008243_1_1 100000008243_1 1.0 100.0 2 2
1210 100000035972_2_1 100000035972_2 1.0   2 2
1212 100000036301_2_1 100000036301_2 1.0   2 2
1241 100000096736_1_1 100000096736_1 1.0 100.0 2 2
1243 100000101846_2_1 100000101846_2 1.0 100.0 2 2
1244 100000104031_1_1 100000104031_1 1.0 1.0 2 2
1274 100000136783_1_1 100000136783_1 1.0 100.0 2 2
1280 100000166955_2_1 100000166955_2 1.0   2 2
1282 100000167883_1_1 100000167883_1 1.0   2 2
1288 100000230074_1_1 100000230074_1 1.0 100.0 2 2
1314 100000109857_1_1 100000109857_1 1.0   2 2
1350 100000194407_1_1 100000194407_1 1.0 100.0 2 2
1384 100000152513_1_1 100000152513_1 1.0   2 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
    );