gca_themes
31 rows where sdg12 = 1
This data as json, CSV (advanced)
Suggested facets: pol_climate, sdg1, sdg2, sdg3, sdg4, sdg5, sdg6, sdg7, sdg8, sdg9, sdg10, sdg11, sdg13, sdg14, sdg15, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 19 | 19 | 19 | NAZCA_18_81 | Global Covenant of Mayors for Climate & Energy | mainly adaptation | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
| 21 | 21 | 21 | NCI_07 | Responsible Care | mainly mitigation | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 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 |
| 23 | 23 | 23 | NAZCA_TOM_4 | European Technology and Innovation Platform on Wind Energy | mainly mitigation | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
| 24 | 24 | 24 | NAZCA_TOM_5 | European Technology and Innovation Platform for Photovoltaics | mainly mitigation | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
| 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 |
| 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 |
| 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 |
| 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 |
| 39 | 39 | 39 | NAZCA_18_21 | "Paris Pact on water and adaptation to climate change in the basins of rivers | lakes and aquifers" | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 |
| 4 | 4 | 4 | CIP_20_02 | Transformative Actions Program | equally adaptation & mitigation | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 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 |
| 50 | 50 | 50 | SIDS_2 | The World Team Project: Sustainable Solutions Oceans Opportunities & Small Island States | mainly adaptation | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 8 | 8 | 8 | NCI_04 | C40 Cities Climate Leadership Group | equally adaptation & mitigation | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 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 |
| 87 | 87 | 87 | YRB_UPT_16 | Alliances for Climate Action | equally adaptation & mitigation | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 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 |
| 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 |
| 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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );