Day six of me doing this. Same four graphs as usual, same color scale as usual. The United States has now passed China in terms of all-time COVID-19 cases per million people.
Total cases
Total deaths
Cases per million people
Deaths per million people
Remember the purpose of this – the data are out there, and you can understand it with the tools that you already have. You can find the data from the European Centers for Disease Control’s Coronavirus Source Data site (download the CSV file from the “Full dataset” lin), and you are welcome to use my Microsoft Excel template.
Update tomorrow, and every day until this pandemic is over.
Day five of me doing this. Since yesterday, another 34,000 people worldwide were diagnosed with COVID-19, and another 1,700 died.
Several friends asked me to plot cases and deaths per capita, so we can get a sense of infection rates across different countries. I’ve done that, and I’ll show those graphs further down the page. But it’s important to be able to directly compare these graphs between one day and the next.
So, while I think the per capita graphs will end up being more useful, for the time being I will continue to show the plots of absolute numbers as well.
Below is the total number reported cases of COVID-19 by country. I have removed South Korea, since the disease appears to be well-contained there. I have replaced it with the United Kingdom, where the number of cases is likely to increase significantly (but that’s a testable hypothesis, we’ll see in a few weeks). The line for the UK is the same light blue color as South Korea, but now has a dot-dash pattern. I also added Australia (gray dot-dot-dash line), where there is also reason to believe that cases will increase.
And here is the graph of absolute number of deaths by country – same countries, same color schemes. The uptick in deaths in the United States that I pointed out yesterday continues today.
COVID-19 cases and deaths per capita
Looking at absolute numbers of cases is important, but when comparing China (which has about 1,400,000,000 people) to Belgium (about 11,000,000), they can give a misleading sense of how far the disease has spread in different places. A better measure could be to look at how the number of cases (or deaths) compares to the population of the country.
The graph below shows the number of reported cases of COVID-19 per million people for each of the countries shown in the other graph. Current values vary between 43 cases per million people in Australia to nearly 900 per million in Italy. This graph looks different from the one graph of total cases. And when you look at the lines for Italy, Spain, and France, you can see why Europe is being described as the new epicenter of infection.
Note that I also changed the scale of the horizontal axis on this graph. The ones above were from February 15th to today, while the ones below show all cases since the first ones were reported on December 31, 2019.
Here is the graph of deaths per million people – same countries, same color schems:
Since COVID-19 is transmitted by person-to-person contact, a better comparison might be population density rather than absolute population. I’ll look at that later. I’m also playing with some simple curve fitting models, but I’m a long way from being ready to share any of those.
Remember: I’m not an epidemiologist, and not even any kind of healthcare worker. I’m just some guy on the Internet that likes to graph things. Listen to the actual experts. And as always, follow the recommendations of your regional health authorities (if you’re in the U.S., follow the CDC recommendations).
What I hope I can contribute to the effort is to help you to realize that data about the virus are publicly available, and that you have access to the tools to understand the trends for yourself. I get the data from the European Centers for Disease Control’s Coronavirus Source Data site (even though it’s a European entity, the reports are from all over the world). I download the CSV file from the “Full dataset” link. I make my graphs in Microsoft Excel using this template.
Update tomorrow, and every day until this pandemic is over.
Day four of me doing this, and COVID-19 has reached 175 separate countries. There are cases from Afghanistan (24 reported cases) to Zimbabwe (just reported its first case today).
The United States (blue dotted line) has vey nearly caught up with Iran and Spain in terms of total number of cases reported.
The bad news for the USA is that the number of new cases continues to grow at a faster rate than in Italy. While it is likely that part of that fast growth is due to better testing becoming more widely available, that is EVEN WORSE NEWS. That would only mean that the disease has spread even more widely than this graph suggests.
The other even worse news for the USA is shown here:
We are just beginning to see the exponential growth phase in the number of deaths, on a time delay from the exponential growth phase of the cases. Death toll in the USA so far: 260 people.
For those of you who say “lol the flu kills 30,000 people a year, this is not enough deaths for me to care” – I have a question for you. How many people need to die for you to take this pandemic seriously? How many? Just say a number.
And then when that many people have died, I’ll come back to you and you can start taking this seriously.
And then it will be even more too late to stop the dying than it is already.
Noon ET: (3) Baylor v (11) Florida (West regional, Albany) 1 PM ET: (4) Villanova v (5) LSU (South regional, Tampa) 3 PM ET: (2) Creighton v (7) Houston (Midwest regional, St. Louis) 4 PM ET: (2) Michigan State v (7) Utah State (South regional, Spokane)
7 PM ET: (3) West Virginia v (11) St. Louis (East regional, Albany) 8 PM ET: (7) East Tennessee State v (15) Winthrop (South regional, Tampa) 9 PM ET: (4) Oregon v (5) Wisconsin (Midwest regional, St. Louis) 10 PM ET: (1) Gonzaga v (8) UCLA (West regional, Spokane)
