Data set from Pupil absence in schools in England

Absence rates by pupil characteristic - 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
Geographic levels
National
Indicators
  • Authorised absence rate
  • Authorised absence rate exact
  • Number of authorised absence sessions
Filters
  • Characteristic
  • School type
Time period
2018/19 Autumn term to 2021/22 Summer term

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameschool_typecharacteristicenrolmentssess_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
201819Spring termNationalE92000001EnglandState-funded secondaryNC Year 8587999699261273648810264754710012635.218093.786211.431898487314.0856197940941960135121384574629020.01343871112529612.39364253600187.61979617512349920648522114842368773679167321194862245532643231124683278208063144158710004043643635002.95290485629212670.30243917270006960.0033864309401834881.101162087813043e-40.0052612666507327080.0239281091601140740.170874614577180870.321128896499587373.7800334630287760.178306743629602140.039784843224621891.15309403593881290.059472763306338991.4306583860993755.21069184912815200
201819Spring termNationalE92000001EnglandState-funded primaryNC Year Not followed or missing2985114330144827324715812.666846.406026.2608211263.3740941703126625959670330.36232405342541414.28913987003333316.0731841833920846433426016831200178471743423065859573708014254004.0610513426047410.299134085541852560.00524796641301495700.146943059564418780.0271144931339106080.174932213767165221.56039534680311386.2748185078282160.299134085541852560.26764628706376285.1246392023091060.50118079244292836.19260036735764812.46741887518586500
201819Spring termNationalE92000001EnglandTotalFirst language Known or believed to be English5555613663598787327994882459630682031824.942673.70651.2361775905013.30816882607221729043311285743600469019.59017851678122612.7868237923546576.80335472442656919271100193118212189197665727623939463870321225312429214112040795346946071673318806812925232421393002.90402881643603730.291016505429507360.00183680263417961920.00297860701182987550.0086311188510355130.036075111149954530.096248367614933560.319851549095733933.6606668782232110.181446835586213940.080574891105097820.91496143738430310.048041980522788391.2250251445984034.88569202282161400
201819Spring termNationalE92000001EnglandState-funded primaryFirst language Unclassified5048590952256531869369604.340963.16321.1777661411.2826267403123947757463718.3879055828375611.5083898342803746.879515748557186127371115300482676415471580817453603867164613621944002.1553357971544220.188678606722711830.00507655444096982500.008122487105551720.045181334524631440.0108299828074022930.26178099067267732.6750057534283660.29528624998307820.06091865329163790.65436786744101040.0277518309439683771.0383246016596943.71333035508806100
201819Spring termNationalE92000001EnglandTotalSEN provision No identified SEN5827318696027216306766142300360576730094.407393.304991.102469438511.6621880916573146256239367060525856318.07494121136346311.5761946566867086.49874655467675318707505167321223173199234430526647243377215584102272677216393564371635217268310522760430930331081002.6877548133117830.240394622729810050.00332932383494613260.00286238807075612970.0063654120099809430.038284709832381040.0623211262474540960.223900727468105223.2652131235052160.235530445119835650.06280831984018280.74957816017355270.044613485343940921.0925304104775124.35774353398272800

Variables in this data set

Table showing first 5 of 53 variables
Variable nameVariable description
characteristicCharacteristic - Filter by characteristic
enrolmentsNumber of pupil enrolments
enrolments_pa_10_exactNumber of persistent absentees
enrolments_pa_10_exact_percentPercentage of persistent absentees
school_typeSchool type - Filter by school type - Total includes primary, secondary and special

Footnotes

  1. Total includes state-funded primary, secondary and special schools. Data for special schools is available from 2016/17 to present.
  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