Contract Volume 2020-12-13

Index-Linked Contract Enactment update 2020.12.13, ROCK-1

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=d098cb37-2a50-4ec4-9842-79d84d53b222&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "d098cb37-2a50-4ec4-9842-79d84d53b222" LIMIT 5`

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

var data = {
  resource_id: 'd098cb37-2a50-4ec4-9842-79d84d53b222', // 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=d098cb37-2a50-4ec4-9842-79d84d53b222&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date
Type	date
Description	Date of the contract enactment
Comment
Example	13/12/2020
Unit

SP

Title	SP
Type	number
Description	Settlement Period
Comment
Example	30
Unit

Strike Price (£/MWh)

Title	Strike Price (£/MWh)
Type	number
Description	Strike Price of the contract enactment for the given settlement period.
Comment
Example	37.0
Unit	£/MWh

Volume Indexed (MW)

Title	Volume Indexed (MW)
Type	number
Description	Indexed Linked Volume enacted for the given settlement period
Comment
Example	210
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

Contract Volume 2020-12-13

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SP

Strike Price (£/MWh)

Volume Indexed (MW)