Building Block Definitions 2022

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=e5ab7ecb-0ab1-4fe7-833c-1fe905b086f8&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "e5ab7ecb-0ab1-4fe7-833c-1fe905b086f8" LIMIT 5`

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

var data = {
  resource_id: 'e5ab7ecb-0ab1-4fe7-833c-1fe905b086f8', // 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=e5ab7ecb-0ab1-4fe7-833c-1fe905b086f8&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Template

Title	Template
Type	string
Description	The area that this data relates to
Comment
Example	Generation
Unit	N/A

Technology

Title	Technology
Type	string
Description	Lower level of categorisation after template level
Comment
Example	Non-renewable CHP
Unit	N/A

Building Block ID Number

Title	Building Block ID Number
Type	string
Description	Code identifying this building block
Comment
Example	Gen_BB001
Unit	n/a

Technology Detail

Title	Technology Detail
Type	string
Description	Further information on what this building block contains
Comment
Example	Offshore Wind
Unit	n/a

Units

Title	Units
Type	string
Description	The units that this building block is in
Comment
Example	MW
Unit	n/a

Detail

Title	Detail
Type	string
Description	Description of what this building block contains
Comment
Example	Installed capacity
Unit	n/a

Comments

Title	Comments
Type	string
Description	Further information on what is included in this building block
Comment
Example	Non-renewable excluding domestic Micro CHP
Unit

Alignment with Ofgem Core Scenario Key Drivers

Title	Alignment with Ofgem Core Scenario Key Drivers
Type	string
Description	Alignment with Ofgem Core Scenario Key Drivers
Comment
Example
Unit

Included in ESO Data

Title	Included in ESO Data
Type	string
Description	Included in ESO Data. Yes or No (Y/N)
Comment
Example	Y
Unit	N/A

ESO Comments

Title	ESO Additional Notes
Type	string
Description	Supplemental notes on what ESO have provided for this building block
Comment
Example	We are unable to provide this data
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Building Block Definitions 2022

CKAN Data API

Data Explorer

Data Explorer

Table Information

Template

Technology

Building Block ID Number

Technology Detail

Units

Detail

Comments

Alignment with Ofgem Core Scenario Key Drivers

Included in ESO Data

ESO Comments