For any queries or feedback please contact box.OpenData.ESO@nationalgrideso.com

Interconnector Register

Interconnector Register

Download (csv)

API

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

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.

Endpoints

The Data API can be accessed via the following actions of the CKAN action API.

Query	`https://data.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)	`https://data.nationalgrideso.com/api/3/action/datastore_search_sql`

Querying

Query example (first 5 results)

https://data.nationalgrideso.com/api/3/action/datastore_search?resource_id=64f7908f-f787-4977-93e1-5342a5f1357f&limit=5

Query example (via SQL statement)

https://data.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "64f7908f-f787-4977-93e1-5342a5f1357f" LIMIT 5

Example: Javascript

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

  
var data = {
resource_id: '64f7908f-f787-4977-93e1-5342a5f1357f', // the resource id
limit: 5 // get 5 results
};
$.ajax({
url: 'https://data.nationalgrideso.com/api/3/action/datastore_search',
data: data,
dataType: 'jsonp',
success: function(data) {
alert('Total results found: ' + data.result.total)
}
});

Example: Python

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

  
import urllib2
url = 'https://data.nationalgrideso.com/api/3/action/datastore_search?resource_id=64f7908f-f787-4977-93e1-5342a5f1357f&limit=5'
fileobj = urllib2.urlopen(url)
print fileobj.read()

Table Information

Customer Name

Title	Customer Name
Type	string
Description	Customer Name
Comment
Example
Unit

Project Name

Title	Project Name
Type	string
Description	Name of generation project
Comment
Example	Auchencrosh (interconnector CCT)
Unit

Connection Site

Title	Connection Site
Type	string
Description	Name of Generation Connection Site
Comment
Example	Upperboat 132kV
Unit

MW Import - Current

Title	MW Import - Current
Type	number
Description	Amount of import capacity currently connected to National Electricity Transmission System (NETS)
Comment	Field will state 0 MW until the project is built and connected.
Example	160
Unit	MW

MW Export - Current

Title	MW Export - Current
Type	number
Description	Amount of export capacity currently connected to National Electricity Transmission System (NETS)
Comment	Field will state 0 MW until the project is built and connected.
Example	450
Unit	MW

MW Import - Increase / Decrease

Title	MW Import - Increase / Decrease
Type	number
Description	Amount of import capacity contracted to connect or be removed at a future date
Comment
Example	340
Unit	MW

MW Export - Increase / Decrease

Title	MW Export - Increase / Decrease
Type	number
Description	Amount of export capacity contracted to connect or be removed at a future date
Comment	Field will state 0 MW unless the Transmission Entry Capacity (TEC) is due to increase or decrease.
Example	1400
Unit	MW

MW Import - Total

Title	MW Import - Total
Type	number
Description	Total amount of import capacity contracted across all Stages
Comment
Example	250
Unit	MW

MW Export - Total

Title	MW Export - Total
Type	number
Description	Total amount of export capacity contracted across all Stages
Comment	Field will state 0 MW unless the Transmission Entry Capacity (TEC) is due to increase or decrease.
Example	1400
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 Transmission Entry Capacity (TEC), otherwise this field will be empty.
Example	2021-11-01
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
Example	Built
Unit

HOST TO

Title	HOST TO
Type	string
Description	Indicates which Transmission Operator is responsible for the connection
Comment
Example	SPT
Unit

Interconnector Register

Interconnector Register

CKAN Data API

Table Information

Customer Name

Project Name

Connection Site

MW Import - Current

MW Export - Current

MW Import - Increase / Decrease

MW Export - Increase / Decrease

MW Import - Total

MW Export - Total

MW Effective From

Project Status

HOST TO

Customize Consent Preferences