Dataset: UK Energy Data 2020-23

About this Dataset

UK Energy Data 2020-23

This dataset is a condensed collection of net generation and demand data for the UK between the periods of 2020 - 2023. This dataset was compiled in order to assist with the ESO Battery Forecasting Hackathon and as such is not a full unabridged collection.

The collection contains three sets of data, each being filtered more than the last to drop values which are believed to already be highly correlated. This was done to test model accuracy changes by reducing features.

The total collection of column categories are as follows:

Datetime
Net Demand
Total System Demand
England Wales Demand
Net Generation
Gas Generation
Coal Generation
Nuclear Generation
Hydropower Generation
Biomass Generation
Solar PV Generation
Solar PV Capacity
Other generation
Pumped Storage Generation
English Wind Generation
Scottish Wind Generation
UK Wind Generation
Wind Capacity
Imports
IFA flow (interconnector)
IFA2 Flow
Britned Flow
Moyle Flow
East-West Flow
Nemo Flow
NSL Flow
Eleclink Flow
Net Interconnector flows
Grid Carbon Intensity
Low carbon Generation
Zero carbon Generation
Renewables Generation
Fossil Fuel Generation
Gas percent gen
Nuclear percent gen
Wind percent gen
Hydro percent gen
Imports percent gen
Biomass percent gen
Other percent gen
Solar percent gen
Storage percent gen
Generation percent gen
Low Carbon percent gen
Zero Carbon percent gen
Renewable percent gen
Fossil Fuel percent gen

Tables

Uk Fuel Mix

@kaggle.danielparke_uk_energy_data_2020_23.uk_fuel_mix

4.7 MB
49393 rows
49 columns


CREATE TABLE uk_fuel_mix (
  "datetime" TIMESTAMP,
  "net_demand" BIGINT,
  "total_system_demand" BIGINT,
  "england_wales_demand" BIGINT,
  "generation" BIGINT,
  "gas" BIGINT,
  "coal" BIGINT,
  "nuclear" BIGINT,
  "scot_wind" DOUBLE,
  "eng_wind" DOUBLE,
  "uk_wind" BIGINT,
  "wind_capacity" BIGINT,
  "hydro" BIGINT,
  "imports" 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,
  "net_interc_flow" BIGINT,
  "biomass" BIGINT,
  "other" BIGINT,
  "solar" BIGINT,
  "solar_cap" BIGINT,
  "pumped_storage" BIGINT,
  "storage" BIGINT,
  "carbon_intensity" BIGINT,
  "low_carbon" BIGINT,
  "zero_carbon" BIGINT,
  "renewable" BIGINT,
  "fossil" BIGINT,
  "gas_perc" DOUBLE,
  "coal_perc" DOUBLE,
  "nuclear_perc" DOUBLE,
  "wind_perc" DOUBLE,
  "hydro_perc" DOUBLE,
  "imports_perc" DOUBLE,
  "biomass_perc" DOUBLE,
  "other_perc" DOUBLE,
  "solar_perc" DOUBLE,
  "storage_perc" DOUBLE,
  "generation_perc" BIGINT,
  "low_carbon_perc" DOUBLE,
  "zero_carbon_perc" DOUBLE,
  "renewable_perc" DOUBLE,
  "fossil_perc" DOUBLE
);

Uk Fuel Mix Reduced

@kaggle.danielparke_uk_energy_data_2020_23.uk_fuel_mix_reduced

2.29 MB
49393 rows
16 columns


CREATE TABLE uk_fuel_mix_reduced (
  "datetime" TIMESTAMP,
  "dem_gen_diff" BIGINT,
  "gas" BIGINT,
  "coal" BIGINT,
  "nuclear" BIGINT,
  "scot_wind" DOUBLE,
  "eng_wind" DOUBLE,
  "uk_wind" BIGINT,
  "hydro" BIGINT,
  "imports" BIGINT,
  "biomass" BIGINT,
  "other" BIGINT,
  "solar" BIGINT,
  "pumped_storage" BIGINT,
  "storage" BIGINT,
  "carbon_intensity" BIGINT
);

Uk Fuel Mix Reducedmore

@kaggle.danielparke_uk_energy_data_2020_23.uk_fuel_mix_reducedmore

1.43 MB
49393 rows
8 columns


CREATE TABLE uk_fuel_mix_reducedmore (
  "datetime" TIMESTAMP,
  "dem_gen_diff" BIGINT,
  "uk_wind" BIGINT,
  "carbon_intensity" BIGINT,
  "low_carbon" BIGINT,
  "zero_carbon" BIGINT,
  "renewable" BIGINT,
  "fossil" BIGINT
);