ECR JAN 2026

This resource view is not available at the moment. Click here for more information.

Download resource

Integrate this resource

Access this data via a web API. Further information in the CKAN API guide (opens in new tab).

Endpoints

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

Create
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_create

Update / Insert
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_upsert

Query
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search

Querying
First 5 results:
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=82a4ae83-77a3-4e7b-9060-8072ed96de9d&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=82a4ae83-77a3-4e7b-9060-8072ed96de9d&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "82a4ae83-77a3-4e7b-9060-8072ed96de9d",
        "limit": 5,
        "q": "jones"
      }'
  
  
    using System;
    using System.Net.Http;
    using System.Text;
    using System.Text.Json;
    using System.Threading.Tasks;

    var data = new {
      resource_id = "82a4ae83-77a3-4e7b-9060-8072ed96de9d", // the resource id
      limit = 5, // get 5 results
      q = "jones" // query for 'jones'
    };

    var url = "https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search";

    using var client = new HttpClient();
    var json = JsonSerializer.Serialize(data);
    var content = new StringContent(json, Encoding.UTF8, "application/json");

    try {
      var response = await client.PostAsync(url, content);
      response.EnsureSuccessStatusCode();
      var responseBody = await response.Content.ReadAsStringAsync();
      var result = JsonSerializer.Deserialize<JsonElement>(responseBody);
      Console.WriteLine($"Total results found: {result.GetProperty("result").GetProperty("total")}");
    } catch (HttpRequestException e) {
      Console.WriteLine($"Error fetching data: {e.Message}");
    }
  
  
    const data = {
      resource_id: '82a4ae83-77a3-4e7b-9060-8072ed96de9d', // the resource id
      limit: 5, // get 5 results
      q: 'jones' // query for 'jones'
    };

    const url = new URL('https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search');
    Object.keys(data).forEach(key => url.searchParams.append(key, data[key]));

    fetch(url)
      .then(response => response.json())
      .then(result => {
        console.log('Total results found: ' + result.result.total);
      })
      .catch(error => {
        console.error('Error fetching data:', error);
      });
  
  
    import urllib.request
    import urllib.error
    import json

    url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=82a4ae83-77a3-4e7b-9060-8072ed96de9d&limit=5&q=title:jones'  
    
    try:
        with urllib.request.urlopen(url) as response:
            data = json.loads(response.read().decode('utf-8'))
            print(f"Total results found: {data['result']['total']}")
    except urllib.error.URLError as e:
        print(f"Error fetching data: {e}")
  
  
    $data = [
      'resource_id' => '82a4ae83-77a3-4e7b-9060-8072ed96de9d', // the resource id
      'limit' => 5, // get 5 results
      'q' => 'jones' // query for 'jones'
    ];

    $url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search';

    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));
    curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);

    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);

    if ($httpCode === 200) {
      $result = json_decode($response, true);
      echo "Total results found: " . $result['result']['total'];
    } else {
      echo "Error fetching data: HTTP " . $httpCode;
    }
  

Data Dictionary

Data Dictionary: Column definitions and metadata for this resource
Column Type Label Description Example
accepted_change_to_maximum_export_capacity(mva) text Not provided- Not provided- Not provided-
accepted_change_to_maximum_export_capacity(mw) text Not provided- Not provided- Not provided-
accepted_change_to_maximum_import_capacity(mva) text Not provided- Not provided- Not provided-
accepted_change_to_maximum_import_capacity(mw) text Not provided- Not provided- Not provided-
accepted_to_connect_registered_capacity(mw) text Not provided- Not provided- Not provided-
address_line_1 text Not provided- Not provided- Not provided-
address_line_2 text Not provided- Not provided- Not provided-
already_connected_registered_capacity(mw) numeric Not provided- Not provided- Not provided-
bulk_supply_point text Not provided- Not provided- Not provided-
chp_cogeneration(yes/no) text Not provided- Not provided- Not provided-
chp_cogeneration2(yes/no) text Not provided- Not provided- Not provided-
chp_cogeneration3(yes/no) text Not provided- Not provided- Not provided-
connected_maximum_export_capacity(mva) numeric Not provided- Not provided- Not provided-
connected_maximum_export_capacity(mw) numeric Not provided- Not provided- Not provided-
connected_maximum_import_capacity(mva) numeric Not provided- Not provided- Not provided-
connected_maximum_import_capacity(mw) numeric Not provided- Not provided- Not provided-
connection_status text Not provided- Not provided- Not provided-
country text Not provided- Not provided- Not provided-
county text Not provided- Not provided- Not provided-
customer_name text Not provided- Not provided- Not provided-
customer_site text Not provided- Not provided- Not provided-
date_accepted text Not provided- Not provided- Not provided-
date_connected timestamp Not provided- Not provided- Not provided-
distribution_reinforcement_reference text Not provided- Not provided- Not provided-
distribution_service_provider(y/n) text Not provided- Not provided- Not provided-
Energy Conversion Technology 1 text Not provided- Not provided- Not provided-
Energy Conversion Technology 2 text Not provided- Not provided- Not provided-
Energy Conversion Technology 3 text Not provided- Not provided- Not provided-
energy_source_&_conversion_tech_1_reg_capacity_mw numeric Not provided- Not provided- Not provided-
energy_source_&_conversion_tech_2_reg_capacity_mw numeric Not provided- Not provided- Not provided-
energy_source_&_conversion_tech_3_reg_capacity_mw numeric Not provided- Not provided- Not provided-
energy_source_1 text Not provided- Not provided- Not provided-
energy_source_2 text Not provided- Not provided- Not provided-
energy_source_3 text Not provided- Not provided- Not provided-
export_mpan/msid text Not provided- Not provided- Not provided-
flexible_connection (Yes/No) text Not provided- Not provided- Not provided-
grid_supply_point text Not provided- Not provided- Not provided-
import_mpan/msid text Not provided- Not provided- Not provided-
in_a_connection_queue(y/n) text Not provided- Not provided- Not provided-
last_updated timestamp Not provided- Not provided- Not provided-
lat numeric Not provided- Not provided- Not provided-
licence_area text Not provided- Not provided- Not provided-
local_authority text Not provided- Not provided- Not provided-
location(x-coordinate):_eastings_(where_data_is_held) numeric Not provided- Not provided- Not provided-
location(y-coordinate):_northings_(where_data_is_held) numeric Not provided- Not provided- Not provided-
lon numeric Not provided- Not provided- Not provided-
point_of_connection(poc)_voltage(kv) text Not provided- Not provided- Not provided-
postcode text Not provided- Not provided- Not provided-
primary text Not provided- Not provided- Not provided-
reference text Not provided- Not provided- Not provided-
storage_capacity_1(mwh) text Not provided- Not provided- Not provided-
storage_capacity_2(mwh) text Not provided- Not provided- Not provided-
storage_capacity_3(mwh) text Not provided- Not provided- Not provided-
storage_duration_1(hours) text Not provided- Not provided- Not provided-
storage_duration_2(hours) text Not provided- Not provided- Not provided-
storage_duration_3(hours) text Not provided- Not provided- Not provided-
target_energisation_date text Not provided- Not provided- Not provided-
Town/City text Not provided- Not provided- Not provided-
transmission_reinforcement_reference text Not provided- Not provided- Not provided-
transmission_service_provider(y/n) text Not provided- Not provided- Not provided-