Axminster 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=ecd939e7-d495-4b80-969c-1d1d749d06d1&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=ecd939e7-d495-4b80-969c-1d1d749d06d1&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "ecd939e7-d495-4b80-969c-1d1d749d06d1",
        "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 = "ecd939e7-d495-4b80-969c-1d1d749d06d1", // 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: 'ecd939e7-d495-4b80-969c-1d1d749d06d1', // 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=ecd939e7-d495-4b80-969c-1d1d749d06d1&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' => 'ecd939e7-d495-4b80-969c-1d1d749d06d1', // 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
102651_10266_0_L1 numeric Not provided- Not provided- Not provided-
10267_10268_0_R1 numeric Not provided- Not provided- Not provided-
10461_809202_0_L1 numeric Not provided- Not provided- Not provided-
105751_10576_0_L1 numeric Not provided- Not provided- Not provided-
10576_779006_0_L1 numeric Not provided- Not provided- Not provided-
703905_720302_0_L1 numeric Not provided- Not provided- Not provided-
703906_704001_0_T1 numeric Not provided- Not provided- Not provided-
703907_704000_0_T2 numeric Not provided- Not provided- Not provided-
705800_705900_0_T1 numeric Not provided- Not provided- Not provided-
711004_711100_0_T1 numeric Not provided- Not provided- Not provided-
711005_711101_0_T2 numeric Not provided- Not provided- Not provided-
715300_715600_0_T1 numeric Not provided- Not provided- Not provided-
715301_715601_0_T2 numeric Not provided- Not provided- Not provided-
7155_715303_0_L1 numeric Not provided- Not provided- Not provided-
7155_779004_0_L1 numeric Not provided- Not provided- Not provided-
719100_719300_0_T1 numeric Not provided- Not provided- Not provided-
7192_719101_0_L1 numeric Not provided- Not provided- Not provided-
7192_719201_0_L1 numeric Not provided- Not provided- Not provided-
7192_719203_0_L1 numeric Not provided- Not provided- Not provided-
720304_720401_0_T1 numeric Not provided- Not provided- Not provided-
720305_720400_0_T2 numeric Not provided- Not provided- Not provided-
723302_10461_0_L1 numeric Not provided- Not provided- Not provided-
723303_9836_0_L1 numeric Not provided- Not provided- Not provided-
723304_723400_0_T1 numeric Not provided- Not provided- Not provided-
723305_723401_0_T2 numeric Not provided- Not provided- Not provided-
723601_7236_0_L1 numeric Not provided- Not provided- Not provided-
723602_726402_0_L1 numeric Not provided- Not provided- Not provided-
723603_7236_0_L1 numeric Not provided- Not provided- Not provided-
723604_966101_0_L1 numeric Not provided- Not provided- Not provided-
723605_723608_0_L1 numeric Not provided- Not provided- Not provided-
723606_7236_0_L1 numeric Not provided- Not provided- Not provided-
723607_10270_0_L1 numeric Not provided- Not provided- Not provided-
726403_7265_0_L1 numeric Not provided- Not provided- Not provided-
726404_726600_0_T1 numeric Not provided- Not provided- Not provided-
726405_726601_0_T2 numeric Not provided- Not provided- Not provided-
726501_7265_0_L1 numeric Not provided- Not provided- Not provided-
726502_822507_0_L1 numeric Not provided- Not provided- Not provided-
7265_715302_0_L1 numeric Not provided- Not provided- Not provided-
728204_747804_0_L1 numeric Not provided- Not provided- Not provided-
728206_719202_0_L1 numeric Not provided- Not provided- Not provided-
728300_728203_0_T1 numeric Not provided- Not provided- Not provided-
747806_749902_0_L1 numeric Not provided- Not provided- Not provided-
7478_747803_0_L1 numeric Not provided- Not provided- Not provided-
7478_747805_0_L1 numeric Not provided- Not provided- Not provided-
749903_750000_0_T1 numeric Not provided- Not provided- Not provided-
749904_750001_0_T2 numeric Not provided- Not provided- Not provided-
758900_759000_0_T1 numeric Not provided- Not provided- Not provided-
758903_9526_0_L1 numeric Not provided- Not provided- Not provided-
758905_720303_0_L1 numeric Not provided- Not provided- Not provided-
758906_759001_0_T2 numeric Not provided- Not provided- Not provided-
766303_703904_0_L1 numeric Not provided- Not provided- Not provided-
779008_782102_0_L1 numeric Not provided- Not provided- Not provided-
779009_779200_0_T1 numeric Not provided- Not provided- Not provided-
779010_779100_0_T2 numeric Not provided- Not provided- Not provided-
7821_703903_0_L1 numeric Not provided- Not provided- Not provided-
7821_782101_0_L1 numeric Not provided- Not provided- Not provided-
798200_817100_0_G1 numeric Not provided- Not provided- Not provided-
798201_817101_0_G2 numeric Not provided- Not provided- Not provided-
798202_817102_0_G3 numeric Not provided- Not provided- Not provided-
798203_719204_0_L1 numeric Not provided- Not provided- Not provided-
798204_749905_0_L1 numeric Not provided- Not provided- Not provided-
8210_817104_0_L1 numeric Not provided- Not provided- Not provided-
821106_8210_0_L1 numeric Not provided- Not provided- Not provided-
821108_817103_0_L1 numeric Not provided- Not provided- Not provided-
821112_822303_0_L1 numeric Not provided- Not provided- Not provided-
821114_822304_0_L2 numeric Not provided- Not provided- Not provided-
822300_822500_0_G1 numeric Not provided- Not provided- Not provided-
822301_822502_0_G2 numeric Not provided- Not provided- Not provided-
822302_822501_0_G3 numeric Not provided- Not provided- Not provided-
822506_9836_0_L1 numeric Not provided- Not provided- Not provided-
822508_711002_0_L1 numeric Not provided- Not provided- Not provided-
822509_779005_0_L1 numeric Not provided- Not provided- Not provided-
822510_758904_0_L2 numeric Not provided- Not provided- Not provided-
822511_9306_0_L1 numeric Not provided- Not provided- Not provided-
822512_9526_0_L1 numeric Not provided- Not provided- Not provided-
822513_10576_0_L1 numeric Not provided- Not provided- Not provided-
822514_705801_0_L1 numeric Not provided- Not provided- Not provided-
822515_9221_0_L1 numeric Not provided- Not provided- Not provided-
922001_9221_0_L1 numeric Not provided- Not provided- Not provided-
922102_7821_0_L1 numeric Not provided- Not provided- Not provided-
9221_922101_0_L1 numeric Not provided- Not provided- Not provided-
9301_766302_0_L1 numeric Not provided- Not provided- Not provided-
9301_809301_0_L1 numeric Not provided- Not provided- Not provided-
9301_9306_0_L1 numeric Not provided- Not provided- Not provided-
9306_930501_0_L1 numeric Not provided- Not provided- Not provided-
9501_10266_0_L1 numeric Not provided- Not provided- Not provided-
9501_10269_0_L1 numeric Not provided- Not provided- Not provided-
9501_950001_0_L1 numeric Not provided- Not provided- Not provided-
952501_9526_0_L1 numeric Not provided- Not provided- Not provided-
966104_779007_0_L1 numeric Not provided- Not provided- Not provided-
9661_966001_0_L1 numeric Not provided- Not provided- Not provided-
9661_966102_0_L1 numeric Not provided- Not provided- Not provided-
9661_966103_0_L1 numeric Not provided- Not provided- Not provided-
9836_983501_0_L1 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-