Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

8 rows where facility_id = 100000252638

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
9076 100000252638 3 3 Program Level 1 process
9077 100000252638 66 66  
9078 100000252638 83 83  
9079 100000252638 17 17  
9080 100000252638 97 97  
9081 100000252638 98 98  
9082 100000252638 54 54  
9083 100000252638 44 44  

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