testToSQLite

Custom SQL query returning 1 row (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
163 ccid_0239 Business Ambition for 1.5 °C – Our Only Future mainly mitigation energy, industry     https://sciencebasedtargets.org/business-ambition-for-1-5c 2019 ‘Business Ambition for 1.5°C’ is an urgent call to action from a global coalition of UN agencies, business and industry leaders. We’re calling on companies to commit to set ambitious science-based emissions reduction targets. By setting a net-zero target in line with a 1.5°C future — our only future — businesses can make their critical contribution to limiting the worst impacts of climate change.               SDG explicitly mentioned SDG explicitly mentioned       SDG explicitly mentioned         Support efforts to hold global temperature rise to within 1.5° C above pre-industrial levels, in line with reaching net-zero emissions well before 2050           So far, over 300 companies, representing more than $3.6 trillion in market cap, have responded to the open letter from global leaders, and signed the Business Ambition for 1.5°C commitment.   Science-based global standard for corporate net-zero targets, to ensure that companies’ net-zero targets translate into action that is consistent with achieving a net-zero world by no later than 2050.   ["China", "Uruguay", "Sweden", "Portugal", "Spain", "Ireland", "Chile", "India", "United Kingdom of Great Britain and Northern Ireland (the)", "United States of America (the)", "Brazil", "Japan", "Australia", "Mexico", "Lebanon", "Luxembourg", "Pakistan", "France", "Germany", "Colombia", "Belgium", "Grenada", "Finland", "Denmark", "Norway", "Thailand", "Singapore", "Canada", "Bangladesh", "Kenya", "Russian Federation (the)", "Italy", "Switzerland", "Netherlands (the)", "United Arab Emirates (the)", "Sri Lanka", "Lithuania", "Costa Rica", "Hungary", "Viet Nam", "Uganda", "Indonesia", "Cameroon", "Jordan", "Egypt", "Mauritius", "Malaysia", "Saudi Arabia", "Hong Kong", "New Zealand"]   ["Science Based Targets Initiative (SBTi)", "United Nations Global Compact", "We Mean Business Coalition", "World Wide Fund for Nature (WWF)", "World Resources Institute (WRI)", "Carbon Disclosure Project (CDP)"] [Science Based Targets Initiative (SBTi)]_oth_int,[United Nations Global Compact]_ior_int,[We Mean Business Coalition]_oth_int {"bus": ["37 Interactive Entertainment", "4D Lab", "AB Electrolux", "AB Volvo", "Abreu Advogados", "ACCIONA", "Accenture", "Aceros AZA SA", "Adani Ports and Special Economic Zone Limited", "ADEC Innovations", "ADOBE", "AES Tiete Energia", "Aguas Andinas", "Aguas de Portugal", "Ajinomoto Co Inc", "Alaya Consulting Limited", "Ambev SA", "Amergin Pty Ltd", "America Movil SAB de CV", "Applied Materials", "An Post", "AKSUL Corporation", "Arab Printing Press", "Arauco", "Ardagh Group SA", "Artistic Milliners", "ASICS Corporation", "Assa Abloy AB", "AstraZeneca", "Atlantic Packaging", "Atlassian Corporation Plc", "Atos", "Auchan Retail Portugal", "Aurubis AG", "Avieco", "Avicola Coliumo", "Australian Ethical Investment", "Bain and Company", "Baluarte Cultura", "BanColombia SA", "Barco NV", "Bayer AG", "Beiersdorf AG", "Bennetts Associates", "Bharti Airtel Limited", "BIAL", "Biogen", "Brambles", "Brejinho by VR Lda", "Brunswick Group", "BT", "Burberry Plc", "Boston Consulting Group", "Boma Global", "Bontaz Group", "Caixa Geral de Depositos", "Capgemini SE", "Carbon Asset Developer Associates (Grenada) Limited", "Carbon Intelligence", "Cargotec", "Carlsberg Group", "CELLNEX TELECOM SA", "CEMAsyscom AS", "Chambers Federation", "CHANEL", "Charoen Pokphand Group Co Ltd", "Chr Hansen A S", "City Developments Limited (CDL)", "Cloetta AB", "Coca Cola European Partners", "Colgate Palmolive", "Coop Sverige AB", "Companhia Brasileira de Aluminio", "Consid AB", "Co operative Group Limited (the Co op)", "Community Servicesnet (CSnet)", "Croda International", "Crown Holdings Inc", "Crystal Claire Cosmetics", "CTT Correios de Portugal SA", "Cybercom Group AB", "Dalberg Advisors", "Dalmia Cement", "Danfoss Group", "Danone", "Decathlon", "Deutsche Telekom AG", "Dentsu International", "Dexus", "Diageo", "DLA Piper International", "Dr Reddys Laboratories Limited", "Dutch Bangla Pack Ltd", "Eco Panplas", "Eco Steel Africa Ltd", "Ecogestus Lda", "Ecolab", "EcoVadis", "EDP Energias do Brasil SA", "EDF Group", "Edge Environment", "EDP Energias de Portugal SA", "Efacec Power Solutions SGPS SA", "EKO BOJACA SASESP", "Elopak AS", "Enplus Group", "Enel Spa", "EPAL Empresa Portugesa das Aguas Livres SA", "EQUIPOS MOVILES DE CAMPANA ARPA", "Ericsson Group", "Europa Mundo Vacaciones", "Europcar Mobility Group", "Everis Portugal", "Facebook Inc", "Faurecia", "Ferrocarrils de la Generalitat de Catalunya", "Fidocar", "Fiskars Corporation", "Firmenich SA", "Footprint", "Ford Motor Company", "FullCycle", "Gebalis EM SA", "Geelen Counterflow", "General Mills", "Givaudan SA", "GlaxoSmithKline", "Globesight", "Glovo", "Green Element Limited", "Green Innovation Group A S", "Greenyard NV", "Grundfos Holding A S", "Grupo Malwee", "GSL Global Star Logistics", "Guess Inc", "Hannon Armstrong Capital LLC", "Hayleys Fabric PLC", "Henkel AG and Co KGaA", "Heathrow Airport Ltd", "Hempel A S", "Hewlett Packard Enterprises", "HH Global", "HandM Group", "Husqvarna AB", "Iberdrola", "Iberia Lineas Aereas de Espana SA", "IFF", "Ignitis Group", "INDITEX", "Infraestruturas de Portugal SA", "Indra", "Ingka Group (IKEA Group)", "Inter IKEA Group", "International Airlines Group (IAG)", "Intrepid Travel", "Intuit", "JLL", "John Sisk and Son", "JSW Energy Limited", "K 9 Internacional SA", "Kesko", "Kier Highways Limited", "Kingspan Group Plc", "Kirin Holdings Co Ltd", "Klabin SA", "Klockner and Co", "KLP", "Kokusai Kogyo Co Ltd", "KPMG International Limited", "KPMG UK LLP", "Kuehne plus Nagel International AG", "LOreal", "LafargeHolcim", "Landsec", "Lansinoh Laboratories Inc", "Lars Partners", "Legacy Vacation Resorts", "Legrand", "Levi Strauss and Co", "Lightsource bp", "Litoral Wines", "Lojas Renner SA", "LONGi Green Energy Technology Co Ltd", "Lundbeck A S", "MAAL Associates LLC", "MacArthur Green", "MaCher Inc", "Magyar Telekom Plc", "Mahindra Group", "Mahindra Heavy Engines Ltd", "Mammut Sports Group", "Maple Company Limited", "MARUI GROUP COLTD", "Mastercard", "Mattos Filho Veiga Filho Marrey Jr e Quiroga Advogados", "Microsoft", "Midwestern Group Limited", "Miljo Matematik Malmo AB", "Moodys Corporation", "Movida", "Multiplex Construction Europe", "MTR Nordic Group", "Natura and Co", "Nechi Group", "Neptuno Pumps", "Nestle SA", "News Corp", "Nogueira Elias Laskowski and Matias Advogados", "Nokia Corporation", "Nomura Research Institute Ltd", "NOS SPGS SA", "NOVO BANCO SA", "Novo Nordisk A S", "Novozymes", "NR Instant Produce Co Ltd", "NRG Energy Inc", "Olam International", "ONO PHARMACEUTICAL CO LTD", "Orange Group", "Orbia Advance Corporation SAB", "Orkla", "Orsted", "OVO Energy", "OXI ZEN Solutions LLC", "Ozone International", "Pachama", "Pago Company Ltd", "PayPal", "PepsiCo", "Pension Danmark", "Pier2 Marketing", "Pine Tree Company For Textile Manufacturing PSC", "Posti Group Ltd", "PNZ Produkte GmbH", "Pyxus International Inc", "PVH", "Qalaa Holdings", "Quidgest", "Quiero", "RATP Group", "ReAccion Alva", "Red Electrica de Espana", "Refinitiv", "Reliance Jio Infocomm Limited", "RENRedes Energeticas Nacionais", "rePurpose Global LLC", "Revenga Smart Solutions", "Ricoh Company Ltd", "Rolls Royce plc", "Royal DSM", "RT Knits Ltd", "Sacyr", "Saint Gobain", "Salesforcecom Inc", "SAP", "Sarawak Energy Berhad", "SAS Institute", "Saudi Telecom", "Scania", "Schneider Electric", "Scoop Scorecode Texteis SA", "Seventh Generation Inc", "Siemens Gamesa Renewable Energy SA", "Signify", "Singapore Telecommunications Ltd (Singtel)", "Sky Group", "SkyPower", "Smart Phases Inc", "Sodexo", "Sony Corporation", "Sopra Steria Group", "South East Water", "SQUARE Management Consulting", "SSE plc", "STMicroelectronics NV", "Storebrand ASA", "SUEZ", "Sustainia", "Sweco", "Swire Coca Cola Limited", "Swisscom AG", "Swiss Reinsurance", "Symrise", "Taiga Apparel Pvt Limited", "TalkTalk", "Tchibo GmbH", "TDC A S", "Tech Mahindra Ltd", "Telefonica", "Telia", "Tendam Retail SA", "TenneT Holding BV", "Tesco", "The British Land Company PLC", "The Lux Collective Ltd", "Thor Industries Inc", "Tintex Textiles SA", "TMG Automotive", "Tokmanni Oy", "Toitu Envirocare", "Transurban Group", "Triciclos SA", "Unibail Rodamco Westfield SE", "Unidas S A", "Unilever", "Univar Solutions", "UPM Kymmene", "Uxua Casa Hotel and Spa", "Vakrangee Limited", "VALORA Sustainability and Innovation", "The VELUX Group", "Vina Concha y Toro", "Vina Polkura SA", "Vodafone Group PLC", "WasteBox Inc", "Wipro", "White house", "Workday", "Workspace Group PLC", "Yarra Valley Water", "YASAVA", "Zurich Insurance"]}