Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

25 rows where facility_id = 100000115957

✎ 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
45677 100000115957 3 3 Program Level 3 process
45678 100000115957 10 10  
45679 100000115957 11 11  
45680 100000115957 13 13  
45681 100000115957 3 3 Program Level 3 process
45682 100000115957 9 9  
45683 100000115957 10 10  
45684 100000115957 11 11  
45685 100000115957 14 14  
45686 100000115957 4 4  
45687 100000115957 99 99  
45688 100000115957 82 82  
45689 100000115957 5 5  
45690 100000115957 32 32  
45691 100000115957 6 6  
45692 100000115957 76 76  
45693 100000115957 17 17  
45694 100000115957 84 84  
45695 100000115957 34 34  
45696 100000115957 97 97  
45697 100000115957 98 98  
45698 100000115957 110 110  
45699 100000115957 13 13  
45700 100000115957 85 85  
45701 100000115957 44 44  

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