testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
1500 89 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
1499 89 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
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
1496 88 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
1495 88 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
1494 88 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1493 88 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
1492 88 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas 4
1491 88 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy across multiple sectors 4
1490 88 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1489 88 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
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
1486 88 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies Positive synergies between adaptation and mitigation is/was a main target of the project 4
1485 88 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2
1484 88 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
1483 88 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
1482 88 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
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
1478 87 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 4
1477 87 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1476 87 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
1475 87 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas 4
1474 87 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy across multiple sectors 4
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
1471 87 Contribution to adaptation goal & co-benefits Relevance Legitimacy All three types of adaptation pathways are proposed (coping, adaptative, transformative) 4
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
1469 87 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
1468 87 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal 4
1467 87 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
1466 87 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
1465 87 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided three or more additional social co-benefits to the main adaptation goal 4
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
1460 86 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1459 86 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
1458 86 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas 4
1457 86 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy across multiple sectors 4
1456 86 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1455 86 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
1454 86 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
1453 86 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified but no measures put in place to minimize them 2
1452 86 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1451 86 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal 4
1450 86 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
1449 86 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically and socio-economically) and addressed inequalities 4
1448 86 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits The project provided one additional social co-benefit to the main adaptation goal 2
1447 86 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
1446 86 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1445 85 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
1444 85 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
1443 85 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
1442 85 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
1441 85 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas 4
1440 85 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy across multiple sectors 4
1439 85 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1438 85 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
1437 85 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
1436 85 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1435 85 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
1434 85 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided three or more additional environmental co-benefits to the main adaptation goal 4
1433 85 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
1432 85 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
1431 85 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
1430 85 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
1429 85 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1428 84 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
1427 84 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
1426 84 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
1425 84 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
1424 84 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (two) of the nation's international commitments and agendas 3
1423 84 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy across multiple sectors 4
1422 84 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
1421 84 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 3
1420 84 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
1419 84 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1418 84 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1417 84 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided three additional environmental co-benefits to the main adaptation goal 4
1416 84 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
1415 84 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
1414 84 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
1413 84 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
1412 84 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
1411 83 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
1410 83 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
1409 83 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
1408 83 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
1407 83 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals is/was aligned to (three) of the nation's international commitments and agendas 4
1406 83 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals were aligned to a national development strategy or action plan 2
1405 83 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project addresses/addressed capacity needs 3
1404 83 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
1403 83 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
1402 83 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
1401 83 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1400 83 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided one additional environmental co-benefit to the main adaptation goal 2