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: Suspensions and permanent exclusions in England

2. Step 2

   • Data set: Permanent exclusions and suspensions - by district (LAD) (2016-17 to 2019-20)

3. Step 3

   • Local authority district:
     • Adur
     • Allerdale
     • Amber Valley
     • Arun
     • Ashfield

4. Step 4

   • Time period: 2019/20

5. Step 5

   • Indicators:
     • Pupil enrolments with one or more suspension
     • Pupil enrolments with one or more suspension (rate)
     • Suspension (rate)
     • Suspensions
   • School Type:
     • Total

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Spring term 2022/23

   Some rows and columns are not shown in this table as the data does not exist in the underlying file.

   'Permanent exclusions and suspensions - by district (LAD) (2016-17 to 2019-20)' in Adur, Allerdale, Amber Valley, Arun, Ashfield and 313 other locations for 2019/20

   		Suspensions	Suspension (rate)	Pupil enrolments with one or more suspension	Pupil enrolments with one or more suspension (rate)
   South East	Adur	171	2.15	101	1.27
   North West	Allerdale	359	2.41	212	1.43
   East Midlands	Amber Valley	348	1.92	228	1.26
   South East	Arun	681	3.74	310	1.70
   East Midlands	Ashfield	572	2.87	360	1.81
   South East	Ashford	781	3.81	424	2.07
   	Aylesbury Vale	948	2.90	510	1.56
   East of England	Babergh	303	2.28	153	1.15
   Outer London	Barking and Dagenham	636	1.44	385	0.87
   	Barnet	1,135	1.95	808	1.39
   Yorkshire and The Humber	Barnsley	2,199	6.36	753	2.18
   North West	Barrow-in-Furness	441	4.70	208	2.22
   East of England	Basildon	914	3.21	498	1.75
   South East	Basingstoke and Deane	727	3.09	397	1.69
   East Midlands	Bassetlaw	1,965	11.27	418	2.40
   South West	Bath and North East Somerset	1,203	4.41	592	2.17
   East of England	Bedford	725	2.47	458	1.56
   Outer London	Bexley	2,002	4.56	937	2.13
   West Midlands	Birmingham	6,005	2.97	3,822	1.89
   East Midlands	Blaby	198	1.64	132	1.10
   North West	Blackburn with Darwen	614	2.23	414	1.51
   	Blackpool	1,308	6.72	571	2.93
   East Midlands	Bolsover	398	3.70	193	1.79
   North West	Bolton	2,339	4.67	1,057	2.11
   East Midlands	Boston	225	2.23	133	1.32
   South West	Bournemouth, Christchurch and Poole	3,017	5.90	1,143	2.24
   South East	Bracknell Forest	568	3.13	283	1.56
   Yorkshire and The Humber	Bradford	4,756	4.76	2,420	2.42
   East of England	Braintree	679	3.37	373	1.85
   	Breckland	655	3.90	301	1.79
   Outer London	Brent	937	1.92	666	1.36
   East of England	Brentwood	491	3.57	297	2.16
   South East	Brighton and Hove	961	3.00	513	1.60
   South West	Bristol City of	3,362	5.55	1,593	2.63
   East of England	Broadland	591	3.09	293	1.53
   Outer London	Bromley	1,205	2.31	760	1.46
   West Midlands	Bromsgrove	404	2.48	244	1.50
   East of England	Broxbourne	555	3.39	353	2.15
   East Midlands	Broxtowe	500	3.22	289	1.86
   North West	Burnley	344	2.48	204	1.47
   	Bury	930	3.15	495	1.68
   Yorkshire and The Humber	Calderdale	1,332	3.62	693	1.89
   East of England	Cambridge	616	4.37	288	2.04
   Inner London	Camden	611	2.77	398	1.81
   West Midlands	Cannock Chase	397	3.10	249	1.95
   South East	Canterbury	481	2.31	311	1.49
   North West	Carlisle	1,068	7.05	429	2.83
   East of England	Castle Point	304	2.26	200	1.48
   	Central Bedfordshire	1,534	3.38	794	1.75
   East Midlands	Charnwood	735	3.17	382	1.65
   East of England	Chelmsford	747	2.74	421	1.54
   South West	Cheltenham	668	4.47	281	1.88
   South East	Cherwell	868	4.09	391	1.84
   North West	Cheshire East	1,662	3.03	735	1.34
   	Cheshire West and Chester	1,699	3.37	788	1.56
   East Midlands	Chesterfield	821	5.31	321	2.08
   South East	Chichester	672	4.64	329	2.27
   	Chiltern	377	2.14	241	1.37
   North West	Chorley	594	3.35	340	1.92
   Inner London	City of London	0	0.00	0	0.00
   East of England	Colchester	1,312	4.67	554	1.97
   North West	Copeland	211	2.33	139	1.53
   East Midlands	Corby	871	6.80	346	2.70
   South West	Cornwall	2,297	3.12	1,240	1.68
   	Cotswold	310	2.57	174	1.44
   North East	County Durham	3,138	4.31	1,371	1.88
   West Midlands	Coventry	2,297	4.02	1,332	2.33
   Yorkshire and The Humber	Craven	224	2.53	111	1.25
   South East	Crawley	1,024	5.29	500	2.58
   Outer London	Croydon	1,954	3.39	1,311	2.27
   East of England	Dacorum	972	4.07	472	1.98
   North East	Darlington	921	5.74	376	2.34
   South East	Dartford	617	2.83	416	1.91
   East Midlands	Daventry	407	3.56	184	1.61
   	Derby	1,773	4.11	941	2.18
   	Derbyshire Dales	178	1.88	114	1.20
   Yorkshire and The Humber	Doncaster	6,296	13.37	1,616	3.43
   South West	Dorset	2,198	4.53	1,013	2.09
   South East	Dover	826	5.04	439	2.68
   West Midlands	Dudley	2,087	4.38	1,053	2.21
   Outer London	Ealing	1,286	2.37	878	1.62
   South East	Eastbourne	557	4.12	267	1.98
   East of England	East Cambridgeshire	282	2.20	162	1.26
   South West	East Devon	699	3.77	294	1.59
   South East	East Hampshire	336	2.11	184	1.16
   East of England	East Hertfordshire	589	2.14	370	1.34
   South East	Eastleigh	532	2.77	289	1.50
   East Midlands	East Lindsey	868	4.95	426	2.43
   	East Northamptonshire	328	2.78	186	1.58
   Yorkshire and The Humber	East Riding of Yorkshire	1,581	3.48	691	1.52
   West Midlands	East Staffordshire	792	3.88	399	1.95
   East of England	East Suffolk	1,709	5.39	686	2.16
   North West	Eden	100	1.41	57	0.81
   South East	Elmbridge	330	2.01	178	1.08
   Outer London	Enfield	1,844	3.18	1,233	2.12
   East of England	Epping Forest	506	2.99	306	1.81
   South East	Epsom and Ewell	212	1.51	144	1.02
   East Midlands	Erewash	972	6.17	383	2.43
   South West	Exeter	750	5.13	298	2.04
   South East	Fareham	545	3.45	285	1.80
   East of England	Fenland	442	3.34	246	1.86
   South West	Forest of Dean	476	4.57	256	2.46
   North West	Fylde	200	2.36	114	1.35
   North East	Gateshead	1,361	4.74	610	2.12
   East Midlands	Gedling	385	2.05	256	1.36
   South West	Gloucester	1,125	5.35	506	2.41
   South East	Gosport	543	5.11	259	2.44
   	Gravesham	520	2.77	311	1.66
   East of England	Great Yarmouth	952	7.09	429	3.19
   Outer London	Greenwich	1,241	2.84	768	1.75
   South East	Guildford	559	3.09	273	1.51
   Inner London	Hackney	1,755	5.04	1,101	3.16
   North West	Halton	657	3.43	336	1.75
   Yorkshire and The Humber	Hambleton	945	8.85	282	2.64
   Inner London	Hammersmith and Fulham	762	3.72	529	2.58
   East Midlands	Harborough	254	1.94	164	1.26
   Inner London	Haringey	1,110	2.88	788	2.04
   East of England	Harlow	741	5.02	375	2.54
   Yorkshire and The Humber	Harrogate	1,066	4.57	345	1.48
   Outer London	Harrow	606	1.60	417	1.10
   South East	Hart	217	1.57	134	0.97
   North East	Hartlepool	1,276	8.33	452	2.95
   South East	Hastings	913	8.09	425	3.77
   	Havant	1,118	7.11	517	3.29
   Outer London	Havering	729	1.82	454	1.13
   West Midlands	Herefordshire County of	789	3.35	451	1.91
   East of England	Hertsmere	493	2.81	311	1.78
   East Midlands	High Peak	692	5.69	301	2.47
   Outer London	Hillingdon	1,427	2.71	839	1.59
   East Midlands	Hinckley and Bosworth	414	2.29	246	1.36
   South East	Horsham	439	2.35	220	1.18
   Outer London	Hounslow	1,278	2.85	788	1.76
   East of England	Huntingdonshire	897	3.78	457	1.93
   North West	Hyndburn	588	4.59	298	2.33
   East of England	Ipswich	891	4.17	432	2.02
   South East	Isle of Wight	855	5.07	434	2.57
   South West	Isles of Scilly	0	0.00	0	0.00
   Inner London	Islington	1,359	5.71	695	2.92
   	Kensington and Chelsea	465	3.56	298	2.28
   East Midlands	Kettering	508	3.01	263	1.56
   East of England	King's Lynn and West Norfolk	853	4.48	387	2.03
   Yorkshire and The Humber	Kingston upon Hull City of	1,291	3.11	733	1.77
   Outer London	Kingston upon Thames	361	1.38	226	0.87
   Yorkshire and The Humber	Kirklees	2,804	4.14	1,285	1.90
   North West	Knowsley	728	3.57	413	2.02
   Inner London	Lambeth	723	1.98	508	1.39
   North West	Lancaster	426	2.23	256	1.34
   Yorkshire and The Humber	Leeds	4,095	3.23	1,948	1.53
   East Midlands	Leicester	1,378	2.40	850	1.48
   South East	Lewes	590	4.64	262	2.06
   Inner London	Lewisham	1,264	3.20	891	2.25
   West Midlands	Lichfield	373	2.42	206	1.34
   East Midlands	Lincoln	554	3.92	282	1.99
   North West	Liverpool	2,682	3.62	1,495	2.02
   East of England	Luton	1,058	2.74	658	1.71
   South East	Maidstone	782	2.91	490	1.82
   East of England	Maldon	399	5.73	172	2.47
   West Midlands	Malvern Hills	274	2.82	149	1.53
   North West	Manchester	4,087	4.63	2,242	2.54
   East Midlands	Mansfield	623	3.52	233	1.32
   South East	Medway	1,757	3.75	833	1.78
   East Midlands	Melton	138	1.96	90	1.28
   South West	Mendip	635	4.44	296	2.07
   Outer London	Merton	510	1.79	359	1.26
   South West	Mid Devon	531	4.99	225	2.11
   North East	Middlesbrough	2,905	11.65	783	3.14
   East of England	Mid Suffolk	316	2.35	173	1.29
   South East	Mid Sussex	407	1.93	227	1.07
   	Milton Keynes	1,843	3.82	923	1.91
   	Mole Valley	219	2.08	113	1.07
   East Midlands	Newark and Sherwood	254	1.67	173	1.13
   West Midlands	Newcastle-under-Lyme	615	4.00	317	2.06
   North East	Newcastle upon Tyne	1,571	3.86	816	2.01
   South East	New Forest	730	3.43	367	1.72
   Inner London	Newham	1,270	2.01	851	1.35
   East Midlands	Northampton	1,667	4.57	728	2.00
   South West	North Devon	463	3.28	239	1.69
   East Midlands	North East Derbyshire	217	1.66	137	1.05
   Yorkshire and The Humber	North East Lincolnshire	1,065	4.46	556	2.33
   East of England	North Hertfordshire	461	2.43	251	1.32
   East Midlands	North Kesteven	394	2.29	236	1.37
   Yorkshire and The Humber	North Lincolnshire	2,061	8.27	711	2.85
   East of England	North Norfolk	277	2.54	150	1.38
   South West	North Somerset	1,396	4.53	678	2.20
   North East	North Tyneside	891	2.87	513	1.65
   	Northumberland	1,738	3.81	837	1.84
   West Midlands	North Warwickshire	579	5.21	289	2.60
   East Midlands	North West Leicestershire	498	3.53	230	1.63
   East of England	Norwich	1,339	7.68	526	3.02
   Not available		205	20.77	58	5.88
   East Midlands	Nottingham	2,908	6.42	1,373	3.03
   West Midlands	Nuneaton and Bedworth	900	4.86	402	2.17
   East Midlands	Oadby and Wigston	276	2.41	181	1.58
   North West	Oldham	1,455	3.25	759	1.70
   South East	Oxford	1,216	6.81	520	2.91
   North West	Pendle	447	3.12	258	1.80
   East of England	Peterborough	1,645	4.27	868	2.25
   South West	Plymouth	1,651	4.23	809	2.07
   South East	Portsmouth	1,175	4.41	515	1.93
   North West	Preston	873	4.37	388	1.94
   South East	Reading	772	3.32	407	1.75
   Outer London	Redbridge	1,158	2.03	796	1.39
   North East	Redcar and Cleveland	4,465	20.47	965	4.42
   West Midlands	Redditch	514	4.15	289	2.33
   South East	Reigate and Banstead	571	2.77	334	1.62
   North West	Ribble Valley	184	1.74	138	1.30
   Yorkshire and The Humber	Richmondshire	201	3.03	91	1.37
   Outer London	Richmond upon Thames	462	1.63	283	1.00
   North West	Rochdale	1,196	3.26	608	1.65
   East of England	Rochford	217	1.70	143	1.12
   North West	Rossendale	323	2.71	167	1.40
   South East	Rother	576	5.06	280	2.46
   Yorkshire and The Humber	Rotherham	3,144	7.07	1,035	2.33
   West Midlands	Rugby	480	2.82	279	1.64
   South East	Runnymede	337	2.91	185	1.60
   East Midlands	Rushcliffe	477	2.32	280	1.36
   South East	Rushmoor	305	2.63	158	1.36
   East Midlands	Rutland	84	1.44	58	0.99
   Yorkshire and The Humber	Ryedale	281	3.91	121	1.68
   North West	Salford	2,053	5.47	946	2.52
   West Midlands	Sandwell	968	1.59	678	1.11
   Yorkshire and The Humber	Scarborough	1,204	9.19	393	3.00
   South West	Sedgemoor	1,272	7.36	496	2.87
   North West	Sefton	801	2.02	507	1.28
   Yorkshire and The Humber	Selby	522	4.18	213	1.71
   South East	Sevenoaks	195	1.48	118	0.90
   Yorkshire and The Humber	Sheffield	4,738	5.77	2,212	2.69
   South East	Shepway	411	2.71	259	1.71
   West Midlands	Shropshire	1,694	4.30	796	2.02
   South East	Slough	615	1.94	435	1.37
   West Midlands	Solihull	1,373	3.44	769	1.92
   South West	Somerset West and Taunton	1,827	9.84	682	3.67
   South East	Southampton	1,230	3.81	587	1.82
   	South Bucks	182	2.03	95	1.06
   East of England	South Cambridgeshire	496	2.13	268	1.15
   East Midlands	South Derbyshire	409	3.20	211	1.65
   East of England	Southend-on-Sea	731	2.43	425	1.41
   South West	South Gloucestershire	1,628	4.10	775	1.95
   	South Hams	512	4.49	186	1.63
   East Midlands	South Holland	432	3.38	235	1.84
   	South Kesteven	580	2.68	298	1.37
   North West	South Lakeland	284	2.00	188	1.32
   East of England	South Norfolk	611	3.12	304	1.55
   East Midlands	South Northamptonshire	353	2.08	216	1.27
   South East	South Oxfordshire	848	3.90	367	1.69
   North West	South Ribble	489	2.92	311	1.86
   South West	South Somerset	1,077	5.17	479	2.30
   West Midlands	South Staffordshire	711	4.79	314	2.11
   North East	South Tyneside	571	2.58	326	1.47
   Inner London	Southwark	1,522	3.50	947	2.18
   South East	Spelthorne	346	2.41	219	1.52
   West Midlands	Stafford	606	3.60	305	1.81
   	Staffordshire Moorlands	448	3.00	254	1.70
   East of England	St Albans	476	1.65	320	1.11
   	Stevenage	615	3.80	310	1.92
   North West	St. Helens	983	3.67	458	1.71
   	Stockport	1,426	3.34	734	1.72
   North East	Stockton-on-Tees	2,059	6.44	745	2.33
   West Midlands	Stoke-on-Trent	3,046	7.52	1,240	3.06
   	Stratford-on-Avon	395	1.97	230	1.15
   South West	Stroud	594	3.52	246	1.46
   North East	Sunderland	1,913	4.74	883	2.19
   South East	Surrey Heath	560	4.57	203	1.65
   Outer London	Sutton	971	2.50	557	1.43
   South East	Swale	1,021	4.36	577	2.46
   South West	Swindon	1,385	3.91	662	1.87
   North West	Tameside	1,730	4.70	877	2.38
   West Midlands	Tamworth	450	4.57	226	2.30
   South East	Tandridge	271	2.46	153	1.39
   South West	Teignbridge	670	4.18	325	2.03
   West Midlands	Telford and Wrekin	2,349	7.76	722	2.39
   East of England	Tendring	1,320	6.79	579	2.98
   South East	Test Valley	463	2.80	247	1.50
   South West	Tewkesbury	510	3.87	254	1.93
   South East	Thanet	956	4.70	467	2.29
   East of England	Three Rivers	358	2.35	235	1.54
   	Thurrock	862	2.90	453	1.52
   South East	Tonbridge and Malling	556	2.50	316	1.42
   South West	Torbay	1,027	5.03	474	2.32
   	Torridge	213	2.74	105	1.35
   Inner London	Tower Hamlets	1,013	2.26	633	1.41
   North West	Trafford	930	2.20	610	1.44
   South East	Tunbridge Wells	441	2.30	289	1.51
   East of England	Uttlesford	210	1.74	123	1.02
   South East	Vale of White Horse	872	4.72	368	1.99
   Yorkshire and The Humber	Wakefield	4,514	8.46	1,612	3.02
   West Midlands	Walsall	1,524	3.04	916	1.83
   Outer London	Waltham Forest	949	2.19	676	1.56
   Inner London	Wandsworth	587	1.72	418	1.22
   North West	Warrington	895	2.76	431	1.33
   West Midlands	Warwick	543	3.01	278	1.54
   East of England	Watford	388	2.62	208	1.40
   South East	Waverley	503	3.02	290	1.74
   	Wealden	560	2.99	263	1.40
   East Midlands	Wellingborough	555	4.39	272	2.15
   East of England	Welwyn Hatfield	474	2.87	273	1.65
   South East	West Berkshire	822	3.13	436	1.66
   South West	West Devon	180	2.69	100	1.50
   North West	West Lancashire	321	2.05	198	1.26
   East Midlands	West Lindsey	643	4.92	185	1.41
   Inner London	Westminster	702	3.15	498	2.23
   South East	West Oxfordshire	650	3.89	294	1.76
   East of England	West Suffolk	1,049	4.48	475	2.03
   North West	Wigan	2,030	4.27	1,025	2.15
   South West	Wiltshire	2,689	3.84	1,414	2.02
   South East	Winchester	479	2.98	263	1.63
   	Windsor and Maidenhead	601	2.69	368	1.64
   North West	Wirral	1,664	3.31	936	1.86
   South East	Woking	396	2.71	228	1.56
   	Wokingham	300	1.12	171	0.64
   West Midlands	Wolverhampton	1,532	3.22	925	1.95
   	Worcester	371	2.58	251	1.75
   South East	Worthing	496	3.34	252	1.70
   West Midlands	Wychavon	432	2.89	227	1.52
   South East	Wycombe	639	2.35	399	1.46
   North West	Wyre	845	5.99	414	2.93
   West Midlands	Wyre Forest	403	3.03	232	1.75
   Yorkshire and The Humber	York	906	3.54	410	1.60

   Save table

   Related information

   • Release type:
   • Publication: Suspensions and permanent exclusions in England, Spring term 2022/23

   Our statistical practice is regulated by the Office for Statistics Regulation (OSR)