Phase 2: FFR Auction Results Summary 26.11.2021

Phase 2 FFR Auction Results Summary 26.11.2021

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=a9659701-f0d4-40d2-91f1-31f4bac0619d&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "a9659701-f0d4-40d2-91f1-31f4bac0619d" LIMIT 5`

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

var data = {
  resource_id: 'a9659701-f0d4-40d2-91f1-31f4bac0619d', // 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=a9659701-f0d4-40d2-91f1-31f4bac0619d&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Service

Title	Service
Type	string
Description	The market for which the bid is in relation to. The two choices are DLH (Dynamic Low High) and LFS (Low Frequency Static)
Comment
Example	LFS
Unit

EFA Date

Title	Date
Type	date
Description	Equivalent date to the delivery end date in this instance.
Comment
Example	14/03/2020
Unit

Delivery Start

Title	Delivery Start
Type	datetime
Description	The time from which delivery of FFR will commence
Comment
Example	13/03/2020 23:00:00
Unit

Delivery End

Title	Delivery End
Type	datetime
Description	The time from which delivery of FFR will end
Comment
Example	13/03/2020 23:00:00
Unit

EFA

Title	EFA Date
Type	integer
Description	The week is split into 42 blocks, with 6 four-hour blocks each day
Comment
Example	1
Unit

Cleared Volume

Title	Cleared Volume
Type	integer
Description	The volume of response that was accepted as per the cleared price.
Comment
Example	88
Unit	MW

Clearing Price

Title	Clearing Price
Type	number
Description	The cleared price per MW per hour.
Comment
Example	5.39
Unit	£/MW

For any queries or feedback please contact [email protected]

You are now signed in

Phase 2: FFR Auction Results Summary 26.11.2021

CKAN Data API

Data Explorer

Data Explorer

Table Information

Service

EFA Date

Delivery Start

Delivery End

EFA

Cleared Volume

Clearing Price