testToSQLite

Custom SQL query returning 101 rows (show)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
1 1 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
5 1 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
10 1 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
18 2 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
19 2 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
35 3 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
43 3 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
52 4 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
54 4 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
69 5 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
70 5 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
71 5 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
72 5 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
86 6 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
87 6 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
94 6 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
103 7 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
107 7 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
109 7 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
111 7 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
120 8 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
121 8 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
139 9 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
140 9 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
145 9 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
146 9 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
157 10 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
159 10 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
161 10 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
162 10 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
171 11 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
172 11 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
188 12 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
193 12 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
195 12 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
196 12 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
197 12 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
205 13 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
206 13 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
209 13 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
213 13 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
222 14 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
224 14 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
226 14 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
230 14 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
231 14 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
239 15 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
242 15 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
243 15 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a multiple sources 3
246 15 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
247 15 Contribution to adaptation goal & co-benefits Relevance Legitimacy One type of measure proposed (coping, adaptative, transformative) 3
256 16 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
257 16 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
259 16 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
261 16 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
264 16 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
276 17 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
278 17 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
280 17 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
281 17 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
297 18 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
298 18 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
312 19 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
314 19 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
315 19 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
324 20 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
328 20 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
331 20 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
332 20 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
341 21 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
346 21 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
348 21 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
358 22 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
359 22 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
360 22 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
363 22 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
375 23 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
383 23 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
392 24 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
393 24 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
397 24 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
398 24 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
401 24 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
409 25 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
410 25 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3
411 25 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
414 25 Contribution to adaptation goal & co-benefits Environmental Co-benefits Environmental Co-benefits The project provided two additional environmental co-benefits to the main adaptation goal 3
418 25 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
426 26 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
433 26 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts were identified and measures put in place to minimize them 3
443 27 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
445 27 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
447 27 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
451 27 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
460 28 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
463 28 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
464 28 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
466 28 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project accounted for and quantified mitigation synergies with adaptation 3
468 28 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
469 28 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived within a year/season 3
478 29 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using national evidence 3