Data set from Attendance in education and early years settings during the coronavirus (COVID-19) pandemic

Table 1C - Attendance in state-funded schools during the COVID-19 outbreak at local authority

Not the latest data
Published
Last updated

This file contains weekly attendance data at local authority level for state-funded education settings for each Thursday in the autumn term (from 10 September until 17 December 2020) for the spring term (13 January until 1 April 2021) and the summer term (15 April until 15 July). It also includes workforce absence statistics in the autumn term (from 10 September until 17 December 2020), the spring term (13 January until 1 April 2021) and the summer term (15 April until 15 July).

The data is shown for each local authority and is further split by the following school phases:

  • state-funded secondary schools
  • state-funded primary schools
  • state-funded special schools
  • all state-funded schools.

Data is in this file has been not been scaled to account for non-response so it is not nationally representative.


Data set details

Theme
COVID-19
Publication
Attendance in education and early years settings during the coronavirus (COVID-19) pandemic
Release type
Geographic levels
Local authority, Regional
Indicators
  • Attendance in fully open schools (%)
  • Attendance in schools (%)
  • Indicates whether the data is based on a low response rate (50% or less)
Filters
  • Date
  • Phase of education
Time period
2020 Week 37 to 2021 Week 9

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifierDatela_namegeographic_levelcountry_codecountry_nameregion_coderegion_namenew_la_codeold_la_codePhasenumber_schools_respondedresponse_ratenumber_open_schoolsproportion_open_schoolsnumber_fully_open_schoolsproportion_fully_open_schoolsnumber_of_schools_with_one_or_more_pupils_self_isolating_due_to_COVID_contact_within_schoolproportion_of_schools_with_one_or_more_pupils_self_isolating_due_to_COVID_contact_within_schoolnumber_children_attendingproportion_children_attendingproportion_children_attending_excl_year_11_13_students_not_in_attendance_adjustednumber_children_attending_fully_openproportion_children_attending_fully_opennumber_pupils_with_SW_attendingproportion_pupils_with_SW_attendingnumber_pupils_with_SW_attending_fully_openproportion_pupils_with_SW_attending_fully_opennumber_pupils_with_EHCP_attendingproportion_pupils_with_EHCP_attendingnumber_pupils_with_EHCP_attending_fully_openproportion_pupils_with_EHCP_attending_fully_opennumber_pupils_eligible_for_FSM_attendingproportion_pupils_eligible_for_FSM_attendingnumber_children_of_critical_workers_attending_state_funded_schoolsproportion_of_all_children_in_attendance_who_are_children_of_critical_workersLower_estimate_for_total_pupils_unable_to_attend_school_because_of_COVID-19Lower_estimate_as_%_of_all_pupilsUpper_estimate_for_total_pupils_unable_to_attend_school_because_of_COVID-19Upper_estimate_as_%_of_all_pupilsUpper_estimate_for_total_pupils_unable_to_attend_school_because_of_COVID_19_excl_year_11_13_students_who_are_not_in_attendance_adjustedUpper_estimate_as_percentage_of_all_pupils_excl_year_11_13_students_who_are_not_in_attendance_adjustedTotal_pupils_absent_from_open_schools_with_a_suspected_case_of_COVID-19proportion_pupils_absent_with_a_suspected_case_of_COVID-19proportion_students_absent_with_a_suspected_case_of_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedTotal_pupils_absent_from_open_schools_with_a_confirmed_case_of_COVID-19proportion_pupils_absent_with_a_confirmed_case_of_COVID-19proportion_students_absent_with_a_confirmed_case_of_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedTotal_pupils_absent_from_open_schools_self_isolating_due_to_contact_inside_settingproportion_pupils_absent_from_open_schools_self_isolating_due_to_contact_inside_settingproportion_students_isolating_due_to_potential_contact_with_case_of_COVID19_inside_setting_excl_year_11_13_students_who_are_not_in_attendance_adjustedTotal_pupils_absent_from_open_schools_self_isolating_due_to_contact_outside_settingproportion_pupils_absent_from_open_schools_self_isolating_due_to_contact_outside_settingproportion_students_isolating_due_to_potential_contact_with_case_of_COVID19_outside_setting_excl_year_11_13_students_who_are_not_in_attendance_adjustedLower_estimate_for_total_pupils_self_isolatingLower_estimate_self_isolating_as_%_of_all_pupilsUpper_estimate_for_total_pupils_self_isolatingUpper_estimate_self_isolating_as_%_of_all_pupilsTotal_pupils_not_attending_because_school_is_closedproportion_pupils_not_attending_because_school_is_closedtotal_students_unable_to_attend_because_setting_is_closed_due_to_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedproportion_students_unable_to_attend_because_setting_is_closed_due_to_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustednumber_of_teachers_and_school_leaders_on_roll_in_responding_schoolsNumber_of_teachers_and_school_leaders_attending_on_site_in_open_schoolsnumber_of_teachers_and_school_leaders_on_roll_responding_open_schoolsProportion_of_teachers_and_school_leaders_attending_on_site_in_open_schoolsnumber_of_teachers_and_school_leaders_on_roll_responding_schools_closed_due_to_covidnumber_of_teachers_and_school_leaders_absent_with_a_suspected_case_of_covid_19proportion_of_teachers_and_school_leaders_absent_with_a_suspected_case_of_covid_19number_of_teachers_and_school_leaders_absent_with_a_confirmed_case_of_covid_19proportion_of_teachers_and_school_leaders_absent_with_a_confirmed_case_of_covid_19number_of_teachers_and_school_leaders_isolating_due_to_contact_in_schoolproportion_of_teachers_and_school_leaders_isolating_due_to_contact_in_schoolnumber_of_teachers_and_school_leaders_isolating_due_to_contact_outside_schoolproportion_of_teachers_and_school_leaders_isolating_due_to_contact_outside_schoolProportion_of_teachers_and_school_leaders_absent_due_to_COVID_19_reasonsnumber_of_teachers_and_school_leaders_absent_for_other_reasonsproportion_of_teachers_and_school_leaders_absent_for_other_reasonsnumber_of_teaching_assistants_and_other_staff_on_roll_in_responding_schoolsNumber_of_teaching_assistants_and_other_staff_attending_on_site_in_open_schoolsnumber_of_teaching_assistants_and_other_staff_on_roll_in_open_responding_schoolsProportion_of_teaching_assistants_and_other_staff_attending_on_site_in_open_schoolsnumber_of_teaching_assistants_and_other_staff_on_roll_responding_schools_closed_due_to_covidnumber_of_teaching_assistants_and_other_staff_absent_with_a_suspected_case_of_covid_19proportion_of_teaching_assistants_and_other_staff_absent_with_a_suspected_case_of_covid_19number_of_teaching_assistants_and_other_staff_absent_with_a_confirmed_case_of_covid_19proportion_of_teaching_assistants_and_other_staff_absent_with_a_confirmed_case_of_covid_19number_of_teaching_assistants_and_other_staff_isolating_due_to_contact_in_schoolproportion_of_teaching_assistants_and_other_staff_isolating_due_to_contact_in_schoolnumber_of_teaching_assistants_and_other_staff_isolating_due_to_contact_outside_schoolproportion_of_teaching_assistants_and_other_staff_isolating_due_to_contact_outside_schoolProportion_of_teaching_assistants_and_other_staff_absent_due_to_COVID_19_reasonsnumber_of_teaching_assistants_and_other_staff_absent_for_other_reasonsproportion_of_teaching_assistants_and_other_staff_absent_for_other_reasonsNumber_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_suspected_case_of_COVID19Proportion_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_suspected_case_of_COVID19Number_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_confirmed_case_of_COVID19Proportion_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_confirmed_case_of_COVID19Number_of_teachers_and_school_leaders_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_inside_the_schoolProportion_of_teachers_and_school_leaders_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_inside_the_schoolNumber_of_teachers_and_school_leaders_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_outside_the_schoolProportion_of_teachers_and_school_leaders_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_outside_the_schoolNumber_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_other_reasonsProportion_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_other_reasonsNumber_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_all_COVID_reasonsProportion_of_teachers_and_school_leaders_who_cannot_teach_on_site_or_remotely_in_open_schools_due_all_COVID_reasonsNumber_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_suspected_case_of_COVID19Proportion_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_suspected_case_of_COVID19Number_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_confirmed_case_of_COVID19Proportion_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_a_confirmed_case_of_COVID19Number_of_teaching_assistants_and_other_staff_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_inside_the_schoolProportion_of_teaching_assistants_and_other_staff_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_inside_the_schoolNumber_of_teaching_assistants_and_other_staff_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_outside_the_schoolProportion_of_teaching_assistants_and_other_staff_in_open_schools_self_isolating_and_cannot_teach_remotely_due_to_potential_contact_with_a_case_of_COVID19_outside_the_schoolNumber_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_other_reasonsProportion_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_other_reasonsNumber_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_all_COVID_reasonsProportion_of_teaching_assistants_and_other_staff_who_cannot_teach_on_site_or_remotely_in_open_schools_due_to_all_COVID_reasonssmall_flaglow_response_flag
2020Week 3710/09/2020Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301All state-funded schools5286.7521004178.8--3255082.5-2644986.260782.446985.987476.960888--------------------------------------------------------------------------------------00
2020Week 3710/09/2020Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded primary3888.4381003078.9--1752080.8-1416784.833886.726089.735287.128688.8--------------------------------------------------------------------------------------00
2020Week 3710/09/2020Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded secondary1184.611100981.8--1472385.2-121018821976.618383.625183.117783.5--------------------------------------------------------------------------------------00
2020Week 3710/09/2020Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded special266.72100150--26964-14397.936100121002696414397.9--------------------------------------------------------------------------------------10
2020Week 3710/09/2020BarnetLocal authorityE92000001EnglandE12000007LondonE09000003302All state-funded schools10381.71031008683.5--3628381-3068187.346277.339684.1124379.2110183.7--------------------------------------------------------------------------------------00

Variables in this data set

Table showing first 5 of 102 variables
Variable nameVariable description
DateDate
low_response_flagIndicates whether the data is based on a low response rate (50% or less)
Lower_estimate_as_%_of_all_pupilsLower estimate for total pupils unable to attend school because of COVID-19 as % of all pupils
Lower_estimate_for_total_pupils_self_isolatingLower estimate for total pupils self-isolating due to a potential contact with COVID-19
Lower_estimate_for_total_pupils_unable_to_attend_school_because_of_COVID-19Lower estimate for total pupils unable to attend school because of COVID-19

Footnotes

  1. The purpose of this data collection is primarily to understand attendance and teacher availability. This data is reported directly by schools via DfE's daily education settings survey. It is not the primary source of data on infection, incidence and COVID-19 cases overall.
  2. A small proportion of schools (less than 1%) were known to be on half term between 24 and 28 May and have been excluded from our estimates.
  3. Data is based on responding schools only. Unlike national level data, no adjustments are made for non-response. Response rates vary by local authority and different schools within a region may respond on different days. Care should be taken when comparing regions and when interpreting trends over time because differences could be due to response bias or different schools being included in the data.
  4. All proportions are rounded to 1 decimal place. Where open rates are rounded to 100.0%, a small number of settings may have reported that they were closed.
  5. The majority of state-funded schools in Leicester and Leicestershire closed for the end of summer term on 9th July 2021, data will be missing or representative of the low number of schools responding (around 1%) for 15th July 2021 data (week 28).
  6. COVID-19 related reasons include a confirmed or suspected case of coronavirus and those required to isolate by NHS Test and Trace due to contact with a confirmed case of COVID-19, where they are not exempt from self-isolation under the changes of 16th August 2021.
  7. Pupils with a social worker are considered ‘children in need’. Our analysis after adjusting for non-response suggests that schools may be under-reporting the number of children with a social worker when compared to the most recently published children in need statistics. Therefore these estimates only account for pupils with a social worker that are identified by schools.
  8. Absence rates for teaching assistants and other staff are likely to be less robust as more work part-time. There are likely to be inconsistencies in how schools treat part time staff in their reported data, for example some may update their on roll numbers daily to account for part-time staff ‘expected’ to be on-site and others may not.
  9. Workforce absences are not known in closed schools. This means these figures are likely to be under-estimates of the numbers of workforce with confirmed or suspected cases and self-isolating, particularly when the proportion of schools closed for COVID-19 related reasons is higher.
  10. On-site testing for staff was available from 4 January to 5 March 2021. All staff are now encouraged to take two rapid COVID-19 tests each week at home. Rates of confirmed cases and isolation among workforce may be impacted by levels of testing.
  11. Secondary schools and colleges were given flexibility to phase the return of pupils between 8 and 12 March 2021 to manage testing and the return of pupils. This impacted attendance rates during the week commencing 8 March 2021.
  12. Off-site provision for pupils in year 11 and 13 impacts attendance estimates during the summer term. Prior to 7 June commentary was more focused on COVID-19 related absence to give the clearest picture of the impact of the pandemic on pupil attendance. Between 7 June and 16 July 2021 attendance is adjusted to exclude year 11-13 pupils identified as not in attendance because they are off-site for approved purposes.
  13. COVID-19 related reasons include a confirmed or suspected case of coronavirus and those required to isolate by NHS Test and Trace due to contact with a confirmed case of COVID-19, where they are not exempt from self-isolation under the changes of 16th August 2021.

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