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: School capacity

2. Step 2

   • Data set: Local authority pupil forecasts

3. Step 3

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

4. Step 4

   • Time period: 2021/22 to 2026/27

5. Step 5

   • Indicators:
     • Local authority pupil forecasts (includes 2021/22 actual pupil numbers)
   • Year group:
     • Primary total

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Academic year 2022/23

   Local authority pupil forecasts (includes 2021/22 actual pupil numbers) for 'Local authority pupil forecasts' for Primary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2021/22 and 2026/27

   		2021/22	2022/23	2023/24	2024/25	2025/26	2026/27
   North East	County Durham	38,251	37,622	37,195	36,370	35,606	35,174
   	Darlington	8,633	8,542	8,286	8,066	7,938	7,739
   	Gateshead	14,649	14,553	14,433	14,151	13,917	13,506
   	Hartlepool	7,689	7,533	7,333	7,196	7,050	6,906
   	Middlesbrough	13,640	13,587	13,385	13,134	12,907	12,731
   	Newcastle upon Tyne	21,997	22,125	22,024	21,766	21,611	21,454
   	North Tyneside	16,035	16,122	16,086	15,771	15,348	15,133
   	Northumberland	22,861	22,647	22,441	22,116	21,525	21,184
   	Redcar and Cleveland	11,018	10,714	10,369	10,025	9,727	9,500
   	South Tyneside	11,687	11,713	11,518	11,327	11,192	11,118
   	Stockton-on-Tees	17,068	16,739	16,377	15,937	15,548	15,187
   	Sunderland	21,165	21,007	20,533	20,191	19,893	19,504
   North West	Blackburn with Darwen	15,192	15,036	14,867	14,609	14,330	13,859
   	Blackpool	11,662	11,625	11,493	11,341	11,085	10,936
   	Bolton	28,165	28,028	27,784	27,769	27,485	27,241
   	Bury	16,184	15,856	15,434	14,996	14,479	14,027
   	Cheshire East	29,556	29,653	29,744	30,000	30,255	30,388
   	Cheshire West and Chester	27,377	27,646	27,820	27,858	27,813	27,831
   	Cumbria	35,179	34,427	33,805	33,029	32,391	31,928
   	Halton	10,548	10,415	10,215	9,903	9,756	9,506
   	Knowsley	13,255	13,251	13,311	13,376	13,360	13,457
   	Lancashire	97,895	97,049	96,886	96,095	95,518	94,666
   	Liverpool	38,772	39,107	39,150	39,181	39,439	39,613
   	Manchester	49,836	49,397	48,784	47,471	46,294	45,817
   	Oldham	24,157	24,099	24,243	24,190	23,930	23,881
   	Rochdale	21,441	21,690	21,730	21,703	21,659	21,622
   	Salford	21,791	21,881	21,889	21,715	21,572	21,516
   	Sefton	21,024	20,674	20,409	20,002	19,663	19,455
   	St. Helens	14,555	14,432	14,194	13,970	13,728	13,541
   	Stockport	24,608	24,501	24,362	24,251	24,186	24,074
   	Tameside	20,442	20,354	20,132	19,942	19,738	19,434
   	Trafford	21,398	21,326	21,536	21,137	20,850	20,374
   	Warrington	17,732	17,802	17,577	17,236	16,750	16,044
   	Wigan	26,120	25,850	25,599	25,285	25,153	24,982
   	Wirral	25,479	25,151	24,343	23,960	23,526	23,128
   Yorkshire and The Humber	Barnsley	20,059	19,800	19,509	19,222	18,794	18,446
   	Bradford	53,808	52,820	52,082	50,953	49,653	48,258
   	Calderdale	18,281	18,367	17,834	17,428	16,960	16,623
   	Doncaster	25,636	25,909	25,883	25,503	25,304	25,010
   	East Riding of Yorkshire	24,543	24,277	23,647	22,963	22,559	22,013
   	Kingston upon Hull, City of	23,158	22,925	22,458	22,270	21,854	21,657
   	Kirklees	37,285	36,627	35,936	35,406	34,840	34,410
   	Leeds	69,532	69,529	68,802	67,818	66,521	65,300
   	North East Lincolnshire	13,493	13,488	13,205	12,982	12,585	12,142
   	North Lincolnshire	13,383	13,271	13,026	12,725	12,515	12,258
   	North Yorkshire	42,170	42,157	41,883	41,640	41,423	41,217
   	Rotherham	22,655	22,460	22,177	21,690	21,408	21,330
   	Sheffield	44,362	44,852	44,425	44,080	43,306	42,148
   	Wakefield	29,137	29,016	28,570	28,184	27,869	27,736
   	York	13,269	12,958	12,683	12,304	11,813	11,428
   East Midlands	Derby	23,327	23,044	22,830	22,601	22,474	22,298
   	Derbyshire	58,397	57,775	56,930	56,513	56,698	56,696
   	Leicester	32,834	32,442	31,736	30,967	29,913	29,090
   	Leicestershire	54,981	54,783	55,695	56,807	58,069	58,620
   	Lincolnshire	55,885	54,934	54,214	53,582	52,668	51,946
   	North Northamptonshire	29,783	29,862	29,871	29,762	29,799	29,765
   	Nottingham	26,630	26,649	26,231	25,575	24,835	24,000
   	Nottinghamshire	66,944	66,757	66,465	66,056	65,411	64,444
   	Rutland	2,740	2,778	2,797	2,710	2,666	2,644
   	West Northamptonshire	35,732	35,992	36,377	36,553	36,687	36,775
   West Midlands	Birmingham	109,718	109,074	107,590	106,104	104,371	102,505
   	Coventry	30,640	30,749	30,233	29,594	29,163	28,759
   	Dudley	26,783	26,562	26,013	25,532	25,182	24,984
   	Herefordshire, County of	13,248	13,394	13,485	13,451	13,507	13,632
   	Sandwell	33,881	33,561	33,088	32,493	32,193	31,844
   	Shropshire	21,207	21,212	21,100	21,011	21,006	20,988
   	Solihull	19,351	19,481	19,369	19,202	19,005	18,827
   	Staffordshire	66,283	65,518	65,723	65,987	66,216	66,626
   	Stoke-on-Trent	22,320	21,771	21,536	21,352	20,959	20,680
   	Telford and Wrekin	16,095	16,207	16,256	16,142	15,759	15,664
   	Walsall	26,859	26,657	26,387	26,080	25,707	25,314
   	Warwickshire	45,354	46,500	47,010	47,294	47,262	47,248
   	Wolverhampton	24,843	24,928	24,783	24,655	24,268	23,904
   	Worcestershire	43,979	44,314	44,367	44,109	44,231	44,040
   East of England	Bedford	15,875	16,204	16,524	16,576	16,382	16,329
   	Cambridgeshire	50,707	50,894	51,112	51,735	52,819	54,194
   	Central Bedfordshire	25,523	26,067	26,696	27,422	28,096	28,788
   	Essex	118,399	119,245	119,583	119,625	120,160	120,591
   	Hertfordshire	98,794	98,183	97,405	96,420	95,320	94,230
   	Luton	22,617	22,343	22,055	21,764	21,528	21,399
   	Norfolk	63,930	63,321	62,612	61,952	61,285	60,480
   	Peterborough	21,489	21,555	21,496	21,496	21,584	21,733
   	Southend-on-Sea	14,924	14,735	14,478	14,321	14,145	13,842
   	Suffolk	55,076	55,332	55,146	55,024	54,390	53,876
   	Thurrock	17,430	17,996	17,965	17,879	17,573	17,391
   South East	Bracknell Forest	9,808	9,631	9,288	9,049	8,886	9,054
   	Brighton and Hove	17,609	17,294	16,812	16,397	15,805	15,246
   	Buckinghamshire	44,278	44,154	43,842	43,521	43,379	43,416
   	East Sussex	37,588	37,002	36,291	35,594	35,148	34,820
   	Hampshire	106,445	105,776	105,195	104,870	104,635	103,546
   	Isle of Wight	9,133	8,969	8,688	8,382	8,063	7,701
   	Kent	127,293	127,975	128,094	127,997	128,079	127,739
   	Medway	25,055	25,442	25,278	25,180	24,964	24,661
   	Milton Keynes	26,725	26,831	26,753	26,409	26,542	26,755
   	Oxfordshire	52,544	52,411	52,066	51,890	52,054	52,290
   	Portsmouth	15,978	15,896	15,577	15,363	15,097	14,790
   	Reading	13,207	13,275	13,230	13,205	13,315	13,490
   	Slough	16,632	16,501	16,222	15,942	15,608	15,273
   	Southampton	19,691	19,282	18,822	18,479	18,010	17,429
   	Surrey	89,077	90,930	91,106	90,865	90,016	88,637
   	West Berkshire	13,051	12,856	12,687	12,500	12,212	11,960
   	West Sussex	65,030	64,497	64,130	64,485	64,435	64,263
   	Windsor and Maidenhead	11,066	11,112	10,882	10,685	10,563	10,440
   	Wokingham	15,761	15,775	15,749	15,643	15,647	15,625
   South West	Bath and North East Somerset	12,994	13,157	13,218	13,333	13,550	13,707
   	Bournemouth, Christchurch and Poole	27,694	27,200	26,544	25,929	25,495	25,081
   	Bristol, City of	35,316	34,831	34,081	33,106	32,500	31,953
   	Cornwall	41,209	40,863	40,376	39,785	39,371	38,902
   	Devon	55,394	55,324	54,923	54,310	53,713	52,295
   	Dorset	24,259	23,888	23,363	23,015	22,755	22,502
   	Gloucestershire	47,306	46,703	47,210	47,540	47,833	48,071
   	Isles of Scilly	157	148	148	139	134	120
   	North Somerset	16,547	16,254	15,880	15,392	15,041	14,619
   	Plymouth	20,116	19,623	19,250	18,668	18,108	17,703
   	Somerset	40,703	39,979	39,412	38,932	38,279	37,548
   	South Gloucestershire	23,594	24,039	24,258	24,256	24,349	24,308
   	Swindon	20,598	20,351	20,039	19,807	19,558	19,490
   	Torbay	9,590	9,346	9,045	8,668	8,374	8,148
   	Wiltshire	38,130	38,488	38,380	38,022	37,262	37,229
   Inner London	Camden	10,105	9,846	9,711	9,537	9,374	9,152
   	City of London	238	240	210	210	210	210
   	Hackney	17,280	17,000	16,724	16,392	15,994	15,517
   	Hammersmith and Fulham	9,089	9,028	8,898	8,734	8,580	8,376
   	Haringey	19,566	19,494	19,477	19,486	19,316	18,996
   	Islington	12,712	12,685	12,555	12,490	12,389	12,213
   	Kensington and Chelsea	6,503	6,404	6,328	6,212	6,168	6,069
   	Lambeth	19,928	19,175	18,360	17,586	16,847	16,113
   	Lewisham	22,900	22,337	21,813	21,290	20,879	20,475
   	Newham	32,733	32,435	31,886	31,278	30,624	30,043
   	Southwark	21,315	21,009	20,704	20,332	19,944	19,551
   	Tower Hamlets	23,175	23,152	22,784	22,512	22,055	21,650
   	Wandsworth	17,551	17,655	17,577	17,358	16,994	16,632
   	Westminster	8,727	8,441	8,271	8,085	7,926	7,648
   Outer London	Barking and Dagenham	24,382	24,609	24,640	24,488	24,595	24,431
   	Barnet	29,761	29,396	29,101	29,106	29,051	28,812
   	Bexley	21,769	21,748	21,579	21,515	21,422	21,248
   	Brent	25,213	25,071	24,903	24,782	24,584	24,256
   	Bromley	27,273	27,081	26,787	26,536	26,226	25,678
   	Croydon	31,405	31,887	31,588	31,200	30,909	30,528
   	Ealing	28,547	27,791	27,201	26,557	25,886	25,255
   	Enfield	29,611	29,744	29,117	28,579	28,034	27,350
   	Greenwich	24,118	24,042	23,865	23,603	23,316	22,945
   	Harrow	21,322	21,338	21,335	21,160	21,014	20,703
   	Havering	23,223	23,938	24,283	24,395	24,643	24,653
   	Hillingdon	27,024	26,808	26,459	26,158	25,605	24,919
   	Hounslow	22,823	22,748	22,374	22,012	21,596	21,013
   	Kingston upon Thames	13,144	13,071	13,059	13,074	13,253	13,435
   	Merton	15,332	15,031	14,979	14,825	14,615	14,246
   	Redbridge	29,489	29,073	28,709	28,345	28,002	27,490
   	Richmond upon Thames	16,143	15,766	15,355	14,843	14,653	14,410
   	Sutton	17,839	17,598	17,237	16,919	16,620	16,285
   	Waltham Forest	23,387	23,690	23,742	23,826	24,067	24,250

   Footnotes

   1. Number of actual pupils on roll in 2021/22 taken from January 2022 School Census.
   2. Pupil forecasts are provided from 2022/23 to 2026/27 for primary (Reception to Year 6) and from 2022/23 to 2028/29 for secondary (Year 7 to Year 13).

   Save table

   Related information

   • Release type:
   • Publication: School capacity, Academic year 2022/23

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