Index Linked Contract Enactment FY 23-24

This data set displays the detail of Index Linked Contract Enactments for Financial Year 23-24.

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=dff083d2-666b-4e23-9b46-9edd9298f0d3&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "dff083d2-666b-4e23-9b46-9edd9298f0d3" LIMIT 5`

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

var data = {
  resource_id: 'dff083d2-666b-4e23-9b46-9edd9298f0d3', // 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=dff083d2-666b-4e23-9b46-9edd9298f0d3&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

ID

Title	Contract ID
Type	String
Description	ID of the Contract Enactment Action
Comment	N/A
Example	ES00101011
Unit	N/A

StartTime

Title	Start Time (UTC)
Type	Date and Time, UTC format
Description	Start time of the contract enactment action in UTC format
Comment	N/A
Example	2020-01-05T00:00:00
Unit	UTC ISO 8601

EndTime

Title	End Time (UTC)
Type	Date and Time, UTC format
Description	End time of the contract enactment action in UTC format
Comment	N/A
Example	2020-01-06T00:00:00
Unit	UTC ISO 8601

Volume

Title	Average Volume
Type	Float
Description	Average Volume of the contract enactment action
Comment	A positve number represents the action increase generation /decrease demand or provide upwards margin; a negative number represents the action reducing genreation / increase demand or provide downwards margin. Value is rounded to up to 1 decimal place
Example	10.9
Unit	MW

Price

Title	Price
Type	Float
Description	Average price of the contract enactment action
Comment	The value is rounded to up to 2 decimal places
Example	200.01
Unit	£/MWh

Cost

Title	Cost
Type	Float
Description	Total cost to Nationalgrid ESO for the contract enctment action
Comment	Cost = Volume * Price * Duration. The value is rounded to up to 2 decimal places
Example	38.57
Unit	£/h

SO_Flag

Title	System Flag
Type	String
Description	System flag indicating whether the action is mainly for system security purpose
Comment	SO_Flag = T (True) means the action is mainly for system security reason, SO_Flag = F (False) means the action is mainly for balancing reason
Example	T,F
Unit	N/A

Reason

Title	Contract Reason
Type	String
Description	Detailed reason for the contract enactment action
Comment	This can be for voltage, thermal constraints, ROCOF, upwards margin or downwards reserve etc
Example	Voltage: V_Mersey, V_SouthEast (Votlage) Thermal: LE1, B6; ROCOF_BMU, ROCOF_IC, Margin, Downwards, Others
Unit	N/A

AssetID

Title	AssetID
Type	String
Description	The ID of the Asset
Comment	In case of BMU this is NG BMU Name otherwise, a name will be given reflects our contract with the conterparty
Example	Drax-3
Unit	N/A

CP_Name

Title	Counterparty name
Type	String
Description	Name of the contract counterparty
Comment	This is the contract counterparty, it might be different from the asset owner
Example	Engie UK
Unit	N/A

Area

Title	Delivery Area
Type	String
Description	The location of the asset
Comment	This can be England&Wales, Scotland, or different interconnectors
Example	E&W, IFA
Unit	N/A

Note

Title	Note
Type	String
Description	Notes or comments
Comment	N/A
Example	N/A
Unit	N/A

Last_Updated

Title	Last Updated
Type	Date and Time, UTC format
Description	Date and Time that the information has been last updated
Comment	N/A
Example	2020-01-05T00:00:00
Unit	UTC ISO 8601

You are now signed in

Index Linked Contract Enactment FY 23-24

CKAN Data API

Data Explorer

Data Explorer

Table Information

ID

StartTime

EndTime

Volume

Price

Cost

SO_Flag

Reason

AssetID

CP_Name

Area

Note

Last_Updated