Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

118 rows where facility_id = 100000207233

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
38949 100000207233 71 71 Program Level 2 process
38950 100000207233 29 29 Program Level 2 process
38951 100000207233 132 132 Program Level 2 process
38952 100000207233 53 53 Program Level 2 process
38953 100000207233 30 30 Program Level 2 process
38954 100000207233 22 22 Program Level 2 process
38955 100000207233 64 64 Program Level 2 process
38956 100000207233 1 1 Program Level 2 process
38957 100000207233 16 16 Program Level 2 process
38958 100000207233 58 58 Program Level 2 process
38959 100000207233 23 23 Program Level 2 process
38960 100000207233 70 70 Program Level 2 process
38961 100000207233 133 133 Program Level 2 process
38962 100000207233 50 50 Program Level 2 process
38963 100000207233 71 71 Program Level 2 process
38964 100000207233 129 129 Program Level 2 process
38965 100000207233 29 29 Program Level 2 process
38966 100000207233 18 18 Program Level 2 process
38967 100000207233 51 51 Program Level 2 process
38968 100000207233 132 132 Program Level 2 process
38969 100000207233 93 93 Program Level 2 process
38970 100000207233 53 53 Program Level 2 process
38971 100000207233 30 30 Program Level 2 process
38972 100000207233 22 22 Program Level 2 process
38973 100000207233 105 105 Program Level 2 process
38974 100000207233 87 87 Program Level 2 process
38975 100000207233 64 64 Program Level 2 process
38976 100000207233 86 86 Program Level 2 process
38977 100000207233 1 1 Program Level 2 process
38978 100000207233 16 16 Program Level 2 process
38979 100000207233 58 58 Program Level 2 process
38980 100000207233 23 23 Program Level 2 process
38981 100000207233 70 70 Program Level 2 process
38982 100000207233 3 3 Program Level 2 process
38983 100000207233 66 66  
38984 100000207233 33 33  
38985 100000207233 9 9  
38986 100000207233 39 39  
38987 100000207233 62 62  
38988 100000207233 99 99  
38989 100000207233 42 42  
38990 100000207233 100 100  
38991 100000207233 12 12  
38992 100000207233 19 19  
38993 100000207233 75 75  
38994 100000207233 92 92  
38995 100000207233 82 82  
38996 100000207233 5 5  
38997 100000207233 83 83  
38998 100000207233 32 32  
38999 100000207233 118 118  
39000 100000207233 72 72  
39001 100000207233 55 55  
39002 100000207233 59 59  
39003 100000207233 6 6  
39004 100000207233 76 76  
39005 100000207233 114 114  
39006 100000207233 17 17  
39007 100000207233 84 84  
39008 100000207233 43 43  
39009 100000207233 20 20  
39010 100000207233 94 94  
39011 100000207233 34 34  
39012 100000207233 108 108  
39013 100000207233 120 120  
39014 100000207233 109 109  
39015 100000207233 77 77  
39016 100000207233 97 97  
39017 100000207233 121 121  
39018 100000207233 106 106  
39019 100000207233 103 103  
39020 100000207233 110 110  
39021 100000207233 36 36  
39022 100000207233 85 85  
39023 100000207233 54 54  
39024 100000207233 61 61  
39025 100000207233 3 3 Program Level 2 process
39026 100000207233 66 66  
39027 100000207233 33 33  
39028 100000207233 9 9  
39029 100000207233 39 39  
39030 100000207233 62 62  
39031 100000207233 99 99  
39032 100000207233 42 42  
39033 100000207233 100 100  
39034 100000207233 12 12  
39035 100000207233 19 19  
39036 100000207233 75 75  
39037 100000207233 92 92  
39038 100000207233 82 82  
39039 100000207233 5 5  
39040 100000207233 83 83  
39041 100000207233 32 32  
39042 100000207233 118 118  
39043 100000207233 72 72  
39044 100000207233 55 55  
39045 100000207233 59 59  
39046 100000207233 6 6  
39047 100000207233 76 76  
39048 100000207233 114 114  

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