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
290 ccid_0408 Earth Optimism Nature-based solutions, knowledge exchange land use, oceans and coastal zones, human settlements, transport, energy, industry     https://earthoptimism.si.edu/ 2017 The global conservation movement has reached a turning point. We have documented the fast pace of habitat loss, the growing number of endangered and extinct species, and the increasing speed of global climate change. Yet while the seriousness of these threats cannot be denied, there are a growing number of examples of improvements in the health of species and ecosystems, along with benefits to human well-being, thanks to our conservation actions. Earth Optimism celebrates a change in focus from problem to solution, from a sense of loss to one of hope, in the dialogue about conservation and sustainability.                         SDG explicitly mentioned               [Deliver solution oriented climate messaging to one billion people]         [Create a repository of credible environmental success stories from around the world and make them available to the general public for digital sharing]   ["Kosovo"]   ["Smithsonian Institute"] [Smithsonian Institute]_edu_usa {"edu": ["George Mason University", "Howard Hughes Medical Institution", "Smithsonian National Museum of Natural History", "Cambridge Conservation Initiative (CCI)", "Yale University Forum on Religion and Ecology", "Peking University Center for Nature and Society"], "inv": ["Band Foundation", "Dynamic Planet", "Sant Foundation"], "ngv": ["Costa Rica Ministry of Environment and Energy"], "ior": ["IUCN Species Survival Commission"], "ing": ["Earth Day Network", "Global Wildlife Conservation"]}