Electricity Supply Data table (ES1) 2022

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=90c4a0e8-22fd-4bda-b5bd-14a540893a98&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "90c4a0e8-22fd-4bda-b5bd-14a540893a98" LIMIT 5`

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

var data = {
  resource_id: '90c4a0e8-22fd-4bda-b5bd-14a540893a98', // 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=90c4a0e8-22fd-4bda-b5bd-14a540893a98&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Connection

Title	Network connection level
Type	string
Description	Distributed, Transmission or non-network connected
Comment	n/a
Example	n/a
Unit	n/a

Scenario

Title	FES Scenario
Type	string
Description	The FES Scenario names
Comment	n/a
Example	Leading the Way,Five Year Forecast,Steady Progression,System Transformation,Consumer Transformation
Unit	n/a

Variable

Title	FES variable
Type	string
Description	Scenario variable and unit of measurement
Comment	The Variable could be: Capacity (MW); Generation (TWh); Demand (MW); Consumption (TWh); Export (TWh); Demand (TWh); Import (TWh); Netflows (TWh); Storage Capacity (GWh); CO2 emissions (mt CO2); CO2 Intensity of Generation (gCO2/kWh).
Example	Import (TWh)
Unit	N/A

Title	Category
Type	string
Description	Type of variable
Comment	n/a
Example	Renewable, Interconnectors, Low Carbon, Storage, Thermal
Unit	n/a

Type

Title	Type of variable
Type	string
Description	Type of variable
Comment	n/a
Example	Offshore Wind
Unit	n/a

SubType

Title	SubType
Type	string
Description	Sub Type of variable
Comment	n/a
Example	n/a
Unit	n/a

2021

Title	2021
Type	integer
Description	FES Scenario Data for year 2021
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2022

Title	2022
Type	integer
Description	FES Scenario Data for year 2022
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2023

Title	2023
Type	integer
Description	FES Scenario Data for year 2023
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2024

Title	2024
Type	integer
Description	FES Scenario Data for year 2024
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2025

Title	2025
Type	integer
Description	FES Scenario Data for year 2025
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2026

Title	2026
Type	integer
Description	FES Scenario Data for year 2026
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2027

Title	2027
Type	integer
Description	FES Scenario Data for year 2027
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2028

Title	2028
Type	integer
Description	FES Scenario Data for year 2028
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2029

Title	2029
Type	integer
Description	FES Scenario Data for year 2029
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2030

Title	2030
Type	integer
Description	FES Scenario Data for year 2030
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2031

Title	2031
Type	integer
Description	FES Scenario Data for year 2031
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2032

Title	2032
Type	integer
Description	FES Scenario Data for year 2032
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2033

Title	2033
Type	integer
Description	FES Scenario Data for year 2033
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2034

Title	2034
Type	integer
Description	FES Scenario Data for year 2034
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2035

Title	2035
Type	integer
Description	FES Scenario Data for year 2035
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2036

Title	2036
Type	integer
Description	FES Scenario Data for year 2036
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2037

Title	2037
Type	integer
Description	FES Scenario Data for year 2037
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2038

Title	2038
Type	integer
Description	FES Scenario Data for year 2038
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2039

Title	2039
Type	integer
Description	FES Scenario Data for year 2039
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2040

Title	2040
Type	integer
Description	FES Scenario Data for year 2040
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2041

Title	2041
Type	integer
Description	FES Scenario Data for year 2041
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2042

Title	2042
Type	integer
Description	FES Scenario Data for year 2042
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2043

Title	2043
Type	integer
Description	FES Scenario Data for year 2043
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2044

Title	2044
Type	integer
Description	FES Scenario Data for year 2044
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2045

Title	2045
Type	integer
Description	FES Scenario Data for year 2045
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2046

Title	2046
Type	integer
Description	FES Scenario Data for year 2046
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2047

Title	2047
Type	integer
Description	FES Scenario Data for year 2047
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2048

Title	2048
Type	integer
Description	FES Scenario Data for year 2048
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2049

Title	2049
Type	integer
Description	FES Scenario Data for year 2049
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

2050

Title	2050
Type	integer
Description	FES Scenario Data for year 2050
Comment	n/a
Example	n/a
Unit	Unit contained within Variable

For any queries or feedback please contact [email protected]

You are now signed in

Electricity Supply Data table (ES1) 2022

CKAN Data API

Data Explorer

Data Explorer

Table Information

Connection

Scenario

Variable

Category

Type

SubType

2021

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