rmp_facility_chemicals

35 rows where facility_id = 100000153656

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

facility_chemical_id ▼ facility_id chemical_id program_level
32150 100000153656 50 50 Program Level 3 process
32151 100000153656 52 52 Program Level 3 process
32152 100000153656 51 51 Program Level 3 process
32153 100000153656 50 50 Program Level 3 process
32154 100000153656 51 51 Program Level 3 process
32155 100000153656 50 50 Program Level 3 process
32156 100000153656 51 51 Program Level 3 process
32157 100000153656 50 50 Program Level 3 process
32158 100000153656 51 51 Program Level 3 process
32159 100000153656 50 50 Program Level 3 process
32160 100000153656 52 52 Program Level 3 process
32161 100000153656 51 51 Program Level 3 process
32162 100000153656 13 13 Program Level 3 process
32163 100000153656 50 50 Program Level 3 process
32164 100000153656 52 52 Program Level 3 process
32165 100000153656 51 51 Program Level 3 process
32166 100000153656 92 92 Program Level 3 process
32167 100000153656 36 36 Program Level 3 process
32168 100000153656 50 50 Program Level 3 process
32169 100000153656 52 52 Program Level 3 process
32170 100000153656 51 51 Program Level 3 process
32171 100000153656 52 52 Program Level 3 process
32172 100000153656 50 50 Program Level 3 process
32173 100000153656 52 52 Program Level 3 process
32174 100000153656 51 51 Program Level 3 process
32175 100000153656 52 52 Program Level 3 process
32176 100000153656 52 52 Program Level 3 process
32177 100000153656 50 50 Program Level 3 process
32178 100000153656 52 52 Program Level 3 process
32179 100000153656 51 51 Program Level 3 process
32180 100000153656 50 50 Program Level 3 process
32181 100000153656 52 52 Program Level 3 process
32182 100000153656 51 51 Program Level 3 process
32183 100000153656 36 36 Program Level 3 process
32184 100000153656 52 52 Program Level 3 process

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