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: Local authority planned places - additional, bulge and removed places

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 2021/22

5. Step 5

   • Indicators:
     • Additional places
     • Bulge places
     • Removed places
   • National curriculum year group:
     • Total

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Academic year 2022/23

   'Local authority planned places - additional, bulge and removed places' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 146 other locations between 2019/20 and 2021/22

   		2019/20			2020/21			2021/22
   		Additional places	Bulge places	Removed places	Additional places	Bulge places	Removed places	Additional places	Bulge places	Removed places
   Outer London	Barking and Dagenham	0	0	0	900	0	0	1,740	0	0
   	Barnet	765	0	0	765	0	0	765	0	0
   Yorkshire and the Humber (E12000003)	Barnsley	0	50	0	200	90	0	200	90	0
   South West (E12000009)	Bath and North East Somerset	598	0	0	717	0	-14	717	0	-14
   East of England	Bedford Borough	1,140	0	-105	1,140	0	-105	1,140	0	-105
   Outer London	Bexley	210	0	0	420	0	0	420	0	0
   West Midlands	Birmingham	2,060	1,072	-1,140	3,005	1,452	-1,200	4,755	1,482	-1,260
   North West	Blackburn with Darwen	0	0	0	0	0	0	0	0	0
   	Blackpool	0	0	0	0	0	0	0	0	0
   	Bolton	135	0	0	1,340	0	0	1,340	0	0
   South West (E12000009)	Bournemouth Christchurch and Poole	4	150	-122	85	300	-242	106	300	-242
   South East	Bracknell Forest	60	0	-262	90	0	-314	120	0	-486
   Yorkshire and the Humber (E12000003)	Bradford	165	0	0	795	0	-30	900	0	-30
   Outer London	Brent	0	0	0	0	0	0	0	0	0
   South East	Brighton and Hove	0	30	0	0	60	0	150	90	0
   SOUTH WEST (E12000009)	Bristol, City of	0	180	0	0	180	0	0	180	0
   Outer London	Bromley	240	0	0	390	0	0	390	0	0
   South East	Buckinghamshire	1,435	0	-920	1,701	0	-920	1,701	0	-920
   North West	Bury	175	0	0	175	0	0	175	0	0
   Yorkshire and the Humber (E12000003)	Calderdale	560	75	-190	1,050	75	-190	1,050	75	-190
   East of England	Cambridgeshire	1,440	0	-105	2,550	0	-105	4,410	0	-705
   Inner London	Camden	0	150	0	0	120	0	0	60	0
   East of England	Central Bedfordshire	0	0	-600	780	0	-600	1,200	0	-1,050
   North West	Cheshire East	200	0	0	490	0	0	490	0	0
   	Cheshire West and Chester	245	55	-650	695	55	-650	695	55	-650
   Inner London	City of London	0	0	0	0	0	0	0	0	0
   South West (E12000009)	Cornwall	28	30	0	28	30	0	28	30	0
   West Midlands	Coventry	0	0	-90	600	0	-180	1,145	0	-270
   Outer London	Croydon	0	30	-180	0	30	-360	0	30	-390
   North West	Cumbria	90	30	0	120	30	0	120	30	0
   North East	Darlington	0	0	0	0	0	0	0	0	0
   East Midlands	Derby	1,185	0	0	1,185	0	0	1,185	0	0
   	Derbyshire	637	0	0	1,397	0	-60	1,477	0	-60
   South West (E12000009)	Devon	585	80	0	585	80	0	585	80	0
   Yorkshire and the Humber (E12000003)	Doncaster	0	0	0	691	0	0	691	0	0
   South West (E12000009)	Dorset	90	30	0	210	30	0	330	30	0
   West Midlands	Dudley	0	45	0	450	45	-15	600	45	-30
   North East	Durham	60	0	0	253	0	0	253	0	0
   Outer London	Ealing	0	30	0	0	30	0	0	30	0
   Yorkshire and the Humber (E12000003)	East Riding of Yorkshire	0	0	0	0	0	0	0	0	0
   South East	East Sussex	615	0	-1,290	821	30	-1,485	821	30	-1,605
   Outer London	Enfield	0	0	0	0	0	0	0	0	0
   East of England	Essex	2,915	30	0	4,920	60	0	6,335	60	-210
   North East	Gateshead	3	0	0	6	0	0	9	0	0
   South West (E12000009)	Gloucestershire	2,169	90	0	2,544	120	-90	4,079	120	-90
   Outer London	Greenwich	270	0	0	570	0	0	720	0	0
   Inner London	Hackney	0	0	0	0	0	0	0	0	0
   North West	Halton	10	0	0	10	0	0	10	0	0
   Inner London	Hammersmith and Fulham	1,050	0	0	840	0	0	840	0	0
   South East	Hampshire	620	0	-150	1,460	0	-940	2,240	0	-1,150
   Inner London	Haringey	30	405	-60	60	405	-120	90	405	-180
   Outer London	Harrow	0	0	0	0	0	0	0	0	0
   North East	Hartlepool	39	0	0	39	0	0	39	0	0
   Outer London	Havering	510	30	0	1,110	210	0	1,320	330	0
   West Midlands	Herefordshire	30	0	0	60	0	0	240	0	-180
   East of England	Hertfordshire	1,364	396	0	2,414	456	0	2,974	336	0
   Outer London	Hillingdon	620	102	0	620	102	0	620	102	0
   	Hounslow	0	72	0	0	72	0	0	72	0
   South East	Isle of Wight	0	0	-105	0	0	-1,344	0	0	-1,344
   South West (E12000009)	Isles Of Scilly	0	0	0	0	0	0	0	0	0
   Inner London	Islington	315	0	0	315	0	0	315	0	0
   	Kensington and Chelsea	80	60	0	80	60	0	80	60	0
   South East	Kent	750	105	0	2,636	150	0	5,514	150	0
   YORKSHIRE AND THE HUMBER (E12000003)	Kingston Upon Hull, City of	0	60	0	555	60	0	765	60	0
   Outer London	Kingston upon Thames	0	105	0	0	105	0	0	105	0
   Yorkshire and the Humber (E12000003)	Kirklees	120	30	0	180	30	0	240	30	0
   North West	Knowsley	0	0	-27	0	0	-27	0	0	-27
   Inner London	Lambeth	56	100	0	56	100	0	791	100	0
   North West	Lancashire	290	0	-275	290	0	-275	290	0	-275
   Yorkshire and the Humber (E12000003)	Leeds	698	180	0	1,556	465	-121	2,241	465	-142
   East Midlands	Leicester	433	327	-440	433	327	-440	433	297	-440
   	Leicestershire	645	45	-420	2,057	45	-420	2,547	45	-420
   Inner London	Lewisham	0	0	0	0	0	0	0	0	0
   East Midlands	Lincolnshire	575	115	0	980	215	0	1,978	235	0
   North West	Liverpool	0	110	0	125	110	0	125	110	0
   East of England	Luton	600	0	0	625	0	0	625	0	0
   North West	Manchester	0	30	0	150	30	0	650	30	0
   South East	Medway	450	0	0	450	0	0	450	0	0
   Outer London	Merton	0	0	-210	175	0	-210	175	0	-210
   North East	Middlesbrough	151	105	0	151	150	0	151	150	0
   South East	Milton Keynes	645	110	0	3,165	190	0	3,375	190	0
   North East	Newcastle upon Tyne	150	65	-10	238	65	-20	238	65	-30
   Inner London	Newham	0	90	0	300	90	0	600	90	0
   East of England	Norfolk	1,560	105	0	2,220	105	0	2,220	105	0
   Yorkshire and the Humber (E12000003)	North East Lincolnshire	15	0	0	30	0	0	45	0	0
   	North Lincolnshire	11	25	0	41	34	0	41	34	0
   South West (E12000009)	North Somerset	0	58	-700	1,160	58	-850	1,160	58	-850
   North East	North Tyneside	45	0	0	60	0	0	75	0	0
   Yorkshire and the Humber (E12000003)	North Yorkshire	0	0	-56	550	0	-56	1,180	0	-56
   East Midlands	Northamptonshire	155	345	-30	275	605	-30	425	605	-30
   North East	Northumberland	36	30	0	72	0	0	108	0	0
   East Midlands	Nottingham	328	0	-60	328	0	-90	328	0	-90
   	Nottinghamshire	997	0	0	1,752	0	0	1,962	0	-545
   North West	Oldham	1,108	20	0	1,318	20	0	1,318	20	0
   South East	Oxfordshire	480	0	-158	2,130	0	-158	3,025	0	-158
   East of England	Peterborough	0	0	0	0	0	0	0	0	0
   South West (E12000009)	Plymouth	420	90	0	435	140	-36	450	140	-72
   South East	Portsmouth	355	0	0	810	0	0	915	0	0
   	Reading	0	90	0	30	270	-30	60	495	-60
   Outer London	Redbridge	120	90	0	120	90	0	120	90	0
   North East	Redcar and Cleveland	0	0	0	0	0	0	0	0	0
   Outer London	Richmond upon Thames	0	30	0	0	30	0	0	30	0
   North West	Rochdale	0	30	0	0	240	0	28	180	0
   Yorkshire and the Humber (E12000003)	Rotherham	105	0	-30	465	0	-60	690	0	-60
   East Midlands	Rutland	0	0	0	0	0	0	0	0	0
   North West	Salford	0	135	0	0	135	0	0	135	0
   West Midlands	Sandwell	825	140	0	825	140	0	1,275	140	0
   North West	Sefton	0	0	0	0	0	0	0	0	0
   Yorkshire and the Humber (E12000003)	Sheffield	0	135	0	0	135	0	0	135	0
   West Midlands	Shropshire	70	0	0	431	0	0	1,023	0	0
   South East	Slough	0	0	0	0	0	0	0	0	0
   West Midlands	Solihull	176	0	0	393	0	0	663	0	0
   South West (E12000009)	Somerset	841	30	0	1,441	30	0	1,861	30	0
   	South Gloucestershire	420	105	0	420	105	0	420	105	0
   North East	South Tyneside	210	0	-510	210	0	-850	210	0	-850
   South East	Southampton	0	84	0	0	84	0	0	84	0
   East of England	Southend-on-Sea	50	0	0	130	0	0	240	0	-30
   Inner London	Southwark	0	0	-270	0	0	-540	0	0	-810
   North West	St Helens	15	0	0	210	0	0	210	0	0
   West Midlands	Staffordshire	890	50	-75	1,460	65	-75	3,005	125	-75
   North West	Stockport	60	60	0	135	60	0	135	60	0
   North East	Stockton-on-Tees	500	0	0	500	0	0	500	0	0
   West Midlands	Stoke-on-Trent	105	0	0	705	0	0	705	0	0
   East of England	Suffolk	593	0	-256	1,508	0	-256	2,078	0	-256
   North East	Sunderland	300	15	0	370	15	0	545	15	0
   South East	Surrey	150	180	0	1,170	180	0	2,850	240	0
   Outer London	Sutton	310	83	0	310	83	0	310	83	0
   South West (E12000009)	Swindon	420	0	0	420	0	0	420	0	0
   North West	Tameside	510	0	0	510	0	0	630	0	0
   West Midlands	Telford and Wrekin	630	90	0	630	90	0	630	90	0
   East of England	Thurrock	0	854	0	30	734	0	60	644	0
   South West (E12000009)	Torbay	30	20	0	90	20	0	150	20	0
   Inner London	Tower Hamlets	0	0	0	409	60	-1,080	419	110	-1,260
   North West	Trafford	70	0	0	70	0	0	175	0	0
   Yorkshire and the Humber (E12000003)	Wakefield	169	30	0	169	30	0	319	30	0
   West Midlands	Walsall	540	0	0	555	0	0	660	0	0
   Outer London	Waltham Forest	0	60	0	0	150	0	0	300	0
   Inner London	Wandsworth	0	0	0	1,005	0	0	1,005	0	0
   North West	Warrington	339	0	0	654	0	0	1,164	0	0
   West Midlands	Warwickshire	220	90	-290	545	120	-360	1,130	120	-390
   South East	West Berkshire	30	30	-210	447	30	-315	597	30	-315
   	West Sussex	1,175	45	-390	1,535	45	-390	2,795	45	-390
   Inner London	Westminster	440	30	-630	440	30	-630	440	30	-630
   North West	Wigan	105	15	0	105	15	0	105	0	0
   South West (E12000009)	Wiltshire	1,885	0	0	2,175	0	-105	2,604	0	-105
   South East	Windsor and Maidenhead	261	69	0	671	30	0	671	30	-98
   North West	Wirral	0	0	0	0	0	0	0	0	0
   South East	Wokingham	0	0	0	180	0	0	810	0	0
   West Midlands	Wolverhampton	198	226	0	396	255	0	594	255	0
   	Worcestershire	440	0	-50	1,040	0	-50	1,765	60	-50
   Yorkshire and the Humber (E12000003)	York	105	30	0	105	30	0	105	30	0

   Footnotes

   1. z - Indicates data is not applicable.
   2. Includes places reported by local authorities in summer 2019 as planned to be added or removed. Includes only projects with a high degree of certainty of going ahead, usually where funding has been committed. 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)