DFS Utilisation Report - TEST

This file will provide details of accepted and rejected bids for DFS and includes a breakdown by GSP, 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=fc466b76-6823-4dd9-8b4a-aab464e0e77b&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "fc466b76-6823-4dd9-8b4a-aab464e0e77b" LIMIT 5`

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

var data = {
  resource_id: 'fc466b76-6823-4dd9-8b4a-aab464e0e77b', // 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=fc466b76-6823-4dd9-8b4a-aab464e0e77b&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

DFS Provider

Title	DFS Provider
Type	string
Description	Name of the registered DFS provider
Comment
Example	ABCLimited
Unit	N/A

Unit

Title	DFS Unit
Type	string
Description	Registered DFS unit ID
Comment
Example	ABCD-01
Unit	N/A

DFS Volume (MW)

Title	DFS Volume Submitted
Type	number
Description	DFS Volume Submitted at D-1
Comment
Example	10
Unit	MW

From (GMT)

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

To (GMT)

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

Price (£/MWh)

Title	Price
Type	number
Description	Price of volume submitted per MWh
Comment
Example	3000
Unit	£/MWh

Status

Title	Status of Bid
Type	string
Description	Status of the bid - either Accepted or Rejected
Comment
Example	Accepted
Unit	N/A

North Scotland

Title	North Scotland
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

South and Central Scotland

Title	South and Central Scotland
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

North East England

Title	North East England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

North West England

Title	North West England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

Yorkshire

Title	Yorkshire
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

East Midlands

Title	East Midlands
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

West Midlands

Title	West Midlands
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

London

Title	London
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

East England

Title	East England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

South East England

Title	South East England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

South West England

Title	South West England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

Southern England

Title	Southern England
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

North Wales, Merseyside and Cheshire

Title	North Wales, Merseyside and Cheshire
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

South Wales

Title	South Wales
Type	number
Description	Volume submitted for GSP at D-1
Comment
Example	2
Unit	MW

Other

Title	Other
Type	number
Description	Volume submitted for other GSPs at D-1
Comment
Example	2
Unit	MW

Total

Title	Total
Type	number
Description	Total volume submitted for GSPs at D-1
Comment
Example	2
Unit	MW

D0 North Scotland

Title	D0 North Scotland
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 South and Central Scotland

Title	D0 South and Central Scotland
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 North East England

Title	D0 North East England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 North West England

Title	D0 North West England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 Yorkshire

Title	D0 Yorkshire
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 East Midlands

Title	D0 East Midlands
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 West Midlands

Title	D0 West Midlands
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 London

Title	D0 London
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 East England

Title	D0 East England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 South East England

Title	D0 South East England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 South West England

Title	D0 South West England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 Southern England

Title	D0 Southern England
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 North Wales Merseyside and Cheshire

Title	D0 North Wales Merseyside and Cheshire
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 South Wales

Title	D0 South Wales
Type	number
Description	Forecasted volume to be delivered for GSP on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 Other

Title	D0 Other
Type	number
Description	Forecasted volume to be delivered for other GSPs on day of event 10:00GMT
Comment
Example	2
Unit	MW

D0 Total

Title	D0 Total
Type	number
Description	Total forecasted volume to be delivered on day of event 10:00GMT
Comment
Example	2
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

DFS Utilisation Report - TEST

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

DFS Provider

Unit

DFS Volume (MW)

From (GMT)

To (GMT)

Price (£/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

D0 North Scotland

D0 South and Central Scotland

D0 North East England

D0 North West England

D0 Yorkshire

D0 East Midlands

D0 West Midlands

D0 London

D0 East England

D0 South East England

D0 South West England

D0 Southern England

D0 North Wales Merseyside and Cheshire

D0 South Wales

D0 Other

D0 Total