Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

11 rows where chemical_id = 111

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 0

facility_chemical_id ▼ facility_id chemical_id program_level
13700 100000026358 111 111  
16259 100000163048 111 111  
53301 100000230341 111 111  
53398 100000230546 111 111  
53408 100000230546 111 111  
53418 100000230546 111 111  
53428 100000230546 111 111  
53441 100000230546 111 111  
53449 100000230546 111 111  
53459 100000230546 111 111  
57715 100000141401 111 111  

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