Richard 📊📉 Profile picture
Over 20 years experience building, diagnosing and fixing large scale, high performance systems involving the processing + analysing of huge datasets.
Rachel ShowYourSmile 😊 & Live Free (Jab Free) Profile picture Max Profile picture Alex Profile picture Phil Barnes Profile picture Helly_HVE Profile picture 7 added to My Authors
Jan 17 4 tweets 4 min read
Pinned index post linking to a simple table of contents page to make it easier to find my normal daily posts.

As interest in this content is reducing, some threads may not be posted to twitter every day but will still be available via index page.

…ddatashare.s3-eu-west-1.amazonaws.com/index.html Vaccine: …ddatashare.s3-eu-west-1.amazonaws.com/Vac/Vac_202201…
Deaths:
Nation:
Table:
Detail:
MSOA:

Jan 17 6 tweets 3 min read
Drops filtering through to MSOA data now (all back under 3000).

Updated (17-Jan) table of top 30 MSOAs (by rate) based on latest numbers in today's report.

Note this data lags behind LA figures so the short spikes have often dropped again by the time we see this detail. Bringing back the view of how many weeks the MSOAs have been in the suppressed 'less than 3 +ves in the last week' category. Since they don't allow us to distinguish between zero / 1 / 2, we generally consider it to mean zero. Link to full table in reply below.
Jan 17 13 tweets 5 min read
#covid19uk - Detailed positive tests thread. The majority of this thread is a set of views of rolling 7 day average positives per 100K by specimen date. Starting with England regions: Some of the more detailed content from this thread has been moved to an external page to try and make the twitter updates a bit more manageable. You can still see the full version here: …ddatashare.s3-eu-west-1.amazonaws.com/Detail/Detail_…
Jan 17 7 tweets 3 min read
#covid19uk - Tables thread. Starting with the top 50 England Local Authorities by positives per 100K population in last 7 days, up to 3 days ago. Bright green means lower than previous period. Link to full versions, sorted by:
Rate: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Count: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Jan 17 6 tweets 4 min read
85 new #covid19uk deaths reported today (17-Jan). This brings the rolling average by date of death (allowing 4 days for lag) to 227, an increase of 49 (28%) in the last week. Closer look at the latest 45 days, with today's added numbers highlighted in orange. Individual nations and animated England charts further down the thread.
Jan 17 8 tweets 3 min read
Dashboard for 17-Jan to explain the #covid19uk total death increase figure of 85.

For England, NHS data is merged by PHE for a net total of 63.

This moves the UK 7 day rolling average up by 1.2 to 263.6. Date of death chart for England regions drawn with 7 day rolling averages of deaths per 1M population.
Jan 17 15 tweets 7 min read
Latest view on England covid hospital admissions (as of 17-Jan) with 1,604 reported for 15-Jan.

The 7 day average is now 1921, equivalent to around 29-Dec (i.e. 14 days ago), a reduction of 81 (4.1%) in the last week. Latest view on England patients with a positive covid test currently in hospital, as of 8am on 17-Jan.

The count is now 16,621, a reduction of 499 (2.9%) in the last week.
Jan 17 11 tweets 6 min read
84,429 new #covid19uk positive tests reported today (17-Jan).

England down 36% on previous Monday - that's now 11 consecutive days of week-on-week drops. Interestingly, day-1 lateral flow positives are up 60% on last Monday which I think reflects the change to testing approach. Animated chart to show LFD-only positives being either converted into PCR confirmed positives or removed due to negattive confirmation, over the last 14 days of reports.
Jan 16 4 tweets 4 min read
Pinned index post linking to a simple table of contents page to make it easier to find my normal daily posts.

As interest in this content is reducing, some threads may not be posted to twitter every day but will still be available via index page.

…ddatashare.s3-eu-west-1.amazonaws.com/index.html Vaccine: …ddatashare.s3-eu-west-1.amazonaws.com/Vac/Vac_202201…
Deaths:
Nation:
Table:
Detail:
MSOA:

Jan 16 6 tweets 3 min read
Recent drops in North East should filter through here in a few days.

Updated (16-Jan) table of top 30 MSOAs (by rate) based on latest numbers in today's report.

Note this data lags behind LA figures so the short spikes have often dropped again by the time we see this detail. Bringing back the view of how many weeks the MSOAs have been in the suppressed 'less than 3 +ves in the last week' category. Since they don't allow us to distinguish between zero / 1 / 2, we generally consider it to mean zero. Link to full table in reply below.
Jan 16 13 tweets 5 min read
#covid19uk - Detailed positive tests thread. The majority of this thread is a set of views of rolling 7 day average positives per 100K by specimen date. Starting with England regions: Some of the more detailed content from this thread has been moved to an external page to try and make the twitter updates a bit more manageable. You can still see the full version here: …ddatashare.s3-eu-west-1.amazonaws.com/Detail/Detail_…
Jan 16 7 tweets 3 min read
#covid19uk - Tables thread. Starting with the top 50 England Local Authorities by positives per 100K population in last 7 days, up to 3 days ago. Bright green means lower than previous period. Link to full versions, sorted by:
Rate: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Count: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Jan 16 6 tweets 4 min read
88 new #covid19uk deaths reported today (16-Jan). This brings the rolling average by date of death (allowing 4 days for lag) to 223, an increase of 58 (35%) in the last week. Closer look at the latest 45 days, with today's added numbers highlighted in orange. Individual nations and animated England charts further down the thread.
Jan 16 8 tweets 3 min read
Dashboard for 16-Jan to explain the #covid19uk total death increase figure of 88.

For England, NHS data is merged by PHE for a net total of 79.

This brings the UK 7 day rolling average DOWN by 1.3 to 262. Date of death chart for England regions drawn with 7 day rolling averages of deaths per 1M population.
Jan 16 15 tweets 7 min read
Latest view on England covid hospital admissions (as of 16-Jan) with 1,692 reported for 14-Jan.

The 7 day average is now 1958, equivalent to around 29-Dec (i.e. 13 days ago) and has been holding level for the last 7 days. Latest view on England patients with a positive covid test currently in hospital, as of 8am on 16-Jan.

The count is now 16,372.
Jan 16 11 tweets 6 min read
70,924 new #covid19uk positive tests reported today (16-Jan).

England down a massive 45% on last Sunday and UK as a whole is half the number reported this time last week.

Very early signs of deaths levelling off too - but need to wait a few more days to be sure. Animated chart to show LFD-only positives being either converted into PCR confirmed positives or removed due to negattive confirmation, over the last 14 days of reports.
Jan 15 4 tweets 4 min read
Pinned index post linking to a simple table of contents page to make it easier to find my normal daily posts.

As interest in this content is reducing, some threads may not be posted to twitter every day but will still be available via index page.

…ddatashare.s3-eu-west-1.amazonaws.com/index.html Vaccine: …ddatashare.s3-eu-west-1.amazonaws.com/Vac/Vac_202201…
Deaths:
Nation:
Table:
Detail:
MSOA:

Jan 15 6 tweets 3 min read
Recent drops in North East should filter through here in a few days.

Updated (15-Jan) table of top 30 MSOAs (by rate) based on latest numbers in today's report.

Note this data lags behind LA figures so the short spikes have often dropped again by the time we see this detail. Bringing back the view of how many weeks the MSOAs have been in the suppressed 'less than 3 +ves in the last week' category. Since they don't allow us to distinguish between zero / 1 / 2, we generally consider it to mean zero. Link to full table in reply below.
Jan 15 13 tweets 5 min read
#covid19uk - Detailed positive tests thread. The majority of this thread is a set of views of rolling 7 day average positives per 100K by specimen date. Starting with England regions: Some of the more detailed content from this thread has been moved to an external page to try and make the twitter updates a bit more manageable. You can still see the full version here: …ddatashare.s3-eu-west-1.amazonaws.com/Detail/Detail_…
Jan 15 7 tweets 3 min read
#covid19uk - Tables thread. Starting with the top 50 England Local Authorities by positives per 100K population in last 7 days, up to 3 days ago. Bright green means lower than previous period. Link to full versions, sorted by:
Rate: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Count: …ddatashare.s3-eu-west-1.amazonaws.com/TableCumulativ…
Jan 15 6 tweets 4 min read
287 new #covid19uk deaths reported today (15-Jan). This brings the rolling average by date of death (allowing 4 days for lag) to 219, an increase of 60 (38%) in the last week. Closer look at the latest 45 days, with today's added numbers highlighted in orange. Individual nations and animated England charts further down the thread.