testToSQLite
| rowid | X_ccid_id | Initiative_Name | Main_climate_policy_focus | Y_Thematic_area | View_initiative_on_UNFCCC_Global_Climate_Action_portal | View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform | Website | Launch_year | Description | Y_SDG1 | Y_SDG2 | Y_SDG3 | Y_SDG4 | Y_SDG5 | Y_SDG6 | Y_SDG7 | Y_SDG8 | Y_SDG9 | Y_SDG10 | Y_SDG11 | Y_SDG12 | Y_SDG13 | Y_SDG14 | Y_SDG15 | Y_SDG16 | Y_SDG17 | Targets_Emissions_reduction | Targets_Energy_efficiency | Targets_Renewable_energy | Targets_Number_people_number_countries | Targets_Number_organizations_newly_engaged | Targets_Areas_protected_improved_or_restored | Targets_in_market_shares_sales_scale | Targets_Funds_to_be_mobilized | Targets_Other | Y_Apply_10_to_Targets_Print_Targets | Y_display_country_names | Countries_where_activity_is_planned_or_ongoing | Y_Print_ActorName_only_Funders | Y_Print_ActorName_only_Lead_partners | Y_Print_ActorName_by_ActorType_Participants | Y_Participants1 | Y_Participants2 | Y_Participants3 | Y_Participants4 | Y_Participants5 | Y_Participants6 | Y_Participants7 | Y_Participants8 | ParticipantNames_National_governments | ParticipantNames_Subnational_and_regional_governments | ParticipantNames_Businesses | ParticipantNames_Investors | ParticipantNames_Domestic_NGOs | ParticipantNames_International_NGOs | ParticipantNames_Academic_educational_institutions | ParticipantNames_International_organizations | ParticipantNames_Other_organizations |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26 | ccid_0027 | Smart Risk Investing | mainly adaptation | industry | https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=57 | http://climateinitiativesplatform.org/index.php/Smart_Risk_Investing_(SRI) | https://www.icmif.org/news/insurance-industry-double-its-climate-smart-investment-end-2015 | 2014 | Increase the amount invested in smarter risk and resilience projects by the global insurance industry ten-fold to USD 420 billion by 2020 (Note: Initiative ended in 2016) | SDG explicitly mentioned | SDG explicitly mentioned | Commit to doubling the industry investment in climate-smart investments from the current $42 billion to $84 billion by end of 2015; increasing the amount invested in climate-smart investments to ten times the current amount by 2020 | ["Kosovo"] | ["International Cooperative and Mutual Insurance Federation (ICMIF)"] | [International Cooperative and Mutual Insurance Federation (ICMIF)]_inv_int,[International Insurance Society (IIS)]_inv_int | {"inv": ["International Cooperative and Mutual Insurance Federation (ICMIF)", "International Insurance Society (IIS)"]} |