testToSQLite

Custom SQL query returning 7 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
277 ccid_0359 100 Resilient Cities equally adaptation & mitigation human settlements http://climateinitiativesplatform.org/index.php/100_Resilient_Cities http://climateinitiativesplatform.org/index.php/100_Resilient_Cities http://www.100resilientcities.org,http://climateinitiativesplatform.org/index.php/100_Resilient_Cities,https://web.archive.org/web/20190726140951/http://www.100resilientcities.org/ 2013 100 Resilient Cities—Pioneered by The Rockefeller Foundation is financially supported by The Rockefeller Foundation and managed as a sponsored project by Rockefeller Philanthropy Advisors (RPA), an independent 501(c)(3) nonprofit organization that provides governance and operational infrastructure to its sponsored projects. In April 2019 the news broke that 100 Resilient Cities was to no longer receive funding from the Rockefeller Foundation six years after its launch. The announcement came as a major shock to its almost 100 staff and those familiar with its work, as the organisation had by all measures been successful in its primary aim—helping cities build workable resiliency strategies. Budget issues and a change in leadership at the foundation in 2017 were the most likely reasons for 100RC’s sudden exit, but a glimmer of hope emerged when the foundation agreed to continue funding some of its initiatives, like the chief resilience officer (CRO) roles it had helped create in cities. Six months on we are beginning to see what the transition looks like with the creation of two new organisations, Resilient Cities Catalyst (RCC), which was unveiled last week, and the Global Resilient Cities Network (GRCN), which will be officially launched at the World Urban Forum next week. (Note: Initiative ended in 2019)                     SDG explicitly mentioned   SDG explicitly mentioned       SDG explicitly mentioned                     ["Ghana", "Ethiopia", "Jordan", "Greece", "United States of America (the)", "India", "Thailand", "Spain", "United Kingdom of Great Britain and Northern Ireland (the)", "Serbia", "Argentina", "Lebanon", "Canada", "Colombia", "Viet Nam", "South Africa", "New Zealand", "Mexico", "Senegal", "China", "Indonesia", "Rwanda", "Japan", "Nigeria", "Portugal", "Egypt", "Myanmar", "Malaysia", "Australia", "Italy", "Uruguay", "Kenya", "Panama", "France", "Liberia", "Brazil", "Ecuador", "Palestine, State of", "Netherlands (the)", "Puerto Rico", "Dominican Republic (the)", "Chile", "Korea (the Republic of)", "Singapore", "Georgia", "Israel", "Denmark"]   ["Rockefeller Philanthropy Advisors"] [Rockefeller Philanthropy Advisors]_ing_usa,[World Resources Institute (WRI)]_edu_usa {"sgv": ["Accra", "Addis Ababa", "Amman", "Athens", "Atlanta", "Bangalore", "Bangkok", "Barcelona", "Belfast", "Belgrade", "Berkeley", "Boston", "Boulder", "Bristol", "Buenos Aires", "Byblos", "Calgary", "Cali", "Can Tho", "Cape Town", "Chennai", "Chicago", "Christchurch", "Colima", "Da Nang", "Dakar", "Dallas", "Deyang", "Durban", "El Paso", "Glasgow", "Guadalajara", "Haiyan", "Honolulu", "Huangshi", "Jaipur", "Jakarta", "Juarez", "Kigali", "Kyoto", "Lagos", "Lisbon", "London", "Los Angeles", "Louisville", "Luxor", "Greater Manchester", "Mandalay", "Medellin", "Melaka", "Melbourne", "Mexico City", "Greater Miami and the Beaches", "Milan", "Minneapolis", "Montevideo", "Montreal", "Nairobi", "Nashville", "New Orleans", "New York", "Norfolk", "Oakland", "Panama City", "Paris", "Paynesville", "Pittsburgh", "Porto Alegre", "Pune", "Quito", "Ramallah", "Rio de Janeiro", "Rome", "Rotterdam", "Salvador", "San Francisco", "San Juan", "Santa Fe", "Santiago de los Caballeros", "Santiago", "Seattle", "Semarang", "Seoul", "Singapore", "St Louis", "Surat", "Sydney", "Tbilisi", "Tel Aviv", "The Hague", "Thessaloniki", "Toronto", "Toyama", "Tulsa", "Vancouver", "Vejle", "Washington DC", "Wellington", "Yiwu"]}                                
226 ccid_0302 Asian Seafood Improvement Collaborative nature-based solutions oceans and coastal zones     http://www.asicollaborative.org/ 2013 THE ASIAN SEAFOOD IMPROVEMENT COLLABORATIVE IS A GROUP OF INTERNATIONAL STAKEHOLDERS DEDICATED TO DEVELOPING CREATIVE STRATEGIES FOR IMPROVING THE ASIAN SEAFOOD INDUSTRY. ASIC is a burgeoning regional collaboration between private sector stakeholders from Indonesia, Myanmar, Philippines, Thailand, and Vietnam who have come together to tackle social and environmental sustainability challenges facing the Asian seafood industry. ASIC stakeholders represent various elements of the Asian seafood industry including producer organizations, processors, environmental NGOs, and local certification bodies. These ASIC participants work in conjunction with export market stakeholders, including NGOs, buyers, and certification bodies, to build innovative tools designed to foster improvement for both shrimp aquaculture and fisheries in the region.                       SDG explicitly mentioned   SDG explicitly mentioned                           ["Myanmar", "Indonesia", "Viet Nam", "Thailand", "Philippines (the)"]   ["Oxfam", "Sweden"] [ICAFIS Vietnam]_dng_vnm,[Socsksargen fishing]_bus_phl,[PT Alter Trade]_bus_idn,[Myanmar Sustainable Aquaculture Programme]_dng_mmr,[Tambuyog Development Center]_dng_phl,[Chicken of the Sea]_bus_tha,[Vietnam Seaculture Association]_bus_vnm,[MDPI]_dng_idn {"edu": ["Kasetsart University"], "bus": ["Vietnam Association of Seafood Export Processors", "Aceh Aquaculture Cooperative", "Pt Atina", "Thai Shrimp Association", "Thai Union", "Vietnam Sea culture Association", "Ecohub Global", "Fairagora", "Blue Apron"], "ing": ["Wetlands International", "Monterey Bay Aquarium Seafood Watch", "Liberty Asia", "Fishmatter", "Solidaridad", "Rare", "Oxfam"], "dng": ["Myanmar Shrimp Association"]}                                
30 ccid_0031 Blue Growth Initiative equally adaptation & mitigation oceans and coastal zones     http://www.fao.org/policy-support/policy-themes/blue-growth/en/ 2013 The world’s marine and freshwater ecosystems – the Blue World – provide food and livelihoods, essential ecosystem services and biodiversity for hundreds of millions of people. Increasing pollution, over-exploitation, Illegal, Unreported and Unregulated (IUU) fishing and climate change have become major threats to these aquatic eco-systems - and underpin the need for more resource efficient, integrated and socially inclusive concepts. FAO promotes sustainable fishery and aquaculture policies and practices to achieve sustainable use of living aquatic resources. The FAO Code of Conduct for Responsible Fisheries (CCRF) has been in place for two decades – and continues to be the global reference framework to achieve this. In 2013, FAO launched the Blue Growth Initiative (BGI), which builds on the CCRF and focuses on fisheries, aquaculture, ecosystem services, trade and social protection. It advocates ways to balance economic growth, social development, food security, and sustainable use of aquatic living resources. SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned   SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned [10% reduction of carbon emissions in the 10 target countries in 5 years and 25% in 25 years] Source: https://cop23.unfccc.int/news/the-blue-growth-initiative-building-resilience-of-coastal-communities     [Blue communities established in 5 target countries and resource stewardship with 30% improved livelihoods]   [Ecosystem degradation reversed in the target countries and 10% ecosystems restored in 4 target countries within 5 years]     [Reduction of overfishing by 20% in the target countries in 5 years and 50% in 10 years]   ["Algeria", "Bangladesh", "Barbados", "Cabo Verde", "Grenada", "Indonesia", "C\u00f4te d'Ivoire", "Kenya", "Madagascar", "Mauritania", "Morocco", "Mozambique", "Nigeria", "Philippines (the)", "Sao Tome and Principe", "Senegal", "Seychelles", "Sri Lanka", "Saint Lucia", "Viet Nam", "Timor-Leste", "Tunisia", "Zambia"]   [""] [UNDP]_ior_int,[NORAD]_ing_nor,[UNEP]_ior_int,[ICFA]_oth_unk,[Global Environmental Facility]_ing_usa,[World Bank]_ior_int,[Food and Agriculture Organization (FAO)]_ior_int {"ing": ["WWF", "MSC"], "ngv": ["Algeria", "Bangladesh", "Barbados", "Cabo Verde", "Grenada", "Indonesia", "Ivory Coast", "Kenya", "Madagascar", "Mauritania", "Morocco", "Mozambique", "Netherlands", "Nigeria", "Philippines", "Sao Tome and Principe", "Senegal", "Seychelles", "Sri Lanka", "St Lucia", "Vietnam", "Timor Leste", "Tunesia", "Zambia"]}                                
190 ccid_0266 Oceania 21 equally adaptation & mitigation oceans and coastal zones     https://sidspartnerships.un.org/partnerships/?p=7714 2013 Through an active membership and the future permanent institution, the annual conference will take a important place. Arrangements for Capacity-Building and Technology Transfer 1. The commitment of the Solomon Islands, Vanuatu and New Caledonia to form a common working group responsible for defining the group to explore possible avenues for collaboration between the parties in managing jointly their maritime zones. 2. A joint regional development plan for a pilot holothurian (sea cucumber/beche de mer) breeding programme, based on cooperation between Tuvalu, Vanuatu, American Samoa, Samoa, Tonga, Kiribati, New Caledonia and such other Pacific countries as may be interested                         SDG explicitly mentioned SDG explicitly mentioned                           ["New Caledonia", "Vanuatu", "Tuvalu", "Marshall Islands (the)", "Solomon Islands", "Samoa", "American Samoa", "Nauru", "Niue", "Palau", "Tonga", "Wallis and Futuna", "Cook Islands (the)", "Micronesia (Federated States of)", "Kiribati", "Papua New Guinea", "French Polynesia"]   ["France"] [New Caledonia]_ngv_ncl,[France]_ngv_fra {"ngv": ["Vanuatu", "Tuvalu", "Marshall Islands", "Solomon Islands", "Samoa", "American Samoa", "Nauru", "Niue", "Palau", "Tonga", "Wallis and Futuna", "Cook Islands", "Federated States of Micronesia", "Kiribati", "Papua New Guinea", "French Polynesia", "Secretariat of the Pacific Community"], "ior": ["SPREP"], "ing": ["Prince Albert II of Monaco", "Green Cross and Ocean Futures Society"], "edu": ["the French Research for Development Institute (IRD) "]}                                
230 ccid_0306 The Ocean Cleanup Marine pollution oceans and coastal zones     https://theoceancleanup.com/ 2013 The Ocean Cleanup is designing and developing cleanup systems to clean up what is already polluting our oceans and to intercept plastic on its way to the ocean via rivers. A significant percentage of the plastic that enters the oceans from rivers and other sources during a transfer that can take many years, drifts into large systems of circulating ocean currents, also known as gyres. Once trapped in a gyre, the plastic will slowly break down into microplastics and become increasingly easier to mistake for food by sea life.                                             [Reach a 90% reduction of floating ocean plastic by the year 2040; tackle plastic in 1000 rivers by 2025]         ["Indonesia", "Malaysia"]   ["Maersk", "Latham and Watkins", "Deloitte", "Boskalis", "De Brauw Blackstone Westbroek", "The Netherlands", "Macquarie", "AkzoNobel"] [The Ocean Cleanup]_oth_nld {"bus": ["Salesforce", "iridium", "Seiche Water Technology Group", "Data Iku", "Microsoft", "Brabantia", "CFF", "DSM", "Agru", "Solidworks", "APL", "BCG", "Ecocast", "Gard", "EgonZehnder", "Globus", "We Ship Yachts", "Orcina", "VBAT", "KLM", "Mocean", "Acta Marine", "Alphatron Marine", "Applus+", "Aram Group", "Aspect Consulting", "BIND film", "Buckaroo", "C-Job", "Calumet Photo", "CSA Ocean Sciences", "Coosto", "CoreTeka", "Danone", "Deltares", "Deugro", "DJI", "Dropbox", "Euromonitor", "Falck Safety Services", "Frans Executive Search", "Geometius", "Global Maritime", "GOM", "GoPro", "Grayling", "Greenhost", "GRRR", "GSS Marine Services", "Heerema Marine Contractors", "HKV Lijn in Water", "in60seconds", "Intel", "INVENT Umwelt- und Verfahrenstechnik AG", "Jardine Lloyd Thompson", "Jurlights", "Key Code Media", "Kiwa", "Kreber", "Lankhorst Ropes", "LiveU", "Lloyd\u2019s Register", "Marine Instruments", "Maskell Pipe and Supply", "Maxar Technologies", "Metrixlab", "Musto", "Netherland-America Foundation", "Panasonic LUMIX", "Progressive Recruitment", "Port Health Centre", "Readme", "Riff Online", "RISKID", "Rise Marketing Group", "Royal Haskoning DHV", "Seatools", "South Pole", "SPECIFIC", "Stichting De Verre Bergen", "SurfSARA", "TK Maxx and Homesense", " Nobels and Ten Veen", "Vis Staalbouw", "VO Patents and Trademarks", "Webslice", "Websols", "Westmarine", "Xflow", "Xomnia", "yPlus"], "ing": ["The Bennink Foundation"], "edu": ["TU Delft ", "Universit\u00e4t Wien", "Wageningen University", "University of Miami", "Universiteit Utrecht", "Carl von Assietzky Universit\u00e4t", "University of Zurich", "University of the Aegean", "Can Tho University", "Ho Chi Minh City University ", "University of Hawaii", "Royal Netherlands Insitute for Sea Research", "Smithsonian Environmental Research Center", "MARIN", "Netherlands Institute for the Law of the Sea (NILOS)"]}                                
152 ccid_0211 BioCarbon Fund Initiative for Sustainable Forest Landscapes mainly mitigation land use     https://www.biocarbonfund-isfl.org/ 2013 The BioCarbon Fund Initiative for Sustainable Forest Landscapes (ISFL) is a multilateral fund that promotes reducing greenhouse gas emissions from the land sector, including efforts to reduce deforestation and forest degradation in developing countries (REDD+), sustainable agriculture, as well as smarter land-use planning, policies and practices. ISFL aims to help rural communities address poverty and develop sustainably while simultaneously reducing land-based greenhouse gas emissions. To accomplish these goals, ISFL programs seek to build on experience, leverage partnerships, incentivize results, and emphasize working at scale.The ISFL is a multilateral facility that promotes and rewards reduced greenhouse gas emissions and increased sequestration through better land management, including reducing emissions from deforestation and forest degradation (REDD+), climate-smart agriculture, and smarter land-use planning and policies.The ISFL aims to catalyze the development of a low-carbon rural economy in each of its program areas that will simultaneously result in livelihood opportunities for communities and an overall reduction in land-based emissions.   SDG explicitly mentioned                     SDG explicitly mentioned   SDG explicitly mentioned     250 million tons of CO2 to be 'purchased' through the BioCarbon Fund         Covering 120 million hectares in total land area         ["Colombia", "Mexico", "Ethiopia", "Zambia", "Indonesia"]   ["World Bank", "BMU", "NICFI", "SDC", "BEIS", "DEFRA", "DOS"] [World Bank]_ior_usa {"ngv": ["MADR", "MADS", "DNP", "CONAFOR", "Ministry of Environment and Forest", "Ministry of Environment and Forestry", "Interim Climate Change Secretariat", "SilvaCarbon"], "edu": ["IDEAM"]}                                
64 ccid_0075 Urban Electric Mobility Initiative mainly mitigation transport     uemi.net 2013 Urban Electric Mobility Initiative (UEMI) was initiated by UN-Habitat and the SOLUTIONS project and launched at the UN Climate Summit in September 2014 in New York. The UEMI aims to contribute significantly to the overall goal of limiting the increase in global mean temperature to two degrees Celsius above pre-industrial levels by decreasing urban CO2 emissions globally. As one of the Action Areas of the UN Climate Summit the UEMI aims to phase out conventionally fuelled vehicles in cities and integrate electric mobility into a wider concept of sustainable urban transport. The secretariat of the Urban Electric Mobility Initiative was established to facilitate the operation of the Urban Electric Mobility Initiative. The UEMI secretariat develops partnerships with local authorities, industry, SMEs, knowledge and network partners to implement innovative urban electric mobility solutions. The UEMI partnership currently consists of over 150 partners collaborating on implementation-oriented projects. Sustainable energy and mobility can make positive contributions to a number of policy objectives, nationally and locally. In particular in cities there is a great potential to create synergies between for example safety, air quality, productivity, access and climate change mitigation. The UEMI secretariat acts as resource centre and provides opportunities for direct collaboration on projects focusing on sustainable urban mobility and the role e-mobility can play in it. The UEMI secretariat pools expertise, facilitate exchange and initiate implementation oriented actions. The resource centre aims to bridge the gap between urban energy and transport and boosting sustainable transport and urban e-mobility.                         SDG explicitly mentioned                     [Increase the global market share of electric vehicles in cities to reach at least 30% by 2030; Electric vehicles will form 30% of the fleet of light duty vehicles by 2030 in commited cities; Multiateral development banks will pledge 30% more investment in infrastructure to support cities in attaining the aforemetioned goals]       ["Mexico", "Ecuador", "Brazil", "Uruguay", "Colombia", "Spain", "China", "Nepal", "India", "Philippines (the)", "Viet Nam", "Indonesia", "Fiji", "Malaysia", "Ethiopia", "Jordan", "Rwanda", "Zambia", "South Africa", "Morocco", "Ghana", "Kenya", "Egypt", "Poland", "Germany", "France", "Hungary", "Ukraine"]   ["European Union"] [UN-Habitat]_ior_int {"bus": ["Bosch", "BMW", "BYD", "EMPOWER", "Michelin", "FIAT", "Ertico ITS Europe", "UITP", "Vulcan"], "edu": ["Aristotle University of Thessaloniki", "AustriaTech", "European Association for Electromobility - AVERE", "CEPT University", "Czech Technical University Centro Ricerche", "Centre for Research and Technology-Hellas (CERTH)", "China Academy of Transportation Sciences (CATS)", "UC-Davis", "Concawe", "Wuppertal Institute", "AIT"], "ing": ["Clean Air Asia", "ECF", "GIZ", "Polis", "Sustainable Transport Africa"], "oth": ["Eliptic", "Trivector Travis"], "ngv": ["European Commission", "Swedish Electromobility Centre"], "ior": ["International Energy Agency", "IRU World Transport Organization"], "sgv": ["San Juan Compala", "Quito", "Belo Horizonte", "Montevideo", "Ibague", "Leon", "Shenzen", "Kathmandu", "Kochi", "Tacloban ", "Hanoi", "Bogor", "Pasig", "Suva", "Melaka", "Addis Abeba", "Amman", "Kigali", "Lusaka", "Cape Town", "Casablanca", "Accra", "Nairobi", "Cairo", "Warsaw", "Bremen", "Barcelona", "LaRochelle", "Budapest", "Kiew"]}