variables
Data license: CC-BY
18 rows where sourceId = 2854 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, display, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8771 | Agricultural land per capita (HYDE (2017)) | hectares per person | Agricultural land per person, in hectares. | 2017-08-24 17:42:01 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8770 | Grazing land per capita (HYDE (2017)) | hectares per person | Grazing land per person, in hectares. | 2017-08-24 17:42:01 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8769 | Cropland per capita (HYDE (2017)) | hectares per person | Cropland per person, in hectares. | 2017-08-24 17:42:01 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | ha | { "shortUnit": "hectares", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||
8768 | Agricultural area (crops & grazing) (HYDE (2017)) | hectares | Agricultural area in hectares. | 2017-08-24 17:42:01 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8767 | Rural Population (HYDE (2017)) | Number of people in the rural population. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | |||||||||||||||||||||||||
8766 | Urban population (HYDE (2017)) | Number of people in the urban population. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | |||||||||||||||||||||||||
8765 | Total population (HYDE (2017)) | Number of people in the population. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | |||||||||||||||||||||||||
8764 | Built-up Area (HYDE (2017)) | hectares | Built-up area measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | ha | {} |
0 | 1 | |||||||||||||||||||||||
8763 | Total Rice Area (HYDE (2017)) | hectares | Total rice area measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8762 | Rainfed Non-rice Crops (HYDE (2017)) | hectares | Rainfed non-rice crops measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8761 | Total Rainfed Area (HYDE (2017)) | hectares | Total rainfed area measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8760 | Rangeland (HYDE (2017)) | hectares | 'Rangeland' refers to "Grazing land with an aridity index > 0.5, assumed to be less or not managed", measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8759 | Pastureland (HYDE (2017)) | hectares | 'Pastureland' refers to "Grazing land with an aridity index > 0.5, assumed to be more intensively managed", measured in hectares. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8758 | Irrigated Rice (HYDE (2017)) | hectares | Hectares of irrigated rice. | 2017-08-24 14:21:08 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8757 | Irrigated Non-rice Crops (HYDE (2017)) | hectares | Irrigated non-rice crops measured in hectares. | 2017-08-24 14:21:07 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8756 | Total Irrigated Area (HYDE (2017)) | hectares | Measured in hectares. | 2017-08-24 14:21:07 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | {} |
0 | 1 | ||||||||||||||||||||||||
8755 | Grazing (HYDE (2017)) | hectares | 'Grazing' refers to the FAO category titled 'permanent meadows and pastures', measured in hectares. | 2017-08-24 14:21:07 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | ha | {} |
0 | 1 | |||||||||||||||||||||||
8754 | Cropland (HYDE (2017)) | hectares | 'Cropland' refers to the same FAO category titled 'arable land and permanent crops', measured in hectares. | 2017-08-24 14:21:07 | 2023-06-15 05:05:42 | global by region | -10000-2016 | Land Use Data - HYDE (2017) 694 | Land Use Data - HYDE (2017) 2854 | ha | {} |
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");