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

42 rows where datasetId = 5004 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, 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
130747 Emissions intensities - Rice, paddy - 27 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:12 2023-06-15 05:05:42 EI - 27 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130746 Emissions intensities - Rice, paddy - 27 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:11 2023-06-15 05:05:42 EI - 27 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130745 Emissions intensities - Rice, paddy - 27 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:10 2023-06-15 05:05:42 EI - 27 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130744 Emissions intensities - Milk, whole fresh sheep - 982 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:09 2023-06-15 05:05:42 EI - 982 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130743 Emissions intensities - Milk, whole fresh sheep - 982 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:08 2023-06-15 05:05:42 EI - 982 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130742 Emissions intensities - Milk, whole fresh sheep - 982 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:08 2023-06-15 05:05:42 EI - 982 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130741 Emissions intensities - Milk, whole fresh goat - 1020 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:07 2023-06-15 05:05:42 EI - 1020 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130740 Emissions intensities - Milk, whole fresh goat - 1020 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:06 2023-06-15 05:05:42 EI - 1020 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130739 Emissions intensities - Milk, whole fresh goat - 1020 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:05 2023-06-15 05:05:42 EI - 1020 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130738 Emissions intensities - Milk, whole fresh cow - 882 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:03 2023-06-15 05:05:42 EI - 882 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130737 Emissions intensities - Milk, whole fresh cow - 882 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:34:01 2023-06-15 05:05:42 EI - 882 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130736 Emissions intensities - Milk, whole fresh cow - 882 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:59 2023-06-15 05:05:42 EI - 882 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130735 Emissions intensities - Milk, whole fresh camel - 1130 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:59 2023-06-15 05:05:42 EI - 1130 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130734 Emissions intensities - Milk, whole fresh camel - 1130 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:59 2023-06-15 05:05:42 EI - 1130 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130733 Emissions intensities - Milk, whole fresh camel - 1130 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:58 2023-06-15 05:05:42 EI - 1130 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130732 Emissions intensities - Milk, whole fresh buffalo - 951 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:58 2023-06-15 05:05:42 EI - 951 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130731 Emissions intensities - Milk, whole fresh buffalo - 951 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:58 2023-06-15 05:05:42 EI - 951 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130730 Emissions intensities - Milk, whole fresh buffalo - 951 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:57 2023-06-15 05:05:42 EI - 951 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130729 Emissions intensities - Meat, sheep - 977 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:56 2023-06-15 05:05:42 EI - 977 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130728 Emissions intensities - Meat, sheep - 977 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:54 2023-06-15 05:05:42 EI - 977 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130727 Emissions intensities - Meat, sheep - 977 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:52 2023-06-15 05:05:42 EI - 977 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130726 Emissions intensities - Meat, pig - 1035 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:51 2023-06-15 05:05:42 EI - 1035 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130725 Emissions intensities - Meat, pig - 1035 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:49 2023-06-15 05:05:42 EI - 1035 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130724 Emissions intensities - Meat, pig - 1035 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:47 2023-06-15 05:05:42 EI - 1035 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130723 Emissions intensities - Meat, goat - 1017 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:45 2023-06-15 05:05:42 EI - 1017 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130722 Emissions intensities - Meat, goat - 1017 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:44 2023-06-15 05:05:42 EI - 1017 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130721 Emissions intensities - Meat, goat - 1017 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:42 2023-06-15 05:05:42 EI - 1017 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130720 Emissions intensities - Meat, chicken - 1058 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:40 2023-06-15 05:05:42 EI - 1058 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130719 Emissions intensities - Meat, chicken - 1058 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:38 2023-06-15 05:05:42 EI - 1058 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130718 Emissions intensities - Meat, chicken - 1058 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:37 2023-06-15 05:05:42 EI - 1058 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130717 Emissions intensities - Meat, cattle - 867 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:35 2023-06-15 05:05:42 EI - 867 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130716 Emissions intensities - Meat, cattle - 867 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:33 2023-06-15 05:05:42 EI - 867 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130715 Emissions intensities - Meat, cattle - 867 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:31 2023-06-15 05:05:42 EI - 867 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130714 Emissions intensities - Meat, buffalo - 947 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:30 2023-06-15 05:05:42 EI - 947 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130713 Emissions intensities - Meat, buffalo - 947 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:30 2023-06-15 05:05:42 EI - 947 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130712 Emissions intensities - Meat, buffalo - 947 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:29 2023-06-15 05:05:42 EI - 947 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130711 Emissions intensities - Eggs, hen, in shell - 1062 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:28 2023-06-15 05:05:42 EI - 1062 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130710 Emissions intensities - Eggs, hen, in shell - 1062 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:26 2023-06-15 05:05:42 EI - 1062 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130709 Emissions intensities - Eggs, hen, in shell - 1062 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:23 2023-06-15 05:05:42 EI - 1062 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130708 Emissions intensities - Cereals excluding rice - 1718 - Production - 5510 - tonnes tonnes Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:22 2023-06-15 05:05:42 EI - 1718 - 5510 - tonnes     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130707 Emissions intensities - Cereals excluding rice - 1718 - Emissions intensity - 71761 - kg CO2eq/kg product kg CO2eq/kg product Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:20 2023-06-15 05:05:42 EI - 1718 - 71761 - kg CO2eq/kg product     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 0           1                                  
130706 Emissions intensities - Cereals excluding rice - 1718 - Emissions (CO2eq) - 7231 - gigagrams gigagrams Intensities of greenhouse gas (GHG) emissions by unit of product for a selection of agricultural commodities. 2020-02-14 01:33:18 2023-06-15 05:05:42 EI - 1718 - 7231 - gigagrams     Agri-Environmental Indicators: Emissions intensities 5004 Agri-Environmental Indicators: Emissions intensities 17735   
{}
 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");