Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

71 rows where facility_id = 100000230546

✎ 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
53389 100000230546 3 3 Program Level 3 process
53390 100000230546 9 9  
53391 100000230546 10 10  
53392 100000230546 11 11  
53393 100000230546 4 4  
53394 100000230546 12 12  
53395 100000230546 5 5  
53396 100000230546 6 6  
53397 100000230546 17 17  
53398 100000230546 111 111  
53399 100000230546 3 3 Program Level 3 process
53400 100000230546 9 9  
53401 100000230546 10 10  
53402 100000230546 11 11  
53403 100000230546 4 4  
53404 100000230546 12 12  
53405 100000230546 5 5  
53406 100000230546 6 6  
53407 100000230546 17 17  
53408 100000230546 111 111  
53409 100000230546 3 3 Program Level 3 process
53410 100000230546 9 9  
53411 100000230546 10 10  
53412 100000230546 11 11  
53413 100000230546 4 4  
53414 100000230546 12 12  
53415 100000230546 5 5  
53416 100000230546 6 6  
53417 100000230546 17 17  
53418 100000230546 111 111  
53419 100000230546 3 3 Program Level 3 process
53420 100000230546 9 9  
53421 100000230546 10 10  
53422 100000230546 11 11  
53423 100000230546 4 4  
53424 100000230546 12 12  
53425 100000230546 5 5  
53426 100000230546 6 6  
53427 100000230546 17 17  
53428 100000230546 111 111  
53429 100000230546 3 3 Program Level 3 process
53430 100000230546 9 9  
53431 100000230546 12 12  
53432 100000230546 5 5  
53433 100000230546 6 6  
53434 100000230546 3 3 Program Level 3 process
53435 100000230546 33 33  
53436 100000230546 11 11  
53437 100000230546 4 4  
53438 100000230546 12 12  
53439 100000230546 5 5  
53440 100000230546 17 17  
53441 100000230546 111 111  
53442 100000230546 3 3 Program Level 3 process
53443 100000230546 33 33  
53444 100000230546 11 11  
53445 100000230546 4 4  
53446 100000230546 12 12  
53447 100000230546 5 5  
53448 100000230546 17 17  
53449 100000230546 111 111  
53450 100000230546 3 3 Program Level 3 process
53451 100000230546 9 9  
53452 100000230546 10 10  
53453 100000230546 11 11  
53454 100000230546 4 4  
53455 100000230546 12 12  
53456 100000230546 5 5  
53457 100000230546 6 6  
53458 100000230546 17 17  
53459 100000230546 111 111  

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