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 Borough

4. Step 4

   • Time period: 2018/19

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 Borough and 146 other locations for 2018/19

   		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
   Outer London	Barking and Dagenham	13	24,594	16,938	0	0	0.0%	13	7,656	31.1%
   	Barnet	27	31,000	26,388	6	212	0.7%	21	4,824	15.6%
   Yorkshire and the Humber (E12000003)	Barnsley	10	13,520	12,097	0	0	0.0%	10	1,423	10.5%
   South West (E12000009)	Bath and North East Somerset	15	14,998	13,092	6	432	2.9%	9	2,338	15.6%
   East of England	Bedford Borough	14	14,407	11,293	1	41	0.3%	13	3,155	21.9%
   Outer London	Bexley	16	23,799	20,484	4	154	0.6%	12	3,469	14.6%
   West Midlands	Birmingham	87	89,021	81,593	26	890	1.0%	61	8,318	9.3%
   North West	Blackburn with Darwen	12	12,845	11,092	2	25	0.2%	10	1,778	13.8%
   	Blackpool	8	9,022	6,752	0	0	0.0%	8	2,270	25.2%
   	Bolton	19	21,667	19,418	7	157	0.7%	12	2,406	11.1%
   South West (E12000009)	Bournemouth Christchurch and Poole	24	28,447	22,907	0	0	0.0%	24	5,540	19.5%
   South East	Bracknell Forest	7	9,660	7,072	0	0	0.0%	7	2,588	26.8%
   Yorkshire and the Humber (E12000003)	Bradford	33	42,996	38,958	9	384	0.9%	24	4,422	10.3%
   Outer London	Brent	15	23,154	19,804	2	52	0.2%	13	3,402	14.7%
   South East	Brighton and Hove	10	14,773	12,431	2	40	0.3%	8	2,382	16.1%
   SOUTH WEST (E12000009)	Bristol, City of	22	24,618	21,774	4	275	1.1%	18	3,119	12.7%
   Outer London	Bromley	19	27,129	22,731	8	553	2.0%	11	4,951	18.2%
   South East	Buckinghamshire	37	41,204	37,887	8	402	1.0%	29	3,719	9.0%
   North West	Bury	13	11,758	11,163	6	185	1.6%	7	780	6.6%
   Yorkshire and the Humber (E12000003)	Calderdale	13	17,393	15,885	1	2	0.0%	12	1,510	8.7%
   East of England	Cambridgeshire	33	40,198	32,708	4	124	0.3%	29	7,614	18.9%
   Inner London	Camden	10	12,096	10,214	1	17	0.1%	9	1,899	15.7%
   East of England	Central Bedfordshire	28	24,886	21,142	5	131	0.5%	23	3,875	15.6%
   North West	Cheshire East	23	25,656	22,727	7	256	1.0%	16	3,185	12.4%
   	Cheshire West and Chester	20	23,964	20,135	5	122	0.5%	15	3,951	16.5%
   Inner London	City of London	z	z	z	z	z	z	z	z	z
   South West (E12000009)	Cornwall	31	35,022	29,066	3	234	0.7%	28	6,190	17.7%
   West Midlands	Coventry	22	24,557	21,905	5	106	0.4%	17	2,758	11.2%
   Outer London	Croydon	24	29,160	22,685	4	206	0.7%	20	6,681	22.9%
   North West	Cumbria	39	37,440	29,503	4	218	0.6%	35	8,155	21.8%
   North East	Darlington	8	7,217	6,547	3	104	1.4%	5	774	10.7%
   East Midlands	Derby	16	20,519	16,941	4	162	0.8%	12	3,740	18.2%
   	Derbyshire	45	49,887	42,632	8	410	0.8%	37	7,665	15.4%
   South West (E12000009)	Devon	42	50,349	39,101	1	92	0.2%	41	11,340	22.5%
   Yorkshire and the Humber (E12000003)	Doncaster	19	22,981	17,519	0	0	0.0%	19	5,462	23.8%
   South West (E12000009)	Dorset	29	29,691	24,857	3	30	0.1%	26	4,864	16.4%
   West Midlands	Dudley	19	19,762	17,660	4	68	0.3%	15	2,170	11.0%
   North East	Durham	31	35,435	27,071	2	99	0.3%	29	8,463	23.9%
   Outer London	Ealing	16	24,541	20,047	2	93	0.4%	14	4,587	18.7%
   Yorkshire and the Humber (E12000003)	East Riding of Yorkshire	18	25,531	19,078	0	0	0.0%	18	6,453	25.3%
   South East	East Sussex	28	32,092	26,605	2	82	0.3%	26	5,569	17.4%
   Outer London	Enfield	21	29,368	23,814	1	63	0.2%	20	5,617	19.1%
   East of England	Essex	78	98,102	86,694	13	399	0.4%	65	11,807	12.0%
   North East	Gateshead	10	13,006	11,358	2	161	1.2%	8	1,809	13.9%
   South West (E12000009)	Gloucestershire	40	44,329	38,435	9	582	1.3%	31	6,476	14.6%
   Outer London	Greenwich	16	19,628	16,008	3	99	0.5%	13	3,719	18.9%
   Inner London	Hackney	16	16,083	13,875	0	0	0.0%	16	2,208	13.7%
   North West	Halton	8	10,429	8,215	2	55	0.5%	6	2,269	21.8%
   Inner London	Hammersmith and Fulham	11	10,235	8,544	5	268	2.6%	6	1,959	19.1%
   South East	Hampshire	68	79,641	68,726	10	281	0.4%	58	11,196	14.1%
   Inner London	Haringey	12	16,464	14,299	4	175	1.1%	8	2,340	14.2%
   Outer London	Harrow	13	17,145	14,449	1	20	0.1%	12	2,716	15.8%
   North East	Hartlepool	5	6,435	5,540	0	0	0.0%	5	895	13.9%
   Outer London	Havering	18	18,702	15,883	4	230	1.2%	14	3,049	16.3%
   West Midlands	Herefordshire	15	10,679	9,406	5	182	1.7%	10	1,455	13.6%
   East of England	Hertfordshire	82	99,194	84,439	12	512	0.5%	70	15,267	15.4%
   Outer London	Hillingdon	22	25,200	20,453	3	49	0.2%	19	4,796	19.0%
   	Hounslow	20	23,560	18,402	1	50	0.2%	19	5,208	22.1%
   South East	Isle of Wight	8	9,368	7,528	1	80	0.9%	7	1,920	20.5%
   South West (E12000009)	Isles Of Scilly	1	285	236	0	0	0.0%	1	49	17.2%
   Inner London	Islington	10	9,967	8,460	1	15	0.2%	9	1,522	15.3%
   	Kensington and Chelsea	6	6,029	5,672	2	21	0.3%	4	378	6.3%
   South East	Kent	98	114,496	101,398	24	1,460	1.3%	74	14,558	12.7%
   YORKSHIRE AND THE HUMBER (E12000003)	Kingston Upon Hull, City of	13	16,000	14,294	2	80	0.5%	11	1,786	11.2%
   Outer London	Kingston upon Thames	11	12,691	10,839	2	30	0.2%	9	1,882	14.8%
   Yorkshire and the Humber (E12000003)	Kirklees	28	30,315	27,269	5	39	0.1%	23	3,085	10.2%
   North West	Knowsley	6	7,081	5,387	0	0	0.0%	6	1,694	23.9%
   Inner London	Lambeth	18	18,755	14,166	1	11	0.1%	17	4,600	24.5%
   North West	Lancashire	83	78,349	67,585	16	403	0.5%	67	11,167	14.3%
   Yorkshire and the Humber (E12000003)	Leeds	43	54,728	47,071	11	996	1.8%	32	8,653	15.8%
   East Midlands	Leicester	19	22,777	20,392	5	225	1.0%	14	2,610	11.5%
   	Leicestershire	47	48,138	41,445	13	557	1.2%	34	7,250	15.1%
   Inner London	Lewisham	14	17,649	14,200	2	62	0.4%	12	3,511	19.9%
   East Midlands	Lincolnshire	54	53,312	46,308	10	570	1.1%	44	7,574	14.2%
   North West	Liverpool	32	34,827	29,504	4	80	0.2%	28	5,403	15.5%
   East of England	Luton	13	16,795	14,259	1	3	0.0%	12	2,539	15.1%
   North West	Manchester	30	36,147	29,973	4	192	0.5%	26	6,366	17.6%
   South East	Medway	18	22,956	19,195	2	62	0.3%	16	3,823	16.7%
   Outer London	Merton	9	11,284	9,295	2	7	0.1%	7	1,996	17.7%
   North East	Middlesbrough	7	9,020	8,179	0	0	0.0%	7	841	9.3%
   South East	Milton Keynes	13	22,914	19,061	1	55	0.2%	12	3,908	17.1%
   North East	Newcastle upon Tyne	15	18,688	16,309	5	133	0.7%	10	2,512	13.4%
   Inner London	Newham	21	28,173	25,153	3	594	2.1%	18	3,614	12.8%
   East of England	Norfolk	53	56,680	45,535	5	482	0.9%	48	11,627	20.5%
   Yorkshire and the Humber (E12000003)	North East Lincolnshire	10	10,191	8,448	1	35	0.3%	9	1,778	17.4%
   	North Lincolnshire	15	11,993	9,702	0	0	0.0%	14	2,195	18.3%
   South West (E12000009)	North Somerset	11	14,941	12,585	1	57	0.4%	10	2,413	16.2%
   North East	North Tyneside	16	15,578	13,375	2	127	0.8%	14	2,330	15.0%
   Yorkshire and the Humber (E12000003)	North Yorkshire	43	44,640	36,037	9	397	0.9%	34	9,000	20.2%
   East Midlands	Northamptonshire	42	58,936	48,417	6	131	0.2%	36	10,650	18.1%
   North East	Northumberland	34	27,191	22,372	6	176	0.6%	28	4,995	18.4%
   East Midlands	Nottingham	17	19,847	16,821	2	18	0.1%	15	3,044	15.3%
   	Nottinghamshire	45	60,225	48,325	8	560	0.9%	37	12,460	20.7%
   North West	Oldham	13	18,326	16,590	3	187	1.0%	10	1,923	10.5%
   South East	Oxfordshire	40	49,031	39,168	5	283	0.6%	35	10,146	20.7%
   East of England	Peterborough	14	20,379	15,935	1	23	0.1%	13	4,467	21.9%
   South West (E12000009)	Plymouth	19	21,127	16,511	2	40	0.2%	17	4,656	22.0%
   South East	Portsmouth	11	11,240	9,329	1	33	0.3%	10	1,944	17.3%
   	Reading	10	10,432	7,733	1	140	1.3%	9	2,839	27.2%
   Outer London	Redbridge	19	30,412	26,840	5	186	0.6%	14	3,758	12.4%
   North East	Redcar and Cleveland	10	9,472	8,226	1	33	0.3%	9	1,279	13.5%
   Outer London	Richmond upon Thames	11	12,164	9,763	2	161	1.3%	9	2,562	21.1%
   North West	Rochdale	12	14,130	12,884	1	12	0.1%	11	1,258	8.9%
   Yorkshire and the Humber (E12000003)	Rotherham	16	20,936	18,153	1	35	0.2%	15	2,818	13.5%
   East Midlands	Rutland	3	2,865	2,591	0	0	0.0%	3	274	9.6%
   North West	Salford	15	12,960	11,523	4	150	1.2%	11	1,587	12.2%
   West Midlands	Sandwell	19	24,371	21,970	3	82	0.3%	16	2,483	10.2%
   North West	Sefton	18	19,395	15,870	1	98	0.5%	17	3,623	18.7%
   Yorkshire and the Humber (E12000003)	Sheffield	30	37,299	31,992	5	422	1.1%	25	5,729	15.4%
   West Midlands	Shropshire	20	18,426	15,952	4	25	0.1%	16	2,499	13.6%
   South East	Slough	15	17,001	12,987	2	150	0.9%	13	4,164	24.5%
   West Midlands	Solihull	15	19,532	17,504	4	204	1.0%	11	2,232	11.4%
   South West (E12000009)	Somerset	38	35,820	29,914	4	57	0.2%	34	5,963	16.6%
   	South Gloucestershire	17	20,704	15,762	1	8	0.0%	16	4,950	23.9%
   North East	South Tyneside	9	10,240	8,517	1	99	1.0%	8	1,822	17.8%
   South East	Southampton	12	12,768	10,867	1	70	0.5%	11	1,971	15.4%
   East of England	Southend-on-Sea	12	14,396	13,184	1	43	0.3%	11	1,255	8.7%
   Inner London	Southwark	19	20,542	17,083	4	347	1.7%	15	3,806	18.5%
   North West	St Helens	9	11,759	10,180	1	27	0.2%	8	1,606	13.7%
   West Midlands	Staffordshire	70	65,466	52,327	10	332	0.5%	60	13,471	20.6%
   North West	Stockport	14	17,791	14,654	1	87	0.5%	13	3,224	18.1%
   North East	Stockton-on-Tees	13	12,963	11,142	2	167	1.3%	11	1,988	15.3%
   West Midlands	Stoke-on-Trent	15	15,460	13,640	1	33	0.2%	14	1,853	12.0%
   East of England	Suffolk	46	49,030	41,183	3	160	0.3%	43	8,007	16.3%
   North East	Sunderland	18	18,763	15,870	5	100	0.5%	13	2,993	16.0%
   South East	Surrey	57	70,319	61,048	12	872	1.2%	45	10,143	14.4%
   Outer London	Sutton	15	21,216	19,284	4	38	0.2%	11	1,970	9.3%
   South West (E12000009)	Swindon	13	16,344	12,503	2	105	0.6%	11	3,946	24.1%
   North West	Tameside	16	15,139	13,412	4	71	0.5%	12	1,798	11.9%
   West Midlands	Telford and Wrekin	13	12,431	11,775	4	362	2.9%	9	1,018	8.2%
   East of England	Thurrock	11	12,174	10,330	2	59	0.5%	9	1,903	15.6%
   South West (E12000009)	Torbay	8	9,666	8,626	2	123	1.3%	6	1,163	12.0%
   Inner London	Tower Hamlets	19	21,656	17,740	2	22	0.1%	17	3,938	18.2%
   North West	Trafford	19	19,950	18,035	5	236	1.2%	14	2,151	10.8%
   Yorkshire and the Humber (E12000003)	Wakefield	18	23,234	19,662	1	95	0.4%	17	3,667	15.8%
   West Midlands	Walsall	19	22,396	20,906	5	268	1.2%	14	1,758	7.8%
   Outer London	Waltham Forest	17	18,105	15,822	3	70	0.4%	14	2,353	13.0%
   Inner London	Wandsworth	11	14,635	12,536	2	40	0.3%	9	2,139	14.6%
   North West	Warrington	13	15,179	12,886	1	50	0.3%	12	2,343	15.4%
   West Midlands	Warwickshire	36	40,746	35,432	7	252	0.6%	29	5,566	13.7%
   South East	West Berkshire	10	13,064	11,500	3	109	0.8%	7	1,673	12.8%
   	West Sussex	39	53,462	46,453	5	160	0.3%	34	7,169	13.4%
   Inner London	Westminster	12	12,113	11,338	4	319	2.6%	8	1,094	9.0%
   North West	Wigan	20	21,542	18,261	1	20	0.1%	19	3,301	15.3%
   South West (E12000009)	Wiltshire	30	36,025	28,857	5	308	0.9%	25	7,476	20.8%
   South East	Windsor and Maidenhead	14	12,960	10,668	1	0	0.0%	13	2,292	17.7%
   North West	Wirral	20	25,419	21,282	1	9	0.0%	19	4,146	16.3%
   South East	Wokingham	10	12,898	11,105	2	38	0.3%	8	1,831	14.2%
   West Midlands	Wolverhampton	20	21,349	18,206	2	66	0.3%	18	3,209	15.0%
   	Worcestershire	45	42,725	35,783	8	234	0.5%	37	7,176	16.8%
   Yorkshire and the Humber (E12000003)	York	9	11,410	10,492	2	53	0.5%	7	971	8.5%

   Footnotes

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