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

Enrolments with one or more session of absence, including by reason for absence - autumn and spring term combined

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: autumn and spring terms
Release type
Number of rows
109,271
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
2016/17 Autumn and spring term to 2021/22 Autumn and spring term

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameestabschool_laestabschool_urnschool_typeschool_nameacademy_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
201617Autumn and spring termNationalE92000001EnglandSpecial10159285486512850152824571778527396547117836399z4618270362726654520380437500
201617Autumn and spring termNationalE92000001EnglandState-funded primary1679038764323335008319504111305512851229984914285928564387694867z2457444814736886627244361064911495300
201617Autumn and spring termNationalE92000001EnglandState-funded secondary3399287099025074212422884868064217547389828119147710843129431744z11706547234715268013636863215514073700
201617Autumn and spring termNationalE92000001EnglandTotal21204684027659289415702940202686050984801935934483952115245253133010z146257947530524272415356126318426006500
201718Autumn and spring termNationalE92000001EnglandSpecial102298087921039053031419764525482640779816803z4649370213176762022851431800

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

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/7bc9c0d7-0a4c-4fda-be71-dd0f7cc173a6/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/7bc9c0d7-0a4c-4fda-be71-dd0f7cc173a6/csv")

Contact us

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

School census statistics team

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