EAC ESO Results By Unit 2023-2024

This contains the cleared quantity and clearing price for each accepted unit 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=a63ab354-7e68-44c2-ad96-c6f920c30e85&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "a63ab354-7e68-44c2-ad96-c6f920c30e85" LIMIT 5`

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

var data = {
  resource_id: 'a63ab354-7e68-44c2-ad96-c6f920c30e85', // 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=a63ab354-7e68-44c2-ad96-c6f920c30e85&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

registeredAuctionParticipant

Title	registeredAuctionParticipant
Type	string
Description	Name of the Participant who submitted the bid
Comment	MANDATORY
Example	EDF ENERGY CUSTOMERS LIMITED
Unit	N/A

auctionUnit

Title	auctionUnit
Type	string
Description	Unit Identifier - a collection of one or more Eligible Assets registered at the relevant time as an Auction Unit in accordance with the Registration and Pre-Qualification Procedure
Comment	MANDATORY
Example	AG-GEDF02
Unit	N/A

serviceType

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

executedQuantity

Title	executedQuantity
Type	number
Description	The volume of response that was accepted as at the clearing price
Comment	MANDATORY
Example	5
Unit	MW

clearingPrice

Title	clearingPrice
Type	number
Description	The cleared price per MW per hour (£/MW/h)
Comment	MANDATORY
Example	100
Unit	£/MW/h

deliveryStart

Title	deliveryStart
Type	datetime
Description	The time from which delivery of the Auction Product will commence
Comment	MANDATORY
Example	2023-06-19T13:30:00
Unit	ISO8601

deliveryEnd

Title	deliveryEnd
Type	datetime
Description	The time from which delivery of the Auction Product will end
Comment	MANDATORY
Example	2023-06-19T17:30:00
Unit	ISO 8601

technologyType

Title	technologyType
Type	string
Description	Technology Type of the Unit
Comment	OPTIONAL
Example	Batteries
Unit	N/A

postCode

Title	postCode
Type	string
Description	Post Code
Comment	OPTIONAL
Example	HU16
Unit	N/A

unitResultID

Title	unitResultID
Type	string
Description	Unit result record unique identifier
Comment	MANDATORY
Example	14#\|\|#94#\|\|#DCL#\|\|#376
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

EAC ESO Results By Unit 2023-2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

registeredAuctionParticipant

auctionUnit

serviceType

auctionProduct

executedQuantity

clearingPrice

deliveryStart

deliveryEnd

technologyType

postCode

unitResultID