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 2023/24

5. Step 5

   • Indicators:
     • Estimated number of places needed: Additional need only
   • National curriculum year group:
     • Primary 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 Primary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 146 other locations between 2019/20 and 2023/24

   		2019/20	2020/21	2021/22	2022/23	2023/24
   Outer London	Barking and Dagenham	514	529	418	501	723
   	Barnet	40	72	42	37	69
   Yorkshire and the Humber (E12000003)	Barnsley	39	81	114	134	92
   South West (E12000009)	Bath and North East Somerset	31	66	84	107	165
   East of England	Bedford Borough	27	60	163	283	444
   Outer London	Bexley	3	1	4	8	18
   West Midlands	Birmingham	863	1,210	1,578	1,888	2,491
   North West	Blackburn with Darwen	76	78	135	126	99
   	Blackpool	0	0	0	0	0
   	Bolton	385	441	556	717	698
   South West (E12000009)	Bournemouth Christchurch and Poole	184	153	156	83	33
   South East	Bracknell Forest	0	0	0	0	0
   Yorkshire and the Humber (E12000003)	Bradford	188	80	33	24	50
   Outer London	Brent	4	16	96	320	584
   South East	Brighton and Hove	2	1	2	2	2
   SOUTH WEST (E12000009)	Bristol, City of	12	40	29	23	17
   Outer London	Bromley	135	118	82	42	31
   South East	Buckinghamshire	141	254	235	197	122
   North West	Bury	115	105	93	81	39
   Yorkshire and the Humber (E12000003)	Calderdale	80	67	63	57	4
   East of England	Cambridgeshire	107	96	168	279	565
   Inner London	Camden	0	0	0	0	0
   East of England	Central Bedfordshire	101	157	225	236	383
   North West	Cheshire East	173	194	288	293	253
   	Cheshire West and Chester	121	445	588	719	735
   Inner London	City of London	31	31	30	30	0
   South West (E12000009)	Cornwall	318	444	615	647	630
   West Midlands	Coventry	73	127	159	219	260
   Outer London	Croydon	14	54	53	120	90
   North West	Cumbria	100	82	23	36	53
   North East	Darlington	0	0	0	0	0
   East Midlands	Derby	55	66	64	114	117
   	Derbyshire	652	639	693	578	536
   South West (E12000009)	Devon	446	646	882	989	853
   Yorkshire and the Humber (E12000003)	Doncaster	1	20	21	2	3
   South West (E12000009)	Dorset	100	120	89	84	29
   West Midlands	Dudley	47	116	137	180	112
   North East	Durham	114	142	178	203	257
   Outer London	Ealing	0	0	0	0	0
   Yorkshire and the Humber (E12000003)	East Riding of Yorkshire	91	112	115	130	58
   South East	East Sussex	182	118	142	157	63
   Outer London	Enfield	143	172	236	205	241
   East of England	Essex	684	862	1,223	1,616	1,935
   North East	Gateshead	0	0	10	4	3
   South West (E12000009)	Gloucestershire	248	372	501	948	1,422
   Outer London	Greenwich	143	268	418	575	802
   Inner London	Hackney	0	0	2	2	6
   North West	Halton	0	0	0	0	0
   Inner London	Hammersmith and Fulham	0	0	0	0	0
   South East	Hampshire	655	967	1,442	1,663	1,882
   Inner London	Haringey	0	0	4	0	0
   Outer London	Harrow	128	191	240	314	338
   North East	Hartlepool	4	10	13	5	0
   Outer London	Havering	17	15	56	241	484
   West Midlands	Herefordshire	145	150	129	123	124
   East of England	Hertfordshire	623	950	1,123	1,202	1,343
   Outer London	Hillingdon	12	51	51	80	132
   	Hounslow	0	0	23	105	248
   South East	Isle of Wight	40	70	62	72	57
   South West (E12000009)	Isles Of Scilly	9	9	9	9	9
   Inner London	Islington	0	0	0	0	0
   	Kensington and Chelsea	0	0	0	0	0
   South East	Kent	1,038	1,015	1,220	1,304	1,154
   YORKSHIRE AND THE HUMBER (E12000003)	Kingston Upon Hull, City of	16	18	25	17	0
   Outer London	Kingston upon Thames	149	75	209	183	318
   Yorkshire and the Humber (E12000003)	Kirklees	144	147	153	64	90
   North West	Knowsley	29	35	34	32	5
   Inner London	Lambeth	56	24	16	20	25
   North West	Lancashire	731	1,153	1,522	1,698	1,982
   Yorkshire and the Humber (E12000003)	Leeds	1,249	1,691	2,081	2,398	2,179
   East Midlands	Leicester	116	232	360	443	579
   	Leicestershire	530	827	1,195	1,715	2,185
   Inner London	Lewisham	0	0	0	0	0
   East Midlands	Lincolnshire	355	462	429	360	326
   North West	Liverpool	491	801	990	1,108	1,213
   East of England	Luton	0	0	9	9	1
   North West	Manchester	2,514	2,924	2,870	3,137	3,693
   South East	Medway	64	128	144	150	161
   Outer London	Merton	40	30	4	1	0
   North East	Middlesbrough	24	35	58	9	44
   South East	Milton Keynes	90	133	112	142	211
   North East	Newcastle upon Tyne	19	51	93	105	125
   Inner London	Newham	0	8	155	188	196
   East of England	Norfolk	131	181	242	242	228
   Yorkshire and the Humber (E12000003)	North East Lincolnshire	132	105	86	59	36
   	North Lincolnshire	97	105	110	90	59
   South West (E12000009)	North Somerset	95	85	30	43	97
   North East	North Tyneside	19	21	3	7	3
   Yorkshire and the Humber (E12000003)	North Yorkshire	289	295	271	268	238
   East Midlands	Northamptonshire	58	120	219	468	699
   North East	Northumberland	83	99	85	75	60
   East Midlands	Nottingham	1	6	7	6	6
   	Nottinghamshire	651	567	646	648	597
   North West	Oldham	167	250	397	458	526
   South East	Oxfordshire	66	135	240	309	456
   East of England	Peterborough	137	284	444	590	779
   South West (E12000009)	Plymouth	31	48	40	52	81
   South East	Portsmouth	42	67	108	110	116
   	Reading	0	0	0	0	0
   Outer London	Redbridge	38	5	23	177	994
   North East	Redcar and Cleveland	0	0	7	12	19
   Outer London	Richmond upon Thames	35	91	58	59	82
   North West	Rochdale	217	421	561	567	579
   Yorkshire and the Humber (E12000003)	Rotherham	0	0	13	28	41
   East Midlands	Rutland	0	0	0	0	0
   North West	Salford	24	152	238	263	277
   West Midlands	Sandwell	280	349	477	386	284
   North West	Sefton	33	50	57	14	14
   Yorkshire and the Humber (E12000003)	Sheffield	366	528	572	563	560
   West Midlands	Shropshire	41	56	40	69	79
   South East	Slough	0	0	0	0	0
   West Midlands	Solihull	231	125	159	125	93
   South West (E12000009)	Somerset	119	148	61	63	54
   	South Gloucestershire	38	76	80	105	82
   North East	South Tyneside	46	60	81	64	114
   South East	Southampton	0	0	0	0	0
   East of England	Southend-on-Sea	0	0	9	2	0
   Inner London	Southwark	0	0	0	0	0
   North West	St Helens	83	64	117	146	171
   West Midlands	Staffordshire	268	309	280	365	435
   North West	Stockport	49	60	76	72	69
   North East	Stockton-on-Tees	7	1	1	0	0
   West Midlands	Stoke-on-Trent	0	0	0	0	0
   East of England	Suffolk	57	84	150	175	170
   North East	Sunderland	19	25	17	33	24
   South East	Surrey	2,344	2,584	2,446	2,393	2,183
   Outer London	Sutton	144	146	63	73	23
   South West (E12000009)	Swindon	24	24	0	0	0
   North West	Tameside	113	91	30	104	41
   West Midlands	Telford and Wrekin	57	93	105	81	56
   East of England	Thurrock	90	131	235	333	468
   South West (E12000009)	Torbay	64	113	185	224	230
   Inner London	Tower Hamlets	270	182	121	129	197
   North West	Trafford	391	385	332	214	106
   Yorkshire and the Humber (E12000003)	Wakefield	74	125	226	279	285
   West Midlands	Walsall	77	244	429	587	664
   Outer London	Waltham Forest	672	876	1,012	1,067	1,074
   Inner London	Wandsworth	61	92	101	108	92
   North West	Warrington	90	91	111	160	169
   West Midlands	Warwickshire	679	1,031	1,302	1,622	1,730
   South East	West Berkshire	63	52	45	11	21
   	West Sussex	286	394	672	896	911
   Inner London	Westminster	0	0	0	0	0
   North West	Wigan	388	452	482	406	359
   South West (E12000009)	Wiltshire	30	31	54	38	27
   South East	Windsor and Maidenhead	19	18	9	11	6
   North West	Wirral	65	55	56	37	3
   South East	Wokingham	47	134	229	288	353
   West Midlands	Wolverhampton	314	525	556	427	367
   	Worcestershire	190	350	522	765	890
   Yorkshire and the Humber (E12000003)	York	50	64	63	62	68

   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)