Data set from Pupil absence in schools in England: autumn term

Absence rates by geographic level

Not the latest data

Published 28 May 2020

Last updated 28 May 2020

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. Primary and secondary only before 2016/17.

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Pupil absence in schools in England: autumn term
• Release: Autumn term 2019/20
• Number of rows: 294,956
• Geographic levels: Local authority, National, Regional
• Geographic levels (only available via download / public API): School
• 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 pupil enrolments
  • Number of religious observance sessions
  • Number of schools
  • Number of sessions possible
  • 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
  • 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: 2006/07 Autumn term to 2019/20 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	estab	laestab	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	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_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
2019	Autumn term	National	E92000001	England						Total							21183	7021552	981843584	48402628	35436952	12965676	4.92977	3.60923	1.32054	922566	13.13906	27945279	2647922	85566	34836	77056	548173	.	793934	2905654	35038420	3515082	696042	8185854	437905	12834883	47873303	2.846	0.27	0.009	0.004	0.008	0.056	.	0.081	0.296	3.569	0.358	0.071	0.834	0.045	1.307	4.876
2019	Autumn term	National	E92000001	England						Total state-funded primary and secondary							20152	6912848	966660881	46806667	34185550	12621117	4.8421	3.53646	1.30564	889912	12.8733	27232383	2487534	84582	34571	76012	498351	.	768841	2621752	33804026	3484550	676322	7909295	425047	12495214	46299240	2.817	0.257	0.009	0.004	0.008	0.052	.	0.08	0.271	3.497	0.36	0.07	0.818	0.044	1.293	4.79
2019	Autumn term	National	E92000001	England						State-funded primary							16761	3879003	544715693	23226008	17456890	5769118	4.26388	3.20477	1.05911	435745	11.23343	14158227	1178956	52663	769	53085	371985	.	114771	1177881	17108337	2381749	439713	2652950	179666	5654078	22762415	2.599	0.216	0.01	0	0.01	0.068	.	0.021	0.216	3.141	0.437	0.081	0.487	0.033	1.038	4.179
2019	Autumn term	National	E92000001	England						State-funded secondary							3391	3033845	421945188	23580659	16728660	6851999	5.58856	3.96465	1.62391	454167	14.97001	13074156	1308578	31919	33802	22927	126366	.	654070	1443871	16695689	1102801	236609	5256345	245381	6841136	23536825	3.099	0.31	0.008	0.008	0.005	0.03	.	0.155	0.342	3.957	0.261	0.056	1.246	0.058	1.621	5.578
2019	Autumn term	National	E92000001	England						Special							1031	108704	15182703	1595961	1251402	344559	10.5117	8.24229	2.26942	32654	30.03937	712896	160388	984	265	1044	49822	.	25093	283902	1234394	30532	19720	276559	12858	339669	1574063	4.695	1.056	0.006	0.002	0.007	0.328	.	0.165	1.87	8.13	0.201	0.13	1.822	0.085	2.237	10.367

---

Variables in this data set

Table showing all 44 variables

Variable name	Variable description
enrolments	Number of pupil enrolments
enrolments_PA_10_exact	Number of persistent absentees
enrolments_pa_10_exact_percent	Percentage of persistent absentees
num_schools	Number of schools
school_type	School type - Filter by school type
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

---

Footnotes

1. Total includes state-funded primary, secondary and special schools. Data for special schools is available from 2016/17 to present.
2. Total includes state-funded primary and secondary schools. Does not include special schools. Available from 2006/07 to present (data for special schools is available from 2016/17 onwards).

---

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/afe1f805-4831-4e76-a3ac-143b60540560/csv")

R

read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/afe1f805-4831-4e76-a3ac-143b60540560/csv")

---

Contact us

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

Absence and exclusions statistics

Email: schools.statistics@education.gov.uk
Contact name: School census statistics team

---