Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

36 rows where facility_id = 100000139085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
10072 100000139085 10 10 Program Level 3 process
10073 100000139085 11 11 Program Level 3 process
10074 100000139085 4 4 Program Level 3 process
10075 100000139085 12 12 Program Level 3 process
10076 100000139085 17 17 Program Level 3 process
10077 100000139085 16 16 Program Level 3 process
10078 100000139085 44 44 Program Level 3 process
10079 100000139085 4 4 Program Level 3 process
10080 100000139085 16 16 Program Level 3 process
10081 100000139085 44 44 Program Level 3 process
10082 100000139085 12 12 Program Level 3 process
10083 100000139085 44 44 Program Level 3 process
10084 100000139085 3 3 Program Level 3 process
10085 100000139085 10 10  
10086 100000139085 11 11  
10087 100000139085 32 32  
10088 100000139085 17 17  
10089 100000139085 13 13  
10090 100000139085 44 44  
10091 100000139085 3 3 Program Level 3 process
10092 100000139085 11 11  
10093 100000139085 4 4  
10094 100000139085 3 3 Program Level 3 process
10095 100000139085 9 9  
10096 100000139085 82 82  
10097 100000139085 32 32  
10098 100000139085 6 6  
10099 100000139085 3 3 Program Level 3 process
10100 100000139085 12 12  
10101 100000139085 5 5  
10102 100000139085 83 83  
10103 100000139085 32 32  
10104 100000139085 84 84  
10105 100000139085 97 97  
10106 100000139085 98 98  
10107 100000139085 110 110  

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