gca_themes
1 row where pol_climate = " Resilience and Climate Change ""
This data as json, CSV (advanced)
| 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 |
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 );