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

    This data is not from the latest release
    View latest data: Financial Year 2022-23
    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 for undefined

    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: