Warwickshire County Council
Shire Hall, Warwick, CV34 4RL
Please ask for
22 January 2021
Dear Aisah Latif Freedom of Information Act 2000
Thank you for your information request as follows: Please could you provide the rate of confirmed coronavirus cases amongst school staff
for each week in November and December.
I would like you to split the figures into primary, secondary and special schools if
In addition, I would like you to split them into staff category: teacher, teaching assistant,
support staff and auxiliary staff if possible.
Since the beginning of term (Sept 2020) schools have been asked to complete a
daily Education Settings Survey
and data is published by the Department for Education (DfE) here: https://explore-education-statistics.service.gov.uk/find-statistics/attendance-
• Please click on the link above and then scroll down the page until you see the
'Download associated files' link. Click on this and open the spreadsheet called
'Table 1C - Weekly attendance in state schools during the COVID outbreak at
local authority level.'
o Once in the spreadsheet, add a filter and you will be able to filter on
Column C to obtain the required weeks in November and December
o Then you can filter on Column D to get Warwickshire's data
o Column L will allow you to filter against the school type required; Primary,
Secondary or Special.
o Scroll all the way across the spreadsheet to the right until you get to
column AU, this shows the total number of teachers on the school roll,
scroll across to column AZ and that will provide the number of teachers
absent with confirmed Covid and column BA will provide the proportion of
teachers absent with confirmed Covid
o Continue to scroll to the right and columns BI, BM and BN will give the
same information as above but for teaching assistants and other staff in
To help you navigate the spreadsheet, attached is a downloaded copy with the above
columns highlighted. If corresponding National or other Local Authority data is required,
please use the filter in column D to obtain what's required. Please be aware that this
information is updated weekly by the DfE so you will be able to download updated
spreadsheets over the coming weeks if necessary.
Since the beginning of term (Sept 2020) schools have been asked to complete a daily Education Settings Survey and data has
been published here: https://explore-
Please refer to the above webpage and go to the 'Download associated files' link, click
on 'Table 1C - Weekly attendance in state schools during the COVID outbreak at local
authority level (csv, 2 Mb)' and then you can filter out what you need, i.e. column C to
get the weeks in Nov/Dec, column D to get Warwickshire, column L to get phase of
school and whatever other columns needed to get the teacher and teaching
assistant/other staff confirmed Covid cases - it provides both numbers and percentages
You will also then have comparisons with national and other LA data if needed.
If you are dissatisfied with the handling of your request, you have the right to ask for an
internal review. Internal review requests should be submitted within 40 days of the date
of receipt of the response to your original letter and should be addressed to:
If you are not content with the outcome of the internal review, you have the right to
apply directly to the Information Commissioner for a decision. The Information
Commissioner can be contacted at:
The Information Commissioner's Office, Wycliffe House, Water Lane, Wilmslow,
Cheshire, SK9 5AF.
Phone: 0303 123 1113
I will now close your request as of this date.
Senior Business Support Officer