Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

73 rows where facility_id = 100000116812

✎ 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
45980 100000116812 9 9 Program Level 3 process
45981 100000116812 10 10 Program Level 3 process
45982 100000116812 11 11 Program Level 3 process
45983 100000116812 4 4 Program Level 3 process
45984 100000116812 12 12 Program Level 3 process
45985 100000116812 5 5 Program Level 3 process
45986 100000116812 6 6 Program Level 3 process
45987 100000116812 13 13 Program Level 3 process
45988 100000116812 44 44 Program Level 3 process
45989 100000116812 9 9 Program Level 3 process
45990 100000116812 10 10 Program Level 3 process
45991 100000116812 11 11 Program Level 3 process
45992 100000116812 4 4 Program Level 3 process
45993 100000116812 12 12 Program Level 3 process
45994 100000116812 5 5 Program Level 3 process
45995 100000116812 6 6 Program Level 3 process
45996 100000116812 34 34 Program Level 3 process
45997 100000116812 13 13 Program Level 3 process
45998 100000116812 44 44 Program Level 3 process
45999 100000116812 9 9 Program Level 3 process
46000 100000116812 10 10 Program Level 3 process
46001 100000116812 11 11 Program Level 3 process
46002 100000116812 4 4 Program Level 3 process
46003 100000116812 12 12 Program Level 3 process
46004 100000116812 5 5 Program Level 3 process
46005 100000116812 6 6 Program Level 3 process
46006 100000116812 13 13 Program Level 3 process
46007 100000116812 44 44 Program Level 3 process
46008 100000116812 9 9 Program Level 3 process
46009 100000116812 10 10 Program Level 3 process
46010 100000116812 11 11 Program Level 3 process
46011 100000116812 4 4 Program Level 3 process
46012 100000116812 12 12 Program Level 3 process
46013 100000116812 5 5 Program Level 3 process
46014 100000116812 6 6 Program Level 3 process
46015 100000116812 13 13 Program Level 3 process
46016 100000116812 44 44 Program Level 3 process
46017 100000116812 9 9 Program Level 3 process
46018 100000116812 10 10 Program Level 3 process
46019 100000116812 11 11 Program Level 3 process
46020 100000116812 4 4 Program Level 3 process
46021 100000116812 12 12 Program Level 3 process
46022 100000116812 5 5 Program Level 3 process
46023 100000116812 6 6 Program Level 3 process
46024 100000116812 13 13 Program Level 3 process
46025 100000116812 44 44 Program Level 3 process
46026 100000116812 9 9 Program Level 3 process
46027 100000116812 10 10 Program Level 3 process
46028 100000116812 11 11 Program Level 3 process
46029 100000116812 4 4 Program Level 3 process
46030 100000116812 12 12 Program Level 3 process
46031 100000116812 5 5 Program Level 3 process
46032 100000116812 6 6 Program Level 3 process
46033 100000116812 34 34 Program Level 3 process
46034 100000116812 13 13 Program Level 3 process
46035 100000116812 85 85 Program Level 3 process
46036 100000116812 44 44 Program Level 3 process
46037 100000116812 9 9 Program Level 3 process
46038 100000116812 12 12 Program Level 3 process
46039 100000116812 5 5 Program Level 3 process
46040 100000116812 6 6 Program Level 3 process
46041 100000116812 13 13 Program Level 3 process
46042 100000116812 9 9 Program Level 3 process
46043 100000116812 10 10 Program Level 3 process
46044 100000116812 11 11 Program Level 3 process
46045 100000116812 4 4 Program Level 3 process
46046 100000116812 12 12 Program Level 3 process
46047 100000116812 5 5 Program Level 3 process
46048 100000116812 6 6 Program Level 3 process
46049 100000116812 13 13 Program Level 3 process
46050 100000116812 83 83 Program Level 3 process
46051 100000116812 6 6 Program Level 3 process
46052 100000116812 13 13 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);