Disaggregated BSAD 2013-14

This is the data for financial year 2013-14.

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=a01c3587-0e29-4e8b-81e6-37a32776fd8a&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "a01c3587-0e29-4e8b-81e6-37a32776fd8a" LIMIT 5`

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

var data = {
  resource_id: 'a01c3587-0e29-4e8b-81e6-37a32776fd8a', // 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=a01c3587-0e29-4e8b-81e6-37a32776fd8a&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	Date and time at which balancing service adjustments occurred. Given in (Coordinated Universal Time) UTC or UTC+1 during British Summer Time.
Comment
Example	30/09/2018
Unit

Settlement Period

Title	Settlement Period
Type	integer
Description	The half hourly period at which balancing service adjustments occurred. Settlement period 1 runs from 00:00-00:30.
Comment
Example	1
Unit

Disaggregated BSAD Volume (MWh)

Title	Disaggregated BSAD Volume
Type	number
Description	The volume of balancing service adjustments – calculated by multiplying the MW volume by 0.5 (as given for a half hour settlement period).
Comment
Example	120
Unit	MWh

Disaggregated BSAD Cost (£)

Title	Disaggregated BSAD Cost
Type	number
Description	The cost associated with the volume in the previous column.
Comment
Example	3.36
Unit	£

Trade Flag System (T) / Energy (F)

Title	Trade Flag System (T) / Energy (F)
Type	boolean
Description	A flag to denote whether the adjustment was taken due to a system issue such as a constraint, or an energy issue (balancing supply and demand).
Comment
Example	F
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Disaggregated BSAD 2013-14

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

Settlement Period

Disaggregated BSAD Volume (MWh)

Disaggregated BSAD Cost (£)

Trade Flag System (T) / Energy (F)