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

Absence by geographic level

Not the latest data
Published
Last updated

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England: autumn term
Release type
Number of rows
268,953
Geographic levels
Local authority, National, Regional
Geographic levels (only available via download / public API)
School
Indicators
  • Authorised absence 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
  • Percentage of persistent absentees
  • Unauthorised absence rate
Filters
  • School type
Time period
2006/07 Autumn term to 2018/19 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_schoolsenrolmentssess_possiblesess_overallsess_authorisedsess_unauthorisedsess_overall_percentsess_authorised_percentsess_unauthorised_percentenrolments_pa_10_exactenrolments_pa_10_exact_percentsess_auth_illnesssess_auth_appointmentssess_auth_religioussess_auth_studysess_auth_travellersess_auth_holidaysess_auth_ext_holidaysess_auth_excludedsess_auth_othersess_auth_totalreasonssess_unauth_holidaysess_unauth_latesess_unauth_othersess_unauth_noyetsess_unauth_totalreasonssess_overall_totalreasons
2018Autumn termNationalE92000001EnglandState-funded primary and secondary2012168350599568507054026624928896524113697254.208213.019961.1882473104710.695552229722424663901032733477482085533368.698210238892328604247344652061327767564304479201126414739868394
2018Autumn termNationalE92000001EnglandState-funded primary167393885774546418050201592081472167254375363.689342.694210.995123577429.206451155824811758296478148460396395846.10788210974011446086723688344106012376288186821534254419803411
2018Autumn termNationalE92000001EnglandState-funded secondary33822949285410432655201070411417485259321894.898993.453641.4453537330512.65747107389761290561384923429021689137522.59032812915221414338010776862026764380142261099592160320064983
2018Autumn termRegionalE92000001EnglandE12000001North EastState-funded primary and secondary103331761645421902209866614194476792194.620383.125031.495363930012.37343111053110187678833529641515.49905102516141246023563716453400524250086776222090082
2018Autumn termRegionalE92000001EnglandE12000001North EastState-funded primary858175079251559939814496958892855603.901452.76631.135161807310.322775712304958451613447630064.3312352846944791558351202410596811061284888979367

Variables in this data set

Table showing all 28 variables
Variable nameVariable description
enrolmentsNumber of pupil enrolments
enrolments_pa_10_exactNumber of persistent absentees
enrolments_pa_10_exact_percentPercentage of persistent absentees
num_schoolsNumber of schools
school_typeSchool type - Filter by school type
sess_auth_appointmentsNumber of medical appointments sessions
sess_auth_excludedNumber of excluded sessions
sess_auth_ext_holidayNumber of extended authorised holiday sessions
sess_auth_holidayNumber of authorised holiday sessions
sess_auth_illnessNumber of illness sessions
sess_auth_otherNumber of authorised other sessions
sess_auth_religiousNumber of religious observance sessions
sess_auth_studyNumber of study leave sessions
sess_auth_totalreasonsNumber of authorised reasons sessions
sess_auth_travellerNumber of traveller sessions
sess_authorisedNumber of authorised absence sessions
sess_authorised_percentAuthorised absence rate
sess_overallNumber of overall absence sessions
sess_overall_percentOverall absence rate
sess_overall_totalreasonsNumber of overall reasons sessions
sess_possibleNumber of sessions possible
sess_unauth_holidayNumber of unauthorised holiday sessions
sess_unauth_lateNumber of late sessions
sess_unauth_noyetNumber of no reason yet sessions
sess_unauth_otherNumber of unauthorised other sessions
sess_unauth_totalreasonsNumber of unauthorised reasons sessions
sess_unauthorisedNumber of unauthorised absence sessions
sess_unauthorised_percentUnauthorised absence rate

Footnotes

  1. Pupil enrolments missing 10 percent or more of their own possible sessions (due to authorised or unauthorised absence) are classified as persistent absentees.
  2. Absence rates are the number of absence sessions expressed as a percentage of the total number of possible sessions.
  3. Includes all schools with at least six enrolments who reported absence information via the school census for the associated academic year.
  4. State-funded secondary schools include city technology colleges and all secondary academies, including all-through academies and free schools.
  5. The definition of persistent absence changed from the 2015/16 academic year - The information presented for years prior to 2015/16 has been produced using the same methodology in order to allow users to make comparisons on a consistent basis over time.
  6. State-funded primary schools include all primary academies, including free schools.
  7. The percentage of persistent absentees is the number of persistent absentees expressed as a percentage of the total number of enrolments.
  8. Number of enrolments includes pupils on the school roll for at least one session who are aged between 5 and 15, excluding boarders. Some pupils may be counted more than once (if they moved schools during the academic year or are registered in more than one school).

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/09d7bdca-25f3-49b2-9a85-25e07f5f64c7/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/09d7bdca-25f3-49b2-9a85-25e07f5f64c7/csv")

Contact us

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

Absence and exclusions statistics

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