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

6 rows where sourceId = 18002 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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
145956 Food's share of total emissions (excl. LULUFC)     2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{}
 0           1                                  
145955 Total GHG emissions (EDGAR)   Total greenhouse gas emissions from all sectors. 2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{
    "name": "Total greenhouse gas emissions",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000
}
 0           1                                  
145954 Total GHG Emissions (tonnes)   Total greenhouse gas emissions from all sectors. 2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{
    "name": "Total greenhouse gas emissions",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000,
    "numDecimalPlaces": 0
}
 0           1                                  
145953 Share of global food emissions   Emissions include not only direct emissions from agriculture, but also land use change and supply chain emissions (transport, packaging, food processing, retail, consumer cooking, refrigeration and waste). Greenhouse gas emissions are quantified on the basis of their 100-year global warming potential (GWP100) using emission factors from the IPCC 5th Assessment Report (AR5). Emissions by country are quantified on the basis of food production, not consumption. This means they do not account for international trade. 2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{
    "name": "Share of the global emissions from food",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145952 Food's share of total emissions (incl. LULUFC)   Emissions include not only direct emissions from agriculture, but also land use change and supply chain emissions (transport, packaging, food processing, retail, consumer cooking, refrigeration and waste). Greenhouse gas emissions are quantified on the basis of their 100-year global warming potential (GWP100) using emission factors from the IPCC 5th Assessment Report (AR5). Emissions by country are quantified on the basis of food production, not consumption. This means they do not account for international trade. 2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{
    "name": "Share of total greenhouse gas emissions that come from food",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145951 Food emissions by country   Emissions include not only direct emissions from agriculture, but also land use change and supply chain emissions (transport, packaging, food processing, retail, consumer cooking, refrigeration and waste). Greenhouse gas emissions are quantified on the basis of their 100-year global warming potential (GWP100) using emission factors from the IPCC 5th Assessment Report (AR5). Emissions by country are quantified on the basis of food production, not consumption. This means they do not account for international trade. 2021-03-10 10:18:49 2023-06-15 05:05:42       GHG emissions from food (Crippa et al. 2021) 5273 Crippa et al. (2021). Food systems are responsible for a third of global anthropogenic GHG emissions. Nature Food. 18002   
{
    "name": "Greenhouse gas emissions from food",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "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");