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: School capacity - national, regional, local authority

3. Step 3

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

4. Step 4

   • Time period: 2021/22

5. Step 5

   • Indicators:
     • Number of pupils on roll
     • Number of school places
     • Number of schools
     • Number of schools at or in excess of capacity
     • Number of schools at or in excess of capacity as a percentage of total schools
   • School phase:
     • Primary

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Academic year 2022/23

   Some rows and columns are not shown in this table as the data does not exist in the underlying file.

   'School capacity - national, regional, local authority ' for Primary in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2021/22

   		2021/22
   		Number of schools	Number of school places	Number of pupils on roll	Number of schools at or in excess of capacity	Number of schools at or in excess of capacity as a percentage of total schools	Pupils in places that exceed their school's capacity	Pupils in places that exceed their school's capacity as a percentage of total places	Number of schools with one or more unfilled places	Number of schools with one or more unfilled places as a percentage of total schools	Unfilled places	Unfilled places as a percentage of total places
   North East	County Durham	212	46,361	38,320	23	10.8%	154	0.3%	189	89.2%	8,195	17.7%
   	Darlington	29	9,320	8,303	3	10.3%	12	0.1%	26	89.7%	1,029	11.0%
   	Gateshead	67	17,066	14,698	7	10.4%	60	0.4%	60	89.6%	2,428	14.2%
   	Hartlepool	30	9,155	7,729	1	3.3%	0	0.0%	29	96.7%	1,426	15.6%
   	Middlesbrough	41	14,740	13,750	6	14.6%	84	0.6%	35	85.4%	1,074	7.3%
   	Newcastle upon Tyne	72	22,810	20,959	16	22.2%	52	0.2%	56	77.8%	1,903	8.3%
   	North Tyneside	55	16,612	14,501	8	14.5%	65	0.4%	47	85.5%	2,176	13.1%
   	Northumberland	127	25,185	19,735	9	7.1%	97	0.4%	118	92.9%	5,547	22.0%
   	Redcar and Cleveland	44	12,723	11,049	7	15.9%	64	0.5%	37	84.1%	1,738	13.7%
   	South Tyneside	45	12,814	11,709	8	17.8%	24	0.2%	37	82.2%	1,129	8.8%
   	Stockton-on-Tees	60	19,813	17,222	6	10.0%	31	0.2%	54	90.0%	2,622	13.2%
   	Sunderland	81	23,545	20,664	6	7.4%	36	0.2%	75	92.6%	2,917	12.4%
   North West	Blackburn with Darwen	55	16,473	14,887	13	23.6%	31	0.2%	42	76.4%	1,617	9.8%
   	Blackpool	31	12,251	11,079	3	9.7%	27	0.2%	28	90.3%	1,199	9.8%
   	Bolton	97	28,990	28,053	30	30.9%	136	0.5%	67	69.1%	1,073	3.7%
   	Bury	64	17,848	16,222	18	28.1%	252	1.4%	46	71.9%	1,878	10.5%
   	Cheshire East	124	32,274	29,712	30	24.2%	219	0.7%	94	75.8%	2,781	8.6%
   	Cheshire West and Chester	129	30,952	27,515	24	18.6%	183	0.6%	105	81.4%	3,620	11.7%
   	Cumbria	268	42,143	35,077	43	16.0%	407	1.0%	225	84.0%	7,473	17.7%
   	Halton	49	11,733	10,183	9	18.4%	34	0.3%	40	81.6%	1,584	13.5%
   	Knowsley	50	14,285	13,279	7	14.0%	60	0.4%	43	86.0%	1,066	7.5%
   	Lancashire	482	105,947	98,145	118	24.5%	715	0.7%	364	75.5%	8,517	8.0%
   	Liverpool	118	39,427	38,032	44	37.3%	789	2.0%	74	62.7%	2,184	5.5%
   	Manchester	135	52,911	49,261	25	18.5%	164	0.3%	110	81.5%	3,814	7.2%
   	Oldham	86	25,900	24,199	19	22.1%	161	0.6%	67	77.9%	1,862	7.2%
   	Rochdale	69	22,875	21,555	17	24.6%	65	0.3%	52	75.4%	1,385	6.1%
   	Salford	76	23,832	21,989	12	15.8%	125	0.5%	64	84.2%	1,968	8.3%
   	Sefton	75	22,477	21,068	24	32.0%	232	1.0%	51	68.0%	1,641	7.3%
   	St. Helens	54	15,900	14,603	8	14.8%	46	0.3%	46	85.2%	1,343	8.4%
   	Stockport	85	27,034	24,677	21	24.7%	173	0.6%	64	75.3%	2,530	9.4%
   	Tameside	76	22,498	20,480	10	13.2%	53	0.2%	66	86.8%	2,071	9.2%
   	Trafford	64	21,798	21,562	36	56.3%	495	2.3%	28	43.8%	731	3.4%
   	Warrington	69	19,021	17,904	19	27.5%	161	0.8%	50	72.5%	1,278	6.7%
   	Wigan	101	27,656	26,211	29	28.7%	310	1.1%	72	71.3%	1,755	6.3%
   	Wirral	91	27,886	25,128	21	23.1%	239	0.9%	70	76.9%	2,997	10.7%
   Yorkshire and The Humber	Barnsley	77	21,057	19,675	18	23.4%	124	0.6%	59	76.6%	1,506	7.2%
   	Bradford	156	56,695	52,525	27	17.3%	124	0.2%	129	82.7%	4,294	7.6%
   	Calderdale	82	20,639	17,862	7	8.5%	50	0.2%	75	91.5%	2,827	13.7%
   	Doncaster	98	29,869	25,729	14	14.3%	143	0.5%	84	85.7%	4,283	14.3%
   	East Riding of Yorkshire	123	28,000	24,143	20	16.3%	154	0.6%	103	83.7%	4,011	14.3%
   	Kingston upon Hull, City of	71	25,575	23,209	12	16.9%	46	0.2%	59	83.1%	2,412	9.4%
   	Kirklees	144	40,378	36,488	23	16.0%	72	0.2%	121	84.0%	3,962	9.8%
   	Leeds	222	73,168	68,244	47	21.2%	317	0.4%	175	78.8%	5,241	7.2%
   	North East Lincolnshire	47	15,163	13,516	8	17.0%	86	0.6%	39	83.0%	1,733	11.4%
   	North Lincolnshire	62	14,972	13,436	9	14.5%	73	0.5%	53	85.5%	1,609	10.7%
   	North Yorkshire	302	51,437	42,292	48	15.9%	323	0.6%	254	84.1%	9,468	18.4%
   	Rotherham	95	26,384	22,631	9	9.5%	35	0.1%	86	90.5%	3,788	14.4%
   	Sheffield	133	47,006	43,627	32	24.1%	195	0.4%	101	75.9%	3,574	7.6%
   	Wakefield	113	31,907	29,233	19	16.8%	107	0.3%	94	83.2%	2,781	8.7%
   	York	50	15,247	13,346	9	18.0%	54	0.4%	41	82.0%	1,955	12.8%
   East Midlands	Derby	73	25,688	23,113	13	17.8%	91	0.4%	60	82.2%	2,666	10.4%
   	Derbyshire	354	66,410	58,567	95	26.8%	775	1.2%	259	73.2%	8,618	13.0%
   	Leicester	82	34,105	32,767	23	28.0%	210	0.6%	59	72.0%	1,548	4.5%
   	Leicestershire	227	61,532	55,139	42	18.5%	340	0.6%	185	81.5%	6,733	10.9%
   	Lincolnshire	280	63,368	55,781	43	15.4%	272	0.4%	237	84.6%	7,859	12.4%
   	North Northamptonshire	111	33,230	29,546	12	10.8%	103	0.3%	99	89.2%	3,787	11.4%
   	Nottingham	75	27,873	26,051	10	13.3%	32	0.1%	65	86.7%	1,854	6.7%
   	Nottinghamshire	281	73,324	66,861	47	16.7%	304	0.4%	234	83.3%	6,767	9.2%
   	Rutland	17	3,302	2,754	0	0.0%	0	0.0%	17	100.0%	548	16.6%
   	West Northamptonshire	148	40,547	34,201	10	6.8%	75	0.2%	138	93.2%	6,421	15.8%
   West Midlands	Birmingham	295	114,414	106,892	85	28.8%	498	0.4%	210	71.2%	8,020	7.0%
   	Coventry	85	33,765	30,690	7	8.2%	5	0.0%	78	91.8%	3,080	9.1%
   	Dudley	78	28,500	26,855	15	19.2%	71	0.2%	63	80.8%	1,716	6.0%
   	Herefordshire, County of	78	14,644	13,136	23	29.5%	288	2.0%	55	70.5%	1,796	12.3%
   	Sandwell	94	35,353	34,069	27	28.7%	256	0.7%	67	71.3%	1,540	4.4%
   	Shropshire	126	23,410	21,096	26	20.6%	269	1.1%	100	79.4%	2,583	11.0%
   	Solihull	59	20,092	19,452	18	30.5%	101	0.5%	41	69.5%	741	3.7%
   	Staffordshire	300	72,249	63,440	53	17.7%	294	0.4%	247	82.3%	9,103	12.6%
   	Stoke-on-Trent	71	24,276	22,388	13	18.3%	101	0.4%	58	81.7%	1,989	8.2%
   	Telford and Wrekin	54	17,255	16,210	14	25.9%	84	0.5%	40	74.1%	1,129	6.5%
   	Walsall	85	27,501	26,551	21	24.7%	155	0.6%	64	75.3%	1,105	4.0%
   	Warwickshire	194	50,869	45,390	44	22.7%	306	0.6%	150	77.3%	5,785	11.4%
   	Wolverhampton	71	25,199	24,391	20	28.2%	129	0.5%	51	71.8%	937	3.7%
   	Worcestershire	182	46,360	40,357	21	11.5%	79	0.2%	161	88.5%	6,082	13.1%
   East of England	Bedford	54	18,976	15,612	3	5.6%	19	0.1%	51	94.4%	3,383	17.8%
   	Cambridgeshire	210	63,403	50,975	6	2.9%	6	0.0%	204	97.1%	12,434	19.6%
   	Central Bedfordshire	98	25,630	21,164	6	6.1%	55	0.2%	92	93.9%	4,521	17.6%
   	Essex	448	129,289	118,592	92	20.5%	701	0.5%	356	79.5%	11,398	8.8%
   	Hertfordshire	403	108,712	97,457	48	11.9%	216	0.2%	355	88.1%	11,471	10.6%
   	Luton	47	24,862	23,231	5	10.6%	560	2.3%	42	89.4%	2,191	8.8%
   	Norfolk	348	74,832	63,766	55	15.8%	360	0.5%	293	84.2%	11,426	15.3%
   	Peterborough	58	23,073	20,695	10	17.2%	89	0.4%	48	82.8%	2,467	10.7%
   	Southend-on-Sea	33	16,335	14,965	5	15.2%	12	0.1%	28	84.8%	1,382	8.5%
   	Suffolk	253	63,750	55,013	34	13.4%	255	0.4%	219	86.6%	8,992	14.1%
   	Thurrock	39	18,654	17,465	3	7.7%	4	0.0%	36	92.3%	1,193	6.4%
   South East	Bracknell Forest	29	11,110	9,723	2	6.9%	2	0.0%	27	93.1%	1,389	12.5%
   	Brighton and Hove	52	20,877	17,659	10	19.2%	102	0.5%	42	80.8%	3,320	15.9%
   	Buckinghamshire	185	47,318	43,673	47	25.4%	213	0.5%	138	74.6%	3,858	8.2%
   	East Sussex	148	39,875	36,719	31	20.9%	232	0.6%	117	79.1%	3,388	8.5%
   	Hampshire	425	114,996	105,681	97	22.8%	820	0.7%	328	77.2%	10,135	8.8%
   	Isle of Wight	38	9,833	8,754	7	18.4%	45	0.5%	31	81.6%	1,124	11.4%
   	Kent	459	138,834	126,927	117	25.5%	839	0.6%	342	74.5%	12,746	9.2%
   	Medway	75	26,810	24,983	16	21.3%	150	0.6%	59	78.7%	1,977	7.4%
   	Milton Keynes	89	30,636	26,373	13	14.6%	112	0.4%	76	85.4%	4,375	14.3%
   	Oxfordshire	241	62,041	51,878	14	5.8%	54	0.1%	227	94.2%	10,217	16.5%
   	Portsmouth	46	16,915	15,483	6	13.0%	7	0.0%	40	87.0%	1,439	8.5%
   	Reading	40	15,230	13,403	3	7.5%	5	0.0%	37	92.5%	1,832	12.0%
   	Slough	29	17,196	16,350	6	20.7%	90	0.5%	23	79.3%	936	5.4%
   	Southampton	55	22,464	19,786	5	9.1%	34	0.2%	50	90.9%	2,712	12.1%
   	Surrey	299	96,676	88,947	49	16.4%	248	0.3%	250	83.6%	7,977	8.3%
   	West Berkshire	67	14,413	13,127	11	16.4%	58	0.4%	56	83.6%	1,344	9.3%
   	West Sussex	228	71,993	64,486	28	12.3%	109	0.2%	200	87.7%	7,616	10.6%
   	Windsor and Maidenhead	46	11,418	10,109	5	10.9%	7	0.1%	41	89.1%	1,316	11.5%
   	Wokingham	54	16,855	15,680	20	37.0%	131	0.8%	34	63.0%	1,306	7.7%
   South West	Bath and North East Somerset	65	16,282	12,984	10	15.4%	80	0.5%	55	84.6%	3,378	20.7%
   	Bournemouth, Christchurch and Poole	66	29,358	26,811	18	27.3%	282	1.0%	48	72.7%	2,829	9.6%
   	Bristol, City of	104	40,395	34,618	8	7.7%	74	0.2%	96	92.3%	5,851	14.5%
   	Cornwall	236	47,464	41,369	42	17.8%	315	0.7%	194	82.2%	6,410	13.5%
   	Devon	311	64,784	54,955	43	13.8%	302	0.5%	268	86.2%	10,131	15.6%
   	Dorset	120	25,241	21,368	19	15.8%	133	0.5%	101	84.2%	4,006	15.9%
   	Gloucestershire	244	53,119	47,492	45	18.4%	178	0.3%	199	81.6%	5,805	10.9%
   	Isles of Scilly	z	z	z	z	z	z	z	z	z	z	z
   	North Somerset	64	18,803	16,643	5	7.8%	85	0.5%	59	92.2%	2,245	11.9%
   	Plymouth	69	23,582	19,999	7	10.1%	50	0.2%	62	89.9%	3,633	15.4%
   	Somerset	217	43,627	37,932	31	14.3%	238	0.5%	186	85.7%	5,933	13.6%
   	South Gloucestershire	93	25,753	23,172	12	12.9%	48	0.2%	81	87.1%	2,629	10.2%
   	Swindon	65	22,674	19,977	9	13.8%	96	0.4%	56	86.2%	2,793	12.3%
   	Torbay	31	10,640	9,645	8	25.8%	61	0.6%	23	74.2%	1,056	9.9%
   	Wiltshire	202	46,502	38,193	21	10.4%	116	0.2%	181	89.6%	8,425	18.1%
   Inner London	Camden	40	11,665	10,070	6	15.0%	113	1.0%	34	85.0%	1,708	14.6%
   	City of London	1	240	235	0	0.0%	0	0.0%	1	100.0%	5	2.1%
   	Hackney	58	21,896	17,314	3	5.2%	94	0.4%	55	94.8%	4,676	21.4%
   	Hammersmith and Fulham	36	11,385	8,847	4	11.1%	5	0.0%	32	88.9%	2,543	22.3%
   	Haringey	63	22,965	19,387	3	4.8%	24	0.1%	60	95.2%	3,602	15.7%
   	Islington	45	15,576	12,468	0	0.0%	0	0.0%	45	100.0%	3,108	20.0%
   	Kensington and Chelsea	27	7,775	6,538	3	11.1%	18	0.2%	24	88.9%	1,255	16.1%
   	Lambeth	60	25,309	18,716	2	3.3%	145	0.6%	58	96.7%	6,738	26.6%
   	Lewisham	64	26,949	21,681	4	6.3%	24	0.1%	60	93.8%	5,292	19.6%
   	Newham	68	36,717	31,230	0	0.0%	0	0.0%	68	100.0%	5,487	14.9%
   	Southwark	73	27,155	20,902	1	1.4%	1	0.0%	72	98.6%	6,254	23.0%
   	Tower Hamlets	65	24,994	23,062	7	10.8%	288	1.2%	58	89.2%	2,220	8.9%
   	Wandsworth	62	23,503	17,498	3	4.8%	233	1.0%	59	95.2%	6,238	26.5%
   	Westminster	39	10,853	7,998	0	0.0%	0	0.0%	39	100.0%	2,855	26.3%
   Outer London	Barking and Dagenham	43	26,818	22,771	3	7.0%	4	0.0%	40	93.0%	4,051	15.1%
   	Barnet	90	31,404	28,567	24	26.7%	192	0.6%	66	73.3%	3,029	9.6%
   	Bexley	59	24,019	21,466	6	10.2%	17	0.1%	53	89.8%	2,570	10.7%
   	Brent	60	29,377	24,506	9	15.0%	133	0.5%	51	85.0%	5,004	17.0%
   	Bromley	76	30,411	27,316	14	18.4%	188	0.6%	62	81.6%	3,283	10.8%
   	Croydon	86	38,517	30,668	6	7.0%	43	0.1%	80	93.0%	7,892	20.5%
   	Ealing	67	31,717	28,110	7	10.4%	95	0.3%	60	89.6%	3,702	11.7%
   	Enfield	68	33,034	28,405	3	4.4%	22	0.1%	65	95.6%	4,651	14.1%
   	Greenwich	65	27,370	23,826	7	10.8%	53	0.2%	58	89.2%	3,597	13.1%
   	Harrow	40	23,706	20,821	4	10.0%	48	0.2%	36	90.0%	2,933	12.4%
   	Havering	59	25,984	23,321	8	13.6%	27	0.1%	51	86.4%	2,690	10.4%
   	Hillingdon	67	32,632	26,669	1	1.5%	1	0.0%	66	98.5%	5,964	18.3%
   	Hounslow	51	25,185	21,959	5	9.8%	33	0.1%	46	90.2%	3,259	12.9%
   	Kingston upon Thames	35	14,370	13,193	4	11.4%	12	0.1%	31	88.6%	1,189	8.3%
   	Merton	44	19,039	15,408	3	6.8%	47	0.2%	41	93.2%	3,678	19.3%
   	Redbridge	52	29,566	26,885	5	9.6%	36	0.1%	47	90.4%	2,717	9.2%
   	Richmond upon Thames	46	18,922	16,228	3	6.5%	0	0.0%	43	93.5%	2,694	14.2%
   	Sutton	40	18,116	17,925	25	62.5%	506	2.8%	15	37.5%	697	3.8%
   	Waltham Forest	53	26,880	22,571	5	9.4%	6	0.0%	48	90.6%	4,315	16.1%

   Footnotes

   1. Includes mainstream state schools with capacity in any of the year groups from reception to year 11 on 1 May for the relevant academic year.
   2. Primary places include all reported capacity in primary and middle deemed primary schools. Capacity excludes nursery places.

   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)