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

16 rows where datasetId = 5086 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
142842 Waste (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Waste",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142841 Total including LUCF (per capita) (CH4 emissions, CAIT)   Total methane emissions including land use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Total including land use change",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142840 Total excluding LUCF (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Total excluding land use change",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142839 Land-Use Change and Forestry (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Land use change and forestry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142838 Industry (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142837 Fugitive Emissions (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142836 Agriculture (per capita) (CH4 emissions, CAIT)     2020-06-16 12:28:53 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Agriculture",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142804 Waste (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Waste",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142803 Total including LUCF (CH4 emissions, CAIT)   Total methane emissions including land use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Total including land-use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000
}
 0           1                                  
142802 Total excluding LUCF (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Total excluding land-use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142801 Other Fuel Combustion (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Other fuel combustion",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142800 Land-Use Change and Forestry (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Land use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142799 Industry (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Industry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142798 Fugitive Emissions (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Fugitive emissions",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142797 Energy (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Energy ",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142796 Agriculture (CH4 emissions, CAIT)     2020-06-04 14:54:59 2023-06-15 05:05:42       Methane emissions by sector (CAIT, 2020) 5086 CAIT Climate Data Explorer via Climate Watch 17816   
{
    "name": "Agriculture",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "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");