Data set from Pupil absence in schools in England

Absence rates by pupil characteristic

Not the 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.
  3. 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. From 2015, the School Action and School Action Plus categories were combined to form one category of SEN support. Extra or different help is given from that provided as part of the school’s usual curriculum. The class teacher and special educational needs co-ordinator (SENCO) may receive advice or support from outside specialists. The pupil does not have an Education, Health and Care plan.

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