Tuesday, March 17, 2020

Map of Covid-19 cases per million - March 17, 2020

The following chart shows the number of cases per million people in the various countries of world as of March 17th. (For followup showing the same visualization method, see my post on March 22)



This shows the number of cases since the first outbreak (not current cases). It clearly shows that the EU is in fact doing much worse than China. It also shows the UK and US are the are the 'big' countries next in line, closely followed by Australia and Canada.

I will do more posts in the days to come showing how this is evolving and also showing current cases.

This map was generated as follows:

1. I took data of current cases from Bing https://www.bing.com/covid by simply cutting and pasting into Excel. Update: It turns out that Bing was getting most of its data from Wikipedia, which was in turn getting most of its data from here: https://www.worldometers.info/coronavirus/#countries. In future I will use the latter (although Worldometers does not give the 'cases per million' in its table for countries with less than a million).

2. I used Excel's Map charting capability to create the above map. Information about how to do that is here: https://support.office.com/en-us/article/format-a-map-chart-2c744937-a1cc-48f7-bc5e-776497343a29. Population of countries is generated in Excel directly from Bing sources.

Note that Diamond Princess data was attributed to Japan.

Below is a table of data for the countries with 10 or more per million.

CountryCases per millionCasesPopulation
San Marino3443.1111533,400
Vatican City1000.0011,000
Iceland616.16220357,050
Italy462.092798060,551,416
Switzerland323.8827428,466,017
Norway271.0114445,328,212
Spain242.061131246,733,038
Monaco232.59938,695
Luxembourg228.05140613,900
Iran199.221616981,162,788
Liechtenstein184.59737,922
Andorra183.781476,177
Denmark177.0310255,789,957
Estonia169.832251,324,820
Qatar166.344392,639,211
South Korea161.66832051,466,201
Bahrain158.792371,492,584
Austria151.2113328,809,212
Slovenia132.082732,066,880
Brunei130.6356428,697
Sweden115.60119110,302,984
Belgium107.94124311,515,793
Germany103.69860482,979,100
Netherlands99.59171117,181,084
France98.82663367,118,648
Malta81.6738465,292
Finland58.433225,511,303
China58.34808811,386,395,000
Singapore47.402665,612,253
Ireland46.332234,813,608
Portugal42.2644810,600,000
Cyprus39.00461,179,551
Czech Republic37.1839610,649,800
Israel36.443248,891,800
Greece35.9738710,760,421
Kuwait31.431304,136,528
Seychelles31.30395,843
Latvia31.09601,929,900
Maldives29.7913436,330
United Kingdom29.54195066,022,273
Armenia24.57722,930,450
Hong Kong21.651627,482,500
Malaysia21.2867331,624,264
Macau20.8813622,567
Lebanon19.671206,100,075
Albania19.14552,873,457
Australia18.3445224,641,662
Panama16.84694,098,587
United States16.005213325,719,178
Croatia15.83654,105,493
Slovakia15.44845,439,892
Republic of North Macedonia13.01272,075,301
Japan12.611574124,776,364
Canada12.2344936,708,083
Bulgaria11.45817,075,991
Romania11.3322219,586,539
Saint Lucia11.182178,844
Chile11.1320118,054,726
United Arab Emirates10.43989,400,145
Palestinian National Authority10.20414019000

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.