testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
269 16 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
272 16 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
276 17 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
278 17 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
280 17 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
281 17 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
283 17 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
284 17 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national develoment strategy for a specific sector 3
297 18 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
298 18 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
300 18 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
304 18 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
306 18 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
312 19 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
314 19 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
315 19 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
317 19 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
324 20 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
328 20 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
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
334 20 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
341 21 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
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
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
351 21 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
355 21 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
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
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
368 22 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
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
375 23 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
383 23 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
385 23 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
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
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
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
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
405 24 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
406 24 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
407 24 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
408 24 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
409 25 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
410 25 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
411 25 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
414 25 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
418 25 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
419 25 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
423 25 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
425 25 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
426 26 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
433 26 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
436 26 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
440 26 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
443 27 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
445 27 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
447 27 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
451 27 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
453 27 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
457 27 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
459 27 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
460 28 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
463 28 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
464 28 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
466 28 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
468 28 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
469 28 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
470 28 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
472 28 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
473 28 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
474 28 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
478 29 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
479 29 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
483 29 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
484 29 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
485 29 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
487 29 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
491 29 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
492 29 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
493 29 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
494 30 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
497 30 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
500 30 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
501 30 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
502 30 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
504 30 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
506 30 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
508 30 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
509 30 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
511 31 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
518 31 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
519 31 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3