Utilisation Report Summary - LIVE

This file will provide a summary of the utilisation report, it will be updated at around 16:30 GMT (only on days where there was a published 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=011f1a15-f63f-4a95-b1eb-453e5ffcd176&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "011f1a15-f63f-4a95-b1eb-453e5ffcd176" LIMIT 5`

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

var data = {
  resource_id: '011f1a15-f63f-4a95-b1eb-453e5ffcd176', // 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=011f1a15-f63f-4a95-b1eb-453e5ffcd176&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	Date of DFS event
Comment
Example	2022-11-15
Unit	N/A

From (GMT)

Title	From
Type	time
Description	Start time of DFS event
Comment	GMT
Example	17:00
Unit	HH:MM

To (GMT)

Title	To
Type	time
Description	End time of DFS event
Comment	GMT
Example	17:30
Unit	HH:MM

DFS Required (MW)

Title	DFS Required Volume
Type	number
Description	Published requirement for DFS event
Comment
Example	200
Unit	MW

DFS Procured (MW)

Title	DFS Volume Procured
Type	number
Description	Volume of DFS accepted
Comment
Example	100
Unit	MW

DFS Provider Bids Accepted Total Cost (£)

Title	Total Cost of Volume Procured
Type	number
Description	Cost of accepted volumes
Comment
Example	£100,000
Unit	£

D0 DFS Procured (MW)

Title	DFS Volume Procured - Updated Forecast at D0
Type	number
Description	The updated forecast of volume procured based on provider submissions on the day of the event at 10:00 GMT. Where an updated forecast has not been received on D0, the values for the unit submitted at D-1 will be used.
Comment
Example	100
Unit	MW

D0 DFS Provider Bids Accepted Total Cost (£)

Title	Total Cost of Volume Procured - Updated Forecast at D0
Type	number
Description	The updated cost of volume procured based on provider submissions on the day of the event at 10:00 GMT. Where an updated forecast has not been received on D0, the values for the unit submitted at D-1 will be used.
Comment
Example	£100,000
Unit	£

Settled Volume

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

Settled Cost

Title	Cost of DFS delivered
Type	number
Description	Post event cost of DFS delivered, visible once settlement data is received
Comment
Example	£100,000
Unit	£

For any queries or feedback please contact [email protected]

You are now signed in

Utilisation Report Summary - LIVE

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

From (GMT)

To (GMT)

DFS Required (MW)

DFS Procured (MW)

DFS Provider Bids Accepted Total Cost (£)

D0 DFS Procured (MW)

D0 DFS Provider Bids Accepted Total Cost (£)

Settled Volume

Settled Cost