testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
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
18 2 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
19 2 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
20 2 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
21 2 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
22 2 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
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
24 2 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
25 2 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
26 2 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
27 2 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
28 2 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
29 2 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
30 2 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (three) of the nation's international commitments and agendas 4
31 2 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
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
324 20 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
325 20 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
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
327 20 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
328 20 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
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
331 20 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
332 20 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
333 20 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
334 20 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
335 20 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
336 20 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (three) of the nation's international commitments and agendas 4
337 20 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
338 20 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by public/private and local stakeholders 4
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
340 20 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
341 21 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
342 21 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
343 21 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
344 21 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
345 21 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
346 21 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
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
348 21 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
349 21 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
350 21 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
351 21 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
352 21 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
353 21 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (three) of the nation's international commitments and agendas 4
354 21 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
355 21 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
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
358 22 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
359 22 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
360 22 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided two additional social co-benefits to the main adaptation goal 3
361 22 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
362 22 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
363 22 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
364 22 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies Positive synergies between adaptation and mitigation is/was a main target of the project 4
365 22 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
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
368 22 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
369 22 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
370 22 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (three) of the nation's international commitments and agendas 4
371 22 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
372 22 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
373 22 Scalability & Replicability Sustainability Sustainability The project integrates multiple stakeholderes and has a business model case and or a finance mechanism to continue opperations beyond the project lifetime 3
374 22 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
375 23 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
376 23 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
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
378 23 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
379 23 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
380 23 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal 4
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
382 23 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
383 23 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
384 23 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
385 23 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
386 23 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
387 23 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (two) of the nation's international commitments and agendas 3
388 23 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
389 23 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
390 23 Scalability & Replicability Sustainability Sustainability The project integrates multiple stakeholderes and has a business model case and or a finance mechanism to continue opperations beyond the project lifetime 3
391 23 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
392 24 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
393 24 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
394 24 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
395 24 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
396 24 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Income diversification of the local community is a target of the project 4
397 24 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
398 24 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
399 24 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
400 24 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
401 24 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
402 24 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
403 24 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4