Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

100 rows where chemical_id = 109

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
10068 100000138022 109 109  
11541 100000075884 109 109  
11585 100000075884 109 109  
11610 100000075884 109 109  
11679 100000075884 109 109  
11709 100000075884 109 109  
11739 100000075884 109 109  
11760 100000075884 109 109  
11799 100000075884 109 109  
11827 100000075884 109 109  
13820 100000049422 109 109 Program Level 3 process
19375 100000105726 109 109  
19855 100000113824 109 109  
19876 100000113824 109 109  
19913 100000113824 109 109  
19977 100000117759 109 109  
19994 100000117759 109 109  
20011 100000117759 109 109  
20028 100000117759 109 109  
20155 100000117759 109 109  
20170 100000117759 109 109  
20187 100000117759 109 109  
20204 100000117759 109 109  
20222 100000117759 109 109  
20274 100000118268 109 109  
24885 100000139833 109 109  
26271 100000086989 109 109  
26332 100000086989 109 109  
26507 100000086989 109 109  
37272 100000066796 109 109  
37590 100000130244 109 109  
39014 100000207233 109 109  
39056 100000207233 109 109  
40564 100000028551 109 109  
41453 100000057528 109 109  
41533 100000059107 109 109 Program Level 3 process
41599 100000059214 109 109  
41617 100000059214 109 109  
41635 100000059214 109 109  
41694 100000059214 109 109  
41883 100000062905 109 109  
41914 100000062905 109 109  
41971 100000062905 109 109  
41993 100000062905 109 109  
42167 100000062905 109 109  
42766 100000070987 109 109  
42864 100000070987 109 109  
42882 100000070987 109 109  
42916 100000070987 109 109  
43932 100000087862 109 109 Program Level 3 process
43946 100000088442 109 109  
44073 100000088914 109 109  
44167 100000088914 109 109  
44266 100000088914 109 109  
44362 100000089824 109 109  
44389 100000089824 109 109  
44412 100000089824 109 109  
44439 100000089824 109 109  
44937 100000100384 109 109 Program Level 3 process
45062 100000104736 109 109 Program Level 3 process
45580 100000115314 109 109  
45645 100000115779 109 109  
46088 100000118133 109 109  
46107 100000118133 109 109  
46142 100000118133 109 109  
46165 100000118133 109 109  
46191 100000118133 109 109  
46259 100000118133 109 109  
46344 100000118133 109 109  
46364 100000118133 109 109  
46381 100000118133 109 109  
46396 100000118133 109 109  
46418 100000118133 109 109  
46442 100000118133 109 109  
46486 100000118133 109 109  
46506 100000118133 109 109  
46529 100000118133 109 109  
46564 100000118133 109 109  
47260 100000131449 109 109  
47282 100000131449 109 109  
47647 100000137372 109 109 Program Level 3 process
47660 100000137372 109 109 Program Level 3 process
47674 100000137372 109 109 Program Level 3 process
47691 100000137372 109 109 Program Level 3 process
47713 100000137372 109 109 Program Level 3 process
47724 100000137372 109 109 Program Level 3 process
48138 100000146709 109 109  
49720 100000156172 109 109 Program Level 3 process
49835 100000157126 109 109  
49854 100000157126 109 109  
54743 100000247084 109 109 Program Level 3 process
54750 100000247084 109 109 Program Level 2 process
56271 100000028034 109 109  
56294 100000028034 109 109  
56318 100000028034 109 109  
56340 100000028034 109 109  
56373 100000028034 109 109  
56397 100000028034 109 109  
56803 100000099252 109 109  
57716 100000141401 109 109  

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