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

13 rows where datasetId = 5403 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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
180060 consumption_co2_per_energy   Carbon intensity is measured as the quantity of carbon dioxide (CO₂) emitted per unit of energy. Consumption-based metrics adjust for the energy or emissions embedded in traded goods: it is the energy or emissions used domestically minus exported goods; plus the energy or emissions from imported goods. 2021-11-15 08:20:15 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Consumption-based carbon intensity of energy",
    "unit": "kg CO\u2082 per kWh",
    "shortUnit": "kg/kWh",
    "includeInTable": true
}
 0           1                                  
180059 production_co2_per_energy   Production-based carbon intensity is measured as the quantity of carbon dioxide (CO₂) emitted per unit of energy. Production-based energy does not adjust for the energy embedded in traded goods. 2021-11-15 08:20:15 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Production-based carbon intensity of energy",
    "unit": "kg CO\u2082 per kWh",
    "shortUnit": "kg/kWh",
    "includeInTable": true
}
 0           1                                  
180058 consumption_energy_intensity   Consumption-based energy intensity is measured as the number of kilowatt-hours used per dollar of GDP. This is measured in 2017 international-$, which adjusts for inflation and cross-country price differences. Consumption-based energy adjusts for the energy embedded in traded goods: it is the energy used domestically minus energy used to produce exported goods; plus the energy used for imported goods. 2021-11-15 08:00:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Consumption-based energy intensity per dollar",
    "unit": "kilowatt-hours per $",
    "shortUnit": "kWh",
    "includeInTable": true
}
 0           1                                  
180057 production_energy_intensity   Production-based energy intensity is measured as the number of kilowatt-hours used per dollar of GDP. This is measured in 2017 international-$, which adjusts for inflation and cross-country price differences. Production-based energy does not adjust for the energy embedded in traded goods. 2021-11-15 08:00:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Energy intensity per dollar",
    "unit": "kilowatt-hours per international-$",
    "shortUnit": "kWh",
    "includeInTable": true
}
 0           1                                  
180006 net_traded_energy_per_capita   Net energy embedded in traded goods is the net difference in energy embedded in exported goods, and imported goods. A positive value indicates that a country is a net importer; a negative value indicates that a country is a net exporter. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Net energy embedded in trade per person",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "conversionFactor": 1000000000,
    "numDecimalPlaces": 0
}
 0           1                                  
180005 consumption_per_capita   Consumption-based (trade-adjusted) energy use measures domestic energy use minus energy used to produce exported goods, plus energy used to produce imported goods. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Consumption-based (trade-adjusted) energy use per person",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "conversionFactor": 1000000000,
    "numDecimalPlaces": 0
}
 0           1                                  
180004 production_per_capita   Production-based energy consumption measures domestic energy consumption only. It does not adjust for energy embedded in traded goods. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Production-based energy use per person",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "conversionFactor": 1000000000,
    "numDecimalPlaces": 0
}
 0           1                                  
180003 net_energy_traded_goods_pct_domestic   Net energy embedded in traded goods is the net difference in energy embedded in exported goods, and imported goods. A positive value indicates that a country is a net importer; a negative value indicates that a country is a net exporter. This is given as a percentage of a country's domestic energy use. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Net energy embedded in traded goods as a share of domestic energy use",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
180002 net_energy_traded_goods   Net energy embedded in traded goods is the net difference in energy embedded in exported goods, and imported goods. A positive value indicates that a country is a net importer; a negative value indicates that a country is a net exporter. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Net energy embedded in traded goods",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
180001 production_based_energy   Production-based energy consumption measures domestic energy consumption only. It does not adjust for energy embedded in traded goods. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Production-based energy consumption",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
180000 energy_imported_goods   Energy embedded in imported goods is the quantity of energy that is used in the manufacturing of goods and services that are imported from other countries. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Energy embedded in imported goods",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
179999 energy_exported_goods   Energy embedded in exported goods is the quantity of energy that is used in the manufacturing of goods and services that are exported to other countries. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Energy embedded in exported goods",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
179998 consumption_based_energy   Consumption-based (trade-adjusted) energy use measures domestic energy use minus energy used to produce exported goods, plus energy used to produce imported goods. 2021-11-09 09:36:24 2023-06-15 05:05:42       Consumption-based energy (Kulionis, 2021) 5403 Calculated by Viktoras Kulionis, based on the EXIOBASE v3.8.2 database 21238   
{
    "name": "Consumption-based (trade-adjusted) energy use",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "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");