testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
681 41 Contribution to adaptation goal & co-benefits Effectiveness Monitoring mechanisms planned or in place   3
685 41 Contribution to adaptation goal & co-benefits Social Co-benefits Revenues are likely to increase from multiple sources   3
687 41 Contribution to adaptation goal & co-benefits Environmental Co-benefits The project accounted for and quantified mitigation synergies with adaptation   3
690 41 Contribution to adaptation goal & co-benefits Relevance The benefits of the project will be perceived within a year/season   3
691 41 Scalability & Replicability Easiness for Implementation The project addresses/addressed capacity needs   3
692 41 Scalability & Replicability Coherence The project's adaptation goals were aligned to a national develoment strategy for a specific sector   3
694 41 Scalability & Replicability Efficiency The costs of the project were shared by private and public stakeholders   3
695 41 Scalability & Replicability Efficiency The project requires 'soft' investements   3
1021 61 Contribution to adaptation goal & co-benefits Effectiveness Monitoring mechanisms planned or in place   3
1022 61 Contribution to adaptation goal & co-benefits Impact Vulnerabilities assessed using national evidence   3
1025 61 Contribution to adaptation goal & co-benefits Social Co-benefits Revenues are likely to increase from multiple sources   3
1029 61 Contribution to adaptation goal & co-benefits Relevance Two types of different measures proposed (coping, adaptative, transformative)   3
1031 61 Scalability & Replicability Easiness for Implementation The project addresses/addressed capacity needs   3
1032 61 Scalability & Replicability Coherence The project's adaptation goals were aligned to a national develoment strategy for a specific sector   3
1033 61 Scalability & Replicability Coherence The project's adaptation goals is/was aligned to (two) of the nation's international commitments and agendas   3
1034 61 Scalability & Replicability Efficiency The project requires 'soft' investements   3
1514 90 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1517 90 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1520 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1521 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1522 90 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1523 90 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1524 90 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1527 90 Scalability & Replicability Efficiency Efficiency for replicability   3
1528 90 Scalability & Replicability Efficiency Investment cost   3
1530 90 Scalability & Replicability Legitimacy Participatory Processes   3
1531 91 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1533 91 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   3
1537 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1538 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1539 91 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1540 91 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1541 91 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1544 91 Scalability & Replicability Efficiency Efficiency for replicability   3
1548 92 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1549 92 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1552 92 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1558 92 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1561 92 Scalability & Replicability Efficiency Efficiency for replicability   3
1562 92 Scalability & Replicability Efficiency Investment cost   3
1565 93 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1570 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   3
1571 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1573 93 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1574 93 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1575 93 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1580 93 Scalability & Replicability Sustainability Sustainability   3
1582 94 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1586 94 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1589 94 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1590 94 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1592 94 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1593 94 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   3
1594 94 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   3
1599 95 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1600 95 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1607 95 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1609 95 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1611 95 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   3
1613 95 Scalability & Replicability Efficiency Investment cost   3
1615 95 Scalability & Replicability Legitimacy Participatory Processes   3
1616 96 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1617 96 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1620 96 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1624 96 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1625 96 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1626 96 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1633 97 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1634 97 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1637 97 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1640 97 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1642 97 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1643 97 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1649 97 Scalability & Replicability Legitimacy Participatory Processes   3
1650 98 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1651 98 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1657 98 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1658 98 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1660 98 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1664 98 Scalability & Replicability Efficiency Investment cost   3
1667 99 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1674 99 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1677 99 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1681 99 Scalability & Replicability Efficiency Investment cost   3
1684 100 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1685 100 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1687 100 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1688 100 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1690 100 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1693 100 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1694 100 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1697 100 Scalability & Replicability Efficiency Efficiency for replicability   3
1072 64 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Impact assessment planned or in place 3
68 4 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
153 9 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
204 12 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
238 14 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
272 16 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
306 18 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
391 23 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
408 24 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3