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
11 1 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
16 1 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
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
164 10 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
1684 100 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation   3
1685 100 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals   3
1687 100 Contribution to adaptation goal & co-benefits Social Co-benefits Equity   3
1688 100 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities   3
1690 100 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies   3
1693 100 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame   3
1694 100 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame   3
1697 100 Scalability & Replicability Efficiency Efficiency for replicability   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
181 11 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
182 11 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national develoment strategy for a specific sector 3
184 11 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 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
198 12 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
202 12 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
204 12 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 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
215 13 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
218 13 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 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
232 14 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
236 14 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
238 14 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 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
254 15 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
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
266 16 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
267 16 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national develoment strategy for a specific sector 3
269 16 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
272 16 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 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
283 17 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
284 17 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national develoment strategy for a specific sector 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
300 18 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
304 18 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
306 18 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 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
317 19 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 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
28 2 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
31 2 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 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
334 20 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 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
351 21 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
355 21 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 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
368 22 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
372 22 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
373 22 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
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
385 23 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
387 23 Scalability & Replicability Coherence Development Strategies: Contribution to International development goals/strategies (E.g SDGs, Sendai Framework, NDCs, NAPs) The project's adaptation goals are/were aligned to (two) of the nation's international commitments and agendas 3
389 23 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3