variables
Data license: CC-BY
6 rows where datasetId = 5249 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145788 | cropland_per_capita | "Land used for cultivation of crops. The total of areas under ''Arable land'' and ''Permanent crops''." | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Cropland per capita", "unit": "hectares", "shortUnit": "ha", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
145787 | pasture_per_capita | "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." | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Pasture land per capita", "unit": "hectares", "shortUnit": "ha", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
145786 | agricultural_land_per_capita | Agricultural land is the sum of cropland and pastures. | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Agricultural land per capita", "unit": "hectares per capita", "shortUnit": "ha", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
145785 | agricultural_land | Agricultural land is the sum of cropland and pastures. | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Agricultural land", "unit": "hectares", "shortUnit": "ha", "includeInTable": true, "conversionFactor": 1000, "numDecimalPlaces": 0 } |
0 | 1 | |||||||||||||||||||||||||||
145784 | cropland | "Land used for cultivation of crops. The total of areas under ''Arable land'' and ''Permanent crops''." | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Cropland", "unit": "hectares", "shortUnit": "ha", "includeInTable": true, "conversionFactor": 1000, "numDecimalPlaces": 0 } |
0 | 1 | |||||||||||||||||||||||||||
145783 | pasture | "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." | 2021-02-05 11:48:11 | 2023-06-15 05:05:42 | Agricultural land use per capita (FAO, 2021) 5249 | Food and Agriculture Organization of the United Nations 17978 | { "name": "Pasture land", "unit": "hectares", "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");