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

3. Step 3

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

4. Step 4

   • Time period: 2020/21

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
     • Pupils in places that exceed their school's capacity
   • 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' for Primary in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2020/21

   		Number of schools	Number of school places	Number of pupils on roll	Number of schools at or in excess of capacity	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	Unfilled places	Unfilled places as a percentage of total places
   North East	County Durham	212	46,186	38,792	28	263	0.6%	184	7,657	16.6%
   	Darlington	29	9,320	8,477	3	10	0.1%	26	853	9.2%
   	Gateshead	67	17,066	14,757	7	65	0.4%	60	2,374	13.9%
   	Hartlepool	30	9,155	7,812	0	0	0.0%	30	1,343	14.7%
   	Middlesbrough	41	14,600	13,467	8	43	0.3%	33	1,176	8.1%
   	Newcastle upon Tyne	72	22,513	20,786	17	47	0.2%	55	1,774	7.9%
   	North Tyneside	55	16,535	14,645	11	62	0.4%	44	1,952	11.8%
   	Northumberland	123	24,877	20,135	13	170	0.7%	110	4,912	19.7%
   	Redcar and Cleveland	44	12,775	11,133	5	48	0.4%	39	1,690	13.2%
   	South Tyneside	45	12,814	11,801	9	43	0.3%	36	1,056	8.2%
   	Stockton-on-Tees	60	19,813	17,260	5	21	0.1%	55	2,574	13.0%
   	Sunderland	81	23,265	20,582	10	60	0.3%	71	2,743	11.8%
   North West	Blackburn with Darwen	55	16,473	14,849	10	37	0.2%	45	1,661	10.1%
   	Blackpool	31	12,251	11,088	4	24	0.2%	27	1,187	9.7%
   	Bolton	97	29,010	27,961	27	117	0.4%	70	1,166	4.0%
   	Bury	64	17,848	16,387	21	247	1.4%	43	1,708	9.6%
   	Cheshire East	124	32,081	29,490	34	222	0.7%	90	2,813	8.8%
   	Cheshire West and Chester	130	30,992	27,437	27	200	0.6%	103	3,755	12.1%
   	Cumbria	268	42,031	35,230	42	385	0.9%	226	7,186	17.1%
   	Halton	49	11,691	10,334	8	24	0.2%	41	1,381	11.8%
   	Knowsley	50	14,154	13,008	8	77	0.5%	42	1,223	8.6%
   	Lancashire	482	106,059	98,043	110	648	0.6%	372	8,664	8.2%
   	Liverpool	119	39,656	37,607	35	621	1.6%	84	2,670	6.7%
   	Manchester	135	52,911	49,089	22	113	0.2%	113	3,935	7.4%
   	Oldham	86	25,770	24,202	22	149	0.6%	64	1,717	6.7%
   	Rochdale	69	22,827	21,341	18	83	0.4%	51	1,569	6.9%
   	Salford	76	23,709	21,696	14	152	0.6%	62	2,165	9.1%
   	Sefton	75	22,476	21,105	24	189	0.8%	51	1,560	6.9%
   	St. Helens	54	15,900	14,583	11	46	0.3%	43	1,363	8.6%
   	Stockport	85	27,034	24,485	21	142	0.5%	64	2,691	10.0%
   	Tameside	76	22,618	20,759	13	64	0.3%	63	1,923	8.5%
   	Trafford	65	21,704	21,204	30	403	1.9%	35	903	4.2%
   	Warrington	69	19,438	17,665	10	103	0.5%	59	1,876	9.7%
   	Wigan	101	27,536	26,266	30	317	1.2%	71	1,587	5.8%
   	Wirral	90	27,996	25,347	21	190	0.7%	69	2,839	10.1%
   Yorkshire and The Humber	Barnsley	77	21,057	19,673	17	109	0.5%	60	1,493	7.1%
   	Bradford	156	56,922	52,663	24	116	0.2%	132	4,375	7.7%
   	Calderdale	82	20,580	18,239	8	50	0.2%	74	2,391	11.6%
   	Doncaster	99	30,076	25,665	8	88	0.3%	91	4,499	15.0%
   	East Riding of Yorkshire	123	27,893	24,152	22	176	0.6%	101	3,917	14.0%
   	Kingston upon Hull, City of	71	25,335	23,264	13	77	0.3%	58	2,148	8.5%
   	Kirklees	143	40,167	36,486	25	122	0.3%	118	3,803	9.5%
   	Leeds	222	72,912	68,029	48	328	0.4%	174	5,211	7.1%
   	North East Lincolnshire	47	15,163	13,536	7	77	0.5%	40	1,704	11.2%
   	North Lincolnshire	62	14,972	13,550	8	84	0.6%	54	1,506	10.1%
   	North Yorkshire	303	51,004	42,321	60	385	0.8%	243	9,068	17.8%
   	Rotherham	95	26,266	22,630	11	34	0.1%	84	3,670	14.0%
   	Sheffield	133	46,996	43,385	30	251	0.5%	103	3,862	8.2%
   	Wakefield	113	32,013	29,189	18	96	0.3%	95	2,920	9.1%
   	York	50	15,402	13,502	7	33	0.2%	43	1,933	12.6%
   East Midlands	Derby	72	25,429	23,197	14	104	0.4%	58	2,336	9.2%
   	Derbyshire	353	66,102	58,931	90	837	1.3%	263	8,008	12.1%
   	Leicester	82	34,141	32,884	29	205	0.6%	53	1,462	4.3%
   	Leicestershire	226	61,143	54,962	45	382	0.6%	181	6,563	10.7%
   	Lincolnshire	280	63,520	55,553	37	274	0.4%	243	8,241	13.0%
   	North Northamptonshire	111	33,223	29,435	16	90	0.3%	95	3,878	11.7%
   	Nottingham	75	27,963	25,810	5	25	0.1%	70	2,178	7.8%
   	Nottinghamshire	282	73,096	66,434	52	346	0.5%	229	6,952	9.5%
   	Rutland	17	3,286	2,811	1	6	0.2%	16	481	14.6%
   	West Northamptonshire	146	39,657	34,293	13	73	0.2%	133	5,437	13.7%
   West Midlands	Birmingham	295	114,411	106,558	68	411	0.4%	227	8,264	7.2%
   	Coventry	85	33,765	30,623	8	15	0.0%	77	3,157	9.3%
   	Dudley	78	28,482	26,946	14	66	0.2%	64	1,602	5.6%
   	Herefordshire, County of	78	14,667	13,144	23	254	1.7%	55	1,777	12.1%
   	Sandwell	94	35,332	33,927	29	226	0.6%	65	1,631	4.6%
   	Shropshire	126	23,426	20,962	26	246	1.1%	100	2,710	11.6%
   	Solihull	59	20,062	19,147	11	69	0.3%	48	984	4.9%
   	Staffordshire	299	71,832	63,202	49	299	0.4%	250	8,929	12.4%
   	Stoke-on-Trent	71	24,264	22,606	14	100	0.4%	57	1,758	7.2%
   	Telford and Wrekin	54	17,260	16,145	13	86	0.5%	41	1,201	7.0%
   	Walsall	85	27,304	26,269	15	58	0.2%	70	1,093	4.0%
   	Warwickshire	194	50,764	45,018	27	172	0.3%	167	5,918	11.7%
   	Wolverhampton	71	25,090	24,184	20	138	0.6%	51	1,044	4.2%
   	Worcestershire	182	46,112	40,702	27	150	0.3%	155	5,560	12.1%
   East of England	Bedford	54	18,796	15,539	4	32	0.2%	50	3,289	17.5%
   	Cambridgeshire	210	63,023	50,699	16	125	0.2%	194	12,449	19.8%
   	Central Bedfordshire	98	26,106	20,724	5	46	0.2%	92	5,353	20.5%
   	Essex	448	129,057	118,062	94	705	0.5%	354	11,700	9.1%
   	Hertfordshire	402	108,410	97,802	63	241	0.2%	339	10,849	10.0%
   	Luton	47	24,862	22,439	2	22	0.1%	45	2,445	9.8%
   	Norfolk	351	74,974	63,880	54	379	0.5%	296	11,383	15.2%
   	Peterborough	58	23,120	20,637	8	57	0.2%	50	2,540	11.0%
   	Southend-on-Sea	33	16,330	14,999	4	14	0.1%	29	1,345	8.2%
   	Suffolk	253	63,465	54,880	30	197	0.3%	223	8,782	13.8%
   	Thurrock	39	18,574	17,316	4	6	0.0%	35	1,264	6.8%
   South East	Bracknell Forest	29	11,161	9,826	4	5	0.0%	25	1,340	12.0%
   	Brighton and Hove	52	20,984	18,069	9	86	0.4%	43	3,001	14.3%
   	Buckinghamshire	184	46,950	43,533	42	223	0.5%	142	3,640	7.8%
   	East Sussex	148	40,085	37,277	34	289	0.7%	114	3,097	7.7%
   	Hampshire	425	114,613	105,666	86	904	0.8%	339	9,851	8.6%
   	Isle of Wight	38	9,952	8,836	7	79	0.8%	31	1,195	12.0%
   	Kent	459	138,886	125,893	96	664	0.5%	363	13,657	9.8%
   	Medway	76	26,890	24,693	12	118	0.4%	64	2,315	8.6%
   	Milton Keynes	89	30,473	26,073	9	87	0.3%	80	4,487	14.7%
   	Oxfordshire	240	61,514	51,639	14	49	0.1%	226	9,924	16.1%
   	Portsmouth	46	17,035	15,636	6	8	0.0%	40	1,407	8.3%
   	Reading	40	15,230	13,077	2	7	0.0%	38	2,160	14.2%
   	Slough	28	17,264	16,353	2	72	0.4%	26	983	5.7%
   	Southampton	55	22,584	19,788	7	31	0.1%	48	2,827	12.5%
   	Surrey	300	96,672	88,929	48	181	0.2%	252	7,924	8.2%
   	West Berkshire	66	14,229	13,159	15	80	0.6%	51	1,150	8.1%
   	West Sussex	228	71,981	64,348	20	60	0.1%	208	7,693	10.7%
   	Windsor and Maidenhead	46	11,444	10,292	6	4	0.0%	40	1,156	10.1%
   	Wokingham	54	16,596	15,342	21	98	0.6%	33	1,352	8.1%
   South West	Bath and North East Somerset	65	16,371	13,009	7	43	0.3%	58	3,405	20.8%
   	Bournemouth, Christchurch and Poole	66	29,358	26,805	13	274	0.9%	53	2,827	9.6%
   	Bristol, City of	106	40,570	34,885	11	66	0.2%	95	5,751	14.2%
   	Cornwall	234	46,893	41,630	53	357	0.8%	181	5,620	12.0%
   	Devon	311	64,591	55,005	55	327	0.5%	256	9,913	15.3%
   	Dorset	121	25,654	21,665	18	110	0.4%	103	4,099	16.0%
   	Gloucestershire	245	53,053	47,500	41	187	0.4%	204	5,740	10.8%
   	Isles of Scilly	z	z	z	z	z	z	z	z	z
   	North Somerset	63	18,758	16,760	5	66	0.4%	58	2,064	11.0%
   	Plymouth	69	23,552	20,175	6	47	0.2%	63	3,424	14.5%
   	Somerset	217	43,536	38,081	30	270	0.6%	187	5,725	13.2%
   	South Gloucestershire	93	25,842	23,037	8	22	0.1%	85	2,827	10.9%
   	Swindon	64	22,242	19,866	9	98	0.4%	55	2,474	11.1%
   	Torbay	30	10,430	9,781	10	66	0.6%	20	715	6.9%
   	Wiltshire	202	46,982	38,591	19	95	0.2%	183	8,486	18.1%
   Inner London	Camden	41	12,085	10,200	3	38	0.3%	38	1,923	15.9%
   	City of London	1	240	225	0	0	0.0%	1	15	6.3%
   	Hackney	58	21,870	17,665	3	91	0.4%	55	4,296	19.6%
   	Hammersmith and Fulham	36	11,385	9,086	3	8	0.1%	33	2,307	20.3%
   	Haringey	63	23,055	19,879	3	8	0.0%	60	3,184	13.8%
   	Islington	46	15,771	12,784	2	5	0.0%	44	2,992	19.0%
   	Kensington and Chelsea	27	7,745	6,507	3	13	0.2%	24	1,251	16.2%
   	Lambeth	60	24,506	19,368	3	191	0.8%	57	5,329	21.7%
   	Lewisham	65	27,159	22,244	3	18	0.1%	62	4,933	18.2%
   	Newham	67	36,467	31,524	1	0	0.0%	66	4,943	13.6%
   	Southwark	74	27,395	21,442	0	0	0.0%	74	5,953	21.7%
   	Tower Hamlets	68	25,684	23,054	6	39	0.2%	62	2,669	10.4%
   	Wandsworth	62	23,499	18,014	4	214	0.9%	58	5,699	24.3%
   	Westminster	39	10,853	8,280	0	0	0.0%	39	2,573	23.7%
   Outer London	Barking and Dagenham	43	26,818	23,050	1	2	0.0%	42	3,770	14.1%
   	Barnet	90	31,623	28,461	16	141	0.4%	74	3,303	10.4%
   	Bexley	59	24,019	21,756	5	24	0.1%	54	2,287	9.5%
   	Brent	60	29,568	24,535	6	120	0.4%	54	5,153	17.4%
   	Bromley	77	30,469	27,374	16	201	0.7%	61	3,296	10.8%
   	Croydon	86	38,577	30,848	5	47	0.1%	81	7,776	20.2%
   	Ealing	68	32,439	28,525	6	57	0.2%	62	3,971	12.2%
   	Enfield	68	33,050	28,856	3	42	0.1%	65	4,236	12.8%
   	Greenwich	63	26,950	23,604	6	73	0.3%	57	3,419	12.7%
   	Harrow	41	23,916	20,786	6	27	0.1%	35	3,157	13.2%
   	Havering	60	26,023	22,704	5	22	0.1%	55	3,341	12.8%
   	Hillingdon	69	32,692	26,690	0	0	0.0%	69	6,002	18.4%
   	Hounslow	51	25,185	22,089	3	38	0.2%	48	3,134	12.4%
   	Kingston upon Thames	35	14,370	13,134	2	0	0.0%	33	1,236	8.6%
   	Merton	44	19,039	15,704	3	40	0.2%	41	3,375	17.7%
   	Redbridge	52	29,476	27,076	5	60	0.2%	47	2,460	8.3%
   	Richmond upon Thames	45	18,922	16,445	3	28	0.1%	42	2,505	13.2%
   	Sutton	40	18,116	17,766	21	443	2.4%	19	793	4.4%
   	Waltham Forest	51	26,880	22,514	0	0	0.0%	51	4,366	16.2%

   Footnotes

   1. z - Indicates data is not applicable.
   2. Includes community, foundation, voluntary and middle schools as deemed. Includes academies/free schools. Includes sixth form places. Excludes all special schools. 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)