Long term demand forecast

This is our 2-52 weeks ahead national demand forecast, updated on ad hoc basis. National Demand is Great Britain’s generation requirement and is the sum of metered generation based on National Grid ESO’s operational generation metering, but excludes generation required to meet station load, pump storage pumping and interconnector exports.

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=903302b4-b577-4228-a347-b9917568b4e1&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "903302b4-b577-4228-a347-b9917568b4e1" LIMIT 5`

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

var data = {
  resource_id: '903302b4-b577-4228-a347-b9917568b4e1', // 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=903302b4-b577-4228-a347-b9917568b4e1&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

calendar_year

Title	calendar_year
Type	integer
Description	The calendar year the demand is forecast to occur.
Comment
Example	2023
Unit

financial_year

Title	financial_year
Type	integer
Description	The financial year the demand is forecast to occur.
Comment
Example	2023
Unit

ESIWK

Title	ESIWK
Type	integer
Description	The ESI week the forecast is for.
Comment
Example	24
Unit

CDATE_peak

Title	CDATE_peak
Type	date
Description	The date of the peak demand during that ESI week.
Comment
Example	13/06/2023
Unit

tsd_peak

Title	tsd_peak
Type	integer
Description	The peak demand during that ESI week.
Comment
Example	27774
Unit	MW

tsd_min

Title	tsd_min
Type	integer
Description	The minimum demand during that ESI week.
Comment
Example	16016
Unit	MW

day_min

Title	day_min
Type	integer
Description	The minimum daytime demand during that ESI week.
Comment
Example	18166
Unit	MW

night_min

Title	night_min
Type	integer
Description	The minimum over night during that ESI week.
Comment
Example	16016
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

Long term demand forecast

CKAN Data API

Data Explorer

Data Explorer

Table Information

calendar_year

financial_year

ESIWK

CDATE_peak

tsd_peak

tsd_min

day_min

night_min