Historic 2-14 Day Ahead Demand Forecasts

All historic 2-14 day ahead demand forecasts from 2020 to the most recent forecast.

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=4dd712a2-ee2c-455d-a9c0-9d3564c80fa0&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "4dd712a2-ee2c-455d-a9c0-9d3564c80fa0" LIMIT 5`

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

var data = {
  resource_id: '4dd712a2-ee2c-455d-a9c0-9d3564c80fa0', // 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=4dd712a2-ee2c-455d-a9c0-9d3564c80fa0&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

DAYSAHEAD

Title	2-14 Day Ahead Demand Forecast
Type	integer
Description	Unique number describing what day the demand forecast is for i .e. "4" for 4 Day Ahead forecast.
Comment
Example	4
Unit

TARGETDATE

Title	Forecast Date
Type	date
Description	The date the demand forecast is for i.e. D+4 for 4 Day Ahead.
Comment
Example	20200930
Unit

FORECASTDEMAND

Title	Demand Forecast
Type	integer
Description	National 2-14 day ahead demand forecast values.
Comment
Example	32610
Unit	MW

CARDINALPOINT

Title	Cardinal Point (CP)
Type	string
Description	Electricity demand fluctuates during a day depending on how much energy people, businesses and industries are using at that moment in time. As this electricity demand goes up and down we get characteristic peaks and troughs, with some of these peaks and troughs appearing every single day at similar times. These we call cardinal points and are the points during the day that we forecast demand for.
Comment
Example	DP
Unit

CP_TYPE

Title	Cardinal Point (CP) Type
Type	string
Description	Fixed, Trough, Peak  , Cardinal point (CP) can either be Fixed i.e occur at a fix time during the day, Trough i.e. minimum demands during the day or Peak i.e maximum demands during the day.
Comment
Example	P
Unit

CP_ST_TIME

Title	Cardinal Point (CP) Standard Time
Type	integer
Description	Time UTC  , The time when a particular cardinal point (CP) starts during the day.
Comment
Example	1700
Unit

CP_END_TIME

Title	Cardinal Point (CP) End Time
Type	integer
Description	Time UTC  , The time when a particular cardinal point (CP) ends during the day.
Comment
Example	1930
Unit

F_Point

Title	Forecasting Point
Type	string
Description	Forecasts of forecasting points  , Publishing forecasts of forecasting points: overnight demand minimum, daytime demand maximum, daytime demand minimum and evening demand maximum.
Comment
Example	DM
Unit

FORECAST_TIMESTAMP

Title
Type	datetime
Description
Comment
Example
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Historic 2-14 Day Ahead Demand Forecasts

CKAN Data API

Data Explorer

Data Explorer

Table Information

DAYSAHEAD

TARGETDATE

FORECASTDEMAND

CARDINALPOINT

CP_TYPE

CP_ST_TIME

CP_END_TIME

F_Point

FORECAST_TIMESTAMP