About Data

This report is created to check daily change in COVID19 cases. Data for analysis is taken from given link.

Table 1: Top 20 countrise on the basis of confirmed cases

## # A tibble: 20 x 7
##    Country_Region   Ccase   Acase  Rcase  Dcase    RR    DR
##    <fct>            <int>   <int>  <int>  <int> <dbl> <dbl>
##  1 US             2422299 1558389 663562 124410  27.4   5.1
##  2 Brazil         1228114  493619 679524  54971  55.3   4.5
##  3 Russia          613148  229997 374557   8594  61.1   1.4
##  4 India           490401  189463 285637  15301  58.2   3.1
##  5 United Kingdom  309455  264780   1361  43314   0.4  14  
##  6 Peru            268602  108616 151225   8761  56.3   3.3
##  7 Chile           259064   34834 219327   4903  84.7   1.9
##  8 Spain           247486   68780 150376  28330  60.8  11.4
##  9 Italy           239706   18303 186725  34678  77.9  14.5
## 10 Iran            215096   29863 175103  10130  81.4   4.7
## 11 Mexico          202951   25529 152362  25060  75.1  12.3
## 12 France          197885   92655  75475  29755  38.1  15  
## 13 Pakistan        195745  107615  84168   3962  43     2  
## 14 Germany         193371    7667 176764   8940  91.4   4.6
## 15 Turkey          193115   22363 165706   5046  85.8   2.6
## 16 Saudi Arabia    170639   51329 117882   1428  69.1   0.8
## 17 Bangladesh      126606   73490  51495   1621  40.7   1.3
## 18 South Africa    118375   56109  59974   2292  50.7   1.9
## 19 Canada          104463   29027  66869   8567  64     8.2
## 20 Qatar            91838   17188  74544    106  81.2   0.1

Table 2: Top 20 countrise on the basis of active cases

## # A tibble: 20 x 7
##    Country_Region   Ccase   Acase  Rcase  Dcase    RR    DR
##    <fct>            <int>   <int>  <int>  <int> <dbl> <dbl>
##  1 US             2422299 1558389 663562 124410  27.4   5.1
##  2 Brazil         1228114  493619 679524  54971  55.3   4.5
##  3 United Kingdom  309455  264780   1361  43314   0.4  14  
##  4 Russia          613148  229997 374557   8594  61.1   1.4
##  5 India           490401  189463 285637  15301  58.2   3.1
##  6 Peru            268602  108616 151225   8761  56.3   3.3
##  7 Pakistan        195745  107615  84168   3962  43     2  
##  8 France          197885   92655  75475  29755  38.1  15  
##  9 Bangladesh      126606   73490  51495   1621  40.7   1.3
## 10 Spain           247486   68780 150376  28330  60.8  11.4
## 11 Sweden           63890   58660      0   5230   0     8.2
## 12 South Africa    118375   56109  59974   2292  50.7   1.9
## 13 Saudi Arabia    170639   51329 117882   1428  69.1   0.8
## 14 Netherlands      50122   43817    186   6119   0.4  12.2
## 15 Colombia         77313   42973  31729   2611  41     3.4
## 16 Egypt            61130   42259  16338   2533  26.7   4.1
## 17 Argentina        52457   36519  14788   1150  28.2   2.2
## 18 Chile           259064   34834 219327   4903  84.7   1.9
## 19 Belgium          61007   34391  16890   9726  27.7  15.9
## 20 Iran            215096   29863 175103  10130  81.4   4.7

Table 3: Top 20 countrise on the basis of recovered cases

## # A tibble: 20 x 7
##    Country_Region   Ccase   Acase  Rcase  Dcase    RR    DR
##    <fct>            <int>   <int>  <int>  <int> <dbl> <dbl>
##  1 Brazil         1228114  493619 679524  54971  55.3   4.5
##  2 US             2422299 1558389 663562 124410  27.4   5.1
##  3 Russia          613148  229997 374557   8594  61.1   1.4
##  4 India           490401  189463 285637  15301  58.2   3.1
##  5 Chile           259064   34834 219327   4903  84.7   1.9
##  6 Italy           239706   18303 186725  34678  77.9  14.5
##  7 Germany         193371    7667 176764   8940  91.4   4.6
##  8 Iran            215096   29863 175103  10130  81.4   4.7
##  9 Turkey          193115   22363 165706   5046  85.8   2.6
## 10 Mexico          202951   25529 152362  25060  75.1  12.3
## 11 Peru            268602  108616 151225   8761  56.3   3.3
## 12 Spain           247486   68780 150376  28330  60.8  11.4
## 13 Saudi Arabia    170639   51329 117882   1428  69.1   0.8
## 14 Pakistan        195745  107615  84168   3962  43     2  
## 15 China            84701     488  79572   4641  93.9   5.5
## 16 France          197885   92655  75475  29755  38.1  15  
## 17 Qatar            91838   17188  74544    106  81.2   0.1
## 18 Canada          104463   29027  66869   8567  64     8.2
## 19 South Africa    118375   56109  59974   2292  50.7   1.9
## 20 Bangladesh      126606   73490  51495   1621  40.7   1.3

Table 4: Top 20 countrise on the basis of death cases

## # A tibble: 20 x 7
##    Country_Region   Ccase   Acase  Rcase  Dcase    RR    DR
##    <fct>            <int>   <int>  <int>  <int> <dbl> <dbl>
##  1 US             2422299 1558389 663562 124410  27.4   5.1
##  2 Brazil         1228114  493619 679524  54971  55.3   4.5
##  3 United Kingdom  309455  264780   1361  43314   0.4  14  
##  4 Italy           239706   18303 186725  34678  77.9  14.5
##  5 France          197885   92655  75475  29755  38.1  15  
##  6 Spain           247486   68780 150376  28330  60.8  11.4
##  7 Mexico          202951   25529 152362  25060  75.1  12.3
##  8 India           490401  189463 285637  15301  58.2   3.1
##  9 Iran            215096   29863 175103  10130  81.4   4.7
## 10 Belgium          61007   34391  16890   9726  27.7  15.9
## 11 Germany         193371    7667 176764   8940  91.4   4.6
## 12 Peru            268602  108616 151225   8761  56.3   3.3
## 13 Russia          613148  229997 374557   8594  61.1   1.4
## 14 Canada          104463   29027  66869   8567  64     8.2
## 15 Netherlands      50122   43817    186   6119   0.4  12.2
## 16 Sweden           63890   58660      0   5230   0     8.2
## 17 Turkey          193115   22363 165706   5046  85.8   2.6
## 18 Chile           259064   34834 219327   4903  84.7   1.9
## 19 China            84701     488  79572   4641  93.9   5.5
## 20 Ecuador          53156   22716  26097   4343  49.1   8.2

Table 5: Top 20 countrise on the basis of recovery rate

Countries more than 1000 cases

## # A tibble: 20 x 7
##    Country_Region  Ccase Acase  Rcase Dcase    RR    DR
##    <fct>           <int> <int>  <int> <int> <dbl> <dbl>
##  1 Iceland          1830     9   1811    10  99     0.5
##  2 New Zealand      1520    14   1484    22  97.6   1.4
##  3 Malaysia         8600   208   8271   121  96.2   1.4
##  4 Thailand         3158    62   3038    58  96.2   1.8
##  5 Luxembourg       4151    73   3968   110  95.6   2.6
##  6 China           84701   488  79572  4641  93.9   5.5
##  7 Cuba             2321    65   2171    85  93.5   3.7
##  8 Austria         17477   459  16320   698  93.4   4  
##  9 Norway           8788   401   8138   249  92.6   2.8
## 10 Switzerland     31428   470  29000  1958  92.3   6.2
## 11 Djibouti         4635   314   4269    52  92.1   1.1
## 12 Finland          7172   245   6600   327  92     4.6
## 13 Ireland         25405   314  23364  1727  92     6.8
## 14 Australia        7595   533   6958   104  91.6   1.4
## 15 Germany        193371  7667 176764  8940  91.4   4.6
## 16 Serbia          13372   954  12154   264  90.9   2  
## 17 Denmark         12836   573  11660   603  90.8   4.7
## 18 Estonia          1984   125   1790    69  90.2   3.5
## 19 Japan           18055   942  16142   971  89.4   5.4
## 20 Slovakia         1630   150   1452    28  89.1   1.7

Table 6: Bottom 20 countrise on the basis of recovery rate

## # A tibble: 20 x 7
##    Country_Region             Ccase   Acase  Rcase  Dcase    RR    DR
##    <fct>                      <int>   <int>  <int>  <int> <dbl> <dbl>
##  1 Venezuela                   4563    3197   1327     39  29.1   0.9
##  2 Benin                       1017     715    288     14  28.3   1.4
##  3 Argentina                  52457   36519  14788   1150  28.2   2.2
##  4 Belgium                    61007   34391  16890   9726  27.7  15.9
##  5 US                       2422299 1558389 663562 124410  27.4   5.1
##  6 Philippines                33069   22947   8910   1212  26.9   3.7
##  7 Egypt                      61130   42259  16338   2533  26.7   4.1
##  8 Bolivia                    28503   20252   7338    913  25.7   3.2
##  9 Equatorial Guinea           2001    1454    515     32  25.7   1.6
## 10 Nepal                      11162    8486   2650     26  23.7   0.2
## 11 Guatemala                  15619   12047   2949    623  18.9   4  
## 12 Central African Republic    3244    2597    607     40  18.7   1.2
## 13 Congo (Kinshasa)            6411    5384    885    142  13.8   2.2
## 14 Guinea-Bissau               1556    1346    191     19  12.3   1.2
## 15 South Sudan                 1942    1682    224     36  11.5   1.9
## 16 Honduras                   15366   13340   1600    426  10.4   2.8
## 17 Haiti                       5543    4935    512     96   9.2   1.7
## 18 Netherlands                50122   43817    186   6119   0.4  12.2
## 19 United Kingdom            309455  264780   1361  43314   0.4  14  
## 20 Sweden                     63890   58660      0   5230   0     8.2

Table 7: Top 20 countrise on the basis of death rate

## # A tibble: 20 x 7
##    Country_Region  Ccase  Acase  Rcase Dcase    RR    DR
##    <fct>           <int>  <int>  <int> <int> <dbl> <dbl>
##  1 Yemen            1076    402    386   288  35.9  26.8
##  2 Belgium         61007  34391  16890  9726  27.7  15.9
##  3 France         197885  92655  75475 29755  38.1  15  
##  4 Italy          239706  18303 186725 34678  77.9  14.5
##  5 Hungary          4123    906   2640   577  64    14  
##  6 United Kingdom 309455 264780   1361 43314   0.4  14  
##  7 Mexico         202951  25529 152362 25060  75.1  12.3
##  8 Netherlands     50122  43817    186  6119   0.4  12.2
##  9 Spain          247486  68780 150376 28330  60.8  11.4
## 10 Canada         104463  29027  66869  8567  64     8.2
## 11 Ecuador         53156  22716  26097  4343  49.1   8.2
## 12 Sweden          63890  58660      0  5230   0     8.2
## 13 Algeria         12445   2647   8920   878  71.7   7.1
## 14 Slovenia         1547     62   1376   109  88.9   7  
## 15 Ireland         25405    314  23364  1727  92     6.8
## 16 Niger            1056     72    917    67  86.8   6.3
## 17 Romania         25286   5815  17906  1565  70.8   6.2
## 18 Sudan            8984   4622   3806   556  42.4   6.2
## 19 Switzerland     31428    470  29000  1958  92.3   6.2
## 20 Greece           3321   1756   1374   191  41.4   5.8

Table 8: Bottom 20 countrise on the basis of death rate

## # A tibble: 20 x 7
##    Country_Region        Ccase Acase  Rcase Dcase    RR    DR
##    <fct>                 <int> <int>  <int> <int> <dbl> <dbl>
##  1 Kuwait                42788  9082  33367   339  78     0.8
##  2 Paraguay               1569   580    976    13  62.2   0.8
##  3 Saudi Arabia         170639 51329 117882  1428  69.1   0.8
##  4 Cote d'Ivoire          8334  4787   3487    60  41.8   0.7
##  5 Kazakhstan            19750  7390  12220   140  61.9   0.7
##  6 United Arab Emirates  46563 11090  35165   308  75.5   0.7
##  7 Belarus               60382 18567  41448   367  68.6   0.6
##  8 Ghana                 15473  3947  11431    95  73.9   0.6
##  9 Guinea                 5174  1284   3861    29  74.6   0.6
## 10 Iceland                1830     9   1811    10  99     0.5
## 11 Sri Lanka              2010   397   1602    11  79.7   0.5
## 12 Costa Rica             2684  1445   1227    12  45.7   0.4
## 13 Maldives               2277   421   1848     8  81.2   0.4
## 14 Oman                  34902 16238  18520   144  53.1   0.4
## 15 Bahrain               24081  5509  18501    71  76.8   0.3
## 16 Uzbekistan             7177  2280   4877    20  68     0.3
## 17 Nepal                 11162  8486   2650    26  23.7   0.2
## 18 West Bank and Gaza     1382   933    446     3  32.3   0.2
## 19 Qatar                 91838 17188  74544   106  81.2   0.1
## 20 Singapore             42736  6106  36604    26  85.7   0.1

Table 9: India and it’s neighbouring countries profile

## # A tibble: 9 x 7
##   Country_Region  Ccase  Acase  Rcase Dcase    RR    DR
##   <fct>           <int>  <int>  <int> <int> <dbl> <dbl>
## 1 China           84701    488  79572  4641  93.9   5.5
## 2 India          490401 189463 285637 15301  58.2   3.1
## 3 Afghanistan     30175  19326  10174   675  33.7   2.2
## 4 Burma             293     76    211     6  72     2  
## 5 Pakistan       195745 107615  84168  3962  43     2  
## 6 Bangladesh     126606  73490  51495  1621  40.7   1.3
## 7 Sri Lanka        2010    397   1602    11  79.7   0.5
## 8 Nepal           11162   8486   2650    26  23.7   0.2
## 9 Bhutan             70     36     34     0  48.6   0

Acknowledgment: JHU CCSE repository developers