Reactive Utilisation Data

Reactive power utilisation figures per Balancing Mechanism Unit per month. Lag and lead are separated out to show the volume of reactive absorption and generation per unit per month. This file is updated during the middle of each month, and holds data up until 2 months ago, e.g. in December 2024 there is data up until October 2024 Default/Market - D means this reactive power provision was obtained via ORPS, while M would mean it was obtained through Enhanced Reactive Power Service (ERPS) Location - A letter to denote where the unit is located (S = South, N = North, SC = Scotland, M = Midlands)

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=528b03d2-4008-4b65-a732-a001cd835a3b&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "528b03d2-4008-4b65-a732-a001cd835a3b" LIMIT 5`

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

var data = {
  resource_id: '528b03d2-4008-4b65-a732-a001cd835a3b', // 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=528b03d2-4008-4b65-a732-a001cd835a3b&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Company

Title	Company
Type	string
Description	Conatains Company names
Comment
Example	NATP
Unit

Unit

Title	Unit
Type	string
Description	Conatains Units
Comment
Example	KLYNA01Z
Unit

Default/Market

Title	Default/Market
Type	string
Description	Contains the D/M
Comment
Example	D
Unit

Location

Title	Location
Type	string
Description	Contains the unit location
Comment
Example	M
Unit

Month-year

Title	Month-year
Type	string
Description	Contains the Monthyear
Comment
Example	Apr-20
Unit

LEAD

Title	LEAD
Type	number
Description	Contains the lead values of the units
Comment
Example	4315.7
Unit

LAG

Title	LAG
Type	number
Description	Contains the Lag values of the units
Comment
Example	198
Unit

TOTAL

Title	TOTAL
Type	number
Description	Contains the Total values of the units
Comment
Example	4513.7
Unit

You are now signed in

Reactive Utilisation Data

CKAN Data API

Data Explorer

Data Explorer

Table Information

Company

Unit

Default/Market

Location

Month-year

LEAD

LAG

TOTAL