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 sourceId = 17817 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
142849 Waste (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Waste",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142848 Total including LUCF (per capita)   Total nitrous oxide emissions including land use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Total including land use change",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142847 Total excluding LUCF (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Total excluding land use change",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142846 Land-Use Change and Forestry (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Land use change and forestry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142845 Industry (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142844 Fugitive Emissions (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142843 Agriculture (per capita) (CAIT)     2020-06-16 12:33:28 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Agriculture",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
142813 Waste (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Waste",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142812 Total including LUCF (N2O emissions, CAIT)   Total nitrous oxide emissions including land use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Total including land use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142811 Total excluding LUCF (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Total excluding land use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142810 Other Fuel Combustion (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Other fuel combustion",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142809 Land-Use Change and Forestry (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Land use change and forestry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142808 Industry (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Industry",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142807 Fugitive Emissions (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Fugitive emissions",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142806 Energy (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "name": "Energy",
    "unit": "tonnes CO\u2082e",
    "shortUnit": "t",
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
142805 Agriculture (N2O emissions, CAIT)     2020-06-04 15:38:10 2023-06-15 05:05:42       Nitrous oxide emissions by sector (CAIT, 2020) 5087 CAIT Climate Data Explorer via. Climate Watch 17817   
{
    "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");