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

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
30529 100000056734 24 24 Program Level 3 process
30530 100000056734 1 1 Program Level 3 process
30531 100000056734 3 3 Program Level 3 process
30532 100000056734 9 9  
30533 100000056734 10 10  
30534 100000056734 11 11  
30535 100000056734 4 4  
30536 100000056734 12 12  
30537 100000056734 5 5  
30538 100000056734 83 83  
30539 100000056734 32 32  
30540 100000056734 6 6  
30541 100000056734 76 76  
30542 100000056734 17 17  
30543 100000056734 84 84  
30544 100000056734 97 97  
30545 100000056734 98 98  
30546 100000056734 13 13  
30547 100000056734 85 85  
30548 100000056734 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);