Aberthaw And Cardiff East 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=e811b074-7753-4d02-8700-887e9ed59165&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=e811b074-7753-4d02-8700-887e9ed59165&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "e811b074-7753-4d02-8700-887e9ed59165",
        "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 = "e811b074-7753-4d02-8700-887e9ed59165", // 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: 'e811b074-7753-4d02-8700-887e9ed59165', // 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=e811b074-7753-4d02-8700-887e9ed59165&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' => 'e811b074-7753-4d02-8700-887e9ed59165', // 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
1154_2302_0_L1 numeric Not provided- Not provided- Not provided-
1154_5893_0_L1 numeric Not provided- Not provided- Not provided-
1155_2301_0_L1 numeric Not provided- Not provided- Not provided-
1155_5894_0_L1 numeric Not provided- Not provided- Not provided-
2278_2286_0_L1 numeric Not provided- Not provided- Not provided-
2278_502405_0_L1 numeric Not provided- Not provided- Not provided-
2286_501806_0_L1 numeric Not provided- Not provided- Not provided-
2286_5608_0_L1 numeric Not provided- Not provided- Not provided-
2301_507706_0_L1 numeric Not provided- Not provided- Not provided-
2731_507901_0_G2 numeric Not provided- Not provided- Not provided-
2750_2755_0_1A numeric Not provided- Not provided- Not provided-
2751_2756_0_2B numeric Not provided- Not provided- Not provided-
3824_505600_0_T1 numeric Not provided- Not provided- Not provided-
3824_505701_0_L1 numeric Not provided- Not provided- Not provided-
3843_501805_0_L1 numeric Not provided- Not provided- Not provided-
3870_501811_0_L1 numeric Not provided- Not provided- Not provided-
3877_506026_0_L1 numeric Not provided- Not provided- Not provided-
3877_5879_0_L1 numeric Not provided- Not provided- Not provided-
3927_3957_0_L1 numeric Not provided- Not provided- Not provided-
3927_507301_0_T1 numeric Not provided- Not provided- Not provided-
3930_3960_0_L1 numeric Not provided- Not provided- Not provided-
3930_507300_0_T2 numeric Not provided- Not provided- Not provided-
3936_504600_0_T1 numeric Not provided- Not provided- Not provided-
3936_504904_0_L1 numeric Not provided- Not provided- Not provided-
3939_504601_0_T2 numeric Not provided- Not provided- Not provided-
3939_504910_0_L1 numeric Not provided- Not provided- Not provided-
3948_3963_0_L1 numeric Not provided- Not provided- Not provided-
3948_504501_0_T2 numeric Not provided- Not provided- Not provided-
3960_507417_0_L1 numeric Not provided- Not provided- Not provided-
3963_504415_0_L1 numeric Not provided- Not provided- Not provided-
3963_504905_0_L1 numeric Not provided- Not provided- Not provided-
3975_506201_0_T1 numeric Not provided- Not provided- Not provided-
3975_507604_0_L1 numeric Not provided- Not provided- Not provided-
3978_506200_0_T2 numeric Not provided- Not provided- Not provided-
3978_507609_0_L1 numeric Not provided- Not provided- Not provided-
3987_4047_0_L1 numeric Not provided- Not provided- Not provided-
4002_507405_0_L1 numeric Not provided- Not provided- Not provided-
4013_506504_0_L1 numeric Not provided- Not provided- Not provided-
4013_506700_0_T1 numeric Not provided- Not provided- Not provided-
4015_506510_0_L1 numeric Not provided- Not provided- Not provided-
4015_506701_0_T2 numeric Not provided- Not provided- Not provided-
4017_506100_0_T1 numeric Not provided- Not provided- Not provided-
4017_507606_0_L1 numeric Not provided- Not provided- Not provided-
4029_4047_0_L1 numeric Not provided- Not provided- Not provided-
4032_4050_0_L1 numeric Not provided- Not provided- Not provided-
4032_507200_0_T2 numeric Not provided- Not provided- Not provided-
4038_507001_0_T1 numeric Not provided- Not provided- Not provided-
4038_507408_0_L1 numeric Not provided- Not provided- Not provided-
4041_507000_0_T2 numeric Not provided- Not provided- Not provided-
4041_507414_0_L1 numeric Not provided- Not provided- Not provided-
4044_506803_0_L1 numeric Not provided- Not provided- Not provided-
4044_507607_0_L1 numeric Not provided- Not provided- Not provided-
4050_3990_0_L1 numeric Not provided- Not provided- Not provided-
4311_4374_0_L1 numeric Not provided- Not provided- Not provided-
4311_503801_0_T1 numeric Not provided- Not provided- Not provided-
4314_4377_0_L1 numeric Not provided- Not provided- Not provided-
4314_503800_0_T2 numeric Not provided- Not provided- Not provided-
4362_4374_0_L1 numeric Not provided- Not provided- Not provided-
4374_504405_0_L1 numeric Not provided- Not provided- Not provided-
4377_4365_0_L2 numeric Not provided- Not provided- Not provided-
4377_504414_0_L1 numeric Not provided- Not provided- Not provided-
4380_503402_0_L1 numeric Not provided- Not provided- Not provided-
4383_504407_0_L1 numeric Not provided- Not provided- Not provided-
500002_500205_0_L1 numeric Not provided- Not provided- Not provided-
500003_500103_0_G1 numeric Not provided- Not provided- Not provided-
500004_505023_0_L1 numeric Not provided- Not provided- Not provided-
500005_500107_0_G2 numeric Not provided- Not provided- Not provided-
500203_500402_0_L1 numeric Not provided- Not provided- Not provided-
500204_500300_0_G1 numeric Not provided- Not provided- Not provided-
500206_500301_0_G2 numeric Not provided- Not provided- Not provided-
500403_500500_0_G1 numeric Not provided- Not provided- Not provided-
500404_500809_0_L1 numeric Not provided- Not provided- Not provided-
500405_500501_0_G2 numeric Not provided- Not provided- Not provided-
500603_505026_0_L1 numeric Not provided- Not provided- Not provided-
500604_500700_0_G1 numeric Not provided- Not provided- Not provided-
500606_505022_0_L1 numeric Not provided- Not provided- Not provided-
500607_500701_0_G2 numeric Not provided- Not provided- Not provided-
500804_2302_0_L1 numeric Not provided- Not provided- Not provided-
500805_504403_0_G1 numeric Not provided- Not provided- Not provided-
500806_504409_0_G2 numeric Not provided- Not provided- Not provided-
500807_501706_0_L1 numeric Not provided- Not provided- Not provided-
500808_2301_0_L1 numeric Not provided- Not provided- Not provided-
500901_502409_0_G2 numeric Not provided- Not provided- Not provided-
500902_501048_0_L1 numeric Not provided- Not provided- Not provided-
500903_2281_0_L1 numeric Not provided- Not provided- Not provided-
500905_502411_0_G1 numeric Not provided- Not provided- Not provided-
501044_5894_0_L1 numeric Not provided- Not provided- Not provided-
501058_5893_0_L1 numeric Not provided- Not provided- Not provided-
501060_2281_0_L1 numeric Not provided- Not provided- Not provided-
501200_4002_0_T1 numeric Not provided- Not provided- Not provided-
501201_4005_0_T2 numeric Not provided- Not provided- Not provided-
501302_505032_0_L1 numeric Not provided- Not provided- Not provided-
501303_5270_0_L1 numeric Not provided- Not provided- Not provided-
501304_507611_0_G2 numeric Not provided- Not provided- Not provided-
501500_505021_0_G1 numeric Not provided- Not provided- Not provided-
501602_2296_0_L1 numeric Not provided- Not provided- Not provided-
501603_501803_0_G1 numeric Not provided- Not provided- Not provided-
501604_507705_0_L1 numeric Not provided- Not provided- Not provided-
501604_5270_0_L1 numeric Not provided- Not provided- Not provided-
501605_501809_0_G2 numeric Not provided- Not provided- Not provided-
501702_505030_0_L1 numeric Not provided- Not provided- Not provided-
501711_2751_0_L1 numeric Not provided- Not provided- Not provided-
501714_2750_0_L1 numeric Not provided- Not provided- Not provided-
501716_504913_0_1B numeric Not provided- Not provided- Not provided-
501717_504909_0_2A numeric Not provided- Not provided- Not provided-
501804_5600_0_L1 numeric Not provided- Not provided- Not provided-
501807_505703_0_L1 numeric Not provided- Not provided- Not provided-
501808_503014_0_T3 numeric Not provided- Not provided- Not provided-
501810_505901_0_L1 numeric Not provided- Not provided- Not provided-
501812_503015_0_T4 numeric Not provided- Not provided- Not provided-
502202_6031_0_L1 numeric Not provided- Not provided- Not provided-
502203_502301_0_T1 numeric Not provided- Not provided- Not provided-
502205_502300_0_T2 numeric Not provided- Not provided- Not provided-
502206_502204_0_L1 numeric Not provided- Not provided- Not provided-
502407_503100_0_L1 numeric Not provided- Not provided- Not provided-
502500_502408_0_T4 numeric Not provided- Not provided- Not provided-
502501_502402_0_T3 numeric Not provided- Not provided- Not provided-
502600_5616_0_L1 numeric Not provided- Not provided- Not provided-
502601_6033_0_L1 numeric Not provided- Not provided- Not provided-
502603_502700_0_T1 numeric Not provided- Not provided- Not provided-
502604_502701_0_T2 numeric Not provided- Not provided- Not provided-
502800_3843_0_T1 numeric Not provided- Not provided- Not provided-
502900_3870_0_T1 numeric Not provided- Not provided- Not provided-
503101_502403_0_L2 numeric Not provided- Not provided- Not provided-
503202_4383_0_L1 numeric Not provided- Not provided- Not provided-
503206_503301_0_T2 numeric Not provided- Not provided- Not provided-
503300_503203_0_T1 numeric Not provided- Not provided- Not provided-
503403_503500_0_T1 numeric Not provided- Not provided- Not provided-
503404_4383_0_L1 numeric Not provided- Not provided- Not provided-
503405_503501_0_T2 numeric Not provided- Not provided- Not provided-
503602_4380_0_L1 numeric Not provided- Not provided- Not provided-
503603_503700_0_T1 numeric Not provided- Not provided- Not provided-
503604_503205_0_L1 numeric Not provided- Not provided- Not provided-
503605_503701_0_T2 numeric Not provided- Not provided- Not provided-
503900_4362_0_T1 numeric Not provided- Not provided- Not provided-
503901_4365_0_T2 numeric Not provided- Not provided- Not provided-
504009_504100_0_T1 numeric Not provided- Not provided- Not provided-
504010_504406_0_L1 numeric Not provided- Not provided- Not provided-
504011_504101_0_T2 numeric Not provided- Not provided- Not provided-
504202_5878_0_L1 numeric Not provided- Not provided- Not provided-
504203_504300_0_T1 numeric Not provided- Not provided- Not provided-
504204_504008_0_L1 numeric Not provided- Not provided- Not provided-
504205_504301_0_T2 numeric Not provided- Not provided- Not provided-
504408_504702_0_L1 numeric Not provided- Not provided- Not provided-
504410_5880_0_L1 numeric Not provided- Not provided- Not provided-
504411_503204_0_L1 numeric Not provided- Not provided- Not provided-
504412_504706_0_L2 numeric Not provided- Not provided- Not provided-
504413_3945_0_L1 numeric Not provided- Not provided- Not provided-
504416_4380_0_L1 numeric Not provided- Not provided- Not provided-
504500_3945_0_T1 numeric Not provided- Not provided- Not provided-
504703_504907_0_L1 numeric Not provided- Not provided- Not provided-
504704_504800_0_T1 numeric Not provided- Not provided- Not provided-
504705_504801_0_T2 numeric Not provided- Not provided- Not provided-
504707_504911_0_L2 numeric Not provided- Not provided- Not provided-
504914_505101_0_L1 numeric Not provided- Not provided- Not provided-
505029_507403_0_G2 numeric Not provided- Not provided- Not provided-
505035_501501_0_G3 numeric Not provided- Not provided- Not provided-
505702_505800_0_L1 numeric Not provided- Not provided- Not provided-
506302_506509_0_L1 numeric Not provided- Not provided- Not provided-
506304_507610_0_L1 numeric Not provided- Not provided- Not provided-
506305_506401_0_T2 numeric Not provided- Not provided- Not provided-
506402_506303_0_T1 numeric Not provided- Not provided- Not provided-
506505_506601_0_T1 numeric Not provided- Not provided- Not provided-
506506_507404_0_L1 numeric Not provided- Not provided- Not provided-
506507_506600_0_T2 numeric Not provided- Not provided- Not provided-
506804_506900_0_T1 numeric Not provided- Not provided- Not provided-
506806_506901_0_T2 numeric Not provided- Not provided- Not provided-
507100_3987_0_T1 numeric Not provided- Not provided- Not provided-
507101_3990_0_T2 numeric Not provided- Not provided- Not provided-
507201_4029_0_T1 numeric Not provided- Not provided- Not provided-
507406_4047_0_L1 numeric Not provided- Not provided- Not provided-
507407_3957_0_L1 numeric Not provided- Not provided- Not provided-
507409_506802_0_L1 numeric Not provided- Not provided- Not provided-
507410_507605_0_L1 numeric Not provided- Not provided- Not provided-
507411_506508_0_L2 numeric Not provided- Not provided- Not provided-
507412_505020_0_G4 numeric Not provided- Not provided- Not provided-
507413_4005_0_L2 numeric Not provided- Not provided- Not provided-
507415_506805_0_L2 numeric Not provided- Not provided- Not provided-
507416_4050_0_L1 numeric Not provided- Not provided- Not provided-
507702_507801_0_G1 numeric Not provided- Not provided- Not provided-
507709_507800_0_G2 numeric Not provided- Not provided- Not provided-
507900_2730_0_G1 numeric Not provided- Not provided- Not provided-
551901_5602_0_L1 numeric Not provided- Not provided- Not provided-
5600_5602_0_L1 numeric Not provided- Not provided- Not provided-
560101_5601_0_L1 numeric Not provided- Not provided- Not provided-
560300_5603_0_L1 numeric Not provided- Not provided- Not provided-
5604_2278_0_L1 numeric Not provided- Not provided- Not provided-
5604_5606_0_L1 numeric Not provided- Not provided- Not provided-
5605_560500_0_L1 numeric Not provided- Not provided- Not provided-
560700_5607_0_L1 numeric Not provided- Not provided- Not provided-
560900_5609_0_L1 numeric Not provided- Not provided- Not provided-
5610_502406_0_L1 numeric Not provided- Not provided- Not provided-
5610_5612_0_L1 numeric Not provided- Not provided- Not provided-
5611_561100_0_L1 numeric Not provided- Not provided- Not provided-
561301_5613_0_L1 numeric Not provided- Not provided- Not provided-
5614_502404_0_L1 numeric Not provided- Not provided- Not provided-
5614_5616_0_L1 numeric Not provided- Not provided- Not provided-
561500_5615_0_L1 numeric Not provided- Not provided- Not provided-
561700_5617_0_L1 numeric Not provided- Not provided- Not provided-
5877_3877_0_L1 numeric Not provided- Not provided- Not provided-
6030_5612_0_L1 numeric Not provided- Not provided- Not provided-
6030_6032_0_L1 numeric Not provided- Not provided- Not provided-
950002_950006_0_S2 numeric Not provided- Not provided- Not provided-
950004_950007_0_S3 numeric Not provided- Not provided- Not provided-
950131_960111_95040_S1 numeric Not provided- Not provided- Not provided-
960117_950132_0_S2 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-