Skip to content

Substation Loading

The net power flow through each GSP, BSP and primary substation. For each substation the data is presented against each relevant node in the network model to reflect the intact topology. Statistical data cleansing (identification and replacement of erroneous time-series values with imputed alternatives) is applied to the data to remove any erroneous outliers or populate any outage periods where necessary.

The polarity of loadings is based on conventional power flow (HV to LV). Demand connected at the bus is expressed as a positive value and generation connected at the bus is expressed as a negative value.

https://dso.nationalgrid.co.uk/curtailment-analysis-data-usage-guidance

Data Files

Name Format Last Changed Download
Ratcliffe Substation Load 10 csv
2 months ago
Staythorpe Substation Load 11 csv
2 months ago
Walpole Substation Load 12 csv
2 months ago
West Burton Substation Load 13 csv
2 months ago
Willington Substation Load 14 csv
2 months ago
Aberthaw and Cardiff East Substation Load 15 csv
2 months ago
Margam Substation Load 16 csv
2 months ago
Pembroke Substation Load 17 csv
2 months ago
Pyle Substation Load 18 csv
2 months ago
Rassau Substation Load 19 csv
2 months ago
Berkswell Substation Load 2 csv
2 months ago
Swansea North Substation Load 20 csv
2 months ago
Upper Boat Substation Load 21 csv
2 months ago
Uskmouth Substation Load 22 csv
2 months ago
Landulph, Abham, Exeter Substation Load 23 csv
2 months ago
Alverdiscott, Indian Queens Substation Load 24 csv
2 months ago
Axminster Substation Load 25 csv
2 months ago
Taunton, Bridgwater Substation Load 26 csv
2 months ago
Iron Acton (SWe) Substation Load 27 csv
2 months ago
Melksham Substation Load 28 csv
2 months ago
Seabank, Sandford Substation Load 29 csv
2 months ago
Bicker Fen Substation Load 3 csv
2 months ago
Bishops Wood Substation Load 30 csv
2 months ago
Bushbury Substation Load 31 csv
2 months ago
Bustleholm Substation Load 32 csv
2 months ago
Cellarhead Substation Load 33 csv
2 months ago
Feckenham Substation Load 34 csv
2 months ago
Iron Acton (WM) Substation Load 35 csv
2 months ago
Ironbridge and Shrewsbury Substation Load 36 csv
2 months ago
Kitwell Substation Load 37 csv
2 months ago
Lea Marston (WM) Substation Load 38 csv
2 months ago
Nechells East Substation Load 39 csv
2 months ago
Chesterfield Substation Load 4 csv
2 months ago
Ocker Hill Substation Load 40 csv
2 months ago
Oldbury Substation Load 41 csv
2 months ago
Penn Substation Load 42 csv
2 months ago
Portham Substation Load 43 csv
2 months ago
Rugeley Substation Load 44 csv
2 months ago
Willenhall Substation Load 45 csv
2 months ago
Coventry Substation Load 5 csv
2 months ago
Drakelow Substation Load 6 csv
2 months ago
East Claydon (EM) Substation Load 7 csv
2 months ago
Enderby Substation Load 8 csv
2 months ago
Grendon Substation Load 9 csv
2 months ago

Additional Info

Field Value
Uploaded Date November 26, 2025, 10:19 (UTC)
Creator National Grid Electricity Distribution
Created Date November 26, 2025, 00:00 (UTC)
Rights NGED Open Data Licence
Coverage All Regions
Contributor Digitalisation & Data
Identifier SLF
Publisher DSO
Relation PELTD BLF
Language EN
Data Classification Open
Update Frequency 12 Months
Expiration Date November 26, 2026, 00:00 (UTC)

Integrate this dataset using cURL

# Get a list of dataset's resources

curl -L -s https://connecteddata.nationalgrid.co.uk/dataset/substation-loading/datapackage.json | grep path

# Get resources

curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/b011d069-e4ca-46e6-a919-e089d5af2c57/download/ratcliffe_substation_load_10.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/d1776063-047a-4cc4-8c3e-2562ce6c39dc/download/staythorpe_substation_load_11.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/5af6da9c-1a1e-4ed9-ba92-ea8daa1cbbde/download/walpole_substation_load_12.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/2c2aa943-92b2-4eea-a21d-2a44eef48101/download/west-burton_substation_load_13.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/7d529d14-70ad-48d5-9803-630eda55df46/download/willington_substation_load_14.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/b2dbf1a4-ce66-4693-94a7-dee14df1e519/download/aberthaw-and-cardiff-east_substation_load_15.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/64ac4a55-6873-4a1b-a457-967ff85baf94/download/margam_substation_load_16.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/d191a5fa-dad8-4b1b-a7c3-73668c87c3ae/download/pembroke_substation_load_17.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/056cbff5-ebd5-4351-bfba-5e8146fc8b77/download/pyle_substation_load_18.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/95579e7f-aa4b-4b09-bff1-17a4debfde91/download/rassau_substation_load_19.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/f3ccf6dc-2975-44c5-bd3e-eaf479acb372/download/berkswell_substation_load_2.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/034be401-1ad6-4553-a1bc-b71f45502068/download/swansea-north_substation_load_20.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/23e63930-6f2e-434b-af2b-bafc473ba5ff/download/upper-boat_substation_load_21.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/9980c2c1-f218-46a6-a087-97d9d3b791b0/download/uskmouth_substation_load_22.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/5e88b679-abc7-400a-a61a-41bba29873de/download/landulph-abham-exeter_substation_load_23.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/10389a6a-9fad-4b4d-a5e6-6536497ec667/download/alverdiscott-indian-queens_substation_load_24.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/49a55de5-58b3-42d2-9eb5-e6d61fd53a54/download/axminster_substation_load_25.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/6479ef58-fa20-4d29-8f5d-b5018b1f5a34/download/taunton-bridgwater_substation_load_26.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/af03edd0-c271-475b-9a4b-913cdee82c8c/download/iron-acton-swe_substation_load_27.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/7b7dbb6e-9e60-43ee-9e0c-4e64c30c462a/download/melksham_substation_load_28.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/7fd02e1d-9c1f-4756-b008-50141bfbadc0/download/seabank-sandford_substation_load_29.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/4b8ffd61-681a-4617-bf3d-b0fba9995bc2/download/bicker-fen_substation_load_3.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/e7314584-4020-4b2c-81fd-34a3eff3f70a/download/bishops-wood_substation_load_30.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/ac1ee631-69d3-47f6-839e-e94f54d8693a/download/bushbury_substation_load_31.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/a068a4da-2664-447f-96fd-f0f58487154a/download/bustleholm_substation_load_32.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/260ebb80-e93b-4170-ba8d-a92db42484cc/download/cellarhead_substation_load_33.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/f2f32c65-bca6-41dd-ab14-3e7b7e0ae7df/download/feckenham_substation_load_34.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/bcab87c8-1119-4b63-b409-0d5cfd4f711d/download/iron-acton-wm_substation_load_35.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/1b7a7f51-a6ac-4073-b251-46fd35f0e057/download/ironbridge-and-shrewsbury_substation_load_36.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/aaa81afa-daf6-4427-836a-62b74f51a12e/download/kitwell_substation_load_37.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/ae52e82f-da6e-45c3-a6d1-0d67044834fe/download/lea-marston-wm_substation_load_38.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/0bc59213-1673-439b-8e13-3fa024beef0a/download/nechells-east_substation_load_39.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/1e92d58d-078d-4c09-a4cc-d15b0377ca59/download/chesterfield_substation_load_4.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/1631d927-3147-429c-bfcf-4996e7167a43/download/ocker-hill_substation_load_40.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/b9cec755-d04d-40b0-93ad-0d17fe7e7412/download/oldbury_substation_load_41.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/c4caafd5-b2f5-408f-908f-66bb1325ab0e/download/penn_substation_load_42.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/5145c01c-469b-467b-ab13-9621b0958213/download/portham_substation_load_43.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/a79dbd90-cde5-468b-b860-ad39420c688e/download/rugeley_substation_load_44.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/c4ee7d17-900b-47e3-81e3-e4af9bf9def2/download/willenhall_substation_load_45.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/ad1e731e-4f97-4c07-a847-54ba7c94e2cc/download/coventry_substation_load_5.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/97952a5e-40de-4281-95ed-dcf1c6b9a04a/download/drakelow_substation_load_6.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/4213beed-b24e-49dc-8c43-d3be752e24b4/download/east-claydon-em_substation_load_7.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/22aab8d0-a16c-4c02-9d35-dda0e1e99c03/download/enderby_substation_load_8.csv
curl -L https://connecteddata.nationalgrid.co.uk/dataset/ef70c80f-1b03-4c58-b1af-b63197764642/resource/a4db549c-8a5e-4cfb-841a-82111eabd74f/download/grendon_substation_load_9.csv