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

24 rows where datasetId = 5525 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, 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
347602 Transport (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Transport",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347601 Transport     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347600 Total including LUCF (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Total including LUCF",
    "unit": "tonnes CO\u2082e per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347599 Total including LUCF     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347598 Total excluding LUCF (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Total excluding LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347597 Total excluding LUCF     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347596 Other fuel combustion (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Other fuel combustion",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347595 Other fuel combustion     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347594 Manufacturing and construction (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Manufacturing and construction",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347593 Manufacturing and construction     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347592 Land-use change and forestry (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Land-use change and forestry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347591 Land-use change and forestry     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347590 Industry (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347589 Industry     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347588 Fugitive emissions (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347587 Fugitive emissions     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347586 Energy (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Energy",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347585 Energy     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347584 Electricity and heat (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Electricity and heat",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347583 Electricity and heat     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347582 Buildings (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Buildings",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347581 Buildings     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "unit": "tonnes",
    "shortUnit": "t",
    "includeInTable": true,
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
347580 Aviation and shipping (per capita)     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Aviation and shipping",
    "unit": "tonnes per capita",
    "shortUnit": "t",
    "includeInTable": true
}
 0           1                                  
347579 Aviation and shipping     2022-02-21 14:14:56 2023-06-15 05:05:42       CO2 emissions by sector (CAIT, 2021) 5525 CO2 emissions by sector (CAIT) 21925   
{
    "name": "Aviation and shipping",
    "unit": "tonnes",
    "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");