Dataset: Electricity Consumption UK 2009-2024

About this Dataset

Electricity Consumption UK 2009-2024

National Grid ESO is the electricity system operator for Great Britain. They have gathered information of the electricity demand in Great Britain from 2009. The is updated twice an hour, which means 48 entries per day. This makes this dataset ideal for time series forecasting.

File information

The dataset consists of three type of files:

Historic_demand_year_20xx.csv: electricity demand in that year
Historic_demand_year_2009_2024.csv: all the yearly datasets merged in one
Historic_demand_year_2009_2024_noNaN.csv: same as above, but NaN values have been removed and the date includes the hour as opposed to only the day

Columns

The columns in the dataset are:

SETTLEMET_DATA: date in format dd/mm/yyyy
SETTLEMENT_PERIOD: half hourly period for the historic outtunr occurred
ND (National Demand). National Demand is the sum of metered generation, but excludes generation required to meet station load, pump storage pumping and interconnector exports. National Demand is calculated as a sum of generation based on National Grid ESO operational generation metering. Measured in MW.
TSD (Transmission System Demand). Transmission System Demand is equal to the ND plus the additional generation required to meet station load, pump storage pumping and interconnector exports. Measured in MW.
ENGLAND_WALES_DEMAND. England and Wales Demand, as ND above but on an England and Wales basis. Measured in MW.
EMBEDDED_WIND_GENERATION. This is an estimate of the GB wind generation from wind farms which do not have Transmission System metering installed. These wind farms are embedded in the distribution network and invisible to National Grid ESO. Their effect is to suppress the electricity demand during periods of high wind. The true output of these generators is not known so an estimate is provided based on National Grid ESO’s best model. Measured in MW.
EMBEDDED_WIND_CAPACITY. This is National Grid ESO’s best view of the installed embedded wind capacity in GB. This is based on publicly available information compiled from a variety of sources and is not the definitive view. It is consistent with the generation estimate provided above. Measured in MW
EMBEDDED_SOLAR_GENERATION. This is an estimate of the GB solar generation from PV panels. These are embedded in the distribution network and invisible to National Grid ESO. Their effect is to suppress the electricity demand during periods of high radiation. The true output of these generators is not known so an estimate is provided based on National Grid ESO’s best model. Measured in MW.
EMBEDDED_SOLAR_CAPACITY. As embedded wind capacity above, but for solar generation. Measured in MW.
NON_BM_STOR (Non-Balancing Mechanism SHort-Term Operating Reserve). For units that are not included in the ND generator definition. This can be in the form of generation or demand reduction. Measured in MW.
PUMP_STORAGE_PUMPING. The demand due to pumping at hydro pump storage units; the -ve signifies pumping load.
IFA_FLOW (IFA Interconnector Flow). The flow on on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
IFA2_FLOW (IFA Interconnector Flow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
MOYLE_FLOW (Moyle Interconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
EAST_WEST_FLOW (East West Innterconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
NEMO_FLOW (Nemo Interconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
NSL_FLOW (North Sea Link Interconnector Flow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
ELCLINK_FLOW. Blank

Tables

Historic Demand 2009–2024

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_2009_2024

5.95 MB
279264 rows
24 columns


CREATE TABLE historic_demand_2009_2024 (
  "unnamed_0" BIGINT,
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" DOUBLE,
  "eleclink_flow" DOUBLE,
  "scottish_transfer" DOUBLE,
  "viking_flow" DOUBLE,
  "greenlink_flow" DOUBLE,
  "is_holiday" BIGINT
);

Historic Demand 2009–2024 Nonan

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_2009_2024_nonan

6.53 MB
278512 rows
19 columns


CREATE TABLE historic_demand_2009_2024_nonan (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "period_hour" VARCHAR,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "is_holiday" BIGINT
);

Historic Demand Year 2009

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2009

379.71 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2009 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2010

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2010

381.46 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2010 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2011

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2011

396.77 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2011 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2012

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2012

407.74 KB
17568 rows
17 columns


CREATE TABLE historic_demand_year_2012 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2013

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2013

422.2 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2013 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2014

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2014

418.88 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2014 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2015

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2015

439.64 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2015 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2016

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2016

435.74 KB
17568 rows
17 columns


CREATE TABLE historic_demand_year_2016 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2017

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2017

452.41 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2017 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2018

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2018

446.94 KB
17520 rows
17 columns


CREATE TABLE historic_demand_year_2018 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT
);

Historic Demand Year 2019

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2019

466.8 KB
17520 rows
19 columns


CREATE TABLE historic_demand_year_2019 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT
);

Historic Demand Year 2020

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2020

484.29 KB
17568 rows
19 columns


CREATE TABLE historic_demand_year_2020 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT
);

Historic Demand Year 2021

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2021

486.99 KB
17520 rows
19 columns


CREATE TABLE historic_demand_year_2021 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT
);

Historic Demand Year 2022

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2022

551.16 KB
17520 rows
19 columns


CREATE TABLE historic_demand_year_2022 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT
);

Historic Demand Year 2023

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2023

622.6 KB
17520 rows
21 columns


CREATE TABLE historic_demand_year_2023 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "scottish_transfer" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT,
  "viking_flow" BIGINT
);

Historic Demand Year 2024

@kaggle.albertovidalrod_electricity_consumption_uk_20092022.historic_demand_year_2024

587.48 KB
16320 rows
22 columns


CREATE TABLE historic_demand_year_2024 (
  "settlement_date" TIMESTAMP,
  "settlement_period" BIGINT,
  "nd" BIGINT,
  "tsd" BIGINT,
  "england_wales_demand" BIGINT,
  "embedded_wind_generation" BIGINT,
  "embedded_wind_capacity" BIGINT,
  "embedded_solar_generation" BIGINT,
  "embedded_solar_capacity" BIGINT,
  "non_bm_stor" BIGINT,
  "pump_storage_pumping" BIGINT,
  "scottish_transfer" BIGINT,
  "ifa_flow" BIGINT,
  "ifa2_flow" BIGINT,
  "britned_flow" BIGINT,
  "moyle_flow" BIGINT,
  "east_west_flow" BIGINT,
  "nemo_flow" BIGINT,
  "nsl_flow" BIGINT,
  "eleclink_flow" BIGINT,
  "viking_flow" BIGINT,
  "greenlink_flow" BIGINT
);