testToSQLite

Custom SQL query returning 1 row (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
31 ccid_0032 Bonn Challenge mainly mitigation land use     https://www.bonnchallenge.org/ 2011 The Bonn Challenge is a global goal to bring 150 million hectares of degraded and deforested landscapes into restoration by 2020 and 350 million hectares by 2030. Launched by the Government of Germany and IUCN in 2011, the Challenge surpassed the 150-million-hectare milestone for pledges in 2017. We respond to the urgent issue of land degradation affecting over 3 billion people and over 30 per cent of Earth’s arable land. We do this by working with countries, organisations and private entities to pledge and achieve ambitious targets to restore degraded and deforested lands. We align our work with the Sustainable Development Goals (SDGs), the Aichi Biodiversity Targets, the Land Degradation Neutrality (LDN) goal, and the Paris Climate Change Agreement – all together providing a roadmap for a sustainable planet. To achieve these goals, we rely on a flexible, nuanced approach to restoration called forest landscape restoration (FLR). FLR restores ecological integrity while enhancing human well-being. IUCN and the World Wide Fund for Nature (WWF) coined the term forest landscape restoration in 2000 as a framework for managing landscapes, complementing both forest conservation and sustainable management. Since then, FLR has evolved into a powerful nature-based solution, transforming landscapes and the lives of people worldwide.                         SDG explicitly mentioned   SDG explicitly mentioned               The Bonn Challenge is a global effort to restore 150 million hectares of the world's deforested and degraded lands by 2020 and 350 million hectares by 2030.         ["Argentina", "Armenia", "Azerbaijan", "Bangladesh", "Benin", "Brazil", "Burundi", "Cameroon", "Central African Republic (the)", "Chad", "Chile", "Colombia", "Costa Rica", "C\u00f4te d'Ivoire", "Cuba", "Congo (the Democratic Republic of the)", "Dominican Republic (the)", "Ecuador", "El Salvador", "Ethiopia", "Eswatini", "Gambia (the)", "Georgia", "Ghana", "Guatemala", "Guinea", "Guatemala", "None", "India", "Kazakhstan", "Kenya", "Kyrgyzstan", "Liberia", "Madagascar", "Malawi", "Mexico", "Mongolia", "Mozambique", "Nigeria", "Niger (the)", "Nigeria", "Pakistan", "Panama", "Peru", "Congo (the)", "Rwanda", "Senegal", "Sri Lanka", "Tajikistan", "Tanzania, United Republic of", "Uganda", "United States of America (the)", "Uruguay", "Uzbekistan", "Zimbabwe"]   ["International Union for Conservation of Nature (IUCN)", "Federal Ministry for the Environment", " Nature Conservation and Nuclear Safety"] [International Union for Conservation of Nature (IUCN)]_oth_che,[Federal Ministry for the Environment, Nature Conservation and Nuclear Safety]_ngv_deu {"ngv": ["Argentina", "Armenia", "Azerbaijan", "Bangladesh", "Benin", "Brazil", "Burundi", "Cameroon", "Central African Republic", "Chad", "Chile", "Colombia", "Costa Rica", "Cote d\u2019Ivorie", "Cuba", "Democratic repoblic of the Congo", "Dominican Republic", "Ecudaor", "El Salvador", "Ethiopia", "Eswatini", "Gambia", "Georgia", "Ghana", "Guatemala", "Guinea", "Honduras", "India", "Kazakhstan", "Kenya", "Kyrgyzstan", "Liberia", "Madagascar", "Malawi", "Mexico", "Mongolia", "Mozambique", "Nicaragua", "Niger", "Nigeria", "Pakistan", "Panama", "Peru", "Republic of the Congo", "Rwanda", "Senegal", "Sri Lanka", "Tajikistan", "Tanzania", "Uganda", "United States", "Uruguay", "Uzbekistan", "Zimbabwe"], "dng": ["Guatemala Private Natural Reserves"], "sgv": ["Scotland", "Campeche", "Chiapas", "Quintana Rio", "Yucatan", "KPK"], "bus": ["Asia Pulp & Paper"], "oth": ["Brazil\u2019s Atlantic Forest Restoration Pact"]}