Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

259 rows where facility_id = 100000070987

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chemical_id

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
42679 100000070987 37 37 Program Level 3 process
42680 100000070987 37 37 Program Level 3 process
42681 100000070987 37 37 Program Level 3 process
42682 100000070987 37 37 Program Level 3 process
42683 100000070987 37 37 Program Level 3 process
42684 100000070987 37 37 Program Level 3 process
42685 100000070987 37 37 Program Level 3 process
42686 100000070987 37 37 Program Level 3 process
42687 100000070987 37 37 Program Level 3 process
42688 100000070987 37 37 Program Level 3 process
42689 100000070987 1 1 Program Level 3 process
42690 100000070987 24 24 Program Level 3 process
42691 100000070987 37 37 Program Level 3 process
42692 100000070987 24 24 Program Level 3 process
42693 100000070987 37 37 Program Level 3 process
42694 100000070987 37 37 Program Level 3 process
42695 100000070987 37 37 Program Level 3 process
42696 100000070987 3 3 Program Level 3 process
42697 100000070987 9 9  
42698 100000070987 83 83  
42699 100000070987 6 6  
42700 100000070987 76 76  
42701 100000070987 3 3 Program Level 3 process
42702 100000070987 9 9  
42703 100000070987 6 6  
42704 100000070987 76 76  
42705 100000070987 3 3 Program Level 3 process
42706 100000070987 9 9  
42707 100000070987 4 4  
42708 100000070987 12 12  
42709 100000070987 5 5  
42710 100000070987 83 83  
42711 100000070987 17 17  
42712 100000070987 84 84  
42713 100000070987 77 77  
42714 100000070987 97 97  
42715 100000070987 98 98  
42716 100000070987 103 103  
42717 100000070987 13 13  
42718 100000070987 3 3 Program Level 3 process
42719 100000070987 10 10  
42720 100000070987 13 13  
42721 100000070987 3 3 Program Level 3 process
42722 100000070987 9 9  
42723 100000070987 4 4  
42724 100000070987 12 12  
42725 100000070987 5 5  
42726 100000070987 83 83  
42727 100000070987 6 6  
42728 100000070987 84 84  
42729 100000070987 98 98  
42730 100000070987 3 3 Program Level 3 process
42731 100000070987 9 9  
42732 100000070987 10 10  
42733 100000070987 11 11  
42734 100000070987 4 4  
42735 100000070987 12 12  
42736 100000070987 5 5  
42737 100000070987 6 6  
42738 100000070987 13 13  
42739 100000070987 3 3 Program Level 3 process
42740 100000070987 4 4  
42741 100000070987 3 3 Program Level 3 process
42742 100000070987 9 9  
42743 100000070987 4 4  
42744 100000070987 12 12  
42745 100000070987 5 5  
42746 100000070987 6 6  
42747 100000070987 3 3 Program Level 3 process
42748 100000070987 9 9  
42749 100000070987 10 10  
42750 100000070987 11 11  
42751 100000070987 4 4  
42752 100000070987 12 12  
42753 100000070987 5 5  
42754 100000070987 6 6  
42755 100000070987 3 3 Program Level 3 process
42756 100000070987 9 9  
42757 100000070987 10 10  
42758 100000070987 11 11  
42759 100000070987 4 4  
42760 100000070987 12 12  
42761 100000070987 5 5  
42762 100000070987 6 6  
42763 100000070987 76 76  
42764 100000070987 17 17  
42765 100000070987 108 108  
42766 100000070987 109 109  
42767 100000070987 77 77  
42768 100000070987 97 97  
42769 100000070987 98 98  
42770 100000070987 106 106  
42771 100000070987 103 103  
42772 100000070987 85 85  
42773 100000070987 44 44  
42774 100000070987 3 3 Program Level 3 process
42775 100000070987 9 9  
42776 100000070987 10 10  
42777 100000070987 11 11  
42778 100000070987 4 4  

Next page

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