Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

60 rows where facility_id = 100000059107

✎ View and edit SQL

This data as json, CSV (advanced)

program_level 1

facility_chemical_id ▼ facility_id chemical_id program_level
41507 100000059107 54 54 Program Level 3 process
41508 100000059107 53 53 Program Level 3 process
41509 100000059107 81 81 Program Level 3 process
41510 100000059107 32 32 Program Level 3 process
41511 100000059107 18 18 Program Level 3 process
41512 100000059107 95 95 Program Level 3 process
41513 100000059107 50 50 Program Level 3 process
41514 100000059107 122 122 Program Level 3 process
41515 100000059107 134 134 Program Level 3 process
41516 100000059107 29 29 Program Level 3 process
41517 100000059107 104 104 Program Level 3 process
41518 100000059107 19 19 Program Level 3 process
41519 100000059107 75 75 Program Level 3 process
41520 100000059107 82 82 Program Level 3 process
41521 100000059107 6 6 Program Level 3 process
41522 100000059107 64 64 Program Level 3 process
41523 100000059107 16 16 Program Level 3 process
41524 100000059107 1 1 Program Level 3 process
41525 100000059107 127 127 Program Level 3 process
41526 100000059107 62 62 Program Level 3 process
41527 100000059107 36 36 Program Level 3 process
41528 100000059107 4 4 Program Level 3 process
41529 100000059107 106 106 Program Level 3 process
41530 100000059107 103 103 Program Level 3 process
41531 100000059107 76 76 Program Level 3 process
41532 100000059107 84 84 Program Level 3 process
41533 100000059107 109 109 Program Level 3 process
41534 100000059107 77 77 Program Level 3 process
41535 100000059107 9 9 Program Level 3 process
41536 100000059107 12 12 Program Level 3 process
41537 100000059107 100 100 Program Level 3 process
41538 100000059107 20 20 Program Level 3 process
41539 100000059107 35 35 Program Level 3 process
41540 100000059107 72 72 Program Level 3 process
41541 100000059107 5 5 Program Level 3 process
41542 100000059107 83 83 Program Level 3 process
41543 100000059107 65 65 Program Level 3 process
41544 100000059107 21 21 Program Level 3 process
41545 100000059107 42 42 Program Level 3 process
41546 100000059107 73 73 Program Level 3 process
41547 100000059107 2 2 Program Level 3 process
41548 100000059107 26 26 Program Level 3 process
41549 100000059107 8 8 Program Level 3 process
41550 100000059107 31 31 Program Level 3 process
41551 100000059107 1 1 Program Level 3 process
41552 100000059107 58 58 Program Level 3 process
41553 100000059107 66 66 Program Level 3 process
41554 100000059107 23 23 Program Level 3 process
41555 100000059107 52 52 Program Level 3 process
41556 100000059107 135 135 Program Level 3 process
41557 100000059107 105 105 Program Level 3 process
41558 100000059107 40 40 Program Level 3 process
41559 100000059107 68 68 Program Level 3 process
41560 100000059107 51 51 Program Level 3 process
41561 100000059107 96 96 Program Level 3 process
41562 100000059107 115 115 Program Level 3 process
41563 100000059107 107 107 Program Level 3 process
41564 100000059107 123 123 Program Level 3 process
41565 100000059107 30 30 Program Level 3 process
41566 100000059107 74 74 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);