Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

406 rows where quantity_released_lbs = "1.0"

✎ View and edit SQL

This data as json, CSV (advanced)

percent_weight >30

quantity_released_lbs 1

  • 1.0 · 406 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
6 100000143515_1_1 100000143515_1 1.0 1.0 1 1
7 100000143515_2_1 100000143515_2 1.0 1.0 1 1
11 100000017698_1_1 100000017698_1 1.0 1.0 15 15
12 100000033545_1_1 100000033545_1 1.0 100.0 15 15
13 100000033545_2_1 100000033545_2 1.0 10.0 15 15
14 100000033545_3_1 100000033545_3 1.0 100.0 15 15
15 100000033545_4_1 100000033545_4 1.0 100.0 15 15
17 100000046915_1_1 100000046915_1 1.0 100.0 15 15
18 100000046915_2_1 100000046915_2 1.0 100.0 15 15
19 100000048717_1_1 100000048717_1 1.0   2 2
26 100000071334_1_1 100000071334_1 1.0   26 26
29 100000081092_1_1 100000081092_1 1.0 100.0 21 21
31 100000099877_1_1 100000099877_1 1.0 20.0 1 1
33 100000099877_3_1 100000099877_3 1.0 20.0 1 1
41 100000145425_1_1 100000145425_1 1.0   2 2
49 100000047558_2_1 100000047558_2 1.0 100.0 2 2
56 100000092384_1_1 100000092384_1 1.0 100.0 45 45
59 100000107895_1_1 100000107895_1 1.0 100.0 15 15
61 100000107895_3_1 100000107895_3 1.0 100.0 2 2
67 100000112282_1_1 100000112282_1 1.0 100.0 26 26
71 100000172813_1_1 100000172813_1 1.0 4.9 29 29
73 100000172813_1_3 100000172813_1 1.0 2.5 30 30
74 100000172813_1_4 100000172813_1 1.0 3.1 87 87
81 100000058082_1_1 100000058082_1 1.0 100.0 2 2
84 100000106592_1_1 100000106592_1 1.0 100.0 88 88
95 100000043099_1_1 100000043099_1 1.0 100.0 16 16
140 100000078257_1_1 100000078257_1 1.0   1 1
143 100000086382_1_1 100000086382_1 1.0 100.0 2 2
147 100000099298_2_1 100000099298_2 1.0 96.5 49 49
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
154 100000111924_1_1 100000111924_1 1.0 99.0 7 7
158 100000115118_1_1 100000115118_1 1.0 37.0 31 31
160 100000119187_1_1 100000119187_1 1.0 100.0 23 23
166 100000127347_1_1 100000127347_1 1.0 100.0 1 1
167 100000127711_1_1 100000127711_1 1.0 100.0 2 2
175 100000144658_1_1 100000144658_1 1.0 100.0 7 7
179 100000147824_1_1 100000147824_1 1.0 100.0 2 2
217 100000198074_1_1 100000198074_1 1.0 100.0 1 1
224 100000214715_1_1 100000214715_1 1.0 100.0 2 2
233 100000009162_1_1 100000009162_1 1.0   1 1
238 100000057537_2_1 100000057537_2 1.0 100.0 8 8
239 100000057537_3_1 100000057537_3 1.0 100.0 8 8
240 100000057537_4_1 100000057537_4 1.0 100.0 8 8
241 100000057537_5_1 100000057537_5 1.0 100.0 8 8
245 100000057715_1_1 100000057715_1 1.0 99.0 7 7
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
282 100000102364_2_2 100000102364_2 1.0 100.0 65 65
284 100000102364_4_1 100000102364_4 1.0 100.0 2 2
286 100000109606_1_1 100000109606_1 1.0 99.0 88 88
292 100000018651_2_1 100000018651_2 1.0 100.0 2 2
304 100000051409_2_1 100000051409_2 1.0   1 1
313 100000075508_1_1 100000075508_1 1.0 100.0 15 15
314 100000075508_2_1 100000075508_2 1.0 100.0 15 15
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
351 100000020639_1_1 100000020639_1 1.0 100.0 15 15
387 100000199313_1_1 100000199313_1 1.0 98.0 51 51
389 100000003907_1_1 100000003907_1 1.0 100.0 1 1
391 100000004817_1_1 100000004817_1 1.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
400 100000047898_1_1 100000047898_1 1.0 99.8 1 1
405 100000070497_1_1 100000070497_1 1.0 100.0 1 1
406 100000070497_2_1 100000070497_2 1.0 99.0 1 1
410 100000075919_1_1 100000075919_1 1.0 100.0 1 1
412 100000084703_1_1 100000084703_1 1.0 100.0 2 2
419 100000092393_1_1 100000092393_1 1.0 99.0 1 1
424 100000099519_1_1 100000099519_1 1.0 100.0 1 1
431 100000110998_1_1 100000110998_1 1.0 100.0 2 2
433 100000114976_1_1 100000114976_1 1.0 100.0 1 1
437 100000151792_1_1 100000151792_1 1.0 100.0 1 1
445 100000189627_1_1 100000189627_1 1.0 100.0 1 1
451 100000228915_1_1 100000228915_1 1.0 100.0 1 1
452 100000229246_1_1 100000229246_1 1.0 99.7 1 1
461 100000087808_4_1 100000087808_4 1.0 1.0 2 2
475 100000020782_1_1 100000020782_1 1.0 1.0 1 1
476 100000022325_1_1 100000022325_1 1.0 82.0 1 1
477 100000024369_1_1 100000024369_1 1.0 100.0 1 1
481 100000045159_1_1 100000045159_1 1.0 100.0 2 2
482 100000045159_2_1 100000045159_2 1.0 100.0 2 2
483 100000046096_1_1 100000046096_1 1.0 99.5 1 1
485 100000048183_1_1 100000048183_1 1.0   2 2
498 100000078523_1_1 100000078523_1 1.0   32 32
499 100000081537_1_1 100000081537_1 1.0   44 44

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