testToSQLite

Custom SQL query returning 4 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
99 ccid_0123 Super-efficient Equipment and Appliance Deployment Initiative mainly mitigation energy   http://climateinitiativesplatform.org/index.php/Super-efficient_Equipment_and_Appliance_Deployment_(SEAD)_Initiative http://www.superefficient.org/ 2010 The Super-efficient Equipment and Appliance Deployment (SEAD) Initiative is a voluntary collaboration among governments working to promote the manufacture, purchase, and use of energy-efficient appliances, lighting and equipment worldwide. SEAD is an initiative under the Clean Energy Ministerial (CEM) and a task of the International Partnership for Energy Efficiency Cooperation (IPEEC).             SDG explicitly mentioned   SDG explicitly mentioned       SDG explicitly mentioned       SDG explicitly mentioned   If all SEAD governments were to adopt current policy best practices for product energy efficiency standards, 2,000 TWh of annual electricity could be saved in 2030, equal to the energy generated by 650 mid-sized power plants. Collectively, these measures would decrease CO2 emissions over the next two decades by 11 billion tonnes, seven times more than the annual emissions of all road vehicles in the United States.                 ["Argentina", "Australia", "Brazil", "Canada", "Chile", "China", "India", "Indonesia", "Korea (the Republic of)", "Mexico", "Russian Federation (the)", "Saudi Arabia", "South Africa", "United Arab Emirates (the)", "United States of America (the)", "Austria", "Belgium", "Bulgaria", "Croatia", "Cyprus", "Czechia", "Denmark", "Estonia", "Finland", "France", "Germany", "Greece", "Hungary", "Ireland", "Italy", "Latvia", "Lithuania", "Luxembourg", "Malta", "Netherlands (the)", "Poland", "Portugal", "Romania", "Slovakia", "Slovenia", "Spain", "Sweden", "United Kingdom of Great Britain and Northern Ireland (the)"]   ["Ministerio de Energia y Mineria", "Department of Industry", " Innovation and Science", "Minist\u00e9rio de Minas e Energia", "Natural Resources Canada", "Ministry of Energy", "China National Institute of Standards", "Directorate-General for Energy", "Federal Institute for Materials Research and Testing", "Bureau of Energy Efficiency", "Ministry of Energy and Energy Resources (MEMR)", "Korea Energy Agency", "Comisi\u00f3n Nacional Para El Uso Eficiente De La Energ\u00eda (CONUEE)", "Swedish Energy Agency", "Ministry of Energy", "Ministry of Energy", " Industry and Mineral Resources", "Department of Energy", "Department for Business", " Energy & Industrial Strategy (BEIS)", "Department of Energy"] [Department of Energy]_ngv_usa,[Bureau of Energy Efficiency]_ngv_ind {"ngv": ["Ministerio de Energia y Mineria", " Innovation and Science", "Minist\u00e9rio de Minas e Energia", "Natural Resources Canada", "Ministry of Energy", "China National Institute of Standards", "Directorate-General for Energy", "Federal Institute for Materials Research and Testing", "Bureau of Energy Efficiency", "Ministry of Energy and Energy Resources (MEMR)", "Korea Energy Agency", "Comisi\u00f3n Nacional Para El Uso Eficiente De La Energ\u00eda (CONUEE)", "Swedish Energy Agency", "Ministry of Energy", " Industry and Mineral Resources", "Department of Energy", " Energy & Industrial Strategy (BEIS)", "Department of Energy"], "ior": ["APEC", "CLASP", "ECREEE", "IEA"], "ing": ["en.lighten initiative"], "oth": ["IEA 4E"], "edu": ["LBNL", "Standards Coordination Community of Practice"]}                                
119 ccid_0154 Coffee & Climate mainly adaptation land use, agriculture     https://coffeeandclimate.org 2010 The initiative for coffee&climate (c&c) is an open global partnership of coffee companies and public partners who strive to address the negative effects of climate change in coffee and help the sector to adapt. Due to varying weather conditions, the extensive expertise of c&c encourages practical adaptation and further developing sustainable production methods which secure higher yields and return of investment. Thus, c&c promotes a coordinated effort of dedicated members within the coffee sector. The aim is to enable smallholder coffee farming families to better respond to climate change in the short and long term by increasing their adaptive capacity and resilience. SDG explicitly mentioned SDG explicitly mentioned     SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned           SDG explicitly mentioned   SDG explicitly mentioned                         ["Brazil", "Tanzania, United Republic of", "Honduras", "Guatemala", "Viet Nam"]   [""] [Hanns R. Neumann Stiftung]_ing_deu,[Conservation International]_ing_usa {"bus": ["Paulig", "Joh. Johannson Kaffe AS", "L\u00f6fbergs", "Fondazione Guiseppe e Pericle Lavazza Onlus", "Tchibo", "Neumann Kaffee Gruppe", "Tim Hortons", "Starbucks", "Franck"], "ngv": ["GIZ on behalf of Federal Ministry for Economic Cooperation and Development", "SIDA"], "ing": ["Hanns R. Neumann Stiftung", "Conservation International"]}                                
110 ccid_0143 Banking Environment Initiative mainly mitigation industry     https://www.cisl.cam.ac.uk/business-action/sustainable-finance/banking-environment-initiative/ 2010 The Banking Environment Initiative (BEI) is a group of global banks committed to pioneering actionable pathways towards a sustainable economy. The BEI co-produces horizon scanning applied research, develops leadership tools and convenes academic and industry collaborations.                         SDG explicitly mentioned                             ["Kosovo"]   ["Barclays", "BNP Paribas", "RBS", "Deutsche Bank", "Lloyds Banking Group", "Santander", "Standard Chartered"] [University of Cambridge]_edu_gbr {"inv": ["Barclays", "BNP Paribas", "RBS", "Deutsche Bank", "Lloyds Banking Group", "Santander", "Standard Chartered"]}                                
202 ccid_0278 Climate Bonds Initiative equally adaptation & mitigation energy, industry     https://www.climatebonds.net 2010 Climate Bonds Initiative is an international organisation working solely to mobilise the largest capital market of all, the $100 trillion bond market, for climate change solutions. We promote investment in projects and assets necessary for a rapid transition to a low carbon and climate resilient economy. The strategy is to develop a large and liquid Green and Climate Bonds Market that will help drive down the cost of capital for climate projects in developed and emerging markets; to grow aggregation mechanisms for fragmented sectors; and to support governments seeking to tap debt capital markets. Climate Bonds Initiative is an investor-focused not-for-profit. Our work therefore is an open source public good and falls into three workstreams.             SDG explicitly mentioned   SDG explicitly mentioned       SDG explicitly mentioned                       Mobilising the $100 trillion bond market for climate change solutions     ["United Kingdom of Great Britain and Northern Ireland (the)", "United States of America (the)", "Kenya", "Canada", "Switzerland", "Netherlands (the)", "France", "Germany", "Japan", "China", "Bermuda", "Australia", "Denmark", "Finland", "Luxembourg", "Sweden", "Iceland", "Taiwan (Province of China)", "Panama", "Italy", "Ukraine", "Nigeria", "Belgium"]   ["Foreign Commonwealth and Development Office", "Climate Works Foundation", "Inter American Development Bank", "OAK Foundation", "Financial Sector Deepening Africa (fsd Africa)", "European Climate Foundation", "The Rockefeller Foundation", "EUs Horizon 2020", "UNDP Global Environmental Finance (UNDP GEF)", "Martin International", "Climate KIC", "State Secretariat for Economic Affairs (SECO)", "Ashrst", "Shearman and Sterling", "Clifford Chance"] [Foreign Commonwealth and Development Office]_sgv_gbr,[Climate Works Foundation]_dng_usa,[Inter American Development Bank]_inv_usa,[OAK Foundation]_ing_int,[Financial Sector Deepening Africa (fsd Africa)]_ing_ken,[European Climate Foundation]_ing_int,[The Rockefeller Foundation]_ing_usa,[EUs Horizon 2020]_ngv_int,[UNDP Global Environmental Finance (UNDP GEF)]_ior_int,[Martin International]_dng_can,[Climate KIC]_oth_int,[State Secretariat for Economic Affairs (SECO)]_sgv_che,[Ashrst]_bus_gbr,[Shearman and Sterling]_bus_usa,[Clifford Chance]_bus_gbr {"sgv": ["Foreign Commonwealth and Development Office", "State Secretariat for Economic Affairs (SECO)", "Ministry of Ecological Transition"], "dng": ["Climate Works Foundation", "Martin International"], "inv": ["Inter American Development Bank", "Blackrock", "Credit Suisse", "Royal Bank of Canada (RBC)", "Rabobank", "Standard Chartered", "Barclays", "HSBC", "FMO Entrepreneurial Development Bank", "Societe Generale", "Lyxor", "Amundi Asset Management", "Bayern LB", "Citi", "State Street Global Advisors", "BNP Paribas Asset Management", "Baker McKenzie", "Nomura", "Refinitiv", "London Stock Exchange Group", "HKEX", "Stichting Pensioenfonds Zorg en Welzijn (PGGM)", "Mitsubishi UFJ Morgan Stanley", "Norton Rose Fulbright", "AXA Investment Managers", "M and G Investments", "UBS", "Solactive", "Fidelity International", "National Australia Bank (NAB)", "Natixis", "Danske Bank", "Zurich Cantonal Bank", "S and P Global", "Australia and New Zealand Banking Group (ANZ)", "Munifin", "SIX Financial Information", "Nasdaq", "Goldman Sachs", "Luxembourg Stock Exchange (LuxSE)", "VanEck", "BCEE Asset Management", "PIMCO", "Handelsbanken", "MSCI", "SMBC Nikko Securities Inc", "Estates and Infrastructure Exchange (EIX)", "ABN AMRO", "Bordier", "Moodys Investors Service", "Fossar Markets", "Berlin Hyp", "Luxembourg Green Exchange", "Mizuho Bank", "Clean Energy Finance Corp (CEFC)", "DZ Bank", "Commerz Bank", "NN Investment Partners", "Obvion Hypotheken", "LBEBW", "Westpac Banking Corporation", "Commonwealth Bank of Australia", "Trio Investment BV", "Union Investment", "Affirmative Investment Management (AIM)", "Deutsche Boerse Group", "Rivertree Investment Funds", "Allianz Global Investments", "UniCredit Corporate and Investment Banking", "Alliance Bernstein", "Taipei Exchange", "Panama Stock Exchange", "Deka Bank", "Green Building Council Australia", "Daiwa Securities", "Borsa Italiana", "Vetiva Capital Management Limited", "Thomson Reuters", "Investor Group on Climate Change", "Clarmondial", "Investor Network on Climate Risk", "Tullett Prebon"], "ing": ["OAK Foundation", "Financial Sector Deepening Africa (fsd Africa)", "European Climate Foundation", "The Rockefeller Foundation"], "ngv": ["EUs Horizon 2020"], "ior": ["UNDP Global Environmental Finance (UNDP GEF)", "UNEP Finance Initiative Principles for Sustainable Insurance (UNEP PSI)"], "oth": ["Climate KIC", "Partnership on Sustainable Low Carbon Transport (SLOCAT Partnership)"], "bus": ["Ashrst", "Shearman and Sterling", "Clifford Chance", "SolTech Energy", "Jool Markets", "White and Case LLP", "D Tek", "Carbonsink"], "edu": ["Monash University", "International Institute for Sustainable Development (IISD)"]}