testToSQLite

This data as json, CSV

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
127	ccid_0165	Resilient Cities Acceleration Initiative	equally adaptation & mitigation	human settlements			https://www.wri.org/our-work/project/global-commission-adaptation/action-tracks/cities,http://climateinitiativesplatform.org/index.php/100_Resilient_Cities	2018	The overarching goal of this Action Track is to develop a defragmented offer by bringing together key city networks and institutions in the urban adaptation space to leverage their overlapping geographies, complementary skills, city-national-global relationships & partnerships, datasets and knowledge to scale up and accelerate action on urban adaptation. The three pathways to action identified by this alliance are:Setup a PLATFORM to enhance coordination and build synergies across urban resilience partners, and adaptation programs to enhance urban adaptation in national plans and policymaking (NAPs and NDCs) and broker subnational financing agreements and access to private sector capital.Build transformative CAPACITY for adaptation planning in 500 cities and develop a knowledge and learning network with 40 universities. This capacity building initiative will support peer to peer learning, focused on both practice building and knowledge development, by providing and applying tools, such as adaptation academies, documenting and disseminating best practices, building centers for applied research, and co-learning partnerships between cities, universities and community organizations.Accelerate and scale SOLUTIONS for urban adaptation with a focus on Nature-based Solutions, Urban Water Resilience Actions, Floating Urban Development options, and Inclusive Climate Resilient infrastructure improvements for the urban poor living in informal settlements.											SDG explicitly mentioned		SDG explicitly mentioned		SDG explicitly mentioned		SDG explicitly mentioned					[Assist 500 cities in implementing comprehensive climate resilience strategies by 2030,Assist 5,000 cities in becoming more water and climate resilient through a city-to-city learning program by 2030]			[Serving the first 50 cities in a programmatic way requires $10 million]	[By 2030, 60 cities enhance, invest, and implement 100-300 nature-based solutions projects to address climate risks and improve the health and wellbeing of urban residents and the biodiversity of cities]		["None"]		["World Resources Institute (WRI)", "UN Habitat", "Ministry of Foreign Affairs of the Netherlands", "Ministry of Infrastructure and Environment of the Netherlands", "Deltares"]	[World Resources Institute (WRI)]_ing_usa,[Global Center for Adaptation]_dng_nld,[Global Resilient Cities Network (GRCN)]_sgv_int,[C40]_sgv_int,[Deltares]_edu_nld	{"edu": ["Collaborative for Urban Resilience Effectiveness (CURE)", "Global Network for Advanced Management (GNAM)", "Least Developed Countries Universities Consortium on Climate Change (LUCCC)", "International Centre for Climate Change & Development (ICCCAD)"]}