testToSQLite

Custom SQL query returning 101 rows (show)

Query parameters

rowidini_codeini_nameact_roleact_nameact_typeact_loc
172 NAZCA_18_68 RE100 partner ASABRI Investor Indonesia
229 NAZCA_18_68 RE100 participant Indonesian Agency for Agricultural Research and Development National Government Indonesia
103 NY14_AG_17 Global Research Alliance on Agriculture Partner African Development Bank Intergovernmental Organization International
111 NY14_AG_17 Global Research Alliance on Agriculture Partner European Commission Intergovernmental Organization International
114 NY14_AG_17 Global Research Alliance on Agriculture Partner Food and Agriculture Organization (FAO) Intergovernmental Organization International
118 NY14_AG_17 Global Research Alliance on Agriculture Partner Inter-American Development Bank (IDB) Intergovernmental Organization International
121 NY14_AG_17 Global Research Alliance on Agriculture Partner World Bank Intergovernmental Organization International
269 NAZCA_18_75 SE4All: United for Efficiency Partner African Development Bank Intergovernmental Organization International
277 NAZCA_18_75 SE4All: United for Efficiency Partner European Commission Intergovernmental Organization International
280 NAZCA_18_75 SE4All: United for Efficiency Partner Food and Agriculture Organization (FAO) Intergovernmental Organization International
284 NAZCA_18_75 SE4All: United for Efficiency Partner Inter-American Development Bank (IDB) Intergovernmental Organization International
287 NAZCA_18_75 SE4All: United for Efficiency Partner World Bank Intergovernmental Organization International
108 NY14_AG_17 Global Research Alliance on Agriculture Partner "Climate Change Agriculture and Food Security (CCAFS)" International NGO
274 NAZCA_18_75 SE4All: United for Efficiency Partner "Climate Change Agriculture and Food Security (CCAFS)" International NGO
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
101 NY14_AG_17 Global Research Alliance on Agriculture Partner "4 Per 1000 Initiative" Other Italy
102 NY14_AG_17 Global Research Alliance on Agriculture Partner Agricultural Model Intercomparison and Improvement Project (AgMIP) International NGO Italy
104 NY14_AG_17 Global Research Alliance on Agriculture Partner Centre for Agriculture and Bioscience International (CABI) International NGO Italy
105 NY14_AG_17 Global Research Alliance on Agriculture Partner Caribbean Agricultural Research & Development Institute (CARDI) International NGO Italy
106 NY14_AG_17 Global Research Alliance on Agriculture Partner Tropical Agronomic Center for Research and Teaching (CATIE) International NGO Italy
112 NY14_AG_17 Global Research Alliance on Agriculture Partner FACCE-JPI International NGO Italy
113 NY14_AG_17 Global Research Alliance on Agriculture Partner FONTAGRO International NGO Italy
115 NY14_AG_17 Global Research Alliance on Agriculture Partner Global Agri-Business Alliance (GAA) Business Italy
116 NY14_AG_17 Global Research Alliance on Agriculture Partner Global Open Data for Agriculture and Nutrition (GODAN) International NGO Italy
119 NY14_AG_17 Global Research Alliance on Agriculture Partner Inter-American Institute for Cooperation on Agriculture (IICA) Research & Education Italy
120 NY14_AG_17 Global Research Alliance on Agriculture Partner World Soil Information (ISRIC) Research & Education Italy
122 NY14_AG_17 Global Research Alliance on Agriculture Partner World Business Council for Sustainable Development (WBCSD) Other Italy
123 NY14_AG_17 Global Research Alliance on Agriculture Partner World Farmers Organisation (WFO) International NGO Italy
143 NCI_04 C40 Cities Climate Leadership Challenge Partner Food and Agriculture Organisation for the United Nations (FAO) Intergovernmental Organization Italy
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
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
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
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
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
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
309 NAZCA_18_73 The New York Declaration on Forests Partner Food and Agriculture Organisation for the United Nations (FAO) Intergovernmental Organization Italy
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
68 NY14_AG_17 Global Research Alliance on Agriculture participant Ministry of Agriculture National Government Lithuania
234 NAZCA_18_68 RE100 participant Ministry of Agriculture National Government Lithuania
69 NY14_AG_17 Global Research Alliance on Agriculture participant Environmental Affairs Department National Government Malawi
235 NAZCA_18_68 RE100 participant Environmental Affairs Department National Government Malawi
70 NY14_AG_17 Global Research Alliance on Agriculture participant Malaysian Agricultural Research and Development Institute National Government Malaysia
236 NAZCA_18_68 RE100 participant Malaysian Agricultural Research and Development Institute National Government Malaysia
72 NY14_AG_17 Global Research Alliance on Agriculture participant Secretariat of Agriculture and Rural Development (SAGARPA) National Government Mexico
238 NAZCA_18_68 RE100 participant Secretariat of Agriculture and Rural Development (SAGARPA) National Government Mexico
71 NY14_AG_17 Global Research Alliance on Agriculture participant Ministry of Environment and Tourism National Government Mongolia
237 NAZCA_18_68 RE100 participant Ministry of Environment and Tourism National Government Mongolia
73 NY14_AG_17 Global Research Alliance on Agriculture participant Ministry of Environment and Tourism National Government Namibia
239 NAZCA_18_68 RE100 participant Ministry of Environment and Tourism National Government Namibia
37 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Livestock and Fisheries" National Government
59 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Food & Forestry" National Government
64 NY14_AG_17 Global Research Alliance on Agriculture participant "Department of Agriculture Food & the Marine" National Government
65 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Food Agriculture and Forestry Politics" National Government
66 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Forestry and Fisheries" National Government
67 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Food and Rural Affairs" National Government
74 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Nature and Food Quality" National Government
86 NY14_AG_17 Global Research Alliance on Agriculture participant "Department of Agriculture Forestry and Fisheries" National Government
92 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Water Resources and Fisheries" National Government
94 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry of Agriculture Animal Industry and Fisheries" National Government
95 NY14_AG_17 Global Research Alliance on Agriculture participant "Department for Environment Food and Rural Affairs" National Government
97 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry for livestock Agriculture and Fishery" National Government
100 NY14_AG_17 Global Research Alliance on Agriculture participant "Ministry for Agriculture Mechanisation and Irrigation Development" National Government
127 NCI_04 C40 Cities Climate Leadership Challenge funder "Department for Business Energy and Industrial Strategy of the United Kingdom (BEIS)" National Government
128 NCI_04 C40 Cities Climate Leadership Challenge funder "Federal Ministry for the Environment Nature Conservation and Nuclear Safety" National Government
164 NCI_04 C40 Cities Climate Leadership Challenge Funder "Department for Business Energy and Industrial Strategy of the United Kingdom (BEIS)" National Government
203 NAZCA_18_68 RE100 participant "Ministry of Agriculture Livestock and Fisheries" National Government
225 NAZCA_18_68 RE100 participant "Ministry of Agriculture Food & Forestry" National Government
230 NAZCA_18_68 RE100 participant "Department of Agriculture Food & the Marine" National Government
231 NAZCA_18_68 RE100 participant "Ministry of Food Agriculture and Forestry Politics" National Government
232 NAZCA_18_68 RE100 participant "Ministry of Agriculture Forestry and Fisheries" National Government
233 NAZCA_18_68 RE100 participant "Ministry of Agriculture Food and Rural Affairs" National Government
240 NAZCA_18_68 RE100 participant "Ministry of Agriculture Nature and Food Quality" National Government
252 NAZCA_18_68 RE100 participant "Department of Agriculture Forestry and Fisheries" National Government
258 NAZCA_18_68 RE100 participant "Ministry of Agriculture Water Resources and Fisheries" National Government
260 NAZCA_18_68 RE100 participant "Ministry of Agriculture Animal Industry and Fisheries" National Government
261 NAZCA_18_68 RE100 participant "Department for Environment Food and Rural Affairs" National Government
263 NAZCA_18_68 RE100 participant "Ministry for livestock Agriculture and Fishery" National Government
266 NAZCA_18_68 RE100 participant "Ministry for Agriculture Mechanisation and Irrigation Development" National Government
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
330 NAZCA_18_73 The New York Declaration on Forests Funder "Department for Business Energy and Industrial Strategy of the United Kingdom (BEIS)" National Government
1 NAZCA_OPS_21 Climate Action 100+ Coalition partner ACTIAM Investor Netherlands
134 NCI_04 C40 Cities Climate Leadership Challenge Partner Bernard Van Leer Foundation International NGO Netherlands
142 NCI_04 C40 Cities Climate Leadership Challenge Partner European Climate Foundation International NGO Netherlands
167 NAZCA_18_68 RE100 partner ACTIAM Investor Netherlands
300 NAZCA_18_73 The New York Declaration on Forests Partner Bernard Van Leer Foundation International NGO Netherlands
308 NAZCA_18_73 The New York Declaration on Forests Partner European Climate Foundation International NGO Netherlands
75 NY14_AG_17 Global Research Alliance on Agriculture participant Ministry for Primary Industries National Government New Zealand
241 NAZCA_18_68 RE100 participant Ministry for Primary Industries National Government New Zealand
76 NY14_AG_17 Global Research Alliance on Agriculture participant Nicaraguan Institute of Agricultural Technology (INTA) National Government Nicaragua
242 NAZCA_18_68 RE100 participant Nicaraguan Institute of Agricultural Technology (INTA) National Government Nicaragua
77 NY14_AG_17 Global Research Alliance on Agriculture participant Agricultural Research Council of Nigeria National Government Nigeria