European Electricity Supply Data Table (ES2) 2023

The Future Energy Scenarios (FES) represent a range of different, credible ways to decarbonise our energy system as we strive towards the 2050 target. One of the FES outputs is an agreed set of data tables containing the European electricity supply values which are included in this dataset. The file is the 2023 version of the dataset.

CKAN Data API

Access resource data via a web API with powerful query support.
Further information in the main CKAN Data API and DataStore documentation.

The Data API can be accessed via the following actions of the CKAN action API.

Query
`https://api.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=6563801b-6da4-46e7-b147-3d81c0237779&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "6563801b-6da4-46e7-b147-3d81c0237779" LIMIT 5`

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: '6563801b-6da4-46e7-b147-3d81c0237779', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});

A simple ajax (JSONP) request to the data API using jQuery.

import urllib2
  url = 'https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=6563801b-6da4-46e7-b147-3d81c0237779&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Country

Title	Country
Type	string
Description	Country data is output from
Comment
Example	Austria
Unit	N/A

EU Scenario

Title	EU Scenario
Type	string
Description	European low carbon scenario
Comment
Example	EU CT
Unit	N/A

FES Scenario Alignment

Title	FES Scenario Alignment
Type	string
Description	The FES scenario's the data aligns to
Comment
Example	CT & LW
Unit	N/A

Variable

Title	Variable
Type	string
Description	Unit used to measure data point
Comment
Example	Capacity (MW)
Unit	N/A

Title	Category
Type	string
Description	High level category of data point
Comment
Example	Storage
Unit	N/A

Type

Title	Type
Type	string
Description	Mid level category of data point
Comment
Example	Storage
Unit	N/A

SubType

Title	SubType
Type	string
Description	Low level category of data point
Comment
Example	Battery
Unit	N/A

SubSubType

Title	SubSubType
Type	string
Description	Base level category of data point
Comment
Example	Battery
Unit	N/A

2022

Title	2022
Type	number
Description	Year of data for data item
Comment
Example	47637
Unit	N/A

2023

Title	2023
Type	number
Description	Year of data for data item
Comment
Example	47638
Unit	N/A

2024

Title	2024
Type	number
Description	Year of data for data item
Comment
Example	47639
Unit	N/A

2025

Title	2025
Type	number
Description	Year of data for data item
Comment
Example	47640
Unit	N/A

2026

Title	2026
Type	number
Description	Year of data for data item
Comment
Example	47641
Unit	N/A

2027

Title	2027
Type	number
Description	Year of data for data item
Comment
Example	47642
Unit	N/A

2028

Title	2028
Type	number
Description	Year of data for data item
Comment
Example	47643
Unit	N/A

2029

Title	2029
Type	number
Description	Year of data for data item
Comment
Example	47644
Unit	N/A

2030

Title	2030
Type	number
Description	Year of data for data item
Comment
Example	47645
Unit	N/A

2031

Title	2031
Type	number
Description	Year of data for data item
Comment
Example	47646
Unit	N/A

2032

Title	2032
Type	number
Description	Year of data for data item
Comment
Example	47647
Unit	N/A

2033

Title	2033
Type	number
Description	Year of data for data item
Comment
Example	47648
Unit	N/A

2034

Title	2034
Type	number
Description	Year of data for data item
Comment
Example	47649
Unit	N/A

2035

Title	2035
Type	number
Description	Year of data for data item
Comment
Example	47650
Unit	N/A

2036

Title	2036
Type	number
Description	Year of data for data item
Comment
Example	47651
Unit	N/A

2037

Title	2037
Type	number
Description	Year of data for data item
Comment
Example	47652
Unit	N/A

2038

Title	2038
Type	number
Description	Year of data for data item
Comment
Example	47653
Unit	N/A

2039

Title	2039
Type	number
Description	Year of data for data item
Comment
Example	47654
Unit	N/A

2040

Title	2040
Type	number
Description	Year of data for data item
Comment
Example	47655
Unit	N/A

2041

Title	2041
Type	number
Description	Year of data for data item
Comment
Example	47656
Unit	N/A

2042

Title	2042
Type	number
Description	Year of data for data item
Comment
Example	47657
Unit	N/A

2043

Title	2043
Type	number
Description	Year of data for data item
Comment
Example	47658
Unit	N/A

2044

Title	2044
Type	number
Description	Year of data for data item
Comment
Example	47659
Unit	N/A

2045

Title	2045
Type	number
Description	Year of data for data item
Comment
Example	47660
Unit	N/A

2046

Title	2046
Type	number
Description	Year of data for data item
Comment
Example	47661
Unit	N/A

2047

Title	2047
Type	number
Description	Year of data for data item
Comment
Example	47662
Unit	N/A

2048

Title	2048
Type	number
Description	Year of data for data item
Comment
Example	47663
Unit	N/A

2049

Title	2049
Type	number
Description	Year of data for data item
Comment
Example	47664
Unit	N/A

2050

Title	2050
Type	number
Description	Year of data for data item
Comment
Example	47665
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

European Electricity Supply Data Table (ES2) 2023

CKAN Data API

Data Explorer

Data Explorer

Table Information

Country

EU Scenario

FES Scenario Alignment

Variable

Category

Type

SubType

SubSubType

2022

2023

2024

2025

2026

2027

2028

2029

2030

2031

2032

2033

2034

2035

2036

2037

2038

2039

2040

2041

2042

2043

2044

2045

2046

2047

2048

2049

2050