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

10 rows where datasetId = 6166 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, updatedAt, timespan, shortUnit, display, type, 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
783628 Share of hens in cages %   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_hens_in_cages grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_hens_in_cages   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     float 
[]
 eea91aebb614ae2be48b5293d7efd9c4 ac797baf45baa83cadad82b19cf5b058
783627 Share of laying hens in unknown housing %   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_hens_in_unknown_housing grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_hens_in_unknown_housing   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     int 
[]
 513a4125805c63c651ca26a535181492 654ae0a1be5ed67cc6d24e42fa4ceb7a
783626 Share of hens housed in a barn or aviary %   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_hens_in_barns grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_hens_in_barns   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     float 
[]
 dc58cfd0c053fca5ffeaa9617b3970c4 d51f8ce394e454804ae8b36c3751ba28
783625 Share of organic, free-range hens %   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_hens_free_range_organic grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_hens_free_range_organic   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     float 
[]
 912a2deca09fa9bd1e8999c4753b0f6d 00bc4600f10b85f06e0460de96f8c3f9
783624 Share of non-organic, free-range hens %   2023-08-02 09:48:23 2024-07-08 16:38:20     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_hens_free_range_not_organic grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_hens_free_range_not_organic   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
   
{
    "hasMapTab": false,
    "hideTimeline": true
}
 float 
[]
 b6c0fdd1f011bdbf9c7ef9075fd3b5f1 a74561c471a36b2854c90c8697fafe0e
783623 Share of all hens that are brown %   2023-08-02 09:48:23 2024-07-08 16:38:19     2016-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     share_of_brown_hens grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#share_of_brown_hens   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     int 
[]
 cecda555cee05e69b3093dd87cda4ae9 ed73f5c128dcab89f548c8e2b0b48a54
783622 Number of laying hens hens   2023-08-02 09:48:23 2024-07-08 16:38:20     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166     
{
    "unit": "hens",
    "numDecimalPlaces": 0
}
 0     number_of_laying_hens grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#number_of_laying_hens   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     int 
[]
 cfd0faee77babdb2086df4d44742e5af 72b88cf1a8983281ca94ebde12bb3d25
783621 Number of hens in cages hens   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166     
{
    "unit": "hens",
    "numDecimalPlaces": 0
}
 0     number_of_hens_in_cages grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#number_of_hens_in_cages   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
   
{
    "hasMapTab": false,
    "hideTimeline": true
}
 float 
[]
 738d7a381477e6bf674ea6d39b754947 9f2a20972863c0d217bbfeff84faae9c
783620 Number of cage-free hens hens   2023-08-02 09:48:23 2024-07-08 16:38:19     2013-2020 Global hen inventory (Welfare Footprint Project, 2022) 6166     
{
    "unit": "hens",
    "numDecimalPlaces": 0
}
 0     number_of_hens_cage_free grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#number_of_hens_cage_free   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
   
{
    "hasMapTab": false,
    "hideTimeline": true
}
 float 
[]
 8aa50fdf15bcb04b895e0d7374cc3cd3 b3794e3ccbb275f60bfcb2eeb8157d7f
783619 Number of commercial egg farms farms   2023-08-02 09:48:23 2024-07-08 16:38:19     2017-2019 Global hen inventory (Welfare Footprint Project, 2022) 6166     
{
    "unit": "farms",
    "numDecimalPlaces": 0
}
 0     number_of_commercial_egg_farms grapher/animal_welfare/2023-08-01/global_hen_inventory/global_hen_inventory#number_of_commercial_egg_farms   2                 
[]
   
[
    {
        "url": "https://welfarefootprint.org/research-projects/laying-hens/",
        "name": "CC BY 4.0"
    }
]
     int 
[]
 bf1776040e28c32341ebc404142dcf7e ed766db486a88817b0989878e343490a

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