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 - places needed, spare places (place planning)

3. Step 3

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

4. Step 4

   • Time period: 2022/23 to 2028/29

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 - places needed, spare places (place planning)' for Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations between 2022/23 and 2028/29

   		2022/23	2023/24	2024/25	2025/26	2026/27	2027/28	2028/29
   North East	County Durham	148	214	169	178	94	69	20
   	Darlington	0	0	0	0	0	0	0
   	Gateshead	154	266	432	515	609	529	498
   	Hartlepool	0	0	0	0	0	0	0
   	Middlesbrough	0	0	0	0	0	0	0
   	Newcastle upon Tyne	525	555	500	381	233	97	115
   	North Tyneside	3	15	10	0	0	0	0
   	Northumberland	35	98	89	80	140	151	69
   	Redcar and Cleveland	44	79	79	99	76	45	28
   	South Tyneside	0	0	0	0	0	0	2
   	Stockton-on-Tees	6	3	11	10	0	0	0
   	Sunderland	19	61	44	48	55	59	7
   North West	Blackburn with Darwen	0	0	14	0	6	0	0
   	Blackpool	0	0	0	6	3	0	0
   	Bolton	0	0	0	39	1	25	0
   	Bury	186	296	343	336	323	246	135
   	Cheshire East	625	531	326	367	361	432	397
   	Cheshire West and Chester	447	721	779	822	801	703	595
   	Cumbria	221	247	235	205	174	158	132
   	Halton	0	0	0	0	0	0	0
   	Knowsley	44	65	34	1	0	0	15
   	Lancashire	305	444	613	639	646	687	605
   	Liverpool	120	251	302	302	387	457	457
   	Manchester	79	231	514	517	664	769	715
   	Oldham	0	0	0	0	0	0	0
   	Rochdale	117	258	361	393	427	494	505
   	Salford	34	0	0	4	16	0	3
   	Sefton	12	13	22	41	6	29	14
   	St. Helens	10	53	46	41	62	50	0
   	Stockport	25	63	55	28	58	83	76
   	Tameside	0	0	0	27	0	0	0
   	Trafford	163	452	627	822	1,001	1,065	931
   	Warrington	180	159	209	217	280	272	189
   	Wigan	25	178	295	435	579	566	426
   	Wirral	0	0	0	0	0	0	0
   Yorkshire and The Humber	Barnsley	145	155	116	82	78	40	26
   	Bradford	317	337	280	224	155	53	35
   	Calderdale	96	86	117	133	110	96	36
   	Doncaster	48	139	100	164	199	162	130
   	East Riding of Yorkshire	105	128	96	86	91	93	132
   	Kingston upon Hull, City of	23	99	76	37	0	0	0
   	Kirklees	117	102	108	120	144	83	28
   	Leeds	332	669	910	1,062	1,293	1,633	1,457
   	North East Lincolnshire	120	178	267	346	366	340	303
   	North Lincolnshire	22	43	82	72	82	63	42
   	North Yorkshire	187	295	265	269	218	250	191
   	Rotherham	127	138	173	198	188	150	100
   	Sheffield	742	529	583	557	715	806	889
   	Wakefield	8	49	82	124	113	110	103
   	York	128	74	35	45	71	59	30
   East Midlands	Derby	0	0	0	0	0	0	0
   	Derbyshire	171	151	105	73	44	46	60
   	Leicester	149	70	38	0	9	0	0
   	Leicestershire	739	863	1,258	1,803	1,993	1,901	1,668
   	Lincolnshire	444	609	623	631	602	582	493
   	North Northamptonshire	0	0	9	37	29	0	0
   	Nottingham	84	106	141	155	176	207	226
   	Nottinghamshire	906	1,170	1,359	1,488	1,502	1,633	1,507
   	Rutland	0	0	0	0	0	0	0
   	West Northamptonshire	43	128	213	135	97	248	207
   West Midlands	Birmingham	458	805	743	811	960	1,097	1,032
   	Coventry	497	828	999	1,217	1,334	1,315	1,199
   	Dudley	7	100	154	142	159	162	68
   	Herefordshire, County of	60	82	121	177	150	152	148
   	Sandwell	180	310	359	368	392	285	231
   	Shropshire	207	214	229	180	150	160	217
   	Solihull	106	54	60	27	52	96	129
   	Staffordshire	224	369	426	549	580	659	714
   	Stoke-on-Trent	70	95	168	244	406	341	329
   	Telford and Wrekin	71	237	390	510	479	391	321
   	Walsall	559	562	558	489	443	394	376
   	Warwickshire	532	598	561	784	981	1,068	1,071
   	Wolverhampton	141	239	149	148	269	135	32
   	Worcestershire	46	113	178	198	282	366	398
   East of England	Bedford	394	719	998	1,306	1,508	1,805	2,011
   	Cambridgeshire	386	535	588	675	896	1,003	1,016
   	Central Bedfordshire	34	90	180	233	347	416	541
   	Essex	292	356	568	592	616	479	597
   	Hertfordshire	385	504	605	696	673	478	399
   	Luton	11	9	6	4	4	2	2
   	Norfolk	427	620	707	744	888	1,012	982
   	Peterborough	35	65	60	29	3	0	0
   	Southend-on-Sea	0	18	64	134	55	0	54
   	Suffolk	180	225	281	378	389	327	264
   	Thurrock	168	115	0	0	0	0	0
   South East	Bracknell Forest	44	20	32	59	10	28	27
   	Brighton and Hove	22	23	70	70	64	38	48
   	Buckinghamshire	494	490	452	417	432	401	371
   	East Sussex	63	92	83	74	60	47	17
   	Hampshire	1,076	1,291	1,306	1,411	1,461	1,690	1,670
   	Isle of Wight	28	17	21	34	0	0	0
   	Kent	1,028	1,300	1,457	1,546	1,656	2,188	2,257
   	Medway	252	224	312	373	453	476	462
   	Milton Keynes	0	0	0	0	0	0	0
   	Oxfordshire	184	214	276	289	294	274	287
   	Portsmouth	74	114	134	161	203	251	261
   	Reading	123	149	261	421	547	689	845
   	Slough	0	0	0	0	0	0	0
   	Southampton	62	74	62	83	95	53	43
   	Surrey	761	1,514	1,913	2,451	2,658	2,878	2,768
   	West Berkshire	25	19	6	0	0	0	0
   	West Sussex	572	1,018	1,230	1,551	1,803	2,145	2,213
   	Windsor and Maidenhead	0	16	0	0	0	0	0
   	Wokingham	124	258	396	517	586	625	663
   South West	Bath and North East Somerset	251	226	215	211	200	158	147
   	Bournemouth, Christchurch and Poole	8	0	0	0	0	0	0
   	Bristol, City of	636	628	653	529	393	173	99
   	Cornwall	336	306	417	469	570	446	274
   	Devon	304	394	424	481	506	605	611
   	Dorset	84	72	64	56	56	55	56
   	Gloucestershire	15	14	72	169	284	373	160
   	Isles of Scilly	9	0	0	4	14	14	12
   	North Somerset	462	478	481	460	394	369	307
   	Plymouth	0	0	0	0	0	0	0
   	Somerset	117	58	58	53	33	21	6
   	South Gloucestershire	63	140	233	295	456	546	633
   	Swindon	44	19	9	34	21	5	4
   	Torbay	0	0	0	0	0	0	0
   	Wiltshire	205	211	300	348	376	440	420
   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	309	271	183	101	22	0	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	49	62	58	50	63	21	0
   Outer London	Barking and Dagenham	0	19	29	34	45	58	49
   	Barnet	0	0	0	0	0	0	0
   	Bexley	0	0	0	0	0	0	0
   	Brent	0	0	0	0	0	21	0
   	Bromley	0	0	0	0	0	0	0
   	Croydon	0	0	0	0	0	0	0
   	Ealing	306	352	176	161	114	107	87
   	Enfield	253	261	227	194	152	138	134
   	Greenwich	0	0	0	0	0	0	0
   	Harrow	78	112	107	126	153	117	53
   	Havering	2	23	46	74	179	402	516
   	Hillingdon	0	0	0	0	0	0	0
   	Hounslow	0	0	0	0	0	0	0
   	Kingston upon Thames	0	0	0	59	133	158	209
   	Merton	0	0	0	0	0	0	0
   	Redbridge	0	0	0	0	0	0	0
   	Richmond upon Thames	0	0	4	0	46	77	101
   	Sutton	54	75	146	272	335	269	158
   	Waltham Forest	0	0	0	0	0	0	0

   Footnotes

   1. Estimates reflect the position reported by local authorities as at May 2022, supplemented with DFE internal data on centrally funded programmes due to add or remove school places.
   2. Estimates are provided from 2022/23 to 2026/27 for primary (Reception to Year 6) and from 2022/23 to 2028/29 for secondary (Year 7 to Year 11).

   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)