If you haven’t seen it already, check out the awesome news result from the Sloan Digital Sky Survey that I was fortunate to be a part of. I’ll tell you more about it in a future post. But for now, COVID-19.
Graphs day 125, pandemic day 132, day 202 since the first cases were diagnosed.
Total cases of COVID-19 diagnosed worldwide: 14,507,132
Total deaths: 606,167
I’m working on a new spreadsheet that will allow me to compare any counties states in the U.S. with any regions in the world – not just countries, but also regions within countries. I’m particularly interested in looking at how current COVID-19 hotspots like Florida compare to past hotspots like Lombardy, Italy and Hubei, China (the province where Wuhan is located).
Here’s the formula that I wrote in one cell of the spreadsheet:
=IF(IFERROR(XMATCH(INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11)),'Areas of interest'!$A$1:$A$99999),-1 <> -1, IF(INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))="US",INDIRECT(CONCAT("'",$B$1,"'!$",$E$3,"$",$A11)),INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11))),IF(INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))="US",INDIRECT(CONCAT("'",$B$1,"'!$",$E$1,"$",$A11)),INDIRECT(CONCAT("'",$B$1,"'!$",$E$2,"$",$A11))))
Did I mention that I like spreadsheets?
Here is the update for cases in Florida, compared to the usual comparison countries.

(click for a larger version)
Cases have decreased in Florida the last two days. Hopefully that’s the beginning of a longer trend. We’ll find out as we go.
Update tomorrow, and every day until the pandemic ends or I do.