Stability Pathfinder Availability Report 2023-2024

The availability report outlines the availability status of the contracted units, as declared to the ESO control room. Column D indicates the status for that settlement period with any notes in column E detailing the time of any changes.

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=a4fd8208-3e36-4f9c-bdc7-435c3734a2da&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "a4fd8208-3e36-4f9c-bdc7-435c3734a2da" LIMIT 5`

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

var data = {
  resource_id: 'a4fd8208-3e36-4f9c-bdc7-435c3734a2da', // 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=a4fd8208-3e36-4f9c-bdc7-435c3734a2da&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

UNIT

Title	UNIT
Type	string
Description	Identifier of the unit that the information relates to
Comment	BMU ID where applicable
Example	UNIT-1
Unit

Settlement Period Start Date Time

Title	Settlement Period Start Date Time
Type	datetime
Description	The identifier of the start date time of the Settlement Period that the information relates to
Comment
Example	11/07/2022 00:00
Unit

Settlement Period End Date Time

Title	Settlement Period End Date Time
Type	datetime
Description	The identifier of the end date time of the Settlement Period that the information relates to
Comment
Example	11/07/2022 00:30
Unit

Availability Flag

Title	Availability Flag
Type	string
Description	Indicates whether the unit was available or unavailable in the relevant settlement period
Comment
Example	Available; Unavailable
Unit

REMARK

Title	REMARK
Type	string
Description	Additional information on the availability of units
Comment
Example	Available at 12/JUL-2022 03:49:40
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Stability Pathfinder Availability Report 2023-2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

UNIT

Settlement Period Start Date Time

Settlement Period End Date Time

Availability Flag

REMARK