Day Ahead Half Hourly Demand Forecast Performance

This file contains historic half hourly day ahead national demand forecast, alongside the outturn values, adjustments for TRIAD avoidance estimates and Absolute Percentage Error (APE) for each half hour from Apr 2021 onwards. This file will be updated on a monthly basis.

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=08e41551-80f8-4e28-a416-ea473a695db9&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "08e41551-80f8-4e28-a416-ea473a695db9" LIMIT 5`

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

var data = {
  resource_id: '08e41551-80f8-4e28-a416-ea473a695db9', // 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=08e41551-80f8-4e28-a416-ea473a695db9&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Month

Title	Month
Type	string
Description	Month in which the demand outturn occurred.
Comment
Example	Apr
Unit

Date

Title	Date
Type	date
Description	Date on which the demand outturn occurred.
Comment
Example	2021-04-18
Unit

Datetime

Title	Datetime
Type	datetime
Description	Datetime at which the demand outturn occurred.
Comment	Datetime follows clock changes (BST when UK was in BST and vice versa).
Example	2021-04-18T02:30:00Z
Unit	GMT/BST

Settlement_Period

Title	Settlement Period
Type	integer
Description	Settlement Period at which the demand outturn occurred.
Comment
Example	5
Unit	Settlement Periods

Demand_Forecast

Title	Demand Forecast
Type	integer
Description	National demand forecast for the specified datetime.
Comment
Example	23088
Unit	MW

Demand_Outturn

Title	Demand Outturn
Type	integer
Description	National demand outturn for the specified datetime.
Comment
Example	23502
Unit	MW

TRIAD_Avoidance_Estimate

Title	TRIAD Avoidance Estimate
Type	integer
Description	TRIAD avoidance estimated to have taken place at the time of the demand outturn.
Comment	This will be 0 for all time periods when it is not TRIAD season.
Example	0
Unit	MW

TRIAD_Avoidance_Corrected_Demand_Outturn

Title	TRIAD Avoidance Corrected Demand Outturn
Type	integer
Description	National demand outturn after adding on any estimated TRIAD avoidance.
Comment	This will be unchanged from the demand outturn when it is not TRIAD season.
Example	23502
Unit	MW

APE

Title	Absolute Percentage Error
Type	number
Description	Absolute Percentage Error of the forecast.
Comment
Example	1.8
Unit	%

Absolute_Error

Title	Absolute Error
Type	integer
Description	Absolute Error of the forecast
Comment	N/A
Example	132
Unit	MW

Publish_Datetime

Title	Publish Datetime
Type	datetime
Description	The datetime at which the forecast was made.
Comment	Datetime follows clock changes (BST when UK was in BST and vice versa).
Example	2021-04-17T08:45:00Z
Unit	GMT/BST

For any queries or feedback please contact [email protected]

You are now signed in

Day Ahead Half Hourly Demand Forecast Performance

CKAN Data API

Data Explorer

Data Explorer

Table Information

Month

Date

Datetime

Settlement_Period

Demand_Forecast

Demand_Outturn

TRIAD_Avoidance_Estimate

TRIAD_Avoidance_Corrected_Demand_Outturn

APE

Absolute_Error

Publish_Datetime