gca_themes
1 row where pol_climate = ""mainly mitigation" sorted by sdg14
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 );