Tom, thanks for writing and sharing.
Key for me is the source of the data, which is not obvious from your posts.
So, here it is:
2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE
This is the data repository for the 2019 Novel Coronavirus Visual Dashboard operated by the Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE). Also, Supported by ESRI Living Atlas Team and the Johns Hopkins University Applied Physics Lab (JHU APL).
I have stopped development of my version of this macro.
I have found the delay and reliability of the data in GitHub to be unacceptable.
There is at least a days delay between the main JHU Coronavirus Tracker site and the data on GitHub.
The data is changing much too fast for this to be acceptable to me.
I have also found that it is easy to navigate the main site, so for now that is my solution.
As I have time, I am working on a KM Macro that uses JavaScript to webscrape the main site.
Personally, I think the death count is not important (depends on too much external factors; already the Confirmed counts are very unreliable, i.e., it must be put into relation with the state of information capability/willingness of the specific country)
My macro is about giving a quick notification. Please consider to put any macros with a different purpose into a separate thread.
If your argument will be that once a day it not sufficient, then please keep in mind that any higher frequency than 1/d will likely not be very informative (in terms of reliability of data). It may be reliable, but the gain from a high-frequency update seems dubious to me.
Actually I could NOT find it in your OP. That's why I asked.
IAC, after some digging, I found this on the Github site:
Update frequency: Files after Feb 1 (UTC): once a day around 23:59 (UTC).
I don't see any necessary correlation between update frequency and reliability.
Either we trust the data maintained by JH or we don't. An update at least every 12 hrs would be helpful.
OK, fine. I'll respect your wishes. Usually minor mods (like my simple display) are put in the same thread with the main macro. Do you want me to move my mods to a new thread?
New Question: You have a KM Variable named "Local Time Latest" which reports this:
"COVID-19 in US: Texas (2020-03-16T23:53:03)"
I've been working on some major enhancements, so I have not uploaded these small changes. If I don't finish within a day or so, I'll post my small enhancements.