EAC ESO 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
`https://api.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=596f29ac-0387-4ba4-a6d3-95c243140707&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "596f29ac-0387-4ba4-a6d3-95c243140707" LIMIT 5`

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

var data = {
  resource_id: '596f29ac-0387-4ba4-a6d3-95c243140707', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/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.nationalgrideso.com/api/3/action/datastore_search?resource_id=596f29ac-0387-4ba4-a6d3-95c243140707&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

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 – [DCH,DCL,DMH,DML,DRH,DRL,NSR,PSR,NQR,PQR]
Comment	MANDATORY
Example	Dynamic Containment LF
Unit	N/A

serviceType

Title	serviceType
Type	string
Description	Service Type Identifier - [Response, Quick Reserve or Slow Reserve]
Comment	MANDATORY
Example	Response
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

For any queries or feedback please contact [email protected]

You are now signed in

EAC ESO Results Summary 2023-2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

auctionID

auctionProduct

serviceType

deliveryStart

deliveryEnd

clearedVolume

clearingPrice