Daily Balancing Volume 2017-2018
On a settlement period basis, the total balancing cost (per MWh) is given, alongside the total volume of services provided and an average cost for the settlement period.
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 example (first 5 results) |
---|
https://api.neso.energy/api/3/action/datastore_search?resource_id=a9b63a05-da9a-4a49-bcf4-13326720ce80&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "a9b63a05-da9a-4a49-bcf4-13326720ce80" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: 'a9b63a05-da9a-4a49-bcf4-13326720ce80', // 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=a9b63a05-da9a-4a49-bcf4-13326720ce80&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
SETT_DATE
Title | Settlement Date |
---|---|
Type | date |
Description | The Payment Date in relation to an Initial Settlement Run. |
Comment | |
Example | 22/03/2020 |
Unit |
SETT_PERIOD
Title | Settlement Period |
---|---|
Type | integer |
Description | A period of 30 minutes beginning on the hour or the half-hour |
Comment | On the first day of BST when clock change happens there will be 46 half hours (SP's) in the day. Similarly the first day of GMT will have 50 half hours as the clock goes back 1 hour at 2am. |
Example | 15 |
Unit |
Energy Imbalance (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Frequency Control Offers (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Frequency Control Bids (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Positive Reserve (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Constraint Offers (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Constraint Bids (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Negative Reserve (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |
Other (MWh)
Title | |
---|---|
Type | any |
Description | |
Comment | |
Example | |
Unit |