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

Table 1B - Daily attendance in education settings during the COVID-19 outbreak (excludes schools holiday dates)

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. 

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 children of critical workers attending
  • number of fully open settings
  • number of open settings including inset
Filters
  • date
  • phase
Time period
2020 Week 37 to 2022 Week 9

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namedatephaseresponse_ratenumber_respondednumber_open_including_insetproportion_open_including_insetnumber_fully_open_settingsproportion_fully_open_settingsnumber_of_settings_with_one_or_more_students_self_isolating_due_to_COVID_contact_within_settingsproportion_of_settings_with_one_or_more_students_self_isolating_due_to_COVID_contact_within_settingsnumber_students_attendingproportion_students_attendingoverall_attendance_rate_excl_year_11_13_students_not_in_attendance_adjustednumber_students_attending_fully_open_settingsproportion_students_attending_fully_open_settingsnumber_students_with_sw_attendingproportion_students_with_sw_attendingnumber_students_with_sw_attending_fully_open_settingsproportion_students_with_sw_attending_in_fully_open_settingsnumber_students_with_ehcp_attendingproportion_students_with_ehcp_attendingnumber_students_with_ehcp_attending_fully_open_settingsproportion_students_with_ehcp_attending_fully_open_settingsnumber_students_eligible_fsm_attendingproportion_students_eligible_fsm_attendingnumber_children_of_critical_workers_attendingnumber_of_otherwise_vulnerable_students_attendingtotal_students_absent_from_open_settings_with_a_suspected_case_of_COVID19proportion_students_absent_with_a_suspected_case_of_COVID19proportion_students_absent_with_a_suspected_case_of_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedtotal_students_absent_from_open_settings_with_a_confirmed_case_of_COVID19proportion_students_absent_with_a_confirmed_case_of_COVID19proportion_students_absent_with_a_confirmed_case_of_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedtotal_students_isolating_NHS_track_and_traceproportion_students_isolating_NHS_track_and_tracetotal_students_absent_from_open_settings_required_to_remain_at_home_or_isolate_in_line_with_government_guidanceproportion_students_required_to_remain_at_home_or_isolate_in_line_with_government_guidancetotal_students_absent_due_to_attendance_restrictionsproportion_students_absent_due_to_attendance_restrictionstotal_students_absent_other_isolationproportion_students_absent_other_isolationtotal_students_absent_from_open_settings_due_to_potential_contact_with_case_of_COVID19_inside_settingproportion_students_absent_from_open_settings_due_to_potential_contact_with_case_of_COVID19_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_students_absent_from_open_settings_due_to_potential_contact_with_case_of_COVID19_outside_settingproportion_students_absent_from_open_settings_due_to_potential_contact_with_case_of_COVID19_outside_settingproportion_students_isolating_due_to_potential_contact_with_case_of_COVID19_outside_setting_excl_year_11_13_students_who_are_not_in_attendance_adjustedtotal_students_not_attending_because_setting_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_not_attending_because_setting_is_closedproportion_students_unable_to_attend_because_setting_is_closed_due_to_COVID19_excl_year_11_13_students_who_are_not_in_attendance_adjustedtotal_students_absent_for_all_covid_reasonsproportion_students_absent_for_all_covid_reasons
2020Week 37NationalE92000001England2020/09/09All state-funded schools71153002160099.91970090.9--714800087-657800090.3--------------------------------------
2020Week 37NationalE92000001England2020/09/10All state-funded schools73158002160099.92000092.4--723100088-674700090--------------------------------------
2020Week 37NationalE92000001England2020/09/11All state-funded schools73157002160099.92010092.7--713000086.8-669900088.713300082.21250008423200080.921700083.3------------------------------
2020Week 38NationalE92000001England2020/09/14All state-funded schools75162002160099.92050094.8--711800086.4-676800087.413300082.212600083.223100080.721800082.5------------------------------
2020Week 38NationalE92000001England2020/09/15All state-funded schools76164002160099.92040094.4--714500086.7-674500087.713300081.81250008323100080.521700082.3------------------------------

Variables in this data set

Table showing first 5 of 53 variables
Variable nameVariable description
datedate
number_children_of_critical_workers_attendingnumber of children of critical workers attending
number_fully_open_settingsnumber of fully open settings
number_of_otherwise_vulnerable_students_attendingnumber of otherwise vulnerable students attending
number_of_settings_with_one_or_more_students_self_isolating_due_to_COVID_contact_within_settingsnumber of settings with one or more students self isolating due to COVID contact within settings

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. 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.
  4. 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.
  5. 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.
  6. From 12 October 2020, schools were asked to exclude nursery children from their submission. A corresponding decrease was observed in submitted number on roll in schools with nurseries.
  7. Data from 04 - 07 January 2022 shown in the chart can be found in table 1A.
  8. 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.
  9. 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.
  10. 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.
  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. From 7 March 2022, data collection has changed from daily to weekly, data will be collected every Thursday.
  13. 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.

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