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:
     • 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 - national, regional, local authority ' for Secondary 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	30	34,789	28,533	4	13.3%	221	0.6%	26	86.7%	6,477	18.6%
   	Darlington	8	7,299	6,695	2	25.0%	56	0.8%	6	75.0%	660	9.0%
   	Gateshead	10	12,806	11,981	1	10.0%	34	0.3%	9	90.0%	859	6.7%
   	Hartlepool	5	6,802	5,853	0	0.0%	0	0.0%	5	100.0%	949	14.0%
   	Middlesbrough	8	10,515	8,838	0	0.0%	0	0.0%	8	100.0%	1,677	15.9%
   	Newcastle upon Tyne	17	21,392	17,886	7	41.2%	433	2.0%	10	58.8%	3,939	18.4%
   	North Tyneside	16	15,693	13,925	4	25.0%	217	1.4%	12	75.0%	1,985	12.6%
   	Northumberland	30	26,172	21,915	4	13.3%	89	0.3%	26	86.7%	4,346	16.6%
   	Redcar and Cleveland	10	9,472	8,231	1	10.0%	3	0.0%	9	90.0%	1,244	13.1%
   	South Tyneside	8	9,874	9,040	2	25.0%	74	0.7%	6	75.0%	908	9.2%
   	Stockton-on-Tees	13	13,463	12,092	2	15.4%	64	0.5%	11	84.6%	1,435	10.7%
   	Sunderland	18	18,968	16,510	4	22.2%	374	2.0%	14	77.8%	2,832	14.9%
   North West	Blackburn with Darwen	12	13,122	11,939	3	25.0%	104	0.8%	9	75.0%	1,287	9.8%
   	Blackpool	8	9,022	7,340	0	0.0%	0	0.0%	8	100.0%	1,682	18.6%
   	Bolton	20	23,959	21,310	3	15.0%	73	0.3%	17	85.0%	2,722	11.4%
   	Bury	13	11,758	11,288	6	46.2%	247	2.1%	7	53.8%	717	6.1%
   	Cheshire East	23	26,798	24,487	10	43.5%	439	1.6%	13	56.5%	2,750	10.3%
   	Cheshire West and Chester	20	23,717	21,300	8	40.0%	355	1.5%	12	60.0%	2,772	11.7%
   	Cumbria	39	37,299	30,876	7	17.9%	492	1.3%	32	82.1%	6,915	18.5%
   	Halton	8	9,871	8,190	1	12.5%	1	0.0%	7	87.5%	1,682	17.0%
   	Knowsley	6	6,659	5,696	1	16.7%	6	0.1%	5	83.3%	969	14.6%
   	Lancashire	82	78,893	71,227	20	24.4%	456	0.6%	62	75.6%	8,122	10.3%
   	Liverpool	32	35,507	32,216	5	15.6%	181	0.5%	27	84.4%	3,472	9.8%
   	Manchester	31	37,853	34,406	12	38.7%	350	0.9%	19	61.3%	3,797	10.0%
   	Oldham	13	19,370	17,951	3	23.1%	50	0.3%	10	76.9%	1,469	7.6%
   	Rochdale	13	15,330	13,995	2	15.4%	49	0.3%	11	84.6%	1,384	9.0%
   	Salford	15	13,652	12,621	4	26.7%	108	0.8%	11	73.3%	1,139	8.3%
   	Sefton	18	19,463	16,519	5	27.8%	169	0.9%	13	72.2%	3,113	16.0%
   	St. Helens	9	12,030	11,121	1	11.1%	66	0.5%	8	88.9%	975	8.1%
   	Stockport	14	17,275	15,875	3	21.4%	74	0.4%	11	78.6%	1,474	8.5%
   	Tameside	16	15,728	14,545	5	31.3%	73	0.5%	11	68.8%	1,256	8.0%
   	Trafford	19	21,065	19,352	6	31.6%	282	1.3%	13	68.4%	1,995	9.5%
   	Warrington	13	15,085	13,609	4	30.8%	117	0.8%	9	69.2%	1,593	10.6%
   	Wigan	19	21,247	19,380	2	10.5%	28	0.1%	17	89.5%	1,895	8.9%
   	Wirral	20	25,206	22,339	3	15.0%	33	0.1%	17	85.0%	2,900	11.5%
   Yorkshire and The Humber	Barnsley	11	14,690	13,197	0	0.0%	0	0.0%	11	100.0%	1,493	10.2%
   	Bradford	35	43,780	40,507	9	25.7%	392	0.9%	26	74.3%	3,665	8.4%
   	Calderdale	13	17,262	16,322	3	23.1%	125	0.7%	10	76.9%	1,065	6.2%
   	Doncaster	20	23,109	18,690	1	5.0%	59	0.3%	19	95.0%	4,478	19.4%
   	East Riding of Yorkshire	18	25,276	19,718	1	5.6%	106	0.4%	17	94.4%	5,664	22.4%
   	Kingston upon Hull, City of	13	16,620	16,085	4	30.8%	114	0.7%	9	69.2%	649	3.9%
   	Kirklees	27	29,520	28,034	7	25.9%	243	0.8%	20	74.1%	1,729	5.9%
   	Leeds	45	58,850	52,444	12	26.7%	687	1.2%	33	73.3%	7,093	12.1%
   	North East Lincolnshire	10	10,087	9,214	3	30.0%	158	1.6%	7	70.0%	1,031	10.2%
   	North Lincolnshire	14	11,888	10,245	1	7.1%	15	0.1%	13	92.9%	1,658	13.9%
   	North Yorkshire	43	44,623	37,019	9	20.9%	573	1.3%	34	79.1%	8,177	18.3%
   	Rotherham	16	21,426	18,963	2	12.5%	94	0.4%	14	87.5%	2,557	11.9%
   	Sheffield	30	37,095	34,645	8	26.7%	723	1.9%	22	73.3%	3,173	8.6%
   	Wakefield	18	23,640	20,709	2	11.1%	25	0.1%	16	88.9%	2,956	12.5%
   	York	9	11,779	11,156	2	22.2%	262	2.2%	7	77.8%	885	7.5%
   East Midlands	Derby	16	21,532	18,405	1	6.3%	70	0.3%	15	93.8%	3,197	14.8%
   	Derbyshire	45	49,576	45,390	9	20.0%	732	1.5%	36	80.0%	4,918	9.9%
   	Leicester	21	25,554	22,528	7	33.3%	126	0.5%	14	66.7%	3,152	12.3%
   	Leicestershire	44	47,444	43,150	17	38.6%	694	1.5%	27	61.4%	4,988	10.5%
   	Lincolnshire	54	54,733	49,122	11	20.4%	646	1.2%	43	79.6%	6,257	11.4%
   	North Northamptonshire	20	26,771	23,637	3	15.0%	149	0.6%	17	85.0%	3,283	12.3%
   	Nottingham	19	21,776	18,696	3	15.8%	175	0.8%	16	84.2%	3,255	14.9%
   	Nottinghamshire	45	58,434	52,926	10	22.2%	986	1.7%	35	77.8%	6,494	11.1%
   	Rutland	3	3,045	2,821	0	0.0%	0	0.0%	3	100.0%	224	7.4%
   	West Northamptonshire	22	34,027	30,021	3	13.6%	116	0.3%	19	86.4%	4,122	12.1%
   West Midlands	Birmingham	88	94,877	85,816	24	27.3%	483	0.5%	64	72.7%	9,544	10.1%
   	Coventry	22	25,534	24,217	7	31.8%	381	1.5%	15	68.2%	1,698	6.6%
   	Dudley	19	20,270	18,182	5	26.3%	151	0.7%	14	73.7%	2,239	11.0%
   	Herefordshire, County of	15	11,081	9,564	3	20.0%	39	0.4%	12	80.0%	1,556	14.0%
   	Sandwell	20	27,201	24,436	4	20.0%	108	0.4%	16	80.0%	2,873	10.6%
   	Shropshire	20	18,566	16,262	5	25.0%	37	0.2%	15	75.0%	2,341	12.6%
   	Solihull	15	19,402	18,105	6	40.0%	383	2.0%	9	60.0%	1,680	8.7%
   	Staffordshire	70	65,645	55,348	8	11.4%	236	0.4%	62	88.6%	10,533	16.0%
   	Stoke-on-Trent	14	15,904	14,870	3	21.4%	73	0.5%	11	78.6%	1,107	7.0%
   	Telford and Wrekin	13	14,142	13,340	4	30.8%	234	1.7%	9	69.2%	1,036	7.3%
   	Walsall	19	23,520	22,421	9	47.4%	545	2.3%	10	52.6%	1,644	7.0%
   	Warwickshire	37	42,478	38,564	8	21.6%	327	0.8%	29	78.4%	4,241	10.0%
   	Wolverhampton	20	23,318	20,495	3	15.0%	74	0.3%	17	85.0%	2,897	12.4%
   	Worcestershire	45	43,790	37,671	7	15.6%	150	0.3%	38	84.4%	6,269	14.3%
   East of England	Bedford	14	14,223	12,800	3	21.4%	345	2.4%	11	78.6%	1,768	12.4%
   	Cambridgeshire	34	41,753	35,675	5	14.7%	303	0.7%	29	85.3%	6,381	15.3%
   	Central Bedfordshire	27	25,249	22,053	6	22.2%	157	0.6%	21	77.8%	3,353	13.3%
   	Essex	81	105,030	93,147	21	25.9%	863	0.8%	60	74.1%	12,746	12.1%
   	Hertfordshire	82	103,616	91,580	17	20.7%	571	0.6%	65	79.3%	12,607	12.2%
   	Luton	13	17,335	15,708	2	15.4%	58	0.3%	11	84.6%	1,685	9.7%
   	Norfolk	53	57,762	48,827	16	30.2%	384	0.7%	37	69.8%	9,319	16.1%
   	Peterborough	14	20,049	18,102	2	14.3%	98	0.5%	12	85.7%	2,045	10.2%
   	Southend-on-Sea	12	15,523	14,546	5	41.7%	216	1.4%	7	58.3%	1,193	7.7%
   	Suffolk	46	49,288	42,350	6	13.0%	262	0.5%	40	87.0%	7,200	14.6%
   	Thurrock	13	15,069	11,763	1	7.7%	89	0.6%	12	92.3%	3,395	22.5%
   South East	Bracknell Forest	7	10,066	8,084	2	28.6%	26	0.3%	5	71.4%	2,008	19.9%
   	Brighton and Hove	10	14,885	12,855	1	10.0%	157	1.1%	9	90.0%	2,187	14.7%
   	Buckinghamshire	37	42,928	40,890	18	48.6%	702	1.6%	19	51.4%	2,740	6.4%
   	East Sussex	26	31,546	28,225	4	15.4%	86	0.3%	22	84.6%	3,407	10.8%
   	Hampshire	69	80,809	72,815	22	31.9%	780	1.0%	47	68.1%	8,774	10.9%
   	Isle of Wight	7	8,749	7,582	0	0.0%	0	0.0%	7	100.0%	1,167	13.3%
   	Kent	100	122,342	110,284	26	26.0%	1,606	1.3%	74	74.0%	13,664	11.2%
   	Medway	19	24,066	21,273	4	21.1%	241	1.0%	15	78.9%	3,034	12.6%
   	Milton Keynes	14	24,506	21,554	5	35.7%	180	0.7%	9	64.3%	3,132	12.8%
   	Oxfordshire	41	50,835	41,933	9	22.0%	436	0.9%	32	78.0%	9,338	18.4%
   	Portsmouth	11	12,040	10,686	1	9.1%	52	0.4%	10	90.9%	1,406	11.7%
   	Reading	10	10,888	9,272	2	20.0%	156	1.4%	8	80.0%	1,772	16.3%
   	Slough	15	17,434	15,260	4	26.7%	90	0.5%	11	73.3%	2,264	13.0%
   	Southampton	12	13,248	12,476	5	41.7%	202	1.5%	7	58.3%	974	7.4%
   	Surrey	57	71,130	65,445	12	21.1%	842	1.2%	45	78.9%	6,527	9.2%
   	West Berkshire	10	13,696	12,385	1	10.0%	7	0.1%	9	90.0%	1,318	9.6%
   	West Sussex	40	55,787	49,583	9	22.5%	374	0.7%	31	77.5%	6,578	11.8%
   	Windsor and Maidenhead	14	13,474	11,501	0	0.0%	0	0.0%	14	100.0%	1,973	14.6%
   	Wokingham	10	13,498	12,533	4	40.0%	224	1.7%	6	60.0%	1,189	8.8%
   South West	Bath and North East Somerset	14	15,225	13,464	6	42.9%	451	3.0%	8	57.1%	2,212	14.5%
   	Bournemouth, Christchurch and Poole	25	28,712	24,282	7	28.0%	187	0.7%	18	72.0%	4,617	16.1%
   	Bristol, City of	22	25,085	24,146	9	40.9%	807	3.2%	13	59.1%	1,746	7.0%
   	Cornwall	31	34,943	30,619	7	22.6%	502	1.4%	24	77.4%	4,826	13.8%
   	Devon	42	50,426	40,422	7	16.7%	291	0.6%	35	83.3%	10,295	20.4%
   	Dorset	29	29,380	25,521	3	10.3%	127	0.4%	26	89.7%	3,986	13.6%
   	Gloucestershire	41	47,938	41,321	6	14.6%	241	0.5%	35	85.4%	6,858	14.3%
   	Isles of Scilly	1	285	262	0	0.0%	0	0.0%	1	100.0%	23	8.1%
   	North Somerset	11	14,877	13,668	4	36.4%	214	1.4%	7	63.6%	1,423	9.6%
   	Plymouth	19	21,031	17,305	1	5.3%	106	0.5%	18	94.7%	3,832	18.2%
   	Somerset	38	36,427	31,199	7	18.4%	132	0.4%	31	81.6%	5,360	14.7%
   	South Gloucestershire	17	20,537	16,549	2	11.8%	171	0.8%	15	88.2%	4,159	20.3%
   	Swindon	14	18,176	14,118	3	21.4%	210	1.2%	11	78.6%	4,268	23.5%
   	Torbay	8	9,966	9,051	2	25.0%	165	1.7%	6	75.0%	1,080	10.8%
   	Wiltshire	29	36,794	30,377	8	27.6%	195	0.5%	21	72.4%	6,612	18.0%
   Inner London	Camden	10	12,096	10,507	2	20.0%	53	0.4%	8	80.0%	1,642	13.6%
   	City of London	z	z	z	z	z	z	z	z	z	z	z
   	Hackney	16	15,922	14,718	5	31.3%	103	0.6%	11	68.8%	1,307	8.2%
   	Hammersmith and Fulham	11	10,458	9,296	5	45.5%	324	3.1%	6	54.5%	1,486	14.2%
   	Haringey	12	16,897	15,599	4	33.3%	268	1.6%	8	66.7%	1,566	9.3%
   	Islington	10	10,207	8,500	1	10.0%	35	0.3%	9	90.0%	1,742	17.1%
   	Kensington and Chelsea	6	5,972	6,188	4	66.7%	318	5.3%	2	33.3%	102	1.7%
   	Lambeth	19	19,730	15,235	1	5.3%	28	0.1%	18	94.7%	4,523	22.9%
   	Lewisham	14	17,299	14,236	1	7.1%	58	0.3%	13	92.9%	3,121	18.0%
   	Newham	21	29,478	27,339	5	23.8%	460	1.6%	16	76.2%	2,599	8.8%
   	Southwark	20	21,941	19,122	6	30.0%	524	2.4%	14	70.0%	3,343	15.2%
   	Tower Hamlets	18	21,098	19,203	6	33.3%	464	2.2%	12	66.7%	2,359	11.2%
   	Wandsworth	11	15,600	13,333	1	9.1%	44	0.3%	10	90.9%	2,311	14.8%
   	Westminster	12	12,857	11,973	3	25.0%	199	1.5%	9	75.0%	1,083	8.4%
   Outer London	Barking and Dagenham	13	26,800	19,725	0	0.0%	0	0.0%	13	100.0%	7,075	26.4%
   	Barnet	28	32,880	29,778	7	25.0%	484	1.5%	21	75.0%	3,586	10.9%
   	Bexley	16	23,169	20,515	5	31.3%	526	2.3%	11	68.8%	3,180	13.7%
   	Brent	16	24,054	20,842	3	18.8%	111	0.5%	13	81.3%	3,323	13.8%
   	Bromley	19	27,926	24,266	5	26.3%	283	1.0%	14	73.7%	3,943	14.1%
   	Croydon	23	29,017	23,639	6	26.1%	407	1.4%	17	73.9%	5,785	19.9%
   	Ealing	17	26,138	22,400	4	23.5%	457	1.7%	13	76.5%	4,195	16.0%
   	Enfield	21	29,208	24,554	2	9.5%	135	0.5%	19	90.5%	4,789	16.4%
   	Greenwich	16	20,244	17,529	4	25.0%	253	1.2%	12	75.0%	2,968	14.7%
   	Harrow	13	17,070	16,159	3	23.1%	124	0.7%	10	76.9%	1,035	6.1%
   	Havering	18	19,152	16,643	5	27.8%	471	2.5%	13	72.2%	2,980	15.6%
   	Hillingdon	22	25,710	22,120	5	22.7%	419	1.6%	17	77.3%	4,009	15.6%
   	Hounslow	20	23,672	20,554	3	15.0%	207	0.9%	17	85.0%	3,325	14.0%
   	Kingston upon Thames	11	12,911	12,313	4	36.4%	113	0.9%	7	63.6%	711	5.5%
   	Merton	9	11,392	10,279	1	11.1%	12	0.1%	8	88.9%	1,125	9.9%
   	Redbridge	19	30,534	28,503	3	15.8%	145	0.5%	16	84.2%	2,176	7.1%
   	Richmond upon Thames	11	12,810	11,296	2	18.2%	94	0.7%	9	81.8%	1,608	12.6%
   	Sutton	15	21,749	20,950	6	40.0%	381	1.8%	9	60.0%	1,180	5.4%
   	Waltham Forest	17	18,288	16,505	4	23.5%	120	0.7%	13	76.5%	1,903	10.4%

   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)