Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
60 rows where chemical_id = 18
This data as json, CSV (advanced)
program_level 3
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 245 | 100000033493 | 18 18 | Program Level 3 process |
| 307 | 100000052836 | 18 18 | Program Level 1 process |
| 312 | 100000052836 | 18 18 | Program Level 1 process |
| 594 | 100000144015 | 18 18 | Program Level 3 process |
| 595 | 100000144015 | 18 18 | Program Level 3 process |
| 716 | 100000177998 | 18 18 | Program Level 3 process |
| 1105 | 100000108901 | 18 18 | Program Level 3 process |
| 1124 | 100000108901 | 18 18 | Program Level 3 process |
| 1186 | 100000108901 | 18 18 | Program Level 3 process |
| 1219 | 100000108901 | 18 18 | Program Level 3 process |
| 1300 | 100000108901 | 18 18 | Program Level 3 process |
| 1346 | 100000111899 | 18 18 | Program Level 3 process |
| 1784 | 100000153399 | 18 18 | Program Level 3 process |
| 3722 | 100000130574 | 18 18 | Program Level 3 process |
| 7120 | 100000060694 | 18 18 | Program Level 2 process |
| 7144 | 100000076749 | 18 18 | Program Level 3 process |
| 7183 | 100000140947 | 18 18 | Program Level 3 process |
| 8928 | 100000193499 | 18 18 | Program Level 3 process |
| 10773 | 100000016902 | 18 18 | Program Level 3 process |
| 11151 | 100000030931 | 18 18 | Program Level 2 process |
| 11382 | 100000060809 | 18 18 | Program Level 3 process |
| 11939 | 100000082929 | 18 18 | Program Level 3 process |
| 13012 | 100000152372 | 18 18 | Program Level 3 process |
| 13789 | 100000049422 | 18 18 | Program Level 3 process |
| 13915 | 100000069739 | 18 18 | Program Level 2 process |
| 15453 | 100000100106 | 18 18 | Program Level 3 process |
| 16990 | 100000120601 | 18 18 | Program Level 3 process |
| 21971 | 100000227523 | 18 18 | Program Level 3 process |
| 22919 | 100000028524 | 18 18 | Program Level 3 process |
| 25459 | 100000090233 | 18 18 | Program Level 3 process |
| 25553 | 100000127819 | 18 18 | Program Level 3 process |
| 27683 | 100000059991 | 18 18 | Program Level 1 process |
| 29689 | 100000076464 | 18 18 | Program Level 3 process |
| 32019 | 100000088004 | 18 18 | Program Level 3 process |
| 32599 | 100000050703 | 18 18 | Program Level 3 process |
| 32603 | 100000051141 | 18 18 | Program Level 3 process |
| 33508 | 100000142115 | 18 18 | Program Level 3 process |
| 37243 | 100000064958 | 18 18 | Program Level 1 process |
| 37420 | 100000100892 | 18 18 | Program Level 3 process |
| 38786 | 100000119132 | 18 18 | Program Level 2 process |
| 38891 | 100000166456 | 18 18 | Program Level 3 process |
| 38966 | 100000207233 | 18 18 | Program Level 2 process |
| 39386 | 100000033769 | 18 18 | Program Level 3 process |
| 39511 | 100000071272 | 18 18 | Program Level 3 process |
| 39538 | 100000082689 | 18 18 | Program Level 3 process |
| 39637 | 100000129318 | 18 18 | Program Level 3 process |
| 41511 | 100000059107 | 18 18 | Program Level 3 process |
| 43548 | 100000080921 | 18 18 | Program Level 3 process |
| 43674 | 100000082983 | 18 18 | Program Level 3 process |
| 44322 | 100000089334 | 18 18 | Program Level 3 process |
| 46858 | 100000119677 | 18 18 | Program Level 3 process |
| 47233 | 100000131074 | 18 18 | Program Level 3 process |
| 48224 | 100000147209 | 18 18 | Program Level 1 process |
| 51248 | 100000197672 | 18 18 | Program Level 3 process |
| 53605 | 100000232214 | 18 18 | Program Level 2 process |
| 55905 | 100000071619 | 18 18 | Program Level 1 process |
| 55963 | 100000112488 | 18 18 | Program Level 2 process |
| 56585 | 100000054371 | 18 18 | Program Level 3 process |
| 56651 | 100000073948 | 18 18 | Program Level 3 process |
| 58130 | 100000083438 | 18 18 | Program Level 3 process |
Advanced export
JSON shape: default, array, newline-delimited, object
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);