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 schools
  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
    • City of London
    • 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
    • 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
    • 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
  4. Step 4 Choose time period

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

    Indicators
    • Gross planned expenditure
    • Income
    • Net planned expenditure
    Category of planned expenditure
    • 1.8.1 TOTAL SCHOOLS BUDGET (before Academy recoupment)
  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 schools' for 1.8.1 TOTAL SCHOOLS BUDGET (before Academy recoupment) in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2021-22
    2021-22
    Gross planned expenditureIncomeNet planned expenditure
    Outer LondonBarking and Dagenham£320,650,354£0£320,650,354
    Barnet£382,568,581£0£382,568,581
    Yorkshire and The HumberBarnsley£226,625,351£0£226,625,351
    South WestBath and North East Somerset£160,095,680£0£160,095,680
    East of EnglandBedford£178,609,349£44,890£178,564,459
    Outer LondonBexley£263,119,808£197,000£262,922,808
    West MidlandsBirmingham£1,322,536,188£825,301£1,321,710,887
    North WestBlackburn with Darwen£176,762,771£0£176,762,771
    Blackpool£130,891,424£0£130,891,424
    Bolton£318,987,500£0£318,987,500
    South WestBournemouth, Christchurch and Poole£310,404,781£190,000£310,214,781
    South EastBracknell Forest£117,529,701£87,260£117,442,441
    Yorkshire and The HumberBradford£616,130,323£631,400£615,498,923
    Outer LondonBrent£344,965,827£1,393,279£343,572,548
    South EastBrighton and Hove£203,751,800£804,800£202,947,000
    South WestBristol, City of£404,680,398£0£404,680,398
    Outer LondonBromley£321,994,515£280,280£321,714,235
    South EastBuckinghamshire£518,022,858£2,356,056£515,666,802
    North WestBury£190,899,133£0£190,899,133
    Yorkshire and The HumberCalderdale£214,993,192£0£214,993,192
    East of EnglandCambridgeshire£541,998,175£732,042£541,266,133
    Inner LondonCamden£190,311,495£0£190,311,495
    East of EnglandCentral Bedfordshire£253,348,964£0£253,348,964
    North WestCheshire East£325,206,338£0£325,206,338
    Cheshire West and Chester£312,617,116£5,351,303£307,265,813
    Inner LondonCity of London£3,631,612£0£3,631,612
    South WestCornwall£449,964,375£0£449,964,375
    North EastCounty Durham£456,720,007£970,001£455,750,006
    West MidlandsCoventry£339,888,695£0£339,888,695
    Outer LondonCroydon£387,854,745£2,743,745£385,111,000
    North WestCumbria£416,780,698£0£416,780,698
    North EastDarlington£98,952,023£0£98,952,023
    East MidlandsDerby£277,106,519£0£277,106,519
    Derbyshire£647,994,621£436,000£647,558,621
    South WestDevon£628,646,000£1,673,017£626,972,983
    Yorkshire and The HumberDoncaster£285,963,431£0£285,963,431
    South WestDorset£298,235,958£130,600£298,105,358
    West MidlandsDudley£294,894,473£156,500£294,737,973
    Outer LondonEaling£373,001,579£0£373,001,579
    Yorkshire and The HumberEast Riding of Yorkshire£263,678,524£0£263,678,524
    South EastEast Sussex£433,211,500£432,000£432,779,500
    Outer LondonEnfield£387,055,157£0£387,055,157
    East of EnglandEssex£1,266,297,640£0£1,266,297,640
    North EastGateshead£168,084,169£48,884£168,035,285
    South WestGloucestershire£528,822,899£0£528,822,899
    Outer LondonGreenwich£343,975,924£0£343,975,924
    Inner LondonHackney£312,763,777£3,969,145£308,794,632
    North WestHalton£130,261,735£419,980£129,841,755
    Inner LondonHammersmith and Fulham£163,182,350£0£163,182,350
    South EastHampshire£1,107,546,339£1,717,000£1,105,829,339
    Inner LondonHaringey£277,174,641£0£277,174,641
    Outer LondonHarrow£243,352,520£1,807,572£241,544,948
    North EastHartlepool£88,514,499£100,000£88,414,499
    Outer LondonHavering£252,355,625£0£252,355,625
    West MidlandsHerefordshire, County of£143,009,680£761,581£142,248,099
    East of EnglandHertfordshire£1,118,436,456£5,110£1,118,431,346
    Outer LondonHillingdon£333,402,035£1,581,400£331,820,635
    Hounslow£303,580,393£268,512£303,311,881
    South EastIsle of Wight£106,725,045£42,445£106,682,600
    South WestIsles of Scilly£3,446,005£139,060£3,306,945
    Inner LondonIslington£202,707,638£0£202,707,638
    Kensington and Chelsea£109,843,908£0£109,843,908
    South EastKent£1,448,432,663£4,174,300£1,444,258,363
    Yorkshire and The HumberKingston upon Hull, City of£262,173,043£0£262,173,043
    Outer LondonKingston upon Thames£158,747,433£0£158,747,433
    Yorkshire and The HumberKirklees£406,610,527£2,828,700£403,781,827
    North WestKnowsley£149,110,577£0£149,110,577
    Inner LondonLambeth£309,036,997£0£309,036,997
    North WestLancashire£1,087,547,847£0£1,087,547,847
    Yorkshire and The HumberLeeds£769,367,820£0£769,367,820
    East MidlandsLeicester£379,338,776£0£379,338,776
    Leicestershire£589,836,847£1,423,839£588,413,008
    Inner LondonLewisham£318,050,262£182,222£317,868,040
    East MidlandsLincolnshire£649,769,875£2,317,156£647,452,719
    North WestLiverpool£485,548,769£9,395,739£476,153,030
    East of EnglandLuton£252,826,683£0£252,826,683
    North WestManchester£601,127,492£0£601,127,492
    South EastMedway£275,766,304£351,699£275,414,605
    Outer LondonMerton£191,363,794£1,855,840£189,507,954
    North EastMiddlesbrough£159,189,319£0£159,189,319
    South EastMilton Keynes£294,433,150£0£294,433,150
    North EastNewcastle upon Tyne£259,990,976£0£259,990,976
    Inner LondonNewham£454,313,551£150,000£454,163,551
    East of EnglandNorfolk£704,502,120£0£704,502,120
    Yorkshire and The HumberNorth East Lincolnshire£149,223,562£0£149,223,562
    North Lincolnshire£153,136,714£102,000£153,034,714
    East MidlandsNorth Northamptonshire£314,964,911£0£314,964,911
    South WestNorth Somerset£180,293,728£0£180,293,728
    North EastNorth Tyneside£184,581,381£270,000£184,311,381
    Northumberland£267,708,736£933,790£266,774,946
    Yorkshire and The HumberNorth Yorkshire£499,456,535£9,313,400£490,143,135
    East MidlandsNottingham£310,788,423£33,143£310,755,280
    Nottinghamshire£702,813,913£1,233,715£701,580,198
    North WestOldham£283,104,244£0£283,104,244
    South EastOxfordshire£562,036,557£578,662£561,457,895
    East of EnglandPeterborough£241,627,905£49,428£241,578,477
    South WestPlymouth£236,708,853£1,279,241£235,429,612
    South EastPortsmouth£175,974,658£0£175,974,658
    Reading£141,633,160£0£141,633,160
    Outer LondonRedbridge£341,115,475£0£341,115,475
    North EastRedcar and Cleveland£129,822,083£0£129,822,083
    Outer LondonRichmond upon Thames£179,176,343£0£179,176,343
    North WestRochdale£236,344,302£365,032£235,979,270
    Yorkshire and The HumberRotherham£271,935,898£80,000£271,855,898
    East MidlandsRutland£34,235,132£0£34,235,132
    North WestSalford£253,240,039£1,609,247£251,630,792
    West MidlandsSandwell£379,809,064£0£379,809,064
    North WestSefton£238,090,227£386,800£237,703,427
    Yorkshire and The HumberSheffield£507,691,465£1,099,000£506,592,465
    West MidlandsShropshire£234,499,850£845,660£233,654,190
    South EastSlough£200,418,446£0£200,418,446
    West MidlandsSolihull£230,690,267£0£230,690,267
    South WestSomerset£442,217,300£0£442,217,300
    South EastSouthampton£214,103,290£0£214,103,290
    East of EnglandSouthend-on-Sea£170,894,977£0£170,894,977
    South WestSouth Gloucestershire£244,238,417£0£244,238,417
    North EastSouth Tyneside£141,111,158£0£141,111,158
    Inner LondonSouthwark£353,899,149£0£353,899,149
    West MidlandsStaffordshire£720,514,334£0£720,514,334
    North WestSt. Helens£167,893,528£1,373,914£166,519,614
    Stockport£257,377,327£694,006£256,683,321
    North EastStockton-on-Tees£189,212,468£46,000£189,166,468
    West MidlandsStoke-on-Trent£255,736,831£0£255,736,831
    East of EnglandSuffolk£594,799,362£919,500£593,879,862
    North EastSunderland£239,279,767£658,291£238,621,476
    South EastSurrey£1,011,445,848£0£1,011,445,848
    Outer LondonSutton£244,494,200£0£244,494,200
    South WestSwindon£216,033,070£672,370£215,360,700
    North WestTameside£230,215,762£0£230,215,762
    West MidlandsTelford and Wrekin£178,098,876£633,222£177,465,654
    East of EnglandThurrock£183,862,000£0£183,862,000
    South WestTorbay£121,841,686£250,000£121,591,686
    Inner LondonTower Hamlets£388,762,448£0£388,762,448
    North WestTrafford£241,675,231£175,360£241,499,871
    Yorkshire and The HumberWakefield£312,419,351£1,220,910£311,198,440
    West MidlandsWalsall£306,964,145£0£306,964,145
    Outer LondonWaltham Forest£291,543,132£0£291,543,132
    Inner LondonWandsworth£258,075,485£0£258,075,485
    North WestWarrington£188,664,480£20,000£188,644,480
    West MidlandsWarwickshire£501,690,478£433,347£501,257,131
    South EastWest Berkshire£154,422,355£101,830£154,320,525
    Inner LondonWestminster£170,365,534£0£170,365,534
    East MidlandsWest Northamptonshireuuu
    South EastWest Sussex£711,696,000£195,100£711,500,900
    North WestWigan£291,655,316£1,131,116£290,524,200
    South WestWiltshire£420,343,135£82,830£420,260,305
    South EastWindsor and Maidenhead£133,117,023£100,430£133,016,593
    North WestWirral£300,125,816£0£300,125,816
    South EastWokingham£158,137,532£0£158,137,532
    West MidlandsWolverhampton£290,613,738£0£290,613,738
    Worcestershire£497,701,486£0£497,701,486
    Yorkshire and The HumberYork£154,503,354£0£154,503,354

    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: