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: Estimates of future school place demand (place planning)

3. Step 3

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

4. Step 4

   • Time period: 2021/22 to 2027/28

5. Step 5

   • Indicators:
     • Estimated number of places needed: Additional need only
   • National curriculum year group:
     • Secondary total

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Academic year 2022/23

   Estimated number of places needed: Additional need only for 'Estimates of future school place demand (place planning)' for Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2021/22 and 2027/28

   		2021/22	2022/23	2023/24	2024/25	2025/26	2026/27	2027/28
   North East	County Durham	147	201	228	269	312	230	218
   	Darlington	1	0	10	0	0	0	0
   	Gateshead	52	210	334	484	530	591	501
   	Hartlepool	0	0	0	0	0	0	0
   	Middlesbrough	0	0	0	0	0	0	0
   	Newcastle upon Tyne	376	496	537	487	348	210	94
   	North Tyneside	0	0	0	0	0	0	0
   	Northumberland	186	225	281	158	127	149	89
   	Redcar and Cleveland	15	108	140	135	133	103	59
   	South Tyneside	141	0	2	25	25	38	58
   	Stockton-on-Tees	0	15	28	42	26	12	1
   	Sunderland	25	51	75	51	51	51	25
   North West	Blackburn with Darwen	0	0	0	0	0	0	0
   	Blackpool	0	0	3	4	25	16	20
   	Bolton	0	0	0	0	0	0	0
   	Bury	123	163	227	203	174	160	119
   	Cheshire East	428	794	484	571	651	723	761
   	Cheshire West and Chester	318	329	483	479	501	438	326
   	Cumbria	169	218	248	226	201	196	159
   	Halton	0	0	0	0	0	0	0
   	Knowsley	38	64	82	91	69	83	58
   	Lancashire	501	797	1,097	1,188	1,206	1,131	1,022
   	Liverpool	108	262	574	772	811	965	992
   	Manchester	0	0	0	0	0	0	0
   	Oldham	422	464	529	242	130	0	0
   	Rochdale	42	183	368	408	370	520	653
   	Salford	77	51	127	201	242	208	222
   	Sefton	11	14	29	0	41	35	90
   	St. Helens	23	35	144	139	174	169	146
   	Stockport	32	83	119	131	143	171	166
   	Tameside	66	98	192	243	297	199	167
   	Trafford	16	21	86	89	91	91	71
   	Warrington	95	1	6	12	13	39	34
   	Wigan	23	228	447	576	703	754	568
   	Wirral	0	0	0	0	0	0	0
   Yorkshire and The Humber	Barnsley	128	197	224	180	167	195	173
   	Bradford	158	186	201	157	116	37	0
   	Calderdale	54	127	257	357	540	371	288
   	Doncaster	18	51	53	55	53	46	11
   	East Riding of Yorkshire	145	156	176	154	151	139	138
   	Kingston upon Hull, City of	180	45	142	170	165	105	63
   	Kirklees	175	209	224	283	303	275	154
   	Leeds	376	647	1,119	1,958	2,514	2,409	2,310
   	North East Lincolnshire	54	127	94	279	235	356	229
   	North Lincolnshire	11	30	45	61	70	54	46
   	North Yorkshire	211	236	301	246	250	208	204
   	Rotherham	140	134	169	156	126	94	84
   	Sheffield	677	764	967	1,047	1,094	1,181	1,290
   	Wakefield	0	22	56	91	102	90	115
   	York	145	77	87	97	99	54	58
   East Midlands	Derby	0	0	0	0	0	0	0
   	Derbyshire	154	118	109	104	103	94	89
   	Leicester	356	329	220	259	326	347	319
   	Leicestershire	429	1,038	1,664	2,223	2,510	2,478	2,342
   	Lincolnshire	417	498	684	641	632	590	551
   	North Northamptonshire	0	0	53	74	70	30	0
   	Nottingham	4	32	53	83	123	172	178
   	Nottinghamshire	903	1,110	1,076	1,326	1,507	1,416	1,395
   	Rutland	74	6	8	15	12	0	0
   	West Northamptonshire	47	127	129	64	74	192	211
   West Midlands	Birmingham	218	552	723	588	399	462	410
   	Coventry	1,443	1,324	1,779	1,913	1,982	1,936	2,002
   	Dudley	12	0	47	35	62	45	124
   	Herefordshire, County of	245	233	320	420	481	432	392
   	Sandwell	210	426	596	680	727	763	670
   	Shropshire	197	200	245	238	173	202	278
   	Solihull	9	0	0	0	0	0	0
   	Staffordshire	248	295	400	463	579	663	768
   	Stoke-on-Trent	0	24	73	115	182	345	317
   	Telford and Wrekin	100	186	277	349	378	315	215
   	Walsall	82	161	184	204	161	253	274
   	Warwickshire	527	973	1,075	1,612	2,195	2,704	2,900
   	Wolverhampton	25	139	154	183	302	297	170
   	Worcestershire	173	271	456	659	754	874	1,068
   East of England	Bedford	562	800	1,155	1,466	1,917	2,081	2,298
   	Cambridgeshire	366	760	1,059	1,214	1,414	1,427	1,486
   	Central Bedfordshire	321	536	738	679	549	441	340
   	Essex	255	367	656	771	787	932	1,144
   	Hertfordshire	746	825	870	1,019	1,197	1,369	1,472
   	Luton	9	12	10	11	11	8	8
   	Norfolk	415	602	794	803	881	942	836
   	Peterborough	71	63	63	37	26	8	4
   	Southend-on-Sea	110	110	110	138	140	49	91
   	Suffolk	144	174	197	259	304	273	249
   	Thurrock	168	178	77	0	0	0	0
   South East	Bracknell Forest	17	12	0	20	0	18	37
   	Brighton and Hove	58	89	89	110	99	70	40
   	Buckinghamshire	193	212	235	231	156	148	87
   	East Sussex	96	71	88	82	58	54	54
   	Hampshire	704	808	741	737	584	722	853
   	Isle of Wight	0	4	0	0	2	0	0
   	Kent	1,054	1,328	1,602	1,575	1,506	1,443	1,554
   	Medway	183	164	323	436	446	448	389
   	Milton Keynes	0	0	0	50	150	418	371
   	Oxfordshire	210	204	259	220	207	239	276
   	Portsmouth	41	46	56	75	87	95	89
   	Reading	165	280	390	450	510	575	570
   	Slough	0	0	0	0	0	0	0
   	Southampton	155	263	232	342	485	515	380
   	Surrey	674	1,268	2,529	3,081	3,755	4,303	4,498
   	West Berkshire	100	128	126	108	64	42	40
   	West Sussex	493	785	1,334	1,764	2,138	2,555	2,910
   	Windsor and Maidenhead	2	25	19	0	0	0	1
   	Wokingham	23	88	192	298	382	391	371
   South West	Bath and North East Somerset	287	364	389	388	364	365	304
   	Bournemouth, Christchurch and Poole	5	32	32	39	42	40	12
   	Bristol, City of	720	1,028	1,224	1,367	1,442	1,450	1,408
   	Cornwall	332	385	579	690	804	883	728
   	Devon	310	512	795	985	1,143	1,298	1,359
   	Dorset	11	14	9	5	2	2	1
   	Gloucestershire	0	0	30	30	32	32	37
   	Isles of Scilly	7	7	0	0	3	11	10
   	North Somerset	152	202	189	156	116	79	33
   	Plymouth	0	0	0	0	0	0	0
   	Somerset	91	43	36	24	18	18	24
   	South Gloucestershire	0	11	69	134	166	224	238
   	Swindon	32	47	29	7	23	0	0
   	Torbay	47	44	69	37	26	2	0
   	Wiltshire	259	288	313	345	456	515	635
   Inner London	Camden	0	0	0	0	0	0	0
   	City of London	z	z	z	z	z	z	z
   	Hackney	0	0	0	0	0	0	0
   	Hammersmith and Fulham	0	0	0	0	0	0	0
   	Haringey	0	0	0	0	0	0	0
   	Islington	0	0	0	0	0	0	0
   	Kensington and Chelsea	90	124	113	49	23	23	0
   	Lambeth	0	0	0	0	0	0	0
   	Lewisham	0	0	0	0	0	0	0
   	Newham	0	0	0	0	0	0	0
   	Southwark	0	0	0	0	0	0	0
   	Tower Hamlets	0	0	0	0	0	0	0
   	Wandsworth	0	0	0	0	0	0	0
   	Westminster	0	71	133	186	220	168	115
   Outer London	Barking and Dagenham	0	0	0	0	0	0	0
   	Barnet	0	0	0	0	0	0	0
   	Bexley	0	0	0	0	0	0	0
   	Brent	17	31	56	59	67	48	30
   	Bromley	0	0	0	0	0	0	0
   	Croydon	0	0	40	0	0	0	0
   	Ealing	363	448	533	548	535	472	397
   	Enfield	5	14	22	0	0	0	0
   	Greenwich	0	0	0	0	0	0	0
   	Harrow	61	195	240	275	294	275	248
   	Havering	0	0	11	17	14	28	58
   	Hillingdon	0	0	0	0	0	0	0
   	Hounslow	0	0	0	0	0	0	0
   	Kingston upon Thames	0	35	81	130	276	422	532
   	Merton	0	0	0	0	0	0	0
   	Redbridge	0	0	0	0	0	0	0
   	Richmond upon Thames	41	90	132	185	229	259	280
   	Sutton	36	4	0	0	12	0	29
   	Waltham Forest	0	0	0	0	0	0	0

   Footnotes

   1. A description of how these estimates have been derived and how to interpret them is provided in the school place planning estimates technical guidance accompanying this release (see supporting files under 'Explore data and files’).
   2. Estimates reflect the position reported by local authorities as at May 2021 in the 2021 School Capacity Survey, supplemented with data from administrative sources on centrally funded programmes.

   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)