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
224	ccid_0300	MedFish4ever	nature-based solutions	oceans and coastal zones			https://oceanconference.un.org/commitments/?id=18708	2017	The EU, together with its Mediterranean partners, has endorsed MedFish4Ever Declaration, which set out a detailed work programme for the next 10 years. In particular, the EU, as a signatory to the Declaration, commits (1) by 2020 to ensure that all key Mediterranean stocks are subject to adequate data collection and scientifically assessed on a regular basis; (2) to establish multi-annual management plans for all key fisheries; (3) to eliminate illegal fishing and to that end, ensure that, by 2020 all States have the legal framework and the necessary human and technical capabilities to meet their control and inspection responsibilities; (4) to support sustainable small-scale fisheries and aquaculture by, inter alia, streamlining funding schemes for local projects related to low-impact techniques and fishing gear, social inclusion and the contribution of fishermen to environmental protection		SDG explicitly mentioned										SDG explicitly mentioned	SDG explicitly mentioned	SDG explicitly mentioned	SDG explicitly mentioned								At least 10% of the Mediterranean sea effectively protected by 2020			100% of key Mediterranean stocks are subjest to adequate data collection by 2020; 100% of the key fisheries should have a multi-annual managment plan by 2020		["Albania", "Algeria", "Bosnia and Herzegovina", "Croatia", "Cyprus", "France", "Greece", "Italy", "Malta", "Monaco", "Montenegro", "Morocco", "Slovenia", "Spain", "Tunisia", "Turkey"]		[""]	[European Union]_ngv_int,[General Fisheries Commission for the Mediterranean]_ngv_int	{"ngv": ["Albania", "Algeria", "Bosnia and Herzegovina", "Croatia", "Cyprus", "France", "Greece", "Italy", "Malta", "Monaco", "Montenegro", "Morocco", "Slovenia", "Spain", "Tunisia", "Turkey"]}
226	ccid_0302	Asian Seafood Improvement Collaborative	nature-based solutions	oceans and coastal zones			http://www.asicollaborative.org/	2013	THE ASIAN SEAFOOD IMPROVEMENT COLLABORATIVE IS A GROUP OF INTERNATIONAL STAKEHOLDERS DEDICATED TO DEVELOPING CREATIVE STRATEGIES FOR IMPROVING THE ASIAN SEAFOOD INDUSTRY. ASIC is a burgeoning regional collaboration between private sector stakeholders from Indonesia, Myanmar, Philippines, Thailand, and Vietnam who have come together to tackle social and environmental sustainability challenges facing the Asian seafood industry. ASIC stakeholders represent various elements of the Asian seafood industry including producer organizations, processors, environmental NGOs, and local certification bodies. These ASIC participants work in conjunction with export market stakeholders, including NGOs, buyers, and certification bodies, to build innovative tools designed to foster improvement for both shrimp aquaculture and fisheries in the region.												SDG explicitly mentioned		SDG explicitly mentioned														["Myanmar", "Indonesia", "Viet Nam", "Thailand", "Philippines (the)"]		["Oxfam", "Sweden"]	[ICAFIS Vietnam]_dng_vnm,[Socsksargen fishing]_bus_phl,[PT Alter Trade]_bus_idn,[Myanmar Sustainable Aquaculture Programme]_dng_mmr,[Tambuyog Development Center]_dng_phl,[Chicken of the Sea]_bus_tha,[Vietnam Seaculture Association]_bus_vnm,[MDPI]_dng_idn	{"edu": ["Kasetsart University"], "bus": ["Vietnam Association of Seafood Export Processors", "Aceh Aquaculture Cooperative", "Pt Atina", "Thai Shrimp Association", "Thai Union", "Vietnam Sea culture Association", "Ecohub Global", "Fairagora", "Blue Apron"], "ing": ["Wetlands International", "Monterey Bay Aquarium Seafood Watch", "Liberty Asia", "Fishmatter", "Solidaridad", "Rare", "Oxfam"], "dng": ["Myanmar Shrimp Association"]}
227	ccid_0303	Partnership with African Coastal States to Eradicate IUU Fishing in their Sovereign Waters by 2020	nature-based solutions	oceans and coastal zones			https://oceanconference.un.org/commitments/?id=17190	2016	The objective of our IUU Task Force campaigns, such as Operation Sola Stella (Liberia, 2017) and Operation Albacore (Gabon, So Tom and Principe, 2016), is to partner with Coastal States in Africa to put an end to the unchecked poaching and IUU fishing that takes place in the Exclusive Economic Zone waters of these sovereign nations.														SDG explicitly mentioned														["Liberia", "Gabon", "Benin", "Sao Tome and Principe", "Tanzania, United Republic of"]		[""]	[Sea Sheperd Global]_ing_nld	{"ngv": ["Liberian Ministry of National Defense", "Gabonse Ministry of Defense", "ANPA Gabon", "Sao Tome and Principe Ministry of Defense ", "Benin Ministry of Fisheries ", "Tanzania"], "dng": ["Eco-Benin"]}