Customer Connections Profile - Census Area — SPENOpenDataPortal

The "Customer Connections Profile - Census Area" data table provides summary information on the number of import and export customers, by connection voltage and customer type, at Census Zone level (Datazones in Scotland, Output Areas in England & Wales).

This data has been published to give the users information which allows them to better understand the types of demand and generation for each level of aggregation.

The table gives the following information:

A unique identifier for each record (the Census Zone Name, the LV Transformer ENID, the HV Circuit ID, the Primary Substation ENID).
The number of SPEN connections in each of the groups (import and export, LV / HV / EHV).

For additional information on column definitions, please click the Dataset schema link below.

Disclaimer

Whilst all reasonable care has been taken in the preparation of this data, SP Energy Networks does not accept any responsibility or liability for the accuracy or completeness of this data, and is not liable for any loss that may be attributed to the use of this data. For the avoidance of doubt, this data should not be used for safety critical purposes without the use of appropriate safety checks and services e.g. LineSearchBeforeUDig etc. Please raise any potential issues with the data which you have received via the feedback form available at the Feedback tab above (must be logged in to see this).

Cells where the residential customer count is four properties or less have been set to null in the published tables.

Data Triage

As part of our commitment to enhancing the transparency, and accessibility of the data we share, we publish the results of our Data Triage process.

Our Data Triage documentation includes our Risk Assessments; detailing any controls we have implemented to prevent exposure of sensitive information. Click here to access the Data Triage documentation for the Distribution Network Live Outages dataset.

To access our full suite of Data Triage documentation, visit the SP Energy Networks Data & Information.

Download dataset metadata (JSON)

Dataset Identifier

customer_connections_profile_census_area

Downloads

1

Themes

Flexibility

Keywords

Flexibility, Customer Counts, Census Zones

Language

English

Modified

26 June 2025 18:22

Publisher

SP Energy Networks SC389555

Update frequency

Quarterly

Coverage

North Wales, Merseyside, Cheshire and North Shropshire, Central Belt and South of Scotland

Creator

SP Energy Networks SC389555

Subject

Flexibility, Customer Counts, Census Zone

Contributor

SP Energy Networks SC389555

Type

Dataset

Format

CSV, JSON, XLSX

Source

SP Energy Networks SC389555

Relation

Flexibility Datasets

Rights

Creative Commons Attribution 4.0 International

Follow

By subscribing to this dataset, you can receive email notifications from the dataset's publisher if important changes happen.

Last processing

21 July 2025 12:58 (metadata)

26 June 2025 18:22 (data)

Attachments

Click to expand Click to collapse

Dataset schema

Click to expand Click to collapse

Census Zone Code

The code of the Census Zone that the circuit is fed from.

No description available for this field.

Name (identifier)	census_zone_code
Type	text
Sample

Licence Area

No description available for this field.

Name (identifier)	licence_area
Type	text
Sample

Residential - Import

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	residential_import
Type	decimal
Sample

Residential - Export

The number of export MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	residential_export
Type	decimal
Sample

Non-residential - Import - EHV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_import_ehv
Type	decimal
Sample

Non-residential - Export - EHV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_export_ehv
Type	decimal
Sample

Non-residential - Import - HV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_import_hv
Type	decimal
Sample

Non-residential - Export - HV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_export_hv
Type	decimal
Sample

Non-residential - Import - LV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_import_lv
Type	decimal
Sample

Non-residential - Export - LV

The number of import MPANs associated with residential properties on the circuit.

No description available for this field.

Name (identifier)	non_residential_export_lv
Type	decimal
Sample

JSON Schema

The following JSON object is a standardized description of your dataset's schema. More about JSON schema.

{

"title":"customer_connections_profile_census_area",
"type":"object",
"oneOf":
[
- {
  - "$ref":"#/definitions/customer_connections_profile_census_area"
  }
]
,
"definitions":
{
- "customer_connections_profile_census_area":
  {
  - "properties":
    {
    "records":
    {
    "type":"array",
    "items":
    {
    "$ref":"#/definitions/customer_connections_profile_census_area_records"
    }
    }
    }
  }
  ,
- "customer_connections_profile_census_area_records":
  {
  - "properties":
    {
    "fields":
    {
    "type":"object",
    "properties":
    {
    "census_zone_code":
    {
    "type":"string",
    "title":"Census Zone Code",
    "description":"The code of the Census Zone that the circuit is fed from."
    }
    ,
    "licence_area":
    {
    "type":"string",
    "title":"Licence Area",
    "description":""
    }
    ,
    "residential_import":
    {
    "type":"number",
    "title":"Residential - Import",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "residential_export":
    {
    "type":"number",
    "title":"Residential - Export",
    "description":"The number of export MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_import_ehv":
    {
    "type":"number",
    "title":"Non-residential - Import - EHV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_export_ehv":
    {
    "type":"number",
    "title":"Non-residential - Export - EHV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_import_hv":
    {
    "type":"number",
    "title":"Non-residential - Import - HV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_export_hv":
    {
    "type":"number",
    "title":"Non-residential - Export - HV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_import_lv":
    {
    "type":"number",
    "title":"Non-residential - Import - LV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    ,
    "non_residential_export_lv":
    {
    "type":"number",
    "title":"Non-residential - Export - LV",
    "description":"The number of import MPANs associated with residential properties on the circuit."
    }
    }
    }
    }
  }
}

}

Reuses

Click to expand Click to collapse

Show more... Show less...

Submit a reuse

Click to expand Click to collapse

Last name

Your last name will be publicly displayed with your reuse

First name

Your first name will be publicly displayed with your reuse

Email

Your email will not be published publicly and will only be used by the administrators to contact you.

Reuse title

Short description of your work (max. 50 characters)

Description

A longer description of what you achieved using this dataset (max. 1000 characters)

URL

An URL where your work can be accessed publicly

Thumbnail

or

(optional) An URL or an image which illustrates your work

false

Please login to submit a new reuse.

Similar datasets

Customer Connections Profile - HV Feeder

The "Customer Connections Profile - HV Feeder" data table provides summary information on the number of import and export customers, by connection voltage and customer type, at HV Feeder level.
Customer Connections Profile - LV Transformer

The "Customer Connections Profile - LV Transformer" data table provides summary information on the number of import and export customers, by connection voltage and customer type, at LV Transformer level.
Customer Connections Profile - Primary Substations

The "Customer Connections Profile - Primary Substations" data table provides summary information on the number of import and export customers by connection voltage and customer type, at Primary Substation level.
Smart Meter Penetration by Census-Area

The "Smart Meter Penetration by Census Zone" data table provides aggregated information giving the percentage of Smart Meter penetration (also broken down by Smart Meter Type i.e. SMETS1 or SMETS2) by Census Zone. In Scotland the census zones are at Datazone level, in England and Wales the census zones are at Output Area level.