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:
     • Secondary

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 Secondary 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	30	34,907	28,161	4	107	0.3%	26	6,853	19.6%
   	Darlington	8	7,235	6,689	3	117	1.6%	5	663	9.2%
   	Gateshead	9	12,556	11,956	2	77	0.6%	7	677	5.4%
   	Hartlepool	5	6,802	5,782	0	0	0.0%	5	1,020	15.0%
   	Middlesbrough	8	10,145	8,577	2	40	0.4%	6	1,608	15.9%
   	Newcastle upon Tyne	15	18,902	17,427	7	355	1.9%	8	1,830	9.7%
   	North Tyneside	16	15,623	13,762	4	202	1.3%	12	2,063	13.2%
   	Northumberland	30	25,939	21,793	7	152	0.6%	23	4,298	16.6%
   	Redcar and Cleveland	10	9,472	8,243	2	11	0.1%	8	1,240	13.1%
   	South Tyneside	8	9,874	8,881	2	50	0.5%	6	1,043	10.6%
   	Stockton-on-Tees	13	13,463	11,831	1	44	0.3%	12	1,676	12.4%
   	Sunderland	18	18,968	16,359	5	368	1.9%	13	2,977	15.7%
   North West	Blackburn with Darwen	12	12,845	11,785	5	211	1.6%	7	1,271	9.9%
   	Blackpool	8	9,022	7,188	0	0	0.0%	8	1,834	20.3%
   	Bolton	20	23,959	20,738	3	53	0.2%	17	3,274	13.7%
   	Bury	13	11,758	11,277	7	212	1.8%	6	693	5.9%
   	Cheshire East	23	26,432	24,088	9	527	2.0%	14	2,871	10.9%
   	Cheshire West and Chester	20	23,428	21,015	8	294	1.3%	12	2,707	11.6%
   	Cumbria	39	37,324	30,513	7	401	1.1%	32	7,212	19.3%
   	Halton	8	10,370	8,146	1	22	0.2%	7	2,246	21.7%
   	Knowsley	6	6,700	5,689	1	4	0.1%	5	1,015	15.1%
   	Lancashire	82	78,269	70,520	25	547	0.7%	57	8,296	10.6%
   	Liverpool	31	34,650	31,288	9	257	0.7%	22	3,619	10.4%
   	Manchester	31	37,647	32,781	6	289	0.8%	25	5,155	13.7%
   	Oldham	13	18,893	17,607	2	102	0.5%	11	1,388	7.3%
   	Rochdale	12	14,430	13,747	1	15	0.1%	11	698	4.8%
   	Salford	15	13,200	12,207	5	214	1.6%	10	1,207	9.1%
   	Sefton	18	19,438	16,231	3	146	0.8%	15	3,353	17.2%
   	St. Helens	9	12,030	11,029	1	29	0.2%	8	1,030	8.6%
   	Stockport	14	17,275	15,622	2	93	0.5%	12	1,746	10.1%
   	Tameside	16	15,426	14,091	4	44	0.3%	12	1,379	8.9%
   	Trafford	19	20,656	18,852	7	185	0.9%	12	1,989	9.6%
   	Warrington	13	15,518	13,338	2	69	0.4%	11	2,249	14.5%
   	Wigan	19	21,042	19,168	3	106	0.5%	16	1,980	9.4%
   	Wirral	20	25,215	22,155	3	50	0.2%	17	3,110	12.3%
   Yorkshire and The Humber	Barnsley	10	13,790	12,862	0	0	0.0%	10	928	6.7%
   	Bradford	35	43,639	39,615	7	304	0.7%	28	4,328	9.9%
   	Calderdale	13	17,226	16,286	3	157	0.9%	10	1,097	6.4%
   	Doncaster	20	22,624	18,410	2	32	0.1%	18	4,246	18.8%
   	East Riding of Yorkshire	18	25,276	19,472	1	72	0.3%	17	5,876	23.2%
   	Kingston upon Hull, City of	13	16,560	15,613	1	38	0.2%	12	985	5.9%
   	Kirklees	27	29,606	27,763	6	224	0.8%	21	2,067	7.0%
   	Leeds	43	55,183	50,560	15	759	1.4%	28	5,382	9.8%
   	North East Lincolnshire	10	10,191	9,023	2	82	0.8%	8	1,250	12.3%
   	North Lincolnshire	15	11,936	10,153	0	0	0.0%	14	1,735	14.5%
   	North Yorkshire	43	44,621	36,744	10	618	1.4%	33	8,495	19.0%
   	Rotherham	16	21,303	18,741	2	49	0.2%	14	2,611	12.3%
   	Sheffield	30	37,095	33,891	7	746	2.0%	23	3,950	10.6%
   	Wakefield	18	23,640	20,298	0	0	0.0%	18	3,342	14.1%
   	York	9	11,767	11,126	3	241	2.0%	6	882	7.5%
   East Midlands	Derby	16	21,532	17,858	1	53	0.2%	15	3,727	17.3%
   	Derbyshire	45	49,709	44,690	9	683	1.4%	36	5,702	11.5%
   	Leicester	20	24,363	21,830	8	178	0.7%	12	2,711	11.1%
   	Leicestershire	44	47,444	42,526	13	520	1.1%	31	5,438	11.5%
   	Lincolnshire	54	54,530	48,144	12	497	0.9%	42	6,883	12.6%
   	North Northamptonshire	20	26,623	23,069	3	102	0.4%	17	3,656	13.7%
   	Nottingham	18	20,387	18,020	1	31	0.2%	17	2,398	11.8%
   	Nottinghamshire	45	57,929	51,269	11	1,420	2.5%	34	8,080	13.9%
   	Rutland	3	2,865	2,748	0	0	0.0%	3	117	4.1%
   	West Northamptonshire	22	33,700	28,911	4	168	0.5%	18	4,957	14.7%
   West Midlands	Birmingham	86	91,297	84,906	29	731	0.8%	57	7,122	7.8%
   	Coventry	22	24,536	23,399	9	723	2.9%	13	1,860	7.6%
   	Dudley	19	19,902	18,011	7	247	1.2%	12	2,138	10.7%
   	Herefordshire, County of	15	10,781	9,470	5	212	2.0%	10	1,523	14.1%
   	Sandwell	20	25,856	23,805	5	129	0.5%	15	2,180	8.4%
   	Shropshire	20	18,418	16,217	4	88	0.5%	16	2,289	12.4%
   	Solihull	15	19,652	18,120	5	310	1.6%	10	1,842	9.4%
   	Staffordshire	70	65,185	54,490	12	351	0.5%	58	11,046	16.9%
   	Stoke-on-Trent	14	15,514	14,593	4	125	0.8%	10	1,046	6.7%
   	Telford and Wrekin	13	13,310	12,854	6	187	1.4%	7	643	4.8%
   	Walsall	19	23,137	22,123	9	382	1.7%	10	1,396	6.0%
   	Warwickshire	36	41,771	37,889	9	261	0.6%	27	4,143	9.9%
   	Wolverhampton	20	22,948	19,817	4	193	0.8%	16	3,324	14.5%
   	Worcestershire	45	43,103	37,050	7	249	0.6%	38	6,302	14.6%
   East of England	Bedford	14	13,999	12,299	4	235	1.7%	10	1,935	13.8%
   	Cambridgeshire	34	41,753	34,874	4	195	0.5%	30	7,074	16.9%
   	Central Bedfordshire	27	25,012	21,694	5	197	0.8%	22	3,515	14.1%
   	Essex	80	102,875	91,291	18	738	0.7%	62	12,322	12.0%
   	Hertfordshire	82	102,977	89,317	16	377	0.4%	66	14,037	13.6%
   	Luton	13	17,335	15,324	2	34	0.2%	11	2,045	11.8%
   	Norfolk	53	57,425	48,168	14	374	0.7%	39	9,631	16.8%
   	Peterborough	14	20,379	17,505	1	77	0.4%	13	2,951	14.5%
   	Southend-on-Sea	12	14,891	14,086	3	138	0.9%	9	943	6.3%
   	Suffolk	46	49,125	42,093	7	249	0.5%	39	7,281	14.8%
   	Thurrock	13	14,625	11,365	2	52	0.4%	11	3,312	22.6%
   South East	Bracknell Forest	7	10,161	7,758	1	2	0.0%	6	2,405	23.7%
   	Brighton and Hove	10	15,011	12,703	1	155	1.0%	9	2,463	16.4%
   	Buckinghamshire	36	42,327	39,848	12	499	1.2%	24	2,978	7.0%
   	East Sussex	26	31,446	27,755	4	115	0.4%	22	3,806	12.1%
   	Hampshire	68	79,349	71,528	19	701	0.9%	49	8,522	10.7%
   	Isle of Wight	7	8,749	7,577	0	0	0.0%	7	1,172	13.4%
   	Kent	100	119,717	107,640	37	2,174	1.8%	63	14,251	11.9%
   	Medway	18	23,166	20,600	4	185	0.8%	14	2,751	11.9%
   	Milton Keynes	14	24,762	20,670	3	166	0.7%	11	4,258	17.2%
   	Oxfordshire	42	50,995	41,054	6	388	0.8%	36	10,329	20.3%
   	Portsmouth	11	11,920	10,232	2	22	0.2%	9	1,710	14.3%
   	Reading	10	10,888	8,865	1	62	0.6%	9	2,085	19.1%
   	Slough	15	17,340	14,493	2	63	0.4%	13	2,910	16.8%
   	Southampton	12	13,248	11,953	2	92	0.7%	10	1,387	10.5%
   	Surrey	57	70,641	64,134	13	829	1.2%	44	7,336	10.4%
   	West Berkshire	10	13,627	12,167	0	0	0.0%	10	1,460	10.7%
   	West Sussex	40	55,458	48,681	7	338	0.6%	33	7,115	12.8%
   	Windsor and Maidenhead	14	13,491	11,334	1	2	0.0%	13	2,159	16.0%
   	Wokingham	10	13,326	11,904	3	164	1.2%	7	1,586	11.9%
   South West	Bath and North East Somerset	14	14,988	13,330	6	583	3.9%	8	2,241	15.0%
   	Bournemouth, Christchurch and Poole	24	27,725	23,700	5	216	0.8%	19	4,241	15.3%
   	Bristol, City of	22	24,894	23,334	8	719	2.9%	14	2,279	9.2%
   	Cornwall	31	34,801	30,245	6	379	1.1%	25	4,935	14.2%
   	Devon	42	50,576	40,227	7	251	0.5%	35	10,600	21.0%
   	Dorset	29	29,404	25,428	2	58	0.2%	27	4,034	13.7%
   	Gloucestershire	40	46,626	40,331	7	458	1.0%	33	6,753	14.5%
   	Isles of Scilly	1	285	252	0	0	0.0%	1	33	11.6%
   	North Somerset	11	14,922	13,233	2	82	0.5%	9	1,771	11.9%
   	Plymouth	19	21,035	17,086	2	99	0.5%	17	4,048	19.2%
   	Somerset	38	36,392	30,910	6	70	0.2%	32	5,552	15.3%
   	South Gloucestershire	17	20,278	16,231	2	227	1.1%	15	4,274	21.1%
   	Swindon	14	17,956	13,736	2	203	1.1%	12	4,423	24.6%
   	Torbay	8	9,966	9,139	3	274	2.7%	5	1,101	11.0%
   	Wiltshire	29	36,419	30,014	8	282	0.8%	21	6,687	18.4%
   Inner London	Camden	10	12,096	10,349	1	37	0.3%	9	1,784	14.7%
   	City of London	z	z	z	z	z	z	z	z	z
   	Hackney	16	16,082	14,577	4	115	0.7%	12	1,620	10.1%
   	Hammersmith and Fulham	11	10,458	9,082	4	293	2.8%	7	1,669	16.0%
   	Haringey	12	16,777	15,232	5	197	1.2%	7	1,742	10.4%
   	Islington	10	10,207	8,369	0	0	0.0%	10	1,838	18.0%
   	Kensington and Chelsea	6	5,972	6,014	3	160	2.7%	3	118	2.0%
   	Lambeth	19	19,730	14,949	0	0	0.0%	19	4,781	24.2%
   	Lewisham	14	17,299	14,032	1	29	0.2%	13	3,296	19.1%
   	Newham	21	29,348	26,897	4	413	1.4%	17	2,864	9.8%
   	Southwark	20	21,941	18,645	4	417	1.9%	16	3,713	16.9%
   	Tower Hamlets	18	21,098	18,832	5	186	0.9%	13	2,452	11.6%
   	Wandsworth	11	15,135	13,191	2	232	1.5%	9	2,176	14.4%
   	Westminster	12	12,857	11,960	3	116	0.9%	9	1,013	7.9%
   Outer London	Barking and Dagenham	13	26,800	18,913	0	0	0.0%	13	7,887	29.4%
   	Barnet	28	32,526	28,647	6	491	1.5%	22	4,370	13.4%
   	Bexley	16	23,169	20,396	5	415	1.8%	11	3,188	13.8%
   	Brent	16	24,054	20,561	2	143	0.6%	14	3,636	15.1%
   	Bromley	19	27,910	23,794	5	172	0.6%	14	4,288	15.4%
   	Croydon	24	29,781	23,364	5	462	1.6%	19	6,879	23.1%
   	Ealing	16	24,645	21,778	5	389	1.6%	11	3,256	13.2%
   	Enfield	22	30,288	24,487	2	154	0.5%	20	5,955	19.7%
   	Greenwich	17	21,429	17,370	4	211	1.0%	13	4,270	19.9%
   	Harrow	13	17,007	15,692	2	63	0.4%	11	1,378	8.1%
   	Havering	18	19,152	16,373	5	408	2.1%	13	3,187	16.6%
   	Hillingdon	22	25,710	21,662	4	357	1.4%	18	4,405	17.1%
   	Hounslow	20	23,672	19,846	4	161	0.7%	16	3,987	16.8%
   	Kingston upon Thames	11	12,891	11,874	2	71	0.6%	9	1,088	8.4%
   	Merton	9	11,284	9,897	2	15	0.1%	7	1,402	12.4%
   	Redbridge	19	30,316	28,171	3	66	0.2%	16	2,211	7.3%
   	Richmond upon Thames	11	12,688	10,868	2	176	1.4%	9	1,996	15.7%
   	Sutton	15	21,749	20,460	5	245	1.1%	10	1,534	7.1%
   	Waltham Forest	17	18,138	16,208	4	165	0.9%	13	2,095	11.6%

   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)