Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

36 rows where facility_id = 100000063584

✎ 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
42256 100000063584 1 1 Program Level 3 process
42257 100000063584 2 2 Program Level 3 process
42258 100000063584 2 2 Program Level 3 process
42259 100000063584 2 2 Program Level 3 process
42260 100000063584 2 2 Program Level 3 process
42261 100000063584 2 2 Program Level 3 process
42262 100000063584 2 2 Program Level 3 process
42263 100000063584 1 1 Program Level 3 process
42264 100000063584 4 4 Program Level 3 process
42265 100000063584 17 17 Program Level 3 process
42266 100000063584 16 16 Program Level 3 process
42267 100000063584 44 44 Program Level 3 process
42268 100000063584 2 2 Program Level 3 process
42269 100000063584 3 3 Program Level 3 process
42270 100000063584 82 82  
42271 100000063584 6 6  
42272 100000063584 108 108  
42273 100000063584 3 3 Program Level 3 process
42274 100000063584 10 10  
42275 100000063584 11 11  
42276 100000063584 4 4  
42277 100000063584 5 5  
42278 100000063584 83 83  
42279 100000063584 32 32  
42280 100000063584 72 72  
42281 100000063584 17 17  
42282 100000063584 97 97  
42283 100000063584 98 98  
42284 100000063584 13 13  
42285 100000063584 44 44  
42286 100000063584 3 3 Program Level 3 process
42287 100000063584 5 5  
42288 100000063584 83 83  
42289 100000063584 32 32  
42290 100000063584 97 97  
42291 100000063584 98 98  

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