Historic II BSUoS Data

This file contains the Historic web prices data for II run from the financial year 2017-2023.

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=3372646d-419f-4599-97a9-6bb4e7e32862&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "3372646d-419f-4599-97a9-6bb4e7e32862" LIMIT 5`

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

var data = {
  resource_id: '3372646d-419f-4599-97a9-6bb4e7e32862', // 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=3372646d-419f-4599-97a9-6bb4e7e32862&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Settlement Day

Title	Settlement Day
Type	date
Description	The settlement date for which the BSUoS price is given.
Comment
Example	1/4/2017
Unit

Settlement Period

Title	Settlement Period
Type	integer
Description	The 30 min period for which the half-hourly charge has been calculated.
Comment
Example	8
Unit

BSUoS Price (£/MWh Hour)

Title	BSUoS Price (£/MWh Hour)
Type	number
Description	This is the flat tariff for system wide balancing which is then applied to each calculation for every BSUoS customer’s charge.
Comment
Example	2.62122
Unit	£/MWh

Half-hourly Charge

Title	Half-hourly Charge
Type	number
Description	This half hourly charge is calculated by taking the BSUoS price for the settlement period and multiplying it by the volume of balancing services (MWh) provided in that period
Comment
Example	47674.58
Unit	£

Total Daily BSUoS Charge

Title	Total Daily BSUoS Charge
Type	number
Description	The sum of the half hourly charges for the whole day
Comment
Example	1946056.15
Unit	£

Run Type

Title	Run Type
Type	string
Description	This run type will be that of the dataset – either II (Interim Initial), SF (Settlement Final) or RF (Reconciliation Final).
Comment
Example	II
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Historic II BSUoS Data

CKAN Data API

Data Explorer

Data Explorer

Table Information

Settlement Day

Settlement Period

BSUoS Price (£/MWh Hour)

Half-hourly Charge

Total Daily BSUoS Charge

Run Type