testToSQLite

Custom SQL query returning 1 row (show)

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
175 ccid_0251 Supporting smallholder farmers mainly adaptation land use, human settlements     https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=125 2019 The Global Commission on Adaptation (GCA) Action Track on Agriculture and Food Security focuses on building the resilience of smallholder producers to intensifying climate shocks and stresses. It incorporates an ambitious goal, diverse partnerships, a ‘Year of Action’ to build significant momentum on the five planned outcomes, and on-going implementation in the coming decade. The GCA seeks to deliver concrete and meaningful action through a set of Action Tracks that mobilize critical partners. Progress against the above goal and planned outcomes will be reviewed at high-profile moments during the GCA ‘Year of Action’ including the Adaptation Action Summit in October 2020 and the UN Food Systems Summit in 2021. The GCA managing partners – Global Center on Adaptation and World Resources Institute – will provide the secretariat for the Action Track.   SDG explicitly mentioned           SDG explicitly mentioned SDG explicitly mentioned       SDG explicitly mentioned       SDG explicitly mentioned       300 million small-scale farmers supported (to enhance resilience to climate change), expanding access to climate-related digital advisory services for at least 100 million small-scale producers by 2030, improving access to and use of adaptation technologies and agroecological practices for 100 million small-scale producers.     scaling up access for at least 100 million small-scale producers to reach insurance, markets, finance and productive safety nets US$750 million to enhance resilience to climate shocks and extreme events for 300 million small-scale farmers     ["Kosovo"]   ["Bill and Melinda Gates Foundation", "UNDP", "World Bank", "United Kingdom", "Netherlands", "Germany", "Global Commission on Adaptation (GCA)", "CGIAR"] [Bill and Melinda Gates Foundation]_ing_usa,[UNDP]_ior_int,[World Bank]_ior_int,[United Kingdom]_ngv_gbr,[Netherlands]_ngv_nld,[Germany]_ngv_deu,[Global Commission on Adaptation (GCA)]_ior_int,[CGIAR]_oth_int {"ing": ["Bill and Melinda Gates Foundation"], "ior": ["UNDP", "World Bank", "Global Commission on Adaptation (GCA)"], "ngv": ["United Kingdom", "Netherlands", "Germany", "Norway", "Sweden", "Switzerland"], "oth": ["CGIAR"]}