Thermal Constraint Costs Data 21-22

Out turn system costs for thermal constraints across a number of significant constraint boundaries for 21-22 financial year.

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=4357dd3b-5c7a-4caa-8d1a-8cf848521143&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "4357dd3b-5c7a-4caa-8d1a-8cf848521143" LIMIT 5`

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

var data = {
  resource_id: '4357dd3b-5c7a-4caa-8d1a-8cf848521143', // 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=4357dd3b-5c7a-4caa-8d1a-8cf848521143&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Settlement Date

Title	Settlement Date
Type	date
Description	The date the constraint costs belong to.
Comment
Example	2021-04-01
Unit	ISO 8601

Constraint Group

Title	Constraint Group
Type	string
Description	The name of the constraint.
Comment
Example	ESTEX
Unit

Daily Cost (GBP)

Title	Daily Cost (GBP)
Type	integer
Description	The daily spend in GBP for the constraint. This is an integer (rounded).
Comment
Example	2,132,332
Unit	£

For any queries or feedback please contact [email protected]

You are now signed in

Thermal Constraint Costs Data 21-22

CKAN Data API

Data Explorer

Data Explorer

Table Information

Settlement Date

Constraint Group

Daily Cost (GBP)