Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

9 rows where chemical_id = 102

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 0

facility_chemical_id ▼ facility_id chemical_id program_level
4647 100000152504 102 102  
46154 100000118133 102 102  
46178 100000118133 102 102  
46408 100000118133 102 102  
46431 100000118133 102 102  
46496 100000118133 102 102  
46519 100000118133 102 102  
46715 100000119043 102 102  
57706 100000141401 102 102  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE rmp_facility_chemicals (
        facility_chemical_id INTEGER PRIMARY KEY,
        facility_id TEXT,
        chemical_id INTEGER,
        program_level TEXT,
        FOREIGN KEY (facility_id) REFERENCES rmp_facility(epa_facility_id),
        FOREIGN KEY (chemical_id) REFERENCES rmp_chemical(chemical_id)
    );
CREATE INDEX idx_rmp_facility_chemicals_facility_id ON rmp_facility_chemicals(facility_id);