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

   • Publication: Planned LA and school expenditure

2. Step 2

   • Data set: s251 Budget - planned expenditure on schools

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford

4. Step 4

   • Time period: 2021-22

5. Step 5

   • Indicators:
     • Gross planned expenditure
     • Income
     • Net planned expenditure
   • Category of planned expenditure:
     • 1.8.1 TOTAL SCHOOLS BUDGET (before Academy recoupment)

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Financial year 2023-24

   Some 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 expenditure	Income	Net planned expenditure
   Outer London	Barking and Dagenham	£320,650,354	£0	£320,650,354
   	Barnet	£382,568,581	£0	£382,568,581
   Yorkshire and The Humber	Barnsley	£226,625,351	£0	£226,625,351
   South West	Bath and North East Somerset	£160,095,680	£0	£160,095,680
   East of England	Bedford	£178,609,349	£44,890	£178,564,459
   Outer London	Bexley	£263,119,808	£197,000	£262,922,808
   West Midlands	Birmingham	£1,322,536,188	£825,301	£1,321,710,887
   North West	Blackburn 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 West	Bournemouth, Christchurch and Poole	£310,404,781	£190,000	£310,214,781
   South East	Bracknell Forest	£117,529,701	£87,260	£117,442,441
   Yorkshire and The Humber	Bradford	£616,130,323	£631,400	£615,498,923
   Outer London	Brent	£344,965,827	£1,393,279	£343,572,548
   South East	Brighton and Hove	£203,751,800	£804,800	£202,947,000
   South West	Bristol, City of	£404,680,398	£0	£404,680,398
   Outer London	Bromley	£321,994,515	£280,280	£321,714,235
   South East	Buckinghamshire	£518,022,858	£2,356,056	£515,666,802
   North West	Bury	£190,899,133	£0	£190,899,133
   Yorkshire and The Humber	Calderdale	£214,993,192	£0	£214,993,192
   East of England	Cambridgeshire	£541,998,175	£732,042	£541,266,133
   Inner London	Camden	£190,311,495	£0	£190,311,495
   East of England	Central Bedfordshire	£253,348,964	£0	£253,348,964
   North West	Cheshire East	£325,206,338	£0	£325,206,338
   	Cheshire West and Chester	£312,617,116	£5,351,303	£307,265,813
   Inner London	City of London	£3,631,612	£0	£3,631,612
   South West	Cornwall	£449,964,375	£0	£449,964,375
   North East	County Durham	£456,720,007	£970,001	£455,750,006
   West Midlands	Coventry	£339,888,695	£0	£339,888,695
   Outer London	Croydon	£387,854,745	£2,743,745	£385,111,000
   North West	Cumbria	£416,780,698	£0	£416,780,698
   North East	Darlington	£98,952,023	£0	£98,952,023
   East Midlands	Derby	£277,106,519	£0	£277,106,519
   	Derbyshire	£647,994,621	£436,000	£647,558,621
   South West	Devon	£628,646,000	£1,673,017	£626,972,983
   Yorkshire and The Humber	Doncaster	£285,963,431	£0	£285,963,431
   South West	Dorset	£298,235,958	£130,600	£298,105,358
   West Midlands	Dudley	£294,894,473	£156,500	£294,737,973
   Outer London	Ealing	£373,001,579	£0	£373,001,579
   Yorkshire and The Humber	East Riding of Yorkshire	£263,678,524	£0	£263,678,524
   South East	East Sussex	£433,211,500	£432,000	£432,779,500
   Outer London	Enfield	£387,055,157	£0	£387,055,157
   East of England	Essex	£1,266,297,640	£0	£1,266,297,640
   North East	Gateshead	£168,084,169	£48,884	£168,035,285
   South West	Gloucestershire	£528,822,899	£0	£528,822,899
   Outer London	Greenwich	£343,975,924	£0	£343,975,924
   Inner London	Hackney	£312,763,777	£3,969,145	£308,794,632
   North West	Halton	£130,261,735	£419,980	£129,841,755
   Inner London	Hammersmith and Fulham	£163,182,350	£0	£163,182,350
   South East	Hampshire	£1,107,546,339	£1,717,000	£1,105,829,339
   Inner London	Haringey	£277,174,641	£0	£277,174,641
   Outer London	Harrow	£243,352,520	£1,807,572	£241,544,948
   North East	Hartlepool	£88,514,499	£100,000	£88,414,499
   Outer London	Havering	£252,355,625	£0	£252,355,625
   West Midlands	Herefordshire, County of	£143,009,680	£761,581	£142,248,099
   East of England	Hertfordshire	£1,118,436,456	£5,110	£1,118,431,346
   Outer London	Hillingdon	£333,402,035	£1,581,400	£331,820,635
   	Hounslow	£303,580,393	£268,512	£303,311,881
   South East	Isle of Wight	£106,725,045	£42,445	£106,682,600
   South West	Isles of Scilly	£3,446,005	£139,060	£3,306,945
   Inner London	Islington	£202,707,638	£0	£202,707,638
   	Kensington and Chelsea	£109,843,908	£0	£109,843,908
   South East	Kent	£1,448,432,663	£4,174,300	£1,444,258,363
   Yorkshire and The Humber	Kingston upon Hull, City of	£262,173,043	£0	£262,173,043
   Outer London	Kingston upon Thames	£158,747,433	£0	£158,747,433
   Yorkshire and The Humber	Kirklees	£406,610,527	£2,828,700	£403,781,827
   North West	Knowsley	£149,110,577	£0	£149,110,577
   Inner London	Lambeth	£309,036,997	£0	£309,036,997
   North West	Lancashire	£1,087,547,847	£0	£1,087,547,847
   Yorkshire and The Humber	Leeds	£769,367,820	£0	£769,367,820
   East Midlands	Leicester	£379,338,776	£0	£379,338,776
   	Leicestershire	£589,836,847	£1,423,839	£588,413,008
   Inner London	Lewisham	£318,050,262	£182,222	£317,868,040
   East Midlands	Lincolnshire	£649,769,875	£2,317,156	£647,452,719
   North West	Liverpool	£485,548,769	£9,395,739	£476,153,030
   East of England	Luton	£252,826,683	£0	£252,826,683
   North West	Manchester	£601,127,492	£0	£601,127,492
   South East	Medway	£275,766,304	£351,699	£275,414,605
   Outer London	Merton	£191,363,794	£1,855,840	£189,507,954
   North East	Middlesbrough	£159,189,319	£0	£159,189,319
   South East	Milton Keynes	£294,433,150	£0	£294,433,150
   North East	Newcastle upon Tyne	£259,990,976	£0	£259,990,976
   Inner London	Newham	£454,313,551	£150,000	£454,163,551
   East of England	Norfolk	£704,502,120	£0	£704,502,120
   Yorkshire and The Humber	North East Lincolnshire	£149,223,562	£0	£149,223,562
   	North Lincolnshire	£153,136,714	£102,000	£153,034,714
   East Midlands	North Northamptonshire	£314,964,911	£0	£314,964,911
   South West	North Somerset	£180,293,728	£0	£180,293,728
   North East	North Tyneside	£184,581,381	£270,000	£184,311,381
   	Northumberland	£267,708,736	£933,790	£266,774,946
   Yorkshire and The Humber	North Yorkshire	£499,456,535	£9,313,400	£490,143,135
   East Midlands	Nottingham	£310,788,423	£33,143	£310,755,280
   	Nottinghamshire	£702,813,913	£1,233,715	£701,580,198
   North West	Oldham	£283,104,244	£0	£283,104,244
   South East	Oxfordshire	£562,036,557	£578,662	£561,457,895
   East of England	Peterborough	£241,627,905	£49,428	£241,578,477
   South West	Plymouth	£236,708,853	£1,279,241	£235,429,612
   South East	Portsmouth	£175,974,658	£0	£175,974,658
   	Reading	£141,633,160	£0	£141,633,160
   Outer London	Redbridge	£341,115,475	£0	£341,115,475
   North East	Redcar and Cleveland	£129,822,083	£0	£129,822,083
   Outer London	Richmond upon Thames	£179,176,343	£0	£179,176,343
   North West	Rochdale	£236,344,302	£365,032	£235,979,270
   Yorkshire and The Humber	Rotherham	£271,935,898	£80,000	£271,855,898
   East Midlands	Rutland	£34,235,132	£0	£34,235,132
   North West	Salford	£253,240,039	£1,609,247	£251,630,792
   West Midlands	Sandwell	£379,809,064	£0	£379,809,064
   North West	Sefton	£238,090,227	£386,800	£237,703,427
   Yorkshire and The Humber	Sheffield	£507,691,465	£1,099,000	£506,592,465
   West Midlands	Shropshire	£234,499,850	£845,660	£233,654,190
   South East	Slough	£200,418,446	£0	£200,418,446
   West Midlands	Solihull	£230,690,267	£0	£230,690,267
   South West	Somerset	£442,217,300	£0	£442,217,300
   South East	Southampton	£214,103,290	£0	£214,103,290
   East of England	Southend-on-Sea	£170,894,977	£0	£170,894,977
   South West	South Gloucestershire	£244,238,417	£0	£244,238,417
   North East	South Tyneside	£141,111,158	£0	£141,111,158
   Inner London	Southwark	£353,899,149	£0	£353,899,149
   West Midlands	Staffordshire	£720,514,334	£0	£720,514,334
   North West	St. Helens	£167,893,528	£1,373,914	£166,519,614
   	Stockport	£257,377,327	£694,006	£256,683,321
   North East	Stockton-on-Tees	£189,212,468	£46,000	£189,166,468
   West Midlands	Stoke-on-Trent	£255,736,831	£0	£255,736,831
   East of England	Suffolk	£594,799,362	£919,500	£593,879,862
   North East	Sunderland	£239,279,767	£658,291	£238,621,476
   South East	Surrey	£1,011,445,848	£0	£1,011,445,848
   Outer London	Sutton	£244,494,200	£0	£244,494,200
   South West	Swindon	£216,033,070	£672,370	£215,360,700
   North West	Tameside	£230,215,762	£0	£230,215,762
   West Midlands	Telford and Wrekin	£178,098,876	£633,222	£177,465,654
   East of England	Thurrock	£183,862,000	£0	£183,862,000
   South West	Torbay	£121,841,686	£250,000	£121,591,686
   Inner London	Tower Hamlets	£388,762,448	£0	£388,762,448
   North West	Trafford	£241,675,231	£175,360	£241,499,871
   Yorkshire and The Humber	Wakefield	£312,419,351	£1,220,910	£311,198,440
   West Midlands	Walsall	£306,964,145	£0	£306,964,145
   Outer London	Waltham Forest	£291,543,132	£0	£291,543,132
   Inner London	Wandsworth	£258,075,485	£0	£258,075,485
   North West	Warrington	£188,664,480	£20,000	£188,644,480
   West Midlands	Warwickshire	£501,690,478	£433,347	£501,257,131
   South East	West Berkshire	£154,422,355	£101,830	£154,320,525
   Inner London	Westminster	£170,365,534	£0	£170,365,534
   East Midlands	West Northamptonshire	u	u	u
   South East	West Sussex	£711,696,000	£195,100	£711,500,900
   North West	Wigan	£291,655,316	£1,131,116	£290,524,200
   South West	Wiltshire	£420,343,135	£82,830	£420,260,305
   South East	Windsor and Maidenhead	£133,117,023	£100,430	£133,016,593
   North West	Wirral	£300,125,816	£0	£300,125,816
   South East	Wokingham	£158,137,532	£0	£158,137,532
   West Midlands	Wolverhampton	£290,613,738	£0	£290,613,738
   	Worcestershire	£497,701,486	£0	£497,701,486
   Yorkshire and The Humber	York	£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

   Related information

   • Release type:
   • Publication: Planned LA and school expenditure, Financial year 2023-24

   Our statistical practice is regulated by the Office for Statistics Regulation (OSR)