testToSQLite

Custom SQL query returning 101 rows (show)

Query parameters

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
22 2 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
24 2 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
39 3 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
41 3 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
57 4 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
58 4 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
74 5 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
75 5 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
124 8 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
126 8 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
143 9 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
174 11 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project did not define a disadvantaged target group 1
175 11 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
176 11 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
192 12 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
194 12 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
245 15 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
262 16 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
277 17 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
279 17 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
295 18 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
313 19 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
345 21 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
413 25 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
430 26 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
432 26 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
449 27 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
481 29 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
498 30 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
503 30 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the long-term (decades) 1
517 31 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
599 36 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project did not define a disadvantaged target group 1
619 37 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
668 40 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on business opportunities to generate extra income 1
707 42 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the long-term (decades) 1
789 47 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
806 48 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
839 50 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
840 50 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
855 51 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
891 53 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
923 55 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
925 55 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
940 56 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
942 56 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
957 57 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
958 57 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
959 57 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
962 57 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the long-term (decades) 1
1007 60 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project did not define a disadvantaged target group 1
1008 60 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1010 60 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1044 62 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1061 63 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1097 65 Contribution to adaptation goal & co-benefits Relevance Legitimacy The project did not proposed integrated measures (coping/adapting/transforming adaptation pathways) 1
1146 68 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1178 70 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1197 71 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1231 73 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1263 75 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1279 76 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project did not define a disadvantaged target group 1
1280 76 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1281 76 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
1282 76 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1297 77 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1298 77 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
1299 77 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1316 78 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1333 79 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1336 79 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the long-term (decades) 1
1349 80 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits No additional environmetal co-benefits to the main adaptation goal where identified 1
1350 80 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1367 81 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1368 81 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts not assessed by the project 1
1382 82 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1397 83 Contribution to adaptation goal & co-benefits Social Co-benefits Social Co-benefits No additional social co-benefits to the main adaptation goal identified 1
1399 83 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
1401 83 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1418 84 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1452 86 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
1535 91 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   1
1551 92 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   1
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
1557 92 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   1
1588 94 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   1
1622 96 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   1
1654 98 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   1
7 1 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
21 2 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
23 2 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
26 2 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
36 3 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using global evidence 2
40 3 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
56 4 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
60 4 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
73 5 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
77 5 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 2
89 6 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
106 7 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
112 7 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2