Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

33 rows where facility_id = 100000057528

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
41430 100000057528 1 1 Program Level 3 process
41431 100000057528 2 2 Program Level 3 process
41432 100000057528 3 3 Program Level 3 process
41433 100000057528 33 33  
41434 100000057528 9 9  
41435 100000057528 10 10  
41436 100000057528 11 11  
41437 100000057528 14 14  
41438 100000057528 4 4  
41439 100000057528 99 99  
41440 100000057528 12 12  
41441 100000057528 82 82  
41442 100000057528 5 5  
41443 100000057528 83 83  
41444 100000057528 32 32  
41445 100000057528 118 118  
41446 100000057528 72 72  
41447 100000057528 6 6  
41448 100000057528 76 76  
41449 100000057528 17 17  
41450 100000057528 84 84  
41451 100000057528 94 94  
41452 100000057528 108 108  
41453 100000057528 109 109  
41454 100000057528 77 77  
41455 100000057528 97 97  
41456 100000057528 98 98  
41457 100000057528 106 106  
41458 100000057528 103 103  
41459 100000057528 110 110  
41460 100000057528 13 13  
41461 100000057528 85 85  
41462 100000057528 44 44  

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