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

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
24867 100000139833 37 37 Program Level 3 process
24868 100000139833 1 1 Program Level 3 process
24869 100000139833 3 3 Program Level 3 process
24870 100000139833 9 9  
24871 100000139833 10 10  
24872 100000139833 11 11  
24873 100000139833 14 14  
24874 100000139833 4 4  
24875 100000139833 12 12  
24876 100000139833 5 5  
24877 100000139833 83 83  
24878 100000139833 32 32  
24879 100000139833 72 72  
24880 100000139833 6 6  
24881 100000139833 76 76  
24882 100000139833 17 17  
24883 100000139833 84 84  
24884 100000139833 94 94  
24885 100000139833 109 109  
24886 100000139833 77 77  
24887 100000139833 97 97  
24888 100000139833 98 98  
24889 100000139833 13 13  
24890 100000139833 85 85  
24891 100000139833 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);