Data set from Pupil absence in schools in England: autumn and spring terms

01 (termly) - Absence rates by geographic level - Termly data

Not the latest data

Published 21 October 2021

Last updated 21 October 2021

Termly absence information for Autumn and Spring term 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: autumn and spring terms
• Release: Autumn and spring term 2020/21
• Number of rows: 17,512
• 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
  • 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 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
  • Persistent absentee rate
  • 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: 2012/13 Autumn term to 2020/21 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	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	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
202021	Autumn term	National	E92000001	England						State-funded primary	527232251	19408124	13911721	5496403	3.68113	2.63863	1.0425	380994	9.87691	10721078	782299	13976	630	90539	98147	:	65152	1852513	13624334	827779	311856	4025687	237791	5403113	19027447	29073659	1623590	2.03346	0.14838	0.00265	0.00012	0.01717	0.01862	0	0.01236	0.35137	2.58412	0.157	0.05915	0.76355	0.0451	1.02481	3.60893	5.51439
202021	Autumn term	National	E92000001	England						State-funded secondary	413010410	23515104	16121740	7393364	5.69359	3.90347	1.79012	501642	16.26256	12569535	920813	7578	74575	17856	23362	:	579546	1900654	16093919	338089	182734	6451472	414371	7386666	23480585	36071358	2622337	3.04339	0.22295	0.00183	0.01806	0.00432	0.00566	0	0.14032	0.4602	3.89673	0.08186	0.04424	1.56206	0.10033	1.78849	5.68523	8.73376
202021	Autumn term	National	E92000001	England						Special	15436745	1633821	1273344	360477	10.58397	8.24879	2.33519	33498	29.19928	609127	105374	292	179	1255	17070	:	17790	506394	1257481	16234	12368	315390	12248	356240	1613721	1499767	185439	3.94595	0.68262	0.00189	0.00116	0.00813	0.11058	0	0.11524	3.28045	8.14602	0.10516	0.08012	2.04311	0.07934	2.30774	10.45376	9.71557
202021	Autumn term	National	E92000001	England						State-funded primary and secondary	940242661	42923228	30033461	12889767	4.56512	3.19422	1.3709	882636	12.71432	23290613	1703112	21554	75205	108395	121509	:	644698	3753167	29718253	1165868	494590	10477159	652162	12789779	42508032	65145017	4245927	2.47709	0.18114	0.00229	0.008	0.01153	0.01292	0	0.06857	0.39917	3.1607	0.124	0.0526	1.1143	0.06936	1.36026	4.52096	6.92853
202021	Autumn term	National	E92000001	England						Total	955679406	44557049	31306805	13250244	4.66234	3.27587	1.38647	916134	12.98231	23899740	1808486	21846	75384	109650	138579	:	662488	4259561	30975734	1182102	506958	10792549	664410	13146019	44121753	66644784	4431366	2.50081	0.18924	0.00229	0.00789	0.01147	0.0145	0	0.06932	0.44571	3.24123	0.12369	0.05305	1.12931	0.06952	1.37557	4.61679	6.97355

---

Variables in this data set

Table showing all 45 variables

Variable name	Variable description
enrolments_pa_10_exact	Number of persistent absentees
enrolments_pa_10_exact_percent	Persistent absentee rate
school_type	School type - Filter by school type - Total includes primary, secondary and special
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

---

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/40aa76a7-55f7-4abb-84e3-9153d764976f/csv")

R

read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/40aa76a7-55f7-4abb-84e3-9153d764976f/csv")

---

Contact us

If you have a specific enquiry about 01 (termly) - Absence rates by geographic level - Termly data statistics and data:

School census statistics team

Email: schools.statistics@education.gov.uk
Contact name: Sean Gibson

---