Daily BSUoS Forecast 2019-20

The Electricity System Operator (ESO) publishes historic and future Balancing Services Use of System (BSUoS) charge forecast for the financial year.

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=c1be6c7c-c36d-46cb-8038-098075599bb0&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "c1be6c7c-c36d-46cb-8038-098075599bb0" LIMIT 5`

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

var data = {
  resource_id: 'c1be6c7c-c36d-46cb-8038-098075599bb0', // 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=c1be6c7c-c36d-46cb-8038-098075599bb0&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	Date for historic outurn and day ahead forecast. Given in (Coordinated Universal Time) UTC or UTC+1 during British Summer Time.
Comment
Example	01-Apr-19
Unit

SP

Title	Settlement Period
Type	integer
Description	The half hourly period at which balancing service use of system occurred. Settlement period 1 runs from 00:00-00:30.
Comment	On the first day of BST when clock change happens there will be 46 half hours (SP's) in the day. Similarly the first day of GMT will have 50 half hours as the clock goes back 1 hour at 2am.
Example	15
Unit	Number

BSUoS £/MWh

Title	Balancing Service Use of System / megawatt hour
Type	number
Description	Balancing Service Use of System, price in megawatt hour per settlement period.
Comment
Example	2.19
Unit	£/MWh

Half hourly cost £

Title	Half hourly cost
Type	integer
Description	Half hourly cost to balance the system per settlement hour.
Comment
Example	44296
Unit	£

Half hourly volume MWh

Title	Half hourly volume Megawatt hour
Type	integer
Description	Volume in megawatt hour per settlement period.
Comment
Example	23253
Unit	MWh

For any queries or feedback please contact [email protected]

You are now signed in

Daily BSUoS Forecast 2019-20

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SP

BSUoS £/MWh

Half hourly cost £

Half hourly volume MWh