testToSQLite

Custom SQL query returning 101 rows (show)

Query parameters

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
7 1 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
21 2 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
23 2 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
26 2 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
32 2 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
33 2 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
34 2 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
36 3 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using global evidence 2
40 3 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
49 3 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
56 4 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
60 4 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
73 5 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
77 5 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
84 5 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
89 6 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
96 6 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project provides limited support to address capacity needs 2
101 6 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
102 6 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
106 7 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
112 7 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
117 7 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
125 8 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
128 8 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
129 8 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
135 8 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
136 8 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
141 9 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
151 9 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
158 10 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
160 10 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
163 10 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
168 10 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
169 10 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
177 11 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
179 11 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
180 11 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
185 11 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
186 11 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
187 11 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
208 13 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
211 13 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
214 13 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
219 13 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
220 13 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
221 13 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
225 14 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
228 14 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
235 14 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
244 15 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
248 15 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
253 15 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
260 16 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
265 16 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
270 16 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
271 16 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
273 17 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Outputs outlined 2
274 17 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using global evidence 2
282 17 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
287 17 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
289 17 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
290 18 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Outputs outlined 2
294 18 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
296 18 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
305 18 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
311 19 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
320 19 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
321 19 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
322 19 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
323 19 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
326 20 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided one additional social co-benefit to the main adaptation goal 2
329 20 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
330 20 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
333 20 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
337 20 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
339 20 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
344 21 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
347 21 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
349 21 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
354 21 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
356 21 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
357 21 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
362 22 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
366 22 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
367 22 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
371 22 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
374 22 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
377 23 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided one additional social co-benefit to the main adaptation goal 2
379 23 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
381 23 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
388 23 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
415 25 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
417 25 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
422 25 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
439 26 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
452 27 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
462 28 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided one additional social co-benefit to the main adaptation goal 2
465 28 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
476 28 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
482 29 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
490 29 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2