rmp_accident_chemicals

27 rows where chemical_id = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: quantity_released_lbs, percent_weight

accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
24 100000064235_1_1 100000064235_1 264.0 0.1 31 31
158 100000115118_1_1 100000115118_1 1.0 37.0 31 31
780 100000144426_1_1 100000144426_1 17.0 40.0 31 31
783 100000146781_1_1 100000146781_1 2.0 30.0 31 31
849 100000085203_1_1 100000085203_1 67.0 37.0 31 31
1038 100000076026_1_1 100000076026_1 630.0 100.0 31 31
1039 100000076026_2_1 100000076026_2 7866.0 6.9 31 31
1048 100000132073_1_1 100000132073_1 10000.0 50.0 31 31
1054 100000167204_1_1 100000167204_1 9175.0 0.4 31 31
1061 100000222966_1_1 100000222966_1 2900.0 50.0 31 31
1064 100000241623_1_1 100000241623_1 1000.0 41.0 31 31
1065 100000241623_2_1 100000241623_2 3000.0 41.0 31 31
1119 100000028588_1_1 100000028588_1 2016.0 44.0 31 31
1123 100000021923_1_1 100000021923_1 90.0 40.0 31 31
1217 100000049609_1_1 100000049609_1 145.0 1.4 31 31
1252 100000115412_1_1 100000115412_1 10.0 22.0 31 31
1253 100000115412_2_1 100000115412_2 1.0 45.0 31 31
1254 100000115412_3_1 100000115412_3 9.0 45.0 31 31
1255 100000115412_4_1 100000115412_4 50.0 45.0 31 31
1256 100000115412_5_1 100000115412_5 1.0 45.0 31 31
1257 100000115412_6_1 100000115412_6 1.0 45.0 31 31
1375 100000049645_1_1 100000049645_1 562.0 7.8 31 31
1376 100000050605_1_1 100000050605_1 234.0 52.0 31 31
1377 100000050605_2_1 100000050605_2 10.0 52.0 31 31
1378 100000050605_3_1 100000050605_3 1500.0 52.0 31 31
1876 100000131074_1_1 100000131074_1 2058.0 50.0 31 31
1949 100000157126_1_1 100000157126_1 2.0 50.0 31 31

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