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

    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
    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
    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 Northamptonshire
    West Sussex
    Wigan
    Wiltshire
    Windsor and Maidenhead
    Wirral
    Wokingham
    Wolverhampton
    Worcestershire
    York
    Column groups
    Column group 1
    2021-22
    Column group 2
    Gross planned expenditure
    Income
    Net planned expenditure
    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 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

    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: