Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

323 rows where chemical_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs >30

percent_weight 19

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
19 100000048717_1_1 100000048717_1 1.0   2 2
23 100000059795_1_1 100000059795_1 2000.0 100.0 2 2
28 100000080574_2_1 100000080574_2 18.0 10.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
38 100000121405_1_1 100000121405_1 9.0   2 2
40 100000144015_1_1 100000144015_1 28.0 100.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
75 100000179497_1_1 100000179497_1 27.0 99.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
89 100000141599_1_1 100000141599_1 2500.0   2 2
99 100000048496_2_1 100000048496_2 5.0 1.0 2 2
100 100000048496_3_1 100000048496_3 5.0 1.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
153 100000106333_1_1 100000106333_1 9.0   2 2
164 100000126482_1_1 100000126482_1 5.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
235 100000033938_1_1 100000033938_1 2.0 99.5 2 2
254 100000084473_1_1 100000084473_1 5.0 100.0 2 2
268 100000072048_1_1 100000072048_1 2.0   2 2
269 100000072912_1_1 100000072912_1 1.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
290 100000005157_1_1 100000005157_1 500.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
294 100000026633_1_1 100000026633_1 16.0   2 2
295 100000028418_1_1 100000028418_1 200.0 100.0 2 2
297 100000043543_1_1 100000043543_1 1000.0 50.0 2 2
298 100000044098_1_1 100000044098_1 150.0 100.0 2 2
299 100000045257_1_1 100000045257_1 10.0   2 2
301 100000049556_2_1 100000049556_2 10.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
324 100000137318_1_1 100000137318_1 8.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
340 100000154129_9_1 100000154129_9 8.0 99.0 2 2
341 100000154218_1_1 100000154218_1 200.0 100.0 2 2
344 100000181359_1_1 100000181359_1 150.0 50.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
461 100000087808_4_1 100000087808_4 1.0 1.0 2 2
462 100000089931_1_1 100000089931_1 175.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
501 100000082117_1_1 100000082117_1 600.0   2 2
514 100000139405_1_1 100000139405_1 1.0   2 2
515 100000139405_2_1 100000139405_2 37.0   2 2
516 100000139405_3_1 100000139405_3 7600.0   2 2
543 100000038853_1_1 100000038853_1 2.0   2 2
544 100000038853_2_1 100000038853_2 4.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)
    );