Covid-19 Data July 17th Expanded From the Wordometers Site

As I have done several times earlier in this pandemic, below is some additional number crunching of the data. The raw source of the data is the Wordometers website. I am reporting this July 17th for July 16th data.

In all the following, I am going to only consider the 90 countries that have at least 10 million people. Smaller countries (often islands) are more likely to be outliers.

In all the following I have coloured Canada and USA yellow, as points of reference, and have also used colours to distinguish Latin America (orange), Middle East and North Africa (green), Europe (pink), Sub-Saharan Africa (blue), Southern and Eastern Asia (purple)

The three rankings I want to highlight are the following, which are not shown in the Wordometers site directly.

The first is New Deaths Per Million. This gives a sense of the recent past spread, and the state of crisis in the country currently. The top 6 such countries are in Latin America. Death rates may be somewhat inaccurate since in some places not all deaths are recorded as being Covid-caused.

The USA is 9th, and Canada is 25th, doing almost 6 times better than the USA and 12 times better than Brazil. Notable European countries are Russia, Sweden, Romania and the UK

Rank	Country	NewDeathsPerM
1	Brazil	6.1
2	Peru	6.0
3	Chile	5.4
4	Mexico	4.5
5	Colombia	4.2
6	Bolivia	3.8
7	South Africa	3.6
8	Guatemala	3.0
9	USA	2.9
10	Ecuador	2.8
11	Iran	2.4
12	Iraq	2.2
13	Argentina	1.4
14	Saudi Arabia	1.3
15	Russia	1.1
16	Dominican Republic	1.1
17	Sweden	1.0
18	Romania	1.0
19	UK	1.0
20	Azerbaijan	0.8
21	Cameroon	0.5
22	Egypt	0.5
23	India	0.5
24	Afghanistan	0.5
25	Canada	0.5
26	Malawi	0.4
27	Ukraine	0.4
28	Madagascar	0.4
29	Belgium	0.3
30	Italy	0.3
31	Portugal	0.3
32	Poland	0.3
33	Indonesia	0.3
34	France	0.3
35	Algeria	0.3
36	Philippines	0.3
37	Turkey	0.2
38	Bangladesh	0.2
39	Zimbabwe	0.2
40	Pakistan	0.2
41	Senegal	0.2
42	Haiti	0.2
43	Yemen	0.2
44	Benin	0.2
45	Kenya	0.1
46	Venezuela	0.1
47	Uzbekistan	0.1
48	Morocco	0.1
49	Germany	0.1
50	Australia	0.1
51	Guinea	0.1
52	Spain	0.1
53	Netherlands	0.1
54	Nigeria	0.0
55	S. Korea	0.0
56	Angola	0.0
57	Ethiopia	0.0
58	DRC	0.0
59	Japan	0.0
60	Kazakhstan	0.0
61	Ghana	0.0
62	Czechia	0.0
63	Zambia	0.0
64	Nepal	0.0
65	Ivory Coast	0.0
66	Rwanda	0.0
67	Burundi	0.0
68	Greece	0.0
69	Mozambique	0.0
70	South Sudan	0.0
71	Somalia	0.0
72	Syria	0.0
73	Sri Lanka	0.0
74	Tunisia	0.0
75	Jordan	0.0
76	Mali	0.0
77	Cuba	0.0
78	Uganda	0.0
79	Malaysia	0.0
80	Niger	0.0
81	Chad	0.0
82	Cambodia	0.0
83	Thailand	0.0
84	Taiwan	0.0
85	Myanmar	0.0
86	China	0.0
87	Sudan	0.0
88	Burkina Faso	0.0
89	Tanzania	0.0
90	Vietnam	0.0

The second is New Deaths / Total Deaths so far. This gives a clue as to the recency of the pandemic. Low numbers here suggest that the worst was much earlier.

In this analysis Africa is doing the worst. It doesn't bode well for the coming period in that continent. Canada is 49th in this ranking, with the USA ranked only slightly higher but Canada is doing 3 times better. 

Rank	Country	NewDeaths/TotDeaths
1	Madagascar	18.87
2	Malawi	15.69
3	Zimbabwe	13.04
4	Benin	7.14
5	Uzbekistan	5.33
6	South Africa	4.63
7	Guatemala	3.85
8	Venezuela	3.85
9	Cameroon	3.75
10	Kenya	3.69
11	Angola	3.57
12	Colombia	3.57
13	Argentina	2.94
14	India	2.66
15	Guinea	2.56
16	Iraq	2.56
17	Azerbaijan	2.40
18	Bolivia	2.27
19	Indonesia	1.96
20	Senegal	1.92
21	Saudi Arabia	1.90
22	Australia	1.77
23	Philippines	1.77
24	Afghanistan	1.71
25	Brazil	1.69
26	Peru	1.57
27	Mexico	1.57
28	Bangladesh	1.56
29	Morocco	1.52
30	Iran	1.46
31	Chile	1.43
32	Russia	1.40
33	Haiti	1.38
34	Ethiopia	1.35
35	Egypt	1.29
36	Dominican Republic	1.28
37	Ukraine	1.25
38	Nigeria	1.17
39	Yemen	1.14
40	Algeria	1.14
41	Romania	0.96
42	Ecuador	0.94
43	Pakistan	0.74
44	S. Korea	0.69
45	Poland	0.69
46	USA	0.68
47	DRC	0.52
48	Turkey	0.39
49	Canada	0.19
50	Sweden	0.18
51	Portugal	0.18
52	UK	0.15
53	Japan	0.10
54	Germany	0.10
55	France	0.06
56	Italy	0.06
57	Belgium	0.04
58	Netherlands	0.02
59	Spain	0.01
60	Kazakhstan	0.00
61	Ghana	0.00
62	Czechia	0.00
63	Zambia	0.00
64	Nepal	0.00
65	Ivory Coast	0.00
66	Rwanda	0.00
67	Burundi	0.00
68	Greece	0.00
69	Mozambique	0.00
70	South Sudan	0.00
71	Somalia	0.00
72	Syria	0.00
73	Sri Lanka	0.00
74	Tunisia	0.00
75	Jordan	0.00
76	Mali	0.00
77	Cuba	0.00
78	Malaysia	0.00
79	Niger	0.00
80	Chad	0.00
81	Thailand	0.00
82	Taiwan	0.00
83	Myanmar	0.00
84	China	0.00
85	Sudan	0.00
86	Burkina Faso	0.00
87	Tanzania	0.00
88	Uganda
89	Cambodia
90	Vietnam

The third ranking is new cases per million. This gives a sense of how bad things are getting currently and bodes badly for the next few weeks in terms of potential deaths. Top countries should clearly be locking down more. This data may be inaccurate due to different testing rates.

Here South Africa does worse followed closely by the USA. Then come a group of Latin-American countries. Canada is 36th, doing 19 times better than the USA.

Rank	Country	NewCasesPerM
1	South Africa	222.0
2	USA	221.7
3	Brazil	206.1
4	Colombia	157.9
5	Chile	130.4
6	Peru	117.1
7	Bolivia	115.7
8	Dominican Republic	98.8
9	Kazakhstan	89.1
10	Argentina	80.4
11	Saudi Arabia	79.3
12	Ecuador	58.7
13	Iraq	56.7
14	Azerbaijan	48.6
15	Guatemala	48.2
16	Mexico	47.7
17	Russia	44.0
18	Romania	40.4
19	Cameroon	37.0
20	Portugal	33.3
21	Iran	29.7
22	Spain	29.1
23	India	25.7
24	Ghana	22.4
25	Philippines	21.8
26	Ukraine	19.4
27	Zimbabwe	18.4
28	Madagascar	17.5
29	Bangladesh	16.6
30	Venezuela	15.0
31	Uzbekistan	14.5
32	Belgium	14.4
33	Algeria	13.3
34	Czechia	12.8
35	Australia	12.7
36	Canada	11.5
37	Sweden	11.4
38	Turkey	11.1
39	Pakistan	9.7
40	UK	9.4
41	Egypt	9.1
42	Poland	8.8
43	France	8.2
44	Kenya	7.8
45	Morocco	7.7
46	Benin	7.0
47	Germany	7.0
48	Senegal	6.7
49	Zambia	6.5
50	Guinea	6.3
51	Haiti	6.2
52	Netherlands	5.8
53	Indonesia	5.8
54	Nepal	5.7
55	Ivory Coast	5.7
56	Malawi	5.1
57	Italy	3.8
58	Japan	3.0
59	Rwanda	2.9
60	Nigeria	2.9
61	Burundi	2.9
62	Greece	2.8
63	Ethiopia	2.6
64	Afghanistan	2.0
65	Mozambique	1.7
66	South Sudan	1.6
67	Somalia	1.4
68	S. Korea	1.2
69	Syria	1.1
70	Angola	0.9
71	Yemen	0.9
72	Sri Lanka	0.7
73	Tunisia	0.7
74	Jordan	0.5
75	DRC	0.4
76	Mali	0.3
77	Cuba	0.2
78	Uganda	0.2
79	Malaysia	0.1
80	Niger	0.1
81	Chad	0.1
82	Cambodia	0.1
83	Thailand	0.1
84	Taiwan	0.0
85	Myanmar	0.0
86	China	0.0
87	Sudan	0.0
88	Burkina Faso	0.0
89	Tanzania	0.0
90	Vietnam	0.0