Contract Volume 2020-12-11

Index-Linked Contract Volume update 2020.12.11

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.neso.energy/api/3/action/datastore_search`
Query (via SQL)
`https://api.neso.energy/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.neso.energy/api/3/action/datastore_search?resource_id=1010ff24-6602-4b5b-a245-eae90f14c8d3&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "1010ff24-6602-4b5b-a245-eae90f14c8d3" LIMIT 5`

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

var data = {
  resource_id: '1010ff24-6602-4b5b-a245-eae90f14c8d3', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.neso.energy/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.neso.energy/api/3/action/datastore_search?resource_id=1010ff24-6602-4b5b-a245-eae90f14c8d3&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Contract date and time (UTC)
Type	datetime
Description	Contract date and time, UTC format
Comment	N/A
Example	2021-07-15T00:00:00
Unit	UTC ISO 8601

SP

Title	Settlement Period
Type	integer
Description	Half hour settlement period
Comment	Half hour settlement period from 1 - 48
Example	1
Unit	N/A

Volume Indexed (MW)

Title	Volume Indexed
Type	integer
Description	Contract volume
Comment	N/A
Example	110
Unit	MW

You are now signed in

Contract Volume 2020-12-11

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SP

Volume Indexed (MW)