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
    Planned LA and school expenditure
  2. Step 2 View a featured table or create your own

    Subject
    S251 Budget - planned expenditure on high needs 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
    • 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
    • Cornwall
    • County Durham
    • Coventry
    • Croydon
    • Cumbria
    • Darlington
    • Derby
    • Derbyshire
    • Devon
    • Doncaster
    • Dorset (E06000059)
    • Dorset (E10000009)
    • 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
    • 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
    • Northamptonshire
    • Northumberland
    • Nottingham
    • Nottinghamshire
    • Oldham
    • Oxfordshire
    • Peterborough
    • Plymouth
    • Poole
    • 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
    Regional
    • East Midlands
    • East of England
    • Inner London
    • North East
    • North West
    • Outer London
    • South East
    • South West
    • West Midlands
    • Yorkshire and The Humber
    National
    • England
  4. Step 4 Choose time period

    Time period
    2021-22
  5. Step 5 Choose your filters

    Indicators
    • Number of PRU places between April and August
    • Number of PRU places between September and March
    • Number of SEN places between April and August
    • Number of SEN places between September and March
    • Number of hospital education places between April and August
    • Number of hospital education places between September and March
    • Total funding for PRU places
    • Total funding for SEN places
    • Total funding for hospital education places
  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
    Cornwall
    County Durham
    Coventry
    Croydon
    Cumbria
    Darlington
    Derby
    Derbyshire
    Devon
    Doncaster
    Dorset
    Dudley
    Ealing
    East Midlands
    East of England
    East Riding of Yorkshire
    East Sussex
    Enfield
    England
    Essex
    Gateshead
    Gloucestershire
    Greenwich
    Hackney
    Halton
    Hammersmith and Fulham
    Hampshire
    Haringey
    Harrow
    Hartlepool
    Havering
    Herefordshire, County of
    Hertfordshire
    Hillingdon
    Hounslow
    Inner London
    Isle of Wight
    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
    North Lincolnshire
    North Northamptonshire
    North Somerset
    North Tyneside
    Northumberland
    North West
    North Yorkshire
    Nottingham
    Nottinghamshire
    Oldham
    Outer London
    Oxfordshire
    Peterborough
    Plymouth
    Portsmouth
    Reading
    Redbridge
    Redcar and Cleveland
    Richmond upon Thames
    Rochdale
    Rotherham
    Rutland
    Salford
    Sandwell
    Sefton
    Sheffield
    Shropshire
    Slough
    Solihull
    Somerset
    Southampton
    South East
    Southend-on-Sea
    South Gloucestershire
    South Tyneside
    Southwark
    South West
    Staffordshire
    St. Helens
    Stockport
    Stockton-on-Tees
    Stoke-on-Trent
    Suffolk
    Sunderland
    Surrey
    Sutton
    Swindon
    Tameside
    Telford and Wrekin
    Torbay
    Tower Hamlets
    Trafford
    Wakefield
    Walsall
    Waltham Forest
    Wandsworth
    Warrington
    Warwickshire
    West Berkshire
    West Midlands
    Westminster
    West Northamptonshire
    West Sussex
    Wigan
    Wiltshire
    Windsor and Maidenhead
    Wirral
    Wokingham
    Wolverhampton
    Worcestershire
    York
    Yorkshire and The Humber
    Column groups
    Column group 1
    Number of SEN places between April and August
    Number of SEN places between September and March
    Total funding for SEN places
    Number of PRU places between April and August
    Number of PRU places between September and March
    Total funding for PRU places
    Number of hospital education places between April and August
    Number of hospital education places between September and March
    Total funding for hospital education places
    Column group 2
    2021-22
    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.
    'S251 Budget - planned expenditure on high needs places' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 154 other locations for 2021-22
    Number of SEN places between April and AugustNumber of SEN places between September and MarchTotal funding for SEN placesNumber of PRU places between April and AugustNumber of PRU places between September and MarchTotal funding for PRU placesNumber of hospital education places between April and AugustNumber of hospital education places between September and MarchTotal funding for hospital education places
    Outer LondonBarking and Dagenham697737£5,782,000189189£1,890,00000£0
    Barnet468495£4,797,689140140£1,400,0003838£631,202
    Yorkshire and The HumberBarnsley2727£162,00000£000£0
    South WestBath and North East Somerset1010£76,00000£000£0
    East of EnglandBedford8787£862,00000£000£0
    Outer LondonBexley140140£1,212,50000£000£0
    West MidlandsBirmingham3,1673,110£30,600,50000£000£0
    North WestBlackburn with Darwen276288£2,698,000166166£1,660,00000£0
    Blackpool205225£2,166,667200185£1,912,50000£0
    Bolton508508£4,992,00000£000£0
    South WestBournemouth, Christchurch and Poole585585£5,850,0004848£480,00000£0
    South EastBracknell Forest262285£2,506,5005656£560,00000£0
    Yorkshire and The HumberBradford895895£8,055,6009090£900,00000£0
    Outer LondonBrent109109£890,0008282£820,00055£50,000
    South EastBrighton and Hove513523£4,984,3338888£880,00000£0
    South WestBristol, City of592592£5,920,00000£000£0
    Outer LondonBromley420420£4,120,00000£000£0
    South EastBuckinghamshire1,3241,324£12,768,0004646£460,00000£0
    North WestBury231232£2,374,198136136£1,449,76000£0
    Yorkshire and The HumberCalderdale407407£4,070,00000£000£0
    East of EnglandCambridgeshire486522£4,996,33300£06060£711,651
    Inner LondonCamden417425£3,850,0008585£850,000271289£3,193,692
    East of EnglandCentral Bedfordshire482509£4,869,22200£000£0
    North WestCheshire East328348£3,232,6666060£600,00000£0
    Cheshire West and Chester865865£8,378,0004040£400,00000£0
    South WestCornwall3636£220,00000£000£0
    North EastCounty Durham1,2511,294£12,596,819170170£1,700,00000£0
    West MidlandsCoventry871912£8,883,500105105£1,050,00000£0
    Outer LondonCroydon870895£8,845,833190190£1,900,00000£0
    North WestCumbria470498£4,613,999185242£2,183,33300£0
    North EastDarlington00£04040£400,00000£0
    East MidlandsDerby129129£1,134,000100100£1,000,00000£0
    Derbyshire411443£3,838,00000£000£0
    South WestDevon1,1951,225£11,952,16700£000£0
    Yorkshire and The HumberDoncaster125125£1,250,000157157£1,570,00000£0
    South WestDorset752754£7,387,633128128£1,280,00000£0
    West MidlandsDudley962965£9,497,5003232£320,00000£0
    Outer LondonEaling1,1031,150£10,377,500183183£1,830,00000£0
    East Midlands4,3824,618£43,524,666252252£2,520,000111111£1,800,987
    East of England7,0227,148£69,651,421699699£6,990,0006060£711,651
    Yorkshire and The HumberEast Riding of Yorkshire484498£4,671,000141141£1,410,00000£0
    South EastEast Sussex162178£1,560,00000£000£0
    Outer LondonEnfield1,0341,098£10,460,333100100£1,000,00000£0
    England91,90793,710£895,930,81613,22813,063£131,791,0931,5381,560£20,723,872
    East of EnglandEssex1,2781,278£12,556,000242242£2,420,00000£0
    North EastGateshead494494£4,888,00000£000£0
    South WestGloucestershire611621£6,116,333216216£2,160,0001515£209,002
    Outer LondonGreenwich213213£1,610,000122122£1,220,00000£0
    Inner LondonHackney511546£5,006,167240240£2,400,00000£0
    North WestHalton241241£2,230,0006060£600,00000£0
    Inner LondonHammersmith and Fulham511511£5,030,00000£000£0
    South EastHampshire3,1413,259£30,549,707291291£2,910,000120120£1,909,440
    Inner LondonHaringey461461£4,578,000118118£1,180,0001212£225,000
    Outer LondonHarrow473487£4,539,0007474£740,00000£0
    North EastHartlepool161161£1,366,0003434£340,00000£0
    Outer LondonHavering208208£1,908,00000£000£0
    West MidlandsHerefordshire, County of215215£1,926,0006550£562,5002525£250,000
    East of EnglandHertfordshire2,0822,133£20,847,833282282£2,820,00000£0
    Outer LondonHillingdon490490£4,656,00000£000£0
    Hounslow939984£8,993,167127127£1,270,0003232£179,008
    Inner London6,5596,710£62,048,6311,2901,290£12,900,000460478£5,167,892
    South EastIsle of Wight327327£3,086,0006060£600,00000£0
    Inner LondonIslington275275£2,494,000100100£1,000,00088£64,000
    Kensington and Chelsea184192£1,758,30000£01010£95,200
    South EastKent5,0615,309£50,202,333288288£2,880,000262262£2,972,754
    Yorkshire and The HumberKingston upon Hull, City of237246£2,422,50000£000£0
    Outer LondonKingston upon Thames8494£587,00099107£1,036,66700£0
    Yorkshire and The HumberKirklees644644£6,360,00000£000£0
    North WestKnowsley569569£5,498,000100100£1,000,00000£0
    Inner LondonLambeth799811£7,343,33300£000£0
    North WestLancashire2,8232,931£28,819,167687672£6,782,50000£0
    Yorkshire and The HumberLeeds1,5231,645£15,334,16700£000£0
    East MidlandsLeicester1,0081,110£10,320,333152152£1,520,000111111£1,800,987
    Leicestershire811869£7,865,00000£000£0
    Inner LondonLewisham891911£8,486,667160160£1,600,00000£0
    East MidlandsLincolnshire552575£5,655,83200£000£0
    North WestLiverpool1,7251,745£16,920,333106106£1,060,00000£0
    East of EnglandLuton639635£6,366,7006565£650,00000£0
    North WestManchester1,2261,226£12,099,701498468£4,805,00000£0
    South EastMedway159159£1,590,0004545£450,00000£0
    Outer LondonMerton544544£5,040,00000£000£0
    North EastMiddlesbrough430453£4,368,50000£000£0
    South EastMilton Keynes880913£8,788,5001818£180,00000£0
    North EastNewcastle upon Tyne400400£3,924,00000£000£0
    Inner LondonNewham138145£978,000132132£1,320,00000£0
    East of EnglandNorfolk1,3231,345£13,178,33300£000£0
    North East5,5935,690£54,582,318860819£8,360,83300£0
    Yorkshire and The HumberNorth Lincolnshire313309£3,106,6702020£200,00000£0
    East MidlandsNorth Northamptonshire209209£2,034,00000£000£0
    South WestNorth Somerset376400£3,900,0008080£800,00000£0
    North EastNorth Tyneside823797£7,748,167165135£1,475,00000£0
    Northumberland809867£8,428,3324040£400,00000£0
    North West16,24316,553£159,305,8903,3473,345£33,548,926110110£1,956,470
    Yorkshire and The HumberNorth Yorkshire784852£8,156,000123113£1,171,66700£0
    East MidlandsNottingham284297£2,915,83300£000£0
    Nottinghamshire687687£6,870,00000£000£0
    North WestOldham1212£72,0007070£700,0003030£544,490
    Outer London8,8629,161£83,024,1551,5991,597£15,978,3677575£860,210
    South EastOxfordshire389400£3,860,00000£0105105£1,642,771
    East of EnglandPeterborough455449£4,491,00000£000£0
    South WestPlymouth588596£5,926,66700£000£0
    South EastPortsmouth5252£328,00000£000£0
    Reading9498£767,33200£000£0
    Outer LondonRedbridge537557£5,133,3339090£900,00000£0
    North EastRedcar and Cleveland172172£1,620,0008574£785,83300£0
    Outer LondonRichmond upon Thames9598£667,50000£000£0
    North WestRochdale647667£6,538,667160160£1,600,00000£0
    Yorkshire and The HumberRotherham338330£3,285,333214198£2,046,66700£0
    East MidlandsRutland2828£215,00000£000£0
    North WestSalford440440£3,896,000231231£2,310,00000£0
    West MidlandsSandwell682682£6,392,000245245£2,450,00000£0
    North WestSefton880865£7,887,495181181£1,810,00000£0
    Yorkshire and The HumberSheffield1,3221,435£13,667,167180180£1,800,00000£0
    West MidlandsShropshire4144£351,500156156£1,560,00000£0
    South EastSlough10896£603,00000£000£0
    West MidlandsSolihull614641£6,301,5006767£670,00000£0
    South WestSomerset569641£5,875,476276276£2,758,0009797£970,000
    South EastSouthampton5560£398,80000£000£0
    South East17,25317,298£167,108,6881,5881,522£15,880,000555555£7,509,211
    East of EnglandSouthend-on-Sea1515£90,00000£000£0
    South WestSouth Gloucestershire284285£2,619,500150150£1,500,00000£0
    North EastSouth Tyneside691691£6,354,0007272£720,00000£0
    Inner LondonSouthwark510508£4,797,000100100£1,000,000117117£1,170,000
    South West6,7936,939£66,757,7761,0331,033£10,328,000112112£1,179,002
    West MidlandsStaffordshire557567£5,558,563246246£2,460,00000£0
    North WestSt. Helens470479£4,448,497125125£1,250,00000£0
    Stockport810810£7,712,000190190£1,900,00000£0
    North EastStockton-on-Tees9090£752,0006565£650,00000£0
    West MidlandsStoke-on-Trent410434£4,240,0003838£380,00000£0
    East of EnglandSuffolk175175£1,394,000110110£1,100,00000£0
    North EastSunderland272271£2,536,500189189£1,890,00000£0
    South EastSurrey1,6791,666£15,709,016272272£2,720,0003636£664,246
    Outer LondonSutton284288£2,327,3007575£750,00000£0
    South WestSwindon254254£2,400,000135135£1,350,00000£0
    North WestTameside541567£5,537,6679293£925,83300£0
    West MidlandsTelford and Wrekin563558£5,568,8334848£480,00000£0
    South WestTorbay283283£2,766,00000£000£0
    Inner LondonTower Hamlets872872£8,240,000225225£2,250,00000£0
    North WestTrafford346353£3,300,8336060£600,00000£0
    Yorkshire and The HumberWakefield641640£6,404,166171171£1,710,0003034£803,296
    West MidlandsWalsall710709£7,094,167125112£1,174,13300£0
    Outer LondonWaltham Forest154154£1,077,000128118£1,221,70000£0
    Inner LondonWandsworth784836£7,470,667130130£1,300,0004242£420,000
    North WestWarrington475475£4,518,00000£000£0
    West MidlandsWarwickshire584584£6,093,44000£000£0
    South EastWest Berkshire4000£3,876,000660£660,00000£0
    West Midlands11,26511,345£111,062,6691,2721,244£12,556,6332525£735,153
    Inner LondonWestminster206217£2,016,49800£000£0
    East MidlandsWest Northamptonshireuuuuuuuuu
    South EastWest Sussex2,0512,029£19,607,000276276£2,760,0001616£160,000
    North WestWigan904958£9,318,00000£000£0
    South WestWiltshire658658£5,748,00000£000£0
    South EastWindsor and Maidenhead301309£2,976,6663535£350,00000£0
    North WestWirral1,2511,251£12,054,00000£08080£1,411,980
    South EastWokingham296311£2,947,5004747£470,0001616£160,000
    West MidlandsWolverhampton858893£8,440,16700£000£485,153
    Worcestershire1,0301,030£10,115,000145145£1,450,00000£0
    Yorkshire and The HumberYork196196£1,920,000192192£1,920,00000£0
    Yorkshire and The Humber7,9368,249£78,864,6031,2881,262£12,728,3343034£803,296

    Footnotes

    1. Before using this data, please check the methodology section for important information such as definitions, limitations and caveats.
    2. To reduce burden on local authorities during the pandemic, data on planned expenditure was not collected for the financial year 2020-21. As a result, there is a break in the time series.

    Save table

    Download Table

    Select file format: