The more I think about this map, the more interesting I think it is.

So I thought I would do a little thread on it...
I'm interested in looking at geographical variation in COVID-19 deaths and trying to understand what patterns we might be able to see in them.

We can start by mapping overall COVID-19 death rates.

This fairly clearly shows higher rates in the North of England.
But hang on, London has seen a bigger increase in mortality during the pandemic than any other region in the UK, so why doesn't it show up in that map?
Well, a large part of the reason for that is that London is *young* and we know that the risk of COVID-19 mortality increases rapidly with age.

So maybe it's better instead to look at the % of all deaths which were from COVID. This picks out London much more clearly.
(It's worth saying here that there are other, more advanced ways of looking at this, for example calculating composite age-based risk scores for small areas, as in these great papers from @ikashnitsky @jm_aburto @drjenndowd @melindacmills and colleagues) ncbi.nlm.nih.gov/pmc/articles/P…
But anyway, the question that jumps out to me is to what extent COVID-19 deaths are associated with deprivation.

There are lots of ways of looking at this. The simplest is just to plot these things on a scatter plot...
If we do that, we can see that there is a correlation between higher deprivation and a greater % of deaths being from COVID-19. But there are still plenty of deprived areas with low COVID deaths and affluent areas with high COVID deaths.
There will be many factors contributing to this, including age, underlying health, ethnicity, ability to work from home etc.

But it's interesting to look for spatial patterns in the data. If we plot this on a map, what do we see?
Plotting two different things (COVID deaths and deprivation) on a map at the same time isn't trivial, but there one approach is to use a 'bivariate' approach where we use a carefully chosen colour scheme that can show two dimensions of colour at once.
So in this map, more pinkness = greater deprivation, more turquoiseness= more COVID-19 cases, and the combination of both colours (purple) means high levels of both.
These kinds of bivariate maps work well where either:

1) You have a strong correlation between the two dimensions, but you are interested in the outliers (the pink and turquoise areas)
2) You are looking for spatial patterns (e.g. are the pink areas clustered together)
Here's the bivariate map of deprivation and % of deaths from COVID.

Lots of Purple - as we would expect from the scatterplot. But this is definitely concentrated in urban areas.

Not so much white, but a clear tendency for this to be in rural areas like Surrey or Cambridgeshire.
So what about the pink areas? These are deprived areas which have seen relatively fewer COVID deaths.

There is a pretty clear trend for these pink areas to be rural areas further from major cities. Cornwall & Devon, Herefordshire, Norfolk, the Isle of Wight.
Finally, how about the turquoise areas? The affluent areas which have seen large numbers of COVID deaths.

These look to be fairly concentrated around the periphery of major cities - the outskirts of London, Cheshire, the leafy Western suburbs of Sheffield.
This isn't a rigorous statistical analysis, but the patterns look pretty clear to me. And there's no way you could have spotted these from a simple scatterplot. Or even by looking at separate maps showing deprivation and COVID-19 cases separately.
tl;dr MAPS FTW \o/
A much higher resolution version of the map can be found here:
github.com/VictimOfMaths/…
And the R code to generate it is here:
github.com/VictimOfMaths/…

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Colin Angus

Colin Angus Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @VictimOfMaths

5 Feb
New data today from @NISRA shows all-cause deaths have fallen, but remain very slightly above the peak in 2010-19 for this time of year, and a fair way above the average. Image
The number of deaths from COVID-19 has fallen, but is still higher than at any point during 2020. Image
In the context of the rest of the UK though, Northern Ireland isn't doing too badly... Image
Read 4 tweets
5 Feb
Forgot to update these plots when the latest ONS mortality data came out the other day.

There were ~ 250 COVID-19 deaths a day in English care homes in the week to 29th January. This is pretty grim, but the numbers have at least stopped rising. Image
Care home residents are still mostly dying in care homes, rather than in hospital. Image
There's a lot of variation in these figures across the country, but in Essex, Portsmouth, West Sussex and Wirral, over two thirds of care home deaths in the last week were from COVID. Image
Read 4 tweets
5 Feb
The latest NHS bed occupancy data for England shows that COVID-19 bed occupancy is falling, although there are still a *lot* of COVID patients in hospitals. Image
The fall is evident across all regions, although it's faster in those areas with the biggest peaks and rather slower in the North of England. Image
The picture is still pretty consistent when you drill down to NHS trust level. ImageImageImage
Read 6 tweets
5 Feb
In light of the ONS data on alcohol-specific deaths for 2020, the other day I had a quick look at some similar figures for Scotland, and concluded that it didn't look as though Scotland had seen a rise in alcohol-related deaths in Q2 & Q3 in the same way that England & wales did. Image
Well, after I posted this, the ever helpful @juliemramsay from @NatRecordsScot pointed out that Scottish mortality data works differently from the English & Welsh figures. In E&W the ONS report the number of deaths *registered* in each quarter. Registration can be delayed...
...for some time (almost 1% take over a year) ons.gov.uk/peoplepopulati…) for various reasons, including where there is an inquest. So the Q2 2020 figures for E&W will be missing some deaths that occurred in that quarter, but will include some deaths from previous quarters.
Read 9 tweets
5 Feb
One last map before I go out for a walk.

This is a comparison of COVID-19 deaths in March-July and August-December 2020 at MSOA level.

More red, because there were more deaths in Mar-Jul, but not much dark red, or clear pockets of red, which would indicate herd immunity.
Even in London, which you would probably mark out as the most likely candidate, there are not many areas which were hit hard in the Spring, but not in the Autumn/Winter.
Again, this isn't a rigorous statistical analysis, and it doesn't include deaths in January (because the figures aren't available at MSOA level yet), but I think it's pretty interesting all the same.
Read 4 tweets
4 Feb
This is a good explanation of the flimsiness of the conclusions of that study on international flights driving COVID deaths, but I think I have a more fundamental objection.

I think this kind of correlation analysis is close to useless for COVID, even if well conducted...
Countries' have been affected differently and at different times by COVID and to different extents for all sorts of different reasons, some of which are hard if not impossible to control for (including dumb luck).
For example, try controlling for the high prevalence of multigenerational households in deprived areas with high BAME populations who work in largely customer-facing jobs in parts of the country which happen to have had serious outbreaks in your national-level model.
Read 5 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!

Follow Us on Twitter!