Kitwell 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=73242e6b-a016-413f-a224-74cde2b21788&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=73242e6b-a016-413f-a224-74cde2b21788&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "73242e6b-a016-413f-a224-74cde2b21788",
        "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 = "73242e6b-a016-413f-a224-74cde2b21788", // 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: '73242e6b-a016-413f-a224-74cde2b21788', // 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=73242e6b-a016-413f-a224-74cde2b21788&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' => '73242e6b-a016-413f-a224-74cde2b21788', // 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
171102_207208_171100_G1 numeric Not provided- Not provided- Not provided-
17111_207206_0_G2 numeric Not provided- Not provided- Not provided-
195700_196206_0_G2 numeric Not provided- Not provided- Not provided-
195701_196208_0_G3 numeric Not provided- Not provided- Not provided-
19624_196207_0_L1 numeric Not provided- Not provided- Not provided-
196602_204003_196600_G1 numeric Not provided- Not provided- Not provided-
196606_204005_196604_G2 numeric Not provided- Not provided- Not provided-
196800_20060_0_G1 numeric Not provided- Not provided- Not provided-
196801_20063_0_G5 numeric Not provided- Not provided- Not provided-
196802_20064_0_G2 numeric Not provided- Not provided- Not provided-
198000_20060_0_L1 numeric Not provided- Not provided- Not provided-
198001_20064_0_L1 numeric Not provided- Not provided- Not provided-
198002_201600_0_G1 numeric Not provided- Not provided- Not provided-
198003_201601_0_G2 numeric Not provided- Not provided- Not provided-
198304_19624_0_L1 numeric Not provided- Not provided- Not provided-
198305_195633_0_L1 numeric Not provided- Not provided- Not provided-
198307_195102_0_L1 numeric Not provided- Not provided- Not provided-
198308_195101_0_L1 numeric Not provided- Not provided- Not provided-
198310_195629_0_L1 numeric Not provided- Not provided- Not provided-
198312_195607_0_L1 numeric Not provided- Not provided- Not provided-
198313_205402_0_G2 numeric Not provided- Not provided- Not provided-
200102_195609_0_L1 numeric Not provided- Not provided- Not provided-
200103_204002_0_L1 numeric Not provided- Not provided- Not provided-
200104_206000_0_G1 numeric Not provided- Not provided- Not provided-
200105_195613_0_L1 numeric Not provided- Not provided- Not provided-
200106_206001_0_G2 numeric Not provided- Not provided- Not provided-
200107_204004_0_L1 numeric Not provided- Not provided- Not provided-
200603_195623_0_L1 numeric Not provided- Not provided- Not provided-
200606_195627_0_L1 numeric Not provided- Not provided- Not provided-
20060_200604_0_L1 numeric Not provided- Not provided- Not provided-
20064_200607_0_L1 numeric Not provided- Not provided- Not provided-
202703_195617_0_L1 numeric Not provided- Not provided- Not provided-
202704_205901_0_G1 numeric Not provided- Not provided- Not provided-
202706_205902_0_G3 numeric Not provided- Not provided- Not provided-
202707_195605_0_L1 numeric Not provided- Not provided- Not provided-
202708_205900_0_G2 numeric Not provided- Not provided- Not provided-
203202_204303_203200_G1 numeric Not provided- Not provided- Not provided-
203206_204305_203204_G2 numeric Not provided- Not provided- Not provided-
204003_196600_196602_G1 numeric Not provided- Not provided- Not provided-
204005_196604_196606_G2 numeric Not provided- Not provided- Not provided-
204302_200605_0_L1 numeric Not provided- Not provided- Not provided-
204303_203200_203202_G1 numeric Not provided- Not provided- Not provided-
204304_19624_0_L1 numeric Not provided- Not provided- Not provided-
204305_203204_203206_G2 numeric Not provided- Not provided- Not provided-
205400_198306_0_G1 numeric Not provided- Not provided- Not provided-
205401_198309_0_G3 numeric Not provided- Not provided- Not provided-
205505_206601_0_G1 numeric Not provided- Not provided- Not provided-
205506_195631_0_L1 numeric Not provided- Not provided- Not provided-
205507_206600_0_G2 numeric Not provided- Not provided- Not provided-
205508_200609_0_L1 numeric Not provided- Not provided- Not provided-
205509_206602_0_G3 numeric Not provided- Not provided- Not provided-
205510_206603_0_G4 numeric Not provided- Not provided- Not provided-
205511_195619_0_L1 numeric Not provided- Not provided- Not provided-
207203_205504_0_L1 numeric Not provided- Not provided- Not provided-
207207_196205_0_L1 numeric Not provided- Not provided- Not provided-
207208_171100_171102_G1 numeric Not provided- Not provided- Not provided-
208200_195103_0_G2 numeric Not provided- Not provided- Not provided-
208201_195105_0_G3 numeric Not provided- Not provided- Not provided-
211600_195625_211604_S1 numeric Not provided- Not provided- Not provided-
211601_195615_211605_S2 numeric Not provided- Not provided- Not provided-
211602_195621_211606_S3 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-