Data set from Pupil absence in schools in England

Absence by geographic level - termly

Not the latest data

Published 17 October 2024

Last updated 17 October 2024

Termly 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.

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Pupil absence in schools in England
• Release: Autumn and spring term 2023/24
• Number of rows: 9,641
• Geographic levels: Local authority, National, Regional
• Indicators:
  • Authorised absence rate
  • Authorised holiday rate
  • Authorised other rate
  • Authorised reasons rate
  • Excluded rate
  • Extended authorised holiday rate
  • Illness rate
  • Late rate
  • Medical appointments rate
  • No reason yet rate
  • Number of authorised absence sessions
  • 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 reasons sessions
  • Number of persistent absentees - 10% or more sessions missed
  • Number of religious observance sessions
  • Number of sessions possible
  • Number of sessions recorded as exceptional circumstances
  • Number of sessions recorded as not attending due to COVID circumstances
  • Number of severe absentees - 50% or more sessions missed
  • Number of study leave sessions
  • Number of traveller sessions
  • Number of unauthorised absence sessions
  • Number of unauthorised holiday sessions
  • Number of unauthorised other sessions
  • Number of unauthorised reasons sessions
  • Overall absence rate
  • Overall reasons rate
  • Percentage of persistent absentees - 10% or more sessions missed
  • Percentage of severe absentees - 50% or more sessions missed
  • Rate of sessions recorded as not attending due to COVID circumstances
  • Religious observance rate
  • Study leave rate
  • Traveller rate
  • Unauthorised absence rate
  • Unauthorised holiday rate
  • Unauthorised other rate
  • Unauthorised reasons rate
• Filters:
  • School type
• Time period: 2018/19 Autumn term to 2023/24 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	education_phase	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
202324	Autumn term	National	E92000001	England						State-funded primary	529761067	27817950	20066294	7751656	5.25104	3.7878	1.46324	589912	15.41024	31101	0.81245	16129916	1227394	44380	674	59048	304351	z	138314	1748984	19653061	3058899	729003	3654114	165015	7607031	27260092	0	683112	3.04475	0.23169	0.00838	0.00013	0.01115	0.05745	0	0.02611	0.33015	3.7098	0.57741	0.13761	0.68977	0.03115	1.43594	5.14573	0
202324	Autumn term	National	E92000001	England						State-funded secondary	443689037	36159398	22930414	13228984	8.14972	5.16813	2.98159	768699	23.43968	103021	3.14138	17326519	1494288	30782	29545	18643	114616	z	1285062	2607271	22906726	1582390	814731	10539766	283535	13220422	36127148	0	2363196	3.9051	0.33679	0.00694	0.00666	0.0042	0.02583	0	0.28963	0.58763	5.16279	0.35664	0.18363	2.37548	0.0639	2.97966	8.14245	0
202324	Autumn term	National	E92000001	England						Special	18621804	2366567	1792867	573700	12.70858	9.62778	3.0808	49138	36.19022	8357	6.15495	1018214	173633	1026	94	1164	56060	z	32583	497992	1780766	64052	35793	453337	15412	568594	2349360	0	142645	5.46786	0.93242	0.00551	0.0005	0.00625	0.30104	0	0.17497	2.67424	9.5628	0.34396	0.19221	2.43444	0.08276	3.05338	12.61618	0
202324	Autumn term	National	E92000001	England						Total	992071908	66343915	44789575	21554340	6.68741	4.51475	2.17266	1407749	19.43517	142479	1.96704	34474649	2895315	76188	30313	78855	475027	z	1455959	4854247	44340553	4705341	1579527	14647217	463962	21396047	65736600	0	3188953	3.47502	0.29185	0.00768	0.00306	0.00795	0.04788	0	0.14676	0.4893	4.46949	0.47429	0.15921	1.47643	0.04677	2.1567	6.62619	0
202324	Spring term	National	E92000001	England						State-funded primary	402583906	22521280	17127949	5393331	5.59418	4.2545	1.33968	666737	17.51752	29540	0.77612	14116151	1008547	16410	193	39180	168892	z	112222	1340115	16801710	1519473	611256	3063328	113471	5307528	22109238	0	373101	3.50639	0.25052	0.00408	0.00005	0.00973	0.04195	0	0.02788	0.33288	4.17347	0.37743	0.15183	0.76092	0.02819	1.31837	5.49183	0

---

Variables in this data set

Table showing all 47 variables

Variable name	Variable description
education_phase	School type - Filter by school type - Total includes primary, secondary and special
enrolments_pa_10_exact	Number of persistent absentees - 10% or more sessions missed
enrolments_pa_10_exact_percent	Percentage of persistent absentees - 10% or more sessions missed
enrolments_pa_50_exact	Number of severe absentees - 50% or more sessions missed
enrolments_pa_50_exact_percent	Percentage of severe absentees - 50% or more sessions missed
sess_auth_appointments	Number of medical appointments sessions
sess_auth_appointments_rate	Medical appointments rate
sess_auth_excluded	Number of excluded sessions
sess_auth_excluded_rate	Excluded rate
sess_auth_ext_holiday	Number of extended authorised holiday sessions
sess_auth_ext_holiday_rate	Extended authorised holiday rate
sess_auth_holiday	Number of authorised holiday sessions
sess_auth_holiday_rate	Authorised holiday rate
sess_auth_illness	Number of illness sessions
sess_auth_illness_rate	Illness rate
sess_auth_other	Number of authorised other sessions
sess_auth_other_rate	Authorised other rate
sess_auth_religious	Number of religious observance sessions
sess_auth_religious_rate	Religious observance rate
sess_auth_study	Number of study leave sessions
sess_auth_study_rate	Study leave rate
sess_auth_totalreasons	Number of authorised reasons sessions
sess_auth_totalreasons_rate	Authorised reasons rate
sess_auth_traveller	Number of traveller sessions
sess_auth_traveller_rate	Traveller rate
sess_authorised	Number of authorised absence sessions
sess_authorised_percent	Authorised absence rate
sess_overall	Number of overall absence sessions
sess_overall_percent	Overall absence rate
sess_overall_totalreasons	Number of overall reasons sessions
sess_overall_totalreasons_rate	Overall reasons rate
sess_possible	Number of sessions possible
sess_unauth_holiday	Number of unauthorised holiday sessions
sess_unauth_holiday_rate	Unauthorised holiday rate
sess_unauth_late	Number of late sessions
sess_unauth_late_rate	Late rate
sess_unauth_noyet	Number of no reason yet sessions
sess_unauth_noyet_rate	No reason yet rate
sess_unauth_other	Number of unauthorised other sessions
sess_unauth_other_rate	Unauthorised other rate
sess_unauth_totalreasons	Number of unauthorised reasons sessions
sess_unauth_totalreasons_rate	Unauthorised reasons rate
sess_unauthorised	Number of unauthorised absence sessions
sess_unauthorised_percent	Unauthorised absence rate
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

---

Footnotes

1. Total includes state-funded primary, secondary and special schools. Data for special schools is available from 2016/17 to present.
2. 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

Python

import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/b9caf7eb-df30-46b7-8ce3-e55b8bbdba4e/csv")

R

read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/b9caf7eb-df30-46b7-8ce3-e55b8bbdba4e/csv")

---

Contact us

If you have a specific enquiry about Absence by geographic level - termly statistics and data:

Attendance and exclusions statistics team

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

---