NESO Mock Balancing-Reserve Results Summary 2023-2024
This contains the cleared quantity and clearing price for each service and 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=a285483f-d830-4ae2-8b6d-98c05f6d21f3&limit=5
|
Query example (via SQL statement) |
https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "a285483f-d830-4ae2-8b6d-98c05f6d21f3" LIMIT 5
|
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: 'a285483f-d830-4ae2-8b6d-98c05f6d21f3', // 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=a285483f-d830-4ae2-8b6d-98c05f6d21f3&limit=5' fileobj = urllib2.urlopen(url) print fileobj.read()
Data Explorer
Data Explorer
Table Information
auctionID
Title | auctionID |
---|---|
Type | integer |
Description | Unique auction identifier. All products auctioned in the same market |
Comment | MANDATORY |
Example | 144 |
Unit | N/A |
auctionProduct
Title | auctionProduct |
---|---|
Type | string |
Description | Service Type Identifier – [NBR,PBR] |
Comment | MANDATORY |
Example | PBR |
Unit | N/A |
serviceType
Title | serviceType |
---|---|
Type | string |
Description | Service Type Identifier - [Balancing Reserve] |
Comment | MANDATORY |
Example | Balancing Reserve |
Unit | N/A |
deliveryStart
Title | deliveryStart |
---|---|
Type | datetime |
Description | The time from which delivery of the Auction Product will commence |
Comment | MANDATORY |
Example | 2023-06-19T13:30:00Z |
Unit | N/A |
deliveryEnd
Title | deliveryEnd |
---|---|
Type | datetime |
Description | The time from which delivery of the Auction Product will end |
Comment | MANDATORY |
Example | 2023-06-19T17:30:00Z |
Unit | N/A |
clearedVolume
Title | clearedVolume |
---|---|
Type | number |
Description | The volume of the Auction Product that was accepted at the clearing price |
Comment | MANDATORY |
Example | 0 |
Unit | MW |
clearingPrice
Title | clearingPrice |
---|---|
Type | number |
Description | The cleared price per MW per hour (£/MW/h) |
Comment | MANDATORY |
Example | 100 |
Unit | £/MW/h |