Rmp Facility Chemicals
Data license: ODbL · Data source: EDGI Cloud Portal
27 rows where facility_id = 100000066778
This data as json, CSV (advanced)
Suggested facets: chemical_id
program_level 1
| facility_chemical_id ▼ | facility_id | chemical_id | program_level |
|---|---|---|---|
| 18429 | 100000066778 | 4 4 | Program Level 3 process |
| 18430 | 100000066778 | 3 3 | Program Level 3 process |
| 18431 | 100000066778 | 9 9 | |
| 18432 | 100000066778 | 10 10 | |
| 18433 | 100000066778 | 11 11 | |
| 18434 | 100000066778 | 4 4 | |
| 18435 | 100000066778 | 12 12 | |
| 18436 | 100000066778 | 5 5 | |
| 18437 | 100000066778 | 6 6 | |
| 18438 | 100000066778 | 3 3 | Program Level 3 process |
| 18439 | 100000066778 | 9 9 | |
| 18440 | 100000066778 | 11 11 | |
| 18441 | 100000066778 | 4 4 | |
| 18442 | 100000066778 | 12 12 | |
| 18443 | 100000066778 | 5 5 | |
| 18444 | 100000066778 | 6 6 | |
| 18445 | 100000066778 | 3 3 | Program Level 3 process |
| 18446 | 100000066778 | 10 10 | |
| 18447 | 100000066778 | 11 11 | |
| 18448 | 100000066778 | 3 3 | Program Level 3 process |
| 18449 | 100000066778 | 9 9 | |
| 18450 | 100000066778 | 10 10 | |
| 18451 | 100000066778 | 11 11 | |
| 18452 | 100000066778 | 4 4 | |
| 18453 | 100000066778 | 12 12 | |
| 18454 | 100000066778 | 5 5 | |
| 18455 | 100000066778 | 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);