Pyle 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=5373bf81-cff3-4e8c-aa76-547f81a8b874&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=5373bf81-cff3-4e8c-aa76-547f81a8b874&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "5373bf81-cff3-4e8c-aa76-547f81a8b874",
        "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 = "5373bf81-cff3-4e8c-aa76-547f81a8b874", // 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: '5373bf81-cff3-4e8c-aa76-547f81a8b874', // 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=5373bf81-cff3-4e8c-aa76-547f81a8b874&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' => '5373bf81-cff3-4e8c-aa76-547f81a8b874', // 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
2212_2216_0_L1 numeric Not provided- Not provided- Not provided-
2212_590600_0_L1 numeric Not provided- Not provided- Not provided-
2213_590400_0_L1 numeric Not provided- Not provided- Not provided-
2216_549602_0_L1 numeric Not provided- Not provided- Not provided-
2219_549603_0_G1 numeric Not provided- Not provided- Not provided-
2252_2256_0_L1 numeric Not provided- Not provided- Not provided-
2253_2257_0_L1 numeric Not provided- Not provided- Not provided-
3735_3807_0_L1 numeric Not provided- Not provided- Not provided-
3735_548801_0_T1 numeric Not provided- Not provided- Not provided-
3738_548800_0_T2 numeric Not provided- Not provided- Not provided-
5132_5134_0_L1 numeric Not provided- Not provided- Not provided-
5132_5175_0_L1 numeric Not provided- Not provided- Not provided-
513503_5134_0_L1 numeric Not provided- Not provided- Not provided-
517103_547411_0_G7 numeric Not provided- Not provided- Not provided-
517106_590600_0_L1 numeric Not provided- Not provided- Not provided-
517107_547410_0_G6 numeric Not provided- Not provided- Not provided-
517109_590400_0_L1 numeric Not provided- Not provided- Not provided-
517112_554901_0_G5 numeric Not provided- Not provided- Not provided-
5175_554902_0_L1 numeric Not provided- Not provided- Not provided-
525800_5134_0_L1 numeric Not provided- Not provided- Not provided-
525800_513603_0_L1 numeric Not provided- Not provided- Not provided-
547402_547700_0_T1 numeric Not provided- Not provided- Not provided-
547403_547701_0_T2 numeric Not provided- Not provided- Not provided-
547408_547411_0_L1 numeric Not provided- Not provided- Not provided-
547410_547406_0_L1 numeric Not provided- Not provided- Not provided-
547502_5883_0_L1 numeric Not provided- Not provided- Not provided-
547503_547601_0_T1 numeric Not provided- Not provided- Not provided-
547504_547802_0_L1 numeric Not provided- Not provided- Not provided-
547600_547505_0_T2 numeric Not provided- Not provided- Not provided-
547803_547902_0_L1 numeric Not provided- Not provided- Not provided-
547903_548001_0_L1 numeric Not provided- Not provided- Not provided-
548200_547405_0_L1 numeric Not provided- Not provided- Not provided-
548303_548400_0_T1 numeric Not provided- Not provided- Not provided-
548305_548401_0_T2 numeric Not provided- Not provided- Not provided-
548501_548600_0_T1 numeric Not provided- Not provided- Not provided-
548900_3768_0_T2 numeric Not provided- Not provided- Not provided-
548901_3765_0_T1 numeric Not provided- Not provided- Not provided-
549003_548500_0_L1 numeric Not provided- Not provided- Not provided-
549004_3765_0_L1 numeric Not provided- Not provided- Not provided-
549005_3807_0_L1 numeric Not provided- Not provided- Not provided-
549006_549501_0_G1 numeric Not provided- Not provided- Not provided-
549007_3768_0_L1 numeric Not provided- Not provided- Not provided-
549008_548304_0_L1 numeric Not provided- Not provided- Not provided-
549009_548700_0_L1 numeric Not provided- Not provided- Not provided-
549010_3738_0_L1 numeric Not provided- Not provided- Not provided-
549101_549200_0_G1 numeric Not provided- Not provided- Not provided-
549102_2252_0_L1 numeric Not provided- Not provided- Not provided-
549104_549201_0_G2 numeric Not provided- Not provided- Not provided-
549105_2253_0_L1 numeric Not provided- Not provided- Not provided-
549503_549013_0_G2 numeric Not provided- Not provided- Not provided-
549504_517108_0_L1 numeric Not provided- Not provided- Not provided-
549505_2257_0_L1 numeric Not provided- Not provided- Not provided-
549506_2256_0_L1 numeric Not provided- Not provided- Not provided-
549506_517111_0_L1 numeric Not provided- Not provided- Not provided-
583309_583313_0_21 numeric Not provided- Not provided- Not provided-
583310_583314_0_22 numeric Not provided- Not provided- Not provided-
583315_2212_0_L1 numeric Not provided- Not provided- Not provided-
583316_2213_0_L1 numeric Not provided- Not provided- Not provided-
5881_5887_0_L1 numeric Not provided- Not provided- Not provided-
5882_548003_0_L1 numeric Not provided- Not provided- Not provided-
5883_547407_0_L1 numeric Not provided- Not provided- Not provided-
5884_548100_0_L1 numeric Not provided- Not provided- Not provided-
5885_547404_0_L1 numeric Not provided- Not provided- Not provided-
5885_5886_0_L1 numeric Not provided- Not provided- Not provided-
5885_5887_0_L1 numeric Not provided- Not provided- Not provided-
5886_5887_0_L1 numeric Not provided- Not provided- Not provided-
952804_952808_95320_S1 numeric Not provided- Not provided- Not provided-
952806_952809_95321_S2 numeric Not provided- Not provided- Not provided-
Half Hour timestamp Not provided- Not provided- Not provided-