Reactive Utilisation Data - Apr-2020 - Sep-2024

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 2019 there is data up until October 2019.

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=a61c6c26-62ec-41e1-ae25-ed95f4562274&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "a61c6c26-62ec-41e1-ae25-ed95f4562274" LIMIT 5`

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

var data = {
  resource_id: 'a61c6c26-62ec-41e1-ae25-ed95f4562274', // 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=a61c6c26-62ec-41e1-ae25-ed95f4562274&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

id

Title
Type	any
Description
Comment
Example
Unit

Company

Title
Type	string
Description
Comment
Example
Unit

Unit

Title
Type	string
Description
Comment
Example
Unit

Default/Market

Title
Type	string
Description
Comment
Example
Unit

Location

Title
Type	string
Description
Comment
Example
Unit

Apr 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Apr 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Apr 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

May 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

May 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

May 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Jun 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Jun 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jun 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Jul 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Jul 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jul 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Aug 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Aug 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Aug 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Sep 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Sep 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Sep 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Oct 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Oct 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Oct 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Nov 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Nov 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Nov 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Dec 20 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Dec 20 - LAG

Title
Type	any
Description
Comment
Example
Unit

Dec 20 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Jan 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Jan 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jan 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Feb 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Feb 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Feb 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Mar 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Mar 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Mar 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Apr 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Apr 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Apr 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

May 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

May 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

May 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Jun 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Jun 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jun 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Jul 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Jul 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jul 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Aug 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Aug 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Aug 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Sep 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Sep 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Sep 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Oct 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Oct 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Oct 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Nov 21 -LEAD

Title
Type	any
Description
Comment
Example
Unit

Nov 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Nov 21 - TOTAL

Title
Type	any
Description
Comment
Example
Unit

Dec 21 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Dec 21 - LAG

Title
Type	any
Description
Comment
Example
Unit

Dec 21 - Total

Title
Type	any
Description
Comment
Example
Unit

Jan 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Jan 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jan 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Feb 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Feb 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Feb 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Mar 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Mar 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Mar 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Apr 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Apr 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Apr 22 - Total

Title
Type	any
Description
Comment
Example
Unit

May 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

May 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

May 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Jun 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Jun 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jun 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Jul 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Jul 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jul 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Aug 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Aug 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Aug 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Sep 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Sep 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Sep 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Oct 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Oct 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Oct 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Nov 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Nov 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Nov 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Dec 22 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Dec 22 - LAG

Title
Type	any
Description
Comment
Example
Unit

Dec 22 - Total

Title
Type	any
Description
Comment
Example
Unit

Jan 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Jan 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jan 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Feb 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Feb 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Feb 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Mar 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Mar 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Mar 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Apr 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Apr 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Apr 23 - Total

Title
Type	any
Description
Comment
Example
Unit

May 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

May 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

May 23 - Total

Title
Type	any
Description
Comment
Example
Unit

June 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

June 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

June 23 - Total

Title
Type	any
Description
Comment
Example
Unit

July 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

July 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

July 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Aug 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Aug 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Aug 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Sep 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Sep 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Sep 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Oct 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Oct 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Oct 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Nov 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Nov 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Nov 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Dec 23 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Dec 23 - LAG

Title
Type	any
Description
Comment
Example
Unit

Dec 23 - Total

Title
Type	any
Description
Comment
Example
Unit

Jan 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Jan 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Jan 24 - Total

Title
Type	any
Description
Comment
Example
Unit

Feb 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Feb 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Feb 24 - Total

Title
Type	any
Description
Comment
Example
Unit

Mar 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Mar 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Mar 24 - Total

Title
Type	any
Description
Comment
Example
Unit

Apr 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Apr 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Apr 24 - Total

Title
Type	any
Description
Comment
Example
Unit

May 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

May 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

May 24 - Total

Title
Type	any
Description
Comment
Example
Unit

June 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

June 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

June 24 - Total

Title
Type	any
Description
Comment
Example
Unit

July 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

July 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

July 24 - Total

Title
Type	any
Description
Comment
Example
Unit

Aug 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Aug 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Aug 24 - Total

Title
Type	any
Description
Comment
Example
Unit

Sep 24 - LEAD

Title
Type	any
Description
Comment
Example
Unit

Sep 24 - LAG

Title
Type	any
Description
Comment
Example
Unit

Sep 24 - Total

Title
Type	any
Description
Comment
Example
Unit

You are now signed in

Reactive Utilisation Data - Apr-2020 - Sep-2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

id

Company

Unit

Default/Market

Location

Apr 20 -LEAD

Apr 20 - LAG

Apr 20 - TOTAL

May 20 -LEAD

May 20 - LAG

May 20 - TOTAL

Jun 20 -LEAD

Jun 20 - LAG

Jun 20 - TOTAL

Jul 20 -LEAD

Jul 20 - LAG

Jul 20 - TOTAL

Aug 20 -LEAD

Aug 20 - LAG

Aug 20 - TOTAL

Sep 20 -LEAD

Sep 20 - LAG

Sep 20 - TOTAL

Oct 20 -LEAD

Oct 20 - LAG

Oct 20 - TOTAL

Nov 20 -LEAD

Nov 20 - LAG

Nov 20 - TOTAL

Dec 20 -LEAD

Dec 20 - LAG

Dec 20 - TOTAL

Jan 21 -LEAD

Jan 21 - LAG

Jan 21 - TOTAL

Feb 21 -LEAD

Feb 21 - LAG

Feb 21 - TOTAL

Mar 21 -LEAD

Mar 21 - LAG

Mar 21 - TOTAL

Apr 21 -LEAD

Apr 21 - LAG

Apr 21 - TOTAL

May 21 -LEAD

May 21 - LAG

May 21 - TOTAL

Jun 21 -LEAD

Jun 21 - LAG

Jun 21 - TOTAL

Jul 21 -LEAD

Jul 21 - LAG

Jul 21 - TOTAL

Aug 21 -LEAD

Aug 21 - LAG

Aug 21 - TOTAL

Sep 21 -LEAD

Sep 21 - LAG

Sep 21 - TOTAL

Oct 21 -LEAD

Oct 21 - LAG

Oct 21 - TOTAL

Nov 21 -LEAD

Nov 21 - LAG

Nov 21 - TOTAL

Dec 21 - LEAD

Dec 21 - LAG

Dec 21 - Total

Jan 22 - LEAD

Jan 22 - LAG

Jan 22 - Total

Feb 22 - LEAD

Feb 22 - LAG

Feb 22 - Total