Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

18 rows where facility_id = 100000088442

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
43935 100000088442 3 3 Program Level 3 process
43936 100000088442 9 9  
43937 100000088442 10 10  
43938 100000088442 11 11  
43939 100000088442 4 4  
43940 100000088442 12 12  
43941 100000088442 5 5  
43942 100000088442 83 83  
43943 100000088442 32 32  
43944 100000088442 6 6  
43945 100000088442 76 76  
43946 100000088442 109 109  
43947 100000088442 77 77  
43948 100000088442 97 97  
43949 100000088442 98 98  
43950 100000088442 106 106  
43951 100000088442 103 103  
43952 100000088442 13 13  

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