Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

30 rows where chemical_id = 56

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
635 100000152586 56 56 Program Level 3 process
1360 100000117189 56 56 Program Level 3 process
7376 100000088166 56 56 Program Level 3 process
7607 100000049716 56 56 Program Level 3 process
8977 100000217366 56 56 Program Level 3 process
18502 100000073822 56 56 Program Level 3 process
18582 100000085061 56 56 Program Level 3 process
18598 100000085953 56 56 Program Level 3 process
22437 100000216027 56 56 Program Level 3 process
30975 100000193471 56 56 Program Level 3 process
30977 100000193471 56 56 Program Level 3 process
32020 100000088308 56 56 Program Level 3 process
35195 100000095871 56 56 Program Level 3 process
36591 100000184819 56 56 Program Level 3 process
37338 100000070479 56 56 Program Level 3 process
37447 100000109811 56 56 Program Level 3 process
37631 100000131207 56 56 Program Level 3 process
41757 100000061096 56 56 Program Level 3 process
44335 100000089824 56 56 Program Level 3 process
44846 100000095265 56 56 Program Level 3 process
44885 100000097851 56 56 Program Level 3 process
47815 100000139398 56 56 Program Level 3 process
48772 100000148798 56 56 Program Level 3 process
49136 100000151998 56 56 Program Level 3 process
49145 100000152103 56 56 Program Level 3 process
49533 100000154049 56 56 Program Level 3 process
50811 100000179442 56 56 Program Level 3 process
51135 100000194602 56 56 Program Level 3 process
51704 100000203549 56 56 Program Level 3 process
53761 100000233687 56 56 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);