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
173 ccid_0249 Coalition for Climate Resilient Investment mainly adaptation human settlements     https://resilientinvestment.org/ 2019 CCRI aims to create a more resilient global financial industry in which key incentive structures foster an accurate pricing of physical climate risks (PCRs) in investment decision-making, resulting in more resilient economies and communities across the world. As such, our mission is to mobilise the global private financial industry, in partnership with key public stakeholders, to develop practical solutions for the pricing of PCRs in to investment decision-making. We are focused on deliverables designed to address key challenges in the investment value chain, including: An investment prioritisation tool for national decision-making;A pricing model for the interpretation of climate data in cash flow modelling practices;A taxonomy for the development of resilience bonds. CCRI aims to advance and support:National decision-making – by facilitating an understanding of the economic and social value at risk associated to PCRs;Project valuation and investment appraisal – by providing investors with greater predictability of longer-term cash flows; Financial innovation – by identifying innovative taxonomies for financial instruments capable of guiding a more efficient allocation of capital.                 SDG explicitly mentioned       SDG explicitly mentioned                     This coalition was created to ensure that, by 2025, physical climate risks are systematically integrated into all investment decisions   [end of 2019] the Coalition will develop case studies to build the business case and identify the critical enabling environments for climate resilient infrastructure investment; [By.COP26 in 2020] analytical tools including a physical risk pricing framework and methodology to prioritise national resilient investment needs, will be developed, alongside a range of instruments to prevent capital flight from the most vulnerable regions, such as a technology transfer programmes, technical assistance facilities and/or blended finance facilities.   ["Jamaica", "United Kingdom of Great Britain and Northern Ireland (the)", "Australia", "Germany", "United States of America (the)", "France", "Canada", "Netherlands (the)", "Switzerland", "None", "Sweden", "Spain"]   [""] [United Kingdom]_ngv_gbr,[Willis Towers Watson]_bus_gbr,[Global Commission on Adaptation]_ing_nld,[World Economic Forum]_ing_che,[World Resources Institute]_ing_usa,[Egypt]_ngv_egy {"ngv": ["Jamaica"], "inv": ["Aberdeen Standard Investments", "Access Corporate Finance", "AustralianSuper", "CBRE Global Investors", "DWS", "Invesco Asset Management", "Impax Asset Management", "Legal & General Investment Manangement", "Lightsmith Group", "Macquarie Infrastructure and Real Assets", "Meridiam Infrastructure", "Schroders", "UK Environment Agency Pension Fund", "Standard Chartered Bank", "HSBC", "Lloyds Banking", "Wells Fargo"], "bus": ["Moody\u2019s Analytics", "Standard & Poor\u2019s Ratings", "Arup", "Mott Macdonald", "WSP", "Resallience (Vinci Group)", "KPMG", "McKinsey & Company", "Parker Fitzgerald (Accenture Group)", "Zurich", "Clyde & Co", "GRESB", "Systemiq", "UK Green Finance Institute", "Acclimatise", "Lobelia Earth", "OneConcern", "Jupiter Intelligence"], "ior": ["Asian Development Bank", "European Bank for Reconstruction and Development", "Green Climate Fund", "UNDP", "UNEP"], "edu": ["University of Oxford", "Imperial College London"], "ing": ["Climate Bonds Initiative", "Climate Policy Initiative", "Taskforce for Climate-related Financial Disclosures Secretariat", "World Resources Institute", "Institutional Investor Group on Climate Change", "Global Adaptation & Resilience Investment Group", "Global Water Partnership", "Investor Group on Climate Change", "The Prince\u2019s Accounting for Sustainability Project", "Global Center on Adaptation"]}