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: Pupil absence in schools in England: autumn term

   This publication has been superseded by Pupil absence in schools in England

2. Step 2

   • Data set: 01 - Absence rates by school and geographic level

3. Step 3

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

4. Step 4

   • Time period: 2019/20 Autumn term to 2021/22 Autumn term

5. Step 5

   • Indicators:
     • Overall absence rate
     • Percentage of persistent absentees
   • School type:
     • Total

6. Step 6 Explore data

   This is the latest data

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

   '01 - Absence rates by school and geographic level' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 148 other locations between 2019/20 Autumn term and 2021/22 Autumn term

   		Overall absence rate			Percentage of persistent absentees
   		2019/20 Autumn term	2020/21 Autumn term	2021/22 Autumn term	2019/20 Autumn term	2020/21 Autumn term	2021/22 Autumn term
   North East	County Durham	5.5%	4.9%	7.5%	15.6%	13.9%	26.5%
   	Darlington	5.1%	4.3%	6.8%	14.3%	12.0%	24.0%
   	Gateshead	5.6%	4.9%	7.7%	15.7%	14.7%	26.5%
   	Hartlepool	5.9%	5.3%	6.9%	17.5%	15.8%	22.3%
   	Middlesbrough	5.8%	5.7%	7.6%	16.9%	16.9%	26.6%
   	Newcastle upon Tyne	6.0%	6.0%	7.9%	17.0%	17.8%	26.3%
   	North Tyneside	5.5%	4.0%	6.8%	15.9%	10.8%	24.4%
   	Northumberland	5.7%	4.6%	7.5%	16.3%	12.5%	26.8%
   	Redcar and Cleveland	5.8%	4.6%	7.3%	16.3%	12.5%	25.2%
   	South Tyneside	5.9%	4.7%	7.0%	18.1%	13.7%	24.7%
   	Stockton-on-Tees	5.3%	4.4%	6.8%	14.9%	12.1%	23.4%
   	Sunderland	6.5%	5.3%	7.6%	20.5%	15.2%	25.9%
   North West	Blackburn with Darwen	4.8%	4.8%	6.5%	13.0%	14.4%	21.4%
   	Blackpool	5.8%	4.7%	7.0%	17.4%	13.8%	24.5%
   	Bolton	5.0%	4.0%	6.3%	13.5%	11.1%	20.3%
   	Bury	5.2%	4.1%	6.6%	13.9%	11.6%	21.6%
   	Cheshire East	4.9%	4.3%	7.1%	13.0%	11.3%	24.5%
   	Cheshire West and Chester	5.2%	4.4%	7.2%	14.0%	11.3%	25.0%
   	Cumbria	5.4%	4.4%	7.3%	15.2%	11.9%	25.7%
   	Halton	5.7%	4.8%	7.6%	16.9%	13.7%	26.5%
   	Knowsley	6.1%	6.1%	7.9%	18.4%	18.5%	27.0%
   	Lancashire	5.0%	4.5%	6.6%	13.2%	12.4%	22.1%
   	Liverpool	5.8%	5.6%	7.4%	16.8%	16.7%	24.4%
   	Manchester	4.7%	4.8%	6.1%	12.6%	13.7%	19.6%
   	Oldham	5.2%	5.1%	6.9%	13.9%	14.8%	22.7%
   	Rochdale	5.3%	4.9%	7.0%	14.4%	14.2%	23.7%
   	Salford	5.9%	5.3%	7.6%	16.7%	15.5%	26.6%
   	Sefton	5.7%	4.9%	7.7%	16.6%	13.5%	26.3%
   	St. Helens	5.6%	4.8%	7.9%	16.0%	13.7%	27.4%
   	Stockport	5.1%	4.2%	6.8%	13.6%	11.4%	22.2%
   	Tameside	4.8%	4.0%	6.6%	12.1%	9.8%	22.0%
   	Trafford	4.4%	3.6%	6.1%	11.2%	8.9%	21.1%
   	Warrington	5.2%	4.2%	6.7%	14.5%	11.6%	23.2%
   	Wigan	5.2%	4.5%	7.1%	14.4%	12.2%	24.8%
   	Wirral	5.7%	5.1%	7.4%	15.9%	14.0%	25.5%
   Yorkshire and The Humber	Barnsley	5.5%	4.5%	7.2%	16.1%	12.2%	25.9%
   	Bradford	5.7%	6.2%	7.8%	15.7%	18.0%	24.6%
   	Calderdale	4.7%	4.5%	6.5%	12.5%	13.1%	21.7%
   	Doncaster	5.8%	5.3%	7.4%	16.8%	14.6%	25.3%
   	East Riding of Yorkshire	5.1%	4.2%	7.0%	14.0%	11.5%	24.9%
   	Kingston upon Hull, City of	5.3%	5.7%	7.2%	15.9%	17.5%	25.2%
   	Kirklees	4.8%	4.4%	6.5%	13.0%	12.7%	22.1%
   	Leeds	5.2%	4.6%	6.4%	14.1%	13.0%	20.9%
   	North East Lincolnshire	5.3%	5.1%	7.4%	15.6%	15.1%	26.2%
   	North Lincolnshire	5.4%	4.9%	7.6%	15.6%	14.3%	27.9%
   	North Yorkshire	5.3%	4.3%	7.2%	14.5%	11.3%	25.9%
   	Rotherham	5.6%	4.9%	7.4%	16.0%	13.7%	25.9%
   	Sheffield	5.4%	5.4%	7.1%	14.9%	15.1%	23.0%
   	Wakefield	5.3%	4.8%	7.1%	15.3%	14.3%	24.5%
   	York	5.0%	3.9%	7.0%	12.7%	9.8%	23.8%
   East Midlands	Derby	5.1%	4.6%	6.9%	15.0%	13.4%	22.7%
   	Derbyshire	5.1%	4.2%	7.3%	13.6%	11.2%	24.3%
   	Leicester	5.0%	4.8%	6.6%	13.5%	13.3%	21.1%
   	Leicestershire	4.9%	4.1%	7.0%	12.2%	10.3%	23.9%
   	Lincolnshire	5.2%	4.5%	7.4%	14.3%	13.0%	27.1%
   	North Northamptonshire	no data	no data	7.5%	no data	no data	26.9%
   	Northamptonshire	4.9%	4.3%	no data	12.5%	11.6%	no data
   	Nottingham	5.5%	5.6%	6.6%	16.4%	16.3%	21.4%
   	Nottinghamshire	4.8%	4.3%	6.9%	13.6%	11.7%	23.7%
   	Rutland	3.9%	3.1%	6.2%	9.5%	7.0%	22.8%
   	West Northamptonshire	no data	no data	6.7%	no data	no data	23.2%
   West Midlands	Birmingham	4.9%	5.5%	6.7%	13.5%	16.2%	22.3%
   	Coventry	4.8%	4.9%	7.0%	13.1%	14.1%	23.8%
   	Dudley	5.3%	4.9%	7.2%	15.1%	14.3%	26.1%
   	Herefordshire, County of	4.9%	4.2%	7.0%	12.4%	11.0%	25.0%
   	Sandwell	4.6%	4.6%	6.6%	12.5%	13.3%	22.3%
   	Shropshire	5.2%	4.4%	7.6%	13.9%	11.4%	27.5%
   	Solihull	4.9%	4.8%	7.1%	12.6%	13.2%	24.6%
   	Staffordshire	5.0%	4.2%	7.3%	13.4%	11.4%	25.4%
   	Stoke-on-Trent	5.4%	5.1%	7.3%	15.5%	15.2%	25.3%
   	Telford and Wrekin	5.1%	4.7%	7.3%	14.1%	13.0%	27.1%
   	Walsall	5.0%	5.3%	6.9%	13.5%	15.5%	23.6%
   	Warwickshire	5.0%	4.8%	7.5%	12.5%	12.6%	26.2%
   	Wolverhampton	4.6%	4.7%	6.0%	12.2%	13.4%	20.0%
   	Worcestershire	5.1%	4.6%	7.2%	13.6%	12.2%	25.5%
   East of England	Bedford	4.5%	4.2%	6.6%	11.3%	12.0%	23.7%
   	Cambridgeshire	4.5%	4.2%	7.0%	10.5%	10.7%	24.0%
   	Central Bedfordshire	4.8%	4.4%	7.0%	11.5%	11.9%	24.2%
   	Essex	4.6%	4.8%	7.1%	12.5%	13.2%	24.0%
   	Hertfordshire	4.5%	4.3%	6.6%	11.1%	11.2%	21.4%
   	Luton	4.7%	4.7%	6.6%	12.0%	13.4%	22.2%
   	Norfolk	5.1%	4.9%	7.7%	13.3%	13.9%	27.7%
   	Peterborough	4.6%	4.6%	7.1%	11.8%	13.1%	25.5%
   	Southend-on-Sea	4.4%	5.0%	6.8%	11.4%	14.5%	24.1%
   	Suffolk	4.8%	4.8%	7.5%	11.9%	12.5%	26.3%
   	Thurrock	4.8%	4.7%	6.7%	13.6%	13.2%	22.9%
   South East	Bracknell Forest	4.2%	3.9%	5.9%	9.6%	9.6%	19.8%
   	Brighton and Hove	5.1%	4.9%	7.5%	13.2%	12.8%	25.7%
   	Buckinghamshire	4.7%	4.3%	6.8%	11.5%	10.8%	23.7%
   	East Sussex	5.3%	5.3%	7.2%	14.4%	15.2%	23.8%
   	Hampshire	4.4%	4.1%	6.7%	11.2%	10.9%	23.2%
   	Isle of Wight	4.9%	4.7%	7.3%	13.9%	12.9%	25.5%
   	Kent	5.2%	5.3%	7.2%	14.2%	15.3%	24.4%
   	Medway	4.8%	5.2%	7.1%	13.6%	16.4%	25.3%
   	Milton Keynes	4.9%	4.5%	6.5%	13.0%	13.1%	22.3%
   	Oxfordshire	4.9%	4.3%	7.1%	12.4%	11.2%	24.3%
   	Portsmouth	5.2%	5.1%	7.4%	13.9%	14.2%	24.9%
   	Reading	4.7%	4.6%	6.6%	12.3%	12.5%	22.1%
   	Slough	4.5%	5.0%	6.6%	11.9%	14.4%	21.6%
   	Southampton	5.0%	5.3%	7.3%	13.3%	15.2%	24.9%
   	Surrey	4.3%	4.1%	6.5%	10.7%	10.3%	22.1%
   	West Berkshire	4.4%	4.5%	6.6%	10.8%	12.3%	21.0%
   	West Sussex	4.7%	4.1%	6.7%	11.8%	11.0%	23.1%
   	Windsor and Maidenhead	4.8%	4.2%	6.7%	12.0%	11.3%	22.0%
   	Wokingham	4.1%	3.8%	6.2%	9.7%	9.4%	20.1%
   South West	Bath and North East Somerset	5.0%	4.3%	7.1%	12.8%	11.3%	24.0%
   	Bournemouth, Christchurch and Poole	4.7%	4.4%	7.3%	11.7%	11.5%	25.9%
   	Bristol, City of	5.3%	5.3%	7.2%	14.6%	15.3%	24.2%
   	Cornwall	5.1%	4.6%	8.0%	13.9%	12.9%	29.7%
   	Devon	4.8%	4.6%	8.0%	12.1%	12.2%	29.2%
   	Dorset	4.9%	4.5%	7.7%	11.9%	11.9%	27.4%
   	Gloucestershire	4.6%	4.2%	6.6%	11.8%	11.0%	22.0%
   	Isles of Scilly	5.9%	4.6%	5.9%	17.6%	10.0%	17.5%
   	North Somerset	5.0%	4.5%	7.2%	13.1%	12.5%	25.0%
   	Plymouth	5.7%	4.8%	8.2%	16.4%	13.5%	29.8%
   	Somerset	5.5%	4.7%	7.5%	14.4%	12.6%	24.9%
   	South Gloucestershire	4.4%	4.0%	6.8%	10.7%	10.5%	23.4%
   	Swindon	4.7%	4.8%	6.8%	12.7%	14.1%	22.6%
   	Torbay	5.2%	5.2%	8.8%	14.2%	15.3%	32.6%
   	Wiltshire	4.7%	4.2%	7.1%	12.1%	10.8%	24.6%
   Inner London	Camden	5.1%	5.1%	7.1%	13.6%	15.4%	23.9%
   	City of London	2.9%	3.1%	3.9%	4.5%	7.8%	10.5%
   	Hackney	4.2%	4.8%	5.8%	10.9%	13.7%	18.4%
   	Hammersmith and Fulham	4.7%	4.6%	6.0%	12.4%	12.7%	18.8%
   	Haringey	4.6%	5.2%	6.4%	11.9%	15.3%	21.2%
   	Islington	4.8%	5.3%	6.6%	13.0%	15.6%	20.9%
   	Kensington and Chelsea	4.4%	5.0%	5.9%	11.6%	14.3%	18.4%
   	Lambeth	4.6%	5.0%	6.2%	12.1%	14.7%	19.6%
   	Lewisham	4.4%	4.5%	5.5%	11.2%	12.5%	17.0%
   	Newham	4.7%	5.4%	6.0%	12.6%	16.0%	18.7%
   	Southwark	4.3%	4.6%	5.7%	11.1%	13.2%	17.6%
   	Tower Hamlets	4.6%	4.9%	5.5%	12.0%	14.5%	17.0%
   	Wandsworth	4.2%	4.5%	5.9%	10.1%	12.7%	18.8%
   	Westminster	4.5%	5.3%	6.3%	11.8%	15.4%	21.0%
   Outer London	Barking and Dagenham	4.5%	4.9%	6.1%	12.6%	14.6%	20.2%
   	Barnet	4.1%	4.0%	5.9%	9.3%	10.9%	19.2%
   	Bexley	4.6%	4.6%	6.4%	11.9%	13.4%	22.1%
   	Brent	4.1%	4.5%	5.5%	10.1%	12.7%	17.4%
   	Bromley	4.3%	4.2%	6.3%	10.8%	11.6%	21.2%
   	Croydon	4.7%	4.9%	6.4%	12.7%	13.9%	21.0%
   	Ealing	4.3%	4.7%	5.8%	10.8%	13.3%	18.8%
   	Enfield	4.7%	5.5%	6.4%	12.6%	16.3%	21.1%
   	Greenwich	4.5%	4.6%	5.9%	11.7%	12.9%	18.6%
   	Harrow	4.1%	4.2%	5.5%	10.0%	11.6%	17.1%
   	Havering	4.4%	4.0%	6.1%	11.6%	11.1%	19.7%
   	Hillingdon	4.9%	4.9%	6.3%	13.0%	13.9%	19.8%
   	Hounslow	4.3%	4.6%	6.2%	10.6%	13.4%	20.5%
   	Kingston upon Thames	3.9%	4.2%	6.1%	9.5%	11.1%	19.6%
   	Merton	4.2%	4.3%	6.1%	10.2%	11.5%	20.3%
   	Redbridge	4.4%	4.6%	5.9%	11.3%	13.0%	19.4%
   	Richmond upon Thames	3.9%	3.8%	6.2%	9.2%	9.3%	20.5%
   	Sutton	4.2%	4.2%	6.4%	10.4%	11.8%	22.0%
   	Waltham Forest	4.7%	4.6%	6.0%	12.4%	13.1%	19.6%

   Footnotes

   1. Total includes state-funded primary, secondary and special schools. Data for special schools is available from 2016/17 to present.

   Save table

   Related information

   • Release type:
   • Publication: Pupil absence in schools in England: autumn term, Autumn term 2021/22

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