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