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:
     • 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 2020/21 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 2020/21 and 2025/26

   		2020/21	2021/22	2022/23	2023/24	2024/25	2025/26
   North East	County Durham	38,725	38,447	37,953	37,521	36,786	36,514
   	Darlington	8,761	8,527	8,368	8,080	7,839	7,662
   	Gateshead	14,750	14,713	14,343	14,079	13,784	13,356
   	Hartlepool	7,804	7,631	7,454	7,271	7,149	7,017
   	Middlesbrough	13,582	13,505	13,296	13,083	12,786	12,567
   	Newcastle upon Tyne	21,881	22,060	21,963	21,887	21,692	21,519
   	North Tyneside	16,244	16,096	16,028	16,017	15,727	15,588
   	Northumberland	23,062	23,096	23,084	22,470	21,725	21,386
   	Redcar and Cleveland	11,115	11,034	10,780	10,427	10,117	9,830
   	South Tyneside	11,768	11,743	11,744	11,579	11,453	11,308
   	Stockton-on-Tees	17,228	17,022	16,664	16,350	15,875	15,438
   	Sunderland	21,191	21,248	21,038	20,481	20,075	19,763
   North West	Blackburn with Darwen	15,135	15,106	14,894	14,655	14,492	14,278
   	Blackpool	11,611	11,578	11,534	11,403	11,261	11,014
   	Bolton	28,142	28,482	28,479	28,412	28,557	28,401
   	Bury	16,368	16,051	15,725	15,266	14,731	14,211
   	Cheshire East	29,350	29,359	29,520	29,596	29,870	30,037
   	Cheshire West and Chester	27,342	27,800	27,698	27,514	27,351	27,193
   	Cumbria	35,349	34,930	34,196	33,652	33,155	32,807
   	Halton	10,659	10,555	10,456	10,271	10,103	10,055
   	Knowsley	12,990	13,200	13,335	13,342	13,454	13,581
   	Lancashire	97,908	97,310	96,881	96,604	96,229	96,040
   	Liverpool	38,060	38,568	38,841	38,639	39,035	39,389
   	Manchester	49,593	49,980	49,328	48,545	47,604	47,820
   	Oldham	24,145	25,023	25,044	25,060	25,099	25,161
   	Rochdale	21,245	21,699	21,794	21,833	21,826	21,889
   	Salford	21,639	21,556	21,336	21,230	20,994	20,973
   	Sefton	21,040	20,848	20,509	20,287	20,106	19,881
   	St. Helens	14,576	14,538	14,388	14,116	13,812	13,645
   	Stockport	24,464	24,068	24,111	24,101	24,093	24,185
   	Tameside	20,738	20,734	20,558	20,743	20,912	20,542
   	Trafford	21,059	21,294	21,405	21,053	20,592	20,235
   	Warrington	17,580	17,728	17,419	16,951	16,381	15,791
   	Wigan	26,211	26,165	25,873	25,597	25,223	24,930
   	Wirral	25,701	25,503	25,045	24,205	23,831	23,376
   Yorkshire and The Humber	Barnsley	20,052	20,049	19,851	19,560	19,340	19,106
   	Bradford	54,211	53,385	52,428	51,594	50,409	49,320
   	Calderdale	18,623	18,583	18,397	17,815	17,402	17,082
   	Doncaster	25,292	26,149	26,152	25,920	25,441	25,195
   	East Riding of Yorkshire	24,519	24,296	23,956	23,240	23,033	22,899
   	Kingston upon Hull, City of	23,212	23,059	22,831	22,335	22,122	22,016
   	Kirklees	37,390	37,053	36,320	35,580	34,919	34,393
   	Leeds	69,505	70,087	69,909	69,135	68,073	66,354
   	North East Lincolnshire	13,467	13,602	13,296	13,004	12,734	12,559
   	North Lincolnshire	13,511	13,307	13,111	12,826	12,470	12,226
   	North Yorkshire	42,203	42,237	42,136	41,846	41,642	41,508
   	Rotherham	22,717	22,721	22,503	22,259	21,859	21,731
   	Sheffield	44,127	44,359	43,969	43,272	42,707	42,085
   	Wakefield	28,890	28,960	28,826	28,418	28,091	27,944
   	York	13,487	13,337	13,003	12,746	12,396	12,151
   East Midlands	Derby	23,416	23,335	23,114	22,884	22,706	22,666
   	Derbyshire	58,836	58,491	57,772	56,997	56,855	57,080
   	Leicester	33,033	33,133	32,415	31,608	30,490	29,750
   	Leicestershire	54,846	54,900	55,705	56,543	57,579	58,305
   	Lincolnshire	55,894	55,363	54,598	53,799	53,193	52,476
   	North Northamptonshire	29,764	29,799	29,797	29,782	29,621	29,751
   	Nottingham	26,476	26,659	26,184	25,619	24,811	24,134
   	Nottinghamshire	66,248	66,823	66,809	66,386	66,517	66,797
   	Rutland	2,793	2,779	2,821	2,795	2,756	2,775
   	West Northamptonshire	35,846	35,828	35,777	35,670	35,541	35,540
   West Midlands	Birmingham	109,646	108,629	106,505	104,082	101,390	98,420
   	Coventry	30,773	31,192	30,803	30,283	29,652	29,218
   	Dudley	26,910	26,773	26,610	26,094	25,636	25,295
   	Herefordshire, County of	13,325	13,335	13,313	13,396	13,340	13,405
   	Sandwell	33,809	33,968	33,737	33,373	32,957	32,842
   	Shropshire	21,059	21,217	21,372	21,234	21,173	21,095
   	Solihull	19,111	19,218	19,188	19,071	18,979	18,796
   	Staffordshire	66,063	65,818	65,962	66,088	66,430	66,823
   	Stoke-on-Trent	22,559	22,241	22,074	21,983	21,747	21,356
   	Telford and Wrekin	16,009	16,087	15,917	15,672	15,387	15,215
   	Walsall	26,620	26,848	26,750	26,520	26,265	25,678
   	Warwickshire	44,979	46,982	47,528	48,141	48,526	49,155
   	Wolverhampton	24,639	24,958	24,876	24,757	24,681	24,478
   	Worcestershire	44,145	44,449	44,789	44,940	44,695	44,881
   East of England	Bedford	15,764	16,244	16,819	17,259	17,483	17,567
   	Cambridgeshire	50,552	50,773	51,099	51,773	52,801	54,323
   	Central Bedfordshire	25,239	25,525	25,603	25,742	25,799	25,871
   	Essex	118,105	119,001	119,917	120,098	120,857	121,595
   	Hertfordshire	99,443	99,522	99,195	98,398	97,331	97,273
   	Luton	22,377	22,188	21,773	21,355	20,962	20,612
   	Norfolk	64,025	64,030	63,452	62,681	61,618	60,949
   	Peterborough	21,423	21,430	21,304	21,281	21,251	21,377
   	Southend-on-Sea	14,996	14,759	14,503	14,251	14,052	13,835
   	Suffolk	55,122	55,460	55,656	55,333	55,091	54,510
   	Thurrock	17,289	17,919	18,065	18,137	18,136	18,025
   South East	Bracknell Forest	9,871	9,740	9,540	9,288	9,049	8,886
   	Brighton and Hove	18,060	17,758	17,437	16,987	16,519	15,970
   	Buckinghamshire	44,277	44,082	43,802	43,349	42,906	42,986
   	East Sussex	38,089	37,536	36,955	36,315	35,724	35,579
   	Hampshire	106,542	105,949	104,838	103,871	103,063	102,801
   	Isle of Wight	9,257	9,136	8,976	8,677	8,341	7,995
   	Kent	126,214	126,263	126,388	125,437	124,914	124,815
   	Medway	24,747	25,307	25,197	24,939	24,730	24,412
   	Milton Keynes	26,439	26,238	26,594	26,821	27,139	27,717
   	Oxfordshire	52,444	52,797	52,458	52,443	52,613	53,092
   	Portsmouth	16,122	15,911	15,739	15,482	15,191	14,979
   	Reading	13,093	13,150	12,995	12,770	12,510	12,440
   	Slough	16,610	16,488	16,176	15,818	15,529	15,301
   	Southampton	19,749	19,435	18,867	18,393	18,050	17,728
   	Surrey	89,289	91,976	92,431	92,327	91,984	91,088
   	West Berkshire	13,124	13,222	13,137	12,846	12,609	12,389
   	West Sussex	65,104	64,907	64,594	64,423	63,930	63,600
   	Windsor and Maidenhead	11,288	11,111	10,980	10,750	10,641	10,564
   	Wokingham	15,420	15,404	15,261	15,310	15,224	15,178
   South West	Bath and North East Somerset	12,988	13,112	13,189	13,209	13,272	13,313
   	Bournemouth, Christchurch and Poole	27,612	27,369	26,842	26,171	25,611	25,137
   	Bristol, City of	35,756	35,396	34,848	34,101	33,215	32,453
   	Cornwall	41,435	42,346	42,032	41,504	40,880	40,443
   	Devon	55,394	56,316	56,641	56,417	56,158	54,872
   	Dorset	24,519	24,256	23,803	23,292	22,923	22,659
   	Gloucestershire	47,398	47,015	46,570	45,884	45,059	44,274
   	Isles of Scilly	150	149	141	144	132	120
   	North Somerset	16,759	16,433	16,122	15,773	15,282	15,012
   	Plymouth	20,356	19,904	19,342	18,923	18,277	17,869
   	Somerset	40,699	40,388	39,844	39,275	38,837	38,205
   	South Gloucestershire	23,500	23,772	23,871	24,017	23,893	23,976
   	Swindon	20,586	20,550	20,420	20,208	20,083	19,972
   	Torbay	9,768	9,562	9,334	9,048	8,864	8,635
   	Wiltshire	38,478	39,349	39,123	38,744	38,685	38,623
   Inner London	Camden	10,212	9,860	9,610	9,470	9,300	9,190
   	City of London	230	240	240	210	210	210
   	Hackney	17,740	17,440	17,309	17,195	17,037	16,922
   	Hammersmith and Fulham	9,430	9,267	9,241	9,217	9,088	8,995
   	Haringey	20,182	19,716	19,585	19,461	19,355	19,218
   	Islington	13,048	12,702	12,582	12,477	12,380	12,254
   	Kensington and Chelsea	6,503	6,399	6,389	6,370	6,279	6,227
   	Lambeth	20,598	20,016	19,423	18,759	18,143	17,542
   	Lewisham	23,680	23,169	22,594	22,093	21,624	21,233
   	Newham	33,157	33,498	33,224	33,184	33,106	33,258
   	Southwark	21,932	21,318	20,902	20,453	20,071	19,736
   	Tower Hamlets	23,317	23,035	23,067	22,890	22,865	22,729
   	Wandsworth	18,113	18,117	18,354	18,393	18,393	18,295
   	Westminster	8,926	8,648	8,563	8,510	8,435	8,372
   Outer London	Barking and Dagenham	24,627	24,917	25,194	25,088	24,917	24,860
   	Barnet	29,706	29,544	29,488	29,191	29,025	28,841
   	Bexley	22,088	22,115	21,990	21,822	21,767	21,761
   	Brent	25,339	25,078	25,015	24,942	25,003	24,967
   	Bromley	27,421	27,154	27,249	27,219	27,037	26,908
   	Croydon	31,757	31,628	31,631	31,375	31,210	30,857
   	Ealing	29,188	28,343	27,591	26,881	26,167	25,419
   	Enfield	30,397	30,647	30,167	29,647	29,405	29,342
   	Greenwich	24,424	24,273	24,292	24,139	23,924	23,689
   	Harrow	21,480	21,339	21,470	21,488	21,417	21,437
   	Havering	22,636	23,032	23,427	23,661	23,729	23,934
   	Hillingdon	27,270	27,222	27,354	27,151	26,946	26,531
   	Hounslow	23,093	22,918	22,941	22,659	22,500	22,370
   	Kingston upon Thames	13,130	13,060	13,087	13,097	13,205	13,337
   	Merton	15,866	15,522	15,344	15,213	15,075	14,920
   	Redbridge	29,783	29,877	29,784	29,365	28,925	28,536
   	Richmond upon Thames	16,523	16,248	15,853	15,363	14,946	14,634
   	Sutton	17,741	17,643	17,584	17,444	17,444	17,444
   	Waltham Forest	23,590	24,083	24,183	24,235	24,325	24,585

   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)