testToSQLite

Custom SQL query returning 101 rows (show)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
1697 100 Scalability & Replicability Efficiency Efficiency for replicability   3
1694 100 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1693 100 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1690 100 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1688 100 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1687 100 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1685 100 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1684 100 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1681 99 Scalability & Replicability Efficiency Investment cost   3
1677 99 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1674 99 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1667 99 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1664 98 Scalability & Replicability Efficiency Investment cost   3
1660 98 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1658 98 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1657 98 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1651 98 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1650 98 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1649 97 Scalability & Replicability Legitimacy Participatory Processes   3
1643 97 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1642 97 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1640 97 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1637 97 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1634 97 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1633 97 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1626 96 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1625 96 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1624 96 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1620 96 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1617 96 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1616 96 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1615 95 Scalability & Replicability Legitimacy Participatory Processes   3
1613 95 Scalability & Replicability Efficiency Investment cost   3
1611 95 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   3
1609 95 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1607 95 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1600 95 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1599 95 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1594 94 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs)   3
1593 94 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies   3
1592 94 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1590 94 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1589 94 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1586 94 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1582 94 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1580 93 Scalability & Replicability Sustainability Sustainability   3
1575 93 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1574 93 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1573 93 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1571 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1570 93 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits   3
1565 93 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1562 92 Scalability & Replicability Efficiency Investment cost   3
1561 92 Scalability & Replicability Efficiency Efficiency for replicability   3
1558 92 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1552 92 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1549 92 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1548 92 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1544 91 Scalability & Replicability Efficiency Efficiency for replicability   3
1541 91 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1540 91 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1539 91 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1538 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1537 91 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1533 91 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits   3
1531 91 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1530 90 Scalability & Replicability Legitimacy Participatory Processes   3
1528 90 Scalability & Replicability Efficiency Investment cost   3
1527 90 Scalability & Replicability Efficiency Efficiency for replicability   3
1524 90 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1523 90 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1522 90 Contribution to adaptation goal & co-benefits Relevance Legitimacy   3
1521 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities   3
1520 90 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1517 90 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1514 90 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1511 89 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1510 89 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
1507 89 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1505 89 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
1504 89 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1503 89 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
1498 89 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
1497 89 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1494 88 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1490 88 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1488 88 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
1487 88 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1484 88 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
1481 88 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
1480 88 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1479 87 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
1477 87 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1473 87 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1472 87 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
1470 87 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1467 87 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
1464 87 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
1463 87 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1462 86 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
1461 86 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