testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

rowidini_codeini_nameact_roleact_nameact_typeact_loc
137 NCI_04 C40 Cities Climate Leadership Challenge Partner Climate KIC - EIT International NGO Belgium
138 NCI_04 C40 Cities Climate Leadership Challenge Partner The Climate Change Collaborative Other United States
139 NCI_04 C40 Cities Climate Leadership Challenge Partner ClimateWorks Foundation International NGO United States
140 NCI_04 C40 Cities Climate Leadership Challenge Partner Dell Business United States
141 NCI_04 C40 Cities Climate Leadership Challenge Partner Eat Foundation International NGO Norway
142 NCI_04 C40 Cities Climate Leadership Challenge Partner European Climate Foundation International NGO Netherlands
143 NCI_04 C40 Cities Climate Leadership Challenge Partner Food and Agriculture Organisation for the United Nations (FAO) Intergovernmental Organization Italy
144 NCI_04 C40 Cities Climate Leadership Challenge Partner Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) Business Germany
145 NCI_04 C40 Cities Climate Leadership Challenge Partner Google Business United States
146 NCI_04 C40 Cities Climate Leadership Challenge Partner Grundfos International NGO Denmark
147 NCI_04 C40 Cities Climate Leadership Challenge Partner INKGA / IKEA Business Sweden
148 NCI_04 C40 Cities Climate Leadership Challenge Partner KR Foundation International NGO Denmark
149 NCI_04 C40 Cities Climate Leadership Challenge Partner L‘Oréal Business France
150 NCI_04 C40 Cities Climate Leadership Challenge Partner Mastercard Business United States
151 NCI_04 C40 Cities Climate Leadership Challenge Partner McConnell Foundation International NGO Canada
152 NCI_04 C40 Cities Climate Leadership Challenge Partner Michelin Corporate Foundation International NGO France
153 NCI_04 C40 Cities Climate Leadership Challenge Partner Microsoft Business United States
154 NCI_04 C40 Cities Climate Leadership Challenge Partner Novo Nordisk Business Denmark
155 NCI_04 C40 Cities Climate Leadership Challenge Partner Qlik Business Sweden
156 NCI_04 C40 Cities Climate Leadership Challenge Partner Ramboll Foundation International NGO Denmark
157 NCI_04 C40 Cities Climate Leadership Challenge Partner Rockefeller Brothers Fund International NGO United States
158 NCI_04 C40 Cities Climate Leadership Challenge Partner ROCKWOOL Group Business Denmark
159 NCI_04 C40 Cities Climate Leadership Challenge Partner Suez North America Business United States
160 NCI_04 C40 Cities Climate Leadership Challenge Partner Wallace Global Fund International NGO United States
161 NCI_04 C40 Cities Climate Leadership Challenge Partner The William and Flora Hewlett Foundation International NGO United States
162 NCI_04 C40 Cities Climate Leadership Challenge Partner World Bank / Global Environment Facility Intergovernmental Organization United States
163 NCI_04 C40 Cities Climate Leadership Challenge Funder German Federal Ministry for Economic Cooperation and Development (BMZ) National Government Germany
164 NCI_04 C40 Cities Climate Leadership Challenge Funder "Department for Business Energy and Industrial Strategy of the United Kingdom (BEIS)" National Government
165 NCI_04 C40 Cities Climate Leadership Challenge Funder United States Agency for International Development (USAID) National Government United States
166 NCI_04 C40 Cities Climate Leadership Challenge Funder Children’s Investment Fund Foundation (CIFF) International NGO United States
1 NAZCA_OPS_21 Climate Action 100+ Coalition partner ACTIAM Investor Netherlands
2 NAZCA_OPS_21 Climate Action 100+ Coalition partner Alecta Investor Sweden
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
5 NAZCA_OPS_21 Climate Action 100+ Coalition partner Amundi Investor France
6 NAZCA_OPS_21 Climate Action 100+ Coalition partner ASABRI Investor Indonesia
7 NAZCA_OPS_21 Climate Action 100+ Coalition partner Asset Managment One Company Ltd. Investor Japan
8 NAZCA_OPS_21 Climate Action 100+ Coalition partner Ethos Foundation Other Switzerland
9 NAZCA_OPS_21 Climate Action 100+ Coalition partner Folksam 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
15 NAZCA_OPS_21 Climate Action 100+ Coalition partner FRR Investor Finland
16 NAZCA_OPS_21 Climate Action 100+ Coalition partner Grantham Mayo Van Otterloo and Co LLC Investor United Kingdom
17 NAZCA_OPS_21 Climate Action 100+ Coalition partner Ivey Foundation Investor Canada
18 NAZCA_OPS_21 Climate Action 100+ Coalition partner Mistra The Swedish Foundation for Strategic Environmental Research Investor Sweden
19 NAZCA_OPS_21 Climate Action 100+ Coalition partner MPC Renewable Energies Investor Germany
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
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
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
26 NAZCA_OPS_21 Climate Action 100+ Coalition partner Seventh Generation Interfaith Inc International NGO USA
27 NAZCA_OPS_21 Climate Action 100+ Coalition partner Shareholder Association for Research and Education International NGO Canada
28 NAZCA_OPS_21 Climate Action 100+ Coalition partner Sisters of St Dominic of Caldwell International NGO United Kingdom
29 NAZCA_OPS_21 Climate Action 100+ Coalition partner Skoll Foundation Investor USA
30 NAZCA_OPS_21 Climate Action 100+ Coalition partner Terre des Hommes International NGO Switzerland
31 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Joseph Rowntree Charitable Trust Investor United Kingdom
32 NAZCA_OPS_21 Climate Action 100+ Coalition partner The McKnight Foundation Investor USA
33 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Representative Church Body of the Church of Ireland International NGO Ireland
34 NAZCA_OPS_21 Climate Action 100+ Coalition partner The Sustainability Group of Loring Wolcott Coolidge Investor USA
35 NAZCA_OPS_21 Climate Action 100+ Coalition partner Tundra Fonder Investor Sweden
36 NAZCA_OPS_21 Climate Action 100+ Coalition partner Walter Scott and Partners Limited Investor United Kingdom
267 NAZCA_18_75 SE4All: United for Efficiency Partner "4 Per 1000 Initiative" Other Italy
268 NAZCA_18_75 SE4All: United for Efficiency Partner Agricultural Model Intercomparison and Improvement Project (AgMIP) International NGO Italy
269 NAZCA_18_75 SE4All: United for Efficiency Partner African Development Bank Intergovernmental Organization International
270 NAZCA_18_75 SE4All: United for Efficiency Partner Centre for Agriculture and Bioscience International (CABI) International NGO Italy
271 NAZCA_18_75 SE4All: United for Efficiency Partner Caribbean Agricultural Research & Development Institute (CARDI) International NGO Italy
272 NAZCA_18_75 SE4All: United for Efficiency Partner Tropical Agronomic Center for Research and Teaching (CATIE) International NGO Italy
273 NAZCA_18_75 SE4All: United for Efficiency Partner Climate & Clean Air Coalition (CCAC) International NGO France
274 NAZCA_18_75 SE4All: United for Efficiency Partner "Climate Change Agriculture and Food Security (CCAFS)" International NGO
275 NAZCA_18_75 SE4All: United for Efficiency Partner Consultative Group on International Agricultural Research (CGIAR) Other France
276 NAZCA_18_75 SE4All: United for Efficiency Partner International Centre for Advanced Mediterranean Agronomic Studies (CIHEAM) International NGO France
277 NAZCA_18_75 SE4All: United for Efficiency Partner European Commission Intergovernmental Organization International
278 NAZCA_18_75 SE4All: United for Efficiency Partner FACCE-JPI International NGO Italy
279 NAZCA_18_75 SE4All: United for Efficiency Partner FONTAGRO International NGO Italy
280 NAZCA_18_75 SE4All: United for Efficiency Partner Food and Agriculture Organization (FAO) Intergovernmental Organization International
281 NAZCA_18_75 SE4All: United for Efficiency Partner Global Agri-Business Alliance (GAA) Business Italy
282 NAZCA_18_75 SE4All: United for Efficiency Partner Global Open Data for Agriculture and Nutrition (GODAN) International NGO Italy
283 NAZCA_18_75 SE4All: United for Efficiency Partner Greenhouse Gas Management Institute (GHGMI) Research & Education France
284 NAZCA_18_75 SE4All: United for Efficiency Partner Inter-American Development Bank (IDB) Intergovernmental Organization International
285 NAZCA_18_75 SE4All: United for Efficiency Partner Inter-American Institute for Cooperation on Agriculture (IICA) Research & Education Italy
286 NAZCA_18_75 SE4All: United for Efficiency Partner World Soil Information (ISRIC) Research & Education Italy
287 NAZCA_18_75 SE4All: United for Efficiency Partner World Bank Intergovernmental Organization International
288 NAZCA_18_75 SE4All: United for Efficiency Partner World Business Council for Sustainable Development (WBCSD) Other Italy
289 NAZCA_18_75 SE4All: United for Efficiency Partner World Farmers Organisation (WFO) International NGO Italy
290 NAZCA_18_75 SE4All: United for Efficiency funder Arup Business United Kingdom
291 NAZCA_18_75 SE4All: United for Efficiency funder Citi Foundation International NGO United States
292 NAZCA_18_75 SE4All: United for Efficiency funder Clean Air Fund International NGO United Kingdom
293 NAZCA_18_75 SE4All: United for Efficiency funder "Department for Business Energy and Industrial Strategy of the United Kingdom (BEIS)" National Government
294 NAZCA_18_75 SE4All: United for Efficiency funder "Federal Ministry for the Environment Nature Conservation and Nuclear Safety" National Government
295 NAZCA_18_75 SE4All: United for Efficiency funder Johnson & Johnson Business United States
296 NAZCA_18_75 SE4All: United for Efficiency funder Ministry of Foreign Affairs of Denmark National Government Denmark
297 NAZCA_18_75 SE4All: United for Efficiency funder Oak Foundation International NGO Denmark
298 NAZCA_18_73 The New York Declaration on Forests Partner Autodesk Inc. Business United States
299 NAZCA_18_73 The New York Declaration on Forests Partner AXA Business France
300 NAZCA_18_73 The New York Declaration on Forests Partner Bernard Van Leer Foundation International NGO Netherlands
301 NAZCA_18_73 The New York Declaration on Forests Partner Cities Alliance / United Nations Office for Project Services Intergovernmental Organization Belgium