Embedded Register

This data file contains the latest version of the Embedded Register including all changes up to publication. This file will be updated twice weekly on Tuesdays and Fridays.

Please note:

Project Nos: We plan to phase out the use of Project IDs in favour of Project Nos which are now found included in the Dataset - we will continue to include Project IDs until the end of this year. If there is more than one Stage the Project No will be followed by a dash and the relevant stage number.

Project IDs: are Case Sensitive i.e. a0l4L0000005iPb; a0l4L0000005ipb and a0l4L0000005ipB relate to different projects.

Staging: If a project includes staged TEC there will be an associated number in the Stage column. Some projects have two separate lines without numbers - this usually indicates that the project is already built and the Customer is perhaps adding a different type of generation or building new generation to be connected at a future date. Once built the second line will fall away and the TEC incorporated into the overall project.

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=68b6f3a1-e1bf-403b-9062-0269fc758d77&limit=5`
Query example (via SQL statement)
`https://api.neso.energy/api/3/action/datastore_search_sql?sql=SELECT * from "68b6f3a1-e1bf-403b-9062-0269fc758d77" LIMIT 5`

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

var data = {
  resource_id: '68b6f3a1-e1bf-403b-9062-0269fc758d77', // 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=68b6f3a1-e1bf-403b-9062-0269fc758d77&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Project Name

Title	Project Name
Type	string
Description	Name of Generation Project
Comment	n/a
Example	Abbotshaugh Reserve Power Facility
Unit	n/a

Customer Name

Title	Customer Name
Type	string
Description	Name of Generator
Comment	n/a
Example	SP DISTRIBUTION PLC
Unit	n/a

Connection Site

Title	Connection Site
Type	string
Description	Name of Generation Connection Site
Comment	n/a
Example	A'Chruach Wind Farm 275kV Substation
Unit	n/a

Stage

Title	Stage
Type	number
Description	Stage refers to Staged Capacity – how much Capacity the Customer will connect and when. The customer may choose to bring on capacity in chunks to align with their build /commissioning program. Staged contracts are also used when a customer may only be able to bring on a proportion of their total capacity at a particular point in time ahead of further reinforcement works being carried out, completion of which would allow the remaining Capacity onto the system.
Comment	Field is only completed if the project is staged otherwise it will be empty
Example
Unit	number

MW Connected

Title	MW Connected
Type	number
Description	Amount of capacity currently connected to the National Grid
Comment	Field will state 0MW until the project is built and connected
Example	20
Unit	MW

MW Increase / Decrease

Title	MW Increase / Decrease
Type	number
Description	Amount of capacity contracted to connect or be removed at a future date
Comment	Field will state 0MW unless the capacity is due to increase or decrease
Example	20
Unit	MW

Cumulative Total Capacity (MW)

Title	Cumulative Total Capacity (MW)
Type	number
Description	Total amount of capacity contracted across all Stages
Comment	n/a
Example	40
Unit	MW

MW Effective From

Title	MW Effective From
Type	date
Description	Date on which Connection is contracted to be effective from
Comment	Field will only include dates for future connections or increase/decreases to capacity, otherwise this field will be empty
Example	31/10/2032
Unit	yyyy-mm-dd

Project Status

Title	Project Status
Type	string
Description	Indicates what stage the Project is at in it's build cycle
Comment	The Status classifications are very much based on information we have either ascertained from the customer or from another source, i.e. government website. It’s important to note that we hold no authority on the Status classifications on Registers and are produced on an “as far as we are aware” basis.
Example	Consents Approved
Unit	n/a

HOST TO

Title	HOST TO
Type	string
Description	Indicates which Transmission Owner (TO) is responsible for the connection
Comment	SHET or SPT
Example	SPT
Unit	n/a

Plant Type

Title	Plant Type
Type	string
Description	Indicates the fuel type contracted to connect
Comment	n/a
Example	Gas Reciprocating
Unit	n/a

Project ID

Title	Project ID
Type	string
Description	Unique Project Identifier
Comment	This reference is case sensitive
Example	a0l4L0000005iN1
Unit	n/a

Project Number

Title	Project Number
Type	string
Description	Unique Project Number
Comment	If there is more than one Stage the Project number will be followed by a dash and the relevant stage number.
Example	PRO-000630-1
Unit	n/a

Gate

Title	Gate
Type	number
Description	Indicates which Gate the Project is contracted at
Comment	The value in this field is only completed once a signed Gate 1 or Gate 2 contract is countersigned - until that point all existing contracted projects will appear blank
Example	1
Unit	n/a

You are now signed in

Embedded Register

CKAN Data API

Data Explorer

Data Explorer

Table Information

Project Name

Customer Name

Connection Site

Stage

MW Connected

MW Increase / Decrease

Cumulative Total Capacity (MW)

MW Effective From

Project Status

HOST TO

Plant Type

Project ID

Project Number

Gate