DFS Utilisation Report Summary

DFS Utilisation Report Summary will provide a summary of the demand flexibility volumes procured and delivered for events. The file will be updated after the DFS utilisation report has been updated, and/or when the relevant settlements data has been processed.

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=25698259-0b66-42f0-ac59-ef0df5245812&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "25698259-0b66-42f0-ac59-ef0df5245812" LIMIT 5`

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

var data = {
  resource_id: '25698259-0b66-42f0-ac59-ef0df5245812', // 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=25698259-0b66-42f0-ac59-ef0df5245812&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 service requirement
Comment
Example	15/11/2024
Unit	YYYY-MM-DD

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 service requirement
Comment
Example	Live
Unit	N/A

Service Requirement MW

Title	Service Requirement MW
Type	integer
Description	Published DFS service requirement for service window
Comment
Example	200
Unit	MW

DFS Procured MW

Title	DFS Procured MW
Type	integer
Description	Total volume of DFS accepted for service window
Comment
Example	100
Unit	MW

DFS Provider Bids Accepted Total Cost GBP

Title	DFS Provider Bids Accepted Total Cost GBP
Type	integer
Description	Indicative total cost of accepted DFS bids for service window
Comment
Example	50000
Unit	£

Settled Volume MW

Title	Settled Volume MW
Type	integer
Description	Total volume of DFS delivered, visible once settlement data is received.
Comment
Example	100
Unit	MW

Settled Cost GBP

Title	Settled Cost GBP
Type	integer
Description	Total cost of DFS delivered, visible once settlement data is received
Comment
Example	50000
Unit	£

You are now signed in

DFS Utilisation Report Summary

CKAN Data API

Data Explorer

Data Explorer

Table Information

Delivery Date

From

To

Service Requirement Type

Service Requirement MW

DFS Procured MW

DFS Provider Bids Accepted Total Cost GBP

Settled Volume MW

Settled Cost GBP