Histroic Index Linked Volumes for 2018

Contract volume enacted per settlement period. Positive: NG buy, Negative: NG Sell. This file is updated ad-hoc following the enactment of a contract.

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=e262f669-78e5-4261-8613-71938038af44&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "e262f669-78e5-4261-8613-71938038af44" LIMIT 5`

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

var data = {
  resource_id: 'e262f669-78e5-4261-8613-71938038af44', // 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=e262f669-78e5-4261-8613-71938038af44&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	The date on which a contract was enacted to help provide voltage management.
Comment
Example	2019-09-29
Unit

SP

Title	Settlement Period
Type	integer
Description	The half hourly period for which the volume was bought or sold. Settlement period 1 runs from 00:00-00:30.
Comment
Example	45
Unit

Volume Indexed (MW)

Title	Volume Indexed (MW)
Type	number
Description	The volume bought or sold at an index-linked price.
Comment	The Index linked volume (typically linked to clean spark spread) that bought or sold. A positive value indicated NGESO bought and a negative value indicateds NGESO sold.
Example	220
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

Histroic Index Linked Volumes for 2018

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SP

Volume Indexed (MW)