testToSQLite

Custom SQL query returning 56 rows (hide)

Query parameters

rowidini_codeini_nameact_roleact_nameact_typeact_loc
17 NAZCA_OPS_21 Climate Action 100+ Coalition partner Ivey Foundation Investor Canada
183 NAZCA_18_68 RE100 partner Ivey Foundation Investor Canada
15 NAZCA_OPS_21 Climate Action 100+ Coalition partner FRR Investor Finland
181 NAZCA_18_68 RE100 partner FRR Investor Finland
5 NAZCA_OPS_21 Climate Action 100+ Coalition partner Amundi Investor France
171 NAZCA_18_68 RE100 partner Amundi Investor France
19 NAZCA_OPS_21 Climate Action 100+ Coalition partner MPC Renewable Energies Investor Germany
185 NAZCA_18_68 RE100 partner MPC Renewable Energies Investor Germany
6 NAZCA_OPS_21 Climate Action 100+ Coalition partner ASABRI Investor Indonesia
172 NAZCA_18_68 RE100 partner ASABRI Investor Indonesia
7 NAZCA_OPS_21 Climate Action 100+ Coalition partner Asset Managment One Company Ltd. Investor Japan
173 NAZCA_18_68 RE100 partner Asset Managment One Company Ltd. Investor Japan
1 NAZCA_OPS_21 Climate Action 100+ Coalition partner ACTIAM Investor Netherlands
167 NAZCA_18_68 RE100 partner ACTIAM Investor Netherlands
2 NAZCA_OPS_21 Climate Action 100+ Coalition partner Alecta Investor Sweden
9 NAZCA_OPS_21 Climate Action 100+ Coalition partner Folksam Investor Sweden
18 NAZCA_OPS_21 Climate Action 100+ Coalition partner Mistra The Swedish Foundation for Strategic Environmental Research Investor Sweden
35 NAZCA_OPS_21 Climate Action 100+ Coalition partner Tundra Fonder Investor Sweden
168 NAZCA_18_68 RE100 partner Alecta Investor Sweden
175 NAZCA_18_68 RE100 partner Folksam Investor Sweden
184 NAZCA_18_68 RE100 partner Mistra The Swedish Foundation for Strategic Environmental Research Investor Sweden
201 NAZCA_18_68 RE100 partner Tundra Fonder Investor Sweden
10 NAZCA_OPS_21 Climate Action 100+ Coalition partner Fond metallurgie vaud batiment FMVB Investor Switzerland
11 NAZCA_OPS_21 Climate Action 100+ Coalition partner Fondation de prevoyance Artes et Comoedia Investor Switzerland
12 NAZCA_OPS_21 Climate Action 100+ Coalition partner Fondation de prevoyance du Groupe BNP PARIBAS en Suisse Investor Switzerland
13 NAZCA_OPS_21 Climate Action 100+ Coalition partner Fondation Leenaards Investor Switzerland
14 NAZCA_OPS_21 Climate Action 100+ Coalition partner Fonds de Prevoyance de CA Indosuez Investor Switzerland
22 NAZCA_OPS_21 Climate Action 100+ Coalition partner Profelia Fondation de Prevoyance Investor Switzerland
23 NAZCA_OPS_21 Climate Action 100+ Coalition partner Prosperita Stiftung Fur die Berufliche Vorsorge Investor Switzerland
176 NAZCA_18_68 RE100 partner Fond metallurgie vaud batiment FMVB Investor Switzerland
177 NAZCA_18_68 RE100 partner Fondation de prevoyance Artes et Comoedia Investor Switzerland
178 NAZCA_18_68 RE100 partner Fondation de prevoyance du Groupe BNP PARIBAS en Suisse Investor Switzerland
179 NAZCA_18_68 RE100 partner Fondation Leenaards Investor Switzerland
180 NAZCA_18_68 RE100 partner Fonds de Prevoyance de CA Indosuez Investor Switzerland
188 NAZCA_18_68 RE100 partner Profelia Fondation de Prevoyance Investor Switzerland
189 NAZCA_18_68 RE100 partner Prosperita Stiftung Fur die Berufliche Vorsorge Investor Switzerland
3 NAZCA_OPS_21 Climate Action 100+ Coalition partner AllianceBernstein Investor USA
21 NAZCA_OPS_21 Climate Action 100+ Coalition partner Neuberger Berman Investor USA
29 NAZCA_OPS_21 Climate Action 100+ Coalition partner Skoll Foundation Investor USA
32 NAZCA_OPS_21 Climate Action 100+ Coalition partner The McKnight Foundation Investor USA
34 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Sustainability Group of Loring Wolcott Coolidge Investor USA
169 NAZCA_18_68 RE100 partner AllianceBernstein Investor USA
187 NAZCA_18_68 RE100 partner Neuberger Berman Investor USA
195 NAZCA_18_68 RE100 partner Skoll Foundation Investor USA
198 NAZCA_18_68 RE100 partner The McKnight Foundation Investor USA
200 NAZCA_18_68 RE100 partner The Sustainability Group of Loring Wolcott Coolidge Investor USA
16 NAZCA_OPS_21 Climate Action 100+ Coalition partner Grantham Mayo Van Otterloo and Co LLC Investor United Kingdom
24 NAZCA_OPS_21 Climate Action 100+ Coalition partner Pyrford International Ltd Investor United Kingdom
25 NAZCA_OPS_21 Climate Action 100+ Coalition partner Sarasin Partners LLP Investor United Kingdom
31 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Joseph Rowntree Charitable Trust Investor United Kingdom
36 NAZCA_OPS_21 Climate Action 100+ Coalition partner Walter Scott and Partners Limited Investor United Kingdom
182 NAZCA_18_68 RE100 partner Grantham Mayo Van Otterloo and Co LLC Investor United Kingdom
190 NAZCA_18_68 RE100 partner Pyrford International Ltd Investor United Kingdom
191 NAZCA_18_68 RE100 partner Sarasin Partners LLP Investor United Kingdom
197 NAZCA_18_68 RE100 partner The Joseph Rowntree Charitable Trust Investor United Kingdom
202 NAZCA_18_68 RE100 partner Walter Scott and Partners Limited Investor United Kingdom