This page contains data on NGED’s distribution substations. It is comprised of the following 4 datasets:

• Substation Demand: details of the transformers used in each substations including their make, model, rating, day and night max demand values (kVA)

• Asset Types: details of all physical equipment within a substation including their make, model, role number and description

• Customers: details the customer demand on feeder within a substation including information such as max demand day and night per feeder (kVA)

• IDNO Connections: details the total agreed import and export capacity (kVA) for IDNOs supplied by each distribution substation

In addition to these datasets, you may also find useful the Distribution Substations dataset (also available on the Connected Data Portal), which provides details on network structure including information on the HV feeder and the Primary substation which feeds each distribution substation and number of customers served by a distribution substation.

The four datasets within this package and the Distribution Substations dataset can be joined together through using the substation number field which exists in all datasets. For further guidance on how to join these datasets please see the attached Entity Relationship Diagram.

To protect customer privacy, data related to substations serving five or fewer customers has been redacted from this dataset. This approach ensures that individual customers cannot be identified through publicly available information.

We understand that in certain cases, specific use cases may require access to redacted substation data. If you have a legitimate need for this information, please contact us at nged.data@nationalgrid.co.uk to discuss your requirements. Access may be granted on a case-by-case basis, subject to a formal review process and the signing of a Non-Disclosure Agreement (NDA).

Disclaimer

Whilst we use reasonable endeavours to ensure that the data contained within these datasets is accurate, we do not accept any responsibility or liability for, the accuracy or the completeness of the content, or any loss which may arise from reliance on this data and related information.