Cellarhead 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=3327849d-bf62-4aef-9d32-1f60cf4c52aa&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=3327849d-bf62-4aef-9d32-1f60cf4c52aa&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "3327849d-bf62-4aef-9d32-1f60cf4c52aa",
        "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 = "3327849d-bf62-4aef-9d32-1f60cf4c52aa", // 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: '3327849d-bf62-4aef-9d32-1f60cf4c52aa', // 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=3327849d-bf62-4aef-9d32-1f60cf4c52aa&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' => '3327849d-bf62-4aef-9d32-1f60cf4c52aa', // 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
133503_137308_0_L1 numeric Not provided- Not provided- Not provided-
133504_13560_0_T5 numeric Not provided- Not provided- Not provided-
133507_137313_0_L1 numeric Not provided- Not provided- Not provided-
133508_13561_0_T6 numeric Not provided- Not provided- Not provided-
133604_140602_0_T5 numeric Not provided- Not provided- Not provided-
133605_140205_0_L1 numeric Not provided- Not provided- Not provided-
133606_140601_0_T4 numeric Not provided- Not provided- Not provided-
133607_137107_0_L1 numeric Not provided- Not provided- Not provided-
133608_140600_0_T1 numeric Not provided- Not provided- Not provided-
133702_13371_0_L1 numeric Not provided- Not provided- Not provided-
133802_137702_0_L1 numeric Not provided- Not provided- Not provided-
133803_140700_0_T1 numeric Not provided- Not provided- Not provided-
133804_140701_0_T2 numeric Not provided- Not provided- Not provided-
133805_142209_0_L1 numeric Not provided- Not provided- Not provided-
133902_134411_0_L1 numeric Not provided- Not provided- Not provided-
133903_13791_0_G3 numeric Not provided- Not provided- Not provided-
133904_135309_0_L1 numeric Not provided- Not provided- Not provided-
133905_13790_0_G4 numeric Not provided- Not provided- Not provided-
133906_14500_0_L1 numeric Not provided- Not provided- Not provided-
133908_135305_0_L1 numeric Not provided- Not provided- Not provided-
134200_136305_0_T2 numeric Not provided- Not provided- Not provided-
134300_13430_0_L1 numeric Not provided- Not provided- Not provided-
134301_142700_0_T1 numeric Not provided- Not provided- Not provided-
13430_144710_0_L1 numeric Not provided- Not provided- Not provided-
134403_134921_0_L1 numeric Not provided- Not provided- Not provided-
134404_145600_0_L1 numeric Not provided- Not provided- Not provided-
134405_13445_0_L1 numeric Not provided- Not provided- Not provided-
134406_134412_0_L1 numeric Not provided- Not provided- Not provided-
134407_13441_0_L1 numeric Not provided- Not provided- Not provided-
134408_145601_0_L1 numeric Not provided- Not provided- Not provided-
134409_13801_0_L1 numeric Not provided- Not provided- Not provided-
134413_140217_0_G3 numeric Not provided- Not provided- Not provided-
134415_134938_0_L1 numeric Not provided- Not provided- Not provided-
134500_136501_0_T1 numeric Not provided- Not provided- Not provided-
134700_138301_0_T6 numeric Not provided- Not provided- Not provided-
134919_14500_0_R1 numeric Not provided- Not provided- Not provided-
134923_14340_0_L1 numeric Not provided- Not provided- Not provided-
134925_138102_0_L1 numeric Not provided- Not provided- Not provided-
134927_140812_0_L1 numeric Not provided- Not provided- Not provided-
134929_140807_0_L1 numeric Not provided- Not provided- Not provided-
134931_14051_0_L1 numeric Not provided- Not provided- Not provided-
13510_13511_0_L1 numeric Not provided- Not provided- Not provided-
13510_13636_0_L1 numeric Not provided- Not provided- Not provided-
13510_144712_0_L1 numeric Not provided- Not provided- Not provided-
135200_137309_0_T1 numeric Not provided- Not provided- Not provided-
135201_137310_0_T2 numeric Not provided- Not provided- Not provided-
135300_139814_0_L1 numeric Not provided- Not provided- Not provided-
135303_13870_0_G4 numeric Not provided- Not provided- Not provided-
135304_14032_0_G2 numeric Not provided- Not provided- Not provided-
135306_139812_0_L1 numeric Not provided- Not provided- Not provided-
135307_13879_0_G3 numeric Not provided- Not provided- Not provided-
13530_13874_0_G5 numeric Not provided- Not provided- Not provided-
135402_141802_0_1A numeric Not provided- Not provided- Not provided-
135403_141804_0_2A numeric Not provided- Not provided- Not provided-
135404_137002_0_L1 numeric Not provided- Not provided- Not provided-
135405_137004_0_L1 numeric Not provided- Not provided- Not provided-
135406_14250_0_L1 numeric Not provided- Not provided- Not provided-
135407_136700_0_T3 numeric Not provided- Not provided- Not provided-
135500_137205_0_T1 numeric Not provided- Not provided- Not provided-
135501_137206_0_T2 numeric Not provided- Not provided- Not provided-
136200_145507_0_T1 numeric Not provided- Not provided- Not provided-
136201_145509_0_T2 numeric Not provided- Not provided- Not provided-
136202_145505_0_T5 numeric Not provided- Not provided- Not provided-
136302_136500_0_L1 numeric Not provided- Not provided- Not provided-
136303_138202_0_L1 numeric Not provided- Not provided- Not provided-
136304_13638_0_L1 numeric Not provided- Not provided- Not provided-
13632_13633_0_L1 numeric Not provided- Not provided- Not provided-
13632_13635_0_L1 numeric Not provided- Not provided- Not provided-
13632_13637_0_L1 numeric Not provided- Not provided- Not provided-
136400_136107_0_T2 numeric Not provided- Not provided- Not provided-
136401_136104_0_T1 numeric Not provided- Not provided- Not provided-
136701_14182_0_1B numeric Not provided- Not provided- Not provided-
136702_14185_0_2B numeric Not provided- Not provided- Not provided-
136800_144706_0_L1 numeric Not provided- Not provided- Not provided-
136801_141600_0_T2 numeric Not provided- Not provided- Not provided-
13700_13970_0_T2 numeric Not provided- Not provided- Not provided-
137102_146202_0_L1 numeric Not provided- Not provided- Not provided-
137103_140213_0_L1 numeric Not provided- Not provided- Not provided-
137104_144500_0_T2 numeric Not provided- Not provided- Not provided-
137105_144501_0_T1 numeric Not provided- Not provided- Not provided-
137106_140209_0_L1 numeric Not provided- Not provided- Not provided-
137203_143202_0_L1 numeric Not provided- Not provided- Not provided-
137307_137602_0_L1 numeric Not provided- Not provided- Not provided-
137311_14372_0_L1 numeric Not provided- Not provided- Not provided-
137312_137606_0_L1 numeric Not provided- Not provided- Not provided-
137503_144708_0_L1 numeric Not provided- Not provided- Not provided-
137504_139900_0_T4 numeric Not provided- Not provided- Not provided-
137506_138803_0_G2 numeric Not provided- Not provided- Not provided-
137507_139901_0_T5 numeric Not provided- Not provided- Not provided-
137508_143806_0_L1 numeric Not provided- Not provided- Not provided-
137509_13512_0_L1 numeric Not provided- Not provided- Not provided-
137510_13400_0_L1 numeric Not provided- Not provided- Not provided-
137510_13401_0_L1 numeric Not provided- Not provided- Not provided-
137511_138802_0_G1 numeric Not provided- Not provided- Not provided-
137512_143803_0_L1 numeric Not provided- Not provided- Not provided-
137513_139902_0_T3 numeric Not provided- Not provided- Not provided-
137603_142205_0_L1 numeric Not provided- Not provided- Not provided-
137604_146300_0_T1 numeric Not provided- Not provided- Not provided-
137605_146301_0_T2 numeric Not provided- Not provided- Not provided-
137607_142208_0_L1 numeric Not provided- Not provided- Not provided-
13764_13763_0_L1 numeric Not provided- Not provided- Not provided-
13766_13763_0_L1 numeric Not provided- Not provided- Not provided-
13767_13768_0_L1 numeric Not provided- Not provided- Not provided-
13769_14372_0_L1 numeric Not provided- Not provided- Not provided-
137703_141200_0_T2 numeric Not provided- Not provided- Not provided-
137704_141201_0_T1 numeric Not provided- Not provided- Not provided-
137705_13370_0_L1 numeric Not provided- Not provided- Not provided-
13801_13941_0_L1 numeric Not provided- Not provided- Not provided-
138103_142202_0_G1 numeric Not provided- Not provided- Not provided-
138104_14050_0_L1 numeric Not provided- Not provided- Not provided-
138105_142203_0_G2 numeric Not provided- Not provided- Not provided-
138203_141700_0_T1 numeric Not provided- Not provided- Not provided-
138204_141701_0_T2 numeric Not provided- Not provided- Not provided-
138205_144703_0_L1 numeric Not provided- Not provided- Not provided-
138300_13765_0_L1 numeric Not provided- Not provided- Not provided-
13840_145602_0_G1 numeric Not provided- Not provided- Not provided-
13841_145603_0_G2 numeric Not provided- Not provided- Not provided-
138502_142206_0_L1 numeric Not provided- Not provided- Not provided-
138504_141000_0_T1 numeric Not provided- Not provided- Not provided-
138505_141001_0_T2 numeric Not provided- Not provided- Not provided-
138506_13401_0_L1 numeric Not provided- Not provided- Not provided-
138507_13370_0_L1 numeric Not provided- Not provided- Not provided-
138801_139807_0_L1 numeric Not provided- Not provided- Not provided-
138900_146501_0_T1 numeric Not provided- Not provided- Not provided-
139000_144711_0_T1 numeric Not provided- Not provided- Not provided-
13930_14250_0_TA numeric Not provided- Not provided- Not provided-
139415_13800_0_L1 numeric Not provided- Not provided- Not provided-
139417_13940_0_L1 numeric Not provided- Not provided- Not provided-
139417_13941_0_L1 numeric Not provided- Not provided- Not provided-
139419_14340_0_L1 numeric Not provided- Not provided- Not provided-
13971_13701_0_T1 numeric Not provided- Not provided- Not provided-
139806_14051_0_L1 numeric Not provided- Not provided- Not provided-
139808_14152_0_L1 numeric Not provided- Not provided- Not provided-
139809_141500_0_L1 numeric Not provided- Not provided- Not provided-
139810_14183_0_L1 numeric Not provided- Not provided- Not provided-
139811_14184_0_L1 numeric Not provided- Not provided- Not provided-
139813_13800_0_L1 numeric Not provided- Not provided- Not provided-
139815_138800_0_L1 numeric Not provided- Not provided- Not provided-
140203_13445_0_G1 numeric Not provided- Not provided- Not provided-
140206_141406_0_L1 numeric Not provided- Not provided- Not provided-
140207_13441_0_G2 numeric Not provided- Not provided- Not provided-
140208_141900_0_T1 numeric Not provided- Not provided- Not provided-
140210_141413_0_L1 numeric Not provided- Not provided- Not provided-
140214_141901_0_T2 numeric Not provided- Not provided- Not provided-
140216_144102_0_L1 numeric Not provided- Not provided- Not provided-
140302_14032_0_L1 numeric Not provided- Not provided- Not provided-
140302_14033_0_L1 numeric Not provided- Not provided- Not provided-
140303_143201_0_L1 numeric Not provided- Not provided- Not provided-
140304_142901_0_L1 numeric Not provided- Not provided- Not provided-
140400_144903_0_T1 numeric Not provided- Not provided- Not provided-
14050_14152_0_L1 numeric Not provided- Not provided- Not provided-
140804_14183_0_L1 numeric Not provided- Not provided- Not provided-
140806_13472_0_G4 numeric Not provided- Not provided- Not provided-
140808_14184_0_L1 numeric Not provided- Not provided- Not provided-
140811_13476_0_G3 numeric Not provided- Not provided- Not provided-
140900_141407_0_T1 numeric Not provided- Not provided- Not provided-
140901_141408_0_T2 numeric Not provided- Not provided- Not provided-
141103_145100_0_T1 numeric Not provided- Not provided- Not provided-
141104_145101_0_T2 numeric Not provided- Not provided- Not provided-
141105_136103_0_L1 numeric Not provided- Not provided- Not provided-
141409_136105_0_L1 numeric Not provided- Not provided- Not provided-
141412_141102_0_L1 numeric Not provided- Not provided- Not provided-
141500_141506_0_L1 numeric Not provided- Not provided- Not provided-
141501_146401_0_G1 numeric Not provided- Not provided- Not provided-
141504_14152_0_L1 numeric Not provided- Not provided- Not provided-
141505_13605_0_G3 numeric Not provided- Not provided- Not provided-
141507_13604_0_G4 numeric Not provided- Not provided- Not provided-
141800_14184_0_L1 numeric Not provided- Not provided- Not provided-
142207_146601_0_L1 numeric Not provided- Not provided- Not provided-
143203_144400_0_T1 numeric Not provided- Not provided- Not provided-
143600_143804_0_T1 numeric Not provided- Not provided- Not provided-
143601_143805_0_T2 numeric Not provided- Not provided- Not provided-
143703_144901_0_L1 numeric Not provided- Not provided- Not provided-
143706_145303_0_L1 numeric Not provided- Not provided- Not provided-
143802_13430_0_L1 numeric Not provided- Not provided- Not provided-
143807_144705_0_L1 numeric Not provided- Not provided- Not provided-
144101_14390_0_T1 numeric Not provided- Not provided- Not provided-
144300_146203_0_T1 numeric Not provided- Not provided- Not provided-
144301_146204_0_T2 numeric Not provided- Not provided- Not provided-
144707_145508_0_L1 numeric Not provided- Not provided- Not provided-
145302_14372_0_L1 numeric Not provided- Not provided- Not provided-
145504_144704_0_L1 numeric Not provided- Not provided- Not provided-
146602_13763_0_L1 numeric Not provided- Not provided- Not provided-
209300_134917_209308_S4 numeric Not provided- Not provided- Not provided-
209302_134913_209306_S2 numeric Not provided- Not provided- Not provided-
209303_134911_209309_10 numeric Not provided- Not provided- Not provided-
209304_134915_209305_S1 numeric Not provided- Not provided- Not provided-
264400_137517_0_L1 numeric Not provided- Not provided- Not provided-
264401_13634_0_L1 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-