Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

15 rows where facility_id = 100000103675

✎ 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
45006 100000103675 11 11 Program Level 3 process
45007 100000103675 17 17 Program Level 3 process
45008 100000103675 44 44 Program Level 3 process
45009 100000103675 3 3 Program Level 3 process
45010 100000103675 11 11  
45011 100000103675 4 4  
45012 100000103675 5 5  
45013 100000103675 83 83  
45014 100000103675 32 32  
45015 100000103675 72 72  
45016 100000103675 17 17  
45017 100000103675 97 97  
45018 100000103675 98 98  
45019 100000103675 85 85  
45020 100000103675 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);