Levels of risk
Column colours use California's four levels of risk. California use positivity rate and new daily cases per 100k. Unfortunately PHE don't publish the number of tests at Local Authority Level so we can't calculate a positivity rate. Instead we have to use daily cases per 100k. As this figure is quite variable daily we don't use the raw figures but instead use the 7-day-rolling-average (as in the graph above). We also ignore the dashed-line segment in the graph (recent days under-report) and use the most recent point of the solid section.
Daily cases shows a smoothed 7-day rolling average (+/3 days of the day in question) of confirmed cases by specimen date. The smoothing hides some of the "noise" in the daily data and smooths out the weekend effect. The big figure we show is this smoothed value as of 5 days ago (in the data). We ignore the most recent days because the data is still coming in and the current value under-estimates the "final" figures for those dates.
Total deaths gives the total of all deaths in a Local Authority i.e. deaths by any cause including COVID-19. Total COVID-19 deaths gives all deaths that the Office of National Statistics has noted as being related to COVID-19. Total COVID-19 deaths as a percent of total deaths takes the Total COVID-19 deaths and divides it by Total deaths to find the percentage of deaths which were related to COVID-19. In pre-COVID times it is known that some areas have more deaths per capita than others because they may have older populations. Therefore the percentage may help compare across authorities with very different figures.
© 2020 ODI Leeds. Cases data comes from Public Health England, death data comes from ONS, and restrictions come from the House of Commons Library.
Code released under an MIT license. Source on Github.
We process the ONS weekly death data - England and Wales - for our UK local authority hexmaps (json). ONS tend to publish the death data once per week on Tuesdays so the dates are given in each panel.