testToSQLite

Custom SQL query returning 101 rows (show)

This data as json, CSV

rowidIDDomainCriteriaVariableRational_for_the_PlatformScore
11 1 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
12 1 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
13 1 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
14 1 Scalability & Replicability Efficiency Efficiency for replicability The project's adaptation measures were tailored to available of local resources 4
15 1 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by public/private and local stakeholders 4
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
17 1 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
28 2 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
29 2 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
30 2 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
31 2 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
32 2 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
33 2 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
34 2 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
45 3 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
46 3 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
47 3 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
48 3 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
49 3 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
50 3 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
51 3 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
62 4 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
63 4 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
64 4 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
65 4 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
66 4 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
67 4 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
68 4 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
79 5 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
80 5 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
81 5 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
82 5 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
83 5 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
84 5 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
85 5 Scalability & Replicability Legitimacy Participatory Processes The project did not involve local stakeholders during desgin, planning or implementation processes 1
96 6 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project provides limited support to address capacity needs 2
97 6 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
98 6 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
99 6 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
100 6 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
101 6 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
102 6 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
113 7 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
114 7 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
115 7 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
116 7 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
117 7 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
118 7 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
119 7 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
130 8 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
131 8 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
132 8 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
133 8 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
134 8 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
135 8 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
136 8 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
147 9 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
148 9 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
149 9 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
150 9 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
151 9 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
152 9 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
153 9 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
164 10 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
165 10 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
166 10 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
167 10 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
168 10 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
169 10 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
170 10 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design, planning and implementation processes of the project 4
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
183 11 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
184 11 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
185 11 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
186 11 Scalability & Replicability Sustainability Sustainability The project integrates institutions from the national to local level, and shows diverse stakeholders (public, private, civil society) 2
187 11 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders were consulted to design adaptation measures of the project 2
198 12 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
199 12 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
200 12 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
201 12 Scalability & Replicability Efficiency Efficiency for replicability The project requires large 'hard' investments 1
202 12 Scalability & Replicability Efficiency Investment cost The costs of the project were shared by private and public stakeholders 3
203 12 Scalability & Replicability Sustainability Sustainability The project integrates institutions, creates business opportunities and incorporates finance measures with a clear exit strategy 4
204 12 Scalability & Replicability Legitimacy Participatory Processes Local stakeholders participated in design and planning processes of the project 3
215 13 Scalability & Replicability Easiness for Implementation Institutional Capacity within the expected time-frame The project address capacity needs 3
216 13 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
217 13 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
218 13 Scalability & Replicability Efficiency Efficiency for replicability The project requires 'soft' investements 3
219 13 Scalability & Replicability Efficiency Investment cost The costs of the project were incurred by private or public stakeholders 2
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
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
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