Data set from Pupil absence in schools in England

Absence rates by pupil characteristic - autumn term

Not the latest data

Published 20 July 2023

Last updated 20 July 2023

Absence information by characteristics for all enrolments in state-funded primary, secondary and special schools including information on overall absence, persistent absence and reason for absence for pupils aged 5-15. Characteristics included are gender, year group, free school meal eligibility, SEN provision, SEN type of need, ethnicity and language. National, regional and local authority data from autumn 2019 to autumn 2022

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Pupil absence in schools in England
• Release: Autumn term 2022/23
• Number of rows: 161,478
• Geographic levels: Local authority, National, Regional
• Indicators:
  • Authorised absence rate
  • Authorised absence rate exact
  • Number of authorised absence sessions
  • Number of authorised absence sessions for persistent absentees
  • Number of authorised holiday sessions
  • Number of authorised other sessions
  • Number of authorised reasons sessions
  • Number of excluded sessions
  • Number of extended authorised holiday sessions
  • Number of illness sessions
  • Number of late sessions
  • Number of medical appointments sessions
  • Number of no reason yet sessions
  • Number of overall absence sessions
  • Number of overall absence sessions for persistent absentees
  • Number of overall reasons sessions
  • Number of persistent absentees (10% missed)
  • Number of persistent absentees (50% missed)
  • Number of pupil enrolments
  • Number of religious observance sessions
  • Number of sessions possible
  • Number of sessions possible for persistent absentees
  • Number of sessions recorded as exceptional circumstances
  • Number of sessions recorded as not attending due to COVID circumstances
  • Number of study leave sessions
  • Number of traveller sessions
  • Number of unauthorised absence sessions
  • Number of unauthorised absence sessions for persistent absentees
  • Number of unauthorised holiday sessions
  • Number of unauthorised other sessions
  • Number of unauthorised reasons sessions
  • Overall absence rate
  • Overall absence rate exact
  • Percentage of persistent absentees (10% missed)
  • Percentage of persistent absentees (50% missed)
  • Rate of sessions recorded as not attending due to COVID circumstances
  • Unauthorised absence rate
  • Unauthorised absence rate exact
• Filters:
  • Characteristic
  • School type
• Time period: 2019/20 Autumn term to 2022/23 Autumn term

---

Data set preview

Table showing first 5 rows, from underlying data

time_period	time_identifier	geographic_level	country_code	country_name	region_code	region_name	old_la_code	new_la_code	la_name	school_type	breakdown_topic	breakdown	enrolments	sess_possible	sess_overall	sess_authorised	sess_unauthorised	sess_overall_percent	sess_authorised_percent	sess_unauthorised_percent	enrolments_pa_10_exact	enrolments_pa_10_exact_percent	enrolments_pa_50_exact	enrolments_pa_50_exact_percent	sess_possible_pa_10_exact	sess_overall_pa_10_exact	sess_authorised_pa_10_exact	sess_unauthorised_pa_10_exact	sess_overall_percent_pa_10_exact	sess_authorised_percent_pa_10_exact	sess_unauthorised_percent_pa_10_exact	sess_authorised_illness	sess_authorised_appointments	sess_authorised_religious	sess_authorised_study	sess_authorised_traveller	sess_authorised_holiday	sess_authorised_ext_holiday	sess_authorised_excluded	sess_authorised_other	sess_authorised_totalreasons	sess_unauthorised_holiday	sess_unauthorised_late	sess_unauthorised_other	sess_unauthorised_noyet	sess_unauthorised_totalreasons	sess_overall_totalreasons	sess_x_covid	sess_y_exceptional	sess_x_covid_rate
202223	Autumn term	National	E92000001	England						Total	Total	Total	7205741	953588265	71792227	51949460	19842767	7.52864	5.44779	2.08085	1743151	24.19114	125279	1.7386	224847525	46042170	29928368	16113802	3079.52633	1978.1793	1101.34704	42562798	2632506	55809	46499	79228	474260	0	1049518	4382682	51283300	4184138	1205386	13656434	611064	19657022	70940322	z	3704453	z
202223	Autumn term	National	E92000001	England						Total	Gender	Gender Male	3687289	488068340	36973022	27003369	9969653	7.57538	5.5327	2.04268	901609	24.45181	63106	1.71145	116431426	23719406	15626386	8093020	3065.76513	2000.05009	1065.71504	21886436	1327121	28181	23605	42739	249181	0	701046	2391964	26650273	2109479	601089	6849422	311357	9871347	36521620	z	1934518	z
202223	Autumn term	National	E92000001	England						Total	Gender	Gender Female	3518432	465517417	34818847	24945906	9872941	7.4796	5.35875	2.12085	841533	23.91784	62171	1.76701	108414983	22322440	14301819	8020621	3092.14366	1953.03871	1139.10495	20676195	1305380	27628	22894	36489	225079	0	348472	1990705	24632842	2074639	604296	6806878	299689	9785502	34418344	z	1769925	z
202223	Autumn term	National	E92000001	England						Total	Gender	Gender unclassified	20	2508	358	185	173	14.27432	7.3764	6.89793	9	45	2	10	1116	324	163	161	211.36662	93.86624	117.50038	167	5	0	0	0	0	0	0	13	185	20	1	134	18	173	358	z	10	z
202223	Autumn term	National	E92000001	England						Total	Major ethnic groups	Ethnicity Major White Total	5119728	682135314	52996125	38713143	14282982	7.76915	5.67529	2.09386	1269466	24.79558	96105	1.87715	165136931	34479103	22654678	11824425	3141.27509	2022.49628	1118.77881	31644250	1955859	22464	28154	76506	327686	0	827841	3285277	38168037	2662566	852546	10225209	397808	14138129	52306166	z	2523401	z

---

Variables in this data set

Table showing all 40 variables

Variable name	Variable description
breakdown	Characteristic - Filter by pupil characteristic
enrolments	Number of pupil enrolments
enrolments_pa_10_exact	Number of persistent absentees (10% missed)
enrolments_pa_10_exact_percent	Percentage of persistent absentees (10% missed)
enrolments_pa_50_exact	Number of persistent absentees (50% missed)
enrolments_pa_50_exact_percent	Percentage of persistent absentees (50% missed)
school_type	School type - Filter by school type
sess_authorised	Number of authorised absence sessions
sess_authorised_appointments	Number of medical appointments sessions
sess_authorised_excluded	Number of excluded sessions
sess_authorised_ext_holiday	Number of extended authorised holiday sessions
sess_authorised_holiday	Number of authorised holiday sessions
sess_authorised_illness	Number of illness sessions
sess_authorised_other	Number of authorised other sessions
sess_authorised_pa_10_exact	Number of authorised absence sessions for persistent absentees
sess_authorised_percent	Authorised absence rate
sess_authorised_percent_pa_10_exact	Authorised absence rate exact
sess_authorised_religious	Number of religious observance sessions
sess_authorised_study	Number of study leave sessions
sess_authorised_totalreasons	Number of authorised reasons sessions
sess_authorised_traveller	Number of traveller sessions
sess_overall	Number of overall absence sessions
sess_overall_pa_10_exact	Number of overall absence sessions for persistent absentees
sess_overall_percent	Overall absence rate
sess_overall_percent_pa_10_exact	Overall absence rate exact
sess_overall_totalreasons	Number of overall reasons sessions
sess_possible	Number of sessions possible
sess_possible_pa_10_exact	Number of sessions possible for persistent absentees
sess_unauthorised	Number of unauthorised absence sessions
sess_unauthorised_holiday	Number of unauthorised holiday sessions
sess_unauthorised_late	Number of late sessions
sess_unauthorised_noyet	Number of no reason yet sessions
sess_unauthorised_other	Number of unauthorised other sessions
sess_unauthorised_pa_10_exact	Number of unauthorised absence sessions for persistent absentees
sess_unauthorised_percent	Unauthorised absence rate
sess_unauthorised_percent_pa_10_exact	Unauthorised absence rate exact
sess_unauthorised_totalreasons	Number of unauthorised reasons sessions
sess_x_covid	Number of sessions recorded as not attending due to COVID circumstances
sess_x_covid_rate	Rate of sessions recorded as not attending due to COVID circumstances
sess_y_exceptional	Number of sessions recorded as exceptional circumstances

---

Using this data

• Download the underlying data as a compressed ZIP file

• View or create your own tables

  View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python

import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/9cee3cc4-1a2d-4441-8464-1aa73facb3fc/csv")

R

read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/9cee3cc4-1a2d-4441-8464-1aa73facb3fc/csv")

---

Contact us

If you have a specific enquiry about Absence rates by pupil characteristic - autumn term statistics and data:

Attendance and exclusions statistics team

Email: schools.statistics@education.gov.uk
Contact name: Attendance and exclusions statistics team

---