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. 






Weekly Cases per 100,000 top twenty

England weekly cases per 100,000 - 8th October 2020    England Weekly Cases per 100,000 - 15/10/2020
8th October 2020 15th October 2020
     


Yesterdays figures show that Nottingham is now first with 960 new cases compared with 723 last week - why is it not in very high lockdown tier?

Knowsley and Liverpool have less cases than last week which is possibly good news.

West Lancashire have jumped from 19th to 5th going from 372 to 496 cases.
   

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...