Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

23 rows where chemical_id = 105

✎ View and edit SQL

This data as json, CSV (advanced)

facility_chemical_id ▼ facility_id chemical_id program_level
5905 100000050927 105 105 Program Level 2 process
6458 100000176766 105 105 Program Level 3 process
6788 100000225918 105 105 Program Level 2 process
7089 100000248751 105 105 Program Level 2 process
7128 100000060694 105 105 Program Level 2 process
11390 100000060809 105 105 Program Level 3 process
14399 100000136756 105 105 Program Level 3 process
14400 100000136756 105 105 Program Level 3 process
14404 100000136756 105 105 Program Level 3 process
14609 100000200819 105 105 Program Level 2 process
21965 100000227523 105 105 Program Level 3 process
23263 100000098967 105 105 Program Level 3 process
23470 100000145354 105 105 Program Level 3 process
28142 100000246897 105 105 Program Level 2 process
29697 100000076464 105 105 Program Level 3 process
32824 100000068099 105 105 Program Level 3 process
32883 100000068099 105 105 Program Level 3 process
33833 100000201505 105 105 Program Level 3 process
38973 100000207233 105 105 Program Level 2 process
41557 100000059107 105 105 Program Level 3 process
50097 100000158072 105 105 Program Level 3 process
51119 100000193998 105 105 Program Level 3 process
52010 100000213823 105 105 Program Level 3 process

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);