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

15 rows where datasetId = 4223 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
104793 Scarcity-weighted water use per 1000kcal (Poore & Nemecek, 2018)   Global average scarcity-weighted water use represents freshwater use weighted by local water scarcity. Therefore, these figures place greater weight on food production in areas with high water stress than conventional measures of freshwater withdrawal. This is measured in liters per 1000 kilocalories across food products. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Scarcity-weighted water use per 1000kcal",
    "unit": "liters per 1000 kilocalories",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104792 Freshwater withdrawals per 1000kcal (Poore & Nemecek, 2018)   Global average freshwater withdrawals per 1000 kilocalories across food products. This is measured in liters of freshwater per 1000 kilocalories. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Freshwater withdrawals per 1000kcal",
    "unit": "liters per 1000kcal",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104791 Eutrophying emissions per 1000kcal (Poore & Nemecek, 2018)   Global average eutrophying emissions per 1000 kilocalories across food products. Eutrophying emissions represent runoff of excess nutrients into the surrounding environment and waterways, which affect and pollute ecosystems with nutrient imbalances. They are measured in grams of phosphate equivalents. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Eutrophying emissions per 1000kcal",
    "unit": "gPO\u2084eq per 1000kcal",
    "shortUnit": "g",
    "numDecimalPlaces": 2
}
 0           1                                  
104790 GHG emissions per 1000kcal (Poore & Nemecek, 2018)   Global average greenhouse gas emissions (GHG) per 1000 kilocalories across different food products. This is measured in kilograms of CO₂-equivalents per 1000kcal (kgCO₂eq per 1000kcal). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Greenhouse gas emissions per 1000kcal",
    "unit": "kgCO\u2082eq per 1000kcal",
    "shortUnit": "kg",
    "numDecimalPlaces": 2
}
 0           1                                  
104789 Land use per 1000kcal (Poore & Nemecek, 2018)   Global mean land used to produce 1000 kilocalories of different food products. This is measured in meters squared per 1000kcal (m² per 1000kcal). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Land use per 1000kcal",
    "unit": "m\u00b2 per 1000kcal",
    "shortUnit": "m\u00b2",
    "numDecimalPlaces": 2
}
 0           1                                  
104788 Scarcity-weighted water use per 100g protein (Poore & Nemecek, 2018)   Global average scarcity-weighted water use represent freshwater use weighted by local water scarcity. Therefore, these figures place greater weight on food production in areas with high water stress than conventional measures of freshwater withdrawal. This is measured in liters per 100 grams of protein across food products. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Scarcity-weighted water use per 100g protein",
    "unit": "liters per 100g protein",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104787 Freshwater withdrawals per 100g protein (Poore & Nemecek, 2018)   Global average freshwater withdrawals per 100 grams of protein across food products. This is measured in liters of freshwater per 100 grams of protein. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Freshwater withdrawals per 100g protein",
    "unit": "liters per 100g protein",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104786 Eutrophying emissions per 100g protein (Poore & Nemecek, 2018)   Global average eutrophying emissions per 100 grams of protein across food products. Eutrophying emissions represent runoff of excess nutrients into the surrounding environment and waterways, which affect and pollute ecosystems with nutrient imbalances. They are measured in grams of phosphate equivalents. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Eutrophying emissions per 100g protein",
    "unit": "gPO\u2084eq per 100 grams protein",
    "shortUnit": "g",
    "numDecimalPlaces": 2
}
 0           1                                  
104785 GHG emissions per 100g protein (Poore & Nemecek, 2018)   Global average greenhouse gas emissions (GHG) per 100 grams of protein across different food products. This is measured in kilograms of CO₂-equivalents per 100 grams of protein (kgCO₂eq per 100g protein). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Greenhouse gas emissions per 100g protein",
    "unit": "kgCO\u2082eq per 100g protein",
    "shortUnit": "kg",
    "numDecimalPlaces": 2
}
 0           1                                  
104784 Land use per 100g protein (Poore & Nemecek, 2018)   Global mean land used to produce 100 grams of protein across different food products. This is measured in meters squared per 100g protein (m² per 100g protein). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Land use per 100g protein",
    "unit": "m\u00b2 per 100g protein",
    "shortUnit": "m\u00b2",
    "numDecimalPlaces": 2
}
 0           1                                  
104783 Scarcity-weighted water use per kilogram (Poore & Nemecek, 2018)   Global average scarcity-weighted water use represent freshwater use weighted by local water scarcity. Therefore, these figures place greater weight on food production in areas with high water stress than conventional measures of freshwater use. This is measured in liters per kilogram of food product. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Scarcity-weighted water use per kilogram",
    "unit": "liters per kilogram",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104782 Freshwater withdrawals per kilogram (Poore & Nemecek, 2018)   Global average freshwater withdrawals per kilogram of food product. This is measured in liters of freshwater per kilogram of food product. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Freshwater withdrawals per kilogram",
    "unit": "liters per kilogram",
    "shortUnit": "L",
    "numDecimalPlaces": 0
}
 0           1                                  
104781 Eutrophying emissions per kilogram (Poore & Nemecek, 2018)   Global average eutrophying emissions per kilogram of food product. Eutrophying emissions represent runoff of excess nutrients into the surrounding environment and waterways, which affect and pollute ecosystems with nutrient imbalances. They are measured in grams of phosphate equivalents. 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Eutrophying emissions per kilogram",
    "unit": "gPO\u2084eq per kilogram",
    "shortUnit": "g",
    "numDecimalPlaces": 2
}
 0           1                                  
104780 GHG emissions per kilogram (Poore & Nemecek, 2018)   Global average greenhouse gas emissions (GHG) per kilogram of food product. This is measured in kilograms of CO₂-equivalents per kilogram of product (kgCO₂eq per kg). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Greenhouse gas emissions per kilogram",
    "unit": "kgCO\u2082eq per kilogram",
    "shortUnit": "kg",
    "numDecimalPlaces": 2
}
 0           1                                  
104779 Land use per kilogram (Poore & Nemecek, 2018)   Global mean land used to produce one kilogram of different food products. This is measured in meters squared per kilogram (m² per kg). 2019-10-08 11:13:34 2023-06-15 05:05:42       Environmental impacts of food (Poore & Nemecek, 2018) 4223 Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science. 17051   
{
    "name": "Land use per kilogram",
    "unit": "m\u00b2 per kilogram",
    "shortUnit": "m\u00b2",
    "numDecimalPlaces": 2
}
 0           1                                  

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