home / risk_management_plans

Rmp Accident Chemicals

Data table with 2,301 records and 6 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

15 rows where chemical_id = 1 and percent_weight = "99.5"

✎ View and edit SQL

This data as json, CSV (advanced)

quantity_released_lbs 11

  • 1.0 3
  • 6000.0 3
  • 10.0 1
  • 105.0 1
  • 123.0 1
  • 1500.0 1
  • 5.0 1
  • 50.0 1
  • 65.0 1
  • 68.0 1
  • 700.0 1

percent_weight 1

  • 99.5 · 15 ✖
accident_chemical_id ▼ facility_accident_chemical_id facility_accident_id quantity_released_lbs percent_weight chemical_id
151 100000101971_1_1 100000101971_1 123.0 99.5 1 1
255 100000102202_1_1 100000102202_1 1500.0 99.5 1 1
409 100000075697_1_1 100000075697_1 105.0 99.5 1 1
469 100000008172_1_1 100000008172_1 6000.0 99.5 1 1
483 100000046096_1_1 100000046096_1 1.0 99.5 1 1
484 100000046096_2_1 100000046096_2 5.0 99.5 1 1
505 100000095461_1_1 100000095461_1 6000.0 99.5 1 1
524 100000157457_1_1 100000157457_1 6000.0 99.5 1 1
860 100000070013_1_1 100000070013_1 10.0 99.5 1 1
897 100000060925_1_1 100000060925_1 700.0 99.5 1 1
913 100000124162_1_1 100000124162_1 1.0 99.5 1 1
925 100000166385_1_1 100000166385_1 50.0 99.5 1 1
1073 100000104834_1_1 100000104834_1 1.0 99.5 1 1
1199 100000220209_1_1 100000220209_1 68.0 99.5 1 1
1289 100000018562_1_1 100000018562_1 65.0 99.5 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)
    );
Powered by Datasette · Queries took 238.929ms · Data license: ODbL · Data source: EDGI Cloud Portal