Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
11 rows where facility_id = 100000084339
This data as json, CSV (advanced)
Suggested facets: chemical_id
program_level 1
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 443 | 100000084339 | 37 37 | Program Level 3 process |
| 444 | 100000084339 | 4 4 | Program Level 3 process |
| 445 | 100000084339 | 12 12 | Program Level 3 process |
| 446 | 100000084339 | 3 3 | Program Level 3 process |
| 447 | 100000084339 | 9 9 | |
| 448 | 100000084339 | 10 10 | |
| 449 | 100000084339 | 11 11 | |
| 450 | 100000084339 | 4 4 | |
| 451 | 100000084339 | 12 12 | |
| 452 | 100000084339 | 5 5 | |
| 453 | 100000084339 | 6 6 |
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);