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

03 - Enrolments with one or more sessions of absence

Not the latest data
Published
Last updated
The number of enrolments with one or more session of absence, including by reason for absence. National, Regional and Local Authority data from 2006/07. School data from 2016/17. Primary and secondary only before 2016/17.

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England: autumn term
Release type
Number of rows
114,619
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
2006/07 Autumn term to 2020/21 Autumn term

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameschool_typeestablaestaburnacademy_typeacademy_open_dateall_throughnum_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
202021Autumn termNationalE92000001EnglandTotal2116770567484617427421660915066063627670867307892011531254020506z9817865708512914223437211663641757114211898714873
202021Autumn termNationalE92000001EnglandTotal state-funded primary and secondary2012369420274525166412820214802333562027834874882311468250718402z9542162095812770723004611456211728084137340692918
202021Autumn termNationalE92000001EnglandState-funded primary1674438573912359052213178173270917962114026095506287185414949z1121231698195344148695517494657412012351281224
202021Autumn termNationalE92000001EnglandState-funded secondary337930846362166114199642174752417658164322653317111816533453z8420930397732363813516281271070672124989411694
202021Autumn termNationalE92000001EnglandSpecial104411472192261884072637365643324339763332104z275736127143543262074329037455821955

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

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/56418045-9e78-411a-ace8-22cdaf6878ff/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/56418045-9e78-411a-ace8-22cdaf6878ff/csv")

Contact us

If you have a specific enquiry about 03 - Enrolments with one or more sessions of absence statistics and data:

Absence and exclusions statistics

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