DFS Utilisation Report Summary

Summary of procured and delivered DFS volumes for Live and Test Events.

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=71a9cb04-8935-4e3a-bdd6-17f6fff0a7c6&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "71a9cb04-8935-4e3a-bdd6-17f6fff0a7c6" LIMIT 5`

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

var data = {
  resource_id: '71a9cb04-8935-4e3a-bdd6-17f6fff0a7c6', // 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=71a9cb04-8935-4e3a-bdd6-17f6fff0a7c6&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	15/11/2022
Unit	N/A

From

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

To

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

Service Requirement Type

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

DFS Required MW

Title	DFS Required Volume
Type	number
Description	Published DFS Service Requirement for service window.
Comment
Example	200
Unit	MW

DFS Procured MW

Title	DFS Volume Procured
Type	number
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	number
Description	Indicative total cost of accepted DFS Bids for service window.
Comment
Example	500000
Unit	£

Settled Volume MW

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

Settled Cost GBP

Title	Cost of DFS delivered
Type	number
Description	Total cost of DFS delivered, visible once settlement data is received
Comment
Example	500000
Unit	£

For any queries or feedback please contact [email protected]

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

DFS Required MW

DFS Procured MW

DFS Provider Bids Accepted Total Cost GBP

Settled Volume MW

Settled Cost GBP