Data set from Pupil absence in schools in England

Absence sessions by reason

Latest data
API data set version 1.0
Published
Last updated
Reasons for absence sessions in full academic years for all pupils enrolments aged 5-15 in state-funded primary, state-funded secondary and special schools.

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England
API data set ID
019d209b-b031-7497-8205-af255b581d91
How do I use this ID?
Release type
Number of rows
266,041
Geographic levels
Local authority, National, Regional
Indicators
  • Number of sessions
  • Percentage of sessions
Filters
  • Absence reason
  • Attendance status
  • Attendance type
Time period
2006/07 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namephase_type_groupingattendance_statusattendance_typeattendance_reasonsession_countsession_percent
200910Academic yearLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primaryPossible sessionsAll possible sessionsAll possible sessions4481933z
200910Academic yearLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primaryAbsenceOverall absenceOverall absence2223054.96003
200910Academic yearLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primaryAbsenceAuthorisedAll authorised2004304.47195
200910Academic yearLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primaryAbsenceUnauthorisedAll unauthorised218750.48807
200910Academic yearLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primaryAbsenceAuthorisedIllness (i)1407933.141345486

Variables in this data set

Table showing first 5 of 6 variables
Variable nameVariable description
attendance_reasonAbsence reason - Filter by absence reason
attendance_statusAttendance status - Filter by absence or possible sessions
attendance_typeAttendance type - Filter by overall, authorised or unauthorised absence or possible sessions
phase_type_groupingSchool type - Filter by school type - Total includes primary, secondary and special
session_countNumber of sessions

Footnotes

  1. Total includes state-funded primary, state-funded secondary and special schools.
  2. Sessions recorded as not attending due to COVID circumstances are included as possible sessions in 2020/21 and 2021/22 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


Using the API

  • API documentation

    This data set is available via an API, follow the link to get all the information to get started. The documentation provides full guidance and examples on how to make the most from our data sets.

  • Building API integrations

    To support building integrations on top of the explore education statistics API, software development kits (SDKs) are provided to streamline common tasks and communication with the API.

API data set details

API data set name
Absence sessions by reason
API data set ID
019d209b-b031-7497-8205-af255b581d91
API data set version
1.0

Download data set as CSV

Get familiar with the data. The CSV response will render its categories and column headers in a human-readable format (instead of machine-readable IDs).

Guidance: Download data set as CSV

Data set metadata

Look up human-readable labels and their corresponding machine-readable IDs to help you create data set queries.

Guidance: Get data set metadata

Query data set using GET

Quickly test the machine-readable IDs in a range of basic queries.

Guidance: Query data set (GET)

Query data set using POST

The POST endpoint is recommended for production level pipeline queries. POST requires a query to be built and supplied in JSON format using third party software such as Postman and Insomnia or programming languages such as Python, R, etc.

Guidance: Query data set (POST)

Get data set summary

Guidance: Get data set summary


API data set version history

API data set updates come in 3 forms: Major, Minor and Patch.

  • Major update (e.g. 1.x.x to 2.0.0): a breaking change meaning the removal of columns or rows from the data set.
  • Minor update (e.g. 1.1.x to 1.2.0): non-breaking changes made as part of a new release (likely with new / additional data).
  • Patch update (e.g. 1.1.0 to 1.1.1): a non-breaking change made as part of a release amendment (e.g. data corrections).

More detailed information on versioning can be found in our Versioning - Explore education statistics API.


Contact us

If you have a specific enquiry about Absence sessions by reason statistics and data:

Attendance and exclusions statistics team

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