Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

33 rows where facility_id = 100000142179

✎ 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
17062 100000142179 50 50 Program Level 3 process
17063 100000142179 52 52 Program Level 3 process
17064 100000142179 51 51 Program Level 3 process
17065 100000142179 8 8 Program Level 3 process
17066 100000142179 8 8 Program Level 3 process
17067 100000142179 73 73 Program Level 3 process
17068 100000142179 92 92 Program Level 3 process
17069 100000142179 50 50 Program Level 3 process
17070 100000142179 73 73 Program Level 3 process
17071 100000142179 52 52 Program Level 3 process
17072 100000142179 51 51 Program Level 3 process
17073 100000142179 50 50 Program Level 3 process
17074 100000142179 73 73 Program Level 3 process
17075 100000142179 52 52 Program Level 3 process
17076 100000142179 51 51 Program Level 3 process
17077 100000142179 8 8 Program Level 3 process
17078 100000142179 92 92 Program Level 3 process
17079 100000142179 36 36 Program Level 3 process
17080 100000142179 3 3 Program Level 3 process
17081 100000142179 9 9  
17082 100000142179 92 92  
17083 100000142179 6 6  
17084 100000142179 36 36  
17085 100000142179 3 3 Program Level 3 process
17086 100000142179 9 9  
17087 100000142179 92 92  
17088 100000142179 6 6  
17089 100000142179 36 36  
17090 100000142179 3 3 Program Level 3 process
17091 100000142179 9 9  
17092 100000142179 92 92  
17093 100000142179 6 6  
17094 100000142179 36 36  

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