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

5 rows where datasetId = 6583 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, timespan, shortUnit, titlePublic, descriptionKey, createdAt (date), updatedAt (date), descriptionKey (array)

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
943793 Primary energy consumption per GDP (kWh/$) kilowatt-hours per $   2024-06-25 14:50:22 2024-07-25 23:09:03     1965-2022 Primary energy consumption 6583   kWh 
{
    "name": "Energy consumption per dollar",
    "unit": "kilowatt-hours per $",
    "shortUnit": "kWh"
}
 0     primary_energy_consumption_per_gdp__kwh_per_dollar grapher/energy/2024-06-20/primary_energy_consumption/primary_energy_consumption#primary_energy_consumption_per_gdp__kwh_per_dollar   2 major   Primary energy consumption per GDP       Measured in kilowatt-hours per international-$.   
[
    "This GDP indicator provides information on economic growth and income levels in the very long run. Some country estimates are available as far back as 1 CE and regional estimates as far back as 1820 CE.",
    "This data is adjusted for inflation and for differences in the cost of living between countries.",
    "This data is expressed in [international-$](#dod:int_dollar_abbreviation) at 2011 prices, using a combination of 2011 and 1990 PPPs for historical data.",
    "Time series for former countries and territories are calculated forward in time by estimating values based on their last official borders.",
    "For more regularly updated estimates of GDP, see the [World Bank's indicator](https://ourworldindata.org/grapher/national-gdp-wb)."
]
 - Primary energy consumption data was compiled based on two key data sources: [Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review), and [International energy data from the U.S. Energy Information Administration (EIA)](https://www.eia.gov/international/data/world/total-energy/more-total-energy-data). EI provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where EI provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. - Per capita figures have been calculated using a population dataset that is based on [different sources](https://ourworldindata.org/population-sources). - To calculate energy per unit of GDP, we divide by total real GDP figures from [the Maddison Project Database](https://ourworldindata.org/grapher/gdp-maddison-project-database).       float 
[]
 82e1acef3fcb68e95f09c258444f7360 c4016eb2b70fa25c9dd09bc98028f84e
943792 Annual change in primary energy consumption (TWh) terawatt-hours   2024-06-25 14:50:22 2024-07-25 23:09:03     1966-2023 Primary energy consumption 6583   TWh 
{
    "name": "Primary energy consumption",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_primary_energy_consumption__twh grapher/energy/2024-06-20/primary_energy_consumption/primary_energy_consumption#annual_change_in_primary_energy_consumption__twh   2 major   Annual change in primary energy consumption           
[]
 - Primary energy consumption data was compiled based on two key data sources: [Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review), and [International energy data from the U.S. Energy Information Administration (EIA)](https://www.eia.gov/international/data/world/total-energy/more-total-energy-data). EI provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where EI provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. - Per capita figures have been calculated using a population dataset that is based on [different sources](https://ourworldindata.org/population-sources). - To calculate energy per unit of GDP, we divide by total real GDP figures from [the Maddison Project Database](https://ourworldindata.org/grapher/gdp-maddison-project-database).       float 
[]
 43a44846d2c41c4ce402ffadf75a53e4 980b058c4aa86273ff41580e52dd6305
943791 Primary energy consumption per capita (kWh/person) kilowatt-hours per person   2024-06-25 14:50:22 2024-07-25 23:09:03     1965-2023 Primary energy consumption 6583   kWh 
{
    "name": "Per capita energy consumption",
    "unit": "kilowatt-hours per person",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     primary_energy_consumption_per_capita__kwh grapher/energy/2024-06-20/primary_energy_consumption/primary_energy_consumption#primary_energy_consumption_per_capita__kwh   2 major   Primary energy consumption per capita       Measured in kilowatt-hours per person.   
[]
 - Primary energy consumption data was compiled based on two key data sources: [Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review), and [International energy data from the U.S. Energy Information Administration (EIA)](https://www.eia.gov/international/data/world/total-energy/more-total-energy-data). EI provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where EI provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. - Per capita figures have been calculated using a population dataset that is based on [different sources](https://ourworldindata.org/population-sources). - To calculate energy per unit of GDP, we divide by total real GDP figures from [the Maddison Project Database](https://ourworldindata.org/grapher/gdp-maddison-project-database). 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
     float 
[]
 0c0b77ed38139a510a4bd8bf9a1d5d68 a1aad93dbe7b2ac06c2746eba8a570c6
943790 Annual change in primary energy consumption (%) %   2024-06-25 14:50:22 2024-07-25 23:09:03     1966-2023 Primary energy consumption 6583   % 
{
    "name": "Primary energy consumption",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_primary_energy_consumption__pct grapher/energy/2024-06-20/primary_energy_consumption/primary_energy_consumption#annual_change_in_primary_energy_consumption__pct   2 major   Annual change in primary energy consumption           
[]
 - Primary energy consumption data was compiled based on two key data sources: [Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review), and [International energy data from the U.S. Energy Information Administration (EIA)](https://www.eia.gov/international/data/world/total-energy/more-total-energy-data). EI provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where EI provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. - Per capita figures have been calculated using a population dataset that is based on [different sources](https://ourworldindata.org/population-sources). - To calculate energy per unit of GDP, we divide by total real GDP figures from [the Maddison Project Database](https://ourworldindata.org/grapher/gdp-maddison-project-database).       float 
[]
 1bff4f06d312b5b817f62b4c1d46a5dd 9019b4144ef367210ef944e391f139a0
943789 Primary energy consumption (TWh) terawatt-hours   2024-06-25 14:50:22 2024-07-25 23:09:03     1965-2023 Primary energy consumption 6583   TWh 
{
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     primary_energy_consumption__twh grapher/energy/2024-06-20/primary_energy_consumption/primary_energy_consumption#primary_energy_consumption__twh   2 major   Primary energy consumption       Measured in terawatt-hours.   
[]
 - Primary energy consumption data was compiled based on two key data sources: [Energy Institute (EI) Statistical Review of World Energy](https://www.energyinst.org/statistical-review), and [International energy data from the U.S. Energy Information Administration (EIA)](https://www.eia.gov/international/data/world/total-energy/more-total-energy-data). EI provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where EI provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. - Per capita figures have been calculated using a population dataset that is based on [different sources](https://ourworldindata.org/population-sources). - To calculate energy per unit of GDP, we divide by total real GDP figures from [the Maddison Project Database](https://ourworldindata.org/grapher/gdp-maddison-project-database).       float 
[]
 40139e830d1ec1499b4f276c7079011a dc7ddcb4c018f04a7aa8b0f7e9d336e4

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");