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 = 100000115314

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
45565 100000115314 3 3 Program Level 3 process
45566 100000115314 9 9  
45567 100000115314 10 10  
45568 100000115314 11 11  
45569 100000115314 4 4  
45570 100000115314 99 99  
45571 100000115314 12 12  
45572 100000115314 5 5  
45573 100000115314 83 83  
45574 100000115314 32 32  
45575 100000115314 118 118  
45576 100000115314 6 6  
45577 100000115314 17 17  
45578 100000115314 28 28  
45579 100000115314 84 84  
45580 100000115314 109 109  
45581 100000115314 77 77  
45582 100000115314 97 97  
45583 100000115314 98 98  
45584 100000115314 110 110  

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