testToSQLite

Custom SQL query returning 2 rows (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 "Main_climate_policy_focus" = :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
142	ccid_0201	Natural Capital Lab	biodiversity conservation	industry			https://www.iadb.org/en/environment/natural-capital-lab	2018	IDB’s Natural Capital Lab serves as a one-stop shop for the IDB Group to drive innovation in the conservation, landscape, regenerative agriculture, biodiversity, and marine ecosystem finance spaces. It seeks to bridge the gap between traditional environmental and financial actors from the public and private sectors to incubate, accelerate, and scale new solutions to pressing problems.The Natural Capital Lab is a risk-tolerant hub within the IDB Group. Given that the solutions to many natural capital problems are cross-cutting, it pursues an agenda of blended finance projects with all parts of the IDB Group (IDB, IDB Invest, IDB Lab), in addition to its own projects, knowledge, and strategic partnerships. As a lab for financial innovation, activities include the deployment of funding in the form of grants, loans, equity, risk capital, or guarantees to:Test new models in natural capital finance across the public and private sectors; Accelerate the deployment of new technologies; Create enabling regulatory frameworks for innovation in natural capital; Identify entrepreneurs and projects, and support them with risk capital and linkages to innovation ecosystems; Link projects to existing investors, international funding sources (such as the GEF), and IDB finance for scale; Test large-scale financing models for conservation; Experiment with investments based on natural capital valuation/risk; Work with anchor companies in valuing and leveraging natural capital in their supply chains													SDG explicitly mentioned	SDG explicitly mentioned	SDG explicitly mentioned										McKinsey and company estimates that $300 billion to $400 billion is needed each year to preserve and restore ecosystems, but conservation projects receive just $52 billion(Address the gap in funding)			["None"]		["Inter American Development Bank", "Blue Orange Capital Sustainable Capital", "French Development Agency"]	[Inter American Development Bank]_ior_int,[Blue Orange Capital Sustainable Capital]_bus_fra,[French Development Agency]_ngv_fra	{"ior": ["Inter American Development Bank"], "bus": ["Blue Orange Capital Sustainable Capital"], "ngv": ["French Development Agency"]}
147	ccid_0206	Biodiversity Facility of Agence Francaise Developpement, WWF and IUCN	biodiversity conservation	land use			https://www.afd.fr/en/six-things-you-should-know-about-one-planet-summit-nairobi,https://www.afd.fr/en/actualites/afds-one-planet-summit-commitments-tracking-our-progress	2019	Data4Nature is a new initiative inviting all development partners to share the biodiversity data from their projects, to provide better protection for the natural world. The objective: convince as many development banks as possible to encourage consulting firms involved in their projects to systematically share the data collected on the Global Biodiversity Information Facility (GBIF). Officers from protected areas and NGOs can also contribute to it.													SDG explicitly mentioned								[16 countries]					[Support 16 countries in developing their voluntary national contributions for the 15th Conference of the Parties (COP) on the Convention on Biological Diversity (CBD)]		["None"]		["Agence Francaise Developpement"]	[Agence Francaise Developpement]_ngv_fra,[WWF]_ing_che,[IUCN]_ing_che	Ambiguous