DFS Utilisation Report

DFS Utilisation Report will provide details of accepted and rejected bids for events, and includes a breakdown by GSP. The ESO will endeavour to update this file within one hour of bid submission gate closure – which occurs one hour after the DFS service requirements are issued. Note: this file will only be updated on days with a corresponding DFS service requirement.

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=cc36fff5-5f6f-4fde-8932-c935d982ecd8&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "cc36fff5-5f6f-4fde-8932-c935d982ecd8" LIMIT 5`

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

var data = {
  resource_id: 'cc36fff5-5f6f-4fde-8932-c935d982ecd8', // 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=cc36fff5-5f6f-4fde-8932-c935d982ecd8&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Delivery Date

Title	Delivery Date
Type	date
Description	Date of DFS event
Comment
Example	2024-01-10
Unit	YYYY-MM-DD

Registered DFS Participant

Title	Registered DFS Participant
Type	string
Description	Name of the Registered DFS Participant
Comment
Example	ABCLimited
Unit	N/A

DFS Unit ID

Title	DFS Unit ID
Type	string
Description	Unit ID for Registered DFS Participant
Comment
Example	ABC-01
Unit	N/A

DFS Volume MW

Title	DFS Volume MW
Type	number
Description	DFS volume tendered for service window
Comment
Example	10
Unit	MW

From

Title	From
Type	time
Description	DFS service window start time
Comment	GMT
Example	17:00:00
Unit	HH:MM:SS

To

Title	To
Type	time
Description	DFS service window end time
Comment	GMT
Example	17:30:00
Unit	HH:MM:SS

Service Requirement Type

Title	Service Requirement Type
Type	string
Description	Indicating a Live or Test DFS event
Comment
Example	Live
Unit	N/A

Utilisation Price GBP per MWh

Title	Utilisation Price GBP per MWh
Type	integer
Description	Tendered utilisation price for service window
Comment
Example	1000
Unit	£/MWh

Status

Title	Status
Type	string
Description	Status of DFS bid: Accepted or Rejected
Comment
Example	Accepted
Unit	N/A

North Scotland

Title	North Scotland
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

South and Central Scotland

Title	South and Central Scotland
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

North East England

Title	North East England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

North West England

Title	North West England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

Yorkshire

Title	Yorkshire
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

East Midlands

Title	East Midlands
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

West Midlands

Title	West Midlands
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

London

Title	London
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

East England

Title	East England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

South East England

Title	South East England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

South West England

Title	South West England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

Southern England

Title	Southern England
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

North Wales Merseyside and Cheshire

Title	North Wales Merseyside and Cheshire
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

South Wales

Title	South Wales
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

Other

Title	Other
Type	number
Description	DFS volume tendered for service window and GSP
Comment
Example	2
Unit	MW

Total

Title	Total
Type	number
Description	Total DFS volume tendered for service window and all GSPs
Comment
Example	10
Unit	MW

You are now signed in

DFS Utilisation Report

CKAN Data API

Data Explorer

Data Explorer

Table Information

Delivery Date

Registered DFS Participant

DFS Unit ID

DFS Volume MW

From

To

Service Requirement Type

Utilisation Price GBP per MWh

Status

North Scotland

South and Central Scotland

North East England

North West England

Yorkshire

East Midlands

West Midlands

London

East England

South East England

South West England

Southern England

North Wales Merseyside and Cheshire

South Wales

Other

Total