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 Select a data set or featured table

    Data set
    Estimates of future school place demand - places needed, spare places (place planning)
  3. Step 3 Choose locations

    Local authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford
  4. Step 4 Choose time period

    Time period
    2022/23 to 2028/29
  5. Step 5 Choose your filters

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

    This data is not from the latest release
    View latest data: Academic year 2022/23
    Estimated number of places needed: Additional need only for 'Estimates of future school place demand - places needed, spare places (place planning)' for Primary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2022/23 and 2026/27
    2022/232023/242024/252025/262026/27
    North EastCounty Durham8391617153
    Darlington00000
    Gateshead67001
    Hartlepool00000
    Middlesbrough14003
    Newcastle upon Tyne2427273366
    North Tyneside2211000
    Northumberland40332425
    Redcar and Cleveland130000
    South Tyneside58933922
    Stockton-on-Tees00000
    Sunderland177112219
    North WestBlackburn with Darwen1751216
    Blackpool00000
    Bolton290318372465485
    Bury4613000
    Cheshire East214228232303380
    Cheshire West and Chester195207231324388
    Cumbria6257504567
    Halton00000
    Knowsley6147654242
    Lancashire5258421,1071,3701,535
    Liverpool5666377178821,001
    Manchester00000
    Oldham3344890113
    Rochdale147175291384495
    Salford36121172198266
    Sefton3347665754
    St. Helens4660374642
    Stockport1715151610
    Tameside150000
    Trafford458160206189201
    Warrington149175223224140
    Wigan150172221298393
    Wirral7349393028
    Yorkshire and The HumberBarnsley00000
    Bradford14171697
    Calderdale60000
    Doncaster3886866249
    East Riding of Yorkshire4361678892
    Kingston upon Hull, City of3818606580
    Kirklees7936425632
    Leeds419409556585576
    North East Lincolnshire163150175156103
    North Lincolnshire142000
    North Yorkshire212184159144139
    Rotherham11111
    Sheffield236333389437349
    Wakefield67000
    York2222142428
    East MidlandsDerby10489113100135
    Derbyshire518441476623713
    Leicester350000
    Leicestershire3013935869051,119
    Lincolnshire310335387383302
    North Northamptonshire354271119174
    Nottingham92221
    Nottinghamshire425560649689676
    Rutland00000
    West Northamptonshire58156144213296
    West MidlandsBirmingham300372428483479
    Coventry3238414748
    Dudley5324000
    Herefordshire, County of121126117139159
    Sandwell13757000
    Shropshire66564781112
    Solihull2387215077194
    Staffordshire171207247374506
    Stoke-on-Trent00000
    Telford and Wrekin489496125215
    Walsall95101818197
    Warwickshire4768027789321,118
    Wolverhampton47417213
    Worcestershire193157212414440
    East of EnglandBedford150138266407448
    Cambridgeshire65187162246408
    Central Bedfordshire9127270408608
    Essex7158159521,1991,223
    Hertfordshire328336475521556
    Luton00000
    Norfolk15415975120159
    Peterborough151123154150123
    Southend-on-Sea2920000
    Suffolk4751121131160
    Thurrock12614314813876
    South EastBracknell Forest000058
    Brighton and Hove22000
    Buckinghamshire260168233170276
    East Sussex6228354051
    Hampshire5317488841,1891,127
    Isle of Wight1719222017
    Kent1,1421,4871,9762,7663,432
    Medway160178204229166
    Milton Keynes861189095162
    Oxfordshire2959685848
    Portsmouth1010848
    Reading00027
    Slough272161536
    Southampton00000
    Surrey1,0691,3801,5251,5061,269
    West Berkshire1525232020
    West Sussex9394205311387
    Windsor and Maidenhead24592
    Wokingham63535480124
    South WestBath and North East Somerset2528336194
    Bournemouth, Christchurch and Poole5834251412
    Bristol, City of40000
    Cornwall185157129144144
    Devon355445467529484
    Dorset18313812310287
    Gloucestershire160204410694987
    Isles of Scilly141414110
    North Somerset20461715
    Plymouth00001
    Somerset3310646
    South Gloucestershire496894145136
    Swindon474000
    Torbay2313500
    Wiltshire619441
    Inner LondonCamden00000
    City of London300000
    Hackney02000
    Hammersmith and Fulham00000
    Haringey00000
    Islington00000
    Kensington and Chelsea000410
    Lambeth00000
    Lewisham00000
    Newham00000
    Southwark00000
    Tower Hamlets478380345291302
    Wandsworth1918000
    Westminster00000
    Outer LondonBarking and Dagenham211172451
    Barnet00010
    Bexley00000
    Brent00000
    Bromley1800012
    Croydon5114112716
    Ealing11201
    Enfield10955421618
    Greenwich53000
    Harrow1440547169
    Havering73150243382455
    Hillingdon00100
    Hounslow00000
    Kingston upon Thames6192122224421
    Merton00000
    Redbridge1611000
    Richmond upon Thames2026184321
    Sutton1751131006933
    Waltham Forest333717

    Footnotes

    1. Estimates reflect the position reported by local authorities as at May 2022, supplemented with DFE internal data on centrally funded programmes due to add or remove school places.
    2. Estimates are provided from 2022/23 to 2026/27 for primary (Reception to Year 6) and from 2022/23 to 2028/29 for secondary (Year 7 to Year 11).

    Save table

    Download Table

    Select file format:

    Related information

    Our statistical practice is regulated by the Office for Statistics Regulation (OSR)