gca_themes

59 rows where sdg7 = 0 sorted by ini_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pol_climate, sdg1, sdg2, sdg3, sdg4, sdg5, sdg6, sdg8, sdg9, sdg10, sdg11, sdg12, sdg13, sdg14, sdg15, sdg16, sdg17

sdg7 ✖

Link rowid rowid ini_id ini_name ▼ pol_climate sdg1 sdg2 sdg3 sdg4 sdg5 sdg6 sdg7 sdg8 sdg9 sdg10 sdg11 sdg12 sdg13 sdg14 sdg15 sdg16 sdg17
85 85 85 OPS_UPT_1 "Pacific Initiative on Biodiversity Resilience and Climate Change " 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1
36 36 36 CAS19_04 Africa Adaptation Initiative mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 1
49 49 49 NAZCA_OPS_6 African Women in Agricultural Research and Development - One Planet Fellowship mainly adaptation 0 1 0 1 1 0 0 0 0 0 0 1 1 0 1 0 1
69 69 69 SDG14_12 Asian Seafood Improvement Collaborative nature-based solutions 1 1 0 0 1 0 0 1 0 1 0 1 1 1 0 0 1
31 31 31 NCI_03 BioCarbon Fund Initiative for Sustainable Forest Landscapes mainly mitigation 0 1 0 0 1 0 0 0 0 0 1 0 1 0 1 0 1
91 91 91 SDG14_7 Blue Carbon Code of Conduct "equally adaptation & mitigation 0 0 0 0 0 1 0 0 0 0 1 0 0 1 1 0 1
86 86 86 YRB_UPT_3 Blue Carbon Initiaitive equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1
89 89 89 SDG14_4 Blue Forests Project "mainly mitigation 0 1 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0
16 16 16 NAZCA_18_32 Bonn Challenge mainly mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1
5 5 5 NCI_20_01 CO2­ Performance Ladder mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0
84 84 84 SIDS_12 Caribbean Challenge Initiative Nature-Based Solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1
32 32 32 NCI_01 Clean Climate & Air Coalition mainly mitigation 0 1 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1
47 47 47 NAZCA_18_26 Climate Risk Early Warning Systems mainly adaptation 1 1 1 0 1 1 0 0 0 0 1 0 1 0 0 1 1
37 37 37 CAS19_16 Coalition for Climate Resilient Investment mainly adaptation 0 0 0 0 0 0 0 1 1 0 1 0 1 0 0 0 1
55 55 55 SIDS_7 Coconut Industry Development for the Caribbean mainly adaptation 0 1 0 0 0 0 0 0 0 0 0 1 1 0 1 0 1
9 9 9 NAZCA_18_41 Collaborative Climate Action Across the Air Transport World mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1
53 53 53 OPS_UPT_2 DeSIRA - Financing for agricultural research to help low-income farmers adapt to climate change mainly adaptation 1 1 0 1 0 0 0 1 0 0 0 0 1 0 1 0 0
64 64 64 CAS19_11 Early Warning Early Action mainly adaptation 1 1 1 0 0 0 0 0 0 1 0 0 1 0 0 0 1
81 81 81 YRB_UPT_1 Earth For Life Initiative equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0
52 52 52 SIDS_6 Enhancing global ocean acidification monitoring and research mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
68 68 68 NAZCA_CAPP_4 Fiji Water Resilience mainly adaptation 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 1
62 62 62 NAZCA_18_22 Food Security Climate Resilience Facility mainly adaptation 1 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1
74 74 74 NY14_AG_18 GFAR: Empowering Farmers Organisations on Climate Change Through Better Foresight "0" 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
59 59 59 LPA_RE_05 Global Facility for Disaster Reduction and Recovery mainly adaptation 1 1 1 1 1 0 0 0 1 0 1 0 1 1 1 0 0
72 72 72 SDG14_1 Goal 14 implementation for the protection of Mediterranean Sea's whales and dolphins mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0
30 30 30 NCI_05 Governors' Climate and Forests Task Force mainly mitigation 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 1
20 20 20 NCI_20_02 Green Building Initiative mainly mitigation 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0
60 60 60 OPS_UPT_3 Helping Farmers Cope with Climate Change mainly adaptation 1 1 1 0 0 0 0 0 0 0 0 0 1 0 1 0 0
43 43 43 NAZCA_18_23 InsuResilience Global Partnership mainly adaptation 1 0 0 0 1 0 0 1 1 0 0 0 1 0 0 0 1
38 38 38 CS18_09 International Alliance to Combat Ocean Acidification mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
88 88 88 SDG14_2 International Waste Platform equally adaptation & mitigation 0 0 1 0 0 1 0 0 0 0 0 1 0 1 1 0 1
58 58 58 CAS19_12 Just Transition Initiative mainly adaptation 1 0 1 0 1 0 0 1 0 1 1 1 1 0 0 1 1
46 46 46 CAS19_13 LDC Initiative for Effective Adaptation and Resilience mainly adaptation 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 1 1
26 26 26 NCI_06 Lean and Green mainly mitigation 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0
76 76 76 OPS_UPT_4 Make Our Planet Great Again equally adaptation & mitigation 1 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0
66 66 66 SDG14_10 MedFish4ever nature-based solutions 0 1 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0
41 41 41 NAZCA_18_12 Megacities Alliance for Water and Climate mainly adaptation 0 0 0 0 1 1 0 0 0 0 1 0 1 0 0 0 1
73 73 73 NY14_AG_09 National Agricultural Resilience Framework mainly adaptation 1 1 1 0 0 0 0 1 0 0 1 0 1 0 1 1 0
75 75 75 SIDS_4 Norway-Pacific Joint Chair of Oceans and Climate Change equally adaptation & mitigation 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 1 1
2 2 2 NAZCA_20_Adhoc14 Ocean Risk and Resilience Action Alliance mainly adaptation 1 0 0 0 1 0 0 0 1 0 1 0 1 1 0 0 1
82 82 82 SIDS_10 Oceania 21 Nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
51 51 51 SIDS_3 Pacific plastic pollution: A system for regional grassrots mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0
71 71 71 SDG14_13 Partnership with African Coastal States to Eradicate IUU Fishing in their Sovereign Waters by 2020 nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
44 44 44 NAZCA_18_25 R4 Rural Resilience Initiative mainly adaptation 1 1 0 0 1 1 0 0 1 0 0 0 1 0 0 0 1
90 90 90 SDG14_3 Raise Awareness about the Ocean and Take Action equally adaptation & mitigation 1 0 0 1 1 1 0 0 0 0 0 1 1 1 0 1 0
65 65 65 SDG14_5 Reducing ship strikes to vulnerable Whales Wildlife conservancy 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0
15 15 15 NAZCA_18_16 Save Food Initiative mainly mitigation 1 1 0 0 0 0 0 0 1 1 0 1 1 0 1 0 1
22 22 22 NAZCA_18_71 Science-based Targets mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0
77 77 77 SIDS_5 Small Island States (SIDS) Blue Guardians: Partnership to Protecting Oceans and Climate-resilient Bl equally adaptation & mitigation 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 1 1
56 56 56 NAZCA_18_27 Smart Risk Investing mainly adaptation 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0
70 70 70 CAS19_18 Supporting smallholder farmers mainly adaptation 1 1 0 0 0 0 0 1 1 0 0 0 1 0 1 0 1
1 1 1 NCI_20_03 Sustainable Building and Climate Initiative mainly mitigation 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0
61 61 61 NAZCA_18_19 The 1 in 100 initiative mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1
78 78 78 SIDS_8 The 10x20 Initiative Nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1
11 11 11 NAZCA_18_73 The New York Declaration on Forests mainly mitigation 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 1
92 92 92 SDG14_16 The Ocean Cleanup Marine pollution 0 0 0 0 0 1 0 0 0 0 0 1 1 1 0 0 1
45 45 45 NAZCA_COP23ANN_1 The Ocean Pathway equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
83 83 83 SIDS_11 Waste Management and Sanitation Improvement (WMI) Programme equally adaptation & mitigation 0 0 0 0 0 1 0 0 0 0 0 1 1 1 0 0 1
42 42 42 NAZCA_18_2 West Africa Coastal Areas Management Program mainly adaptation 0 0 0 0 0 0 0 0 0 0 1 0 1 1 1 1 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "gca_themes" (
	"rowid" VARCHAR(100) NULL,
	"ini_id" VARCHAR(100) NULL,
	"ini_name" VARCHAR(100) NULL,
	"pol_climate" VARCHAR(100) NULL,
	"sdg1" TINYINT NULL,
	"sdg2" TINYINT NULL,
	"sdg3" TINYINT NULL,
	"sdg4" TINYINT NULL,
	"sdg5" TINYINT NULL,
	"sdg6" TINYINT NULL,
	"sdg7" TINYINT NULL,
	"sdg8" TINYINT NULL,
	"sdg9" TINYINT NULL,
	"sdg10" TINYINT NULL,
	"sdg11" TINYINT NULL,
	"sdg12" TINYINT NULL,
	"sdg13" TINYINT NULL,
	"sdg14" TINYINT NULL,
	"sdg15" TINYINT NULL,
	"sdg16" TINYINT NULL,
	"sdg17" TINYINT NULL
);