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             2347022 1510931 647548 121228  27.6   5.2
##  2 Brazil         1145906  465298 627963  52645  54.8   4.6
##  3 Russia          598878  234682 355847   8349  59.4   1.4
##  4 India           456183  183022 258685  14476  56.7   3.2
##  5 United Kingdom  307682  263341   1330  43011   0.4  14  
##  6 Peru            260810  103969 148437   8404  56.9   3.2
##  7 Chile           250767   35692 210570   4505  84     1.8
##  8 Spain           246752   68051 150376  28325  60.9  11.5
##  9 Italy           238833   19573 184585  34675  77.3  14.5
## 10 Iran            209970   30947 169160   9863  80.6   4.7
## 11 France          197804   93086  74995  29723  37.9  15  
## 12 Germany         192480    7741 175825   8914  91.3   4.6
## 13 Mexico          191410   24387 143646  23377  75    12.2
## 14 Turkey          190165   22316 162848   5001  85.6   2.6
## 15 Pakistan        188926  107417  77754   3755  41.2   2  
## 16 Saudi Arabia    164144   52913 109885   1346  66.9   0.8
## 17 Bangladesh      119198   70018  47635   1545  40     1.3
## 18 South Africa    106108   48961  55045   2102  51.9   2  
## 19 Canada          103767   29120  66135   8512  63.7   8.2
## 20 Qatar            89579   17979  71501     99  79.8   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             2347022 1510931 647548 121228  27.6   5.2
##  2 Brazil         1145906  465298 627963  52645  54.8   4.6
##  3 United Kingdom  307682  263341   1330  43011   0.4  14  
##  4 Russia          598878  234682 355847   8349  59.4   1.4
##  5 India           456183  183022 258685  14476  56.7   3.2
##  6 Pakistan        188926  107417  77754   3755  41.2   2  
##  7 Peru            260810  103969 148437   8404  56.9   3.2
##  8 France          197804   93086  74995  29723  37.9  15  
##  9 Bangladesh      119198   70018  47635   1545  40     1.3
## 10 Spain           246752   68051 150376  28325  60.9  11.5
## 11 Sweden           60837   55676      0   5161   0     8.5
## 12 Saudi Arabia    164144   52913 109885   1346  66.9   0.8
## 13 South Africa    106108   48961  55045   2102  51.9   2  
## 14 Netherlands      49930   43630    186   6114   0.4  12.2
## 15 Colombia         73760   40719  30517   2524  41.4   3.4
## 16 Egypt            58141   40241  15535   2365  26.7   4.1
## 17 Chile           250767   35692 210570   4505  84     1.8
## 18 Belgium          60810   34326  16771   9713  27.6  16  
## 19 Argentina        47203   32549  13576   1078  28.8   2.3
## 20 Iran            209970   30947 169160   9863  80.6   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 US             2347022 1510931 647548 121228  27.6   5.2
##  2 Brazil         1145906  465298 627963  52645  54.8   4.6
##  3 Russia          598878  234682 355847   8349  59.4   1.4
##  4 India           456183  183022 258685  14476  56.7   3.2
##  5 Chile           250767   35692 210570   4505  84     1.8
##  6 Italy           238833   19573 184585  34675  77.3  14.5
##  7 Germany         192480    7741 175825   8914  91.3   4.6
##  8 Iran            209970   30947 169160   9863  80.6   4.7
##  9 Turkey          190165   22316 162848   5001  85.6   2.6
## 10 Spain           246752   68051 150376  28325  60.9  11.5
## 11 Peru            260810  103969 148437   8404  56.9   3.2
## 12 Mexico          191410   24387 143646  23377  75    12.2
## 13 Saudi Arabia    164144   52913 109885   1346  66.9   0.8
## 14 China            84653     458  79555   4640  94     5.5
## 15 Pakistan        188926  107417  77754   3755  41.2   2  
## 16 France          197804   93086  74995  29723  37.9  15  
## 17 Qatar            89579   17979  71501     99  79.8   0.1
## 18 Canada          103767   29120  66135   8512  63.7   8.2
## 19 South Africa    106108   48961  55045   2102  51.9   2  
## 20 Bangladesh      119198   70018  47635   1545  40     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             2347022 1510931 647548 121228  27.6   5.2
##  2 Brazil         1145906  465298 627963  52645  54.8   4.6
##  3 United Kingdom  307682  263341   1330  43011   0.4  14  
##  4 Italy           238833   19573 184585  34675  77.3  14.5
##  5 France          197804   93086  74995  29723  37.9  15  
##  6 Spain           246752   68051 150376  28325  60.9  11.5
##  7 Mexico          191410   24387 143646  23377  75    12.2
##  8 India           456183  183022 258685  14476  56.7   3.2
##  9 Iran            209970   30947 169160   9863  80.6   4.7
## 10 Belgium          60810   34326  16771   9713  27.6  16  
## 11 Germany         192480    7741 175825   8914  91.3   4.6
## 12 Canada          103767   29120  66135   8512  63.7   8.2
## 13 Peru            260810  103969 148437   8404  56.9   3.2
## 14 Russia          598878  234682 355847   8349  59.4   1.4
## 15 Netherlands      49930   43630    186   6114   0.4  12.2
## 16 Sweden           60837   55676      0   5161   0     8.5
## 17 Turkey          190165   22316 162848   5001  85.6   2.6
## 18 China            84653     458  79555   4640  94     5.5
## 19 Chile           250767   35692 210570   4505  84     1.8
## 20 Ecuador          51643   22378  24991   4274  48.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          1824     8   1806    10  99     0.5
##  2 New Zealand      1516    11   1483    22  97.8   1.5
##  3 Luxembourg       4133    64   3959   110  95.8   2.7
##  4 Thailand         3156    75   3023    58  95.8   1.8
##  5 Malaysia         8590   283   8186   121  95.3   1.4
##  6 China           84653   458  79555  4640  94     5.5
##  7 Austria         17408   454  16261   693  93.4   4  
##  8 Norway           8772   386   8138   248  92.8   2.8
##  9 Switzerland     31332   376  29000  1956  92.6   6.2
## 10 Australia        7521   494   6924   103  92.1   1.4
## 11 Serbia          13092   775  12054   263  92.1   2  
## 12 Cuba             2318   110   2123    85  91.6   3.7
## 13 Germany        192480  7741 175825  8914  91.3   4.6
## 14 Slovakia         1589   113   1448    28  91.1   1.8
## 15 Denmark         12761   565  11593   603  90.8   4.7
## 16 Croatia          2366   117   2142   107  90.5   4.5
## 17 Japan           17879   818  16096   965  90     5.4
## 18 Slovenia         1534    49   1376   109  89.7   7.1
## 19 Estonia          1982   142   1771    69  89.4   3.5
## 20 Finland          7155   428   6400   327  89.4   4.6

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 Mauritania                  3292    2215    963    114  29.3   3.5
##  2 Ethiopia                    4848    3361   1412     75  29.1   1.5
##  3 Somalia                     2812    1904    818     90  29.1   3.2
##  4 Argentina                  47203   32549  13576   1078  28.8   2.3
##  5 Belgium                    60810   34326  16771   9713  27.6  16  
##  6 US                       2347022 1510931 647548 121228  27.6   5.2
##  7 Egypt                      58141   40241  15535   2365  26.7   4.1
##  8 Philippines                31825   22197   8442   1186  26.5   3.7
##  9 Bolivia                    26389   19243   6300    846  23.9   3.2
## 10 Nepal                      10099    7851   2224     24  22     0.2
## 11 Guatemala                  14540   11061   2897    582  19.9   4  
## 12 Central African Republic    3051    2492    522     37  17.1   1.2
## 13 Congo (Kinshasa)            6027    5031    861    135  14.3   2.2
## 14 Guinea-Bissau               1556    1346    191     19  12.3   1.2
## 15 South Sudan                 1930    1677    217     36  11.2   1.9
## 16 Honduras                   13943   12077   1461    405  10.5   2.9
## 17 Haiti                       5324    4799    436     89   8.2   1.7
## 18 Netherlands                49930   43630    186   6114   0.4  12.2
## 19 United Kingdom            307682  263341   1330  43011   0.4  14  
## 20 Sweden                     60837   55676      0   5161   0     8.5

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         60810  34326  16771  9713  27.6  16  
##  2 France         197804  93086  74995 29723  37.9  15  
##  3 Italy          238833  19573 184585 34675  77.3  14.5
##  4 Hungary          4107    934   2600   573  63.3  14  
##  5 United Kingdom 307682 263341   1330 43011   0.4  14  
##  6 Mexico         191410  24387 143646 23377  75    12.2
##  7 Netherlands     49930  43630    186  6114   0.4  12.2
##  8 Spain          246752  68051 150376 28325  60.9  11.5
##  9 Sweden          60837  55676      0  5161   0     8.5
## 10 Ecuador         51643  22378  24991  4274  48.4   8.3
## 11 Canada         103767  29120  66135  8512  63.7   8.2
## 12 Algeria         12076   2541   8674   861  71.8   7.1
## 13 Slovenia         1534     49   1376   109  89.7   7.1
## 14 Ireland         25391    973  22698  1720  89.4   6.8
## 15 Niger            1051     71    913    67  86.9   6.4
## 16 Romania         24505   5779  17187  1539  70.1   6.3
## 17 Sudan            8889   4642   3699   548  41.6   6.2
## 18 Switzerland     31332    376  29000  1956  92.6   6.2
## 19 Greece           3302   1738   1374   190  41.6   5.8
## 20 Mali             1978    565   1302   111  65.8   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                41033  8395  32304   334  78.7   0.8
##  2 Saudi Arabia         164144 52913 109885  1346  66.9   0.8
##  3 Venezuela              4187  2825   1327    35  31.7   0.8
##  4 Cote d'Ivoire          7904  4664   3182    58  40.3   0.7
##  5 Ghana                 14568  3566  10907    95  74.9   0.7
##  6 Kazakhstan            18765  7117  11514   134  61.4   0.7
##  7 United Arab Emirates  45683 11675  33703   305  73.8   0.7
##  8 Belarus               59487 20442  38688   357  65     0.6
##  9 Guinea                 5040  1327   3685    28  73.1   0.6
## 10 Sri Lanka              1991   432   1548    11  77.7   0.6
## 11 Costa Rica             2368  1227   1129    12  47.7   0.5
## 12 Iceland                1824     8   1806    10  99     0.5
## 13 Maldives               2238   417   1813     8  81     0.4
## 14 Oman                  32394 14975  17279   140  53.3   0.4
## 15 Bahrain               23062  5545  17450    67  75.7   0.3
## 16 Uzbekistan             6662  2083   4560    19  68.4   0.3
## 17 West Bank and Gaza     1169   724    442     3  37.8   0.3
## 18 Nepal                 10099  7851   2224    24  22     0.2
## 19 Qatar                 89579 17979  71501    99  79.8   0.1
## 20 Singapore             42432  6411  35995    26  84.8   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           84653    458  79555  4640  94     5.5
## 2 India          456183 183022 258685 14476  56.7   3.2
## 3 Afghanistan     29481  19603   9260   618  31.4   2.1
## 4 Burma             292     82    204     6  69.9   2.1
## 5 Pakistan       188926 107417  77754  3755  41.2   2  
## 6 Bangladesh     119198  70018  47635  1545  40     1.3
## 7 Sri Lanka        1991    432   1548    11  77.7   0.6
## 8 Nepal           10099   7851   2224    24  22     0.2
## 9 Bhutan             70     36     34     0  48.6   0

Acknowledgment: JHU CCSE repository developers