Data set from Pupil absence in schools in England

Absence rates by geographic level - school level - autumn and spring term combined

Not the latest data

Published 19 October 2023

Last updated 19 October 2023

Absence information 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. Includes school level data.

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Pupil absence in schools in England
• Release: Autumn and spring term 2022/23
• Geographic levels: School
• Indicators:
  • Authorised absence rate
  • Authorised holiday rate
  • Authorised other rate
• Filters:
  • School type
• Time period: 2016/17 Autumn and spring term to 2022/23 Autumn and spring 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	estab	school_laestab	school_urn	academy_type	academy_open_date	all_through	num_schools	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_auth_illness	sess_auth_appointments	sess_auth_religious	sess_auth_study	sess_auth_traveller	sess_auth_holiday	sess_auth_ext_holiday	sess_auth_excluded	sess_auth_other	sess_auth_totalreasons	sess_unauth_holiday	sess_unauth_late	sess_unauth_other	sess_unauth_noyet	sess_unauth_totalreasons	sess_overall_totalreasons	sess_x_covid	sess_y_exceptional	sess_auth_illness_rate	sess_auth_appointments_rate	sess_auth_religious_rate	sess_auth_study_rate	sess_auth_traveller_rate	sess_auth_holiday_rate	sess_auth_ext_holiday_rate	sess_auth_excluded_rate	sess_auth_other_rate	sess_auth_totalreasons_rate	sess_unauth_holiday_rate	sess_unauth_late_rate	sess_unauth_other_rate	sess_unauth_noyet_rate	sess_unauth_totalreasons_rate	sess_overall_totalreasons_rate	sess_x_covid_rate	school_name
201617	Autumn and spring term	School	E92000001	England	E12000004	East Midlands	928	E10000021	Northamptonshire	State-funded primary	3312	9283312	140065	Primary converter academy	01/09/2013		1	117	29202	1471	1210	261	5.03733	4.14355	0.89377	19	16.23932	0	0	1078	49	9	0	0	0	z	0	74	1210	208	29	24	0	261	1471	z	z	3.6915279775357852	0.1677967262516266	0.030819807	0	0	0	z	0	0.2534073008698034	4.1435518115197589	0.7122799808232313	0.099308267	0.082186152	0	0.8937743990137662	5.0373262105335251	0	z
201617	Autumn and spring term	School	E92000001	England	E12000004	East Midlands	928	E10000021	Northamptonshire	State-funded primary	3336	9283336	141068	Primary converter academy	01/08/2014		1	91	22180	742	590	152	3.34536	2.66005	0.6853	4	4.3956	0	0	487	69	0	0	0	0	z	0	34	590	148	0	4	0	152	742	z	z	2.1956717763751127	0.3110910730387737	0	0	0	0	z	0	0.1532912533814247	2.6600541027953111	0.6672678088367899	0	0.018034265	0	0.6853020739404869	3.3453561767357980	0	z
201617	Autumn and spring term	School	E92000001	England	E12000004	East Midlands	928	E10000021	Northamptonshire	State-funded primary	3348	9283348	141724	Primary converter academy	01/02/2015		1	370	92028	3699	3141	558	4.01943	3.41309	0.60634	28	7.56757	0	0	2554	175	202	0	0	0	z	12	198	3141	268	56	221	13	558	3699	z	z	2.7752423175555266	0.1901595166688399	0.2194984135263181	0	0	0	z	0.01303951	0.2151519102881732	3.4130916677532925	0.2912157169557091	0.060851045	0.2401443039075064	0.014126136	0.6063372017212153	4.0194288694745078	0	z
201617	Autumn and spring term	School	E92000001	England	E12000004	East Midlands	928	E10000021	Northamptonshire	State-funded primary	3350	9283350	142738	Primary converter academy	01/04/2016		1	185	45766	1915	1323	592	4.18433	2.89079	1.29354	20	10.81081	1	0.54054	1046	74	4	0	30	0	z	6	163	1323	157	1	434	0	592	1915	z	z	2.2855394834593366	0.1616920858279072	0.008740113	0	0.065550846	0	z	0.013110169	0.3561595944587685	2.8907922912205567	0.3430494253375869	0.002185028	0.9483022330988070	0	1.2935366866232574	4.1843289778438142	0	z
201617	Autumn and spring term	School	E92000001	England	E12000004	East Midlands	928	E10000021	Northamptonshire	State-funded primary	3408	9283408	141634	Primary converter academy	01/03/2015		1	223	46018	1907	1421	486	4.14403	3.08792	1.05611	23	10.3139	5	2.24215	1175	199	10	0	0	0	z	0	37	1421	424	9	53	0	486	1907	z	z	2.5533486896431831	0.4324394802033987	0.021730627	0	0	0	z	0	0.08040332	3.0879221174323091	0.9213785909861359	0.019557564	0.1151723238732670	0	1.0561084792907123	4.1440305967230214	0	z

---

Variables in this data set

Table showing first 5 of 49 variables

Variable name	Variable description
enrolments	Number of pupil enrolments
enrolments_pa_10_exact	Number of persistent absentees (10% or more missed)
enrolments_pa_10_exact_percent	Percentage of persistent absentees (10% or more missed)
enrolments_pa_50_exact	Number of severely absent pupils (50% or more missed)
enrolments_pa_50_exact_percent	Percentage of severely absent pupils (50% or more missed)

---

Footnotes

1. Sessions recorded as not attending due to COVID circumstances are included as possible sessions in 2020/21 and 2021/22 only, but not as an absence within absence rates.

---

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

---