Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

70 rows where chemical_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
476 100000099779 42 42 Program Level 3 process
964 100000062326 42 42  
1112 100000108901 42 42 Program Level 3 process
1131 100000108901 42 42 Program Level 3 process
1193 100000108901 42 42 Program Level 3 process
1227 100000108901 42 42 Program Level 3 process
1248 100000108901 42 42 Program Level 3 process
1307 100000108901 42 42 Program Level 3 process
4431 100000147557 42 42 Program Level 3 process
4434 100000147557 42 42  
7395 100000111808 42 42 Program Level 3 process
7396 100000127631 42 42 Program Level 3 process
11911 100000080315 42 42 Program Level 3 process
12666 100000144266 42 42 Program Level 3 process
13804 100000049422 42 42 Program Level 3 process
13940 100000069739 42 42 Program Level 2 process
16895 100000091866 42 42 Program Level 3 process
16942 100000100115 42 42 Program Level 3 process
16955 100000104745 42 42 Program Level 3 process
16984 100000117802 42 42 Program Level 3 process
18536 100000082082 42 42 Program Level 3 process
19241 100000096601 42 42 Program Level 3 process
19245 100000096601 42 42 Program Level 3 process
19285 100000098869 42 42 Program Level 3 process
20609 100000132812 42 42 Program Level 3 process
20613 100000132812 42 42 Program Level 3 process
20616 100000133438 42 42 Program Level 3 process
20619 100000133438 42 42 Program Level 3 process
20743 100000137407 42 42 Program Level 3 process
20970 100000140714 42 42 Program Level 3 process
20971 100000140714 42 42 Program Level 3 process
21357 100000169462 42 42 Program Level 3 process
21418 100000173509 42 42 Program Level 3 process
21705 100000202899 42 42 Program Level 3 process
21709 100000202899 42 42 Program Level 3 process
21710 100000202899 42 42 Program Level 3 process
21713 100000202899 42 42 Program Level 3 process
21719 100000202899 42 42 Program Level 3 process
21722 100000202899 42 42 Program Level 3 process
22928 100000028524 42 42 Program Level 3 process
25998 100000022067 42 42 Program Level 3 process
29703 100000076464 42 42 Program Level 3 process
30568 100000069374 42 42  
30572 100000069374 42 42  
30650 100000118446 42 42 Program Level 3 process
30662 100000127597 42 42 Program Level 3 process
30678 100000131957 42 42 Program Level 3 process
33313 100000110131 42 42 Program Level 3 process
35193 100000094284 42 42 Program Level 3 process
37395 100000091697 42 42 Program Level 3 process
38732 100000089637 42 42 Program Level 3 process
38989 100000207233 42 42  
39032 100000207233 42 42  
41545 100000059107 42 42 Program Level 3 process
43232 100000078015 42 42 Program Level 3 process
43297 100000079489 42 42 Program Level 3 process
43499 100000079826 42 42 Program Level 3 process
43503 100000079826 42 42 Program Level 3 process
43506 100000079826 42 42  
43602 100000081234 42 42 Program Level 3 process
43857 100000084794 42 42 Program Level 3 process
46070 100000117562 42 42 Program Level 3 process
46937 100000125429 42 42 Program Level 3 process
46943 100000125429 42 42 Program Level 3 process
46971 100000125429 42 42 Program Level 3 process
48001 100000140769 42 42 Program Level 3 process
49480 100000152425 42 42 Program Level 3 process
50070 100000157796 42 42 Program Level 3 process
53486 100000230626 42 42 Program Level 3 process
55028 100000253218 42 42 Program Level 2 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);