Bushbury Branch Load

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=5f333eb3-2507-48f4-a7cb-8cbb81a61cb2&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=5f333eb3-2507-48f4-a7cb-8cbb81a61cb2&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "5f333eb3-2507-48f4-a7cb-8cbb81a61cb2",
        "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 = "5f333eb3-2507-48f4-a7cb-8cbb81a61cb2", // 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: '5f333eb3-2507-48f4-a7cb-8cbb81a61cb2', // 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=5f333eb3-2507-48f4-a7cb-8cbb81a61cb2&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' => '5f333eb3-2507-48f4-a7cb-8cbb81a61cb2', // 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
100401_104505_0_1A numeric Not provided- Not provided- Not provided-
104504_128317_0_L1 numeric Not provided- Not provided- Not provided-
12171_124103_0_3C numeric Not provided- Not provided- Not provided-
12171_209115_0_L1 numeric Not provided- Not provided- Not provided-
12172_13013_0_L1 numeric Not provided- Not provided- Not provided-
12173_12175_0_L1 numeric Not provided- Not provided- Not provided-
12173_209121_0_L1 numeric Not provided- Not provided- Not provided-
12174_124104_0_1C numeric Not provided- Not provided- Not provided-
12174_209124_0_L1 numeric Not provided- Not provided- Not provided-
12350_127302_0_T1 numeric Not provided- Not provided- Not provided-
125501_209000_209003_G3 numeric Not provided- Not provided- Not provided-
125503_209001_209002_G2 numeric Not provided- Not provided- Not provided-
12560_124003_0_T3 numeric Not provided- Not provided- Not provided-
12560_128304_0_L1 numeric Not provided- Not provided- Not provided-
12561_124002_0_T1 numeric Not provided- Not provided- Not provided-
12561_128309_0_L1 numeric Not provided- Not provided- Not provided-
12562_124001_0_T2 numeric Not provided- Not provided- Not provided-
12562_128316_0_L1 numeric Not provided- Not provided- Not provided-
12731_127301_0_L1 numeric Not provided- Not provided- Not provided-
12731_128314_0_L1 numeric Not provided- Not provided- Not provided-
12731_130300_0_L1 numeric Not provided- Not provided- Not provided-
128311_130302_0_L1 numeric Not provided- Not provided- Not provided-
129701_130303_0_T1 numeric Not provided- Not provided- Not provided-
129702_130301_0_T2 numeric Not provided- Not provided- Not provided-
133102_209109_0_L1 numeric Not provided- Not provided- Not provided-
133103_208902_0_L1 numeric Not provided- Not provided- Not provided-
133107_124700_0_1A numeric Not provided- Not provided- Not provided-
209002_125503_209001_G2 numeric Not provided- Not provided- Not provided-
209003_125501_209000_G3 numeric Not provided- Not provided- Not provided-
209105_125500_0_L1 numeric Not provided- Not provided- Not provided-
209111_13013_0_L1 numeric Not provided- Not provided- Not provided-
209113_13011_0_L1 numeric Not provided- Not provided- Not provided-
209116_128305_0_3B numeric Not provided- Not provided- Not provided-
209119_125502_0_L1 numeric Not provided- Not provided- Not provided-
209123_128312_0_1B numeric Not provided- Not provided- Not provided-
209133_124105_0_2C numeric Not provided- Not provided- Not provided-
209200_13014_209204_S2 numeric Not provided- Not provided- Not provided-
209201_12176_209205_S3 numeric Not provided- Not provided- Not provided-
209202_13015_209203_S4 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-