Skip Rate - Exclusion Reasons

A list of BMUs that have been excluded and the reason why.

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=8640d486-83b7-4252-a322-418739d17be6&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "8640d486-83b7-4252-a322-418739d17be6" LIMIT 5`

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

var data = {
  resource_id: '8640d486-83b7-4252-a322-418739d17be6', // 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=8640d486-83b7-4252-a322-418739d17be6&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 with excluded volume
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 bid or offer volume was excluded
Comment
Example	Offer
Unit

excluded_from_accepted_or_feasible_merit_stack

Title	Excluded from Accepted or Feasible Merit Stack
Type	string
Description	Whether the unit was excluded from the accepted merit stack or the feasible merit stack. If volume has been excluded from both the accepted merit stack and the feasible merit stack then there will be two rows.
Comment
Example	Accepted
Unit

exclusion_stage

Title	Exclusion Stage
Type	integer
Description	The stage the volume was excluded at
Comment
Example	3
Unit

pair_id

Title	Pair Id
Type	string
Description	Pair ID of excluded volume. There will be multiple rows if volume was excluded for multiple pair IDs for the same BMU
Comment
Example	1
Unit

average_price_per_MWh

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

excluded_volume_MWh

Title	Excluded Volume MWh
Type	number
Description	Total excluded volume
Comment
Example	5
Unit	MWh

exclusion_reason

Title	Exclusion Reason
Type	string
Description	The reason the volume was excluded from the given stage. Multiple reasons will be given for the stage if appropriate
Comment
Example	Inaccessible long notice unit
Unit

You are now signed in

Skip Rate - Exclusion Reasons

CKAN Data API

Data Explorer

Data Explorer

Table Information

date

bm_unit

fuel

bid_offer

excluded_from_accepted_or_feasible_merit_stack

exclusion_stage

pair_id

average_price_per_MWh

excluded_volume_MWh

exclusion_reason