Data set from Pupil absence in schools in England

Absence rates by pupil characteristic - full academic years

Latest data
Published
Last updated

Absence information for the full academic year, 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
Local authority, National, Regional
Indicators
  • Authorised absence rate
  • Authorised absence rate exact
  • Authorised holiday rate
Filters
  • Characteristic
  • School type
Time period
2017/18 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_identifierabsence_termstime_periodgeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameschool_typecharacteristicenrolmentssess_possiblesess_overallsess_authorisedsess_unauthorisedsess_overall_percentsess_authorised_percentsess_unauthorised_percentenrolments_pa_10_exactenrolments_pa_10_exact_percentenrolments_pa_50_exactenrolments_pa_50_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_ext_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
Academic yearSix half terms201718Local authorityE92000001EnglandE12000002North West344E08000015WirralSpecialEthnicity Minor Any other Asian background2756272703.571433.571430000000000002410000z02270000027003.1746031750.132275132000000.2645502653.571428571000003.57142857100
Academic yearSix half terms201718Local authorityE92000001EnglandE12000002North West344E08000015WirralTotalEthnicity Minor Any other black background40124535604251354.496913.412831.08408512.512.5121021811510318.016539.504138.51242713300016z9964251489221135560022.1761824460.2649963860000.1284830960.0722717420.7708985793.4128322490.1124227090.0642415480.7387778050.1686340641.0840761264.49690837500.016060387
Academic yearSix half terms201718Local authorityE92000001EnglandE12000002North West344E08000015WirralState-funded secondaryEthnicity Minor Any other Mixed background17962742360927498605.752134.381441.370692916.201120097171927127265519.8312213.090466.740762176238630052z5519227491002355518286036090363.4681712410.3793312290.0095629720.04781486100.0828790920.0876605780.3060151094.3814350830.159382870.036658060.8845749260.2900768231.3706926785.75212776100.057377833
Academic yearSix half terms201718Local authorityE92000001EnglandE12000002North West344E08000015WirralSpecialEthnicity Minor Bangladeshi4151038422016425.4304614.5695410.86093375125113436620416232.2751317.9894214.28571170346000z0102200016221643840411.258278152.2516556290.39735099300000.66225165614.569536420010.728476820.13245033110.8609271525.4304635800.264900662
Academic yearSix half terms201718Local authorityE92000001EnglandE12000002North West344E08000015WirralState-funded secondaryEthnicity Minor Black African4816382420364562.563792.221950.3418436.2512.08333550105852019.0909115.454553.6363620232120022z3264364285815564200101.2330606760.1953363450.073251129000.1342937370.1953363450.390672692.2219509220.1709193020.0305213040.0488340860.0915639120.3418386032.56378952500.061042608

Variables in this data set

Table showing first 5 of 56 variables
Variable nameVariable description
characteristicCharacteristic - Filter by characteristic
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 severely absent pupils (50% or more missed)

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