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 = 6174 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, 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
789694 kilograms_per_animal_direct kilograms The estimated quantity of edible meat produced per animal, measured in kilograms. 2023-08-09 10:37:15 2024-07-08 17:22:37     2023-2023 Animal lives lost per kilogram (Faunalytics) 6174 Impact of Replacing Animal Products (Faunalytics, 2023) 28244 kg 
{
    "unit": "kilograms",
    "shortUnit": "kg",
    "numDecimalPlaces": 0
}
 0     kilograms_per_animal_direct grapher/fasttrack/2023-08-07/animal_lives_per_kilogram/animal_lives_per_kilogram#kilograms_per_animal_direct   1                 
[]
         mixed 
[]
 3f1645baab7cc0655f1552a34e5cdaa6 770a211ded7342789d3add3067f427c1
789693 days_per_kg_total days The estimated number of days of suffering that go toward each kilogram of animal product purchased for retail sale, including the suffering of animals used directly in production and those used indirectly. For example, the pork numbers include the suffering of pigs slaughtered for food (direct) but also those who die pre-slaughter and feed fish given to those pigs (indirect). 2023-08-09 10:37:15 2024-07-08 17:22:37     2023-2023 Animal lives lost per kilogram (Faunalytics) 6174 Impact of Replacing Animal Products (Faunalytics, 2023) 28244 days 
{
    "unit": "days",
    "shortUnit": "days",
    "numDecimalPlaces": 0
}
 0     days_per_kg_total grapher/fasttrack/2023-08-07/animal_lives_per_kilogram/animal_lives_per_kilogram#days_per_kg_total   1                 
[]
         mixed 
[]
 c0777309400c3755a04cbfbbe850dbab f7bea793919279954577336f5082146c
789692 days_per_kg_direct days The estimated number of days of animal suffering that go toward each kilogram of animal product purchased for retail sale, including direct suffering only. For example, the pork numbers include only the suffering of pigs slaughtered for food. 2023-08-09 10:37:15 2024-07-08 17:22:37     2023-2023 Animal lives lost per kilogram (Faunalytics) 6174 Impact of Replacing Animal Products (Faunalytics, 2023) 28244 days 
{
    "unit": "days",
    "shortUnit": "days",
    "numDecimalPlaces": 0
}
 0     days_per_kg_direct grapher/fasttrack/2023-08-07/animal_lives_per_kilogram/animal_lives_per_kilogram#days_per_kg_direct   1                 
[]
         mixed 
[]
 2749b81b95d912764a62cce43c75f944 b87e69fc9c8f66842c609bb50c98c1ed
789691 lives_per_kg_total lives The estimated number of animal lives that go toward each kilogram of animal product purchased for retail sale, including direct and indirect deaths. For example, the pork numbers include the deaths of pigs slaughtered for food (direct) but also those who die pre-slaughter and feed fish given to those pigs (indirect). 2023-08-09 10:37:15 2024-07-08 17:22:37     2023-2023 Animal lives lost per kilogram (Faunalytics) 6174 Impact of Replacing Animal Products (Faunalytics, 2023) 28244 lives 
{
    "unit": "lives",
    "shortUnit": "lives",
    "numDecimalPlaces": 2
}
 0     lives_per_kg_total grapher/fasttrack/2023-08-07/animal_lives_per_kilogram/animal_lives_per_kilogram#lives_per_kg_total   1                 
[]
         float 
[]
 58e8b1709bec7fbc4219b64ab7126fbc 70e53b7e987ad050d414d273c3e18b3a
789690 lives_per_kg_direct lives The estimated number of animal lives that go toward each kilogram of animal product purchased for retail sale, including direct deaths only. For example, the pork numbers include only the deaths of pigs slaughtered for food. 2023-08-09 10:37:15 2024-07-08 17:22:37     2023-2023 Animal lives lost per kilogram (Faunalytics) 6174 Impact of Replacing Animal Products (Faunalytics, 2023) 28244 lives 
{
    "unit": "lives",
    "shortUnit": "lives",
    "numDecimalPlaces": 0
}
 0     lives_per_kg_direct grapher/fasttrack/2023-08-07/animal_lives_per_kilogram/animal_lives_per_kilogram#lives_per_kg_direct   1                 
[]
         float 
[]
 86b22b8a731c33be32632ffc14166287 ffb082f8df4e8846f30aede11b0b20ba

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