Dataset: UK Historical Electricity (DUKES, 2023c)

About this Dataset

UK Historical Electricity (DUKES, 2023c)

All data prior to 1985 (and prior to 1965 in the case of renewables), is sourced from the Digest of UK Energy Statistics (DUKES), published by the UK's Department for Business, Energy & Industrial Strategy.

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.

Tables

Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_1

12.7 KB
103 rows
12 columns


CREATE TABLE owid_uk_historical_electricity_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "coal_generation" FLOAT,
  "gas_generation" FLOAT,
  "hydro_generation" FLOAT,
  "net_imports" FLOAT,
  "nuclear_generation" FLOAT,
  "oil_generation" FLOAT,
  "other_renewables_generation" FLOAT,
  "solar_generation" FLOAT,
  "total_generation" FLOAT,
  "wind_generation" FLOAT
);

UK's Historical Electricity Data

@owid.uk_historical_electricity.owid_uk_historical_electricity_2

13.42 KB
102 rows
13 columns


CREATE TABLE owid_uk_historical_electricity_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "all_sources" FLOAT,
  "coal" FLOAT,
  "electricity_generation" FLOAT,
  "gas" FLOAT,
  "hydro" FLOAT,
  "implied_efficiency" FLOAT,
  "net_imports" FLOAT,
  "nuclear" FLOAT,
  "oil" FLOAT,
  "other" FLOAT,
  "wind_and_solar" FLOAT
);

UK Historical Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_3

12.7 KB
103 rows
12 columns


CREATE TABLE owid_uk_historical_electricity_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "coal_generation" FLOAT,
  "gas_generation" FLOAT,
  "hydro_generation" FLOAT,
  "net_imports" FLOAT,
  "nuclear_generation" FLOAT,
  "oil_generation" FLOAT,
  "other_renewables_generation" FLOAT,
  "solar_generation" FLOAT,
  "total_generation" FLOAT,
  "wind_generation" FLOAT
);

UK Historical Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_4

13.45 KB
103 rows
13 columns


CREATE TABLE owid_uk_historical_electricity_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "all_sources" FLOAT,
  "coal" FLOAT,
  "electricity_generation" FLOAT,
  "gas" FLOAT,
  "hydro" FLOAT,
  "implied_efficiency" FLOAT,
  "net_imports" FLOAT,
  "nuclear" FLOAT,
  "oil" FLOAT,
  "other" FLOAT,
  "wind_and_solar" FLOAT
);

UK Historical Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_5

12.75 KB
104 rows
12 columns


CREATE TABLE owid_uk_historical_electricity_5 (
  "country" VARCHAR,
  "year" INTEGER,
  "coal_generation" FLOAT,
  "gas_generation" FLOAT,
  "hydro_generation" FLOAT,
  "net_imports" FLOAT,
  "nuclear_generation" FLOAT,
  "oil_generation" FLOAT,
  "other_renewables_generation" FLOAT,
  "solar_generation" FLOAT,
  "total_generation" FLOAT,
  "wind_generation" FLOAT
);

UK Historical Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_6

12.75 KB
104 rows
12 columns


CREATE TABLE owid_uk_historical_electricity_6 (
  "country" VARCHAR,
  "year" INTEGER,
  "coal_generation" FLOAT,
  "gas_generation" FLOAT,
  "hydro_generation" FLOAT,
  "net_imports" FLOAT,
  "nuclear_generation" FLOAT,
  "oil_generation" FLOAT,
  "other_renewables_generation" FLOAT,
  "solar_generation" FLOAT,
  "total_generation" FLOAT,
  "wind_generation" FLOAT
);

UK Historical Electricity

@owid.uk_historical_electricity.owid_uk_historical_electricity_7

12.82 KB
105 rows
12 columns


CREATE TABLE owid_uk_historical_electricity_7 (
  "country" VARCHAR,
  "year" INTEGER,
  "coal_generation" FLOAT,
  "gas_generation" FLOAT,
  "hydro_generation" FLOAT,
  "net_imports" FLOAT,
  "nuclear_generation" FLOAT,
  "oil_generation" FLOAT,
  "other_renewables_generation" FLOAT,
  "solar_generation" FLOAT,
  "total_generation" FLOAT,
  "wind_generation" FLOAT
);