Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

64 rows where quantity_released_lbs = "2.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

percent_weight 13

quantity_released_lbs 1

  • 2.0 · 64 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
5 100000035678_2_1 100000035678_2 2.0 100.0 1 1
27 100000080574_1_1 100000080574_1 2.0 100.0 7 7
51 100000054772_1_1 100000054772_1 2.0 100.0 1 1
60 100000107895_2_1 100000107895_2 2.0 100.0 15 15
65 100000111425_3_1 100000111425_3 2.0 100.0 60 60
70 100000171164_1_1 100000171164_1 2.0 100.0 1 1
169 100000138059_1_1 100000138059_1 2.0 100.0 1 1
231 100000246646_1_1 100000246646_1 2.0 100.0 2 2
234 100000019071_1_1 100000019071_1 2.0 98.0 10 10
235 100000033938_1_1 100000033938_1 2.0 99.5 2 2
268 100000072048_1_1 100000072048_1 2.0   2 2
289 100000003792_1_1 100000003792_1 2.0 100.0 1 1
311 100000063646_1_1 100000063646_1 2.0 100.0 2 2
348 100000218089_1_1 100000218089_1 2.0   4 4
356 100000062264_1_1 100000062264_1 2.0   1 1
371 100000135043_1_1 100000135043_1 2.0 100.0 2 2
396 100000019847_1_1 100000019847_1 2.0 99.0 1 1
411 100000079684_1_1 100000079684_1 2.0 100.0 1 1
420 100000094943_1_1 100000094943_1 2.0 99.0 1 1
543 100000038853_1_1 100000038853_1 2.0   2 2
545 100000038853_3_1 100000038853_3 2.0   2 2
551 100000072119_1_1 100000072119_1 2.0 100.0 7 7
562 100000129489_2_1 100000129489_2 2.0 100.0 2 2
571 100000177006_1_1 100000177006_1 2.0 100.0 1 1
578 100000007707_1_1 100000007707_1 2.0 4.7 1 1
783 100000146781_1_1 100000146781_1 2.0 30.0 31 31
789 100000156127_2_1 100000156127_2 2.0 100.0 1 1
801 100000183954_1_1 100000183954_1 2.0 100.0 2 2
871 100000118393_1_1 100000118393_1 2.0 100.0 2 2
885 100000183366_1_1 100000183366_1 2.0   19 19
967 100000231117_1_1 100000231117_1 2.0 99.0 1 1
975 100000025849_4_1 100000025849_4 2.0 99.9 88 88
983 100000122048_1_1 100000122048_1 2.0 100.0 1 1
996 100000093533_1_3 100000093533_1 2.0   4 4
1093 100000214813_2_4 100000214813_2 2.0   4 4
1125 100000034385_1_1 100000034385_1 2.0 100.0 14 14
1150 100000148164_1_1 100000148164_1 2.0 100.0 1 1
1156 100000193471_2_1 100000193471_2 2.0 100.0 56 56
1172 100000154343_1_1 100000154343_1 2.0 1.0 2 2
1187 100000114547_1_1 100000114547_1 2.0 100.0 2 2
1188 100000115341_1_1 100000115341_1 2.0 100.0 2 2
1191 100000129336_1_2 100000129336_1 2.0 50.0 28 28
1193 100000132527_1_1 100000132527_1 2.0 100.0 2 2
1249 100000110293_5_1 100000110293_5 2.0 2.0 24 24
1371 100000027384_1_1 100000027384_1 2.0 100.0 1 1
1422 100000074901_1_1 100000074901_1 2.0 0.1 2 2
1432 100000105717_2_1 100000105717_2 2.0 5.2 1 1
1471 100000098627_1_1 100000098627_1 2.0 99.9 1 1
1496 100000136131_2_1 100000136131_2 2.0 100.0 1 1
1535 100000012522_1_7 100000012522_1 2.0   10 10
1562 100000048986_1_5 100000048986_1 2.0   6 6
1699 100000069515_5_3 100000069515_5 2.0 0.3 11 11
1719 100000079489_1_2 100000079489_1 2.0 100.0 42 42
1757 100000089316_4_1 100000089316_4 2.0 99.0 2 2
1949 100000157126_1_1 100000157126_1 2.0 50.0 31 31
1963 100000162343_1_1 100000162343_1 2.0 99.0 47 47
2036 100000227248_1_1 100000227248_1 2.0   10 10
2157 100000099234_2_1 100000099234_2 2.0 100.0 2 2
2203 100000077999_1_1 100000077999_1 2.0 100.0 2 2
2224 100000151881_1_1 100000151881_1 2.0 100.0 1 1
2225 100000151881_2_1 100000151881_2 2.0 100.0 1 1
2226 100000151881_3_1 100000151881_3 2.0 100.0 1 1
2246 100000042651_1_1 100000042651_1 2.0 100.0 40 40
2247 100000045578_1_1 100000045578_1 2.0 99.9 2 2

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