variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

5 rows where datasetId = 6169 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, timespan, 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
789444 Total number of eggs produced in the UK eggs The total number of eggs is calculated as the sum of eggs from barns, cages (including enriched cages), and free-range eggs (both non-organic and organic). Since there is no data for organic eggs prior to 2006, and given that they represented a small fraction of the total, we assume there were no organic eggs until that year. 2023-08-07 07:47:35 2024-07-08 16:40:24     1996-2022 UK egg statistics (Defra, 2023) 6169     
{
    "unit": "eggs"
}
 0     number_of_eggs_all grapher/animal_welfare/2023-08-01/uk_egg_statistics/uk_egg_statistics#number_of_eggs_all   2                 
[]
   
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    }
]
     float 
[]
 c1b8e36ce1596043a6115683ba2cddf5 6558c402dcc7102b4da0cd28842565f8
788661 Number of eggs from hens in organic, free-range farms eggs   2023-08-02 15:32:03 2024-07-08 16:40:24     2006-2022 UK egg statistics (Defra, 2023) 6169     
{
    "unit": "eggs",
    "numDecimalPlaces": 0
}
 0     number_of_eggs_from_organic_free_range_farms grapher/animal_welfare/2023-08-01/uk_egg_statistics/uk_egg_statistics#number_of_eggs_from_organic_free_range_farms   2                 
[]
   
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    }
]
     float 
[]
 f72126ff6a858aceb68433dfde6476b6 864df4540dc796a0ab4fa36c597d9791
788660 Number of eggs from hens in non-organic, free-range farms eggs   2023-08-02 15:32:02 2024-07-08 16:40:24     1996-2022 UK egg statistics (Defra, 2023) 6169     
{
    "unit": "eggs",
    "numDecimalPlaces": 0
}
 0     number_of_eggs_from_non_organic_free_range_farms grapher/animal_welfare/2023-08-01/uk_egg_statistics/uk_egg_statistics#number_of_eggs_from_non_organic_free_range_farms   2                 
[]
   
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    }
]
     float 
[]
 1e5cc11e8433a55495e164d8ee80d41f af002f5f115bb722b1b1ae1cd3c6ea94
788659 Number of eggs from hens in (enriched) cages eggs   2023-08-02 15:32:02 2024-07-08 16:40:24     1996-2022 UK egg statistics (Defra, 2023) 6169     
{
    "unit": "eggs",
    "numDecimalPlaces": 0
}
 0     number_of_eggs_from_enriched_cages grapher/animal_welfare/2023-08-01/uk_egg_statistics/uk_egg_statistics#number_of_eggs_from_enriched_cages   2                 
[]
   
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    }
]
     float 
[]
 e00dda21bf95a98b032ad821b32c8c5a 7b96957349f827094c7fb68171a7da99
788658 Number of eggs from hens in barns eggs   2023-08-02 15:32:01 2024-07-08 16:40:24     1996-2022 UK egg statistics (Defra, 2023) 6169     
{
    "unit": "eggs",
    "numDecimalPlaces": 0
}
 0     number_of_eggs_from_barns grapher/animal_welfare/2023-08-01/uk_egg_statistics/uk_egg_statistics#number_of_eggs_from_barns   2                 
[]
   
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    }
]
     float 
[]
 49b02702838b85889d5ef5fd314d3008 077aaff6626404e9e1a175767d66519a

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");