Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

59 rows where facility_id = 100000049422

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
13775 100000049422 80 80 Program Level 3 process
13776 100000049422 66 66 Program Level 3 process
13777 100000049422 88 88 Program Level 3 process
13778 100000049422 65 65 Program Level 3 process
13779 100000049422 71 71 Program Level 3 process
13780 100000049422 8 8 Program Level 3 process
13781 100000049422 40 40 Program Level 3 process
13782 100000049422 37 37 Program Level 3 process
13783 100000049422 9 9 Program Level 3 process
13784 100000049422 47 47 Program Level 3 process
13785 100000049422 62 62 Program Level 3 process
13786 100000049422 31 31 Program Level 3 process
13787 100000049422 29 29 Program Level 3 process
13788 100000049422 73 73 Program Level 3 process
13789 100000049422 18 18 Program Level 3 process
13790 100000049422 51 51 Program Level 3 process
13791 100000049422 53 53 Program Level 3 process
13792 100000049422 30 30 Program Level 3 process
13793 100000049422 74 74 Program Level 3 process
13794 100000049422 112 112 Program Level 3 process
13795 100000049422 7 7 Program Level 3 process
13796 100000049422 8 8 Program Level 3 process
13797 100000049422 24 24 Program Level 3 process
13798 100000049422 1 1 Program Level 3 process
13799 100000049422 25 25 Program Level 3 process
13800 100000049422 60 60 Program Level 3 process
13801 100000049422 2 2 Program Level 3 process
13802 100000049422 69 69 Program Level 3 process
13803 100000049422 4 4 Program Level 3 process
13804 100000049422 42 42 Program Level 3 process
13805 100000049422 100 100 Program Level 3 process
13806 100000049422 12 12 Program Level 3 process
13807 100000049422 75 75 Program Level 3 process
13808 100000049422 82 82 Program Level 3 process
13809 100000049422 5 5 Program Level 3 process
13810 100000049422 83 83 Program Level 3 process
13811 100000049422 32 32 Program Level 3 process
13812 100000049422 72 72 Program Level 3 process
13813 100000049422 6 6 Program Level 3 process
13814 100000049422 76 76 Program Level 3 process
13815 100000049422 17 17 Program Level 3 process
13816 100000049422 28 28 Program Level 3 process
13817 100000049422 84 84 Program Level 3 process
13818 100000049422 20 20 Program Level 3 process
13819 100000049422 108 108 Program Level 3 process
13820 100000049422 109 109 Program Level 3 process
13821 100000049422 77 77 Program Level 3 process
13822 100000049422 97 97 Program Level 3 process
13823 100000049422 98 98 Program Level 3 process
13824 100000049422 106 106 Program Level 3 process
13825 100000049422 103 103 Program Level 3 process
13826 100000049422 36 36 Program Level 3 process
13827 100000049422 85 85 Program Level 3 process
13828 100000049422 16 16 Program Level 3 process
13829 100000049422 58 58 Program Level 3 process
13830 100000049422 23 23 Program Level 3 process
13831 100000049422 70 70 Program Level 3 process
13832 100000049422 54 54 Program Level 3 process
13833 100000049422 61 61 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);