Electricity Supply Data table (ES1) 2024

This table contains the electricity supply data from each of the pathways with the FES: Pathways to Net Zero, covering the period out to 2050 with capacity, generation and interconnector flows.

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=8c8a436d-408a-441b-8c7a-84249805772c&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "8c8a436d-408a-441b-8c7a-84249805772c" LIMIT 5`

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

var data = {
  resource_id: '8c8a436d-408a-441b-8c7a-84249805772c', // 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=8c8a436d-408a-441b-8c7a-84249805772c&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

For any queries or feedback please contact [email protected]

You are now signed in

Electricity Supply Data table (ES1) 2024

CKAN Data API

Data Explorer

Data Explorer