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
297 ccid_0544 Leaders' Pledge for Nature mainly mitigation land use, oceans and coastal zones, water, human settlements, industry     https://www.leaderspledgefornature.org/ 2020 Political leaders participating in the United Nations Summit on Biodiversity in September 2020, representing 81 countries from all regions and the European Union, have committed to reversing biodiversity loss by 2030. By doing so, these leaders are sending a united signal to step up global ambition and encourage others to match their collective ambition for nature, climate and people with the scale of the crisis at hand. SDG explicitly mentioned               SDG explicitly mentioned     SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned [Reverse biodiversity loss by 2030 for sustainable development] Participants have created a list of ten broad-based goals towards achieving the UN Sustainable Development Goals by addressing biodiversity loss. Participants have planned to convene at the UN General Assembly High Level Week in September 2021, and CoP 15 to review progress. No detailed targets or monitoring arrangements have been established at this time. [Align domestic climate policies with the Paris Agreement to keep global temperature rise below 2 degrees Celsius]       [Eliminate plastic leakage to the ocean by 2050]         ["Albania", "Andorra", "Armenia", "Austria", "Bangladesh", "Barbados", "Belgium", "Belize", "Bhutan", "Bolivia (Plurinational State of)", "Bosnia and Herzegovina", "Bulgaria", "Canada", "Colombia", "Comoros (the)", "Costa Rica", "Cyprus", "Czechia", "Denmark", "Djibouti", "None", "Estonia", "Fiji", "Finland", "France", "Gabon", "Georgia", "Germany", "Greece", "Guatemala", "Honduras", "Hungary", "Iceland", "Ireland", "Israel", "Italy", "Jordan", "Kenya", "Latvia", "Lebanon", "Lesotho", "Lithuania", "Luxembourg", "Maldives", "Malta", "Mexico", "Moldova (the Republic of)", "Monaco", "Montenegro", "Morocco", "Nepal", "Netherlands (the)", "New Zealand", "Nigeria", "Norway", "Pakistan", "Palau", "Panama", "Paraguay", "Peru", "Portugal", "Marshall Islands (the)", "Republic of North Macedonia", "Congo (the Democratic Republic of the)", "Romania", "San Marino", "Seychelles", "Slovakia", "Slovenia", "Spain", "Sri Lanka", "Saint Lucia", "Sweden", "Switzerland", "Gambia (the)", "Timor-Leste", "United Kingdom of Great Britain and Northern Ireland (the)", "Uganda"]   [""] [Alliance of Small Island States (AOSIS)]_sgv_int,[Belize]_ngv_blz,[Bhutan]_ngv_btn,[Colombia]_ngv_col,[Costa Rica]_ngv_cri,[European Union]_sgv_int,[Finland]_ngv_fin,[Kenya]_ngv_ken,[Seychelles]_ngv_syc,[United Kingdom]_ngv_gbr {"ngv": ["Bhutan", "Bolivia", "Bosnia and Herzegovina", "Bulgaria", "Canada", "Colombia", "Comoros", "Costa Rica", "Cyprus", "Czech Republic", "Denmark", "Djibouti", "EU", "Estonia", "Fiji", "Finland", "France", "Gabon", "Georgia", "Germany", "Greece", "Guatemala", "Honduras", "Hungary", "Iceland", "Ireland", "Israel", "Italy", "Jordan", "Kenya", "Latvia", "Lebanon", "Lesotho", "Lithuania", "Luxembourg", "Maldives", "Malta", "Mexico", "Moldova", "Monaco", "Montengro", "Morocco", "Nepal", "Netherlands", "New Zealand", "Nigeria", "Norway", "Pakistan", "Palau", "Panama", "Paraguay", "Peru", "Portugal", "Republic of Marshall Islands", "Republic of North Macedonia", "Republique du Congo", "Romania", "San Marino", "Seychelles", "Slovakia", "Slovenia", "Spain", "Sri Lanka", "Saint Lucia", "Sweden", "Switzerland", "Gambia", "Timor Leste", "United Kingdom", "Uganda"], "bus": ["Business for Nature Coalition", "Danone", "Greenhouse PR", "International Chamber of Commerce", "KM0 Energy", "Uniliver"], "sgv": ["ICLEI Local Governments for Sustainability", "Regions4Sustainable Development"], "ing": ["African Conservation Foundation", "Animal Defenders International", "BirdLife International", "Carribbean Natural Resources Institute (CANARI)", "Club of Rome", "Conservation International", "EAT", "Ecology International Australia", "Except Integrated Sustainability", "FacingFuture Earth", "Future Earth", "Global Alliance on Health and Pollution (GAHP)", "Global Choices", "Global Footprint Network", "The International Childbirth Education Association (ICEA", "Incitare International", "International Council of Environmental Law (ICEL)", "International Institute for Environment and Development (IIED)", "OS Climate", "Planetary Emergency Partnership", "Save the Rhino International", "Stop Ecocide International", "The Interfaith Center for Sustainable Development", "The Nature Conservancy", "TreeSisters", "True Nature Foundation", "We Forest ASBL VZW", "World Land Trust", "World Resources Institute (WRI)", "World Wildlife Fund (WWF)", "FaithInvest", "The Global Environment Facility (GEF)"], "dng": ["Aytzim Ecological Judaism", "\nCoordinadora Ecuatoriana de Organizaciones para la Defensa de la Naturaleza y el Medio Ambiente (CEDENMA)", "Climate and Sustainability", "Congres d Energia de Catalunya", "Ecoacsa Reserva de Biodiversidad", "MOVE BG Foundation", "National Audubon Society", "One Nature", "Shabnam Resources", "The Biodiversity Consultancy Ltd", "US Alliance for Wildlife and Health", "WildEarth Guardians", "Wildlife and Countryside Link", "Jupau Indigenous Association"], "edu": ["Cornell Botanic Gardens", "Postdam Institute for Climate Impact Research"], "ior": ["World Bank"]}