Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

79 rows where facility_id = 100000115779

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
45590 100000115779 88 88 Program Level 3 process
45591 100000115779 71 71 Program Level 3 process
45592 100000115779 1 1 Program Level 3 process
45593 100000115779 11 11 Program Level 3 process
45594 100000115779 4 4 Program Level 3 process
45595 100000115779 5 5 Program Level 3 process
45596 100000115779 17 17 Program Level 3 process
45597 100000115779 93 93 Program Level 3 process
45598 100000115779 22 22 Program Level 3 process
45599 100000115779 2 2 Program Level 3 process
45600 100000115779 11 11 Program Level 3 process
45601 100000115779 17 17 Program Level 3 process
45602 100000115779 44 44 Program Level 3 process
45603 100000115779 71 71 Program Level 3 process
45604 100000115779 53 53 Program Level 3 process
45605 100000115779 1 1 Program Level 3 process
45606 100000115779 1 1 Program Level 3 process
45607 100000115779 1 1 Program Level 3 process
45608 100000115779 88 88 Program Level 3 process
45609 100000115779 7 7 Program Level 3 process
45610 100000115779 88 88 Program Level 3 process
45611 100000115779 71 71 Program Level 3 process
45612 100000115779 4 4 Program Level 3 process
45613 100000115779 12 12 Program Level 3 process
45614 100000115779 17 17 Program Level 3 process
45615 100000115779 3 3 Program Level 3 process
45616 100000115779 12 12  
45617 100000115779 5 5  
45618 100000115779 83 83  
45619 100000115779 32 32  
45620 100000115779 59 59  
45621 100000115779 84 84  
45622 100000115779 97 97  
45623 100000115779 98 98  
45624 100000115779 110 110  
45625 100000115779 3 3 Program Level 3 process
45626 100000115779 82 82  
45627 100000115779 32 32  
45628 100000115779 3 3 Program Level 3 process
45629 100000115779 9 9  
45630 100000115779 10 10  
45631 100000115779 11 11  
45632 100000115779 14 14  
45633 100000115779 4 4  
45634 100000115779 12 12  
45635 100000115779 82 82  
45636 100000115779 5 5  
45637 100000115779 32 32  
45638 100000115779 118 118  
45639 100000115779 6 6  
45640 100000115779 76 76  
45641 100000115779 17 17  
45642 100000115779 84 84  
45643 100000115779 94 94  
45644 100000115779 108 108  
45645 100000115779 109 109  
45646 100000115779 77 77  
45647 100000115779 97 97  
45648 100000115779 98 98  
45649 100000115779 106 106  
45650 100000115779 103 103  
45651 100000115779 110 110  
45652 100000115779 13 13  
45653 100000115779 44 44  
45654 100000115779 3 3 Program Level 3 process
45655 100000115779 10 10  
45656 100000115779 11 11  
45657 100000115779 44 44  
45658 100000115779 3 3 Program Level 3 process
45659 100000115779 66 66  
45660 100000115779 10 10  
45661 100000115779 4 4  
45662 100000115779 12 12  
45663 100000115779 5 5  
45664 100000115779 59 59  
45665 100000115779 6 6  
45666 100000115779 17 17  
45667 100000115779 28 28  
45668 100000115779 84 84  

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