Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

113 rows where facility_id = 100000107886

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
45095 100000107886 9 9 Program Level 3 process
45096 100000107886 12 12 Program Level 3 process
45097 100000107886 4 4 Program Level 3 process
45098 100000107886 17 17 Program Level 3 process
45099 100000107886 24 24 Program Level 3 process
45100 100000107886 5 5 Program Level 3 process
45101 100000107886 5 5 Program Level 3 process
45102 100000107886 13 13 Program Level 3 process
45103 100000107886 3 3 Program Level 3 process
45104 100000107886 4 4  
45105 100000107886 5 5  
45106 100000107886 6 6  
45107 100000107886 13 13  
45108 100000107886 3 3 Program Level 3 process
45109 100000107886 4 4  
45110 100000107886 6 6  
45111 100000107886 17 17  
45112 100000107886 3 3 Program Level 3 process
45113 100000107886 12 12  
45114 100000107886 5 5  
45115 100000107886 85 85  
45116 100000107886 3 3 Program Level 3 process
45117 100000107886 4 4  
45118 100000107886 12 12  
45119 100000107886 5 5  
45120 100000107886 32 32  
45121 100000107886 17 17  
45122 100000107886 3 3 Program Level 3 process
45123 100000107886 11 11  
45124 100000107886 4 4  
45125 100000107886 17 17  
45126 100000107886 3 3 Program Level 3 process
45127 100000107886 9 9  
45128 100000107886 5 5  
45129 100000107886 6 6  
45130 100000107886 3 3 Program Level 3 process
45131 100000107886 12 12  
45132 100000107886 5 5  
45133 100000107886 3 3 Program Level 3 process
45134 100000107886 9 9  
45135 100000107886 10 10  
45136 100000107886 11 11  
45137 100000107886 4 4  
45138 100000107886 12 12  
45139 100000107886 5 5  
45140 100000107886 6 6  
45141 100000107886 17 17  
45142 100000107886 85 85  
45143 100000107886 3 3 Program Level 3 process
45144 100000107886 9 9  
45145 100000107886 13 13  
45146 100000107886 3 3 Program Level 3 process
45147 100000107886 9 9  
45148 100000107886 12 12  
45149 100000107886 5 5  
45150 100000107886 6 6  
45151 100000107886 3 3 Program Level 3 process
45152 100000107886 4 4  
45153 100000107886 17 17  
45154 100000107886 3 3 Program Level 3 process
45155 100000107886 6 6  
45156 100000107886 13 13  
45157 100000107886 3 3 Program Level 3 process
45158 100000107886 12 12  
45159 100000107886 5 5  
45160 100000107886 3 3 Program Level 3 process
45161 100000107886 4 4  
45162 100000107886 17 17  
45163 100000107886 3 3 Program Level 3 process
45164 100000107886 9 9  
45165 100000107886 5 5  
45166 100000107886 3 3 Program Level 1 process
45167 100000107886 4 4  
45168 100000107886 5 5  
45169 100000107886 6 6  
45170 100000107886 3 3 Program Level 3 process
45171 100000107886 4 4  
45172 100000107886 5 5  
45173 100000107886 6 6  
45174 100000107886 3 3 Program Level 3 process
45175 100000107886 4 4  
45176 100000107886 17 17  
45177 100000107886 3 3 Program Level 3 process
45178 100000107886 10 10  
45179 100000107886 11 11  
45180 100000107886 13 13  
45181 100000107886 3 3 Program Level 3 process
45182 100000107886 9 9  
45183 100000107886 10 10  
45184 100000107886 11 11  
45185 100000107886 4 4  
45186 100000107886 12 12  
45187 100000107886 5 5  
45188 100000107886 6 6  
45189 100000107886 17 17  
45190 100000107886 85 85  
45191 100000107886 3 3 Program Level 3 process
45192 100000107886 6 6  
45193 100000107886 13 13  
45194 100000107886 3 3 Program Level 3 process

Next page

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