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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | ccid_0089 | The Sustainable Finance Facilities | equally adaptation & mitigation | energy | https://group.bnpparibas/en/news/bnp-paribas-sustainable-finance-facility,https://group.bnpparibas/en/news/bnp-paribas-joins-sustainable-project-budget-natural-farming-india | 2018 | (data unavailable at time of collection) | SDG explicitly mentioned | SDG explicitly mentioned | [Increas its financing in the renewable energy sector to 15 billion euros by 2020] | [Target capital funding amount of USD10 billion by 2025] | ["India"] | ["United Nations Environment Programme (UNEP)", "BNP Paribas"] | [United Nations Environment Programme (UNEP)]_ior_int,[BNP Paribas]_inv_fra,[Tropical Landscapes Finance Facility (TLFF)]_oth_int | {"ior": ["United Nations Environment Programme (UNEP)"], "inv": ["BNP Paribas"], "oth": ["Tropical Landscapes Finance Facility (TLFF)"], "sgv": ["Andhra Pradesh"]} |