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 excluding half term and Easter dates. 

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 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 (%)
  • Attendance in schools (%): adjusted to exclude y11-13 not in attendance
Filters
  • Date
  • Phase of education
Time period
2020 Week 37 to 2022 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_percentage_of_all_pupilsUpper_estimate_for_total_pupils_unable_to_attend_school_because_of_COVID_19Upper_estimate_as_percentage_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_percentage_of_all_pupilsUpper_estimate_for_total_pupils_self_isolatingUpper_estimate_self_isolating_as_percentage_of_all_pupilsTotal_pupils_absent_from_open_settings_isolating_NHS_track_and_traceproportion_pupils_absent_from_open_settings_isolating_NHS_track_and_traceTotal_pupils_absent_from_open_settings_required_to_remain_at_home_or_isolate_in_line_with_government_guidanceproportion_pupils_absent_from_open_settings_required_to_remain_at_home_or_isolate_in_line_with_government_guidanceTotal_pupils_absent_from_open_settings_due_to_attendance_restrictions_in_placeproportion_pupils_absent_from_open_settings_due_to_attendance_restrictions_in_placeTotal_pupils_absent_from_open_settings_due_to_isolating_other_reasonsproportion_pupils_absent_from_open_settings_due_to_isolating_other_reasonsTotal_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_schoolnumber_of_teachers_and_school_leaders_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_inside_education_settingproportion_of_teachers_and_school_leaders_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_inside_education_settingnumber_of_teachers_and_school_leaders_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_outside_education_settingproportion_of_teachers_and_school_leaders_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_outside_education_settingnumber_of_teachers_and_school_leaders_absent_due_to_COVID_19_reasonsProportion_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_teachers_and_school_leaders_absent_for_any_reasonproportion_of_teachers_and_school_leaders_absent_for_any_reasonnumber_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_schoolnumber_of_teaching_assistants_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_inside_education_settingproportion_of_teaching_assistants_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_inside_education_settingnumber_of_teaching_assistants_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_outside_education_settingproportion_of_teaching_assistants_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_with_a_case_of_covid_19_outside_education_settingnumber_of_teaching_assistants_and_other_staff_absent_due_to_COVID_19_reasonsProportion_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_teaching_assistants_and_other_staff_absent_for_any_reasonproportion_of_teaching_assistants_and_other_staff_absent_for_any_reasonNumber_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 372020/09/10Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301All state-funded schools5286.7521004178.8--3255082.5-2644986.260782.446985.987476.960888------------------------------------------------------------------------------------------------------------00
2020Week 372020/09/10Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded primary3888.4381003078.9--1752080.8-1416784.833886.726089.735287.128688.8------------------------------------------------------------------------------------------------------------00
2020Week 372020/09/10Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded secondary1184.611100981.8--1472385.2-121018821976.618383.625183.117783.5------------------------------------------------------------------------------------------------------------00
2020Week 372020/09/10Barking and DagenhamLocal authorityE92000001EnglandE12000007LondonE09000002301State-funded special266.72100150--26964-14397.936100121002696414397.9------------------------------------------------------------------------------------------------------------10
2020Week 372020/09/10BarnetLocal authorityE92000001EnglandE12000007LondonE09000003302All state-funded schools10381.71031008683.5--3628381-3068187.346277.339684.1124379.2110183.7------------------------------------------------------------------------------------------------------------00

Variables in this data set

Table showing first 5 of 133 variables
Variable nameVariable description
DateDate
low_response_flagIndicates whether the data is based on a low response rate (50% or less)
Lower_estimate_as_percentage_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. A small proportion of schools (less than 1%) were known to be on half term between 24 and 28 May 2021 and have been excluded from our estimates. See matching criteria
  2. The purpose of this data collection is primarily to understand attendance and workforce 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.
  3. 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.
  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. 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.
  7. Off-site provision for pupils in year 11 and 13 impacts attendance estimates during the summer term. In the 2021/22 academic year, on-site attendance during the summer is adjusted to exclude year 11-13 pupils identified as not in attendance because they are off-site for approved purposes. During the 2020/21 academic year this applied from 7 June to 16 July. Commentary was focused on COVID-19 related absence to give the clearest picture of the impact of the pandemic on pupil attendance.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. From 7 March 2022, data collection has changed from daily to weekly, data will be collected every Thursday.
  13. 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.

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