variables
Data license: CC-BY
14 rows where datasetId = 5694 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, timespan, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 474359 | Naturally regenerating forest | 00006717 || Share in Forest land | 007210 || percent | percent | Forest predominantly composed of trees established through natural regeneration. Explanatory notes 1. Includes forests for which it is not possible to distinguish whether planted or naturally regenerated. 2. Includes forests with a mix of naturally regenerated native tree species and planted/seeded trees, and where the naturally regenerated trees are expected to constitute the major part of the growing stock at stand maturity. 3. Includes coppice from trees originally established through natural regeneration. 4. Includes naturally regenerated trees of introduced species. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1990-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Naturally regenerating forest - Share in Forest land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
naturally_regenerating_forest__00006717__share_in_forest_land__007210__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#naturally_regenerating_forest__00006717__share_in_forest_land__007210__percent | 1 | |||||||||||||||||||||
| 474358 | Planted Forest | 00006716 || Share in Forest land | 007210 || percent | percent | Forest predominantly composed of trees established through planting and/or deliberate seeding. Explanatory notes 1. In this context, predominantly means that the planted/seeded trees are expected to constitute more than 50 percent of the growing stock at maturity. 2. Includes coppice from trees that were originally planted or seeded. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1990-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Planted Forest - Share in Forest land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
planted_forest__00006716__share_in_forest_land__007210__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#planted_forest__00006716__share_in_forest_land__007210__percent | 1 | |||||||||||||||||||||
| 474357 | Land under perm. meadows and pastures | 00006655 || Share in Agricultural land | 007208 || percent | percent | Land used permanently (five years or more) to grow herbaceous forage crops through cultivation or naturally (wild prairie or grazing land). Permanent meadows and pastures on which trees and shrubs are grown should be recorded under this heading only if the growing of forage crops is the most important use of the area. Measures may be taken to keep or increase productivity of the land (i.e., use of fertilizers, mowing or systematic grazing by domestic animals.) This class includes: • Grazing in wooded areas (agroforestry areas, for example) • Grazing in shrubby zones (heath, maquis, garigue) • Grassland in the plain or low mountain areas used for grazing: land crossed during transhumance where the animals spend a part of the year (approximately 100 days) without returning to the holding in the evening: mountain and subalpine meadows and similar; and steppes and dry meadows used for pasture. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Land under perm. meadows and pastures - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
land_under_perm__meadows_and_pastures__00006655__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#land_under_perm__meadows_and_pastures__00006655__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474356 | Land under permanent crops | 00006650 || Share in Agricultural land | 007208 || percent | percent | Land cultivated with long-term crops which do not have to be replanted for several years (such as cocoa and coffee), land under trees and shrubs producing flowers (such as roses and jasmine), and nurseries (except those for forest trees, which should be classified under "Forestry"). Permanent meadows and pastures are excluded from land under permanent crops. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Land under permanent crops - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
land_under_permanent_crops__00006650__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#land_under_permanent_crops__00006650__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474355 | Land area equipped for irrigation | 00006690 || Share in Cropland | 007252 || percent | percent | Land area equipped with irrigation infrastructure and equipment to provide water to crops, which are in working order. The equipment does not have to be used during the reference year. The area equipped for irrigation covers areas equipped for fully controlled irrigation by any of the methods of surface, sprinkler or localized irrigation. It also includes areas under partially controlled irrigation methods of spate irrigation (controlling flood waters to water crops), equipped wetlands and inland valley bottoms and equipped flood recession. It excludes manual watering of plants using buckets, watering cans or other devices. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Land area equipped for irrigation - Share in Cropland (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
land_area_equipped_for_irrigation__00006690__share_in_cropland__007252__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#land_area_equipped_for_irrigation__00006690__share_in_cropland__007252__percent | 1 | |||||||||||||||||||||
| 474354 | Arable land | 00006621 || Share in Agricultural land | 007208 || percent | percent | The total of areas under temporary crops, temporary meadows and pastures, and land with temporary fallow. Arable land does not include land that is potentially cultivable but is not normally cultivated. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Arable land - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
arable_land__00006621__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#arable_land__00006621__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474353 | Cropland | 00006620 || Share in Land area | 007209 || percent | percent | Land used for cultivation of crops. The total of areas under ''Arable land'' and ''Permanent crops''. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Cropland - Share in Land area (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
cropland__00006620__share_in_land_area__007209__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#cropland__00006620__share_in_land_area__007209__percent | 1 | |||||||||||||||||||||
| 474352 | Land under perm. meadows and pastures | 00006655 || Share in Land area | 007209 || percent | percent | Land used permanently (five years or more) to grow herbaceous forage crops through cultivation or naturally (wild prairie or grazing land). Permanent meadows and pastures on which trees and shrubs are grown should be recorded under this heading only if the growing of forage crops is the most important use of the area. Measures may be taken to keep or increase productivity of the land (i.e., use of fertilizers, mowing or systematic grazing by domestic animals.) This class includes: • Grazing in wooded areas (agroforestry areas, for example) • Grazing in shrubby zones (heath, maquis, garigue) • Grassland in the plain or low mountain areas used for grazing: land crossed during transhumance where the animals spend a part of the year (approximately 100 days) without returning to the holding in the evening: mountain and subalpine meadows and similar; and steppes and dry meadows used for pasture. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Land under perm. meadows and pastures - Share in Land area (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
land_under_perm__meadows_and_pastures__00006655__share_in_land_area__007209__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#land_under_perm__meadows_and_pastures__00006655__share_in_land_area__007209__percent | 1 | |||||||||||||||||||||
| 474351 | Forest land | 00006646 || Share in Land area | 007209 || percent | percent | Land spanning more than 0.5 hectares with trees higher than 5 metres and a canopy cover of more than 10 per cent, or trees able to reach these thresholds in situ. Excludes land that is predominantly under agricultural or urban land use. Explanatory notes: • Forest land is determined both by the presence of trees and by the absence of other predominant land uses. The trees should be able to reach a minimum height of 5 metres in situ • Includes areas with young trees that have not yet reached but that are expected to reach a canopy cover of 10 per cent and tree height of 5 metres. It also includes areas that are temporarily unstocked owing to clear-cutting as part of a forest management practice or natural disasters, and that are expected to be regenerated within five years. Local conditions may, in exceptional cases, justify the use of a longer time frame • Includes forest roads, firebreaks and other small open areas • May include forest land in national parks, nature reserves and other protected areas, such as those of specific environmental, scientific, historical, cultural or spiritual interest • Includes windbreaks, shelter belts and corridors of trees with an area of more than 0.5 hectares and width of more than 20 metres • Includes abandoned shifting cultivation land with a regeneration of trees that have, or is expected to reach, a canopy cover of 10 per cent and tree height of 5 metres • Includes areas with mangroves in tidal zones, regardless of whether this area is classified as land area or not • Includes areas with bamboo and palms provided that land use, height and canopy cover criteria are met • Some agroforestry systems such as the taungya system, where crops are grown only during the first years of the forest rotation should be classified as forest • Excludes: tree stands in agricultural production systems, such as fruit-tree plantations (→Permanent crops), oil palm plantations, rubber and Christmas trees (→Permanent crops) and agroforestry systems when crops are grown under tree co… | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1990-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Forest land - Share in Land area (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
forest_land__00006646__share_in_land_area__007209__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#forest_land__00006646__share_in_land_area__007209__percent | 1 | |||||||||||||||||||||
| 474350 | Land area equipped for irrigation | 00006690 || Share in Agricultural land | 007208 || percent | percent | Land area equipped with irrigation infrastructure and equipment to provide water to crops, which are in working order. The equipment does not have to be used during the reference year. The area equipped for irrigation covers areas equipped for fully controlled irrigation by any of the methods of surface, sprinkler or localized irrigation. It also includes areas under partially controlled irrigation methods of spate irrigation (controlling flood waters to water crops), equipped wetlands and inland valley bottoms and equipped flood recession. It excludes manual watering of plants using buckets, watering cans or other devices. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Land area equipped for irrigation - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
land_area_equipped_for_irrigation__00006690__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#land_area_equipped_for_irrigation__00006690__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474349 | Cropland | 00006620 || Share in Agricultural land | 007208 || percent | percent | Land used for cultivation of crops. The total of areas under ''Arable land'' and ''Permanent crops''. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Cropland - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
cropland__00006620__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#cropland__00006620__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474348 | Agriculture area under organic agric. | 00006671 || Share in Agricultural land | 007208 || percent | percent | 'Agriculture'' area certified organic and/or in conversion to organic. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 2004-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Agriculture area under organic agric. - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
agriculture_area_under_organic_agric__00006671__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#agriculture_area_under_organic_agric__00006671__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474347 | Agriculture area actually irrigated | 00006611 || Share in Agricultural land | 007208 || percent | percent | Land area actually irrigated that is Agriculture. | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 2001-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Agriculture area actually irrigated - Share in Agricultural land (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
agriculture_area_actually_irrigated__00006611__share_in_agricultural_land__007208__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#agriculture_area_actually_irrigated__00006611__share_in_agricultural_land__007208__percent | 1 | |||||||||||||||||||||
| 474346 | Agricultural land | 00006610 || Share in Land area | 007209 || percent | percent | Land used for cultivation of crops and animal husbandry. The total of areas under ''Cropland'' and ''Permanent meadows and pastures.'' | 2022-08-23 17:41:49 | 2023-10-27 12:25:39 | 1961-2019 | Agri-Environmental Indicators: Land use indicators (FAO, 2022-05-17) 5694 | Food and Agriculture Organization of the United Nations 26717 | % | {
"name": "Agricultural land - Share in Land area (percent)",
"unit": "percent",
"shortUnit": "%"
} |
0 | {} |
agricultural_land__00006610__share_in_land_area__007209__percent | grapher/faostat/2022-05-17/faostat_el/faostat_el_flat#agricultural_land__00006610__share_in_land_area__007209__percent | 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");