Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

26 rows where chemical_id = 94

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
1929 100000006076 94 94 Program Level 1 process
19346 100000105209 94 94  
21128 100000146969 94 94  
21148 100000146969 94 94  
22160 100000246049 94 94 Program Level 3 process
24884 100000139833 94 94  
26504 100000086989 94 94  
37226 100000061407 94 94 Program Level 3 process
39010 100000207233 94 94  
39052 100000207233 94 94  
40135 100000008779 94 94  
40180 100000008779 94 94  
41451 100000057528 94 94  
45036 100000103924 94 94  
45643 100000115779 94 94  
45972 100000116661 94 94  
46719 100000119043 94 94  
47258 100000131449 94 94  
49612 100000154049 94 94  
49633 100000154049 94 94  
50689 100000176409 94 94  
51514 100000201863 94 94  
51530 100000201863 94 94  
51545 100000201863 94 94  
54671 100000245503 94 94  
54742 100000247084 94 94 Program Level 3 process

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