Financial Year Losses

This file contains the Financial Year Losses for the transmission system. The data will be updated on an annual basis.

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=c0cd9512-4f8a-468e-8823-7c8238dcb9b9&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "c0cd9512-4f8a-468e-8823-7c8238dcb9b9" LIMIT 5`

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

var data = {
  resource_id: 'c0cd9512-4f8a-468e-8823-7c8238dcb9b9', // 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=c0cd9512-4f8a-468e-8823-7c8238dcb9b9&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Row Labels

Title	Financial Year
Type	year
Description	Financial Year that transmission losses occurred.
Comment
Example	2020-21
Unit

Sum of NGET

Title	Sum of National Grid Electricity Transmission (NGET) system losses
Type	number
Description	Annual NGET losses in TWh
Comment
Example	4.556
Unit	TWh

Sum of SPT

Title	Sum of Scottish Power Transmission (NGET) system losses
Type	number
Description	Annual SPTL losses in TWh
Comment
Example	0.554
Unit	TWh

Sum of SHETL

Title	Sum of Scottish Hydro Transmission (SHETL) system losses
Type	number
Description	Annual SHETL losses in TWh
Comment
Example	0.326
Unit	TWh

Sum of GB totals

Title	Sum of GB (Great Britain) system losses
Type	number
Description	Annual GB losses in TWh
Comment
Example	5.426
Unit	TWh

For any queries or feedback please contact [email protected]

You are now signed in

Financial Year Losses

CKAN Data API

Data Explorer

Data Explorer

Table Information

Row Labels

Sum of NGET

Sum of SPT

Sum of SHETL

Sum of GB totals