Skip Rate - In Merit Post System Action

"Post System Action Skip Rate" – A more targeted measure of avoidable skips not in context of all actions taken at the time. The occurrence of these skips is far less the BM Skips.

NOTE: We are continuing to work to provide these datasets during December.

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=dec04882-67bf-4c46-aac4-e8b0a7051eab&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "dec04882-67bf-4c46-aac4-e8b0a7051eab" LIMIT 5`

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

var data = {
  resource_id: 'dec04882-67bf-4c46-aac4-e8b0a7051eab', // 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=dec04882-67bf-4c46-aac4-e8b0a7051eab&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

date

Title	Date
Type	datetime
Description	Datetime slice at 5min intervals
Comment
Example	2024-10-11T23:55:00Z
Unit	DateTime UTC

bm_unit

Title	BM Unit
Type	string
Description	BMU ID in merit stack
Comment
Example	CONTB-1
Unit

fuel

Title	Fuel
Type	string
Description	Fuel type of BMU
Comment
Example	Battery
Unit

bid_offer

Title	Bid/Offer
Type	string
Description	Whether the volume and price refers to a bid or an offer.
Comment
Example	Offer
Unit

stage

Title	Stage
Type	integer
Description	Identify which units are still in merit after each stage in skip rate methodology
Comment
Example	5
Unit

available_volume_MWh

Title	Available Volume MWh
Type	number
Description	Total available volume
Comment
Example	100
Unit	MWh

average_price_per_MWh

Title	Average Price £/MWh
Type	number
Description	Average price for accepted volume
Comment
Example	100
Unit	£/MWh

pair_id

Title	Pair Id
Type	string
Description	A number used to identify a particular Bid-Offer Pair. Values are negative for Bid-Offer Pairs that cover operating levels below Final Physical Notification (FPN) and positive for those that cover operating levels above FPN.
Comment
Example	1
Unit

accepted_volume_MWh

Title	Accepted Volume MWh
Type	number
Description	Total accepted volume
Comment
Example	50
Unit	MWh

in_merit_volume_MWh

Title	Remaining Available Volume MWh
Type	number
Description	Remaining available volume that wasn't accepted
Comment
Example	50
Unit	MWh

skipped_volume_MWh

Title	Skipped Volume MWh
Type	number
Description	The volume that was skipped
Comment
Example	10
Unit	MWh

You are now signed in

Skip Rate - In Merit Post System Action

CKAN Data API

Data Explorer

Data Explorer

Table Information

date

bm_unit

fuel

bid_offer

stage

available_volume_MWh

average_price_per_MWh

pair_id

accepted_volume_MWh

in_merit_volume_MWh

skipped_volume_MWh