Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

12,550 rows where chemical_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
1 100000013521 1 1 Program Level 3 process
2 100000023654 1 1 Program Level 3 process
3 100000024252 1 1 Program Level 3 process
4 100000024289 1 1 Program Level 3 process
5 100000035678 1 1 Program Level 3 process
6 100000046407 1 1 Program Level 3 process
7 100000052747 1 1 Program Level 3 process
8 100000052747 1 1 Program Level 3 process
9 100000054718 1 1 Program Level 3 process
10 100000054718 1 1 Program Level 3 process
11 100000057779 1 1 Program Level 3 process
22 100000113003 1 1 Program Level 3 process
97 100000143515 1 1 Program Level 3 process
98 100000148592 1 1 Program Level 3 process
99 100000150034 1 1 Program Level 3 process
103 100000152201 1 1 Program Level 3 process
104 100000156724 1 1 Program Level 3 process
105 100000160504 1 1 Program Level 3 process
106 100000162691 1 1 Program Level 3 process
107 100000165849 1 1 Program Level 3 process
108 100000171574 1 1 Program Level 3 process
109 100000173974 1 1 Program Level 3 process
110 100000176132 1 1 Program Level 3 process
120 100000181304 1 1 Program Level 3 process
121 100000182811 1 1 Program Level 3 process
122 100000185836 1 1 Program Level 3 process
125 100000207705 1 1 Program Level 3 process
126 100000208704 1 1 Program Level 3 process
127 100000208802 1 1 Program Level 3 process
128 100000209179 1 1 Program Level 3 process
147 100000212147 1 1 Program Level 3 process
154 100000217598 1 1 Program Level 3 process
155 100000217712 1 1 Program Level 3 process
156 100000218052 1 1 Program Level 3 process
157 100000218123 1 1 Program Level 3 process
158 100000218702 1 1 Program Level 2 process
159 100000219051 1 1 Program Level 2 process
160 100000221887 1 1 Program Level 3 process
161 100000225151 1 1 Program Level 3 process
162 100000225437 1 1 Program Level 3 process
163 100000227275 1 1 Program Level 3 process
166 100000231466 1 1 Program Level 1 process
174 100000237004 1 1 Program Level 3 process
175 100000238922 1 1 Program Level 3 process
184 100000241874 1 1 Program Level 3 process
229 100000029355 1 1 Program Level 3 process
238 100000031397 1 1 Program Level 3 process
247 100000033652 1 1 Program Level 3 process
253 100000036472 1 1 Program Level 3 process
258 100000037113 1 1 Program Level 3 process
259 100000037113 1 1 Program Level 3 process
262 100000037774 1 1 Program Level 3 process
275 100000046791 1 1 Program Level 3 process
276 100000046791 1 1 Program Level 3 process
282 100000048977 1 1 Program Level 3 process
290 100000050044 1 1 Program Level 3 process
297 100000051926 1 1 Program Level 3 process
299 100000052435 1 1 Program Level 3 process
300 100000052541 1 1 Program Level 3 process
315 100000054683 1 1 Program Level 3 process
322 100000057591 1 1 Program Level 3 process
338 100000059802 1 1 Program Level 3 process
339 100000059973 1 1 Program Level 2 process
341 100000059982 1 1 Program Level 2 process
345 100000063094 1 1 Program Level 3 process
353 100000064235 1 1 Program Level 3 process
362 100000064761 1 1 Program Level 3 process
363 100000065181 1 1 Program Level 3 process
364 100000065225 1 1 Program Level 3 process
365 100000065234 1 1 Program Level 3 process
372 100000067438 1 1 Program Level 2 process
373 100000067438 1 1 Program Level 2 process
378 100000071174 1 1 Program Level 3 process
387 100000071815 1 1 Program Level 3 process
408 100000074224 1 1 Program Level 3 process
428 100000081877 1 1 Program Level 3 process
458 100000088255 1 1 Program Level 3 process
466 100000091633 1 1 Program Level 3 process
471 100000094051 1 1 Program Level 3 process
472 100000094159 1 1 Program Level 3 process
480 100000099877 1 1 Program Level 3 process
481 100000099877 1 1 Program Level 3 process
482 100000099877 1 1 Program Level 3 process
483 100000099877 1 1 Program Level 3 process
487 100000103693 1 1 Program Level 3 process
494 100000104433 1 1 Program Level 3 process
502 100000106431 1 1 Program Level 3 process
513 100000111149 1 1 Program Level 3 process
514 100000112898 1 1 Program Level 3 process
521 100000115582 1 1 Program Level 3 process
524 100000117198 1 1 Program Level 3 process
525 100000118259 1 1 Program Level 3 process
529 100000118419 1 1 Program Level 2 process
533 100000122315 1 1 Program Level 3 process
540 100000124304 1 1 Program Level 1 process
541 100000125893 1 1 Program Level 3 process
542 100000125893 1 1 Program Level 3 process
558 100000131635 1 1 Program Level 3 process
561 100000133036 1 1 Program Level 3 process
566 100000135169 1 1 Program Level 3 process

Next page

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