Seabank And Sandford 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=58ec0a31-5bf8-493a-8ada-603287e5f242&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=58ec0a31-5bf8-493a-8ada-603287e5f242&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "58ec0a31-5bf8-493a-8ada-603287e5f242",
        "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 = "58ec0a31-5bf8-493a-8ada-603287e5f242", // 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: '58ec0a31-5bf8-493a-8ada-603287e5f242', // 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=58ec0a31-5bf8-493a-8ada-603287e5f242&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' => '58ec0a31-5bf8-493a-8ada-603287e5f242', // 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
100451_10048_0_L1 numeric Not provided- Not provided- Not provided-
100461_7837_0_L1 numeric Not provided- Not provided- Not provided-
100462_10046_0_L1 numeric Not provided- Not provided- Not provided-
10047_10048_0_R1 numeric Not provided- Not provided- Not provided-
10047_10049_0_L1 numeric Not provided- Not provided- Not provided-
100601_10061_0_L1 numeric Not provided- Not provided- Not provided-
100602_10061_0_L1 numeric Not provided- Not provided- Not provided-
100603_725700_0_L1 numeric Not provided- Not provided- Not provided-
101551_10156_0_L1 numeric Not provided- Not provided- Not provided-
101561_873517_0_L1 numeric Not provided- Not provided- Not provided-
101562_10156_0_L1 numeric Not provided- Not provided- Not provided-
101563_10161_0_L1 numeric Not provided- Not provided- Not provided-
101564_10156_0_L1 numeric Not provided- Not provided- Not provided-
101601_10161_0_L1 numeric Not provided- Not provided- Not provided-
101611_900602_0_L1 numeric Not provided- Not provided- Not provided-
101612_10161_0_L1 numeric Not provided- Not provided- Not provided-
101652_10166_0_L1 numeric Not provided- Not provided- Not provided-
101661_20901_0_L1 numeric Not provided- Not provided- Not provided-
101662_10166_0_L1 numeric Not provided- Not provided- Not provided-
101663_900502_0_L1 numeric Not provided- Not provided- Not provided-
101664_10166_0_L1 numeric Not provided- Not provided- Not provided-
101951_10196_0_L1 numeric Not provided- Not provided- Not provided-
10196_737003_0_L1 numeric Not provided- Not provided- Not provided-
103701_10371_0_L1 numeric Not provided- Not provided- Not provided-
103701_105851_0_L2 numeric Not provided- Not provided- Not provided-
10371_10372_0_L1 numeric Not provided- Not provided- Not provided-
10946_809521_0_L1 numeric Not provided- Not provided- Not provided-
10946_886200_0_L1 numeric Not provided- Not provided- Not provided-
20902_20901_0_L1 numeric Not provided- Not provided- Not provided-
600405_873507_0_L1 numeric Not provided- Not provided- Not provided-
600502_768601_0_L1 numeric Not provided- Not provided- Not provided-
600702_739901_0_T1 numeric Not provided- Not provided- Not provided-
600902_873521_0_L1 numeric Not provided- Not provided- Not provided-
600903_783800_0_T1 numeric Not provided- Not provided- Not provided-
600904_783801_0_T2 numeric Not provided- Not provided- Not provided-
600905_783703_0_L1 numeric Not provided- Not provided- Not provided-
601002_783701_0_L1 numeric Not provided- Not provided- Not provided-
601003_703801_0_T2 numeric Not provided- Not provided- Not provided-
601004_703800_0_T1 numeric Not provided- Not provided- Not provided-
601005_733701_0_L1 numeric Not provided- Not provided- Not provided-
601006_715903_0_L1 numeric Not provided- Not provided- Not provided-
7033_703600_0_T1 numeric Not provided- Not provided- Not provided-
705309_8738_0_L1 numeric Not provided- Not provided- Not provided-
7064_706500_0_T1 numeric Not provided- Not provided- Not provided-
7064_898505_0_L1 numeric Not provided- Not provided- Not provided-
707701_716503_0_L1 numeric Not provided- Not provided- Not provided-
707702_873503_0_L1 numeric Not provided- Not provided- Not provided-
707703_707800_0_T1 numeric Not provided- Not provided- Not provided-
71300_20901_0_L1 numeric Not provided- Not provided- Not provided-
71300_873515_0_L1 numeric Not provided- Not provided- Not provided-
71301_71300_0_L1 numeric Not provided- Not provided- Not provided-
71302_751206_0_L1 numeric Not provided- Not provided- Not provided-
7141_714401_0_T2 numeric Not provided- Not provided- Not provided-
7141_7869_0_R2 numeric Not provided- Not provided- Not provided-
7142_714402_0_T3 numeric Not provided- Not provided- Not provided-
7142_7870_0_R3 numeric Not provided- Not provided- Not provided-
7143_714403_0_T4 numeric Not provided- Not provided- Not provided-
7143_7871_0_R4 numeric Not provided- Not provided- Not provided-
715802_716001_0_T1 numeric Not provided- Not provided- Not provided-
7159_715801_0_L1 numeric Not provided- Not provided- Not provided-
7159_715904_0_L1 numeric Not provided- Not provided- Not provided-
716103_716300_0_T1 numeric Not provided- Not provided- Not provided-
7162_7798_0_L1 numeric Not provided- Not provided- Not provided-
7162_892504_0_L1 numeric Not provided- Not provided- Not provided-
716402_716501_0_L1 numeric Not provided- Not provided- Not provided-
716403_716601_0_T1 numeric Not provided- Not provided- Not provided-
716404_716600_0_T2 numeric Not provided- Not provided- Not provided-
7165_716502_0_L1 numeric Not provided- Not provided- Not provided-
7165_716504_0_L2 numeric Not provided- Not provided- Not provided-
7165_720602_0_L1 numeric Not provided- Not provided- Not provided-
716700_716900_0_T2 numeric Not provided- Not provided- Not provided-
7168_716701_0_L1 numeric Not provided- Not provided- Not provided-
7168_716804_0_L1 numeric Not provided- Not provided- Not provided-
7173_600503_0_L1 numeric Not provided- Not provided- Not provided-
7173_717302_0_L1 numeric Not provided- Not provided- Not provided-
718005_718101_0_T1 numeric Not provided- Not provided- Not provided-
718006_718100_0_T2 numeric Not provided- Not provided- Not provided-
720601_720700_0_T1 numeric Not provided- Not provided- Not provided-
721111_600406_0_L1 numeric Not provided- Not provided- Not provided-
721112_72111_0_L1 numeric Not provided- Not provided- Not provided-
72111_7513_0_L3 numeric Not provided- Not provided- Not provided-
721200_600402_0_T1 numeric Not provided- Not provided- Not provided-
721201_600404_0_T2 numeric Not provided- Not provided- Not provided-
725702_7258_0_L1 numeric Not provided- Not provided- Not provided-
725703_9816_0_L1 numeric Not provided- Not provided- Not provided-
725704_601602_0_L1 numeric Not provided- Not provided- Not provided-
725705_725901_0_T2 numeric Not provided- Not provided- Not provided-
725801_7258_0_L1 numeric Not provided- Not provided- Not provided-
725802_9766_0_L1 numeric Not provided- Not provided- Not provided-
727200_727400_0_T2 numeric Not provided- Not provided- Not provided-
727201_7273_0_L1 numeric Not provided- Not provided- Not provided-
7273_10371_0_L1 numeric Not provided- Not provided- Not provided-
72751_72752_0_LA numeric Not provided- Not provided- Not provided-
72751_72752_0_LB numeric Not provided- Not provided- Not provided-
72751_898506_0_L1 numeric Not provided- Not provided- Not provided-
72752_72753_0_L1 numeric Not provided- Not provided- Not provided-
72753_7275_0_LA numeric Not provided- Not provided- Not provided-
72753_7275_0_LB numeric Not provided- Not provided- Not provided-
727600_7275_0_T1 numeric Not provided- Not provided- Not provided-
729802_10061_0_L1 numeric Not provided- Not provided- Not provided-
729803_730000_0_T1 numeric Not provided- Not provided- Not provided-
729804_729904_0_L1 numeric Not provided- Not provided- Not provided-
729805_730001_0_T2 numeric Not provided- Not provided- Not provided-
729902_601604_0_L1 numeric Not provided- Not provided- Not provided-
7299_729901_0_L1 numeric Not provided- Not provided- Not provided-
7299_729903_0_L1 numeric Not provided- Not provided- Not provided-
7299_9776_0_L1 numeric Not provided- Not provided- Not provided-
733103_733201_0_T1 numeric Not provided- Not provided- Not provided-
733105_733200_0_T2 numeric Not provided- Not provided- Not provided-
733703_716801_0_L1 numeric Not provided- Not provided- Not provided-
7337_733702_0_L1 numeric Not provided- Not provided- Not provided-
7337_733704_0_L1 numeric Not provided- Not provided- Not provided-
733800_734000_0_T1 numeric Not provided- Not provided- Not provided-
733801_734001_0_T2 numeric Not provided- Not provided- Not provided-
733801_898509_0_L2 numeric Not provided- Not provided- Not provided-
733802_898504_0_L1 numeric Not provided- Not provided- Not provided-
734804_801603_0_L1 numeric Not provided- Not provided- Not provided-
737002_737100_0_T2 numeric Not provided- Not provided- Not provided-
737005_737101_0_T1 numeric Not provided- Not provided- Not provided-
7390_739200_0_T1 numeric Not provided- Not provided- Not provided-
7391_739201_0_T2 numeric Not provided- Not provided- Not provided-
7398_21047_0_L1 numeric Not provided- Not provided- Not provided-
7398_600705_0_L1 numeric Not provided- Not provided- Not provided-
739900_600704_0_T2 numeric Not provided- Not provided- Not provided-
745703_745900_0_T2 numeric Not provided- Not provided- Not provided-
745801_872508_0_L2 numeric Not provided- Not provided- Not provided-
745803_745901_0_T1 numeric Not provided- Not provided- Not provided-
748702_748900_0_T1 numeric Not provided- Not provided- Not provided-
748703_748901_0_T2 numeric Not provided- Not provided- Not provided-
751202_751401_0_T1 numeric Not provided- Not provided- Not provided-
751204_751301_0_L1 numeric Not provided- Not provided- Not provided-
751205_751400_0_T2 numeric Not provided- Not provided- Not provided-
7526_753302_0_L1 numeric Not provided- Not provided- Not provided-
7526_892513_0_L1 numeric Not provided- Not provided- Not provided-
753304_753410_0_T1 numeric Not provided- Not provided- Not provided-
753305_753400_0_T2 numeric Not provided- Not provided- Not provided-
757402_737006_0_L1 numeric Not provided- Not provided- Not provided-
757403_757500_0_T1 numeric Not provided- Not provided- Not provided-
757404_892510_0_L1 numeric Not provided- Not provided- Not provided-
757405_757501_0_T2 numeric Not provided- Not provided- Not provided-
757600_757800_0_T1 numeric Not provided- Not provided- Not provided-
757601_7577_0_L1 numeric Not provided- Not provided- Not provided-
7577_892505_0_L1 numeric Not provided- Not provided- Not provided-
7620_716102_0_L1 numeric Not provided- Not provided- Not provided-
7620_762001_0_L1 numeric Not provided- Not provided- Not provided-
7620_762003_0_L1 numeric Not provided- Not provided- Not provided-
765100_601603_0_T1 numeric Not provided- Not provided- Not provided-
765101_601605_0_T2 numeric Not provided- Not provided- Not provided-
768603_751203_0_L1 numeric Not provided- Not provided- Not provided-
7686_768501_0_L1 numeric Not provided- Not provided- Not provided-
7686_768602_0_L1 numeric Not provided- Not provided- Not provided-
7686_768604_0_L1 numeric Not provided- Not provided- Not provided-
768800_705307_0_L1 numeric Not provided- Not provided- Not provided-
768801_705311_0_L1 numeric Not provided- Not provided- Not provided-
770500_770700_0_T2 numeric Not provided- Not provided- Not provided-
770502_770701_0_T3 numeric Not provided- Not provided- Not provided-
779803_779804_0_L1 numeric Not provided- Not provided- Not provided-
7798_779802_0_L1 numeric Not provided- Not provided- Not provided-
7807_780900_0_T1 numeric Not provided- Not provided- Not provided-
7807_872510_0_L1 numeric Not provided- Not provided- Not provided-
7808_780901_0_T2 numeric Not provided- Not provided- Not provided-
7808_872511_0_L1 numeric Not provided- Not provided- Not provided-
7810_781200_0_T1 numeric Not provided- Not provided- Not provided-
7810_898507_0_L1 numeric Not provided- Not provided- Not provided-
7811_781201_0_T2 numeric Not provided- Not provided- Not provided-
7811_898508_0_L2 numeric Not provided- Not provided- Not provided-
781300_781402_0_L1 numeric Not provided- Not provided- Not provided-
781301_781500_0_T1 numeric Not provided- Not provided- Not provided-
781406_718004_0_L1 numeric Not provided- Not provided- Not provided-
78141_781403_0_L1 numeric Not provided- Not provided- Not provided-
78141_78142_0_LA numeric Not provided- Not provided- Not provided-
78141_78142_0_LB numeric Not provided- Not provided- Not provided-
78142_898511_0_L1 numeric Not provided- Not provided- Not provided-
7814_781401_0_L1 numeric Not provided- Not provided- Not provided-
7814_781404_0_L1 numeric Not provided- Not provided- Not provided-
7814_781405_0_L1 numeric Not provided- Not provided- Not provided-
782200_782400_0_T1 numeric Not provided- Not provided- Not provided-
7823_733102_0_L1 numeric Not provided- Not provided- Not provided-
7823_753303_0_L1 numeric Not provided- Not provided- Not provided-
7823_782201_0_L1 numeric Not provided- Not provided- Not provided-
7837_783702_0_L1 numeric Not provided- Not provided- Not provided-
7837_783704_0_L1 numeric Not provided- Not provided- Not provided-
7871_886505_0_L1 numeric Not provided- Not provided- Not provided-
789802_10372_0_L1 numeric Not provided- Not provided- Not provided-
789802_10372_0_L2 numeric Not provided- Not provided- Not provided-
789803_708401_0_T1 numeric Not provided- Not provided- Not provided-
789804_872506_0_L2 numeric Not provided- Not provided- Not provided-
789805_708400_0_T2 numeric Not provided- Not provided- Not provided-
789806_872509_0_L1 numeric Not provided- Not provided- Not provided-
790700_7034_0_T2 numeric Not provided- Not provided- Not provided-
790701_7035_0_T3 numeric Not provided- Not provided- Not provided-
791100_791102_0_L1 numeric Not provided- Not provided- Not provided-
793000_600505_0_T1 numeric Not provided- Not provided- Not provided-
793001_600504_0_T2 numeric Not provided- Not provided- Not provided-
801004_768800_0_L1 numeric Not provided- Not provided- Not provided-
801005_768801_0_L1 numeric Not provided- Not provided- Not provided-
801603_873103_0_L1 numeric Not provided- Not provided- Not provided-
803004_873106_0_L1 numeric Not provided- Not provided- Not provided-
809102_809511_0_L1 numeric Not provided- Not provided- Not provided-
872103_872500_0_G1 numeric Not provided- Not provided- Not provided-
872501_872104_0_G2 numeric Not provided- Not provided- Not provided-
872507_745701_0_L1 numeric Not provided- Not provided- Not provided-
872512_744100_0_T1 numeric Not provided- Not provided- Not provided-
872513_744102_0_T2 numeric Not provided- Not provided- Not provided-
872514_744101_0_T3 numeric Not provided- Not provided- Not provided-
8726_801004_0_L1 numeric Not provided- Not provided- Not provided-
8726_872102_0_L1 numeric Not provided- Not provided- Not provided-
8727_801005_0_L1 numeric Not provided- Not provided- Not provided-
8727_872105_0_L1 numeric Not provided- Not provided- Not provided-
873104_873509_0_G1 numeric Not provided- Not provided- Not provided-
873105_873519_0_G2 numeric Not provided- Not provided- Not provided-
873505_717301_0_L1 numeric Not provided- Not provided- Not provided-
873523_716803_0_L1 numeric Not provided- Not provided- Not provided-
8738_803004_0_L1 numeric Not provided- Not provided- Not provided-
8739_705305_0_L1 numeric Not provided- Not provided- Not provided-
8739_734804_0_L1 numeric Not provided- Not provided- Not provided-
886100_809509_0_L1 numeric Not provided- Not provided- Not provided-
886101_886500_0_G1 numeric Not provided- Not provided- Not provided-
886201_886501_0_G2 numeric Not provided- Not provided- Not provided-
886506_7033_0_L1 numeric Not provided- Not provided- Not provided-
886507_7031_0_L3 numeric Not provided- Not provided- Not provided-
886509_104501_0_L1 numeric Not provided- Not provided- Not provided-
886511_770503_0_L3 numeric Not provided- Not provided- Not provided-
886512_7029_0_L1 numeric Not provided- Not provided- Not provided-
886513_7870_0_L1 numeric Not provided- Not provided- Not provided-
886514_791100_0_L1 numeric Not provided- Not provided- Not provided-
886515_7035_0_L3 numeric Not provided- Not provided- Not provided-
886516_108551_0_L1 numeric Not provided- Not provided- Not provided-
886517_770500_0_L1 numeric Not provided- Not provided- Not provided-
886518_7034_0_L1 numeric Not provided- Not provided- Not provided-
886519_7869_0_L1 numeric Not provided- Not provided- Not provided-
886520_7030_0_L2 numeric Not provided- Not provided- Not provided-
886521_7391_0_L2 numeric Not provided- Not provided- Not provided-
8920_898001_0_L1 numeric Not provided- Not provided- Not provided-
892102_8982_0_L1 numeric Not provided- Not provided- Not provided-
892103_892514_0_G1 numeric Not provided- Not provided- Not provided-
892104_8920_0_L1 numeric Not provided- Not provided- Not provided-
892105_892515_0_G2 numeric Not provided- Not provided- Not provided-
892502_748700_0_L1 numeric Not provided- Not provided- Not provided-
892503_21047_0_L1 numeric Not provided- Not provided- Not provided-
892506_748701_0_L2 numeric Not provided- Not provided- Not provided-
892507_9531_0_L1 numeric Not provided- Not provided- Not provided-
892508_737004_0_L1 numeric Not provided- Not provided- Not provided-
892511_762002_0_L1 numeric Not provided- Not provided- Not provided-
892512_733104_0_L1 numeric Not provided- Not provided- Not provided-
898002_809525_0_L2 numeric Not provided- Not provided- Not provided-
898003_898500_0_G1 numeric Not provided- Not provided- Not provided-
898101_898501_0_G2 numeric Not provided- Not provided- Not provided-
898102_809517_0_L1 numeric Not provided- Not provided- Not provided-
8982_8983_0_L1 numeric Not provided- Not provided- Not provided-
8983_898103_0_L1 numeric Not provided- Not provided- Not provided-
8998_779805_0_L1 numeric Not provided- Not provided- Not provided-
8998_899701_0_L1 numeric Not provided- Not provided- Not provided-
8998_9766_0_L1 numeric Not provided- Not provided- Not provided-
900500_900700_0_T1 numeric Not provided- Not provided- Not provided-
900600_900701_0_T2 numeric Not provided- Not provided- Not provided-
9012_898513_0_L1 numeric Not provided- Not provided- Not provided-
9012_901000_0_T1 numeric Not provided- Not provided- Not provided-
9013_898510_0_L1 numeric Not provided- Not provided- Not provided-
9013_901001_0_T2 numeric Not provided- Not provided- Not provided-
9471_10196_0_L1 numeric Not provided- Not provided- Not provided-
9471_600703_0_L1 numeric Not provided- Not provided- Not provided-
9471_947001_0_L1 numeric Not provided- Not provided- Not provided-
9531_953001_0_L1 numeric Not provided- Not provided- Not provided-
9531_977602_0_L1 numeric Not provided- Not provided- Not provided-
971808_970302_970290_S1 numeric Not provided- Not provided- Not provided-
971809_970304_970291_S2 numeric Not provided- Not provided- Not provided-
9766_976501_0_L1 numeric Not provided- Not provided- Not provided-
9771_600403_0_L1 numeric Not provided- Not provided- Not provided-
9771_873511_0_L1 numeric Not provided- Not provided- Not provided-
9771_977001_0_L1 numeric Not provided- Not provided- Not provided-
9776_977501_0_L1 numeric Not provided- Not provided- Not provided-
9776_977601_0_L1 numeric Not provided- Not provided- Not provided-
9816_981501_0_L1 numeric Not provided- Not provided- Not provided-
9816_9821_0_L1 numeric Not provided- Not provided- Not provided-
9821_762004_0_L1 numeric Not provided- Not provided- Not provided-
9821_982001_0_L1 numeric Not provided- Not provided- Not provided-
9922_809101_0_G1 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-