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
    Permanent exclusions and suspensions in England
  2. Step 2 View a featured table or create your own

    Subject
    Permanent exclusions and suspensions - by geography (2006-07 to 2019-20)
  3. Step 3 Choose locations

    Local Authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford
    • Bedfordshire (Pre LGR 2009)
    • Bexley
    • Birmingham
    • Blackburn with Darwen
    • Blackpool
    • Bolton
    • Bournemouth
    • Bournemouth Christchurch and Poole
    • Bracknell Forest
    • Bradford
    • Brent
    • Brighton and Hove
    • Bristol City of
    • Bromley
    • Buckinghamshire
    • Bury
    • Calderdale
    • Cambridgeshire
    • Camden
    • Central Bedfordshire
    • Cheshire (Pre LGR 2009)
    • Cheshire East
    • Cheshire West and Chester
    • City of London
    • Cornwall
    • Coventry
    • Croydon
    • Cumbria
    • Darlington
    • Derby
    • Derbyshire
    • Devon
    • Doncaster
    • Dorset (E06000059)
    • Dorset (E10000009)
    • Dudley
    • Durham
    • Ealing
    • East Riding of Yorkshire
    • East Sussex
    • Enfield
    • Essex
    • Gateshead (E08000020)
    • Gateshead (E08000037)
    • Gloucestershire
    • Greenwich
    • Hackney
    • Halton
    • Hammersmith and Fulham
    • Hampshire
    • Haringey
    • Harrow
    • Hartlepool
    • Havering
    • Herefordshire
    • 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 Somerset
    • North Tyneside
    • North Yorkshire
    • Northamptonshire
    • Northumberland (E06000048)
    • Northumberland (E06000057)
    • Nottingham
    • Nottinghamshire
    • Oldham
    • Oxfordshire
    • Peterborough
    • Plymouth
    • Poole
    • Portsmouth
    • Pre-LGR 2019 Bournemouth
    • Pre-LGR 2019 Dorset
    • Pre-LGR 2019 Poole
    • 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 Sussex
    • Westminster
    • Wigan
    • Wiltshire
    • Windsor and Maidenhead
    • Wirral
    • Wokingham
    • Wolverhampton
    • Worcestershire
    • York
  4. Step 4 Choose time period

    Time period
    2019/20
  5. Step 5 Choose your filters

    Indicators
    • Permanent exclusions
    • Permanent exclusions (rate)
    School Type
    • 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
    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
    Coventry
    Croydon
    Cumbria
    Darlington
    Derby
    Derbyshire
    Devon
    Doncaster
    Dorset
    Dudley
    Durham
    Ealing
    East Riding of Yorkshire
    East Sussex
    Enfield
    Essex
    Gateshead
    Gloucestershire
    Greenwich
    Hackney
    Halton
    Hammersmith and Fulham
    Hampshire
    Haringey
    Harrow
    Hartlepool
    Havering
    Herefordshire
    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
    Northamptonshire
    North East Lincolnshire
    North Lincolnshire
    North Somerset
    North Tyneside
    Northumberland
    North Yorkshire
    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
    Southampton
    Southend-on-Sea
    South Gloucestershire
    South Tyneside
    Southwark
    Staffordshire
    St. Helens
    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
    Westminster
    West Sussex
    Wigan
    Wiltshire
    Windsor and Maidenhead
    Wirral
    Wokingham
    Wolverhampton
    Worcestershire
    York
    Row group 2
    2019/20
    Column groups
    Column group 1
    Permanent exclusions
    Permanent exclusions (rate)
    This is the latest data
    WarningSome rows and columns are not shown in this table as the data does not exist in the underlying file.
    'Permanent exclusions and suspensions - by geography (2006-07 to 2019-20)' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 146 other locations for 2019/20
    Permanent exclusionsPermanent exclusions (rate)
    Outer LondonBarking and Dagenham150.03
    Barnet180.03
    Yorkshire and The HumberBarnsley410.12
    South WestBath and North East Somerset220.08
    East of EnglandBedford440.15
    Outer LondonBexley360.08
    West MidlandsBirmingham1600.08
    North WestBlackburn with Darwen220.08
    Blackpool140.07
    Bolton860.17
    South WestBournemouth Christchurch and Poole600.12
    South EastBracknell Forest10.01
    Yorkshire and The HumberBradford550.06
    Outer LondonBrent130.03
    South EastBrighton and Hove30.01
    South WestBristol City of40.01
    Outer LondonBromley210.04
    South EastBuckinghamshire290.03
    North WestBury140.05
    Yorkshire and The HumberCalderdale270.07
    East of EnglandCambridgeshire70.01
    Inner LondonCamden90.04
    East of EnglandCentral Bedfordshire340.07
    North WestCheshire East210.04
    Cheshire West and Chester280.06
    Inner LondonCity of London00.00
    South WestCornwall810.11
    West MidlandsCoventry270.05
    Outer LondonCroydon270.05
    North WestCumbria520.07
    North EastDarlington170.11
    East MidlandsDerby330.08
    Derbyshire1220.11
    South WestDevon600.06
    Yorkshire and The HumberDoncaster480.10
    South WestDorset350.07
    West MidlandsDudley500.10
    North EastDurham640.09
    Outer LondonEaling180.03
    Yorkshire and The HumberEast Riding of Yorkshire250.06
    South EastEast Sussex370.05
    Outer LondonEnfield150.03
    East of EnglandEssex740.03
    North EastGateshead320.11
    South WestGloucestershire520.06
    Outer LondonGreenwich90.02
    Inner LondonHackney250.07
    North WestHalton190.10
    Inner LondonHammersmith and Fulham130.06
    South EastHampshire390.02
    Inner LondonHaringey180.05
    Outer LondonHarrow150.04
    North EastHartlepool30.02
    Outer LondonHavering40.01
    West MidlandsHerefordshire150.06
    East of EnglandHertfordshire960.05
    Outer LondonHillingdon270.05
    Hounslow280.06
    South EastIsle of Wight100.06
    South WestIsles Of Scilly00.00
    Inner LondonIslington120.05
    Kensington and Chelsea70.05
    South EastKent150.01
    Yorkshire and The HumberKingston upon Hull City of230.06
    Outer LondonKingston upon Thames60.02
    Yorkshire and The HumberKirklees540.08
    North WestKnowsley100.05
    Inner LondonLambeth50.01
    North WestLancashire1620.09
    Yorkshire and The HumberLeeds100.01
    East MidlandsLeicester200.03
    Leicestershire220.02
    Inner LondonLewisham110.03
    East MidlandsLincolnshire500.05
    North WestLiverpool790.11
    East of EnglandLuton160.04
    North WestManchester560.06
    South EastMedway230.05
    Outer LondonMerton50.02
    North EastMiddlesbrough300.12
    South EastMilton Keynes70.01
    North EastNewcastle upon Tyne550.14
    Inner LondonNewham350.06
    East of EnglandNorfolk1130.10
    East MidlandsNorthamptonshire790.07
    Yorkshire and The HumberNorth East Lincolnshire170.07
    North Lincolnshire200.08
    South WestNorth Somerset300.10
    North EastNorth Tyneside180.06
    Northumberland370.08
    Yorkshire and The HumberNorth Yorkshire400.05
    East MidlandsNottingham610.13
    Nottinghamshire290.02
    North WestOldham410.09
    South EastOxfordshire440.05
    East of EnglandPeterborough390.10
    South WestPlymouth430.11
    South EastPortsmouth120.05
    Reading130.06
    Outer LondonRedbridge250.04
    North EastRedcar and Cleveland320.15
    Outer LondonRichmond upon Thames100.04
    North WestRochdale460.13
    Yorkshire and The HumberRotherham300.07
    East MidlandsRutland30.05
    North WestSalford380.10
    West MidlandsSandwell430.07
    North WestSefton160.04
    Yorkshire and The HumberSheffield570.07
    West MidlandsShropshire310.08
    South EastSlough70.02
    West MidlandsSolihull410.10
    South WestSomerset660.09
    South EastSouthampton160.05
    East of EnglandSouthend-on-Sea30.01
    South WestSouth Gloucestershire410.10
    North EastSouth Tyneside240.11
    Inner LondonSouthwark100.02
    West MidlandsStaffordshire1140.09
    North WestSt. Helens190.07
    Stockport400.09
    North EastStockton-on-Tees300.09
    West MidlandsStoke-on-Trent330.08
    East of EnglandSuffolk1010.10
    North EastSunderland560.14
    South EastSurrey510.03
    Outer LondonSutton290.07
    South WestSwindon270.08
    North WestTameside510.14
    West MidlandsTelford and Wrekin250.08
    East of EnglandThurrock170.06
    South WestTorbay220.11
    Inner LondonTower Hamlets10.00
    North WestTrafford340.08
    Yorkshire and The HumberWakefield510.10
    West MidlandsWalsall430.08
    Outer LondonWaltham Forest180.04
    Inner LondonWandsworth40.01
    North WestWarrington120.04
    West MidlandsWarwickshire550.07
    South EastWest Berkshire80.03
    Inner LondonWestminster90.04
    South EastWest Sussex850.07
    North WestWigan520.11
    South WestWiltshire130.02
    South EastWindsor and Maidenhead210.09
    North WestWirral180.04
    South EastWokingham130.05
    West MidlandsWolverhampton740.16
    Worcestershire560.07
    Yorkshire and The HumberYork130.05

    Save table

    Download Table

    Select file format: