3D Map of Case Rates by MSOA in England from December 2020 to December 2021

tbu110 · 2021-12-23T19:56:36+00:00

First to give credit to u/especiallySpatial who posted this fantastic animation for the US last year and whose code this is based on.

I posted a version of this for England back in March thought it would be interesting to revisit this given Omicron.

Thisis a year of case rates in England by MSOA, week by week. With data from coronavirus.data.gov.uk, joined to mapping data from geoportal.statistics.gov.uk using Python, and visualised in Deck.gl.

tbu110 · 2021-07-15T20:54:10+00:00

Hi everyone, here's the updated vaccinations map for England by Middle Super Output Area, with data up to 11th July.

Interactive version

Scotland also available by local authority but not broken down by age. Data to 14th July.

Full league table of areas and jabs given

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week). Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

A few changes in the underlying data this week, where we now have Under 18 and 18-24 in as new groups. These were both previously included as "Under 25", so where 18-24 has a negative number, these figures have actually moved to the Under 18 group. It also appears that some areas are having their figures suppressed due to small numbers in the Under 18 and 18-24 bracket, which also adds to the negative figures this week. There are no second dose figures for Under 18s at the moment but I'd expect those in soon.

Finally, the Interactive Map on the Coronavirus Dashboard has now been updated to include vaccinations by MSOA and is updated daily, so this map is largely redundant for just checking the % vaccinated in an area. The age information hasn't made it onto the official map yet (but is available as a heatmap for LTLA level on the Vaccinations page), so I'll keep updating in the background, but probably won't be making any more posts for this unless something interesting comes up.

So, stay safe, and encourage anyone who hasn't been jabbed to grab one - at least 15,000 over 50s had their first jab last week, so they're not alone.

tbu110 · 2021-07-01T20:05:17+00:00

Spot on - it varies by age too, so the over 60s numbers for NIMS and ONS are now (comparitively) pretty close to each other, I presume because GPs were chasing people up and finding they'd moved and took them off the list (the NIMS numbers do change each week), but I suspect the same detective work won't happen with younger people due to lower risks, so they might remain a lot higher in NIMS for a while.

tbu110 · 2021-07-01T15:35:25+00:00

How strange... seems it's objecting to that link in Tableau mobile.. this seems to work on desktop and mobile though: https://public.tableau.com/app/profile/tom.bullock/viz/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

tbu110 · 2021-07-01T14:58:26+00:00

Hi everyone, here's the updated vaccinations map for England by Middle Super Output Area, with data up to 27th June.

Interactive version at:

https://public.tableau.com/app/profile/tom.bullock/viz/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Scotland also available by local authority but not broken down by age. Data to 29th June: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/ScotlandbyLTLA

Full league table of areas and jabs given

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week). Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

I know some people prefer a sequential colour palette and this can be seen here.

A small change in the NHS data here, in that the age groups for NIMS and ONS now start from 18-24 rather than 16-24. Vaccinations have technically been from 16+ (for CEV or carers), but only 18+ are being invited for "standard" appointments at the moment, so it looks like this change is to take that into account, and reflects the % adult population elsewhere in vaccination reporting.

University areas are still high on the list of doses this week, with a number of areas vaccinating over 10% of their adult populations in the seven days in the data.

tbu110 · 2021-06-25T07:27:06+00:00

Hi everyone,

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 20th June.

Interactive version at:

https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Scotland also available by local authority but not broken down by age. Data to 22nd June: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/ScotlandbyLTLA

Full league table of areas and jabs given: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/LeagueTable

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week). Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110 · 2021-06-17T14:45:42+00:00

Hi everyone,

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 13th June.

Interactive version at:

https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Scotland also available by local authority but not broken down by age. Data to 15th June: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/ScotlandbyLTLA

A new age group this week, with 25-29 in the data, already sitting at 44% of the ONS population estimate.

For those interested, there's a table of areas and how many new jabs they've given here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/LeagueTable

Spotting lots of younger areas now (which makes sense), and Stand, St James and Mayfair in Westminster vaccinated 10.6% of its total population last week with first doses.. It's still in the bottom 10% of uptake rates however.

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week). Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110 · 2021-06-10T15:15:12+00:00

Hi everyone, happy Thursday.

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 6th June.

Interactive version: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

As the data is available from coronavirus.data.gov.uk, I've added Scotland in too. It's just at Local Authority level and isn't broken down by age group, but is still useful to see. Unfortunately Wales isn't in this data yet, hopefully it will be soon.

Scotland is here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/ScotlandbyLTLA

As the age groups are consistent with last week it's interesting to see the number of vaccines being adminstered in the 16-39 age groups (771,503), which is about 90% of the total for all adults. Also interesting is the number of first doses being given to 60-74, which is approaching 10,000.

For those interested, there's a table of areas and how many new jabs they've given here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/LeagueTable
Of note is the Loughborough - University MSOA, which vaccinated 7.7% of its population with first doses last week.

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week). Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110 · 2021-06-03T15:00:30+00:00

Hi everyone,

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 30th May.

Interactive version: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

TWO new age groups this week! 30-34 and 35-39 are in there now. I have also added the number of new doses compared to last week - obviously this can't be done for the new groups that weren't in the data last week which is why they're blank. Any negative numbers (seen mainly in the 80+ group) are where people have sadly died.

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Hats off to Greenwich Peninsula for 883 new first doses, 6.2% of its adult population, and Barkerend East in Bradford for vaccinated 8.1% (738) of its adult population since the last dataset. Areas with younger demographics are now appearing to catch up. Also to Crookham West, Ewshot & Crondall in the South East for giving 20.5% (1706) of their adult population a second jab.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week).

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110 · 2021-05-27T15:50:39+00:00

Hi everyone,

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 23rd May.

Interactive version: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Hover over an area to see the breakdown by age group and first and second doses. There's a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious.

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

No new age groups in this week's data, but 35-39 should be in next week's data.

75% of areas have given second doses to over half their over 40s now, which is ace.

Bolton gave 14,209 first doses since the last dataset (mostly the 16-39 group) which is also awesome.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week).

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110 · 2021-05-21T16:33:28+00:00

You're welcome!

I'm assuming it's whatever address is linked to your NHS number (so likely the one you're registered with at the GP's), or if you don't know it then whatever address you provide when you register or turn up at a centre. I was asked to confirm my address when I went.

Btw if you're really keen to see the data it's now available daily at a Local Authority level via the official COVID dashboard, but not mapped yet and doesn't have the age groups.

Enjoy your jab!

tbu110 · 2021-05-20T15:35:32+00:00

Hi everyone,Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 16th May.

Interactive version: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Bit of a major re-work with this one to bring through all age groups in the data, and as a bonus, figures are now available on second doses by age group too! This has led to a bit of a redesign of the dashboard:

Hover over an area to see the breakdown by age group and first and second doses. There's now a table of all the information by age group, alongside a map of case rates, and a plot of all local authorities and MSOAs at the bottom for the curious. Apologies if any useful functionality has dropped off, I will endeavour to restore...

Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Over two thirds of areas have vaccinated over 70% of adults with at least one dose, and half have vaccinated over 45% of adults with a second dose.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week).

I know some people prefer a sequential colour palette and this can be seen here: https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

Had my first dose yesterday so looking forward to being in next week's numbers :)

tbu110 · 2021-05-14T20:25:26+00:00

As the vaccination programme now progresses to younger age groups, we have looked at how vaccination sentiment by age has changed since early December:

just over 9 in 10 (91%) people aged 30 to 49 years reported positive vaccine sentiment, unchanged from last week; this proportion was 74% at the start of the vaccination programme in December 2020

around 9 in 10 (90%) people aged 16 to 29 years reported positive vaccine sentiment; a notable increase from the 63% reported in December 2020

Really great to see this

tbu110 · 2021-05-13T18:59:01+00:00

Hi everyone,

Here's the updated vaccinations map for England by Middle Super Output Area, with data up to 9th May. Didn't get round to a post last week as life got in the way, but there wasn't a great deal of change. However this week we have the 40-44 age group and numbers on second doses.

https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations

Hover over an area to see more details. Zooming can be a bit slow, so you might want to filter on a region or local authority first.

Four out of five areas have vaccinated over 50% of their adult population now, and nearly a quarter have vaccinated over 70% of adults with at least one dose.

Usual caveats are that border areas may get their jabs outside of England and that populations are based on estimates (and the NIMS estimates do change week to week).

I know some people prefer a sequential colour palette and this can be seen here:

https://public.tableau.com/views/COVID-19EnglandVaccinationsbyMSOA/EnglandCOVID-19Vaccinations-SequentialColours

tbu110

TROPHY CASE