Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

30 rows where facility_id = 100000146736

✎ 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
48142 100000146736 71 71 Program Level 3 process
48143 100000146736 17 17 Program Level 3 process
48144 100000146736 44 44 Program Level 3 process
48145 100000146736 71 71 Program Level 3 process
48146 100000146736 30 30 Program Level 3 process
48147 100000146736 84 84 Program Level 3 process
48148 100000146736 71 71 Program Level 3 process
48149 100000146736 44 44 Program Level 3 process
48150 100000146736 88 88 Program Level 3 process
48151 100000146736 71 71 Program Level 3 process
48152 100000146736 1 1 Program Level 3 process
48153 100000146736 71 71 Program Level 3 process
48154 100000146736 17 17 Program Level 3 process
48155 100000146736 3 3 Program Level 3 process
48156 100000146736 66 66  
48157 100000146736 4 4  
48158 100000146736 17 17  
48159 100000146736 3 3 Program Level 3 process
48160 100000146736 84 84  
48161 100000146736 61 61  
48162 100000146736 3 3 Program Level 3 process
48163 100000146736 66 66  
48164 100000146736 4 4  
48165 100000146736 17 17  
48166 100000146736 3 3 Program Level 3 process
48167 100000146736 4 4  
48168 100000146736 12 12  
48169 100000146736 5 5  
48170 100000146736 17 17  
48171 100000146736 84 84  

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