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
    Local authority planned changes to school places
  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 2023/24
  5. Step 5 Choose your filters

    Indicators
    • Additional places (permanent)
    • Bulge places (temporary for large cohort)
    • Places to remove (permanent)
    National curriculum year group
    • 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
    Column groups
    Column group 1
    2021/22
    2022/23
    2023/24
    Column group 2
    Additional places (permanent)
    Bulge places (temporary for large cohort)
    Places to remove (permanent)
    This is the latest data
    'Local authority planned changes to school places' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2021/22 and 2023/24
    2021/222022/232023/24
    Additional places (permanent)Bulge places (temporary for large cohort)Places to remove (permanent)Additional places (permanent)Bulge places (temporary for large cohort)Places to remove (permanent)Additional places (permanent)Bulge places (temporary for large cohort)Places to remove (permanent)
    North EastCounty Durham105001050043500
    Darlington000000000
    Gateshead000000000
    Hartlepool000000000
    Middlesbrough0005350053500
    Newcastle upon Tyne074-1707574-1907574-210
    North Tyneside000000000
    Northumberland030003000300
    Redcar and Cleveland000000000
    South Tyneside000000000
    Stockton-on-Tees0300200600200900
    Sunderland280003500037500
    North WestBlackburn with Darwen0000006000
    Blackpool000000000
    Bolton000000000
    Bury000000000
    Cheshire East2559002559001,305900
    Cheshire West and Chester185300335300335300
    Cumbria350035003500
    Halton000000000
    Knowsley000000000
    Lancashire350035003500
    Liverpool000000000
    Manchester240001,110001,35000
    Oldham015001500150
    Rochdale01300241800241800
    Salford150187015039701503970
    Sefton000000000
    St. Helens6015-2109015-21012015-210
    Stockport045004500450
    Tameside80002300-452600-45
    Trafford460006700067000
    Warrington0006150082500
    Wigan00004500600
    Wirral0530053-19053-38
    Yorkshire and The HumberBarnsley00-15000-15000-150
    Bradford2400-302400-302400-30
    Calderdale00000012500
    Doncaster1500-1403000-1401,0200-140
    East Riding of Yorkshire000000000
    Kingston upon Hull, City of190001,710001,71000
    Kirklees420005400054000
    Leeds76011001,58011002,3501100
    North East Lincolnshire000000000
    North Lincolnshire90001200015000
    North Yorkshire54000540001,02000
    Rotherham570008700094500
    Sheffield013700137001370
    Wakefield070007000700
    York3863007180071800
    East MidlandsDerby210002100021000
    Derbyshire60008620094400
    Leicester09000240002400
    Leicestershire390001,9610-602,8240-60
    Lincolnshire25370585420655420
    North Northamptonshire0125042012504201250
    Nottingham000000000
    Nottinghamshire345001,515002,74500
    Rutland0002100021000
    West Northamptonshire450200060026006002600
    West MidlandsBirmingham374135039413504141350
    Coventry150120069533006956000
    Dudley820008200097000
    Herefordshire, County of0001500015000
    Sandwell210002100021000
    Shropshire255005550055500
    Solihull26002060038600
    Staffordshire7853001,4756001,921600
    Stoke-on-Trent945009450094500
    Telford and Wrekin300006000070500
    Walsall105001050010500
    Warwickshire15000300001,24900
    Wolverhampton0450580450580450
    Worcestershire55290-10555290-10555290-105
    East of EnglandBedford000000000
    Cambridgeshire10500525001,03500
    Central Bedfordshire1,2000-7502,6100-7503,8100-750
    Essex3956002,16890-2102,238120-210
    Hertfordshire50412002,23815002,7301500
    Luton000000000
    Norfolk2,36013502,91013502,9101200
    Peterborough060006000600
    Southend-on-Sea000000000
    Suffolk210001,135001,28500
    Thurrock60001200018000
    South EastBracknell Forest030-36028030-39028030-390
    Brighton and Hove000000000
    Buckinghamshire6753002,2373002,267300
    East Sussex030-24046030-4204600-570
    Hampshire87075-1587075-301,08075-45
    Isle of Wight000000000
    Kent2,3516002,75324003,1733300
    Medway0150-140210150-140420150-140
    Milton Keynes210002100021000
    Oxfordshire710001,2800-1053,4730-175
    Portsmouth00001000300
    Reading000000000
    Slough000000000
    Southampton00-301200-1802400-330
    Surrey480120-270930120-360930120-360
    West Berkshire1650-3016530-9016560-150
    West Sussex0120002700303900
    Windsor and Maidenhead00091009100
    Wokingham4200-2106300-2106300-210
    South WestBath and North East Somerset03007060070900
    Bournemouth, Christchurch and Poole000000000
    Bristol, City of00-31500-31500-315
    Cornwall60007202801,025280
    Devon185004960-2006010-200
    Dorset901120901120901120
    Gloucestershire1,1084501,1084501,678450
    Isles of Scilly000000000
    North Somerset056005600560
    Plymouth000000000
    Somerset28005530097300
    South Gloucestershire03000300030-45
    Swindon50015003000
    Torbay030006000600
    Wiltshire270300697300772300
    Inner LondonCamden00-42000-63000-630
    City of London000000000
    Hackney300030003000
    Hammersmith and Fulham00-1,47000-1,68000-2,310
    Haringey000000000
    Islington000000000
    Kensington and Chelsea150300150300150300
    Lambeth735007350073500
    Lewisham000000000
    Newham600006000060000
    Southwark000000000
    Tower Hamlets2540-4206740-4209740-420
    Wandsworth400004000040000
    Westminster150001500015000
    Outer LondonBarking and Dagenham000000000
    Barnet890-1201180-2401470-360
    Bexley000000000
    Brent00000-21000-210
    Bromley570005700057000
    Croydon000000000
    Ealing000000000
    Enfield00000-3000-60
    Greenwich000000000
    Harrow000000000
    Havering300003000030000
    Hillingdon00000022500
    Hounslow000000000
    Kingston upon Thames030003000300
    Merton000000000
    Redbridge000000000
    Richmond upon Thames000000000
    Sutton07300196003490
    Waltham Forest150006000090000

    Footnotes

    1. z - Indicates data is not applicable.
    2. Cumulative places reported by local authorities in summer 2021 as planned to be added or removed. Includes only projects with a high degree of certainty of going ahead, usually where funding has been committed. Excludes nursery places.
    3. Excludes additional places in projects funded through central DfE programmes, such as Free Schools, unless local authorities have contributed their own funding to deliver additional places to these projects.
    4. Additional, bulge and places to remove are reported cumulatively.
    5. Bulge places are places used to accommodate a specific large cohort. They move through the school with this cohort. Additional places are permanent places that will not move through the school with a specific cohort.

    Save table

    Download Table

    Select file format:

    Related information