Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

12 rows where facility_id = 100000105691

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
14239 100000105691 3 3 Program Level 3 process
14240 100000105691 9 9  
14241 100000105691 4 4  
14242 100000105691 12 12  
14243 100000105691 5 5  
14244 100000105691 83 83  
14245 100000105691 32 32  
14246 100000105691 76 76  
14247 100000105691 17 17  
14248 100000105691 84 84  
14249 100000105691 97 97  
14250 100000105691 98 98  

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