Notes

The data is collected from https://coronavirus.data.gov.uk/ which provides the latest UK cases data as a Legacy CSV download. Unfortunately they do not archive this data. I collect it each day and add a column to a spreadsheet for the 350 areas from England - including region and national figures. I do not include the other home nations as they were not available when I started collecting this data.

Friday, 16 October 2020

Weekly cases increasing or decreasing?

 Introduction

Taking the current case count and deducting the case count from 7 days previously gives the number of cases in the previous week. This number is multiplied by 100,00 and divided by the population to give the number of cases per 100,000 in the past week

This is done for the seven days subtracting the number of cases from 14 days ago.

If the number of cases is either UP, DOWN or EQUAL.

Spreadsheet calculation



On the 10th October all 350 areas were UP. 

Yesterday 259 were UP, 86 were down and 5 were EQUAL.

Today 203 were UP, 141 were down and 6 were EQUAL.

Conclusion

Although the figures suggest that things are getting better a week ago the figures included the missed cases reported on the 3rd October 2020:

"Due to a technical issue, which has now been resolved, there has been a delay in publishing a number of COVID-19 cases to the dashboard in England. This means the total reported over the coming days will include some additional cases from the period between 24 September and 1 October, increasing the number of cases reported."

I suspect that the these are just starting to disappear from the previous weeks data. 






No comments:

Post a Comment

Weekly cases increasing or decreasing?

 Introduction Taking the current case count and deducting the case count from 7 days previously gives the number of cases in the previous we...