testToSQLite

Custom SQL query returning 2 rows (hide)

Query parameters

rowidX_ccid_idInitiative_NameMain_climate_policy_focusY_Thematic_areaView_initiative_on_UNFCCC_Global_Climate_Action_portalView_initiative_on_UNEP_DTU_Climate_Initiatives_PlatformWebsiteLaunch_yearDescriptionY_SDG1Y_SDG2Y_SDG3Y_SDG4Y_SDG5Y_SDG6Y_SDG7Y_SDG8Y_SDG9Y_SDG10Y_SDG11Y_SDG12Y_SDG13Y_SDG14Y_SDG15Y_SDG16Y_SDG17Targets_Emissions_reductionTargets_Energy_efficiencyTargets_Renewable_energyTargets_Number_people_number_countriesTargets_Number_organizations_newly_engagedTargets_Areas_protected_improved_or_restoredTargets_in_market_shares_sales_scaleTargets_Funds_to_be_mobilizedTargets_OtherY_Apply_10_to_Targets_Print_TargetsY_display_country_namesCountries_where_activity_is_planned_or_ongoingY_Print_ActorName_only_FundersY_Print_ActorName_only_Lead_partnersY_Print_ActorName_by_ActorType_ParticipantsY_Participants1Y_Participants2Y_Participants3Y_Participants4Y_Participants5Y_Participants6Y_Participants7Y_Participants8ParticipantNames_National_governmentsParticipantNames_Subnational_and_regional_governmentsParticipantNames_BusinessesParticipantNames_InvestorsParticipantNames_Domestic_NGOsParticipantNames_International_NGOsParticipantNames_Academic_educational_institutionsParticipantNames_International_organizationsParticipantNames_Other_organizations
249 ccid_0328 Ocean Risk and Resilience Action Alliance mainly adaptation oceans and coastal zones, water     https://www.oceanriskalliance.org/ 2019 The Ocean Risk and Resilience Action Alliance, ORRAA, is a multi-sector collaboration between governments, financial institutions, the insurance industry, environmental organisations and stakeholders from the Global South. Our purpose is to build resilience in the regions and communities most vulnerable to ocean risk, by pioneering finance and insurance products that incentivise investment in nature-based solutions. Our aim is to drive $500 million of investment into nature-based solutions by 2030, and surface at least 15 novel finance products by 2025 that incentivise private and blended finance into coastal natural capital. SDG explicitly mentioned       SDG explicitly mentioned           SDG explicitly mentioned   SDG explicitly mentioned SDG explicitly mentioned     SDG explicitly mentioned               Alliance member organisations provide monetary or in-kind technical and professional support of at least USD$ 50,000 per annum     ["France", "United States of America (the)", "Sweden", "Canada", "United Kingdom of Great Britain and Northern Ireland (the)", "Switzerland"]   ["AXA", "Ocean Unite", "Global Resilience Partnership", "Canada", " Stockholm Resilience Centre", "The Nature Conservancy", "Willis Towers Watson", "rare", "WWF", "greensquare ventures"] [AXA]_inv_fra,[Ocean Unite]_ing_usa,[Global Resilience Partnership]_oth_swe {"inv": ["AXA", "Willis Towers Watson", "greensquare ventures"], "ing": ["Ocean Unite", "The Nature Conservancy", "WWF"], "oth": ["Global Resilience Partnership", "rare", "MAR Fund", "Saskawa Peace Foundation"], "ngv": ["Canada"], "edu": [" Stockholm Resilience Centre", "Stimson"]}                                
251 ccid_0330 Transformative Actions Program equally adaptation & mitigation human settlements   http://climateinitiativesplatform.org/index.php/Transformative_Actions_Program_(TAP) https://tap-potential.org/ 2015 The Transformative Actions Program (TAP) is an innovative initiative that aims to catalyze and improve capital flows to cities, towns, and regions, and strengthen their capacity to access climate finance and attract investment. Through the TAP and its partners, local and regional governments can receive support to develop their infrastructure concepts into highly transformative, mature, robust, and bankable projects ready for financing and implementation. The TAP connects local and regional governments, technical experts, and financial institutions.                     SDG explicitly mentioned   SDG explicitly mentioned                       As of September 2019, the TAP pipeline has 45 projects with an identified investment need of 2.3 billion Euro.     ["Germany", "Finland", "Senegal", "Zambia", "South Africa", "China", "Japan", "Korea (the Republic of)", "United States of America (the)", "Australia", "Vanuatu", "Brazil", "Mexico", "Cameroon", "Mozambique", "Benin", "Mongolia", "Colombia", "Indonesia", "Philippines (the)", "India", "Portugal"]   ["ICLEI"] [ICLEI]_sgv_int {"bus": ["bettervest", "Deutsche Gesellschaft f\u00fcr Internationale Zusammenarbeit - GIZ - FELICITY", "Deutsche Gesellschaft f\u00fcr Internationale Zusammenarbeit - GIZ - Covenant of Mayors in Sub Saharan Africa component III"], "sgv": ["C40 Cities Climate Leadership Group", "Covenant of Mayors in Sub Saharan Africa component III and FELICITY"], "oth": ["Global 100% RE Platform", "R20 - Regions of Climate Action", "Cities Alliance"], "dng": ["Global Fund for Cities Development - FMDV", "Global Infrastructure Basel Foundation", "Sustainable Infrastructure Foundation"], "ior": ["United Nations Human Settlements - UN-Habitat", "UN Capital Development Fund - UNCDF", "European Investment Bank"]}