Data set from Pupil absence in schools in England

Absence rates by geographic level

Not the latest data
Published
Last updated
Absence information for full academic years for all enrolments in state-funded primary, state-funded secondary and special schools including information on overall absence, persistent absence and reason for absence for pupils aged 5-15.

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England
Release type
Number of rows
11,567
Geographic levels
Local authority, National, Regional
Indicators
  • Overall absence rate
  • Percentage of persistent absentees (10% or more missed)
  • Number of schools
  • Number of pupil enrolments
  • Number of sessions possible
  • Number of overall absence sessions
  • Number of authorised absence sessions
  • Number of unauthorised absence sessions
  • Authorised absence rate
  • Unauthorised absence rate
  • Number of persistent absentees (10% or more missed)
  • Overall absence rate (persistent absentees only)
  • Authorised absence rate (persistent absentees only)
  • Unauthorised absence rate (persistent absentees only)
  • Number of sessions possible (persistent absentees only)
  • Number of overall absence sessions (persistent absentees only)
  • Number of authorised absence sessions (persistent absentees only)
  • Number of unauthorised absence sessions (persistent absentees only)
  • Number of severe absentees (50% or more missed)
  • Percentage of severe absentees (50% or more missed)
  • 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 interview sessions
  • Number of late sessions
  • Number of medical appointments sessions
  • Number of regulated performance sessions
  • Number of religious observance sessions
  • Number of study leave sessions
  • Number of temporary reduced timetable sessions
  • Number of traveller sessions
  • Number of unauthorised holiday sessions
  • Number of unauthorised other sessions
  • Number of unauthorised reasons sessions
  • Number of no reason yet sessions
  • Number of overall reasons sessions
  • Authorised holiday rate
  • Authorised other rate
  • Authorised reasons rate
  • Excluded rate
  • Extended authorised holiday rate
  • Illness rate
  • Interview rate
  • Late rate
  • Medical appointments rate
  • Regulated performance rate
  • Religious observance rate
  • Study leave rate
  • Temporary reduced timetable rate
  • Traveller rate
  • Unauthorised holiday rate
  • Unauthorised other rate
  • Unauthorised reasons rate
  • No reason yet rate
  • Overall reasons rate
  • Number of sessions recorded as exceptional circumstances
  • Number of sessions recorded as not attending due to COVID circumstances
  • Number of sessions recorded as unable to attend because of access arrangements
  • Rate of sessions recorded as not attending due to COVID circumstances
Filters
  • School type
Time period
2006/07 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifieryear_breakdowngeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameeducation_phasenum_schoolsenrolmentssess_possiblesess_overallsess_authorisedsess_unauthorisedsess_overall_percentsess_authorised_percentsess_unauthorised_percentenrolments_pa_10_exactenrolments_pa_10_exact_percentsess_possible_pa_10_exactsess_overall_pa_10_exactsess_authorised_pa_10_exactsess_unauthorised_pa_10_exactsess_overall_percent_pa_10_exactsess_authorised_percent_pa_10_exactsess_unauthorised_percent_pa_10_exactenrolments_pa_50_exactenrolments_pa_50_exact_percentsess_auth_illnesssess_auth_appointmentssess_auth_religioussess_auth_studysess_auth_travellersess_auth_holidaysess_auth_ext_holidaysess_auth_excludedsess_auth_interviewsess_auth_reg_performancesess_auth_temp_reduced_timetablesess_auth_othersess_auth_totalreasonssess_unauth_holidaysess_unauth_latesess_unauth_othersess_unauth_noyetsess_unauth_totalreasonssess_overall_totalreasonssess_x_covidsess_y_exceptionalsess_q_la_arrangementssess_auth_illness_ratesess_auth_appointments_ratesess_auth_religious_ratesess_auth_study_ratesess_auth_traveller_ratesess_auth_holiday_ratesess_auth_ext_holiday_ratesess_auth_excluded_ratesess_auth_interview_ratesess_auth_reg_performance_ratesess_auth_temp_reduced_timetable_ratesess_auth_other_ratesess_auth_totalreasons_ratesess_unauth_holiday_ratesess_unauth_late_ratesess_unauth_other_ratesess_unauth_noyet_ratesess_unauth_totalreasons_ratesess_overall_totalreasons_ratesess_x_covid_rate
200910Academic yearFive half termsLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded primary64151034481933222305200430218754.960034.471950.48807191712.6928453658480437674901294714.9905712.577712.41286360.2383614079310529181409224649232720zzz21601200430431934411322788821875222305zzz3.1413454860.2349209590.04047360800.0020526860.5499635980.0051763380.016064497zzz0.4819572274.47195440.0963646710.0767749090.29511820.019812880.4880706614.960025061z
200910Academic yearFive half termsLocal authorityE92000001EnglandE12000005West Midlands334E08000029SolihullState-funded secondary14157134746468326299274915513846.874565.791991.08257327920.868079645981812981389254237318.7951914.402374.392811480.9419189870207481722907520713237105610545zzz284552749153724274041965295551384326299zzz4.000237650.4371250370.0362796080.19119480.0043611380.2788810540.0222481220.222165197zzz0.5994984065.7919910130.078458340.0577271350.8841311050.0622568191.08257346.874564413z
200910Academic yearFive half termsLocal authorityE92000001EnglandE12000005West Midlands335E08000030WalsallState-funded secondary19178355305298381806304753770537.196695.744311.45238407222.8315111814212202301611105912018.6411113.636975.004141750.9812221021925142332730343271041145912738zzz390963047539096178362958321677053381806zzz3.9624352860.4739036340.0627108980.0571881160.006163650.1962377990.0086517290.240099614zzz0.7369237325.7443144570.1714512550.0336079141.186700540.060618651.4523783587.196692815z
200910Academic yearFive half termsLocal authorityE92000001EnglandE12000005West Midlands336E08000031WolverhamptonState-funded primary76170525009402304961259730452316.087775.184850.90292341820.044579558591472621170293023315.4062512.243333.16291590.3461797061029622582705373262082506zzz268492597303615190329753996045231304961zzz3.5873743010.2055335150.0450752413.99249E-050.0140735360.7451188780.0415618470.010101006zzz0.5359721585.1848504070.0721643020.0379885660.5939431490.1988261270.9029221456.087772552z
200910Academic yearFive half termsLocal authorityE92000001EnglandE12000005West Midlands860E10000028StaffordshireState-funded primary2955002214912021752885708855440305.048854.753580.29527652813.0502618505562761182471492896914.9208113.355391.56542870.1739248661234051327310249712747625012452zzz499817088536329503228425424444030752883zzz3.2632196530.2283459770.0219487356.706E-050.016744880.8548539460.0167717040.01644311zzz0.3351725434.7535676080.0424422690.0337445880.1906180260.028460260.2952651425.04883275z

Variables in this data set

Table showing all 63 variables
Variable nameVariable description
education_phaseSchool type - Filter by school type - Total includes primary, secondary and special
enrolmentsNumber of pupil enrolments
enrolments_pa_10_exactNumber of persistent absentees (10% or more missed)
enrolments_pa_10_exact_percentPercentage of persistent absentees (10% or more missed)
enrolments_pa_50_exactNumber of severe absentees (50% or more missed)
enrolments_pa_50_exact_percentPercentage of severe absentees (50% or more missed)
num_schoolsNumber of schools
sess_auth_appointmentsNumber of medical appointments sessions
sess_auth_appointments_rateMedical appointments rate
sess_auth_excludedNumber of excluded sessions
sess_auth_excluded_rateExcluded rate
sess_auth_ext_holidayNumber of extended authorised holiday sessions
sess_auth_ext_holiday_rateExtended authorised holiday rate
sess_auth_holidayNumber of authorised holiday sessions
sess_auth_holiday_rateAuthorised holiday rate
sess_auth_illnessNumber of illness sessions
sess_auth_illness_rateIllness rate
sess_auth_interviewNumber of interview sessions
sess_auth_interview_rateInterview rate
sess_auth_otherNumber of authorised other sessions
sess_auth_other_rateAuthorised other rate
sess_auth_reg_performanceNumber of regulated performance sessions
sess_auth_reg_performance_rateRegulated performance rate
sess_auth_religiousNumber of religious observance sessions
sess_auth_religious_rateReligious observance rate
sess_auth_studyNumber of study leave sessions
sess_auth_study_rateStudy leave rate
sess_auth_temp_reduced_timetableNumber of temporary reduced timetable sessions
sess_auth_temp_reduced_timetable_rateTemporary reduced timetable rate
sess_auth_totalreasonsNumber of authorised reasons sessions
sess_auth_totalreasons_rateAuthorised reasons rate
sess_auth_travellerNumber of traveller sessions
sess_auth_traveller_rateTraveller rate
sess_authorisedNumber of authorised absence sessions
sess_authorised_pa_10_exactNumber of authorised absence sessions (persistent absentees only)
sess_authorised_percentAuthorised absence rate
sess_authorised_percent_pa_10_exactAuthorised absence rate (persistent absentees only)
sess_overallNumber of overall absence sessions
sess_overall_pa_10_exactNumber of overall absence sessions (persistent absentees only)
sess_overall_percentOverall absence rate
sess_overall_percent_pa_10_exactOverall absence rate (persistent absentees only)
sess_overall_totalreasonsNumber of overall reasons sessions
sess_overall_totalreasons_rateOverall reasons rate
sess_possibleNumber of sessions possible
sess_possible_pa_10_exactNumber of sessions possible (persistent absentees only)
sess_q_la_arrangementsNumber of sessions recorded as unable to attend because of access arrangements
sess_unauth_holidayNumber of unauthorised holiday sessions
sess_unauth_holiday_rateUnauthorised holiday rate
sess_unauth_lateNumber of late sessions
sess_unauth_late_rateLate rate
sess_unauth_noyetNumber of no reason yet sessions
sess_unauth_noyet_rateNo reason yet rate
sess_unauth_otherNumber of unauthorised other sessions
sess_unauth_other_rateUnauthorised other rate
sess_unauth_totalreasonsNumber of unauthorised reasons sessions
sess_unauth_totalreasons_rateUnauthorised reasons rate
sess_unauthorisedNumber of unauthorised absence sessions
sess_unauthorised_pa_10_exactNumber of unauthorised absence sessions (persistent absentees only)
sess_unauthorised_percentUnauthorised absence rate
sess_unauthorised_percent_pa_10_exactUnauthorised absence rate (persistent absentees only)
sess_x_covidNumber of sessions recorded as not attending due to COVID circumstances
sess_x_covid_rateRate of sessions recorded as not attending due to COVID circumstances
sess_y_exceptionalNumber of sessions recorded as exceptional circumstances

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

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/d37f27c4-cca2-4274-97e9-1cdcb4ecad18/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/d37f27c4-cca2-4274-97e9-1cdcb4ecad18/csv")

Contact us

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

Attendance and exclusions statistics team

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