testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
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
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
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
693 41 Scalability & Replicability Coherence The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas   4
697 41 Scalability & Replicability Legitimacy Local stakeholders participated in design, planning and implementation processes of the project   4
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
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
1028 61 Contribution to adaptation goal & co-benefits Environmental Co-benefits Negative impacts assessed but not found or negligible   4
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
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
1519 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
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
1529 90 Scalability & Replicability Sustainability Sustainability   4
1532 91 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   4
1534 91 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1536 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
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
1545 91 Scalability & Replicability Efficiency Investment cost   4
1546 91 Scalability & Replicability Sustainability Sustainability   4
1550 92 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1553 92 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
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
1563 92 Scalability & Replicability Sustainability Sustainability   4
1567 93 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1572 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   4
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
1579 93 Scalability & Replicability Efficiency Investment cost   4
1583 94 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   4
1584 94 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1587 94 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1596 94 Scalability & Replicability Efficiency Investment cost   4
1597 94 Scalability & Replicability Sustainability Sustainability   4
1598 94 Scalability & Replicability Legitimacy Participatory Processes   4
1601 95 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1602 95 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1604 95 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1605 95 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   4
1606 95 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   4
1610 95 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1614 95 Scalability & Replicability Sustainability Sustainability   4
1618 96 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1619 96 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1621 96 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1623 96 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   4
1627 96 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1628 96 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1630 96 Scalability & Replicability Efficiency Investment cost   4
1631 96 Scalability & Replicability Sustainability Sustainability   4
1632 96 Scalability & Replicability Legitimacy Participatory Processes   4
1635 97 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1638 97 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1641 97 Contribution to adaptation goal & co-benefits Relevance Legitimacy   4
1644 97 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1645 97 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1647 97 Scalability & Replicability Efficiency Investment cost   4
1648 97 Scalability & Replicability Sustainability Sustainability   4
1652 98 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1653 98 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1656 98 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   4
1661 98 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1662 98 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1665 98 Scalability & Replicability Sustainability Sustainability   4
1668 99 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   4
1670 99 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   4
1675 99 Contribution to adaptation goal & co-benefits Relevance Legitimacy   4
1678 99 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1679 99 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1682 99 Scalability & Replicability Sustainability Sustainability   4
1686 100 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   4
1689 100 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   4
1691 100 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   4
1692 100 Contribution to adaptation goal & co-benefits Relevance Legitimacy   4
1695 100 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   4
1696 100 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   4
1699 100 Scalability & Replicability Sustainability Sustainability   4
1700 100 Scalability & Replicability Legitimacy Participatory Processes   4
9 1 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
400 24 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
434 26 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
638 38 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
723 43 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
1114 66 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
1165 69 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
1182 70 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
1216 72 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
1471 87 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
249 15 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1184 70 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1218 72 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1235 73 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1286 76 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1422 84 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4