gca_themes

30 rows where sdg17 = 0 sorted by sdg3

✎ View and edit SQL

This data as json, CSV (advanced)

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

sdg17 ✖

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
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
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
6 6 6 NAZCA_18_68 RE100 mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0
7 7 7 NAZCA_18_3 Africa Renewable Energy Initiative mainly mitigation 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0
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
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
25 25 25 NAZCA_TOM_6 SunShot Initiative mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 0 0
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
27 27 27 NAZCA_TOM_7 Wind Vision mainly mitigation 0 0 0 0 0 0 1 1 1 0 0 0 1 0 0 0 0
28 28 28 NCI_02 The 2030 Challenge mainly mitigation 0 0 0 0 0 0 1 0 1 0 1 1 1 0 0 0 0
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
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
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
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
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
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
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
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
79 79 79 OPS_UPT_5 Support for coal- and carbon-intensive regions in transition equally adaptation & mitigation 0 0 0 0 0 0 1 1 1 0 1 0 1 0 0 0 0
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
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
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
3 3 3 CIP_20_01 Navigating a Changing Climate equally adaptation & mitigation 0 0 1 0 0 0 1 0 1 0 1 0 1 1 0 0 0
29 29 29 NAZCA_18_52 Global Fuel Economy Initiative mainly mitigation 0 0 1 0 0 0 1 0 1 0 1 1 1 0 0 0 0
35 35 35 CS18_14 C40 Green & Healthy Streets mainly mitigation 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 0 0
57 57 57 NY14_AG_03 North American Climate Smart Agriculture Alliance mainly adaptation 0 1 1 0 0 1 1 1 0 0 1 1 1 0 1 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
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
67 67 67 NAZCA_CAPP_3 Climate change and health in small island developing states mainly adaptation 0 0 1 0 1 0 1 0 0 1 0 0 1 0 0 0 0
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

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
);