Balancing Service Contract Enactment 21-22 (Pre June 2021)

The data shows the balancing service contract that have been enacted by the trading team. The volume and price is related to the enactment decision, there might be other payment term in the contact if there is no impact on to the enactment decision, they won't be shown. (i.e. availability payment).

This data will assist market participant to gain better visibility to the balancing service contract enactment. We are also working closely with our counterparties to make more balancing service contract available.

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=f75a1dcb-de6e-4c20-8407-e37d5e67cf79&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "f75a1dcb-de6e-4c20-8407-e37d5e67cf79" LIMIT 5`

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

var data = {
  resource_id: 'f75a1dcb-de6e-4c20-8407-e37d5e67cf79', // 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=f75a1dcb-de6e-4c20-8407-e37d5e67cf79&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Record

Title	Record
Type	text
Description	Identifier for the contract enactment action.
Comment	Format is given as YYYY_MM_DD-XX, where xx is the sequencial number for the day.
Example	2020_12_16-1
Unit	N/A

Counterparty

Title	Counterparty
Type	string
Description	Counterparty name.
Comment	Counterparty who we hold the contract rights with.
Example	Sgurrenergy
Unit	N/A

Unit

Title	Unit
Type	string
Description	Name of the unit or units
Comment	Some units don't have equivalent BMU name, we will try our best to make it as clear as possible
Example	Hydros
Unit	N/A

Start Time

Title	Start Time
Type	datetime
Description	Start date time of a given contract enactment
Comment	N/A
Example	2020-12-10T23:00:00
Unit	N/A

End Time

Title	End Time
Type	datetime
Description	End date time of a given contract enactment.
Comment	N/A
Example	2020-11-26T08:00:00
Unit	N/A

Volume

Title	Volume
Type	number
Description	Average volume of the contract.
Comment	Positive volume indicating more active power output to grid, negative volume shows less power output
Example	-5.4
Unit	MW

Price

Title	Price
Type	number
Description	Price of the contract enactment action.
Comment	Negative price indicates National Grid ESO paying for the services
Example	-100
Unit	£/MWh

Notes

Title	Notes
Type	string
Description	Additional information to the contract enactement action.
Comment	Normally indicates what the contract enactement is for, also with some other details
Example	Constraints; Reactive
Unit	N/A

Last Updated

Title	Last Updated
Type	datetime
Description	The date and time of when the data was last updated.
Comment	N/A
Example	2020-11-26T06:00:00
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

Balancing Service Contract Enactment 21-22 (Pre June 2021)

CKAN Data API

Data Explorer

Data Explorer

Table Information

Record

Counterparty

Unit

Start Time

End Time

Volume

Price

Notes

Last Updated