Friday, May 27, 2022
Bill King Blog
No Result
View All Result
  • Home
  • About Bill
  • Policy Discussion
  • Categories
  • Tune in
  • Home
  • About Bill
  • Policy Discussion
  • Categories
  • Tune in
No Result
View All Result
Bill King Blog
No Result
View All Result
Home COVID-19

COVID-19 Statistics from Other Countries – Update No. 2

by Bill King
March 26, 2020
in COVID-19, Public Health
0
comparative-mortality-rate-3-22
Share this article
  

This is follow-up to my earlier posts where I began to track the World Health Organization’s COVID-19 daily situation reports.  I have updated the spreadsheet here through WHO’s Sunday evening report. 

I have added tabs for the U.S., Germany, France and Spain, which are the countries with the most cases right now, excluding Italy.  I have also added columns on the “Table” tab with the daily percentage change in new cases and new deaths.

Here are the highlights from the most recent data:

  • Europe has become the epicenter of the outbreak.  The number of new cases there (151,000) now far outstrips the total number of cases in China.  Italy is particularly alarming.  News cases there accelerated over the weekend and its mortality rate is the highest in the world at 9%.  Yesterday, Europe accounted for almost 70% of all new cases and nearly 90% of news fatalities globally.  How things play out in Europe of the next week are really going to be critical.
  • While the global “calculated fatality rate”1 has been hovering just over 4%, there is a very significant variance between countries.  Italy is on the high end at 9% and Germany on the low end at .3%.  S. Korea’s new cases and deaths have slowed to a trickle at 1.2%.  It would obviously be very helpful if we determine why the outcomes between the different countries are so different.
  • It is somewhat stunning how quiet the outbreak is outside of Europe and the U.S.  Latin America, Africa and South Asia have remarkably few cases.  India, a country with a population of 1.3 billion, has fewer than 300 cases and only 4 deaths.
  • I was taken aback by New York’s Cuomo’s prediction in his press conference over the weekend that 40-80% of New Yorkers would contract COVID-19.  I have seen some modeling with those kinds of numbers but have always understood those as worst-case scenarios.  So, I have added a column on each country’s individual worksheet that calculates the percentage of that country’s population that has been infected, at least according to WHO’s confirmed cases.  So far, no country has an infection rate over one-tenth of one percent (.1%).

1 I am using the term “calculated fatality rate” to mean WHO’s total fatalities divided by the total confirmed cases.  There is widespread agreement that there are many more cases than those that have been confirmed because so many cases are presenting with no or mild symptoms.  Therefore, the real fatality rate is undoubtedly lower.

Spreadsheet Notes:

WHO releases their report late in the afternoon and it includes reports from the previous day.  So, for example, my current spreadsheet includes WHO’s report from Sunday evening, which is through Saturday.  Most of the media and some websites are reporting number live from the various countries information directly and therefore will be more current than those in the spreadsheet.

As previously noted, the WHO daily situation reports have a number of anomalies that make analyzing the data challenging.  Frequently, WHO’s number do not tie their summaries.  Also, there are some countries (including U.S.) that the WHO does not report every day.  I have started “smoothing” the blank by doing a straight trajectory between the values on either side of the gap.  I have noted those with light orange shading. 

For global cases and deaths, I have added 7425 because WHO shows zero new cases and deaths for US due to the weekend issue noted above.  I have highlighted these fields in yellow and will post actual WHO values for US with smoothing after 3/24 report.

There was a change in how WHO reported Chinese new cases on February 17.  I have created a new that backfilled the previous days’ reports as if the change had been in place during those days.

The spreadsheet currently has data broken down by country for China, S. Korea, Italy, Germany, Spain, France, Germany, Switzerland and the US.  These are all the countries that were reporting more than 6,000 cases as of Sunday evening.

I found some input errors on the Germany and US spreadsheets.  Those have been corrected in this version.

ShareTweet

Bill King

Related Posts

Fewer People May Be Dying in the US than Normal
COVID-19

Fewer People May Be Dying in the US than Normal

April 19, 2022
COVID-19

County Vaccine Contract Exposed as Blatant Bid-Rigging

March 20, 2022
Excess Death Analysis for 2021
COVID-19

Excess Death Analysis for 2021

March 13, 2022
Update on US & Texas COVID Stats – Omicron Going, Going, But Not Quite Gone
COVID-19

Update on US & Texas COVID Stats – Omicron Going, Going, But Not Quite Gone

February 23, 2022
Stay Home – Unless You Are Going to a Lina Hidalgo Rally
COVID-19

Stay Home – Unless You Are Going to a Lina Hidalgo Rally

February 12, 2022
Update on US & Texas COVID Stats – Omicron Peak?
COVID-19

Update on US & Texas COVID Stats – Omicron Peak?

January 25, 2022
Load More
Next Post
US-Testing-3-26

Coronavirus Testing in US Begins to Ramp Up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

By Categories

  • Book Review
  • City Of Houston Finances
  • Climate Change
  • COVID-19
  • Crime
  • Demographics
  • Economics
  • Election Reform
  • Environment
  • Ethics
  • Faith
  • Federal Government Finances
  • Flooding
  • Harris County
  • Harvey Recovery
  • homeblog
  • Human Trafficking
  • Hurricane Preparation
  • Ike Dike
  • Immigration
  • Kingwood
  • Management Districts
  • Media
  • Mobility
  • Montrose Management District
  • National Economy
  • National Economy
  • National Politics
  • Pensions
  • Police Polices & Procedures
  • Police Policies & Procedures
  • Political Parties
  • Property Taxes
  • Public Health
  • Quote of the Week
  • Race
  • Rebuild Houston
  • Rebuild Houston – Drainage Fee
  • SAM Party
  • Social Security
  • State of Texas
  • State of Texas Finances
  • TIRZ
  • Uncategorized
  • Uptown
  • Utility Grid
Bill King Blog

Posts range from local to national issues and focus on fact-based analysis, avoiding hyperbole and partisanship. The site is intended to be an open, respectful discussion of the critical issues of our day. Contact Bill directly and let him know what matters to you - weking@weking.net

Recent News

  • “The lady doth protest too much, methinks”
  • Poll:  58% of Voters Would Consider Moderate Independent in 2024 And Utah Democrats Make a Surprise Move

Our Social Media

No Result
View All Result
  • Home
  • About Bill
  • Policy Discussion
  • Categories
  • Tune in