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 high needs places

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford
   • Regional:
     • East Midlands
     • East of England
     • Inner London
     • North East
     • North West
   • National:
     • England

4. Step 4

   • Time period: 2021-22

5. Step 5

   • 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

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 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 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
   Outer London	Barking and Dagenham	697	737	£5,782,000	189	189	£1,890,000	0	0	£0
   	Barnet	468	495	£4,797,689	140	140	£1,400,000	38	38	£631,202
   Yorkshire and The Humber	Barnsley	27	27	£162,000	0	0	£0	0	0	£0
   South West	Bath and North East Somerset	10	10	£76,000	0	0	£0	0	0	£0
   East of England	Bedford	87	87	£862,000	0	0	£0	0	0	£0
   Outer London	Bexley	140	140	£1,212,500	0	0	£0	0	0	£0
   West Midlands	Birmingham	3,167	3,110	£30,600,500	0	0	£0	0	0	£0
   North West	Blackburn with Darwen	276	288	£2,698,000	166	166	£1,660,000	0	0	£0
   	Blackpool	205	225	£2,166,667	200	185	£1,912,500	0	0	£0
   	Bolton	508	508	£4,992,000	0	0	£0	0	0	£0
   South West	Bournemouth, Christchurch and Poole	585	585	£5,850,000	48	48	£480,000	0	0	£0
   South East	Bracknell Forest	262	285	£2,506,500	56	56	£560,000	0	0	£0
   Yorkshire and The Humber	Bradford	895	895	£8,055,600	90	90	£900,000	0	0	£0
   Outer London	Brent	109	109	£890,000	82	82	£820,000	5	5	£50,000
   South East	Brighton and Hove	513	523	£4,984,333	88	88	£880,000	0	0	£0
   South West	Bristol, City of	592	592	£5,920,000	0	0	£0	0	0	£0
   Outer London	Bromley	420	420	£4,120,000	0	0	£0	0	0	£0
   South East	Buckinghamshire	1,324	1,324	£12,768,000	46	46	£460,000	0	0	£0
   North West	Bury	231	232	£2,374,198	136	136	£1,449,760	0	0	£0
   Yorkshire and The Humber	Calderdale	407	407	£4,070,000	0	0	£0	0	0	£0
   East of England	Cambridgeshire	486	522	£4,996,333	0	0	£0	60	60	£711,651
   Inner London	Camden	417	425	£3,850,000	85	85	£850,000	271	289	£3,193,692
   East of England	Central Bedfordshire	482	509	£4,869,222	0	0	£0	0	0	£0
   North West	Cheshire East	328	348	£3,232,666	60	60	£600,000	0	0	£0
   	Cheshire West and Chester	865	865	£8,378,000	40	40	£400,000	0	0	£0
   South West	Cornwall	36	36	£220,000	0	0	£0	0	0	£0
   North East	County Durham	1,251	1,294	£12,596,819	170	170	£1,700,000	0	0	£0
   West Midlands	Coventry	871	912	£8,883,500	105	105	£1,050,000	0	0	£0
   Outer London	Croydon	870	895	£8,845,833	190	190	£1,900,000	0	0	£0
   North West	Cumbria	470	498	£4,613,999	185	242	£2,183,333	0	0	£0
   North East	Darlington	0	0	£0	40	40	£400,000	0	0	£0
   East Midlands	Derby	129	129	£1,134,000	100	100	£1,000,000	0	0	£0
   	Derbyshire	411	443	£3,838,000	0	0	£0	0	0	£0
   South West	Devon	1,195	1,225	£11,952,167	0	0	£0	0	0	£0
   Yorkshire and The Humber	Doncaster	125	125	£1,250,000	157	157	£1,570,000	0	0	£0
   South West	Dorset	752	754	£7,387,633	128	128	£1,280,000	0	0	£0
   West Midlands	Dudley	962	965	£9,497,500	32	32	£320,000	0	0	£0
   Outer London	Ealing	1,103	1,150	£10,377,500	183	183	£1,830,000	0	0	£0
   East Midlands		4,382	4,618	£43,524,666	252	252	£2,520,000	111	111	£1,800,987
   East of England		7,022	7,148	£69,651,421	699	699	£6,990,000	60	60	£711,651
   Yorkshire and The Humber	East Riding of Yorkshire	484	498	£4,671,000	141	141	£1,410,000	0	0	£0
   South East	East Sussex	162	178	£1,560,000	0	0	£0	0	0	£0
   Outer London	Enfield	1,034	1,098	£10,460,333	100	100	£1,000,000	0	0	£0
   England		91,907	93,710	£895,930,816	13,228	13,063	£131,791,093	1,538	1,560	£20,723,872
   East of England	Essex	1,278	1,278	£12,556,000	242	242	£2,420,000	0	0	£0
   North East	Gateshead	494	494	£4,888,000	0	0	£0	0	0	£0
   South West	Gloucestershire	611	621	£6,116,333	216	216	£2,160,000	15	15	£209,002
   Outer London	Greenwich	213	213	£1,610,000	122	122	£1,220,000	0	0	£0
   Inner London	Hackney	511	546	£5,006,167	240	240	£2,400,000	0	0	£0
   North West	Halton	241	241	£2,230,000	60	60	£600,000	0	0	£0
   Inner London	Hammersmith and Fulham	511	511	£5,030,000	0	0	£0	0	0	£0
   South East	Hampshire	3,141	3,259	£30,549,707	291	291	£2,910,000	120	120	£1,909,440
   Inner London	Haringey	461	461	£4,578,000	118	118	£1,180,000	12	12	£225,000
   Outer London	Harrow	473	487	£4,539,000	74	74	£740,000	0	0	£0
   North East	Hartlepool	161	161	£1,366,000	34	34	£340,000	0	0	£0
   Outer London	Havering	208	208	£1,908,000	0	0	£0	0	0	£0
   West Midlands	Herefordshire, County of	215	215	£1,926,000	65	50	£562,500	25	25	£250,000
   East of England	Hertfordshire	2,082	2,133	£20,847,833	282	282	£2,820,000	0	0	£0
   Outer London	Hillingdon	490	490	£4,656,000	0	0	£0	0	0	£0
   	Hounslow	939	984	£8,993,167	127	127	£1,270,000	32	32	£179,008
   Inner London		6,559	6,710	£62,048,631	1,290	1,290	£12,900,000	460	478	£5,167,892
   South East	Isle of Wight	327	327	£3,086,000	60	60	£600,000	0	0	£0
   Inner London	Islington	275	275	£2,494,000	100	100	£1,000,000	8	8	£64,000
   	Kensington and Chelsea	184	192	£1,758,300	0	0	£0	10	10	£95,200
   South East	Kent	5,061	5,309	£50,202,333	288	288	£2,880,000	262	262	£2,972,754
   Yorkshire and The Humber	Kingston upon Hull, City of	237	246	£2,422,500	0	0	£0	0	0	£0
   Outer London	Kingston upon Thames	84	94	£587,000	99	107	£1,036,667	0	0	£0
   Yorkshire and The Humber	Kirklees	644	644	£6,360,000	0	0	£0	0	0	£0
   North West	Knowsley	569	569	£5,498,000	100	100	£1,000,000	0	0	£0
   Inner London	Lambeth	799	811	£7,343,333	0	0	£0	0	0	£0
   North West	Lancashire	2,823	2,931	£28,819,167	687	672	£6,782,500	0	0	£0
   Yorkshire and The Humber	Leeds	1,523	1,645	£15,334,167	0	0	£0	0	0	£0
   East Midlands	Leicester	1,008	1,110	£10,320,333	152	152	£1,520,000	111	111	£1,800,987
   	Leicestershire	811	869	£7,865,000	0	0	£0	0	0	£0
   Inner London	Lewisham	891	911	£8,486,667	160	160	£1,600,000	0	0	£0
   East Midlands	Lincolnshire	552	575	£5,655,832	0	0	£0	0	0	£0
   North West	Liverpool	1,725	1,745	£16,920,333	106	106	£1,060,000	0	0	£0
   East of England	Luton	639	635	£6,366,700	65	65	£650,000	0	0	£0
   North West	Manchester	1,226	1,226	£12,099,701	498	468	£4,805,000	0	0	£0
   South East	Medway	159	159	£1,590,000	45	45	£450,000	0	0	£0
   Outer London	Merton	544	544	£5,040,000	0	0	£0	0	0	£0
   North East	Middlesbrough	430	453	£4,368,500	0	0	£0	0	0	£0
   South East	Milton Keynes	880	913	£8,788,500	18	18	£180,000	0	0	£0
   North East	Newcastle upon Tyne	400	400	£3,924,000	0	0	£0	0	0	£0
   Inner London	Newham	138	145	£978,000	132	132	£1,320,000	0	0	£0
   East of England	Norfolk	1,323	1,345	£13,178,333	0	0	£0	0	0	£0
   North East		5,593	5,690	£54,582,318	860	819	£8,360,833	0	0	£0
   Yorkshire and The Humber	North Lincolnshire	313	309	£3,106,670	20	20	£200,000	0	0	£0
   East Midlands	North Northamptonshire	209	209	£2,034,000	0	0	£0	0	0	£0
   South West	North Somerset	376	400	£3,900,000	80	80	£800,000	0	0	£0
   North East	North Tyneside	823	797	£7,748,167	165	135	£1,475,000	0	0	£0
   	Northumberland	809	867	£8,428,332	40	40	£400,000	0	0	£0
   North West		16,243	16,553	£159,305,890	3,347	3,345	£33,548,926	110	110	£1,956,470
   Yorkshire and The Humber	North Yorkshire	784	852	£8,156,000	123	113	£1,171,667	0	0	£0
   East Midlands	Nottingham	284	297	£2,915,833	0	0	£0	0	0	£0
   	Nottinghamshire	687	687	£6,870,000	0	0	£0	0	0	£0
   North West	Oldham	12	12	£72,000	70	70	£700,000	30	30	£544,490
   Outer London		8,862	9,161	£83,024,155	1,599	1,597	£15,978,367	75	75	£860,210
   South East	Oxfordshire	389	400	£3,860,000	0	0	£0	105	105	£1,642,771
   East of England	Peterborough	455	449	£4,491,000	0	0	£0	0	0	£0
   South West	Plymouth	588	596	£5,926,667	0	0	£0	0	0	£0
   South East	Portsmouth	52	52	£328,000	0	0	£0	0	0	£0
   	Reading	94	98	£767,332	0	0	£0	0	0	£0
   Outer London	Redbridge	537	557	£5,133,333	90	90	£900,000	0	0	£0
   North East	Redcar and Cleveland	172	172	£1,620,000	85	74	£785,833	0	0	£0
   Outer London	Richmond upon Thames	95	98	£667,500	0	0	£0	0	0	£0
   North West	Rochdale	647	667	£6,538,667	160	160	£1,600,000	0	0	£0
   Yorkshire and The Humber	Rotherham	338	330	£3,285,333	214	198	£2,046,667	0	0	£0
   East Midlands	Rutland	28	28	£215,000	0	0	£0	0	0	£0
   North West	Salford	440	440	£3,896,000	231	231	£2,310,000	0	0	£0
   West Midlands	Sandwell	682	682	£6,392,000	245	245	£2,450,000	0	0	£0
   North West	Sefton	880	865	£7,887,495	181	181	£1,810,000	0	0	£0
   Yorkshire and The Humber	Sheffield	1,322	1,435	£13,667,167	180	180	£1,800,000	0	0	£0
   West Midlands	Shropshire	41	44	£351,500	156	156	£1,560,000	0	0	£0
   South East	Slough	108	96	£603,000	0	0	£0	0	0	£0
   West Midlands	Solihull	614	641	£6,301,500	67	67	£670,000	0	0	£0
   South West	Somerset	569	641	£5,875,476	276	276	£2,758,000	97	97	£970,000
   South East	Southampton	55	60	£398,800	0	0	£0	0	0	£0
   	South East	17,253	17,298	£167,108,688	1,588	1,522	£15,880,000	555	555	£7,509,211
   East of England	Southend-on-Sea	15	15	£90,000	0	0	£0	0	0	£0
   South West	South Gloucestershire	284	285	£2,619,500	150	150	£1,500,000	0	0	£0
   North East	South Tyneside	691	691	£6,354,000	72	72	£720,000	0	0	£0
   Inner London	Southwark	510	508	£4,797,000	100	100	£1,000,000	117	117	£1,170,000
   South West		6,793	6,939	£66,757,776	1,033	1,033	£10,328,000	112	112	£1,179,002
   West Midlands	Staffordshire	557	567	£5,558,563	246	246	£2,460,000	0	0	£0
   North West	St. Helens	470	479	£4,448,497	125	125	£1,250,000	0	0	£0
   	Stockport	810	810	£7,712,000	190	190	£1,900,000	0	0	£0
   North East	Stockton-on-Tees	90	90	£752,000	65	65	£650,000	0	0	£0
   West Midlands	Stoke-on-Trent	410	434	£4,240,000	38	38	£380,000	0	0	£0
   East of England	Suffolk	175	175	£1,394,000	110	110	£1,100,000	0	0	£0
   North East	Sunderland	272	271	£2,536,500	189	189	£1,890,000	0	0	£0
   South East	Surrey	1,679	1,666	£15,709,016	272	272	£2,720,000	36	36	£664,246
   Outer London	Sutton	284	288	£2,327,300	75	75	£750,000	0	0	£0
   South West	Swindon	254	254	£2,400,000	135	135	£1,350,000	0	0	£0
   North West	Tameside	541	567	£5,537,667	92	93	£925,833	0	0	£0
   West Midlands	Telford and Wrekin	563	558	£5,568,833	48	48	£480,000	0	0	£0
   South West	Torbay	283	283	£2,766,000	0	0	£0	0	0	£0
   Inner London	Tower Hamlets	872	872	£8,240,000	225	225	£2,250,000	0	0	£0
   North West	Trafford	346	353	£3,300,833	60	60	£600,000	0	0	£0
   Yorkshire and The Humber	Wakefield	641	640	£6,404,166	171	171	£1,710,000	30	34	£803,296
   West Midlands	Walsall	710	709	£7,094,167	125	112	£1,174,133	0	0	£0
   Outer London	Waltham Forest	154	154	£1,077,000	128	118	£1,221,700	0	0	£0
   Inner London	Wandsworth	784	836	£7,470,667	130	130	£1,300,000	42	42	£420,000
   North West	Warrington	475	475	£4,518,000	0	0	£0	0	0	£0
   West Midlands	Warwickshire	584	584	£6,093,440	0	0	£0	0	0	£0
   South East	West Berkshire	400	0	£3,876,000	66	0	£660,000	0	0	£0
   West Midlands		11,265	11,345	£111,062,669	1,272	1,244	£12,556,633	25	25	£735,153
   Inner London	Westminster	206	217	£2,016,498	0	0	£0	0	0	£0
   East Midlands	West Northamptonshire	u	u	u	u	u	u	u	u	u
   South East	West Sussex	2,051	2,029	£19,607,000	276	276	£2,760,000	16	16	£160,000
   North West	Wigan	904	958	£9,318,000	0	0	£0	0	0	£0
   South West	Wiltshire	658	658	£5,748,000	0	0	£0	0	0	£0
   South East	Windsor and Maidenhead	301	309	£2,976,666	35	35	£350,000	0	0	£0
   North West	Wirral	1,251	1,251	£12,054,000	0	0	£0	80	80	£1,411,980
   South East	Wokingham	296	311	£2,947,500	47	47	£470,000	16	16	£160,000
   West Midlands	Wolverhampton	858	893	£8,440,167	0	0	£0	0	0	£485,153
   	Worcestershire	1,030	1,030	£10,115,000	145	145	£1,450,000	0	0	£0
   Yorkshire and The Humber	York	196	196	£1,920,000	192	192	£1,920,000	0	0	£0
   	Yorkshire and The Humber	7,936	8,249	£78,864,603	1,288	1,262	£12,728,334	30	34	£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

   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)