Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
31 rows where facility_id = 100000107886 and program_level = "Program Level 3 process"
This data as json, CSV (advanced)
program_level 1
- Program Level 3 process · 31 ✖
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 45095 | 100000107886 | 9 9 | Program Level 3 process |
| 45096 | 100000107886 | 12 12 | Program Level 3 process |
| 45097 | 100000107886 | 4 4 | Program Level 3 process |
| 45098 | 100000107886 | 17 17 | Program Level 3 process |
| 45099 | 100000107886 | 24 24 | Program Level 3 process |
| 45100 | 100000107886 | 5 5 | Program Level 3 process |
| 45101 | 100000107886 | 5 5 | Program Level 3 process |
| 45102 | 100000107886 | 13 13 | Program Level 3 process |
| 45103 | 100000107886 | 3 3 | Program Level 3 process |
| 45108 | 100000107886 | 3 3 | Program Level 3 process |
| 45112 | 100000107886 | 3 3 | Program Level 3 process |
| 45116 | 100000107886 | 3 3 | Program Level 3 process |
| 45122 | 100000107886 | 3 3 | Program Level 3 process |
| 45126 | 100000107886 | 3 3 | Program Level 3 process |
| 45130 | 100000107886 | 3 3 | Program Level 3 process |
| 45133 | 100000107886 | 3 3 | Program Level 3 process |
| 45143 | 100000107886 | 3 3 | Program Level 3 process |
| 45146 | 100000107886 | 3 3 | Program Level 3 process |
| 45151 | 100000107886 | 3 3 | Program Level 3 process |
| 45154 | 100000107886 | 3 3 | Program Level 3 process |
| 45157 | 100000107886 | 3 3 | Program Level 3 process |
| 45160 | 100000107886 | 3 3 | Program Level 3 process |
| 45163 | 100000107886 | 3 3 | Program Level 3 process |
| 45170 | 100000107886 | 3 3 | Program Level 3 process |
| 45174 | 100000107886 | 3 3 | Program Level 3 process |
| 45177 | 100000107886 | 3 3 | Program Level 3 process |
| 45181 | 100000107886 | 3 3 | Program Level 3 process |
| 45191 | 100000107886 | 3 3 | Program Level 3 process |
| 45194 | 100000107886 | 3 3 | Program Level 3 process |
| 45197 | 100000107886 | 3 3 | Program Level 3 process |
| 45200 | 100000107886 | 3 3 | 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);