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

8 rows where sourceId = 17987 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
145875 emissions_intensity_prod   Emissions intensity of agricultural production is measured as the amount of greenhouse gas emissions produced per unit of agricultural output. It's measured in kilograms of carbon dioxide equivalents (kgCO₂e) per 1000 kilocalories of food. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Greenhouse gas emissions of agriculture per kilocalorie",
    "unit": "kilograms CO\u2082e per 1000kcal",
    "shortUnit": "kg",
    "includeInTable": true,
    "conversionFactor": 1000000000000000
}
 0           1                                  
145874 emissions_intensity_land   Emissions intensity of land use is measured as the amount of greenhouse gases produced per hectare of agricultural land. It is measured in tonnes of carbon dioxide equivalents (tCO₂e) per hectare. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Greenhouse gas emissions of agriculture per hectare",
    "unit": "tonnes per hectare",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000000
}
 0           1                                  
145873 land_intensity_prod   Land use intensity measures the amount of land needed to produce a given output. It is the inverse of crop yield, and calculated by dividing agricultural land use (in hectares) by food production (measured in kilocalories). 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Land use intensity of food production",
    "unit": "hectares per million kilocalories",
    "shortUnit": "ha",
    "includeInTable": true,
    "conversionFactor": 1000000
}
 0           1                                  
145872 kcal_prod_capita   Total per capita kilocalorie production from agriculture. This does not measure the supply of kilocalories for human consumption because it does not account for trade between countries, and allocation of foods towards other uses such as animal feed, biofuels and wastage. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Daily production of calories per person",
    "unit": "kilocalories per day",
    "shortUnit": "kcal",
    "includeInTable": true,
    "conversionFactor": 0.002739726,
    "numDecimalPlaces": 0
}
 0           1                                  
145871 land_use   Total land use for agriculture. This includes cropland and pasture for grazing. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Land use for agriculture",
    "unit": "hectares",
    "shortUnit": "ha",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145870 total_kcal_production   Total kilocalorie production from agriculture. This does not measure the supply of kilocalories for human consumption because it does not account for trade between countries, and allocation of foods towards other uses such as animal feed, biofuels and wastage. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Total calorie production",
    "unit": "kilocalories",
    "shortUnit": "kcal",
    "includeInTable": true
}
 0           1                                  
145869 population     2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Population",
    "includeInTable": true
}
 0           1                                  
145868 total_emissions   Annual greenhouse gas emissions from agriculture. This includes land use change and emissions from agricultural production (including fertilisers, manure, enteric fermentation from livestock, methane from rice etc.). It does not include supply chain emissions post-farmgate, such as refrigeration, packaging or transport. 2021-02-16 10:04:23 2023-06-15 05:05:42       PALE factors of food production (Hong et al. (2021)) 5258 Hong et al. (2021). Global and regional drivers of land-use emissions in 1961–2017. Nature. 17987   
{
    "name": "Greenhouse gas emissions from agriculture",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000000,
    "numDecimalPlaces": 0
}
 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");