This is an HTML version of an attachment to the Freedom of Information request 'Coronavirus cases amongst school staff'.

Aisah Latif
Business Support
Resources Group
Warwickshire County Council
Shire Hall, Warwick, CV34 4RL
Please ask for Joanne Price 
Our ref: 6362664
Your ref: 
Date: 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.
A. 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:
• 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 
(i.e proportion/rates)
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:
Information Management 
Shire Hall 
CV34 4RL 
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.

Yours faithfully
Joanne Price 
Senior Business Support Officer