Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

  1. Step 1 Choose a publication

    Publication
    School capacity
  2. Step 2 View a featured table or create your own

    Subject
    Estimates of future school place demand (place planning)
  3. Step 3 Choose locations

    Local Authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford
    • Bexley
    • Birmingham
    • Blackburn with Darwen
    • Blackpool
    • Bolton
    • Bournemouth, Christchurch and Poole
    • Bracknell Forest
    • Bradford
    • Brent
    • Brighton and Hove
    • Bristol, City of
    • Bromley
    • Buckinghamshire
    • Bury
    • Calderdale
    • Cambridgeshire
    • Camden
    • Central Bedfordshire
    • Cheshire East
    • Cheshire West and Chester
    • City of London
    • Cornwall
    • County Durham
    • Coventry
    • Croydon
    • Cumbria
    • Darlington
    • Derby
    • Derbyshire
    • Devon
    • Doncaster
    • Dorset
    • Dudley
    • Ealing
    • East Riding of Yorkshire
    • East Sussex
    • Enfield
    • Essex
    • Gateshead
    • Gloucestershire
    • Greenwich
    • Hackney
    • Halton
    • Hammersmith and Fulham
    • Hampshire
    • Haringey
    • Harrow
    • Hartlepool
    • Havering
    • Herefordshire, County of
    • Hertfordshire
    • Hillingdon
    • Hounslow
    • Isle of Wight
    • Isles of Scilly
    • Islington
    • Kensington and Chelsea
    • Kent
    • Kingston upon Hull, City of
    • Kingston upon Thames
    • Kirklees
    • Knowsley
    • Lambeth
    • Lancashire
    • Leeds
    • Leicester
    • Leicestershire
    • Lewisham
    • Lincolnshire
    • Liverpool
    • Luton
    • Manchester
    • Medway
    • Merton
    • Middlesbrough
    • Milton Keynes
    • Newcastle upon Tyne
    • Newham
    • Norfolk
    • North East Lincolnshire
    • North Lincolnshire
    • North Northamptonshire
    • North Somerset
    • North Tyneside
    • North Yorkshire
    • Northumberland
    • Nottingham
    • Nottinghamshire
    • Oldham
    • Oxfordshire
    • Peterborough
    • Plymouth
    • Portsmouth
    • Reading
    • Redbridge
    • Redcar and Cleveland
    • Richmond upon Thames
    • Rochdale
    • Rotherham
    • Rutland
    • Salford
    • Sandwell
    • Sefton
    • Sheffield
    • Shropshire
    • Slough
    • Solihull
    • Somerset
    • South Gloucestershire
    • South Tyneside
    • Southampton
    • Southend-on-Sea
    • Southwark
    • St. Helens
    • Staffordshire
    • Stockport
    • Stockton-on-Tees
    • Stoke-on-Trent
    • Suffolk
    • Sunderland
    • Surrey
    • Sutton
    • Swindon
    • Tameside
    • Telford and Wrekin
    • Thurrock
    • Torbay
    • Tower Hamlets
    • Trafford
    • Wakefield
    • Walsall
    • Waltham Forest
    • Wandsworth
    • Warrington
    • Warwickshire
    • West Berkshire
    • West Northamptonshire
    • West Sussex
    • Westminster
    • Wigan
    • Wiltshire
    • Windsor and Maidenhead
    • Wirral
    • Wokingham
    • Wolverhampton
    • Worcestershire
    • York
  4. Step 4 Choose time period

    Time period
    2021/22 to 2027/28
  5. Step 5 Choose your filters

    Indicators
    • Estimated number of places needed: Additional need only
    National curriculum year group
    • Secondary total
  6. Step 6 (current) Explore data

    Re-order table headers

    Drag and drop the options below to re-order the table headers. Hold the Ctrl key and click to select multiple items to drag and drop. For keyboard users, select and deselect a draggable item with space and use the arrow keys to move a selected item.

    To move an item with your keyboard, select or deselect the item with Space and use the Up and Down arrow keys to move the selected item. To move multiple items, you can press Ctrl and Enter to add an item to your selected items. If you are using a screen reader disable scan mode.

    Row groups
    Row group 1
    County Durham
    Darlington
    Gateshead
    Hartlepool
    Middlesbrough
    Newcastle upon Tyne
    North Tyneside
    Northumberland
    Redcar and Cleveland
    South Tyneside
    Stockton-on-Tees
    Sunderland
    Blackburn with Darwen
    Blackpool
    Bolton
    Bury
    Cheshire East
    Cheshire West and Chester
    Cumbria
    Halton
    Knowsley
    Lancashire
    Liverpool
    Manchester
    Oldham
    Rochdale
    Salford
    Sefton
    St. Helens
    Stockport
    Tameside
    Trafford
    Warrington
    Wigan
    Wirral
    Barnsley
    Bradford
    Calderdale
    Doncaster
    East Riding of Yorkshire
    Kingston upon Hull, City of
    Kirklees
    Leeds
    North East Lincolnshire
    North Lincolnshire
    North Yorkshire
    Rotherham
    Sheffield
    Wakefield
    York
    Derby
    Derbyshire
    Leicester
    Leicestershire
    Lincolnshire
    North Northamptonshire
    Nottingham
    Nottinghamshire
    Rutland
    West Northamptonshire
    Birmingham
    Coventry
    Dudley
    Herefordshire, County of
    Sandwell
    Shropshire
    Solihull
    Staffordshire
    Stoke-on-Trent
    Telford and Wrekin
    Walsall
    Warwickshire
    Wolverhampton
    Worcestershire
    Bedford
    Cambridgeshire
    Central Bedfordshire
    Essex
    Hertfordshire
    Luton
    Norfolk
    Peterborough
    Southend-on-Sea
    Suffolk
    Thurrock
    Bracknell Forest
    Brighton and Hove
    Buckinghamshire
    East Sussex
    Hampshire
    Isle of Wight
    Kent
    Medway
    Milton Keynes
    Oxfordshire
    Portsmouth
    Reading
    Slough
    Southampton
    Surrey
    West Berkshire
    West Sussex
    Windsor and Maidenhead
    Wokingham
    Bath and North East Somerset
    Bournemouth, Christchurch and Poole
    Bristol, City of
    Cornwall
    Devon
    Dorset
    Gloucestershire
    Isles of Scilly
    North Somerset
    Plymouth
    Somerset
    South Gloucestershire
    Swindon
    Torbay
    Wiltshire
    Camden
    City of London
    Hackney
    Hammersmith and Fulham
    Haringey
    Islington
    Kensington and Chelsea
    Lambeth
    Lewisham
    Newham
    Southwark
    Tower Hamlets
    Wandsworth
    Westminster
    Barking and Dagenham
    Barnet
    Bexley
    Brent
    Bromley
    Croydon
    Ealing
    Enfield
    Greenwich
    Harrow
    Havering
    Hillingdon
    Hounslow
    Kingston upon Thames
    Merton
    Redbridge
    Richmond upon Thames
    Sutton
    Waltham Forest
    Row group 2
    Estimated number of places needed: Additional need only
    Column groups
    Column group 1
    2021/22
    2022/23
    2023/24
    2024/25
    2025/26
    2026/27
    2027/28
    This is the latest data
    Estimated number of places needed: Additional need only for 'Estimates of future school place demand (place planning)' for Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2021/22 and 2027/28
    2021/222022/232023/242024/252025/262026/272027/28
    North EastCounty Durham147201228269312230218
    Darlington10100000
    Gateshead52210334484530591501
    Hartlepool0000000
    Middlesbrough0000000
    Newcastle upon Tyne37649653748734821094
    North Tyneside0000000
    Northumberland18622528115812714989
    Redcar and Cleveland1510814013513310359
    South Tyneside1410225253858
    Stockton-on-Tees015284226121
    Sunderland25517551515125
    North WestBlackburn with Darwen0000000
    Blackpool0034251620
    Bolton0000000
    Bury123163227203174160119
    Cheshire East428794484571651723761
    Cheshire West and Chester318329483479501438326
    Cumbria169218248226201196159
    Halton0000000
    Knowsley38648291698358
    Lancashire5017971,0971,1881,2061,1311,022
    Liverpool108262574772811965992
    Manchester0000000
    Oldham42246452924213000
    Rochdale42183368408370520653
    Salford7751127201242208222
    Sefton1114290413590
    St. Helens2335144139174169146
    Stockport3283119131143171166
    Tameside6698192243297199167
    Trafford16218689919171
    Warrington951612133934
    Wigan23228447576703754568
    Wirral0000000
    Yorkshire and The HumberBarnsley128197224180167195173
    Bradford158186201157116370
    Calderdale54127257357540371288
    Doncaster18515355534611
    East Riding of Yorkshire145156176154151139138
    Kingston upon Hull, City of1804514217016510563
    Kirklees175209224283303275154
    Leeds3766471,1191,9582,5142,4092,310
    North East Lincolnshire5412794279235356229
    North Lincolnshire11304561705446
    North Yorkshire211236301246250208204
    Rotherham1401341691561269484
    Sheffield6777649671,0471,0941,1811,290
    Wakefield022569110290115
    York145778797995458
    East MidlandsDerby0000000
    Derbyshire1541181091041039489
    Leicester356329220259326347319
    Leicestershire4291,0381,6642,2232,5102,4782,342
    Lincolnshire417498684641632590551
    North Northamptonshire00537470300
    Nottingham4325383123172178
    Nottinghamshire9031,1101,0761,3261,5071,4161,395
    Rutland7468151200
    West Northamptonshire471271296474192211
    West MidlandsBirmingham218552723588399462410
    Coventry1,4431,3241,7791,9131,9821,9362,002
    Dudley12047356245124
    Herefordshire, County of245233320420481432392
    Sandwell210426596680727763670
    Shropshire197200245238173202278
    Solihull9000000
    Staffordshire248295400463579663768
    Stoke-on-Trent02473115182345317
    Telford and Wrekin100186277349378315215
    Walsall82161184204161253274
    Warwickshire5279731,0751,6122,1952,7042,900
    Wolverhampton25139154183302297170
    Worcestershire1732714566597548741,068
    East of EnglandBedford5628001,1551,4661,9172,0812,298
    Cambridgeshire3667601,0591,2141,4141,4271,486
    Central Bedfordshire321536738679549441340
    Essex2553676567717879321,144
    Hertfordshire7468258701,0191,1971,3691,472
    Luton91210111188
    Norfolk415602794803881942836
    Peterborough716363372684
    Southend-on-Sea1101101101381404991
    Suffolk144174197259304273249
    Thurrock168178770000
    South EastBracknell Forest171202001837
    Brighton and Hove588989110997040
    Buckinghamshire19321223523115614887
    East Sussex96718882585454
    Hampshire704808741737584722853
    Isle of Wight0400200
    Kent1,0541,3281,6021,5751,5061,4431,554
    Medway183164323436446448389
    Milton Keynes00050150418371
    Oxfordshire210204259220207239276
    Portsmouth41465675879589
    Reading165280390450510575570
    Slough0000000
    Southampton155263232342485515380
    Surrey6741,2682,5293,0813,7554,3034,498
    West Berkshire100128126108644240
    West Sussex4937851,3341,7642,1382,5552,910
    Windsor and Maidenhead225190001
    Wokingham2388192298382391371
    South WestBath and North East Somerset287364389388364365304
    Bournemouth, Christchurch and Poole5323239424012
    Bristol, City of7201,0281,2241,3671,4421,4501,408
    Cornwall332385579690804883728
    Devon3105127959851,1431,2981,359
    Dorset111495221
    Gloucestershire003030323237
    Isles of Scilly770031110
    North Somerset1522021891561167933
    Plymouth0000000
    Somerset91433624181824
    South Gloucestershire01169134166224238
    Swindon32472972300
    Torbay474469372620
    Wiltshire259288313345456515635
    Inner LondonCamden0000000
    City of Londonzzzzzzz
    Hackney0000000
    Hammersmith and Fulham0000000
    Haringey0000000
    Islington0000000
    Kensington and Chelsea901241134923230
    Lambeth0000000
    Lewisham0000000
    Newham0000000
    Southwark0000000
    Tower Hamlets0000000
    Wandsworth0000000
    Westminster071133186220168115
    Outer LondonBarking and Dagenham0000000
    Barnet0000000
    Bexley0000000
    Brent17315659674830
    Bromley0000000
    Croydon00400000
    Ealing363448533548535472397
    Enfield514220000
    Greenwich0000000
    Harrow61195240275294275248
    Havering001117142858
    Hillingdon0000000
    Hounslow0000000
    Kingston upon Thames03581130276422532
    Merton0000000
    Redbridge0000000
    Richmond upon Thames4190132185229259280
    Sutton3640012029
    Waltham Forest0000000

    Footnotes

    1. A description of how these estimates have been derived and how to interpret them is provided in the school place planning estimates technical guidance accompanying this release (see supporting files under 'Explore data and files’).
    2. Estimates reflect the position reported by local authorities as at May 2021 in the 2021 School Capacity Survey, supplemented with data from administrative sources on centrally funded programmes.
    3. Estimates are provided from 2021/22 to 2025/26 for primary (Reception to Year 6) and from 2021/22 to 2027/28 for secondary (Year 7 to Year 11).

    Save table

    Download Table

    Select file format:

    Related information