Phase 2: FFR Auction Results by Unit 26.11.2021

Phase 2 FFR Auction Results by Unit 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=87ee8fc4-11ae-4575-b734-99548aab2d98&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "87ee8fc4-11ae-4575-b734-99548aab2d98" LIMIT 5`

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

var data = {
  resource_id: '87ee8fc4-11ae-4575-b734-99548aab2d98', // 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=87ee8fc4-11ae-4575-b734-99548aab2d98&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Company

Title	Company
Type	string
Description	The member of the trial who submitted the bid
Comment
Example	Example Company
Unit

Unit Name

Title	Unit Name
Type	string
Description	The unit which would provide the FFR being bidded for.
Comment
Example	FFR-01
Unit

EFA Date

Title	Electricity Forward Agreement Date
Type	date
Description	Equivalent date to the delivery end date in this instance.
Comment
Example	13/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 22:00:00
Unit

EFA

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

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

Cleared Volume

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

Clearing Price

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

Cancelled

Title	Cancelled
Type	string
Description	Whether or not the bid has been cancelled
Comment
Example
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Phase 2: FFR Auction Results by Unit 26.11.2021

CKAN Data API

Data Explorer

Data Explorer

Table Information

Company

Unit Name

EFA Date

Delivery Start

Delivery End

EFA

Service

Cleared Volume

Clearing Price

Cancelled