Current SF BSUoS Data

Data for the Settlement Final (SF) BSUoS run.

NOTE: As part of our ongoing efforts to align with data management best practices and improve consistency across datasets, the below column ids for this datafile will be updated on 1st October 2026 as follows:
Volume (MWh) → Volume_MWh
Actual BSUoS Cost (£) → Actual BSUoS Cost_GBP
BSUoS Total Recovery (£) → BSUoS Total Recovery_GBP
BSUoS Tariff (£/MWh) → BSUoS Tariff_GBP per MWh

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.neso.energy/api/3/action/datastore_search`
Query (via SQL)
`https://api.neso.energy/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.neso.energy/api/3/action/datastore_search?resource_id=f0060fd0-1fc9-4288-a0b3-4af9b592b0cf&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "f0060fd0-1fc9-4288-a0b3-4af9b592b0cf" LIMIT 5`

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

var data = {
  resource_id: 'f0060fd0-1fc9-4288-a0b3-4af9b592b0cf', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.neso.energy/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.neso.energy/api/3/action/datastore_search?resource_id=f0060fd0-1fc9-4288-a0b3-4af9b592b0cf&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Settlement Date

Title	Settlement Date
Type	date
Description	The settlement date for which the BSUoS price is given
Comment
Example	2023-04-01
Unit	ISO 8601

Settlement Period

Title	Settlement Period
Type	integer
Description	The 30 minutes period for which half-hourly charge has been calculated
Comment
Example	2
Unit

BSUoS Tariff_GBP per MWh

Title	BSUoS Tariff (£/MWh) (numeric)
Type	number
Description	This is the fixed tariff for settlement while balancing which is then applied to each calculation for every BSUoS customers charge.
Comment
Example	13.41
Unit	£/MWh

Volume_MWh

Title	Volume (MWh)
Type	number
Description	The value will be calculated (Column F divided by C) BSUoS recovery (£) BSUoS tariff (£/MWh)
Comment
Example	7400.12
Unit	MWh

BSUoS Total Recovery_GBP

Title	BSUoS Total Recovery (£)
Type	number
Description	The sum of half hour charges for whole day its include sum of BSUoS recovery and BSUoS fund recovery.
Comment
Example	56789.54
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	SF
Unit

Actual BSUoS Cost_GBP

Title	Actual BSUoS Cost(£)
Type	number
Description	Actual BSUoS cost for whole day.
Comment
Example	54679.21
Unit	£

You are now signed in

Current SF BSUoS Data

CKAN Data API

Data Explorer

Data Explorer

Table Information

Settlement Date

Settlement Period

BSUoS Tariff_GBP per MWh

Volume_MWh

BSUoS Total Recovery_GBP

Run Type

Actual BSUoS Cost_GBP