Bishops Wood 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=abf3eb44-876a-448b-8454-9cf134125cac&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=abf3eb44-876a-448b-8454-9cf134125cac&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "abf3eb44-876a-448b-8454-9cf134125cac",
        "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 = "abf3eb44-876a-448b-8454-9cf134125cac", // 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: 'abf3eb44-876a-448b-8454-9cf134125cac', // 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=abf3eb44-876a-448b-8454-9cf134125cac&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' => 'abf3eb44-876a-448b-8454-9cf134125cac', // 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
10002_10430_0_L1 numeric Not provided- Not provided- Not provided-
100106_108932_100110_S2 numeric Not provided- Not provided- Not provided-
100107_108933_100111_S3 numeric Not provided- Not provided- Not provided-
100108_108934_0_S4 numeric Not provided- Not provided- Not provided-
100212_111502_100211_G4 numeric Not provided- Not provided- Not provided-
100301_119901_100300_G1 numeric Not provided- Not provided- Not provided-
100303_119903_100302_G2 numeric Not provided- Not provided- Not provided-
100802_10002_0_L1 numeric Not provided- Not provided- Not provided-
100803_104901_0_T1 numeric Not provided- Not provided- Not provided-
100903_103601_0_L1 numeric Not provided- Not provided- Not provided-
100904_102400_0_T1 numeric Not provided- Not provided- Not provided-
101101_10235_0_L1 numeric Not provided- Not provided- Not provided-
101102_10460_0_G2 numeric Not provided- Not provided- Not provided-
101103_103700_0_T5 numeric Not provided- Not provided- Not provided-
10180_10540_0_L1 numeric Not provided- Not provided- Not provided-
102302_10181_0_L1 numeric Not provided- Not provided- Not provided-
102302_10431_0_L1 numeric Not provided- Not provided- Not provided-
102303_103900_0_T1 numeric Not provided- Not provided- Not provided-
102304_10231_0_L1 numeric Not provided- Not provided- Not provided-
102305_103901_0_T2 numeric Not provided- Not provided- Not provided-
10230_10232_0_L1 numeric Not provided- Not provided- Not provided-
10231_10234_0_L1 numeric Not provided- Not provided- Not provided-
10234_10235_0_L1 numeric Not provided- Not provided- Not provided-
103602_10360_0_L1 numeric Not provided- Not provided- Not provided-
103603_104202_0_L1 numeric Not provided- Not provided- Not provided-
103701_117305_0_T3 numeric Not provided- Not provided- Not provided-
103702_117307_0_T4 numeric Not provided- Not provided- Not provided-
104200_10430_0_L1 numeric Not provided- Not provided- Not provided-
104200_10431_0_L1 numeric Not provided- Not provided- Not provided-
104601_108929_0_L1 numeric Not provided- Not provided- Not provided-
104603_119900_0_L1 numeric Not provided- Not provided- Not provided-
104604_108925_0_L1 numeric Not provided- Not provided- Not provided-
104605_119902_0_L1 numeric Not provided- Not provided- Not provided-
10463_11732_0_G1 numeric Not provided- Not provided- Not provided-
106030_114206_0_L1 numeric Not provided- Not provided- Not provided-
106041_107302_0_L1 numeric Not provided- Not provided- Not provided-
106042_213301_0_L1 numeric Not provided- Not provided- Not provided-
106043_108104_0_L1 numeric Not provided- Not provided- Not provided-
106046_106031_0_L1 numeric Not provided- Not provided- Not provided-
106047_213302_0_L1 numeric Not provided- Not provided- Not provided-
10606_116704_0_G1 numeric Not provided- Not provided- Not provided-
106600_107505_0_T2 numeric Not provided- Not provided- Not provided-
10690_10700_0_L1 numeric Not provided- Not provided- Not provided-
10691_10696_0_L1 numeric Not provided- Not provided- Not provided-
10691_117306_0_L1 numeric Not provided- Not provided- Not provided-
10692_10695_0_L1 numeric Not provided- Not provided- Not provided-
10693_10694_0_L1 numeric Not provided- Not provided- Not provided-
10693_10697_0_L1 numeric Not provided- Not provided- Not provided-
10695_11303_0_L1 numeric Not provided- Not provided- Not provided-
10697_10700_0_L1 numeric Not provided- Not provided- Not provided-
107001_10590_0_T1 numeric Not provided- Not provided- Not provided-
107002_10700_0_L1 numeric Not provided- Not provided- Not provided-
107200_120903_0_T1 numeric Not provided- Not provided- Not provided-
107301_11800_0_T1 numeric Not provided- Not provided- Not provided-
107401_120200_0_T1 numeric Not provided- Not provided- Not provided-
107402_107400_0_L1 numeric Not provided- Not provided- Not provided-
10741_194500_0_L1 numeric Not provided- Not provided- Not provided-
10741_194501_0_L1 numeric Not provided- Not provided- Not provided-
107504_107506_0_L1 numeric Not provided- Not provided- Not provided-
107600_115905_0_T2 numeric Not provided- Not provided- Not provided-
107601_115903_0_T1 numeric Not provided- Not provided- Not provided-
107702_11153_0_L1 numeric Not provided- Not provided- Not provided-
107703_109700_0_G1 numeric Not provided- Not provided- Not provided-
107704_116406_0_L1 numeric Not provided- Not provided- Not provided-
107705_109702_0_G2 numeric Not provided- Not provided- Not provided-
107902_118703_107901_G1 numeric Not provided- Not provided- Not provided-
107903_118705_107900_G2 numeric Not provided- Not provided- Not provided-
108002_110301_0_T1 numeric Not provided- Not provided- Not provided-
108004_110300_0_T3 numeric Not provided- Not provided- Not provided-
108005_110102_0_L1 numeric Not provided- Not provided- Not provided-
108102_120403_0_L1 numeric Not provided- Not provided- Not provided-
108103_116001_0_T1 numeric Not provided- Not provided- Not provided-
108105_116000_0_T2 numeric Not provided- Not provided- Not provided-
108502_108507_0_L1 numeric Not provided- Not provided- Not provided-
108503_110500_0_T1 numeric Not provided- Not provided- Not provided-
108504_120902_0_L1 numeric Not provided- Not provided- Not provided-
108505_110501_0_T2 numeric Not provided- Not provided- Not provided-
108506_10852_0_L1 numeric Not provided- Not provided- Not provided-
10852_194502_0_L1 numeric Not provided- Not provided- Not provided-
10852_194503_0_L1 numeric Not provided- Not provided- Not provided-
108905_11150_0_L1 numeric Not provided- Not provided- Not provided-
108909_11153_0_L1 numeric Not provided- Not provided- Not provided-
108911_111407_0_L1 numeric Not provided- Not provided- Not provided-
108915_116703_0_L1 numeric Not provided- Not provided- Not provided-
108917_110203_0_L1 numeric Not provided- Not provided- Not provided-
108921_110200_0_L1 numeric Not provided- Not provided- Not provided-
108923_108934_0_L1 numeric Not provided- Not provided- Not provided-
109104_115601_0_T1 numeric Not provided- Not provided- Not provided-
109106_109108_0_L1 numeric Not provided- Not provided- Not provided-
109107_115600_0_T3 numeric Not provided- Not provided- Not provided-
10913_194600_0_L1 numeric Not provided- Not provided- Not provided-
10951_120607_0_L1 numeric Not provided- Not provided- Not provided-
10951_208700_0_L1 numeric Not provided- Not provided- Not provided-
109801_109804_0_L1 numeric Not provided- Not provided- Not provided-
109802_11081_0_L1 numeric Not provided- Not provided- Not provided-
109901_116603_0_L1 numeric Not provided- Not provided- Not provided-
109902_109105_0_L1 numeric Not provided- Not provided- Not provided-
109903_114000_0_T2 numeric Not provided- Not provided- Not provided-
110000_117218_0_T1 numeric Not provided- Not provided- Not provided-
110001_117216_0_T2 numeric Not provided- Not provided- Not provided-
110101_110205_0_2B numeric Not provided- Not provided- Not provided-
110202_117220_0_G3 numeric Not provided- Not provided- Not provided-
110204_117223_0_2C numeric Not provided- Not provided- Not provided-
110800_110804_0_L1 numeric Not provided- Not provided- Not provided-
110801_110805_0_L1 numeric Not provided- Not provided- Not provided-
110802_120100_0_T1 numeric Not provided- Not provided- Not provided-
110803_120101_0_T2 numeric Not provided- Not provided- Not provided-
11080_112601_0_L1 numeric Not provided- Not provided- Not provided-
11080_117217_0_L1 numeric Not provided- Not provided- Not provided-
11080_208602_0_L1 numeric Not provided- Not provided- Not provided-
111403_116706_0_L1 numeric Not provided- Not provided- Not provided-
111404_118300_0_G1 numeric Not provided- Not provided- Not provided-
111405_116405_0_L1 numeric Not provided- Not provided- Not provided-
111406_118301_0_G2 numeric Not provided- Not provided- Not provided-
111408_118302_0_G3 numeric Not provided- Not provided- Not provided-
111502_100211_100212_G4 numeric Not provided- Not provided- Not provided-
111504_113007_0_G3 numeric Not provided- Not provided- Not provided-
11150_111501_0_L1 numeric Not provided- Not provided- Not provided-
11150_118702_0_L1 numeric Not provided- Not provided- Not provided-
11153_111503_0_L1 numeric Not provided- Not provided- Not provided-
112302_112304_0_L1 numeric Not provided- Not provided- Not provided-
11231_112305_0_L1 numeric Not provided- Not provided- Not provided-
11231_194504_0_L1 numeric Not provided- Not provided- Not provided-
11231_194505_0_L1 numeric Not provided- Not provided- Not provided-
112603_119100_0_T1 numeric Not provided- Not provided- Not provided-
113003_113006_0_L1 numeric Not provided- Not provided- Not provided-
11303_114705_0_L1 numeric Not provided- Not provided- Not provided-
113201_120404_0_T1 numeric Not provided- Not provided- Not provided-
113302_114300_0_T3 numeric Not provided- Not provided- Not provided-
11370_116602_0_T1 numeric Not provided- Not provided- Not provided-
113904_116200_0_T1 numeric Not provided- Not provided- Not provided-
113906_116201_0_T2 numeric Not provided- Not provided- Not provided-
114102_121300_0_T2 numeric Not provided- Not provided- Not provided-
11410_113304_0_L1 numeric Not provided- Not provided- Not provided-
11410_114101_0_L1 numeric Not provided- Not provided- Not provided-
11410_114103_0_L1 numeric Not provided- Not provided- Not provided-
114204_117100_0_T1 numeric Not provided- Not provided- Not provided-
114207_116904_0_L1 numeric Not provided- Not provided- Not provided-
114301_113306_0_T2 numeric Not provided- Not provided- Not provided-
114600_117802_0_T1 numeric Not provided- Not provided- Not provided-
114706_117401_0_T3 numeric Not provided- Not provided- Not provided-
114800_116407_0_G3 numeric Not provided- Not provided- Not provided-
114801_116404_0_G1 numeric Not provided- Not provided- Not provided-
115002_106044_0_L1 numeric Not provided- Not provided- Not provided-
115003_118600_0_T2 numeric Not provided- Not provided- Not provided-
115004_115902_0_L1 numeric Not provided- Not provided- Not provided-
115005_118601_0_T1 numeric Not provided- Not provided- Not provided-
115201_117222_0_L1 numeric Not provided- Not provided- Not provided-
11581_115801_0_L1 numeric Not provided- Not provided- Not provided-
11581_194506_0_L1 numeric Not provided- Not provided- Not provided-
11581_194507_0_L1 numeric Not provided- Not provided- Not provided-
11592_113903_0_L1 numeric Not provided- Not provided- Not provided-
11592_115904_0_L1 numeric Not provided- Not provided- Not provided-
11592_117304_0_L1 numeric Not provided- Not provided- Not provided-
116403_118704_0_L1 numeric Not provided- Not provided- Not provided-
116705_10607_0_G2 numeric Not provided- Not provided- Not provided-
116707_10603_0_G3 numeric Not provided- Not provided- Not provided-
116905_183102_0_L1 numeric Not provided- Not provided- Not provided-
116906_119400_0_T1 numeric Not provided- Not provided- Not provided-
116907_183104_0_L1 numeric Not provided- Not provided- Not provided-
116908_113307_0_L1 numeric Not provided- Not provided- Not provided-
117215_120605_0_L1 numeric Not provided- Not provided- Not provided-
117219_119502_0_L1 numeric Not provided- Not provided- Not provided-
117221_120608_0_L1 numeric Not provided- Not provided- Not provided-
117803_120606_0_L1 numeric Not provided- Not provided- Not provided-
11790_115802_0_T1 numeric Not provided- Not provided- Not provided-
118703_107901_107902_G1 numeric Not provided- Not provided- Not provided-
118705_107900_107903_G2 numeric Not provided- Not provided- Not provided-
119504_119506_0_L1 numeric Not provided- Not provided- Not provided-
11952_117224_0_L1 numeric Not provided- Not provided- Not provided-
11952_208600_0_L1 numeric Not provided- Not provided- Not provided-
11952_208601_0_L1 numeric Not provided- Not provided- Not provided-
119700_120609_0_T4 numeric Not provided- Not provided- Not provided-
119701_120604_0_T1 numeric Not provided- Not provided- Not provided-
119901_100300_100301_G1 numeric Not provided- Not provided- Not provided-
119903_100302_100303_G2 numeric Not provided- Not provided- Not provided-
120405_10913_0_L1 numeric Not provided- Not provided- Not provided-
120406_108003_0_L1 numeric Not provided- Not provided- Not provided-
120407_113200_0_T3 numeric Not provided- Not provided- Not provided-
120905_107201_0_T2 numeric Not provided- Not provided- Not provided-
172004_10913_0_L1 numeric Not provided- Not provided- Not provided-
172005_172101_0_T1 numeric Not provided- Not provided- Not provided-
172006_172100_0_T2 numeric Not provided- Not provided- Not provided-
172007_109103_0_L1 numeric Not provided- Not provided- Not provided-
172008_10741_0_L1 numeric Not provided- Not provided- Not provided-
175001_175101_0_T1 numeric Not provided- Not provided- Not provided-
175002_120904_0_L1 numeric Not provided- Not provided- Not provided-
175005_112303_0_L1 numeric Not provided- Not provided- Not provided-
175006_175100_0_T2 numeric Not provided- Not provided- Not provided-
183101_184300_0_T1 numeric Not provided- Not provided- Not provided-
183105_184301_0_T2 numeric Not provided- Not provided- Not provided-
184500_119503_0_T2 numeric Not provided- Not provided- Not provided-
184501_119505_0_T1 numeric Not provided- Not provided- Not provided-
184602_184603_0_L1 numeric Not provided- Not provided- Not provided-
208604_11081_0_L1 numeric Not provided- Not provided- Not provided-
213303_213304_0_G1 numeric Not provided- Not provided- Not provided-
216500_118706_0_G3 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-