Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

73 rows where chemical_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
257 100000036472 22 22 Program Level 3 process
2924 100000093285 22 22 Program Level 2 process
3614 100000121281 22 22 Program Level 3 process
3619 100000121281 22 22 Program Level 2 process
4784 100000156234 22 22 Program Level 3 process
4888 100000164902 22 22 Program Level 3 process
4964 100000173288 22 22 Program Level 3 process
5462 100000212192 22 22 Program Level 2 process
7127 100000060694 22 22 Program Level 2 process
8317 100000010016 22 22 Program Level 3 process
8503 100000073118 22 22 Program Level 2 process
9803 100000095942 22 22 Program Level 2 process
11389 100000060809 22 22 Program Level 3 process
11469 100000070102 22 22 Program Level 3 process
11486 100000072271 22 22 Program Level 2 process
12198 100000104273 22 22 Program Level 2 process
13916 100000069739 22 22 Program Level 2 process
15477 100000104077 22 22 Program Level 1 process
16030 100000135579 22 22 Program Level 3 process
16645 100000248261 22 22 Program Level 3 process
16734 100000044034 22 22 Program Level 2 process
17025 100000130342 22 22 Program Level 3 process
18159 100000045845 22 22 Program Level 2 process
18171 100000047816 22 22 Program Level 2 process
18173 100000047816 22 22 Program Level 2 process
18500 100000072725 22 22 Program Level 2 process
18633 100000088282 22 22 Program Level 3 process
21164 100000147995 22 22 Program Level 3 process
21565 100000188432 22 22 Program Level 3 process
22923 100000028524 22 22 Program Level 3 process
25131 100000216875 22 22 Program Level 3 process
25460 100000090233 22 22 Program Level 3 process
25942 100000243514 22 22 Program Level 2 process
29696 100000076464 22 22 Program Level 3 process
30503 100000041572 22 22 Program Level 2 process
30933 100000161549 22 22 Program Level 2 process
32619 100000056789 22 22 Program Level 2 process
32758 100000068099 22 22 Program Level 3 process
32822 100000068099 22 22 Program Level 3 process
32881 100000068099 22 22 Program Level 3 process
33236 100000093613 22 22 Program Level 2 process
33309 100000108457 22 22 Program Level 2 process
33839 100000201836 22 22 Program Level 1 process
37135 100000044338 22 22 Program Level 1 process
37396 100000091777 22 22 Program Level 2 process
38584 100000019151 22 22 Program Level 1 process
38620 100000030236 22 22 Program Level 3 process
38715 100000081671 22 22 Program Level 3 process
38954 100000207233 22 22 Program Level 2 process
38972 100000207233 22 22 Program Level 2 process
39116 100000247164 22 22 Program Level 3 process
39571 100000097655 22 22 Program Level 3 process
40874 100000041475 22 22 Program Level 2 process
41040 100000042884 22 22 Program Level 2 process
41204 100000047889 22 22 Program Level 2 process
41271 100000049663 22 22 Program Level 2 process
41319 100000051329 22 22 Program Level 2 process
42988 100000072789 22 22 Program Level 2 process
43226 100000077506 22 22 Program Level 2 process
43955 100000088781 22 22 Program Level 3 process
44903 100000099788 22 22 Program Level 3 process
45598 100000115779 22 22 Program Level 3 process
47548 100000135481 22 22 Program Level 3 process
49534 100000154049 22 22 Program Level 3 process
50096 100000158072 22 22 Program Level 3 process
52009 100000213823 22 22 Program Level 3 process
54079 100000237558 22 22 Program Level 1 process
55816 100000020461 22 22 Program Level 1 process
55931 100000081715 22 22 Program Level 2 process
56052 100000154806 22 22 Program Level 3 process
56685 100000086916 22 22 Program Level 2 process
57789 100000178522 22 22 Program Level 2 process
58131 100000083438 22 22 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);