Data set from Pupil absence in schools in England

Absence by pupil characteristics - termly

Not the latest data
Published
Last updated
Absence information at national level for the full academic year, by each term, by pupil characteristics including SEN, FSM, language, year group, gender and ethnicity for England.

Data set details

Theme
Pupils and schools
Publication
Pupil absence in schools in England
Release type
Number of rows
3,342
Geographic levels
National
Indicators
  • Authorised absence rate
  • Authorised absence rate exact
  • Number of authorised absence sessions
  • Number of authorised absence sessions for persistent absentees
  • Number of authorised holiday sessions
  • Number of authorised other sessions
  • Number of authorised reasons sessions
  • Number of excluded 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 absence sessions for persistent absentees
  • Number of overall reasons sessions
  • Number of persistent absentees
  • Number of pupil enrolments
  • Number of religious observance sessions
  • Number of sessions possible
  • Number of sessions possible for persistent absentees
  • Number of sessions recorded as exceptional circumstances
  • Number of sessions recorded as not attending due to COVID circumstances
  • Number of study leave sessions
  • Number of traveller sessions
  • Number of unauthorised absence sessions
  • Number of unauthorised absence sessions for persistent absentees
  • Number of unauthorised holiday sessions
  • Number of unauthorised other sessions
  • Number of unauthorised reasons sessions
  • Overall absence rate
  • Overall absence rate exact
  • Percentage of persistent absentees
  • Rate of authorised holiday sessions
  • Rate of authorised other sessions
  • Rate of authorised reasons sessions
  • Rate of excluded sessions
  • Rate of illness sessions
  • Rate of late sessions
  • Rate of medical appointments sessions
  • Rate of no reason yet sessions
  • Rate of overall reasons sessions
  • Rate of religious observance sessions
  • Rate of sessions recorded as exceptional circumstances
  • Rate of sessions recorded as not attending due to COVID circumstances
  • Rate of study leave sessions
  • Rate of traveller sessions
  • Rate of unauthorised holiday sessions
  • Rate of unauthorised other sessions
  • Rate of unauthorised reasons sessions
  • Unauthorised absence rate
  • Unauthorised absence rate exact
Filters
  • Characteristic
  • School type
Time period
2018/19 Autumn term to 2023/24 Summer term

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameeducation_phasecharacteristicenrolmentssess_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_exactsess_auth_illnesssess_auth_appointmentssess_auth_religioussess_auth_studysess_auth_travellersess_auth_holidaysess_auth_excludedsess_auth_othersess_auth_totalreasonssess_unauth_holidaysess_unauth_latesess_unauth_othersess_unauth_noyetsess_unauth_totalreasonssess_overall_totalreasonssess_x_covidsess_y_exceptionalsess_auth_illness_ratesess_auth_appointments_ratesess_auth_religious_ratesess_auth_study_ratesess_auth_traveller_ratesess_auth_holiday_ratesess_auth_excluded_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_ratesess_y_exceptional_rate
202324Autumn termNationalE92000001EnglandTotalEthnicity Major Any Other Ethnic Group1726122300019413283828412944870885.775533.657772.117762928516.9658358861473638739957833680920.5200949411.134605179.385489774631171680832229728259114692340198020835360122812302163136111808548472413200840700272.7441985920.2960105470.0096912230.0031651910.0011260770.0498647970.101742620.4261703183.6319693650.5339607140.1313728051.3635145860.0786297722.1074778765.73944724100.304462649
202324Autumn termNationalE92000001EnglandTotalEthnicity Major Asian Total9339951270681747029152472900823001445.53183.721631.8101715226516.302551984750238072922126357168093519.1827263710.713474178.4692522013803382306214499257633116736486570638840146950259563631303251144155539652284808697983303585122.9931822270.2409840250.0392899330.0060070129.12896E-050.0579594380.051709250.3056634783.6948866520.7526377140.1025630540.9004260970.0424693281.7980961945.49298284600.282141459
202324Autumn termNationalE92000001EnglandTotalEthnicity Major Black Total46043961305703268393117543589295734.377952.861661.516295527012.003766781265139819478377961441520.6184834211.558005779.0604776541277775137357206919433502117871995230889174355616170810461161786241188925369266892501652722.0842677560.2240525650.003374890.0031693630.0005709090.034544910.1174360560.3766191212.844035570.2637731760.1706382851.0078377210.0671846141.5094337964.35346936600.269586665
202324Autumn termNationalE92000001EnglandTotalEthnicity Major Mixed Total502846686295804776510312458716519236.959844.552832.4070110475720.832821376909030447621723727132103522.1130227212.51881579.5942070252387734198297489323892513581811247435441430962702905661633031149536382731641678473794801905363.4791616090.2889380930.0071295790.0034810060.0003657320.0521903240.1638856020.5164158084.5115677530.4233830370.2379484181.6749862090.0557674992.3920851626.90365291500.277629559
202324Autumn termNationalE92000001EnglandTotalEthnicity Major Unclassified1182021563710313073917905625168298.360835.055683.305152969525.12225367101591895048218243676825.0325863613.1348414511.897744957578849495121954781579143485811099678163271180367253923021298751319412948260572833.6821910040.3165228240.0077955620.003498090.0052119630.0506103980.2229185290.7098245764.9985729450.4551994060.2348580812.5087895120.0830524683.2818994678.28047241200.366327446

Variables in this data set

Table showing all 53 variables
Variable nameVariable description
characteristicCharacteristic - Filter by characteristic
education_phaseSchool type - Filter by school type - Total includes primary, secondary and special
enrolmentsNumber of pupil enrolments
enrolments_pa_10_exactNumber of persistent absentees
enrolments_pa_10_exact_percentPercentage of persistent absentees
sess_auth_appointmentsNumber of medical appointments sessions
sess_auth_appointments_rateRate of medical appointments sessions
sess_auth_excludedNumber of excluded sessions
sess_auth_excluded_rateRate of excluded sessions
sess_auth_holidayNumber of authorised holiday sessions
sess_auth_holiday_rateRate of authorised holiday sessions
sess_auth_illnessNumber of illness sessions
sess_auth_illness_rateRate of illness sessions
sess_auth_otherNumber of authorised other sessions
sess_auth_other_rateRate of authorised other sessions
sess_auth_religiousNumber of religious observance sessions
sess_auth_religious_rateRate of religious observance sessions
sess_auth_studyNumber of study leave sessions
sess_auth_study_rateRate of study leave sessions
sess_auth_totalreasonsNumber of authorised reasons sessions
sess_auth_totalreasons_rateRate of authorised reasons sessions
sess_auth_travellerNumber of traveller sessions
sess_auth_traveller_rateRate of traveller sessions
sess_authorisedNumber of authorised absence sessions
sess_authorised_pa_10_exactNumber of authorised absence sessions for persistent absentees
sess_authorised_percentAuthorised absence rate
sess_authorised_percent_pa_10_exactAuthorised absence rate exact
sess_overallNumber of overall absence sessions
sess_overall_pa_10_exactNumber of overall absence sessions for persistent absentees
sess_overall_percentOverall absence rate
sess_overall_percent_pa_10_exactOverall absence rate exact
sess_overall_totalreasonsNumber of overall reasons sessions
sess_overall_totalreasons_rateRate of overall reasons sessions
sess_possibleNumber of sessions possible
sess_possible_pa_10_exactNumber of sessions possible for persistent absentees
sess_unauth_holidayNumber of unauthorised holiday sessions
sess_unauth_holiday_rateRate of unauthorised holiday sessions
sess_unauth_lateNumber of late sessions
sess_unauth_late_rateRate of late sessions
sess_unauth_noyetNumber of no reason yet sessions
sess_unauth_noyet_rateRate of no reason yet sessions
sess_unauth_otherNumber of unauthorised other sessions
sess_unauth_other_rateRate of unauthorised other sessions
sess_unauth_totalreasonsNumber of unauthorised reasons sessions
sess_unauth_totalreasons_rateRate of unauthorised reasons sessions
sess_unauthorisedNumber of unauthorised absence sessions
sess_unauthorised_pa_10_exactNumber of unauthorised absence sessions for persistent absentees
sess_unauthorised_percentUnauthorised absence rate
sess_unauthorised_percent_pa_10_exactUnauthorised absence rate exact
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
sess_y_exceptional_rateRate of sessions recorded as exceptional circumstances

Footnotes

  1. 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.
  2. From 2023/24 the school census data item ‘sex’ replaced ‘gender’. Historical use of the word “gender” in the data collection may have meant that “gender identity” was reported in some cases, as opposed to legal sex. While this is unlikely to have a significant effect on overall figures, it may affect figures in more granular subdivisions. Time-series in this publication prior to spring 2023 which contained gender as a category may be affected.
  3. EHC plans – A pupil has an EHC plan when a formal assessment has been made. A document is in place that sets out the child’s need and the extra help they should receive. EHC plans were introduced in September 2014 replacing Statements of SEN, with these being phased out by April 2018. This category therefore includes Statements of SEN for the years up to 2018.
  4. Total includes state-funded primary, secondary and special schools.

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/f573e34a-3463-4275-ac9f-7d85f8e1f865/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/f573e34a-3463-4275-ac9f-7d85f8e1f865/csv")

Contact us

If you have a specific enquiry about Absence by pupil characteristics - termly statistics and data:

Attendance and exclusions statistics team

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