testToSQLite

Custom SQL query returning 72 rows (show)

Query parameters

rowidini_codeini_nameact_roleact_nameact_typeact_loc
17 NAZCA_OPS_21 Climate Action 100+ Coalition partner Ivey Foundation Investor Canada
27 NAZCA_OPS_21 Climate Action 100+ Coalition partner Shareholder Association for Research and Education International NGO Canada
183 NAZCA_18_68 RE100 partner Ivey Foundation Investor Canada
193 NAZCA_18_68 RE100 partner Shareholder Association for Research and Education International NGO 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
33 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Representative Church Body of the Church of Ireland International NGO Ireland
199 NAZCA_18_68 RE100 partner The Representative Church Body of the Church of Ireland International NGO Ireland
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
8 NAZCA_OPS_21 Climate Action 100+ Coalition partner Ethos Foundation Other Switzerland
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
30 NAZCA_OPS_21 Climate Action 100+ Coalition partner Terre des Hommes International NGO Switzerland
174 NAZCA_18_68 RE100 partner Ethos Foundation Other 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
196 NAZCA_18_68 RE100 partner Terre des Hommes International NGO Switzerland
3 NAZCA_OPS_21 Climate Action 100+ Coalition partner AllianceBernstein Investor USA
4 NAZCA_OPS_21 Climate Action 100+ Coalition partner Amherst College Research & Education USA
20 NAZCA_OPS_21 Climate Action 100+ Coalition partner Nathan Cummings Foundation International NGO USA
21 NAZCA_OPS_21 Climate Action 100+ Coalition partner Neuberger Berman Investor USA
26 NAZCA_OPS_21 Climate Action 100+ Coalition partner Seventh Generation Interfaith Inc International NGO 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
170 NAZCA_18_68 RE100 partner Amherst College Research & Education USA
186 NAZCA_18_68 RE100 partner Nathan Cummings Foundation International NGO USA
187 NAZCA_18_68 RE100 partner Neuberger Berman Investor USA
192 NAZCA_18_68 RE100 partner Seventh Generation Interfaith Inc International NGO 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
28 NAZCA_OPS_21 Climate Action 100+ Coalition partner Sisters of St Dominic of Caldwell International NGO 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
194 NAZCA_18_68 RE100 partner Sisters of St Dominic of Caldwell International NGO 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