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

Table 1A - Daily attendance in education during the COVID-19 outbreak in holiday periods (not comparable to other time periods)

Not the latest data
Published
Last updated

This file contains daily attendance data for state-funded education settings for dates excluding half term and Easter dates. Half term includes 19th October - 23rd October 2020, 2nd November 2020, and 15 February - 19 February 2021. Easter dates include 29 March 2021 - 19 April 2021.

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

Further details on the column headings can be found in the “Table 1b variable additions and removal log” ancillary file.


Data set details

Theme
COVID-19
Publication
Attendance in education and early years settings during the coronavirus (COVID-19) pandemic
Release type
Geographic levels
National
Indicators
  • Number of open settings, excluding settings expected to be on holiday
  • Number of schools greater than 10 less than 15 percent of teachers and school leaders for any absence, excluding settings expected to be on holiday
  • Number of schools greater than 10 less than 15 percent of teaching assistants and other staff for any absence, excluding settings expected to be on holiday
Filters
  • Date
  • Setting type or phase
Time period
2020 Week 43 to 2022 Week 9

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namedatephaseResponse_rate_excl_settings_on_holidayNumber_responded_excl_settings_on_holidayNumber_open_excl_settings_on_holidayProportion_open_excl_settings_on_holidayNumber_with_one_or_more_students_self_isolating_due_to_covid_contact_in_setting_excl_settings_on_holidayProportion_with_one_or_more_students_self_isolating_due_to_covid_contact_in_setting_excl_settings_on_holidayNumber_students_attending_excl_settings_on_holidayProportion_students_attending_excl_settings_on_holidayProportion_students_attending_excl_year_11_13_students_not_in_attendance_adjusted_excl_settings_on_holidayNumber_students_with_sw_attending_excl_settings_on_holidayProportion_students_with_sw_attending_excl_settings_on_holidayNumber_students_with_ehcp_attending_excl_settings_on_holidayProportion_students_with_ehcp_attending_excl_settings_on_holidayNumber_students_fsm_eligible_attending_excl_settings_on_holidayProportion_students_fsm_eligible_attending_excl_settings_on_holidayNumber_students_absent_from_open_settings_suspected_case_of_covid_excl_settings_on_holidayProportion_students_absent_from_open_settings_suspected_case_of_covid_excl_settings_on_holidayNumber_students_absent_from_open_settings_confirmed_case_of_covid_excl_settings_on_holidayProportion_students_absent_from_open_settings_with_a_confirmed_case_of_covid_excl_settings_on_holidayNumber_students_absent_from_open_settings_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayProportion_students_absent_from_open_settings_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayNumber_students_absent_from_open_settings_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayProportion_students_absent_from_open_settings_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayNumber_students_absent_from_open_settings_isolating_NHS_track_and_trace_excl_settings_on_holidayProportion_students_absent_from_open_settings_isolating_NHS_track_and_trace_excl_settings_on_holidayNumber_students_absent_from_open_settings_required_to_remain_at_home_or_isolate_in_line_with_government_guidance_excl_settings_on_holidayProportion_students_absent_from_open_settings_required_to_remain_at_home_or_isolate_in_line_with_government_guidance_excl_settings_on_holidayNumber_students_absent_from_open_settings_due_to_attendance_restrictions_excl_settings_on_holidayProportion_students_absent_from_open_settings_due_to_attendance_restrictions_excl_settings_on_holidayNumber_students_absent_from_open_settings_due_to_isolating_other_reasons_excl_settings_on_holidayProportion_students_absent_from_open_settings_due_to_isolating_other_reasons_excl_settings_on_holidayNumber_students_absent_because_setting_is_closed_excl_settings_on_holidayProportion_students_absent_because_setting_is_closed_excl_settings_on_holidayNumber_students_absent_covid_reasons_excl_settings_on_holidayProportion_students_absent_covid_reasons_excl_settings_on_holidayNumber_teachers_and_school_leaders_on_roll_in_open_settings_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_suspected_case_of_covid_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_suspected_case_of_covid_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_confirmed_case_of_covid_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_confirmed_case_of_covid_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayNumber_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_inside_education_setting_excl_settings_on_holidayProportion_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_inside_education_setting_excl_settings_on_holidayNumber_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_outside_education_setting_excl_settings_on_holidayProportion_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_outside_education_setting_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_covid_reasons_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_covid_reasons_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_for_other_reasons_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_for_other_reasons_excl_settings_on_holidayNumber_teachers_and_school_leaders_absent_for_any_reason_excl_settings_on_holidayProportion_teachers_and_school_leaders_absent_for_any_reason_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_on_roll_in_open_settings_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_suspected_case_of_covid_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_suspected_case_of_covid_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_confirmed_case_of_covid_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_confirmed_case_of_covid_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_contact_with_case_of_covid_inside_setting_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_contact_with_case_of_covid_outside_setting_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_inside_education_setting_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_inside_education_setting_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_outside_education_setting_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_required_to_remain_at_home_or_isolate_by_NHS_test_and_trace_or_in_line_with_government_guidance_due_to_close_contact_outside_education_setting_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_for_covid_reasons_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_for_covid_reasons_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_for_other_reasons_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_for_other_reasons_excl_settings_on_holidayNumber_teaching_assistants_and_other_staff_absent_for_any_reason_excl_settings_on_holidayProportion_teaching_assistants_and_other_staff_absent_for_any_reason_excl_settings_on_holidayNumber_of_schools_with_less_than_5_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_with_less_than_5_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_5_less_than_10_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_5_less_than_10_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_10_less_than_15_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_10_less_than_15_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_15_less_than_20_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_15_less_than_20_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_20_less_than_25_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_20_less_than_25_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_25_less_than_30_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_25_less_than_30_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_with_30_percent_or_more_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayProportion_of_schools_with_30_percent_or_more_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber_of_schools_with_less_than_5_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_with_less_than_5_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_5_less_than_10_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_5_less_than_10_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_10_less_than_15_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_10_less_than_15_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_15_less_than_20_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_15_less_than_20_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_20_less_than_25_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_20_less_than_25_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_greater_than_25_less_than_30_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_greater_than_25_less_than_30_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber_of_schools_with_30_percent_or_more_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayProportion_of_schools_with_30_percent_or_more_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holiday
2020Week 43NationalE92000001England2020/10/19State-funded schools77166002060099.6470023685800088.3-1340008323300083.3----------------------------------------------------------------------------------------
2020Week 43NationalE92000001England2020/10/20State-funded schools77168002060099.5490024.2682600087.7-13300082.423300082.9----------------------------------------------------------------------------------------
2020Week 43NationalE92000001England2020/10/21State-funded schools75163002050099.4500024.9676500087-13300081.423000082.2----------------------------------------------------------------------------------------
2020Week 43NationalE92000001England2020/10/22State-funded schools72155001980099.3500025.7651500086.2-12800080.522000081.1----------------------------------------------------------------------------------------
2020Week 43NationalE92000001England2020/10/23State-funded schools61132001780099.2460025.9571600084.2-11300078.419400079.2----------------------------------------------------------------------------------------

Variables in this data set

Table showing first 5 of 103 variables
Variable nameVariable description
dateDate
Number_of_schools_greater_than_10_less_than_15_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber of schools greater than 10 less than 15 percent of teachers and school leaders for any absence, excluding settings expected to be on holiday
Number_of_schools_greater_than_10_less_than_15_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber of schools greater than 10 less than 15 percent of teaching assistants and other staff for any absence, excluding settings expected to be on holiday
Number_of_schools_greater_than_15_less_than_20_percent_of_teachers_and_school_leaders_for_any_absence_excl_settings_on_holidayNumber of schools greater than 15 less than 20 percent of teachers and school leaders for any absence, excluding settings expected to be on holiday
Number_of_schools_greater_than_15_less_than_20_percent_of_teaching_assistants_and_other_staff_for_any_absence_excl_settings_on_holidayNumber of schools greater than 15 less than 20 percent of teaching assistants and other staff for any absence, excluding settings expected to be on holiday

Footnotes

  1. All national level figures are adjusted for non-response. Regional and local authority level figures are based on responding schools only. See accompanying document for full methodology.
  2. The number of students absent for COVID-19 related reasons does not include students who are absent for a phased return while asymptomatic testing was taking place. This is to allow comparisons to be made between previous weeks of data for this measure. There were 340,000 secondary school students absent on 6 January for a phased return.
  3. There are only a small number of special post 16 settings therefore the data is expected to be variable and sensitive to changes in one or more settings.
  4. For overall attendance, we have removed the number of students absent due to a phased return. We have not been able to do this for the attendance rates for students with an EHCP, students with a social worker, or those eligible for free school meals. This is because we know how many students within these groups were absent for a phased return. For this reason, attendance rates for these groups may be depressed slightly.
  5. 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.
  6. From 7 March 2022, data collection has changed from daily to weekly, data will be collected every Thursday.
  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 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. 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.
  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. 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. 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.
  12. Figures for independent schools are unlikely to be representative. We looked at a sample of non-responding school websites across different phases to assess whether they were open to children of key workers and vulnerable children. This was to enable us to assess whether non-responding schools were as likely to be open as the responding schools. For independent schools, we found evidence that non-responding schools were more likely to be closed than responding schools. Open rates and attendance rates for independent schools are likely to be lower than reported here.
  13. The number of students on-site is calculated using a grossing methodology. This includes reported attendance from responding colleges and estimates of attendance in non-responding colleges. Two further education colleges are excluded from these metrics due to missing data used for the grossing methodology. See the methodology for further information.
  14. 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.

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