Select Page

COVID week 39 of lockdown – Dec 7 – Dec 13

Weekend – it’s Saturday and the graph from The Seattle Times is grim reading. Average number of positive cases >3000 per day for a few days. Positive cases >12.5%. We were doing so well. Is this “mask and isolation and lockdown” fatigue – or just the follow on from Thanksgiving where it seemed like everyone travelled.

Friday – Hanukkah, Christmas – following on from Thanksgiving. Flu season. Lots to be really concerned about. Vaccines are being approved. Vaccines are being withdrawn for more testing.

Thursday – US recordbreaking deaths – 3000 in one 24 hour period.

Wednesday – The US cumulative cases curve isn’t slowing down..


Tuesday – UK starts vaccinations. The beginning of the end? Perhaps. More closures and restrictions to come. Margaret Keenan, William Shakespeare first and second on the NHS.

Monday – week 39. Is this still “lockdown” – yes. It’s been nine months of social distancing, working from home, near zero normal social activity (football, movies, eating out). What we have done has been just us, masks on, six+ feet apart.

The Guardian The Seattle Times
7 Dec here here
8 Dec here here
9 Dec here here
10 Dec here here
11 Dec here here
12 Dec here here
13 Dec here

COVID week 38 of lockdown – Nov 30 – Dec 6

Weekend – Discussion is moving to “how to promote vaccine adoption” – and breaking through the antivax/COVID hoax rhetoric, as well as reaching to BIPOC communities that have been historically underserved and abused by the medical professions. Tough message to land.

Washington State still seeing record positive cases per day, and a steady uptick in deaths and hospitalisation.

Friday – full steam ahead for vaccine production. Rollouts starting across many countries this month. Even with “500M doses in a year” – it’s going to be a long slog.

Thursday – Italy record deaths. Biden will launch “masks for 100 days”.

Wednesday – vaccine rollout starts in Russia. Germany extends lockdown to mid January.

Tuesday – Washington State notification app goes live.

Monday – Record deaths across the globe; following the surge and hospitalisations.

The Guardian The Seattle Times
30 Nov here here
1 Dec here here
2 Dec here here
3 Dec here here
4 Dec here here
5 Dec here here
6 Dec

COVD week 37 of lockdown – Nov 23 – Nov 29

Weekend – no end to the positive cases in Washington. As always weekend graphic from The Seattle Times.

Friday – positive tests spiking at around 20% in parts of Washington State. That is alarming.

Thursday – Thanksgiving Day. 3M+ travelled.

Wednesday – 60M global cases, vast numbers of US cases. Records broken across the globe.

Tuesday – Italy and Spain hit hard again. UK and French lockdowns easing.

Monday – today Russia with peak cases. 12% positive test rate in Washington State.

The Guardian The Seattle Times
23 Nov here here
24 Nov here here
25 Nov here here
26 Nov here here
27 Nov here here
28 Nov here here
29 Nov here here

Kusto queries that work for me

Azure Resource Graph explorer is awesome.

Here’s my running list of useful queries.

Resources, by name, subscription name, resource group and location. Switch out the “where” for the resource type. e.g. microsoft.compute/virtualmachines


| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘’

| project name, SubName, resourceGroup, location

Linux machines, including appliance MarketPlace identifiers (i.e. CentOS, SLES, RHEL)


| join kind=leftouter (ResourceContainers | where type==’microsoft.resources/subscriptions’ | project SubName=name, subscriptionId) on subscriptionId

| where type =~ ‘Microsoft.compute/virtualmachines’

| where properties.storageProfile.osDisk.osType =~ ‘Linux’

| project name, SubName, resourceGroup, location, properties.storageProfile.imageReference.offer

COVID week 36 of lockdown – Nov 16 – Nov 22

Weekend – 200k cases per day; holiday travel is surging.

Weekly data from The Seattle Times. That positive test rate at >10% – ouch.

Friday – COVID tests spiking at 20% positive in King County. Trump Jr has COVID. Testing before Thanksgiving leads to huge lines.

UK cases may have plateaued; here come the hospitalisations and then the deaths. Compare with Monday.


Thursday – positive tests stop Brexit negotiations. “Don’t travel for Thanksgiving” – which is being widely ignored.

Wednesday – 250k deaths in the US. That’s 4 Vietnam wars.

Tuesday – “Trump administration has checked out”, US COVID cases continue to accelerate.

Monday – talking with friends about the last 36 weeks about “lockdown”: no school (all from home), no work (all from home), seen friends twice (socially distanced, wearing masks, outside), been outside the town a handful of times (to collect flour and visit Orcas Island for some isolated time away). This has not been normal, it’s not been with people. Our bubble of four has has had near zero contact with anyone else.

Today the talk has been around vaccines. A second encouraging report. UK numbers look dreadful.


The Guardian The Seattle Times
16 Nov here here
17 Nov here here
18 Nov here here
19 Nov here here
20 Nov here here
21 Nov here here
22 Nov here here

COVID week 35 of lockdown – Nov 9 – Nov 15

Weekend – 2142 cases in WA yesterday; way about the March/July peaks. Positive test rate is heading to 5.7% and above. 184k new cases in the US on Friday. Europe-wide lockdowns are returning. Trump says “vaccine ready, except for New York”. Five more months of “severe” restrictions. WA heading back to tighter lockdown.

The Seattle Times has the weekly graph of State-wide data. It’s not looking good. 2000+ cases and more seem to be on the cards. This is heading into Thanksgiving.

Friday – Gov Inslee urges WA residents to not travel for Thanksgiving. This is likely to be the next super-spreader holiday weekend. This is a cool visualisation from GA Tech.  I worry it’s got “yellow, so it’s safe”.. 150k cases in the US yesterday. That’s a run rate of 1M per week.


Thursday – those UK curves. Ouch. Graphs from The Guardian. Cases peaked, hospitals filling, deaths following along behind.


Wednesday – 1 million cases in Texas, 1 million new US cases in the last nine days. On track for 1M+ cases per week – with the associated hospitalisation and deaths. Locally in Washington State the positive case numbers are up dramatically but hospitals and deaths are still lagging (i.e. flat). Graphs from The Seattle Times.


Tuesday – the deaths lag the hospital intake, which lags the positive cases. England & Wales death tolls jumps 41%

Monday – Biden transition announces COVID-19 Task Force. Positive news on vaccines. “Back to normal by Spring 2021”

The Guardian The Seattle Times
9 Nov here here
10 Nov here here
11 Nov here here
12 Nov here here

13 Nov

here here
14 Nov here here
15 Nov here


COVID week 34 of lockdown – Nov 2 – Nov 8

Weekend – US setting the pace for a million new cases per week. Shocking, sad, not unexpected. Washington State – big spike in numbers. The White House continues to spread coronavirus. Melbourne relaxes the lockdown (which seems to have worked).

From The Seattle Times – the regular weekly status. That spike is going to be brutal. Hospital capacity is still good – but the spike in testing is the early indicator.

Friday – while most of the news continues to focus on election counts, the infections keep coming. US setting records for daily new cases. I would not be surprised to see some huge spikes in 5-14 days from long lines waiting to vote.

Thursday – the steadily increasing number of global cases, followed by the lagging hospitalisation, followed by the deaths. Europe, USA, Brazil.

Wednesday – post election. Record breaking local Washington State coronavirus cases. England lockdown starts tomorrow, panic buying and last minute socialising.

Tuesday – election day in the US. COVID related news intertwined with election news. Mask wearing while voting is now a partisan issue :\

Monday – Argentina importing 10M Russian vaccines.

The Guardian The Seattle Times
Nov 2 here here
Nov 3 here here
Nov 4 here here
Nov 5 here here
Nov 6 here here
Nov 7 here here
Nov 8 here here

COVID week 33 of lockdown – Oct 26 – Nov 1

Weekend – Numbers and reports from around the US and Europe continue to show a massive rise in positive tests, associated hospitalisation and the final lagging indicator, death.

Washington State numbers from The Seattle Times. Daily cases up, 800+ per day – that’s approaching the July peak. Hospitalisation and death are still relatively stable.

Friday – 91k US cases in the last 24 hours. 24k UK cases. This is the “new normal” as we head deeper into this phase of infection. “Save Christmas” lockdown.

Chart shows cases are continuing to rise steeply

Thursday – EU moving patients across borders to keep hospitals going.

Wednesday – France, Germany, Greece.

Tuesday – Talk of a new England-wide lockdown.

Monday – There is a risk this becomes a list of countries with record breaking infection. Portugal, Czechia, Belgium, Italy, UK, most of the US.

The Guardian The Seattle Times
Oct 26 here here
Oct 27 here here
Oct 28 here here
Oct 29 here here
Oct 30 here here
Oct 31 here here
Nov 1 here here

COVID – week 32 of work from home – Oct 19 – Oct 25

Slightly changing the title of the post to reflect this is week 32 of working from home; week 43 of 2020.

Weekend – Victoria, Australia flaring up again. UK urging “fresh air”, and this in the Seattle Times about Friluftsliv.

Weekly graph for Washington State, from the Seattle Times.

Friday – “3M cases in Spain” – 3x reported number. Multiple lockdowns across Europe. 80k + daily cases in the US.

That UK curve.


Thursday – Curfew and lockdown orders across Europe. US State numbers growing.

Wednesday – So many European countries in escalating cases. UK, Spain, France, Germany, Italy.

Tuesday – Manchester/NW England facing lockdown enforcement.

Monday – 40M global cases. “Tsunami” of cases in Belgium and across Europe. 48 US States with increasing cases.

I found this too:

The Seattle Times The Guardian
19 Oct here here
20 Oct here here
21 Oct here here
22 Oct here here
23 Oct here here
24 Oct here here
25 Oct here here

Week 32 – Oct 12 – Oct 18

Weekend – misleading Tweets from Trump removed. US cases up in 48 States. Early voting continues despite distancing.

Weekly summary of Washington State cases:

Friday – local outbreak of COVID-19 at Harborview Hospital in Seattle. Continued reporting of massive European case surges. US Thanksgiving could be another superspreader weekend. 8M cases in the US. 220k deaths. 400k new global cases today.

Thursday – Remdesivir doesn’t prevent COVID deaths. UK lockdowns continuing amidst much confusion and pushback.

Wednesday – multiple WA counties improve – and start opening back up. 38M global cases. Watched Totally Under Control last night.

Tuesday – this looks a lot like March – with rapidly climbing positive cases across the globe. The only difference being rather than 30k cases per day it’s 300k cases per day. US daily cases is a classic fast, slow, fast pattern.


Monday – continued mixed behaviour from Senators – masks, positive tests, no masks, video attendance. French declare second wave is here. J&J vaccine trial paused.

The Seattle Times The Guardian
12 Oct here here
13 Oct here here
14 Oct here here
15 Oct here here
16 Oct here here
17 Oct here here
18 Oct here here