testToSQLite

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
220 13 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
221 13 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
222 14 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Monitoring mechanisms planned or in place 3
223 14 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
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
225 14 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disdavantaged group (defined geographically) 2
226 14 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from multiple sources 3
227 14 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
228 14 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
229 14 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
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
233 14 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
234 14 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 (three) of the nation's international commitments and agendas 4
235 14 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2
236 14 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
237 14 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
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
240 15 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
241 15 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
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
244 15 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
245 15 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
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
248 15 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
249 15 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame Capacities to implement the project were already available 4
250 15 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
251 15 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 (three) of the nation's international commitments and agendas 4
252 15 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
253 15 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
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
255 15 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
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
258 16 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
259 16 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
260 16 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
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
262 16 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
263 16 Contribution to adaptation goal & co-benefits Environmental Co-benefits Externalities Negative impacts assessed but not found or negligible 4
264 16 Contribution to adaptation goal & co-benefits Relevance Legitimacy Two types of different measures proposed (coping, adaptative, transformative) 3
265 16 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
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
268 16 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 (three) of the nation's international commitments and agendas 4
269 16 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
270 16 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
271 16 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
272 16 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
273 17 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Outputs outlined 2
274 17 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using global evidence 2
275 17 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
276 17 Contribution to adaptation goal & co-benefits Social Co-benefits Equity The project targeted a disadvantaged group (defined geographically and socio-economically) 3
277 17 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities No evidence on bussiness opportunities to generate extra income 1
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
279 17 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
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
282 17 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benfits of the project will be perceived in several years 2
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
285 17 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 (three) of the nation's international commitments and agendas 4
286 17 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
287 17 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
288 17 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
289 17 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
290 18 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Outputs outlined 2
291 18 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
292 18 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
293 18 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
294 18 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
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
296 18 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project identified synergies with mitigation, but did not quantify them 2
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
299 18 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
300 18 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
301 18 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
302 18 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 (three) of the nation's international commitments and agendas 4
303 18 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
304 18 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
305 18 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
306 18 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
307 19 Contribution to adaptation goal & co-benefits Effectiveness Monitoring & Evaluation Impact assessment planned or in place 4
308 19 Contribution to adaptation goal & co-benefits Impact Efficacy contributing to adaptation goals Vulnerabilities assessed using sub-national evidence 4
309 19 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
310 19 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
311 19 Contribution to adaptation goal & co-benefits Social Co-benefits Business Opportunities Revenues are likely to increase from a single source 2
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
313 19 Contribution to adaptation goal & co-benefits Environmental Co-benefits Mitigation synergies The project does not account for contributions to mitigation efforts 1
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
316 19 Contribution to adaptation goal & co-benefits Relevance Implementation time-frame The benefits of the project will be perceived in the short-term (months) 4
317 19 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
318 19 Scalability & Replicability Coherence Development Strategies: Contribution to national development goals/strategies The project's adaptation goals are/were aligned to a national development strategy across multiple sectors 4
319 19 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 (three) of the nation's international commitments and agendas 4
320 19 Scalability & Replicability Efficiency Efficiency for replicability The project requires minor 'hard' investments and large 'soft' investments 2