Data set from Pupil absence in schools in England

02 - Enrolments with one or more session of absence, including by reason for absence

Not the latest data
Published
Last updated
The number of enrolments with one or more session of absence, including by reason for absence. Includes school level data.

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England
Release type
Number of rows
153,644
Geographic levels
Local authority, National, Regional
Geographic levels (only available via download / public API)
School
Indicators
  • Number of enrolments with at least one absence session due to agreed extended family holiday
  • Number of enrolments with at least one absence session due to agreed family holiday
  • Number of enrolments with at least one absence session due to arriving late
  • Number of enrolments with at least one absence session due to exceptional circumstances
  • Number of enrolments with at least one absence session due to exclusion
  • Number of enrolments with at least one absence session due to family holiday not agreed
  • Number of enrolments with at least one absence session due to illness
  • Number of enrolments with at least one absence session due to medical or dental appointments
  • Number of enrolments with at least one absence session due to no reason yet
  • Number of enrolments with at least one absence session due to not attending due to COVID circumstances
  • Number of enrolments with at least one absence session due to other authorised circumstances
  • Number of enrolments with at least one absence session due to other unauthorised circumstances
  • Number of enrolments with at least one absence session due to religious observance
  • Number of enrolments with at least one absence session due to study leave
  • Number of enrolments with at least one absence session due to traveller absence
  • Number of enrolments with at least one authorised absence session
  • Number of enrolments with at least one overall absence session
  • Number of enrolments with at least one unauthorised absence session
  • Number of pupil enrolments
  • Number of schools
Filters
  • School type
Time period
2012/13 to 2020/21

Data set preview

Table showing first 5 rows, from underlying data
time_identifieryear_breakdowntime_periodgeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameestabschool_laestabschool_urnacademy_typeacademy_open_dateall_throughschool_typeschool_nametrustnum_schoolsenrolmentsenrol_overallenrol_authorisedenrol_unauthorisedenrol_auth_illnessenrol_auth_appointmentsenrol_auth_religiousenrol_auth_studyenrol_auth_travellerenrol_auth_holidayenrol_auth_ext_holidayenrol_auth_excludedenrol_auth_otherenrol_unauth_holidayenrol_unauth_lateenrol_unauth_otherenrol_unauth_noyetenrol_x_covidenrol_y_exceptional
Academic yearSix half terms202021NationalE92000001EnglandTotal2125672230886236883595519127284395081982179637868621990589523770404z1776831728781390516498789208174540016669327912733024
Academic yearSix half terms202021NationalE92000001EnglandState-funded primary1679839567273345051317181814018242670559870366386351598382453086z219958521162973103074429675351549113760473992261
Academic yearSix half terms202021NationalE92000001EnglandState-funded secondary34053147760277784326707291282660232188686717129004089743134910808z15108379322289011182767108007823886230697461683958
Academic yearSix half terms202021NationalE92000001EnglandSpecial10531186011139891126444395589537588419828248646510z4605834434195858034132639310257256805
Academic yearSix half terms202021RegionalE92000001EnglandE12000001North EastTotal1093334364285858271514127573239123784111271918903414682z106527723623701155289702919446324506111378

Variables in this data set

Table showing all 21 variables
Variable nameVariable description
enrol_auth_appointmentsNumber of enrolments with at least one absence session due to medical or dental appointments
enrol_auth_excludedNumber of enrolments with at least one absence session due to exclusion
enrol_auth_ext_holidayNumber of enrolments with at least one absence session due to agreed extended family holiday
enrol_auth_holidayNumber of enrolments with at least one absence session due to agreed family holiday
enrol_auth_illnessNumber of enrolments with at least one absence session due to illness
enrol_auth_otherNumber of enrolments with at least one absence session due to other authorised circumstances
enrol_auth_religiousNumber of enrolments with at least one absence session due to religious observance
enrol_auth_studyNumber of enrolments with at least one absence session due to study leave
enrol_auth_travellerNumber of enrolments with at least one absence session due to traveller absence
enrol_authorisedNumber of enrolments with at least one authorised absence session
enrol_overallNumber of enrolments with at least one overall absence session
enrol_unauth_holidayNumber of enrolments with at least one absence session due to family holiday not agreed
enrol_unauth_lateNumber of enrolments with at least one absence session due to arriving late
enrol_unauth_noyetNumber of enrolments with at least one absence session due to no reason yet
enrol_unauth_otherNumber of enrolments with at least one absence session due to other unauthorised circumstances
enrol_unauthorisedNumber of enrolments with at least one unauthorised absence session
enrol_x_covidNumber of enrolments with at least one absence session due to not attending due to COVID circumstances
enrol_y_exceptionalNumber of enrolments with at least one absence session due to exceptional circumstances
enrolmentsNumber of pupil enrolments
num_schoolsNumber of schools
school_typeSchool type - Filter by school type

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 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/48c898e8-f183-4c2f-9b84-1170b44daea9/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/48c898e8-f183-4c2f-9b84-1170b44daea9/csv")

Contact us

If you have a specific enquiry about 02 - Enrolments with one or more session of absence, including by reason for absence statistics and data:

Attendance and exclusions statistics team

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