variables
Data license: CC-BY
15 rows where datasetId = 5201 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145375 | Forest cover | Share of land area that is covered by forest. | 2020-11-04 21:02:59 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of land area covered by forest",
"unit": "%",
"shortUnit": "%",
"includeInTable": true,
"numDecimalPlaces": 1
} |
0 | 1 | |||||||||||||||||||||||||||
| 145193 | Share of regional forest area | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of regional forest area",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145192 | Share of regional deforestation | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of regional deforestation",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145189 | Share of global forest expansion | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of annual global forest expansion",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145188 | Share of global forest area | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of global forest area",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145187 | Share of global deforestation | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Share of global deforestation",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145185 | Annual net change in forest area | Net change in forest area measures forest expansion (either through afforestation or natural expansion) minus deforestation. | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual change in forest area",
"unit": "hectares per year",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145184 | Natural forest expansion | Natural forest expansion is the expansion of forests through natural succession on land that, until then, was under another land use (e.g. forest succession on land previously used for agriculture). | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual natural forest expansion",
"unit": "hectares per year",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000
} |
0 | 1 | |||||||||||||||||||||||||||
| 145183 | Forest expansion | Forest expansion is the sum of afforestation (the establishment of forest through planting and/or deliberate seeding) and natural forest expansion (expansion of forests through natural succession on land that, until then, was under another land use). | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual forest expansion",
"unit": "hectares per year",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000
} |
0 | 1 | |||||||||||||||||||||||||||
| 145182 | Forest area | A forest is defined as Land spanning more than 0.5 hectares with trees higher than 5 meters and a canopy cover of more than 10 percent, or trees able to reach these thresholds in situ. It does not include land that is predominantly under agricultural or urban land use. Forest is determined both by the presence of trees and the absence of other predominant land uses. The trees should be able to reach a minimum height of 5 meters in situ. | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Forest area",
"unit": "hectares",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145181 | Expansion as share of forest area | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual forest expansion as a share of forest area",
"unit": "% of forest area",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145180 | Deforestation as share of forest area | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual deforestation as a share of forest area",
"unit": "% of forest area",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145179 | Deforestation | The conversion of forest to other land use or the long-term reduction of the tree canopy cover below the minimum 10 percent threshold. Deforestation implies the long-term or permanent loss of forest cover and implies transformation into another land use. Such a loss can only be caused and maintained by a continued human-induced or natural perturbation. | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual deforestation rate",
"unit": "hectares per year",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145178 | Conversion as share of forest area | Annual forest change measures the net change in forests, given as afforestation minus deforestation. | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual forest change as a share of forest area",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 145177 | Afforestation | Afforestation is the establishment of forest through planting and/or deliberate seeding on land that, until then, was not classified as forest. It implies a transformation of land use from non-forest to forest. | 2020-10-20 09:08:41 | 2023-06-15 05:05:42 | Forest land, deforestation and change (FAO, 2020) 5201 | UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 17931 | {
"name": "Annual afforestation rate",
"unit": "hectares per year",
"shortUnit": "ha",
"includeInTable": true,
"conversionFactor": 1000,
"numDecimalPlaces": 0
} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");