Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
12 rows where facility_id = 100000073378
This data as json, CSV (advanced)
Suggested facets: chemical_id
program_level 1
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 30578 | 100000073378 | 16 16 | Program Level 3 process |
| 30579 | 100000073378 | 8 8 | Program Level 3 process |
| 30580 | 100000073378 | 2 2 | Program Level 3 process |
| 30581 | 100000073378 | 8 8 | Program Level 3 process |
| 30582 | 100000073378 | 1 1 | Program Level 3 process |
| 30583 | 100000073378 | 3 3 | Program Level 3 process |
| 30584 | 100000073378 | 12 12 | |
| 30585 | 100000073378 | 5 5 | |
| 30586 | 100000073378 | 83 83 | |
| 30587 | 100000073378 | 84 84 | |
| 30588 | 100000073378 | 97 97 | |
| 30589 | 100000073378 | 98 98 |
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);