[Live] Spikes in Cases and Deaths - Coronavirus Pandemic : Real Time Counter, World Map, News

Coronavirus Live Streaming: Spike of Confirmed Cases and Deaths, Ratio of Death per Cases.

On Jan 26th, the first live stream, "Coronavirus Pandemic: Real Time Counter, World Map, News" was started. I aimed to provide very basic information about current numbers of confirmed cases, deaths, recovered patients. Recently I felt this streaming couldn't reflect current situations because of some problems. Although there apparently exist some countries showing surge of case or death, current dashboard couldn't focus on those countries. And due to the discrepancy between official recovered patients and estimated numbers, old streaming (streaming based on active cases) was less meaningful.

To tackle these problems, I selected 3 values from total cases and total death for last 5 days - Case Growth Rate (CGR), Death Growth Rate (DGR) and Deaths per Cases ratio(DPC). Announcing the number of recovered patients, performed tests and patients in ICU is not mandatory, there are many blanks in data. Thus I chose only case and death to show severity.

To measure bursts of case and death, calculating slope of cumulative graph is a reasonable choice. When we comparing country's CGR to world average CGR, we can guess a current situation glimely.
The reason of high DPC is various. A large cluster of elderly people like nursing home or population of underlying disease. If causes of high DPC are remained unsolved for a long time, CGR and DGR become smaller as if there is no bad situation. So I take DPC as a indicator of bad situation.

I simply added all 3 values. When comparing to world average value, a higher Severity Index represents a worse situation. But the comparison between adjacent countries is impossible, because I didn't do statiscal analysis. It's impossible to say how much differences in severity index shows statiscally significance.

There are still many obstacle in production and distribution of vaccine. Seeing optimistic results of vaccine trials, we can see exit of long tunnel faintly. Until we get vaccine, we must face cold winter season at least once. To protect neighbor's family and friends, I strongly recomment to use mask.
I really hope everything would be returned as we lived before Pandemic.
And I always appreciate to all moderators. I still feel pain thinking of their hard time. Seeing my country ruined by this virus is really painful. I hope everyone is ok. Stephanie Hughes, Random, Entrenched Trader, Droid Knight, Craft Fan, Fries, jlpowell73, The NCV, Josh Leathers,The Eldritch God, srpk khin, Hitz1001, Redchief, GildArt by Gilda, emmamec, lambi, AmberLeanne, DukeHeart, Green Rock Films, Charlie, amithist57, Billy C, Kiha Wihane, syeda bukhari and Kesrako.

For those who are affected by this unfortunate outbreak, please keep them in your thoughts.
Source google spreadsheet: https://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vS-OxrDtDBTCX2USuoFYo2V2rQN-zvZecEe3qLCGVrMbuP4COh9GrR_hh2MuleKewwzuH5UKQKD6-0b/pubhtml?gid=242649667&single=true

Видео [Live] Spikes in Cases and Deaths - Coronavirus Pandemic : Real Time Counter, World Map, News канала Roylab Stats