testToSQLite

Custom SQL query returning 101 rows (show)

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
681 41 Contribution to adaptation goal & co-benefits Effectiveness Monitoring mechanisms planned or in place   3
682 41 Contribution to adaptation goal & co-benefits Impact Vulnerabilities assessed using sub-national evidence   4
683 41 Contribution to adaptation goal & co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal   4
684 41 Contribution to adaptation goal & co-benefits Social Co-benefits The project targeted a disdavantaged group (defined geographically)   2
685 41 Contribution to adaptation goal & co-benefits Social Co-benefits Revenues are likely to increase from multiple sources   3
686 41 Contribution to adaptation goal & co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal   4
687 41 Contribution to adaptation goal & co-benefits Environmental Co-benefits The project accounted for and quantified mitigation synergies with adaptation   3
688 41 Contribution to adaptation goal & co-benefits Environmental Co-benefits Negative impacts assessed but not found or negligible   4
689 41 Contribution to adaptation goal & co-benefits Relevance All three types of adaptation pathways are proposed (coping, adaptative, transformative)   4
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
693 41 Scalability & Replicability Coherence The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas   4
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
696 41 Scalability & Replicability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society)   2
697 41 Scalability & Replicability Legitimacy Local stakeholders participated in design, planning and implementation processes of the project   4
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
1023 61 Contribution to adaptation goal & co-benefits Social Co-benefits The project provided one additional social co-benefit to the main adaptation goal   2
1024 61 Contribution to adaptation goal & co-benefits Social Co-benefits The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities   4
1025 61 Contribution to adaptation goal & co-benefits Social Co-benefits Revenues are likely to increase from multiple sources   3
1026 61 Contribution to adaptation goal & co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal   4
1027 61 Contribution to adaptation goal & co-benefits Environmental Co-benefits The project identified synergies with mitigation, but did not quantify them   2
1028 61 Contribution to adaptation goal & co-benefits Environmental Co-benefits Negative impacts assessed but not found or negligible   4
1029 61 Contribution to adaptation goal & co-benefits Relevance Two types of different measures proposed (coping, adaptative, transformative)   3
1030 61 Contribution to adaptation goal & co-benefits Relevance The benfits of the project will be perceived in several years   2
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
1035 61 Scalability & Replicability Efficiency The costs of the project were shared by public/private and local stakeholders   4
1036 61 Scalability & Replicability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy   4
1037 61 Scalability & Replicability Legitimacy Local stakeholders participated in design, planning and implementation processes of the project   4
1514 90 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1515 90 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   4
1516 90 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1517 90 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1518 90 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   2
1519 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
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
1525 90 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1526 90 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1527 90 Scalability & Replicability Efficiency Efficiency for replicability   3
1528 90 Scalability & Replicability Efficiency Investment cost   3
1529 90 Scalability & Replicability Sustainability Sustainability   4
1530 90 Scalability & Replicability Legitimacy Participatory Processes   3
1531 91 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1532 91 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   4
1533 91 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   3
1534 91 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1535 91 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   1
1536 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
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
1542 91 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1543 91 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1544 91 Scalability & Replicability Efficiency Efficiency for replicability   3
1545 91 Scalability & Replicability Efficiency Investment cost   4
1546 91 Scalability & Replicability Sustainability Sustainability   4
1547 91 Scalability & Replicability Legitimacy Participatory Processes   2
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
1550 92 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1551 92 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   1
1552 92 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1553 92 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1554 92 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   1
1555 92 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   1
1556 92 Contribution to adaptation goal & co-benefits Relevance Legitimacy   2
1557 92 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   1
1558 92 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1559 92 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1560 92 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1561 92 Scalability & Replicability Efficiency Efficiency for replicability   3
1562 92 Scalability & Replicability Efficiency Investment cost   3
1563 92 Scalability & Replicability Sustainability Sustainability   4
1564 92 Scalability & Replicability Legitimacy Participatory Processes   2
1565 93 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1566 93 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   2
1567 93 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1568 93 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   2
1569 93 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   2
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
1572 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   4
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
1576 93 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1577 93 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1578 93 Scalability & Replicability Efficiency Efficiency for replicability   2
1579 93 Scalability & Replicability Efficiency Investment cost   4
1580 93 Scalability & Replicability Sustainability Sustainability   3