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

9 rows where datasetId = 6128 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, updatedAt, timespan, sourceId, shortUnit, 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
737503 Global reserves of oil tonnes Estimates have been compiled using a combination of primary official sources, third-party data from the OPEC Secretariat, World Oil, Oil & Gas Journal and Chinese reserves based on official data and information in the public domain. Canadian oil sands "under active development" are an official estimate. Venezuelan Orinoco Belt reserves are based on the OPEC Secretariat and government announcements. Reserves and R/P ratio for Canada includes Canadian oil sands. Reserves and R/P ratio for Venezuela includes the Orinoco Belt. Saudi Arabia's oil reserves include NGLs from 2017. Total proved reserves of oil are generally taken to be those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known reservoirs under existing economic and operating conditions. The data series for total proved oil reserves does not necessarily meet the definitions, guidelines and practices used for determining proved reserves at company level, for instance as published by the US Securities and Exchange Commission, nor does it necessarily represent BP's view of proved reserves by country. Reserves-to-production (R/P) ratio: If the reserves remaining at the end of any year are divided by the production in that year, the result is the length of time that those remaining reserves would last if production were to continue at that rate. Reserves include gas condensate and natural gas liquids (NGLs) as well as crude oil. 2023-07-17 14:29:31 2023-12-14 12:11:34     1980-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 28655 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     oil_reserves grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#oil_reserves   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"
    }
]
            
737502 Oil annual production tonnes 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:29:31 2023-12-14 12:11:33     1965-2022 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29201 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     oil_production grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#oil_production   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"
    }
]
            
737501 Oil reserves/production ratio years   2023-07-17 14:29:31 2023-12-14 12:11:33     1980-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29200 years 
{
    "unit": "years",
    "shortUnit": "years"
}
 0     oil_left grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#oil_left   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"
    }
]
            
737500 Global reserves of gas cubic meters Total proved reserves of natural gas is generally taken to be those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known reservoirs under existing economic and operating conditions. The data series for total proved natural gas does not necessarily meet the definitions, guidelines and practices used for determining proved reserves at company level, for instance as published by the US Securities and Exchange Commission, nor does it necessarily represent BP's view of proved reserves by country. Reserves-to-production (R/P) ratio: If the reserves remaining at the end of any year are divided by the production in that year, the result is the length of time that those remaining reserves would last if production were to continue at that rate. As far as possible, the data represents standard cubic metres (measured at 15C and 1013 mbar) and has been standardized using a gross calorific value (GCV) of 40 MJ/m3. 2023-07-17 14:29:31 2023-12-14 12:11:33     1980-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 28655 cubic meters 
{
    "unit": "cubic meters",
    "shortUnit": "cubic meters"
}
 0     gas_reserves grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#gas_reserves   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"
    }
]
            
737499 Gas annual production cubic meters Excludes gas flared or recycled. Includes natural gas produced for Gas-to-Liquids transformation. As far as possible, the data represents standard cubic metres (measured at 15C and 1013 mbar); as they are derived directly from measures of energy content using an average conversion factor and have been standardized using a Gross Calorific Value (GCV) of 40 MJ/m3, they do not necessarily equate with gas volumes expressed in specific national terms. 2023-07-17 14:29:31 2023-12-14 12:11:33     1970-2022 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29201 cubic meters 
{
    "unit": "cubic meters",
    "shortUnit": "cubic meters"
}
 0     gas_production grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#gas_production   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"
    }
]
            
737498 Gas reserves/production ratio years   2023-07-17 14:29:31 2023-12-14 12:11:33     1980-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29200 years 
{
    "unit": "years",
    "shortUnit": "years"
}
 0     gas_left grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#gas_left   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"
    }
]
            
737497 Global reserves of coal tonnes Total proved reserves of coal are generally taken to be those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known reservoirs under existing economic and operating conditions. The data series for total proved coal reserves does not necessarily meet the definitions, guidelines and practices used for determining proved reserves at company level, for instance as published by the US Securities and Exchange Commission, nor does it necessarily represent BP's view of proved reserves by country. Reserves-to-production (R/P) ratio: If the reserves remaining at the end of any year are divided by the production in that year, the result is the length of time that those remaining reserves would last if production were to continue at that rate. 2023-07-17 14:29:31 2023-12-14 12:11:32     2020-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 28655 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     coal_reserves grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#coal_reserves   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"
    }
]
            
737496 Coal annual production tonnes 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:29:31 2023-12-14 12:11:32     1981-2022 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29201 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     coal_production grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#coal_production   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"
    }
]
            
737495 Coal reserves/production ratio years   2023-07-17 14:29:31 2023-12-14 12:11:32     2020-2020 Fossil fuel reserves/production ratio (Energy Institute, 2023) 6128 Energy Institute Statistical Review of World Energy (2023) 29200 years 
{
    "unit": "years",
    "shortUnit": "years"
}
 0     coal_left grapher/energy/2023-07-10/fossil_fuel_reserves_production_ratio/fossil_fuel_reserves_production_ratio#coal_left   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"
    }
]
            

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