Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

25 rows where facility_id = 100000141401

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
57699 100000141401 24 24 Program Level 3 process
57700 100000141401 3 3 Program Level 3 process
57701 100000141401 33 33  
57702 100000141401 9 9  
57703 100000141401 10 10  
57704 100000141401 11 11  
57705 100000141401 4 4  
57706 100000141401 102 102  
57707 100000141401 12 12  
57708 100000141401 5 5  
57709 100000141401 83 83  
57710 100000141401 32 32  
57711 100000141401 6 6  
57712 100000141401 76 76  
57713 100000141401 17 17  
57714 100000141401 84 84  
57715 100000141401 111 111  
57716 100000141401 109 109  
57717 100000141401 77 77  
57718 100000141401 97 97  
57719 100000141401 98 98  
57720 100000141401 106 106  
57721 100000141401 103 103  
57722 100000141401 13 13  
57723 100000141401 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);