variables
Data license: CC-BY
21 rows where datasetId = 5041 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137849 | Live Animals - Turkeys - 1079 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:50 | 2023-06-15 05:05:42 | QA - 1079 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137848 | Live Animals - Sheep and Goats - 1749 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:48 | 2023-06-15 05:05:42 | QA - 1749 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137847 | Live Animals - Sheep - 976 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:45 | 2023-06-15 05:05:42 | QA - 976 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137846 | Live Animals - Rodents, other - 1150 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:45 | 2023-06-15 05:05:42 | QA - 1150 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137845 | Live Animals - Rabbits and hares - 1140 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:45 | 2023-06-15 05:05:42 | QA - 1140 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137844 | Live Animals - Poultry Birds - 2029 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:42 | 2023-06-15 05:05:42 | QA - 2029 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | { "unit": "birds", "conversionFactor": 1000 } |
0 | 1 | |||||||||||||||||||||||||
137843 | Live Animals - Pigs - 1034 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:40 | 2023-06-15 05:05:42 | QA - 1034 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | { "unit": "pigs" } |
0 | 1 | |||||||||||||||||||||||||
137842 | Live Animals - Pigeons, other birds - 1083 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:39 | 2023-06-15 05:05:42 | QA - 1083 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137841 | Live Animals - Mules - 1110 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:38 | 2023-06-15 05:05:42 | QA - 1110 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137840 | Live Animals - Horses - 1096 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:37 | 2023-06-15 05:05:42 | QA - 1096 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137839 | Live Animals - Goats - 1016 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:35 | 2023-06-15 05:05:42 | QA - 1016 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137838 | Live Animals - Geese and guinea fowls - 1072 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:35 | 2023-06-15 05:05:42 | QA - 1072 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137837 | Live Animals - Ducks - 1068 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:34 | 2023-06-15 05:05:42 | QA - 1068 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137836 | Live Animals - Chickens - 1057 - Stocks - 5112 - 1000 Head | 1000 Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:32 | 2023-06-15 05:05:42 | QA - 1057 - 5112 - 1000 Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137835 | Live Animals - Cattle and Buffaloes - 1746 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:29 | 2023-06-15 05:05:42 | QA - 1746 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137834 | Live Animals - Cattle - 866 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:27 | 2023-06-15 05:05:42 | QA - 866 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137833 | Live Animals - Camels - 1126 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:26 | 2023-06-15 05:05:42 | QA - 1126 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137832 | Live Animals - Camelids, other - 1157 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:26 | 2023-06-15 05:05:42 | QA - 1157 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137831 | Live Animals - Buffaloes - 946 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:25 | 2023-06-15 05:05:42 | QA - 946 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137830 | Live Animals - Beehives - 1181 - Stocks - 5114 - No | No | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:24 | 2023-06-15 05:05:42 | QA - 1181 - 5114 - No | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
0 | 1 | |||||||||||||||||||||||||
137829 | Live Animals - Asses - 1107 - Stocks - 5111 - Head | Head | The dataset contains the following commodities and commodity aggregates thereof : Animals live n.e.s.; Asses; Beehives; Buffaloes; Camelids, other; Camels; Cattle; Chickens; Ducks; Geese and guinea fowls; Goats; Horses; Mules; Pigeons, other birds; Pigs; Rabbits and hares; Rodents, other; Sheep; Turkeys. | 2020-02-14 02:55:22 | 2023-06-15 05:05:42 | QA - 1107 - 5111 - Head | Production: Live Animals 5041 | Production: Live Animals 17772 | {} |
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");