Drakelow 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=53fe429c-6f86-448f-b21c-fbf89cad50e5&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=53fe429c-6f86-448f-b21c-fbf89cad50e5&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "53fe429c-6f86-448f-b21c-fbf89cad50e5",
        "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 = "53fe429c-6f86-448f-b21c-fbf89cad50e5", // 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: '53fe429c-6f86-448f-b21c-fbf89cad50e5', // 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=53fe429c-6f86-448f-b21c-fbf89cad50e5&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' => '53fe429c-6f86-448f-b21c-fbf89cad50e5', // 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
315700_450922_45060_S7 numeric Not provided- Not provided- Not provided-
315701_450908_45061_S8 numeric Not provided- Not provided- Not provided-
392204_392211_0_L1 numeric Not provided- Not provided- Not provided-
426776_44981_0_L1 numeric Not provided- Not provided- Not provided-
426777_45473_0_L1 numeric Not provided- Not provided- Not provided-
426779_45473_0_L1 numeric Not provided- Not provided- Not provided-
426780_45472_0_L1 numeric Not provided- Not provided- Not provided-
426781_45382_0_L1 numeric Not provided- Not provided- Not provided-
444002_456904_444000_2A numeric Not provided- Not provided- Not provided-
444003_456908_444001_1A numeric Not provided- Not provided- Not provided-
444400_454708_0_T1 numeric Not provided- Not provided- Not provided-
444401_454709_0_T2 numeric Not provided- Not provided- Not provided-
444600_392205_0_T1 numeric Not provided- Not provided- Not provided-
444601_392206_0_T2 numeric Not provided- Not provided- Not provided-
444900_456606_0_T2 numeric Not provided- Not provided- Not provided-
444901_456600_0_T1 numeric Not provided- Not provided- Not provided-
445000_447700_0_T1 numeric Not provided- Not provided- Not provided-
445001_447701_0_T2 numeric Not provided- Not provided- Not provided-
445101_450214_0_L1 numeric Not provided- Not provided- Not provided-
445202_448800_0_L1 numeric Not provided- Not provided- Not provided-
445203_450205_0_L1 numeric Not provided- Not provided- Not provided-
445400_445402_0_L1 numeric Not provided- Not provided- Not provided-
445403_453801_0_L1 numeric Not provided- Not provided- Not provided-
445802_44685_0_T1 numeric Not provided- Not provided- Not provided-
446100_449000_0_T1 numeric Not provided- Not provided- Not provided-
446101_449001_0_T2 numeric Not provided- Not provided- Not provided-
446102_449002_0_T3 numeric Not provided- Not provided- Not provided-
446501_450910_0_L1 numeric Not provided- Not provided- Not provided-
446805_451206_0_L1 numeric Not provided- Not provided- Not provided-
446806_44685_0_L1 numeric Not provided- Not provided- Not provided-
44680_446503_0_G2 numeric Not provided- Not provided- Not provided-
446810_451202_0_L1 numeric Not provided- Not provided- Not provided-
44681_446502_0_G1 numeric Not provided- Not provided- Not provided-
44686_445801_0_T2 numeric Not provided- Not provided- Not provided-
44686_446803_0_L1 numeric Not provided- Not provided- Not provided-
44687_445800_0_T3 numeric Not provided- Not provided- Not provided-
44687_446808_0_L1 numeric Not provided- Not provided- Not provided-
44731_447301_0_L1 numeric Not provided- Not provided- Not provided-
44731_447701_0_L1 numeric Not provided- Not provided- Not provided-
44731_450212_0_L1 numeric Not provided- Not provided- Not provided-
447700_450202_0_L1 numeric Not provided- Not provided- Not provided-
448800_455800_0_T1 numeric Not provided- Not provided- Not provided-
448801_450504_0_L1 numeric Not provided- Not provided- Not provided-
448801_455801_0_T2 numeric Not provided- Not provided- Not provided-
448900_450912_0_L1 numeric Not provided- Not provided- Not provided-
448901_450920_0_L1 numeric Not provided- Not provided- Not provided-
448902_450210_0_G2 numeric Not provided- Not provided- Not provided-
448903_450203_0_G1 numeric Not provided- Not provided- Not provided-
449000_449006_0_L1 numeric Not provided- Not provided- Not provided-
449001_450211_0_L1 numeric Not provided- Not provided- Not provided-
449002_450505_0_L1 numeric Not provided- Not provided- Not provided-
449004_450207_0_L1 numeric Not provided- Not provided- Not provided-
44920_446500_0_L1 numeric Not provided- Not provided- Not provided-
44920_450906_0_L1 numeric Not provided- Not provided- Not provided-
449300_451205_0_T2 numeric Not provided- Not provided- Not provided-
449301_451204_0_T1 numeric Not provided- Not provided- Not provided-
44980_450509_0_L1 numeric Not provided- Not provided- Not provided-
44981_450509_0_L1 numeric Not provided- Not provided- Not provided-
450502_456903_0_2B numeric Not provided- Not provided- Not provided-
450506_456603_0_L1 numeric Not provided- Not provided- Not provided-
450510_456909_0_1B numeric Not provided- Not provided- Not provided-
45070_450511_0_L1 numeric Not provided- Not provided- Not provided-
45070_450700_0_L1 numeric Not provided- Not provided- Not provided-
45070_454705_0_L1 numeric Not provided- Not provided- Not provided-
45071_450503_0_L1 numeric Not provided- Not provided- Not provided-
45071_450701_0_L1 numeric Not provided- Not provided- Not provided-
45071_454702_0_L1 numeric Not provided- Not provided- Not provided-
450914_456905_0_L1 numeric Not provided- Not provided- Not provided-
450918_456907_0_L1 numeric Not provided- Not provided- Not provided-
452701_452702_0_L1 numeric Not provided- Not provided- Not provided-
45270_456604_0_L1 numeric Not provided- Not provided- Not provided-
45312_450508_0_L1 numeric Not provided- Not provided- Not provided-
45312_453101_0_L1 numeric Not provided- Not provided- Not provided-
45312_456600_0_L1 numeric Not provided- Not provided- Not provided-
453800_453802_0_L1 numeric Not provided- Not provided- Not provided-
453800_457800_0_T1 numeric Not provided- Not provided- Not provided-
453801_457801_0_T2 numeric Not provided- Not provided- Not provided-
45382_454710_0_L1 numeric Not provided- Not provided- Not provided-
45383_392207_0_L1 numeric Not provided- Not provided- Not provided-
45383_392210_0_L1 numeric Not provided- Not provided- Not provided-
45383_445404_0_L1 numeric Not provided- Not provided- Not provided-
454703_454708_0_L1 numeric Not provided- Not provided- Not provided-
454707_454709_0_L1 numeric Not provided- Not provided- Not provided-
45472_451207_0_L1 numeric Not provided- Not provided- Not provided-
45473_451203_0_L1 numeric Not provided- Not provided- Not provided-
45490_445201_0_T1 numeric Not provided- Not provided- Not provided-
456605_456606_0_L1 numeric Not provided- Not provided- Not provided-
456904_444000_444002_2A numeric Not provided- Not provided- Not provided-
456908_444001_444003_1A numeric Not provided- Not provided- Not provided-
459200_449500_0_T1 numeric Not provided- Not provided- Not provided-
459200_459201_0_L1 numeric Not provided- Not provided- Not provided-
460200_450702_0_T1 numeric Not provided- Not provided- Not provided-
460201_450703_0_T2 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-