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

12 rows where datasetId = 6131 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, createdAt, updatedAt, timespan, shortUnit, schemaVersion, licenses, 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
737661 Oil production per capita (kWh) kilowatt-hours   2023-07-17 14:30:30 2023-12-19 13:30:19     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 kWh 
{
    "name": "Oil production per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     oil_production_per_capita__kwh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#oil_production_per_capita__kwh   2 major               
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    },
    {
        "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"
    }
]
            
737660 Gas production per capita (kWh) kilowatt-hours   2023-07-17 14:30:29 2023-12-19 13:30:19     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 kWh 
{
    "name": "Gas production per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     gas_production_per_capita__kwh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#gas_production_per_capita__kwh   2 major               
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    },
    {
        "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"
    }
]
            
737659 Coal production per capita (kWh) kilowatt-hours   2023-07-17 14:30:29 2023-12-19 13:30:19     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 kWh 
{
    "name": "Coal production per capita",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     coal_production_per_capita__kwh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#coal_production_per_capita__kwh   2 major               
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    },
    {
        "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"
    }
]
            
737658 Annual change in gas production (TWh) terawatt-hours Excludes gas flared or recycled. Includes natural gas produced for Gas-to-Liquids transformation. 2023-07-17 14:30:29 2023-12-19 13:30:19     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Annual change in gas production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_gas_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_gas_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737657 Annual change in oil production (TWh) terawatt-hours Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form. 2023-07-17 14:30:28 2023-12-19 13:30:18     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Annual change in oil production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_oil_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_oil_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737656 Annual change in gas production (%) % Excludes gas flared or recycled. Includes natural gas produced for Gas-to-Liquids transformation. 2023-07-17 14:30:27 2023-12-19 13:30:18     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 % 
{
    "name": "Annual change in gas production",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_gas_production__pct grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_gas_production__pct   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737655 Annual change in oil production (%) % Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form. 2023-07-17 14:30:27 2023-12-19 13:30:18     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 % 
{
    "name": "Annual change in oil production",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_oil_production__pct grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_oil_production__pct   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737654 Annual change in coal production (TWh) terawatt-hours Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations. 2023-07-17 14:30:26 2023-12-19 13:30:18     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Annual change in coal production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_coal_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_coal_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737653 Annual change in coal production (%) % Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations. 2023-07-17 14:30:26 2023-12-19 13:30:18     1901-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 % 
{
    "name": "Annual change in coal production",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_coal_production__pct grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#annual_change_in_coal_production__pct   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737652 Oil production (TWh) terawatt-hours Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form. 2023-07-17 14:30:25 2023-12-19 13:30:17     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Oil production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     oil_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#oil_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737651 Gas production (TWh) terawatt-hours Excludes gas flared or recycled. Includes natural gas produced for Gas-to-Liquids transformation. 2023-07-17 14:30:25 2023-12-19 13:30:17     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Gas production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     gas_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#gas_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            
737650 Coal production (TWh) terawatt-hours Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations. 2023-07-17 14:30:23 2023-12-19 13:30:17     1900-2022 Fossil fuel production (EI & Shift, 2023) 6131 Energy Institute Statistical Review of World Energy (2023); The Shift Data Portal 29205 TWh 
{
    "name": "Coal production",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     coal_production__twh grapher/energy/2023-07-10/fossil_fuel_production/fossil_fuel_production#coal_production__twh   1                 
[]
   
[
    {
        "url": "https://web.archive.org/web/20230626200231/https://www.energyinst.org/__data/assets/pdf_file/0004/1055542/EI_Stat_Review_PDF_single-2.pdf",
        "name": "\u00a9 Energy Institute 2023"
    },
    {
        "url": "https://www.theshiftdataportal.org/legal-notice",
        "name": "Creative Commons BY-SA 3.0"
    }
]
            

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