Select Page

COVID – week 57 – Apr 12 – Apr 18

Friday – “Pandemic fatigue” is the zeitgeist – and as a result cases are surging.

Thursday – more reporting on the politics behind vaccines. Red vs Blue states. Voting history being a strong correlation to intent to vaccinate.

Wednesday – J&J and AstraZeneca tests being stopped or delayed. Increasing positive tests globally – UK, France, India, US; here in Washington State I am sure this is another wave slowly breaking. If so – it’s going to be another summer of restrictions. Graph from The Seattle Times.


Tuesday – six blood clot cases from millions of doses; yet the J&J vaccine is being delayed. Two WA counties are moved back to Phase 2 of reopening; King County was close to being pushed backed.

Monday – UK reduces lockdown. Long queues for shops, bars, haircuts. WHO: Pandemic “a long way from over”.

This time last year was “week 6” – and at work we were discussion what return to work would look like. Ran my first Zoom meeting with online voting for 5th LD Dems. “Reopen America” was trending.

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

COVID – week 56 – Apr 5 – Apr 11

Weekend – India, Iran, Brazil are the next breaking wave.

This time last year the UK was in the midst of a major wave – with NHS staff bearing the brunt of a lack of PPE, space and resources. Boris was in ICU. School was also “out until September” and it was almost a month working from home.

P1 variant (Brazil) is running rife through Whistler, BC and now beyond. Good list of variants here. I’m still thinking an annual Covid booster to go along with flu.

B1.1.7 – aka UK variant – 74% more transmissible; 64% more virulent
P1 – eek/E484k and others – 152% more transmissible; 45% more virulent

Clearly a rising rate of positive tests in Washington State. Some shocking disparity in vaccination rates – that seem to align with voting intent.

Friday – Delays to J&J vaccine shipping. J&J now under investigation for platelet/clotting issues. UCL claims UK heading for herd immunity; disputed.

Thursday – more restrictions on AstraZeneca vaccine. WHO warn of fourth wave in the UK; even with massive vaccine drive.

Wednesday – after weeks of bad press and the UK pushing forward with vaccinations – the UK regulator says “no AstraZeneca vaccine for under 30s“. Meanwhile the entire vaccine supply chain is running well in the US – City of Seattle alone will deliver >30k doses this week. Biden calls for “all adults to be offered the vaccine by 19 April” – that’s testament to the manufacturing, distribution and last mile working well.

Tuesday – France, Canada clearly in another major wave. Multiple locations flagging the E484K “eek” variant as being especially virulent and evasive. That’s the Brazil/South Africa variant.

Monday – more AstraZeneca woes – this time the UK is considering not using it for under 30s because of the blood clotting risks. UK lifting more lockdown; certainly the numbers are lowering quickly. US news – wave 4 is certainly here. “The United States has entered a fourth wave of transmission, and there’s no disputing this. Whether it remains as small regional outbreaks, or whether it generalizes nationwide remains to be seen,” Dr. George Rutherford, a UC San Francisco epidemiologist, said Friday at a campus town hall meeting.


The Guardian The Seattle Times
5 Apr here here
6 Apr here here
7 Apr here here
8 Apr here here
9 Apr here here
10 Apr here here
11 Apr here here

COVID – week 55 – Mar 29 – Apr 4

Weekend – continued reports that Covid is spreading faster than vaccines can be administered; meanwhile it’s spring break – and there are just too many folk travelling and not wearing masks. 60k+ cases per day in the US still. In King County, WA “If cases continues to climb over the next week or two, the county may return to the more-limited Phase 2 of the reopening plan”.

The US daily cases graph from JHU (see below) certainly seems like the start of another uptick. Canada describing a third wave (the first two are really “the first”). “As variants spread, Covid is killing faster and younger,” said Dr Adalsteinn Brown, co-chair of Ontario’s Covid-19 science advisory table.

US gets 4M+ vaccines in a day; average of over 3M per day for the week. Very good news. Almost half of the UK has had one shot of a vaccine.

Here The Seattle Times has the weekly update. Certainly a clear uptick in positive cases in the State. I have zero confidence that this will be contained; it’s going to be another wave, another lockdown.

Friday – much discussion on “coronavirus passports”, privacy, technology and inclusion.

Thursday – AstraZenaca still in the news; bloodclots, halted for under 60s in the Netherlands. France, Belgium, Germany continue to fight through a new massive wave. Variants are more transmissible.

Wednesday – Pfizer vaccine for me. Thousands of people getting vaccinated in Seattle.


Tuesday – Back to Western Europe for rising cases. Netherlands, France, Germany still fighting with variants and rising numbers.

Monday – my first vaccination scheduled for Wednesday; that will make both adults in the house having had one shot. Two shots done by end of April. Meanwhile US wide cases are rising; WA cases are rising; Brazil and much of Europe is in the midst of another wave. I don’t see any of the restrictions being really removed until 2022. WHO origins of COVID report is going to stir up some more politics.

US cases – from JHU – is that the start of a fourth wave across the country?


I suspect that, after a year, The Seattle Times daily updates are back behind the paywall.

The Guardian The Seattle Times
29 Mar here here
30 Mar here here
31 Mar here here
1 Apr here here
2 Apr here here
3 Apr here here
4 Apr here here

COVID – week 54 – Mar 22 – Mar 28

Weekend – clear signs and reporting of another wave. Brazil is still a tragedy; US is racing to immunize; half the population seem to be out and about.

Weekly summary of Washington State cases from The Seattle Times. That positive rate picking up; and the number of cases still being around 1000 per day is really sad. Nowhere close to being done with this.

For the first time; The Seattle Times daily COVID news is “below the fold” on the website.

Friday – a story of multiple parts. Declining cases in the US and UK; another wave building in Europe. Is the US about to follow? Certainly looking at the rates there’s a lot of folk without masks, spring break, kids back at school, more virulent variants running wild. April will be interesting – have 200M vaccinations beaten the spread? I hope so.

Thursday – EU vaccine production and distribution woes. What should have been a triumph of the commons is coming unraveled quickly.

Wednesday – the story of vaccine chasers – I have colleagues who did exactly this; showed up at end of day and got vaccinated.

Tuesday – AstraZeneca in the news again; blood clots; approvals; export restrictions.

Monday – the tragedy of timing continues. Looks like a major wave is about to break over most of Europe; looking at the rates in the US I think there will be regional waves too. Germany looking at closing all stores; Poland talking about closing churches. New variants are more virulent and affect younger people. Lockdown fatigue – and here in Washington State we may be seeing a similar up-tick. Time will tell.


The Guardian The Seattle Times
22 Mar here here
23 Mar here here
24 Mar here here
25 Mar here here
26 Mar here here
27 Mar here here
28 Mar here here

More Kusto

You can tell where I’ve been working by the Kusto queries against Azure Resource Graph that I leave behind.

All Azure VNets and subnets, with subnet details:

// get all Azure VNETS and SUBNETS with associated subnets


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

| where type == “”

| mv-expand subs=properties.subnets

| extend subnetname =

| extend subnetprefix=

| extend vnetprefix = substring(tostring(properties.addressSpace.addressPrefixes),2,strlen(tostring(properties.addressSpace.addressPrefixes))-4)

| project SubName, resourceGroup, name, vnetprefix, subnetname, subnetprefix

| sort by SubName, resourceGroup asc, name

This one for pulling back network security groups and metadata (this was originally at Thomas Balkeståhl’s blog) – tidied up:


| where type =~ “”

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

| mv-expand rules=properties.securityRules

| extend direction = tostring(

| extend priority = toint(

| extend description =

| extend destprefix =

| extend destport =

| extend sourceprefix =

| extend sourceport =

| extend subnet_name = split((split(tostring(properties.subnets), ‘/’))[10], ‘”‘)[0]

| project SubName, resourceGroup, subnet_name, name, direction, priority, destprefix, destport, sourceprefix, sourceport, description

| sort by SubName, resourceGroup asc, name, direction asc, priority asc

COVID – week 53 – Mar 15 – Mar 21 2021

Weekend – Italy, Germany, France all picking up for another wave. I think this goes back to the earliest days (a year ago!) – the hammer and the dance. This is going to be the Spring story – racing to produce, ship and deliver vaccines across the globe; and getting enough people immunised.

Casing surging across Europe. JHU/The Guardian graphic.


Washington State weekly recap from The Seattle Times. Positive tests have ticked back up.

Friday – The “people we know who have been vaccinated” list keeps growing. Friends, family, colleagues. All positive. 100M shots in 58 days; weeks ahead of schedule. On the downside – positive cases are picking up; lots of B117 variant in the US – and it’s spreading just as states open up too early. It’s a race to vaccinate “most” before the next wave comes through.

Thursday – vaccine manufacturing shortages. Hoarding/export bans for vaccine.

Wednesday – Looking back at last year; and there was absolute panic: blueprints for ventilators being sent to industry, closing borders, exams being cancelled, schools closing.

Tuesday – AstraZeneca vaccine “safe”, another wave of infections in France.

Monday – The blog rolls around. Officially more than a year of weekly synopsis.

A reminder of “this time last year” and the panic buying:


The Guardian The Seattle Times
15 Mar here here
16 Mar here here
17 Mar here here
18 Mar here here
19 Mar here here
20 Mar here here
21 Mar here here

COVID – week 52 – Mar 8 – Mar 14 2021

Weekend – Almost 3MM vaccinations in the US yesterday. Phenomenal rate. This is the only way to beat the variants; run faster and vaccinate. Plenty of concern about the 50% who say they won’t get the vaccine however. 🙁 100M vaccinated. Concerns in Europe on blood clot risk of AstraZeneca vaccine.

Weekly graph from The Seattle Times. Positive test rate is picking up slightly. 20% with first dose, 11% with two.

Friday – All US adults eligible for vaccine by 1 May, “independence from Covid 4th July”.

Thursday – real concern in Brazil over spiraling cases and overrun hospitals.

Wednesday – Mixed directions in Europe, relaxed rules vs. increased lockdown and a “fourth wave”.

Tuesday – some excitement – as “extra” vaccines are being given at the close of day in many locations in Washington. We made appointments, then were told there was an error. Mid-March – and we must be just weeks away from open vaccinations.

Monday – the year rolls over. A year, 52 weeks, since I started the daily updates on COVID and capturing the news summaries for posterity. So what are my main observations? Firstly I’m glad that The Guardian, The Seattle Times and many other media outlets are still summarising the pandemic news on a daily basis. The BBC news website stopped this in the summer. Secondly – there’s sadly little shock value of dozens, hundreds or thousands dying on a daily basis. >500K deaths in the US – and that number really doesn’t resonate with many. Thirdly – everything is political. Masks, eating out, return to school, vaccination.

The Guardian The Seattle Times
8 Mar here here
9 Mar here here
10 Mar here here
11 Mar here here
12 Mar here here
13 Mar here here
14 Mar here here

COVID – week 51 – Mar 1 – Mar 7 2021

Weekend – 28M fully vaccinated in the US (two shots),  WA is still slowly, but surely getting vaccines out. Almost a third of the UK have received at least one vaccine dose. “Hundreds of deaths per day” across European countries; sadly that isn’t newsworthy after the brutal waves of the past year. 90M vaccines have been delivered in theUS, including over 2.4M yesterday.

UK numbers from The Guardian. That massive peak, and the climb into it, seems so long ago.


Weekend numbers from The Seattle Times. A year on – they are still doing a daily roundup and regular stats.

Friday – @YearCovid tweeting last years news.

Thursday – last day in the office one year ago. The start of “vaccine passports” and “vaccinated only” events.

Wednesday – a year ago was the week of panic buying and stripped shelves.

Tuesday – amidst positive talk about vaccinations and decreasing positive tests and a decline in deaths; there are still huge risks of a fourth wave.

Monday – a year since the first COVID death in the US and in Washington State. It’s still a race against time – vaccinate and beat the variants. CDC/NIH tracking five variants across the US.

The Guardian The Seattle Times
1 Mar here here
2 Mar here here
3 Mar here here
4 Mar here here
5 Mar here here
6 Mar here here
7 Mar here here

More Kusto – The Everything Script

“The get everything about virtual machines” script.

This brings back pretty much everything – sub second queries. Far, far easier than the old methods using PowerShell.


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

| extend nics=array_length(properties.networkProfile.networkInterfaces)

| mv-expand nic=properties.networkProfile.networkInterfaces

| where nics == 1 or =~ ‘true’ or isempty(nic)

| project subscriptionId, resourceGroup, vmId = id, vmName = name, vmSize=tostring(properties.hardwareProfile.vmSize), nicId = tostring(,location, tags.itowner, tags.businessowner, tags.application, tags.costcenter, tags.supportgroup, tags.[‘project’], powerstate=properties.extended.instanceView.powerState.displayStatus, os=properties.storageProfile.osDisk.osType, sku=properties.storageProfile.imageReference.sku

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

| join kind=leftouter (


  | where type =~ ‘’

  | extend ipConfigsCount=array_length(properties.ipConfigurations)

  | mv-expand ipconfig=properties.ipConfigurations

  | where ipConfigsCount == 1 or =~ ‘true’

  | project nicId = id, privIP = tostring( on nicId

| project-away subscriptionId, subscriptionId1, vmId, nicId, nicId1

COVID – week 50 – Feb 22 – Feb 28 2021

Saturday – huge demand for vaccinations; this story from Portland, OR describing how 400,000 attempts to book for 3,400 slots. Washington State at around 13% first vaccination, UK is at just under 30% of the population having at least one dose. That reaches almost 40% in Wales. That’s actually quite the testament to the role of the NHS.

Track and Trace (contact tracing) is partially working, depending on location. Great results in New Zealand, missed contacts in England (with a possible Brazil variant escaped into the wild), unknown results in the US.


Usual weekend state of the State from The Seattle Times. Positive test rate is steady at around 5.4% – still a good way to go to below 2% trend.

Friday – next week I will start the “one year ago” retrospectives. The first cases of COVID in the US were in Washington State, first identified in late January. The first death was 29 February.

Thursday – reluctance over taking the AstraZeneca vaccine.

Wednesday – J&J single shot vaccine approved

Tuesday – >112M global cases, >2.5M global deaths.

Monday – officially 500,000 deaths due to Covid in the US.

The Guardian The Seattle Times
22 Feb here here
23 Feb here here
24 Feb here here
25 Feb here here
26 Feb here here
27 Feb here here
28 Feb here here