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

2 rows where datasetId = 6171 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
789446 Share of eggs from hens in cages %   2023-08-07 07:47:40 2024-07-08 16:18:01     1996-2022 Share of cage-free eggs (Various sources, 2023) 6171   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_eggs_in_cages grapher/animal_welfare/2023-08-03/share_of_cage_free_eggs/share_of_cage_free_eggs#share_of_eggs_in_cages   2             Share of all eggs that are produced by laying hens in cages. This includes conventional as well as enriched cages, which are larger, furnished cages that provide slightly more space.   
[]
 For the United States, we approximate the share of eggs by the share of hens (for which there is more data available); the difference is expected to be smaller than 10%. 
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    },
    {
        "url": "https://osf.io/cmh6v",
        "name": "Creative Commons Attribution 4.0 International License"
    }
]
   
{
    "note": "For the United States, we approximate the share of eggs by the share of hens (for which there is more data available); the difference is expected to be smaller than 10%.\n",
    "subtitle": "Share of all eggs that are produced in cage-free housing systems. This includes barns, pasture and free-range (non-organic and organic) eggs.\n"
}
 float 
[]
 a2d737e05047ead7e2ff8f2f657c9879 59cf21e2b8e13fce6c4473f9c9d5282b
789445 Share of cage-free eggs %   2023-08-07 07:47:39 2024-07-08 16:18:01     1996-2022 Share of cage-free eggs (Various sources, 2023) 6171   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_eggs_cage_free grapher/animal_welfare/2023-08-03/share_of_cage_free_eggs/share_of_cage_free_eggs#share_of_eggs_cage_free   2             Share of all eggs that are produced in cage-free housing systems. This includes barns, pasture and free-range (non-organic and organic) eggs.   
[]
 For the United States, we approximate the share of eggs by the share of hens (for which there is more data available); the difference is expected to be smaller than 10%. 
[
    {
        "url": "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1173898/egg-packers-27july23.ods",
        "name": "Public domain"
    },
    {
        "url": "https://osf.io/cmh6v",
        "name": "Creative Commons Attribution 4.0 International License"
    }
]
   
{
    "note": "For the United States, we approximate the share of eggs by the share of hens (for which there is more data available); the difference is expected to be smaller than 10%.\n",
    "subtitle": "Share of all eggs that are produced in cage-free housing systems. This includes barns, pasture and free-range (non-organic and organic) eggs.\n"
}
 float 
[]
 56944897cae3f3212f3765624dc998e7 f89f86153daff2bef5e8710d92601951

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