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             2279879 1463372 622133 119969  27.3   5.3
##  2 Brazil         1085038  433845 600576  50617  55.4   4.7
##  3 Russia          583879  236636 339142   8101  58.1   1.4
##  4 India           425282  174387 237196  13699  55.8   3.2
##  5 United Kingdom  305803  261767   1319  42717   0.4  14  
##  6 Peru            251338  101510 141967   7861  56.5   3.1
##  7 Spain           246272   67573 150376  28323  61.1  11.5
##  8 Chile           242355   37307 200569   4479  82.8   1.8
##  9 Italy           238499   20972 182893  34634  76.7  14.5
## 10 Iran            204952   31738 163591   9623  79.8   4.7
## 11 France          197008   92869  74496  29643  37.8  15  
## 12 Germany         191272    7637 174740   8895  91.4   4.7
## 13 Turkey          187685   22495 160240   4950  85.4   2.6
## 14 Pakistan        181088  106040  71458   3590  39.5   2  
## 15 Mexico          180545   24225 134495  21825  74.5  12.1
## 16 Saudi Arabia    157612   55215 101130   1267  64.2   0.8
## 17 Bangladesh      112306   65765  45077   1464  40.1   1.3
## 18 Canada          103078   29347  65249   8482  63.3   8.2
## 19 South Africa     97302   43764  51608   1930  53     2  
## 20 Qatar            87369   18952  68319     98  78.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             2279879 1463372 622133 119969  27.3   5.3
##  2 Brazil         1085038  433845 600576  50617  55.4   4.7
##  3 United Kingdom  305803  261767   1319  42717   0.4  14  
##  4 Russia          583879  236636 339142   8101  58.1   1.4
##  5 India           425282  174387 237196  13699  55.8   3.2
##  6 Pakistan        181088  106040  71458   3590  39.5   2  
##  7 Peru            251338  101510 141967   7861  56.5   3.1
##  8 France          197008   92869  74496  29643  37.8  15  
##  9 Spain           246272   67573 150376  28323  61.1  11.5
## 10 Bangladesh      112306   65765  45077   1464  40.1   1.3
## 11 Saudi Arabia    157612   55215 101130   1267  64.2   0.8
## 12 Sweden           56043   50990      0   5053   0     9  
## 13 South Africa     97302   43764  51608   1930  53     2  
## 14 Netherlands      49801   43506    186   6109   0.4  12.3
## 15 Colombia         68836   39071  27412   2353  39.8   3.4
## 16 Egypt            55233   38304  14736   2193  26.7   4  
## 17 Chile           242355   37307 200569   4479  82.8   1.8
## 18 Belgium          60550   34083  16771   9696  27.7  16  
## 19 Iran            204952   31738 163591   9623  79.8   4.7
## 20 Canada          103078   29347  65249   8482  63.3   8.2

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 US             2279879 1463372 622133 119969  27.3   5.3
##  2 Brazil         1085038  433845 600576  50617  55.4   4.7
##  3 Russia          583879  236636 339142   8101  58.1   1.4
##  4 India           425282  174387 237196  13699  55.8   3.2
##  5 Chile           242355   37307 200569   4479  82.8   1.8
##  6 Italy           238499   20972 182893  34634  76.7  14.5
##  7 Germany         191272    7637 174740   8895  91.4   4.7
##  8 Iran            204952   31738 163591   9623  79.8   4.7
##  9 Turkey          187685   22495 160240   4950  85.4   2.6
## 10 Spain           246272   67573 150376  28323  61.1  11.5
## 11 Peru            251338  101510 141967   7861  56.5   3.1
## 12 Mexico          180545   24225 134495  21825  74.5  12.1
## 13 Saudi Arabia    157612   55215 101130   1267  64.2   0.8
## 14 China            84572     398  79535   4639  94     5.5
## 15 France          197008   92869  74496  29643  37.8  15  
## 16 Pakistan        181088  106040  71458   3590  39.5   2  
## 17 Qatar            87369   18952  68319     98  78.2   0.1
## 18 Canada          103078   29347  65249   8482  63.3   8.2
## 19 South Africa     97302   43764  51608   1930  53     2  
## 20 Bangladesh      112306   65765  45077   1464  40.1   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             2279879 1463372 622133 119969  27.3   5.3
##  2 Brazil         1085038  433845 600576  50617  55.4   4.7
##  3 United Kingdom  305803  261767   1319  42717   0.4  14  
##  4 Italy           238499   20972 182893  34634  76.7  14.5
##  5 France          197008   92869  74496  29643  37.8  15  
##  6 Spain           246272   67573 150376  28323  61.1  11.5
##  7 Mexico          180545   24225 134495  21825  74.5  12.1
##  8 India           425282  174387 237196  13699  55.8   3.2
##  9 Belgium          60550   34083  16771   9696  27.7  16  
## 10 Iran            204952   31738 163591   9623  79.8   4.7
## 11 Germany         191272    7637 174740   8895  91.4   4.7
## 12 Canada          103078   29347  65249   8482  63.3   8.2
## 13 Russia          583879  236636 339142   8101  58.1   1.4
## 14 Peru            251338  101510 141967   7861  56.5   3.1
## 15 Netherlands      49801   43506    186   6109   0.4  12.3
## 16 Sweden           56043   50990      0   5053   0     9  
## 17 Turkey          187685   22495 160240   4950  85.4   2.6
## 18 China            84572     398  79535   4639  94     5.5
## 19 Chile           242355   37307 200569   4479  82.8   1.8
## 20 Ecuador          50640   21426  24991   4223  49.4   8.3

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          1823     8   1805    10  99     0.5
##  2 New Zealand      1513     9   1482    22  98     1.5
##  3 Luxembourg       4120    54   3956   110  96     2.7
##  4 Thailand         3148    72   3018    58  95.9   1.8
##  5 Malaysia         8572   295   8156   121  95.1   1.4
##  6 China           84572   398  79535  4639  94     5.5
##  7 Austria         17341   454  16197   690  93.4   4  
##  8 Norway           8745   363   8138   244  93.1   2.8
##  9 Serbia          12894   686  11947   261  92.7   2  
## 10 Switzerland     31292   336  29000  1956  92.7   6.3
## 11 Australia        7474   469   6903   102  92.4   1.4
## 12 Croatia          2317    68   2142   107  92.4   4.6
## 13 Germany        191272  7637 174740  8895  91.4   4.7
## 14 Denmark         12591   509  11482   600  91.2   4.8
## 15 Slovakia         1587   112   1447    28  91.2   1.8
## 16 Cuba             2312   124   2103    85  91     3.7
## 17 Slovenia         1520    35   1376   109  90.5   7.2
## 18 Japan           17780   877  15948   955  89.7   5.4
## 19 Ireland         25379   966  22698  1715  89.4   6.8
## 20 Estonia          1981   148   1764    69  89     3.5

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 Somalia                     2779    1907    782     90  28.1   3.2
##  2 Belgium                    60550   34083  16771   9696  27.7  16  
##  3 US                       2279879 1463372 622133 119969  27.3   5.3
##  4 Mauritania                  2984    2062    811    111  27.2   3.7
##  5 Ethiopia                    4532    3245   1213     74  26.8   1.6
##  6 Egypt                      55233   38304  14736   2193  26.7   4  
##  7 Philippines                30052   20990   7893   1169  26.3   3.9
##  8 Bolivia                    24388   18161   5454    773  22.4   3.2
##  9 Venezuela                   3917    3049    835     33  21.3   0.8
## 10 Guatemala                  13145    9903   2711    531  20.6   4  
## 11 Nepal                       9026    7231   1772     23  19.6   0.3
## 12 Central African Republic    2808    2313    472     23  16.8   0.8
## 13 Congo (Kinshasa)            5826    4855    841    130  14.4   2.2
## 14 Honduras                   12769   11113   1293    363  10.1   2.8
## 15 Guinea-Bissau               1541    1371    153     17   9.9   1.1
## 16 South Sudan                 1892    1689    169     34   8.9   1.8
## 17 Haiti                       5077    4965     24     88   0.5   1.7
## 18 Netherlands                49801   43506    186   6109   0.4  12.3
## 19 United Kingdom            305803  261767   1319  42717   0.4  14  
## 20 Sweden                     56043   50990      0   5053   0     9

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 Belgium         60550  34083  16771  9696  27.7  16  
##  2 France         197008  92869  74496 29643  37.8  15  
##  3 Italy          238499  20972 182893 34634  76.7  14.5
##  4 United Kingdom 305803 261767   1319 42717   0.4  14  
##  5 Hungary          4094    935   2589   570  63.2  13.9
##  6 Netherlands     49801  43506    186  6109   0.4  12.3
##  7 Mexico         180545  24225 134495 21825  74.5  12.1
##  8 Spain          246272  67573 150376 28323  61.1  11.5
##  9 Sweden          56043  50990      0  5053   0     9  
## 10 Ecuador         50640  21426  24991  4223  49.4   8.3
## 11 Canada         103078  29347  65249  8482  63.3   8.2
## 12 Algeria         11771   2504   8422   845  71.5   7.2
## 13 Slovenia         1520     35   1376   109  90.5   7.2
## 14 Ireland         25379    966  22698  1715  89.4   6.8
## 15 Niger            1036     58    911    67  87.9   6.5
## 16 Romania         24045   5622  16911  1512  70.3   6.3
## 17 Switzerland     31292    336  29000  1956  92.7   6.3
## 18 Sudan            8580   4734   3325   521  38.8   6.1
## 19 Greece           3266   1702   1374   190  42.1   5.8
## 20 Mali             1933    569   1255   109  64.9   5.6

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                39650  8084  31240   326  78.8   0.8
##  2 Saudi Arabia         157612 55215 101130  1267  64.2   0.8
##  3 Venezuela              3917  3049    835    33  21.3   0.8
##  4 Zambia                 1430   225   1194    11  83.5   0.8
##  5 Cote d'Ivoire          7492  4370   3068    54  41     0.7
##  6 Kazakhstan            17732  6715  10897   120  61.5   0.7
##  7 United Arab Emirates  44925 12208  32415   302  72.2   0.7
##  8 Belarus               58505 20493  37666   346  64.4   0.6
##  9 Ghana                 14154  3596  10473    85  74     0.6
## 10 Sri Lanka              1950   441   1498    11  76.8   0.6
## 11 Costa Rica             2213  1169   1032    12  46.6   0.5
## 12 Guinea                 4988  1292   3669    27  73.6   0.5
## 13 Iceland                1823     8   1805    10  99     0.5
## 14 Maldives               2203   392   1803     8  81.8   0.4
## 15 Oman                  29471 13788  15552   131  52.8   0.4
## 16 Bahrain               21764  5282  16419    63  75.4   0.3
## 17 Nepal                  9026  7231   1772    23  19.6   0.3
## 18 Uzbekistan             6315  1919   4377    19  69.3   0.3
## 19 Qatar                 87369 18952  68319    98  78.2   0.1
## 20 Singapore             42095  7127  34942    26  83     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           84572    398  79535  4639  94     5.5
## 2 India          425282 174387 237196 13699  55.8   3.2
## 3 Burma             290     84    200     6  69     2.1
## 4 Afghanistan     28833  19488   8764   581  30.4   2  
## 5 Pakistan       181088 106040  71458  3590  39.5   2  
## 6 Bangladesh     112306  65765  45077  1464  40.1   1.3
## 7 Sri Lanka        1950    441   1498    11  76.8   0.6
## 8 Nepal            9026   7231   1772    23  19.6   0.3
## 9 Bhutan             68     38     30     0  44.1   0

Acknowledgment: JHU CCSE repository developers