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

10 rows where datasetId = 6588 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, 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
943852 Electricity generation from wind terawatt-hours   2024-06-25 14:50:28 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Wind",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     wind_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#wind_generation   2 major   Electricity generation from wind power   Ember and Energy Institute   Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 02e8d7347ccec9bec643b965da6fa214 2aff95524f293a9d719469b6696d4e94
943851 Total electricity generation terawatt-hours   2024-06-25 14:50:28 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Total electricity generation",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     total_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#total_generation   2 major   Total electricity generation       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 c9a57e7f44d755d774a0bec434fcaeeb 9e0c754f12799449891ca4842a4890ff
943850 Electricity generation from solar terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Solar",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     solar_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#solar_generation   2 major   Electricity generation from solar power   Ember and Energy Institute   Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 e2de8708422675469635cb8f85f199d3 2068312caf27b342dd21b26c2912696a
943847 Electricity generation from other renewables terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Other renewables",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     other_renewables_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#other_renewables_generation   2 major   Electricity generation from other renewables   Ember and Energy Institute   Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 12a0c0b584aaa60421291953d235494a e9c24981f3a21b3253559a6d8cfc0eca
943846 Electricity generation from oil terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     oil_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#oil_generation   2 major   Electricity generation from oil       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 766847bc078c17e256fd5638bcb203e4 098b5340005cbe83cbd26d0d2eef1c50
943844 Electricity generation from nuclear terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:11     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Nuclear",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     nuclear_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#nuclear_generation   2 major   Electricity generation from nuclear power       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 6fa511fcaef6010d5ce37ca1455439c1 0a176969b4943670f181cd5d5342a9f0
943842 Net electricity imports terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:10     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Net electricity imports",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     net_imports grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#net_imports   2 major   Net electricity imports       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 638a27cba3b835bc400231f1aac1a28c 98514b7c93fd571d4410f8cb0dfeb0ad
943836 Electricity generation from gas terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:10     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Natural gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     gas_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#gas_generation   2 major   Electricity generation from natural gas       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 e67fc15e6b2e24a3ee41dee77755fd73 ef851400f38576c63c7c68a0dfdf4c3f
943834 Electricity generation from hydropower terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:10     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Hydropower",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     hydro_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#hydro_generation   2 major   Electricity generation from hydropower       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 6649c44b4cb61c5458dd9ad0cb796754 9f5acb20ce9924b5c8958956112fd785
943832 Electricity generation from coal terawatt-hours   2024-06-25 14:50:27 2024-07-25 23:20:10     1920-2023 UK historical electricity 6588   TWh 
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     coal_generation grapher/energy/2024-06-20/uk_historical_electricity/uk_historical_electricity#coal_generation   2 major   Electricity generation from coal       Measured in terawatt-hours.   
[]
 All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from (DUKES). All other data is sourced from the the Energy Institute (EI) Statistical Review of World Energy and Ember's Yearly electricity data. Where data from Ember is available for a given year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.       float 
[]
 1ddc5d5886b5c14a847e00d1cd43b307 aca23712e9d86cfa6749b030b3261408

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