testToSQLite

Custom SQL query returning 1 row (hide)

select rowid, X_ccid_id, Initiative_Name, Main_climate_policy_focus, Y_Thematic_area, View_initiative_on_UNFCCC_Global_Climate_Action_portal, View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform, Website, Launch_year, Description, Y_SDG1, Y_SDG2, Y_SDG3, Y_SDG4, Y_SDG5, Y_SDG6, Y_SDG7, Y_SDG8, Y_SDG9, Y_SDG10, Y_SDG11, Y_SDG12, Y_SDG13, Y_SDG14, Y_SDG15, Y_SDG16, Y_SDG17, Targets_Emissions_reduction, Targets_Energy_efficiency, Targets_Renewable_energy, Targets_Number_people_number_countries, Targets_Number_organizations_newly_engaged, Targets_Areas_protected_improved_or_restored, Targets_in_market_shares_sales_scale, Targets_Funds_to_be_mobilized, Targets_Other, Y_Apply_10_to_Targets_Print_Targets, Y_display_country_names, Countries_where_activity_is_planned_or_ongoing, Y_Print_ActorName_only_Funders, Y_Print_ActorName_only_Lead_partners, Y_Print_ActorName_by_ActorType_Participants, Y_Participants1, Y_Participants2, Y_Participants3, Y_Participants4, Y_Participants5, Y_Participants6, Y_Participants7, Y_Participants8, ParticipantNames_National_governments, ParticipantNames_Subnational_and_regional_governments, ParticipantNames_Businesses, ParticipantNames_Investors, ParticipantNames_Domestic_NGOs, ParticipantNames_International_NGOs, ParticipantNames_Academic_educational_institutions, ParticipantNames_International_organizations, ParticipantNames_Other_organizations from stake where "Targets_in_market_shares_sales_scale" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	X_ccid_id	Initiative_Name	Main_climate_policy_focus	Y_Thematic_area	View_initiative_on_UNFCCC_Global_Climate_Action_portal	View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform	Website	Launch_year	Description	Y_SDG1	Y_SDG2	Y_SDG3	Y_SDG4	Y_SDG5	Y_SDG6	Y_SDG7	Y_SDG8	Y_SDG9	Y_SDG10	Y_SDG11	Y_SDG12	Y_SDG13	Y_SDG14	Y_SDG15	Y_SDG16	Y_SDG17	Targets_Emissions_reduction	Targets_Energy_efficiency	Targets_Renewable_energy	Targets_Number_people_number_countries	Targets_Number_organizations_newly_engaged	Targets_Areas_protected_improved_or_restored	Targets_in_market_shares_sales_scale	Targets_Funds_to_be_mobilized	Targets_Other	Y_Apply_10_to_Targets_Print_Targets	Y_display_country_names	Countries_where_activity_is_planned_or_ongoing	Y_Print_ActorName_only_Funders	Y_Print_ActorName_only_Lead_partners	Y_Print_ActorName_by_ActorType_Participants	Y_Participants1	Y_Participants2	Y_Participants3	Y_Participants4	Y_Participants5	Y_Participants6	Y_Participants7	Y_Participants8	ParticipantNames_National_governments	ParticipantNames_Subnational_and_regional_governments	ParticipantNames_Businesses	ParticipantNames_Investors	ParticipantNames_Domestic_NGOs	ParticipantNames_International_NGOs	ParticipantNames_Academic_educational_institutions	ParticipantNames_International_organizations	ParticipantNames_Other_organizations
238	ccid_0314	Clean Cooking Fund	mainly mitigation	energy	https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=122		https://www.worldbank.org/en/news/feature/2019/11/04/why-clean-cooking-matters	2019	The Fund will scale up public and private investments in the clean cooking sector by catalyzing technology and business innovations and linking incentives with verified results, also known as results-based financing. It is expected to leverage at least $1 billion in investments to support a sizable number of businesses delivering clean cooking solutions. It will also help with developing an impact bond market to monetize the health, gender, and climate impacts of projects that can attract a broad range of capital. The CCF will complement and support the High-Level Coalition of Leaders for Clean Cooking, Energy and Health, which is being convened by the World Health Organization, United Nations Development Program, United Nations Department of Economics and Social Affairs and the World Bank. The Coalition aims to demonstrate the global leadership in advocacy and action required to create political momentum, drive practical solutions, spur investments and mobilize public support and multi-stakeholder engagements for clean cooking. The Fund draws from the World Bank’s experience and lessons learned from the past decade. The World Bank currently has an active lending portfolio of over $350 million in clean cooking and heating projects across 21 countries, helping over 3.6 million households and 18 million people with improved access to more efficient, cleaner cooking and heating solutions. Among these projects, results-based financing has been implemented in various ways, successfully helping private companies enter the clean cooking market in 10 countries: Bangladesh, China, Ethiopia, Indonesia, Kenya, Lao PDR, Madagascar, Mongolia, Rwanda, and Uganda.							SDG explicitly mentioned						SDG explicitly mentioned			SDG explicitly mentioned	SDG explicitly mentioned							[Distribution of 4 million improved stoves]	[$500 million]			["Uganda", "Burundi", "Zambia", "Ghana", "Kenya", "Rwanda", "Senegal", "Ethiopia", "Burundi", "Nepal", "Myanmar"]		["Denmark", "Netherlands", "World Bank", "Norway", "United Kingdom"]	[World Health Organization]_ior_int,[High-Level Coalition of Leaders for Clean Cooking, Energy and Health]_ing_int,[World Bank]_ior_int,[United Nations Development Program]_ior_int,[United Nations Department of Economic and Social Affairs]_ior_int,[Energy Sector Management Assistance Program (ESMAP)]_ing_usa	{"ngv": ["Bangladesh", "China", "Ethiopia", "Indonesia", "Kenya", "Lao PDR", "Madagascar", "Mongolia", "Rwanda", "Uganda", "Burundi", "Nepal", "Myanmar"], "ing": ["Energy Sector Management Assistance Program (ESMAP)"], "ior": ["World Bank", "United Nations Development Program", "United Nations Department of Economic and Social Affairs"], "oth": ["High Level Coalition of Leaders for Clean Cooking Energy and Health"]}