Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
17 rows where facility_id = 100000147913 and program_level = "Program Level 1 process"
This data as json, CSV (advanced)
program_level 1
- Program Level 1 process · 17 ✖
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 48262 | 100000147913 | 3 3 | Program Level 1 process |
| 48273 | 100000147913 | 3 3 | Program Level 1 process |
| 48275 | 100000147913 | 3 3 | Program Level 1 process |
| 48289 | 100000147913 | 3 3 | Program Level 1 process |
| 48303 | 100000147913 | 3 3 | Program Level 1 process |
| 48328 | 100000147913 | 3 3 | Program Level 1 process |
| 48360 | 100000147913 | 3 3 | Program Level 1 process |
| 48374 | 100000147913 | 3 3 | Program Level 1 process |
| 48382 | 100000147913 | 3 3 | Program Level 1 process |
| 48414 | 100000147913 | 3 3 | Program Level 1 process |
| 48425 | 100000147913 | 3 3 | Program Level 1 process |
| 48439 | 100000147913 | 3 3 | Program Level 1 process |
| 48451 | 100000147913 | 3 3 | Program Level 1 process |
| 48467 | 100000147913 | 3 3 | Program Level 1 process |
| 48498 | 100000147913 | 3 3 | Program Level 1 process |
| 48523 | 100000147913 | 3 3 | Program Level 1 process |
| 48543 | 100000147913 | 3 3 | Program Level 1 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);