Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

34 rows where percent_weight = "100.0" and quantity_released_lbs = "2.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

quantity_released_lbs 1

  • 2.0 · 34 ✖

percent_weight 1

  • 100.0 · 34 ✖
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
289 100000003792_1_1 100000003792_1 2.0 100.0 1 1
311 100000063646_1_1 100000063646_1 2.0 100.0 2 2
371 100000135043_1_1 100000135043_1 2.0 100.0 2 2
411 100000079684_1_1 100000079684_1 2.0 100.0 1 1
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
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
983 100000122048_1_1 100000122048_1 2.0 100.0 1 1
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
1187 100000114547_1_1 100000114547_1 2.0 100.0 2 2
1188 100000115341_1_1 100000115341_1 2.0 100.0 2 2
1193 100000132527_1_1 100000132527_1 2.0 100.0 2 2
1371 100000027384_1_1 100000027384_1 2.0 100.0 1 1
1496 100000136131_2_1 100000136131_2 2.0 100.0 1 1
1719 100000079489_1_2 100000079489_1 2.0 100.0 42 42
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

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