Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

20 rows where facility_id = 100000103924

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
45023 100000103924 2 2 Program Level 3 process
45024 100000103924 3 3 Program Level 3 process
45025 100000103924 9 9  
45026 100000103924 10 10  
45027 100000103924 11 11  
45028 100000103924 4 4  
45029 100000103924 12 12  
45030 100000103924 82 82  
45031 100000103924 5 5  
45032 100000103924 32 32  
45033 100000103924 6 6  
45034 100000103924 76 76  
45035 100000103924 17 17  
45036 100000103924 94 94  
45037 100000103924 108 108  
45038 100000103924 77 77  
45039 100000103924 110 110  
45040 100000103924 13 13  
45041 100000103924 85 85  
45042 100000103924 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);