Charts and tables updated with 23.04 data. Please go here for missing definitions. Key findings:
- Belgium probably over reported Covid19 deaths
- New cases at Singapore are surging, mortality is still low
- No unified definition of Covid19 inflicted death obstructs country data comparison
- Country lock down does not compensate high population density
Deaths per 1 million population
- Calculate daily deaths per 1 million people (deaths_1M) defined as:
(deaths in country on given day) / (country population size) * (1 million) - Take all countries from ECDC data set with more than 10 cumulative Covid-19 deaths and more than 100 detected cases, sort descending by deaths_1M
- Take top 10 countries from above list and plot results
Isle of Man joined top group, it has population of 80 thousands, 15 deaths
No changes in above one million population countries group
Cases per 1 million population
Ranking created like the one for deaths:
- Calculate daily cases per 1 million people (cases_1M) defined as:
(new cases in country on given day) / (country population size) * (1 million) - Take all countries from ECDC data set with more than 10 cumulative Covid-19 deaths and more than 100 detected cases, sort descending by cases_1M
- Take top 10 countries from above list and plot results
Please note Luxembourg is 3rd in all countries ranking, it has around 600 thousands inhabitants. It seems to be well after infections peak.
Singapore cases are growing rapidly, death count is still tiny. We’ll keep an eye on it.
High and low cases mortality countries
- More than 20 cumulative deaths and 10000 cumulative cases
- Sort by cases mortality rate
- Take top 5 and bottom 5 from above list
- Add Germany to result
Sweden replaced Netherlands in top 5. Saudi Arabia joined bottom 5 (exceeded 20 deaths threshold)
As of 2020-04-23 there were 29 countries meeting 100 cumulative deaths and 10000 cumulative cases threshold. They are listed in table below sorted by cases mortality rate top down. Poland is among new countries in the group.
Country | pop2018 | CumCases | CumDeaths | CumDeaths_1M | CasesMortality |
---|---|---|---|---|---|
France | 66987244 | 119151 | 21340 | 318.6 | 17.91 |
Belgium | 11422068 | 41889 | 6262 | 548.2 | 14.95 |
United Kingdom | 66488991 | 133495 | 18100 | 272.2 | 13.56 |
Italy | 60431283 | 187327 | 25085 | 415.1 | 13.39 |
Sweden | 10183175 | 16004 | 1937 | 190.2 | 12.10 |
Netherlands | 17231017 | 34842 | 4054 | 235.3 | 11.64 |
Spain | 46723749 | 208389 | 21717 | 464.8 | 10.42 |
Mexico | 126190788 | 10544 | 970 | 7.7 | 9.20 |
Iran, Islamic Republic of | 81800269 | 85996 | 5391 | 65.9 | 6.27 |
Brazil | 209469333 | 45757 | 2906 | 13.9 | 6.35 |
United States of America | 327167434 | 842629 | 46784 | 143.0 | 5.55 |
China | 1392730000 | 83876 | 4636 | 3.3 | 5.53 |
Ecuador | 17084357 | 10850 | 537 | 31.4 | 4.95 |
Canada | 37058856 | 40179 | 1974 | 53.3 | 4.91 |
Ireland | 4853506 | 16671 | 769 | 158.4 | 4.61 |
Switzerland | 8516543 | 28186 | 1216 | 142.8 | 4.31 |
Poland | 37978548 | 10169 | 426 | 11.2 | 4.19 |
Portugal | 10281762 | 21982 | 785 | 76.3 | 3.57 |
Germany | 82927922 | 148046 | 5094 | 61.4 | 3.44 |
India | 1352617328 | 21393 | 681 | 0.5 | 3.18 |
Austria | 8847037 | 14924 | 494 | 55.8 | 3.31 |
Peru | 31989256 | 19250 | 530 | 16.6 | 2.75 |
Japan | 126529100 | 11772 | 287 | 2.3 | 2.44 |
Turkey | 82319724 | 98674 | 2376 | 28.9 | 2.41 |
Korea, Republic of | 51635256 | 10702 | 240 | 4.6 | 2.24 |
Chile | 18729160 | 11296 | 160 | 8.5 | 1.42 |
Israel | 8883800 | 14592 | 191 | 21.5 | 1.31 |
Saudi Arabia | 33699947 | 12772 | 114 | 3.4 | 0.89 |
Russian Federation | 144478050 | 57999 | 513 | 3.6 | 0.88 |
Country insight
Change in layout of this section we compare countries selected after lock down measures severity. Numbers on list below reflect country ranking
- Belgium – moderate: business shutdown, sport activities outside allowed. Population density 376/km2
- France – severe: business shutdown, stay at home order so no sports outside. Population density 104/km2
- Sweden – relaxed: Keep social distance but some public places remain open. Population density 23/km2
It seems Covid19 impact grows with population density. In my opinion lock down measures efficiency is limited in densely populated areas.
Daily deaths
Belgium ranking can be overstated. There were comments Belgium reported all deaths in nursery houses for eledery people as Covid19 caused without actual virus presence test. This practice has been probably abolish recently. We’ll try to investigate it further. Please note there is no unified definition of Covid19 victim, so deaths reported in countries may adopt different criteria. Unfortunately there is no information on total daily deaths in ECDC data set.
Daily cases
I do hope France under reports cases, otherwise 18% cases mortality looks scary.
Cumulative cases and deaths
Newcomer – Poland
Poland matches standard pattern: Low testing capacity focuses on more severe cases with higher death probability. In result cases mortality goes up.
Population mortality
- Calculate cumulative deaths per 1 million people (cumdeaths_1M) defined as:
(total deaths in country till given date) / (country population size) * 1 million - Take countries with population above 1 million
- Sort by cumdeaths_1M descending
- Select top 5 from above list
Belgium qualified all deceased in nursery houses as Covid19 victims without testing for actual virus presence. The line should be revised down probably.
Covidmeter
San Marino reference line uptick due to additional death. Please remember population is tiny, every deaths is visible. Lack of common definition of Covid19 fatality can easily obscure this ranking.