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 place planning estimates

3. Step 3

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

4. Step 4

   • Time period: 2019/20 to 2025/26

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 'School place planning estimates' for Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 146 other locations between 2019/20 and 2025/26

   		2019/20	2020/21	2021/22	2022/23	2023/24	2024/25	2025/26
   Outer London	Barking and Dagenham	0	0	0	0	14	165	397
   	Barnet	0	0	0	0	0	0	0
   Yorkshire and the Humber (E12000003)	Barnsley	0	0	103	294	451	495	553
   South West (E12000009)	Bath and North East Somerset	183	347	466	615	595	688	832
   East of England	Bedford Borough	380	508	798	995	1,279	1,533	1,758
   Outer London	Bexley	0	0	0	0	0	0	0
   West Midlands	Birmingham	418	642	792	1,668	2,644	3,524	3,952
   North West	Blackburn with Darwen	0	0	0	0	16	9	14
   	Blackpool	0	0	14	4	26	22	55
   	Bolton	83	7	40	107	211	226	236
   South West (E12000009)	Bournemouth Christchurch and Poole	0	0	22	19	88	61	100
   South East	Bracknell Forest	0	0	0	0	0	0	0
   Yorkshire and the Humber (E12000003)	Bradford	195	55	124	244	317	206	142
   Outer London	Brent	9	39	128	267	530	860	1,100
   South East	Brighton and Hove	54	93	36	44	51	73	73
   SOUTH WEST (E12000009)	Bristol, City of	225	429	695	1,150	1,418	1,651	1,694
   Outer London	Bromley	0	0	0	0	0	0	0
   South East	Buckinghamshire	572	706	826	1,056	1,273	1,396	1,413
   North West	Bury	163	241	307	354	421	436	391
   Yorkshire and the Humber (E12000003)	Calderdale	0	0	0	0	0	0	0
   East of England	Cambridgeshire	229	633	941	1,490	2,118	2,488	2,566
   Inner London	Camden	0	0	0	0	0	0	0
   East of England	Central Bedfordshire	138	353	605	792	1,077	1,430	1,707
   North West	Cheshire East	575	807	1,194	1,538	1,874	1,905	1,876
   	Cheshire West and Chester	255	205	219	260	317	307	304
   Inner London	City of London	z	z	z	z	z	z	z
   South West (E12000009)	Cornwall	107	190	319	544	838	1,130	1,269
   West Midlands	Coventry	554	799	832	1,231	1,749	1,917	2,014
   Outer London	Croydon	0	0	12	12	0	0	0
   North West	Cumbria	80	106	141	159	176	130	111
   North East	Darlington	0	0	3	0	0	0	0
   East Midlands	Derby	0	0	0	0	67	71	48
   	Derbyshire	140	125	148	185	179	163	136
   South West (E12000009)	Devon	262	507	777	1,284	1,828	1,924	2,058
   Yorkshire and the Humber (E12000003)	Doncaster	56	82	85	90	159	129	88
   South West (E12000009)	Dorset	17	19	17	16	5	2	5
   West Midlands	Dudley	130	17	93	115	210	300	401
   North East	Durham	88	120	160	222	209	189	220
   Outer London	Ealing	54	90	119	130	183	138	111
   Yorkshire and the Humber (E12000003)	East Riding of Yorkshire	18	19	28	29	19	0	5
   South East	East Sussex	46	50	123	211	367	443	488
   Outer London	Enfield	122	180	225	298	368	231	255
   East of England	Essex	209	288	365	739	1,443	2,154	2,891
   North East	Gateshead	124	263	274	312	307	327	284
   South West (E12000009)	Gloucestershire	141	304	406	656	1,117	1,230	1,155
   Outer London	Greenwich	0	0	0	0	0	0	0
   Inner London	Hackney	0	0	0	0	0	0	0
   North West	Halton	0	0	0	6	8	51	65
   Inner London	Hammersmith and Fulham	0	0	0	0	153	0	0
   South East	Hampshire	651	957	1,309	1,609	1,720	2,016	2,367
   Inner London	Haringey	0	0	0	0	0	0	13
   Outer London	Harrow	85	261	501	729	882	933	913
   North East	Hartlepool	0	0	0	0	1	24	33
   Outer London	Havering	0	0	6	37	81	155	173
   West Midlands	Herefordshire	206	185	218	226	184	239	284
   East of England	Hertfordshire	597	876	1,086	1,651	1,911	2,324	2,619
   Outer London	Hillingdon	0	0	0	0	0	0	0
   	Hounslow	0	0	0	0	0	0	0
   South East	Isle of Wight	0	0	0	0	0	0	0
   South West (E12000009)	Isles Of Scilly	7	7	7	7	0	0	4
   Inner London	Islington	0	0	0	0	0	0	0
   	Kensington and Chelsea	24	31	35	52	39	14	3
   South East	Kent	951	1,057	1,046	1,363	2,055	2,525	2,868
   YORKSHIRE AND THE HUMBER (E12000003)	Kingston Upon Hull, City of	157	219	369	584	865	994	923
   Outer London	Kingston upon Thames	0	0	0	0	55	71	118
   Yorkshire and the Humber (E12000003)	Kirklees	87	89	171	254	283	307	316
   North West	Knowsley	0	0	0	0	0	0	0
   Inner London	Lambeth	0	0	0	0	0	0	0
   North West	Lancashire	86	191	251	364	451	454	362
   Yorkshire and the Humber (E12000003)	Leeds	573	1,032	1,814	2,520	3,218	3,665	3,586
   East Midlands	Leicester	300	541	724	638	1,067	1,766	2,104
   	Leicestershire	721	1,007	1,489	2,377	2,995	3,025	2,852
   Inner London	Lewisham	0	0	0	0	0	0	0
   East Midlands	Lincolnshire	517	675	896	1,207	1,477	1,553	1,688
   North West	Liverpool	50	51	97	195	361	442	442
   East of England	Luton	13	37	115	243	351	408	442
   North West	Manchester	0	0	0	0	26	302	464
   South East	Medway	0	0	0	0	0	0	0
   Outer London	Merton	0	0	0	0	0	0	0
   North East	Middlesbrough	0	15	39	192	158	280	333
   South East	Milton Keynes	0	0	0	159	530	999	1,311
   North East	Newcastle upon Tyne	129	216	375	654	778	929	1,024
   Inner London	Newham	8	55	51	214	361	435	411
   East of England	Norfolk	479	512	774	952	1,302	1,362	1,495
   Yorkshire and the Humber (E12000003)	North East Lincolnshire	0	0	34	125	194	249	278
   	North Lincolnshire	43	75	124	240	328	436	366
   South West (E12000009)	North Somerset	69	101	107	114	106	99	81
   North East	North Tyneside	6	15	10	39	47	76	125
   Yorkshire and the Humber (E12000003)	North Yorkshire	223	205	318	376	486	454	434
   East Midlands	Northamptonshire	0	22	135	404	547	870	991
   North East	Northumberland	2	3	5	5	1	0	0
   East Midlands	Nottingham	34	102	157	253	340	388	360
   	Nottinghamshire	517	681	889	1,150	1,363	1,327	1,239
   North West	Oldham	27	197	189	307	368	302	389
   South East	Oxfordshire	143	199	347	486	574	616	662
   East of England	Peterborough	0	0	0	0	10	39	61
   South West (E12000009)	Plymouth	0	0	0	0	0	0	0
   South East	Portsmouth	121	61	89	120	127	191	225
   	Reading	112	100	70	210	402	558	649
   Outer London	Redbridge	0	0	0	290	1,395	2,699	4,153
   North East	Redcar and Cleveland	2	7	7	35	111	228	280
   Outer London	Richmond upon Thames	0	74	193	307	425	526	599
   North West	Rochdale	63	197	544	928	1,256	1,527	1,829
   Yorkshire and the Humber (E12000003)	Rotherham	262	341	326	345	361	318	285
   East Midlands	Rutland	33	36	43	47	51	12	15
   North West	Salford	11	30	53	161	342	532	682
   West Midlands	Sandwell	104	258	459	753	1,087	1,304	1,330
   North West	Sefton	23	49	57	35	12	0	0
   Yorkshire and the Humber (E12000003)	Sheffield	378	579	624	757	807	914	808
   West Midlands	Shropshire	136	178	245	263	255	245	343
   South East	Slough	0	0	0	0	0	0	0
   West Midlands	Solihull	21	22	16	91	132	157	210
   South West (E12000009)	Somerset	46	47	93	159	197	203	241
   	South Gloucestershire	0	0	16	56	134	171	183
   North East	South Tyneside	0	0	0	0	0	0	0
   South East	Southampton	115	377	782	1,153	1,489	1,718	1,819
   East of England	Southend-on-Sea	0	31	42	207	367	431	437
   Inner London	Southwark	0	0	0	0	0	0	0
   North West	St Helens	46	81	313	224	186	107	127
   West Midlands	Staffordshire	213	204	229	316	354	413	447
   North West	Stockport	12	17	27	35	49	48	45
   North East	Stockton-on-Tees	0	0	30	171	251	374	400
   West Midlands	Stoke-on-Trent	160	19	19	157	206	196	233
   East of England	Suffolk	299	336	409	639	812	721	722
   North East	Sunderland	0	9	9	9	9	4	0
   South East	Surrey	765	965	1,708	2,878	3,876	4,670	5,179
   Outer London	Sutton	0	189	396	570	781	848	738
   South West (E12000009)	Swindon	91	111	126	127	96	74	91
   North West	Tameside	0	8	157	233	415	445	511
   West Midlands	Telford and Wrekin	225	314	449	635	782	869	944
   East of England	Thurrock	78	157	146	166	115	29	76
   South West (E12000009)	Torbay	6	33	74	114	186	206	231
   Inner London	Tower Hamlets	0	0	0	0	0	0	0
   North West	Trafford	375	339	517	689	876	914	871
   Yorkshire and the Humber (E12000003)	Wakefield	62	140	304	432	550	598	646
   West Midlands	Walsall	232	325	220	257	301	301	322
   Outer London	Waltham Forest	0	0	0	162	387	579	604
   Inner London	Wandsworth	0	0	0	0	0	0	0
   North West	Warrington	60	122	0	14	63	113	188
   West Midlands	Warwickshire	524	758	919	1,523	2,081	2,528	3,181
   South East	West Berkshire	72	86	130	235	268	296	258
   	West Sussex	392	689	1,187	2,003	2,688	2,947	3,243
   Inner London	Westminster	45	63	102	124	137	74	25
   North West	Wigan	38	146	305	508	806	811	721
   South West (E12000009)	Wiltshire	322	268	267	383	558	694	894
   South East	Windsor and Maidenhead	3	0	0	0	1	13	22
   North West	Wirral	0	0	0	0	0	0	0
   South East	Wokingham	1	2	70	201	381	551	615
   West Midlands	Wolverhampton	27	65	50	316	632	857	1,081
   	Worcestershire	111	152	255	369	577	791	929
   Yorkshire and the Humber (E12000003)	York	144	220	277	309	344	296	282

   Footnotes

   1. z - Indicates data is not applicable.
   2. A description of how these estimates have been derived and how to interpret them is provided in the technical guidance accompanying the 'School capacity: Academic year 2018/19' release.

   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)