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: 2020/21 to 2027/28

5. Step 5

   • Indicators:
     • Local authority pupil forecasts (includes 2020/21 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 2020/21 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 2020/21 and 2027/28

   		2020/21	2021/22	2022/23	2023/24	2024/25	2025/26	2026/27	2027/28
   North East	County Durham	28,100	29,433	30,489	31,138	31,502	31,788	31,608	31,193
   	Darlington	6,374	6,431	6,429	6,532	6,537	6,406	6,325	6,168
   	Gateshead	11,989	12,390	12,909	13,153	13,351	13,387	13,502	13,429
   	Hartlepool	5,793	5,885	5,917	5,977	5,882	5,800	5,699	5,568
   	Middlesbrough	8,605	8,862	9,140	9,319	9,481	9,575	9,505	9,380
   	Newcastle upon Tyne	16,308	17,067	17,622	18,223	18,682	19,028	19,174	19,248
   	North Tyneside	12,211	12,288	12,327	12,362	12,290	12,342	12,243	12,214
   	Northumberland	18,866	19,146	19,413	19,657	19,525	19,328	18,927	18,742
   	Redcar and Cleveland	8,262	8,347	8,385	8,493	8,490	8,524	8,370	8,134
   	South Tyneside	8,887	9,328	9,518	9,733	9,713	9,644	9,629	9,768
   	Stockton-on-Tees	11,844	12,118	12,309	12,442	12,430	12,458	12,252	12,024
   	Sunderland	15,746	16,018	16,373	16,642	16,552	16,538	16,455	16,240
   North West	Blackburn with Darwen	11,355	11,504	11,767	11,931	11,987	11,877	11,904	11,799
   	Blackpool	6,623	6,692	6,889	7,030	7,105	7,226	7,254	7,204
   	Bolton	20,403	21,233	21,890	22,439	22,591	22,591	22,539	22,438
   	Bury	11,256	11,308	11,376	11,415	11,302	11,219	11,097	10,918
   	Cheshire East	24,096	24,741	25,557	26,397	26,917	27,325	27,460	27,518
   	Cheshire West and Chester	21,060	21,677	22,114	22,515	22,584	22,621	22,414	22,197
   	Cumbria	30,357	30,899	31,087	31,222	31,131	30,832	30,437	30,130
   	Halton	7,798	7,917	7,906	8,003	8,002	8,033	8,044	8,029
   	Knowsley	5,695	5,874	6,052	6,306	6,414	6,459	6,520	6,479
   	Lancashire	70,530	71,663	73,046	73,861	74,146	74,098	73,817	73,374
   	Liverpool	30,819	31,250	32,385	33,422	33,834	34,352	34,855	35,213
   	Manchester	31,796	33,259	33,907	34,495	34,921	34,867	34,885	34,921
   	Oldham	17,546	18,827	19,261	19,546	19,638	19,706	19,681	19,789
   	Rochdale	13,721	14,095	14,486	14,794	15,016	15,177	15,301	15,454
   	Salford	12,163	12,641	13,128	13,361	13,568	13,627	13,513	13,438
   	Sefton	16,231	16,611	16,883	17,044	17,079	17,115	16,902	16,805
   	St. Helens	11,049	11,399	11,564	11,758	11,743	11,711	11,590	11,462
   	Stockport	15,631	15,996	16,312	16,497	16,548	16,590	16,710	16,632
   	Tameside	14,076	14,880	15,304	15,628	15,793	15,843	15,622	15,394
   	Trafford	18,850	19,799	20,171	20,609	20,707	20,745	20,644	20,429
   	Warrington	13,335	13,577	13,915	14,181	14,254	14,289	14,513	14,553
   	Wigan	19,182	19,738	20,344	20,818	20,882	20,854	20,574	20,083
   	Wirral	21,806	22,295	22,630	22,975	22,996	22,939	22,747	22,558
   Yorkshire and The Humber	Barnsley	12,459	12,759	13,139	13,319	13,356	13,287	13,512	13,305
   	Bradford	38,046	39,052	39,592	40,017	40,185	40,194	39,755	39,306
   	Calderdale	15,868	16,403	16,726	17,081	17,066	17,083	16,820	16,604
   	Doncaster	18,383	19,359	20,159	20,785	21,248	21,228	21,022	20,845
   	East Riding of Yorkshire	19,015	19,175	19,285	19,375	19,301	19,153	18,958	18,801
   	Kingston upon Hull, City of	15,694	16,085	16,462	16,873	17,036	17,089	16,989	16,849
   	Kirklees	26,794	27,275	27,701	28,049	28,062	27,965	27,769	27,482
   	Leeds	49,251	51,609	53,573	55,465	56,692	57,485	57,719	57,739
   	North East Lincolnshire	9,031	9,342	9,533	9,647	9,868	9,766	9,933	9,683
   	North Lincolnshire	10,151	10,251	10,474	10,674	10,821	10,792	10,731	10,569
   	North Yorkshire	36,793	37,428	37,772	38,142	38,206	38,324	38,235	38,255
   	Rotherham	18,654	19,318	19,718	20,032	20,077	20,007	19,780	19,708
   	Sheffield	32,993	33,888	34,411	34,967	35,266	35,286	35,341	35,468
   	Wakefield	20,371	20,889	21,225	21,535	21,704	21,827	21,659	21,580
   	York	11,148	11,355	11,469	11,583	11,533	11,447	11,291	11,244
   East Midlands	Derby	17,500	18,077	18,541	19,028	19,240	19,232	19,074	18,882
   	Derbyshire	44,764	45,328	45,834	46,155	45,838	45,744	45,406	45,121
   	Leicester	21,340	22,312	22,872	23,207	23,343	23,408	23,332	23,080
   	Leicestershire	42,576	43,618	45,509	46,991	48,237	48,874	48,962	48,744
   	Lincolnshire	47,804	49,020	49,852	50,634	50,824	51,115	50,921	50,645
   	North Northamptonshire	22,629	23,224	23,728	24,169	24,441	24,402	24,262	24,045
   	Nottingham	17,230	17,973	18,647	19,181	19,541	19,606	19,537	19,265
   	Nottinghamshire	50,941	53,163	55,173	57,026	58,078	58,694	58,399	58,453
   	Rutland	2,756	2,865	2,948	2,956	2,968	2,952	2,929	2,914
   	West Northamptonshire	27,335	27,876	28,469	28,926	29,134	29,234	29,155	29,226
   West Midlands	Birmingham	81,398	82,210	83,321	83,941	83,654	83,031	81,978	80,820
   	Coventry	23,135	24,271	25,017	25,819	26,313	26,566	26,582	26,613
   	Dudley	18,034	18,236	18,438	18,936	19,109	19,286	19,175	19,142
   	Herefordshire, County of	9,301	9,471	9,779	10,018	10,191	10,289	10,257	10,165
   	Sandwell	23,813	24,630	25,274	25,952	26,357	26,472	26,443	26,310
   	Shropshire	16,074	16,352	16,568	16,754	16,728	16,717	16,741	16,994
   	Solihull	18,166	18,221	18,407	18,477	18,565	18,545	18,675	18,817
   	Staffordshire	51,495	53,208	54,624	55,589	56,208	56,701	56,794	56,926
   	Stoke-on-Trent	14,606	15,011	15,696	15,990	16,068	16,259	16,279	16,145
   	Telford and Wrekin	12,839	13,225	13,686	13,987	14,265	14,356	14,279	14,142
   	Walsall	21,746	22,081	22,474	22,834	22,996	23,136	23,274	23,286
   	Warwickshire	37,735	39,910	41,302	42,825	44,242	45,455	46,327	46,708
   	Wolverhampton	19,225	19,904	20,672	21,248	21,515	21,752	21,797	21,656
   	Worcestershire	33,705	34,501	35,599	36,563	37,290	37,662	37,979	38,238
   East of England	Bedford	12,007	12,747	13,632	14,528	15,296	15,980	16,234	16,460
   	Cambridgeshire	34,888	35,956	37,475	39,044	40,068	40,799	41,114	41,343
   	Central Bedfordshire	17,208	18,204	19,183	20,015	20,499	20,849	20,830	20,884
   	Essex	91,388	94,127	96,189	98,429	99,631	100,602	101,033	101,313
   	Hertfordshire	87,862	90,775	93,474	95,742	97,054	98,043	99,434	100,982
   	Luton	15,279	15,587	15,826	15,963	15,822	15,698	15,559	15,284
   	Norfolk	47,971	49,093	50,576	51,844	52,449	52,895	53,180	52,995
   	Peterborough	16,683	17,347	17,987	18,567	19,018	19,248	19,320	19,359
   	Southend-on-Sea	14,117	14,564	15,084	15,183	15,230	15,215	15,140	15,212
   	Suffolk	41,755	42,999	44,281	45,342	45,952	46,365	46,003	45,422
   	Thurrock	11,341	12,029	12,496	12,761	12,870	13,015	13,224	13,298
   South East	Bracknell Forest	7,689	7,942	8,187	8,478	8,791	8,883	8,925	8,955
   	Brighton and Hove	12,738	13,125	13,234	13,273	13,132	13,033	12,852	12,657
   	Buckinghamshire	39,041	39,958	40,583	41,076	41,313	41,354	41,293	41,256
   	East Sussex	26,918	27,547	28,102	28,569	28,825	28,788	28,623	28,341
   	Hampshire	70,465	71,214	72,512	72,944	72,952	72,773	72,792	72,492
   	Isle of Wight	7,180	7,209	7,243	7,183	7,129	7,110	6,993	6,926
   	Kent	107,058	110,250	112,441	114,972	116,207	116,863	117,088	117,005
   	Medway	20,490	21,223	21,945	22,659	22,946	23,100	23,131	23,096
   	Milton Keynes	20,133	21,034	22,250	23,235	24,106	24,674	25,180	25,450
   	Oxfordshire	40,266	41,057	41,976	42,664	42,993	43,400	43,613	43,865
   	Portsmouth	9,712	10,083	10,371	10,561	10,727	10,855	10,908	10,850
   	Reading	8,865	9,440	9,835	10,140	10,215	10,290	10,385	10,385
   	Slough	14,230	14,872	15,357	15,728	15,890	15,930	15,838	15,734
   	Southampton	11,929	12,499	13,036	13,405	13,375	13,428	13,302	12,889
   	Surrey	63,892	67,738	70,612	73,084	74,436	75,719	76,468	76,882
   	West Berkshire	12,202	12,602	12,970	13,213	13,348	13,415	13,391	13,350
   	West Sussex	48,017	49,401	51,033	52,867	53,864	54,512	55,171	55,447
   	Windsor and Maidenhead	10,416	10,616	10,778	10,923	10,945	10,888	10,751	10,697
   	Wokingham	11,691	12,168	12,527	12,985	13,307	13,549	13,602	13,729
   South West	Bath and North East Somerset	13,390	13,644	13,902	14,096	14,209	14,264	14,419	14,458
   	Bournemouth, Christchurch and Poole	22,808	23,468	24,135	24,722	25,018	25,095	25,026	24,832
   	Bristol, City of	22,650	23,541	24,596	25,425	25,862	26,116	26,252	26,278
   	Cornwall	30,286	31,150	32,122	32,925	33,391	33,472	33,398	32,976
   	Devon	39,649	40,779	41,998	43,067	43,567	43,953	44,060	43,882
   	Dorset	22,524	22,764	22,980	23,043	22,971	22,783	22,526	22,350
   	Gloucestershire	40,445	41,855	42,764	43,540	43,719	43,857	43,558	43,410
   	Isles of Scilly	99	105	110	96	102	106	118	114
   	North Somerset	13,249	13,806	14,232	14,359	14,435	14,455	14,296	14,182
   	Plymouth	16,885	17,182	17,496	17,676	17,732	17,618	17,440	17,124
   	Somerset	28,104	28,733	29,157	29,436	29,339	29,299	29,065	28,795
   	South Gloucestershire	15,784	16,305	16,897	17,431	17,933	18,359	18,722	18,956
   	Swindon	12,921	13,367	13,702	13,834	13,795	13,800	13,601	13,443
   	Torbay	9,160	9,304	9,472	9,574	9,570	9,560	9,410	9,230
   	Wiltshire	30,071	30,978	31,813	32,478	32,861	33,592	33,757	34,146
   Inner London	Camden	10,359	10,380	10,270	10,150	10,030	9,910	9,820	9,730
   	City of London	z	z	z	z	z	z	z	z
   	Hackney	14,612	14,911	15,023	14,993	14,859	14,594	14,455	14,363
   	Hammersmith and Fulham	8,820	9,029	9,054	9,062	8,992	8,895	8,803	8,739
   	Haringey	15,044	15,641	15,646	15,603	15,482	15,350	15,253	15,214
   	Islington	8,158	8,180	8,231	8,224	8,191	8,126	8,068	8,029
   	Kensington and Chelsea	6,040	6,151	6,288	6,314	6,246	6,201	6,122	6,044
   	Lambeth	13,820	14,181	14,025	13,871	13,609	13,269	12,966	12,572
   	Lewisham	12,814	12,850	12,856	12,810	12,735	12,595	12,348	12,044
   	Newham	25,276	27,724	28,165	28,475	28,404	28,272	27,934	27,481
   	Southwark	18,311	18,717	19,067	19,141	18,912	18,664	18,466	18,251
   	Tower Hamlets	18,409	18,580	18,528	18,814	18,843	18,848	18,839	18,912
   	Wandsworth	13,219	13,497	13,774	14,046	14,154	14,260	14,257	14,170
   	Westminster	11,397	12,234	12,399	12,477	12,447	12,351	12,269	12,216
   Outer London	Barking and Dagenham	17,451	18,272	18,953	19,427	19,729	19,828	19,848	20,033
   	Barnet	27,356	27,942	28,369	28,748	28,712	28,664	28,572	28,489
   	Bexley	20,032	20,256	20,329	20,384	20,428	20,465	20,497	20,525
   	Brent	19,739	19,914	20,145	20,337	20,487	20,554	20,545	20,581
   	Bromley	23,864	24,629	25,256	25,590	25,579	25,560	25,490	25,448
   	Croydon	22,662	21,720	22,323	22,633	22,666	22,710	22,632	22,570
   	Ealing	21,258	21,841	22,235	22,480	22,615	22,657	22,380	22,026
   	Enfield	23,187	23,621	23,796	23,777	23,370	23,158	22,998	22,883
   	Greenwich	16,747	17,378	17,864	18,184	18,260	18,259	18,327	18,331
   	Harrow	15,058	15,360	15,742	15,914	15,940	15,977	15,965	15,975
   	Havering	16,375	16,550	16,774	17,089	17,368	17,574	17,806	18,048
   	Hillingdon	21,261	21,837	22,435	22,899	22,976	23,095	23,103	22,971
   	Hounslow	18,872	19,551	20,136	20,594	20,719	21,006	21,056	21,048
   	Kingston upon Thames	11,875	12,173	12,471	12,754	13,017	13,280	13,473	13,640
   	Merton	9,923	10,269	10,555	10,702	10,673	10,584	10,497	10,420
   	Redbridge	25,635	25,464	25,704	25,991	26,120	26,175	26,159	26,138
   	Richmond upon Thames	10,884	11,080	11,343	11,638	11,860	11,998	12,113	12,178
   	Sutton	20,524	21,246	21,675	22,037	22,228	22,195	22,201	22,176
   	Waltham Forest	15,392	15,980	16,357	16,690	16,919	16,993	17,086	17,084

   Footnotes

   1. Pupil forecasts are provided by local authorities. They include pupils expected to be educated in maintained community, foundation and voluntary schools, city technology colleges, academies, free schools, studio schools and university technology colleges. They also include pupils expected to be educated in new schools (or expanded schools) funded through housing developer contribution (HDC) and housing infrastructure fund (HIF) agreements.
   2. Number of pupils on roll in 2020/21 taken from January 2021 School Census.

   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)