Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

22 rows where chemical_id = 1 and quantity_released_lbs = "2.0"

✎ View and edit SQL

This data as json, CSV (advanced)

percent_weight 5

quantity_released_lbs 1

  • 2.0 · 22 ✖
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
51 100000054772_1_1 100000054772_1 2.0 100.0 1 1
70 100000171164_1_1 100000171164_1 2.0 100.0 1 1
169 100000138059_1_1 100000138059_1 2.0 100.0 1 1
289 100000003792_1_1 100000003792_1 2.0 100.0 1 1
356 100000062264_1_1 100000062264_1 2.0   1 1
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
571 100000177006_1_1 100000177006_1 2.0 100.0 1 1
578 100000007707_1_1 100000007707_1 2.0 4.7 1 1
789 100000156127_2_1 100000156127_2 2.0 100.0 1 1
967 100000231117_1_1 100000231117_1 2.0 99.0 1 1
983 100000122048_1_1 100000122048_1 2.0 100.0 1 1
1150 100000148164_1_1 100000148164_1 2.0 100.0 1 1
1371 100000027384_1_1 100000027384_1 2.0 100.0 1 1
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
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

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