Disaggregated BSAD 2024-25

This is the data for financial year 2024-25.

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=bc7cf2a8-6e25-4dad-ac2d-b9a97e968317&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "bc7cf2a8-6e25-4dad-ac2d-b9a97e968317" LIMIT 5`

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

var data = {
  resource_id: 'bc7cf2a8-6e25-4dad-ac2d-b9a97e968317', // 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=bc7cf2a8-6e25-4dad-ac2d-b9a97e968317&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date of balancing service adjustments
Type	timestamp
Description	Date at which balancing service adjustments occurred. Given in (Coordinated Universal Time) UTC or UTC+1 during British Summer Time.
Comment	N/A
Example	2019-01-04T00:00:00
Unit	N/A

SettlementPeriod

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

DisaggregatedBSADCost

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

DisaggregatedBSADVolume

Title	Disaggregated BSAD Volume
Type	float
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	N/A
Example	120.00
Unit	MWh

TradeFlag

Title	Trade Flag
Type	text
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	T = System and F = Energy
Example	F
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

Disaggregated BSAD 2024-25

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SettlementPeriod

DisaggregatedBSADCost

DisaggregatedBSADVolume

TradeFlag