Rmp Facility Chemicals

Data table with 59,323 records and 4 columns.

Data license: ODbL · Data source: EDGI Cloud Portal

73 rows where facility_id = 100000142357

✎ 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
24 100000142357 3 3 Program Level 3 process
25 100000142357 9 9  
26 100000142357 10 10  
27 100000142357 11 11  
28 100000142357 4 4  
29 100000142357 12 12  
30 100000142357 5 5  
31 100000142357 6 6  
32 100000142357 3 3 Program Level 3 process
33 100000142357 10 10  
34 100000142357 11 11  
35 100000142357 4 4  
36 100000142357 5 5  
37 100000142357 6 6  
38 100000142357 13 13  
39 100000142357 3 3 Program Level 3 process
40 100000142357 9 9  
41 100000142357 10 10  
42 100000142357 11 11  
43 100000142357 4 4  
44 100000142357 12 12  
45 100000142357 5 5  
46 100000142357 6 6  
47 100000142357 13 13  
48 100000142357 3 3 Program Level 3 process
49 100000142357 10 10  
50 100000142357 11 11  
51 100000142357 4 4  
52 100000142357 12 12  
53 100000142357 5 5  
54 100000142357 6 6  
55 100000142357 3 3 Program Level 3 process
56 100000142357 9 9  
57 100000142357 10 10  
58 100000142357 11 11  
59 100000142357 4 4  
60 100000142357 12 12  
61 100000142357 5 5  
62 100000142357 6 6  
63 100000142357 3 3 Program Level 3 process
64 100000142357 9 9  
65 100000142357 10 10  
66 100000142357 11 11  
67 100000142357 4 4  
68 100000142357 12 12  
69 100000142357 5 5  
70 100000142357 6 6  
71 100000142357 13 13  
72 100000142357 3 3 Program Level 3 process
73 100000142357 9 9  
74 100000142357 10 10  
75 100000142357 11 11  
76 100000142357 4 4  
77 100000142357 12 12  
78 100000142357 5 5  
79 100000142357 6 6  
80 100000142357 3 3 Program Level 3 process
81 100000142357 12 12  
82 100000142357 5 5  
83 100000142357 6 6  
84 100000142357 3 3 Program Level 3 process
85 100000142357 9 9  
86 100000142357 4 4  
87 100000142357 12 12  
88 100000142357 5 5  
89 100000142357 6 6  
90 100000142357 3 3 Program Level 3 process
91 100000142357 10 10  
92 100000142357 11 11  
93 100000142357 4 4  
94 100000142357 5 5  
95 100000142357 6 6  
96 100000142357 13 13  

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