gca_themes
10 rows where sdg10 = 1 sorted by sdg9
This data as json, CSV (advanced)
Suggested facets: pol_climate, sdg1, sdg2, sdg3, sdg4, sdg5, sdg6, sdg7, sdg8, sdg9, sdg11, sdg12, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 40 | 40 | 40 | NAZCA_18_24 | Global Resilience Partnership | mainly adaptation | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
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 );