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 2028/29

5. Step 5

   • Indicators:
     • Local authority pupil forecasts (includes 2021/22 actual pupil numbers)
   • Year group:
     • Secondary 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 Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2021/22 and 2028/29

   		Local authority pupil forecasts (includes 2021/22 actual pupil numbers)
   		2021/22	2022/23	2023/24	2024/25	2025/26	2026/27	2027/28	2028/29
   North East	County Durham	28,626	29,762	30,501	30,829	31,142	31,079	30,759	30,167
   	Darlington	6,401	6,395	6,518	6,529	6,407	6,362	6,312	6,137
   	Gateshead	12,028	12,507	12,872	13,178	13,087	13,258	13,199	13,183
   	Hartlepool	5,871	5,910	5,970	5,883	5,797	5,690	5,570	5,416
   	Middlesbrough	8,858	9,176	9,367	9,511	9,635	9,629	9,557	9,559
   	Newcastle upon Tyne	16,794	17,461	18,056	18,493	18,856	19,106	19,304	19,407
   	North Tyneside	12,360	12,479	12,551	12,474	12,529	12,389	12,374	12,203
   	Northumberland	18,866	18,894	19,378	19,506	19,357	19,110	18,994	18,653
   	Redcar and Cleveland	8,286	8,364	8,477	8,457	8,487	8,345	8,034	7,860
   	South Tyneside	9,066	9,217	9,414	9,365	9,305	9,315	9,348	9,278
   	Stockton-on-Tees	12,110	12,447	12,587	12,611	12,636	12,494	12,261	12,022
   	Sunderland	15,874	16,063	16,479	16,469	16,475	16,422	16,307	16,023
   North West	Blackburn with Darwen	11,557	11,863	11,984	12,069	11,958	12,041	11,976	11,926
   	Blackpool	6,735	6,919	7,067	7,137	7,287	7,356	7,321	7,269
   	Bolton	21,039	21,703	22,400	22,756	22,942	23,058	23,149	23,022
   	Bury	11,322	11,388	11,535	11,524	11,422	11,332	11,184	10,795
   	Cheshire East	24,547	25,323	26,072	26,557	26,988	27,226	27,418	27,306
   	Cheshire West and Chester	21,359	22,138	22,659	22,937	23,014	23,016	22,950	22,742
   	Cumbria	30,787	31,280	31,484	31,507	31,312	30,993	30,622	30,292
   	Halton	7,844	7,756	7,853	7,875	7,918	7,919	7,899	7,762
   	Knowsley	5,723	5,840	5,851	5,782	5,626	5,545	5,509	5,522
   	Lancashire	71,302	72,726	73,998	74,581	74,703	74,870	74,752	74,156
   	Liverpool	31,411	32,295	33,276	33,754	34,264	34,825	35,214	35,527
   	Manchester	33,484	34,493	35,478	36,420	36,912	37,382	37,532	37,388
   	Oldham	17,985	18,398	18,569	18,716	18,807	18,873	18,890	18,982
   	Rochdale	13,994	14,368	14,726	14,997	15,212	15,386	15,634	15,754
   	Salford	12,587	13,146	13,406	13,663	13,739	13,723	13,737	13,626
   	Sefton	16,570	17,042	17,298	17,399	17,487	17,351	17,160	17,026
   	St. Helens	11,195	11,255	11,416	11,378	11,330	11,213	11,085	10,957
   	Stockport	15,907	16,192	16,391	16,409	16,403	16,522	16,432	16,282
   	Tameside	14,567	14,935	15,305	15,587	15,574	15,465	15,346	15,241
   	Trafford	19,384	19,938	20,804	21,014	21,218	21,335	21,550	21,493
   	Warrington	13,553	13,964	14,360	14,575	14,675	14,782	14,778	14,604
   	Wigan	19,446	20,043	20,594	20,686	20,697	20,631	20,133	19,796
   	Wirral	22,020	22,257	22,668	22,732	22,665	22,513	22,376	22,021
   Yorkshire and The Humber	Barnsley	12,852	13,340	13,611	13,695	13,685	13,627	13,392	13,268
   	Bradford	38,960	39,384	39,842	39,976	39,986	39,782	39,482	38,893
   	Calderdale	15,955	16,348	16,590	16,512	16,430	16,210	16,033	15,694
   	Doncaster	18,750	20,049	20,758	21,157	21,350	21,444	21,309	21,158
   	East Riding of Yorkshire	19,280	19,548	19,687	19,690	19,631	19,532	19,343	19,149
   	Kingston upon Hull, City of	16,135	16,472	16,902	17,087	17,193	17,136	17,044	16,771
   	Kirklees	27,144	27,510	27,857	27,816	27,721	27,602	27,333	27,062
   	Leeds	50,883	52,568	54,541	55,828	56,693	57,348	58,006	57,822
   	North East Lincolnshire	9,232	9,578	9,904	9,999	10,079	10,044	9,929	9,770
   	North Lincolnshire	10,270	10,387	10,519	10,673	10,653	10,599	10,491	10,258
   	North Yorkshire	37,074	37,441	37,901	38,009	38,094	38,027	37,950	37,736
   	Rotherham	18,940	19,392	19,815	19,957	19,989	19,873	19,880	19,768
   	Sheffield	33,598	34,620	35,254	35,551	35,493	35,484	35,548	35,441
   	Wakefield	20,818	21,190	21,598	21,780	21,949	21,819	21,754	21,504
   	York	11,198	11,406	11,489	11,475	11,419	11,281	11,091	10,955
   East Midlands	Derby	18,063	18,619	19,219	19,461	19,498	19,518	19,439	19,099
   	Derbyshire	45,514	45,961	46,380	46,163	46,081	45,748	45,690	45,517
   	Leicester	22,128	22,830	23,260	23,452	23,514	23,432	23,187	22,886
   	Leicestershire	43,255	44,362	46,014	47,057	48,074	48,663	48,644	48,337
   	Lincolnshire	48,860	50,032	50,862	51,028	51,429	51,377	51,197	50,828
   	North Northamptonshire	23,289	23,837	24,321	24,666	24,729	24,761	24,698	24,532
   	Nottingham	17,985	18,792	19,417	19,870	19,978	20,076	20,003	19,709
   	Nottinghamshire	52,568	54,735	56,856	58,102	58,884	59,173	59,014	58,864
   	Rutland	2,809	2,946	3,035	3,094	3,109	3,132	3,090	3,030
   	West Northamptonshire	28,258	29,064	29,664	30,048	30,231	30,276	30,292	30,101
   West Midlands	Birmingham	82,585	84,854	86,575	87,449	88,134	88,589	88,971	88,905
   	Coventry	23,918	24,803	25,444	25,873	26,144	26,171	26,298	26,092
   	Dudley	18,203	18,359	18,820	18,981	19,160	19,084	19,064	18,726
   	Herefordshire, County of	9,373	9,597	9,765	9,913	9,982	9,921	9,868	9,826
   	Sandwell	24,530	25,248	25,949	26,288	26,320	26,304	26,180	25,937
   	Shropshire	16,145	16,460	16,531	16,568	16,551	16,498	16,597	16,724
   	Solihull	18,168	18,360	18,588	18,742	18,749	18,873	18,917	18,884
   	Staffordshire	52,474	53,967	54,915	55,619	56,167	56,403	56,480	56,527
   	Stoke-on-Trent	14,909	15,549	15,882	16,007	16,182	16,264	16,099	15,869
   	Telford and Wrekin	13,332	13,960	14,436	14,865	15,068	15,065	14,985	14,861
   	Walsall	22,097	22,479	22,964	23,253	23,457	23,610	23,672	23,762
   	Warwickshire	38,464	40,881	42,616	43,870	44,871	45,636	45,985	46,205
   	Wolverhampton	19,865	20,555	20,992	21,200	21,384	21,502	21,406	21,200
   	Worcestershire	34,095	34,861	35,667	36,258	36,497	36,812	37,067	37,127
   East of England	Bedford	12,513	13,223	14,032	14,585	15,077	15,336	15,638	15,833
   	Cambridgeshire	35,603	36,802	38,222	39,262	40,035	40,858	41,346	41,384
   	Central Bedfordshire	17,690	18,758	19,727	20,547	21,198	21,735	22,197	22,637
   	Essex	93,136	95,584	98,067	99,633	100,744	101,001	101,112	100,862
   	Hertfordshire	90,195	92,870	95,200	96,686	97,531	97,987	98,458	98,347
   	Luton	15,663	16,020	16,234	16,199	16,178	16,116	15,962	15,949
   	Norfolk	48,764	50,274	51,568	52,415	53,117	53,735	53,766	53,435
   	Peterborough	17,329	17,834	18,212	18,692	19,148	19,469	19,572	19,526
   	Southend-on-Sea	14,609	14,789	14,857	15,115	15,100	15,010	15,042	15,093
   	Suffolk	42,125	43,281	44,370	44,972	45,417	45,488	44,943	44,083
   	Thurrock	11,803	12,766	12,977	13,048	13,173	13,384	13,542	13,589
   South East	Bracknell Forest	7,997	8,176	8,478	8,791	8,883	8,925	8,955	8,957
   	Brighton and Hove	12,911	13,049	13,050	12,891	12,791	12,593	12,400	12,227
   	Buckinghamshire	40,010	40,809	41,397	41,751	41,907	42,013	42,069	41,882
   	East Sussex	27,264	27,897	28,478	28,743	28,711	28,676	28,462	27,942
   	Hampshire	71,761	72,949	73,883	74,074	74,117	73,797	73,687	73,288
   	Isle of Wight	7,234	7,188	7,147	7,137	7,205	7,103	7,030	6,855
   	Kent	109,782	113,909	117,631	119,598	120,837	121,834	122,777	123,108
   	Medway	21,178	21,920	22,722	23,254	23,665	23,962	24,161	24,243
   	Milton Keynes	20,914	21,979	23,011	23,788	24,207	24,543	24,685	24,816
   	Oxfordshire	41,083	42,964	42,855	42,966	43,247	43,475	43,755	43,935
   	Portsmouth	10,115	10,541	10,820	10,993	11,170	11,300	11,383	11,189
   	Reading	9,236	9,415	9,660	9,837	10,022	10,073	10,225	10,340
   	Slough	14,885	15,366	15,748	15,937	16,001	15,968	15,948	15,872
   	Southampton	12,445	12,960	13,390	13,380	13,369	13,383	13,039	12,737
   	Surrey	65,083	68,662	70,931	72,175	73,349	74,024	74,421	74,372
   	West Berkshire	12,418	12,818	13,131	13,279	13,264	13,209	13,122	12,907
   	West Sussex	48,915	50,257	51,855	52,917	53,612	54,189	54,562	54,751
   	Windsor and Maidenhead	10,565	10,950	11,155	11,238	11,185	11,091	11,033	10,990
   	Wokingham	12,311	12,847	13,307	13,750	14,079	14,309	14,545	14,674
   South West	Bath and North East Somerset	13,497	13,720	13,805	13,863	13,864	13,939	14,055	14,084
   	Bournemouth, Christchurch and Poole	23,401	24,122	24,815	25,233	25,421	25,451	25,377	25,157
   	Bristol, City of	23,394	24,321	25,000	25,584	25,801	25,812	25,736	25,448
   	Cornwall	30,739	31,605	32,373	32,875	32,940	32,868	32,406	31,745
   	Devon	39,854	40,889	41,769	42,160	42,428	42,488	42,300	41,998
   	Dorset	22,644	22,919	23,056	23,002	22,809	22,544	22,399	22,163
   	Gloucestershire	41,433	42,551	44,360	45,419	46,408	46,801	47,124	46,685
   	Isles of Scilly	106	112	100	105	110	124	120	115
   	North Somerset	13,692	14,062	14,335	14,529	14,562	14,505	14,418	14,164
   	Plymouth	17,254	17,670	17,925	18,047	18,017	17,892	17,649	17,247
   	Somerset	28,418	28,998	29,392	29,417	29,419	29,244	29,043	28,757
   	South Gloucestershire	16,004	16,636	17,267	17,851	18,234	18,882	19,221	19,497
   	Swindon	13,383	14,050	14,441	14,518	14,701	14,663	14,329	14,031
   	Torbay	9,086	9,229	9,415	9,423	9,421	9,266	9,100	8,816
   	Wiltshire	30,491	31,555	32,443	33,123	33,734	33,862	34,155	34,180
   Inner London	Camden	10,541	10,506	10,333	10,257	10,165	10,040	9,939	9,834
   	City of London	z	z	z	z	z	z	z	z
   	Hackney	14,747	14,805	14,963	14,977	14,918	14,960	14,959	14,920
   	Hammersmith and Fulham	9,029	9,177	9,185	9,088	8,945	8,825	8,742	8,635
   	Haringey	15,368	16,103	15,986	15,888	15,682	15,571	15,466	15,352
   	Islington	8,309	8,309	8,361	8,319	8,231	8,162	8,130	8,099
   	Kensington and Chelsea	6,192	6,307	6,325	6,269	6,188	6,064	5,982	5,911
   	Lambeth	14,065	14,262	14,012	13,723	13,345	13,015	12,613	12,163
   	Lewisham	13,035	13,150	13,073	12,951	12,805	12,565	12,307	12,103
   	Newham	25,748	27,396	27,340	27,196	26,937	26,478	26,042	25,725
   	Southwark	18,774	19,126	19,334	19,180	18,882	18,558	18,368	18,143
   	Tower Hamlets	18,840	18,953	19,246	19,245	19,189	19,171	19,193	19,132
   	Wandsworth	13,348	13,447	13,612	13,616	13,517	13,452	13,297	13,143
   	Westminster	11,454	11,467	11,365	11,304	11,170	11,040	10,928	10,805
   Outer London	Barking and Dagenham	18,029	18,833	19,412	19,803	19,978	20,125	20,263	20,271
   	Barnet	28,352	28,863	29,043	29,026	28,966	28,829	28,788	28,758
   	Bexley	20,220	20,481	20,620	20,726	20,809	20,879	20,939	20,992
   	Brent	19,990	20,179	20,317	20,419	20,335	20,313	20,341	20,327
   	Bromley	24,395	25,042	25,477	25,532	25,540	25,352	25,185	24,947
   	Croydon	22,939	22,293	22,678	22,765	22,709	22,512	22,376	22,007
   	Ealing	21,862	22,290	22,598	22,836	22,965	22,777	22,524	22,252
   	Enfield	23,412	24,166	24,304	24,183	23,947	23,670	23,499	23,310
   	Greenwich	17,247	17,894	18,193	18,291	18,334	18,332	18,323	18,297
   	Harrow	15,477	15,776	15,766	15,775	15,770	15,704	15,626	15,542
   	Havering	16,615	17,011	17,370	17,705	18,043	18,420	18,905	19,138
   	Hillingdon	21,682	22,370	22,781	22,887	22,938	22,831	22,599	22,352
   	Hounslow	19,515	19,965	20,409	20,434	20,468	20,458	20,361	20,152
   	Kingston upon Thames	12,286	12,838	13,037	13,232	13,449	13,622	13,697	13,750
   	Merton	10,253	10,419	10,676	10,708	10,586	10,460	10,364	10,225
   	Redbridge	25,755	26,036	26,292	26,401	26,362	26,410	26,465	26,547
   	Richmond upon Thames	11,249	11,634	11,872	12,073	12,158	12,300	12,415	12,551
   	Sutton	21,007	21,621	22,228	22,500	22,551	22,651	22,690	22,650
   	Waltham Forest	15,680	15,945	16,083	16,052	16,082	16,196	16,304	16,407

   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)