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

46 rows where datasetId = 5509 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
413899 Net electricity imports as a share of demand     2022-03-31 09:37:58 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{}
 0           1                                  
413898 Net imports (TWh)     2022-03-31 09:37:58 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{}
 0           1                                  
413897 Electricity demand (TWh)     2022-03-31 09:37:58 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{}
 0           1                                  
248117 Carbon intensity of electricity (gCO2/kWh)   Carbon intensity of electricity production is measured in grams of carbon dioxide (CO₂) emitted per kilowatt-hour (kWh). 2022-02-15 09:07:11 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Carbon intensity of electricity per kWh",
    "unit": "grams CO\u2082 per kilowatt-hour",
    "shortUnit": "gCO\u2082",
    "includeInTable": true
}
 0           1                                  
247985 Other renewables including bioenergy (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewables, including bioenergy",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247984 Other renewables excluding bioenergy (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewables, excluding bioenergy",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247983 Bioenergy (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Bioenergy",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247982 Hydro (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Hydropower",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247981 Wind (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Wind",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247980 Solar (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Solar",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247979 Nuclear (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Nuclear",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247978 Low-carbon electricity (% electricity)   Low-carbon electricity is the sum of electricity from nuclear and renewable sources (including solar, wind, hydropower, biomass and waste, geothermal and wave and tidal). 2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Share of electricity from low-carbon sources",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
247977 Renewables (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Renewables",
    "unit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0           1                                  
247976 Fossil fuels (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Fossil fuels",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247975 Gas (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Gas",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247974 Oil (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Oil",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247973 Coal (% electricity)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Coal",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247972 Electricity as share of primary energy     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Electricity as share of primary energy",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
247971 Other renewable electricity including bioenergy per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewable electricity per capita, including bioenergy",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247970 Other renewable electricity excluding bioenergy per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewable electricity per capita, excluding bioenergy",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247969 Bioenergy electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Bioenergy electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247968 Hydro electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Hydro electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247967 Wind electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Wind electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247966 Solar electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Solar electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247965 Nuclear electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Nuclear electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247964 Low-carbon electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Low-carbon electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247963 Renewable electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Renewable electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247962 Fossil fuel electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Fossil fuel electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247961 Gas electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Gas electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247960 Oil electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Oil electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247959 Coal electricity per capita (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Coal electricity per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247958 Per capita electricity (kWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Per capita electricity use",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247957 Electricity from wind (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Wind",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247956 Electricity from solar (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Solar",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247955 Electricity from renewables (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Renewables",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247954 Electricity from other renewables including bioenergy (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewables, including bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247953 Electricity from other renewables excluding bioenergy (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Other renewables excluding bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247952 Electricity from oil (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247951 Electricity from nuclear (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Nuclear",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247950 Low-carbon electricity (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Low-carbon electricity",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
247949 Electricity from hydro (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Hydropower",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247948 Electricity from gas (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247947 Electricity from fossil fuels (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Fossil fuels",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247946 Electricity generation (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Electricity generation",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247945 Electricity from coal (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
247944 Electricity from bioenergy (TWh)     2022-02-10 10:37:57 2023-06-15 05:05:42       Electricity mix from BP & EMBER (2022) - archive 5509 Our World in Data based on BP Statistical Review of World Energy & Ember (2022) 21323   
{
    "name": "Bioenergy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 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");