Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

195 rows where chemical_id = 2 and percent_weight = "100.0"

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs >30

percent_weight 1

  • 100.0 · 195 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
10 100000011505_1_1 100000011505_1 100.0 100.0 2 2
23 100000059795_1_1 100000059795_1 2000.0 100.0 2 2
30 100000083642_1_1 100000083642_1 5.0 100.0 2 2
34 100000100393_1_1 100000100393_1 94.0 100.0 2 2
35 100000100393_2_1 100000100393_2 9.0 100.0 2 2
40 100000144015_1_1 100000144015_1 28.0 100.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
80 100000054255_1_1 100000054255_1 6.0 100.0 2 2
81 100000058082_1_1 100000058082_1 1.0 100.0 2 2
109 100000071557_1_1 100000071557_1 3.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
150 100000099555_3_1 100000099555_3 3.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
168 100000127711_2_1 100000127711_2 66.0 100.0 2 2
179 100000147824_1_1 100000147824_1 1.0 100.0 2 2
205 100000158054_1_1 100000158054_1 34.0 100.0 2 2
206 100000158054_2_1 100000158054_2 20.0 100.0 2 2
207 100000158054_3_1 100000158054_3 35.0 100.0 2 2
208 100000162138_1_1 100000162138_1 3.0 100.0 2 2
224 100000214715_1_1 100000214715_1 1.0 100.0 2 2
231 100000246646_1_1 100000246646_1 2.0 100.0 2 2
254 100000084473_1_1 100000084473_1 5.0 100.0 2 2
270 100000108732_1_1 100000108732_1 10.0 100.0 2 2
273 100000053808_1_1 100000053808_1 42.0 100.0 2 2
279 100000089539_1_1 100000089539_1 58.0 100.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
283 100000102364_3_1 100000102364_3 6.0 100.0 2 2
284 100000102364_4_1 100000102364_4 1.0 100.0 2 2
291 100000018651_1_1 100000018651_1 20.0 100.0 2 2
292 100000018651_2_1 100000018651_2 1.0 100.0 2 2
295 100000028418_1_1 100000028418_1 200.0 100.0 2 2
298 100000044098_1_1 100000044098_1 150.0 100.0 2 2
307 100000058331_1_1 100000058331_1 9.0 100.0 2 2
308 100000058331_2_1 100000058331_2 5.0 100.0 2 2
309 100000058331_3_1 100000058331_3 5.0 100.0 2 2
310 100000058331_4_1 100000058331_4 5.0 100.0 2 2
311 100000063646_1_1 100000063646_1 2.0 100.0 2 2
316 100000081635_1_1 100000081635_1 50.0 100.0 2 2
319 100000094293_1_1 100000094293_1 9.0 100.0 2 2
322 100000099573_1_1 100000099573_1 3075.0 100.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
341 100000154218_1_1 100000154218_1 200.0 100.0 2 2
352 100000041938_1_1 100000041938_1 108.0 100.0 2 2
371 100000135043_1_1 100000135043_1 2.0 100.0 2 2
372 100000135043_2_1 100000135043_2 7.0 100.0 2 2
388 100000219925_1_1 100000219925_1 6.0 100.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
458 100000087808_1_1 100000087808_1 3.0 100.0 2 2
459 100000087808_2_1 100000087808_2 55.0 100.0 2 2
460 100000087808_3_1 100000087808_3 171.0 100.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
548 100000050446_1_1 100000050446_1 5.0 100.0 2 2
562 100000129489_2_1 100000129489_2 2.0 100.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
632 100000091866_1_1 100000091866_1 8780.0 100.0 2 2
633 100000091866_2_1 100000091866_2 1.0 100.0 2 2
635 100000100623_1_1 100000100623_1 10.0 100.0 2 2
639 100000207732_1_1 100000207732_1 1.0 100.0 2 2
705 100000082457_1_1 100000082457_1 3.0 100.0 2 2
706 100000082457_2_1 100000082457_2 160.0 100.0 2 2
707 100000082457_3_1 100000082457_3 297.0 100.0 2 2
727 100000087997_1_1 100000087997_1 12.0 100.0 2 2
781 100000144444_1_1 100000144444_1 554.0 100.0 2 2
793 100000158688_1_1 100000158688_1 450.0 100.0 2 2
794 100000165402_1_1 100000165402_1 100.0 100.0 2 2
800 100000177523_1_1 100000177523_1 1100.0 100.0 2 2
801 100000183954_1_1 100000183954_1 2.0 100.0 2 2
818 100000231536_1_1 100000231536_1 1.0 100.0 2 2
819 100000231536_2_1 100000231536_2 6512.0 100.0 2 2
820 100000231536_3_1 100000231536_3 5.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
830 100000140643_1_1 100000140643_1 885.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
845 100000058386_1_1 100000058386_1 1641.0 100.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
871 100000118393_1_1 100000118393_1 2.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
1051 100000150882_1_1 100000150882_1 6.0 100.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)
    );