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             2255119 1443988 617460 119719  27.4   5.3
##  2 Brazil         1032913  393863 589074  49976  57     4.8
##  3 Russia          576162  234146 334024   7992  58     1.4
##  4 India           410461  169451 227756  13254  55.5   3.2
##  5 United Kingdom  304580  260587   1319  42674   0.4  14  
##  6 Peru            251338  100460 143017   7861  56.9   3.1
##  7 Spain           245938   67240 150376  28322  61.1  11.5
##  8 Italy           238275   21212 182453  34610  76.6  14.5
##  9 Chile           236748   35844 196609   4295  83     1.8
## 10 Iran            202584   31693 161384   9507  79.7   4.7
## 11 France          196724   92652  74436  29636  37.8  15.1
## 12 Germany         190670    7166 174609   8895  91.6   4.7
## 13 Turkey          186493   22738 158828   4927  85.2   2.6
## 14 Pakistan        176617  105224  67892   3501  38.4   2  
## 15 Mexico          175202   23567 130854  20781  74.7  11.9
## 16 Saudi Arabia    154233   54086  98917   1230  64.1   0.8
## 17 Bangladesh      108775   63357  43993   1425  40.4   1.3
## 18 Canada          102762   29470  64826   8466  63.1   8.2
## 19 South Africa     92681   40478  50326   1877  54.3   2  
## 20 Qatar            86488   19631  66763     94  77.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             2255119 1443988 617460 119719  27.4   5.3
##  2 Brazil         1032913  393863 589074  49976  57     4.8
##  3 United Kingdom  304580  260587   1319  42674   0.4  14  
##  4 Russia          576162  234146 334024   7992  58     1.4
##  5 India           410461  169451 227756  13254  55.5   3.2
##  6 Pakistan        176617  105224  67892   3501  38.4   2  
##  7 Peru            251338  100460 143017   7861  56.9   3.1
##  8 France          196724   92652  74436  29636  37.8  15.1
##  9 Spain           245938   67240 150376  28322  61.1  11.5
## 10 Bangladesh      108775   63357  43993   1425  40.4   1.3
## 11 Saudi Arabia    154233   54086  98917   1230  64.1   0.8
## 12 Sweden           56043   50990      0   5053   0     9  
## 13 Netherlands      49710   43416    186   6108   0.4  12.3
## 14 South Africa     92681   40478  50326   1877  54.3   2  
## 15 Egypt            53758   37325  14327   2106  26.7   3.9
## 16 Colombia         63454   37271  24035   2148  37.9   3.4
## 17 Chile           236748   35844 196609   4295  83     1.8
## 18 Belgium          60550   34083  16771   9696  27.7  16  
## 19 Iran            202584   31693 161384   9507  79.7   4.7
## 20 Canada          102762   29470  64826   8466  63.1   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             2255119 1443988 617460 119719  27.4   5.3
##  2 Brazil         1032913  393863 589074  49976  57     4.8
##  3 Russia          576162  234146 334024   7992  58     1.4
##  4 India           410461  169451 227756  13254  55.5   3.2
##  5 Chile           236748   35844 196609   4295  83     1.8
##  6 Italy           238275   21212 182453  34610  76.6  14.5
##  7 Germany         190670    7166 174609   8895  91.6   4.7
##  8 Iran            202584   31693 161384   9507  79.7   4.7
##  9 Turkey          186493   22738 158828   4927  85.2   2.6
## 10 Spain           245938   67240 150376  28322  61.1  11.5
## 11 Peru            251338  100460 143017   7861  56.9   3.1
## 12 Mexico          175202   23567 130854  20781  74.7  11.9
## 13 Saudi Arabia    154233   54086  98917   1230  64.1   0.8
## 14 China            84553     380  79534   4639  94.1   5.5
## 15 France          196724   92652  74436  29636  37.8  15.1
## 16 Pakistan        176617  105224  67892   3501  38.4   2  
## 17 Qatar            86488   19631  66763     94  77.2   0.1
## 18 Canada          102762   29470  64826   8466  63.1   8.2
## 19 South Africa     92681   40478  50326   1877  54.3   2  
## 20 Bangladesh      108775   63357  43993   1425  40.4   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             2255119 1443988 617460 119719  27.4   5.3
##  2 Brazil         1032913  393863 589074  49976  57     4.8
##  3 United Kingdom  304580  260587   1319  42674   0.4  14  
##  4 Italy           238275   21212 182453  34610  76.6  14.5
##  5 France          196724   92652  74436  29636  37.8  15.1
##  6 Spain           245938   67240 150376  28322  61.1  11.5
##  7 Mexico          175202   23567 130854  20781  74.7  11.9
##  8 India           410461  169451 227756  13254  55.5   3.2
##  9 Belgium          60550   34083  16771   9696  27.7  16  
## 10 Iran            202584   31693 161384   9507  79.7   4.7
## 11 Germany         190670    7166 174609   8895  91.6   4.7
## 12 Canada          102762   29470  64826   8466  63.1   8.2
## 13 Russia          576162  234146 334024   7992  58     1.4
## 14 Peru            251338  100460 143017   7861  56.9   3.1
## 15 Netherlands      49710   43416    186   6108   0.4  12.3
## 16 Sweden           56043   50990      0   5053   0     9  
## 17 Turkey          186493   22738 158828   4927  85.2   2.6
## 18 China            84553     380  79534   4639  94.1   5.5
## 19 Chile           236748   35844 196609   4295  83     1.8
## 20 Ecuador          49731   21129  24446   4156  49.2   8.4

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          1822     7   1805    10  99.1   0.5
##  2 New Zealand      1511     7   1482    22  98.1   1.5
##  3 Luxembourg       4105    44   3951   110  96.2   2.7
##  4 Thailand         3147    71   3018    58  95.9   1.8
##  5 Malaysia         8556   289   8146   121  95.2   1.4
##  6 China           84553   380  79534  4639  94.1   5.5
##  7 Austria         17323   460  16175   688  93.4   4  
##  8 Croatia          2299    50   2142   107  93.2   4.7
##  9 Norway           8742   360   8138   244  93.1   2.8
## 10 Serbia          12803   654  11889   260  92.9   2  
## 11 Switzerland     31243   387  28900  1956  92.5   6.3
## 12 Australia        7461   463   6896   102  92.4   1.4
## 13 Germany        190670  7166 174609  8895  91.6   4.7
## 14 Denmark         12591   509  11482   600  91.2   4.8
## 15 Slovakia         1586   111   1447    28  91.2   1.8
## 16 Japan           17725   822  15948   955  90     5.4
## 17 Cuba             2309   153   2071    85  89.7   3.7
## 18 Ireland         25374   961  22698  1715  89.5   6.8
## 19 Slovenia         1519    51   1359   109  89.5   7.2
## 20 Estonia          1981   154   1758    69  88.7   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 Belgium                    60550   34083  16771   9696  27.7  16  
##  2 US                       2255119 1443988 617460 119719  27.4   5.3
##  3 Somalia                     2755    1916    751     88  27.3   3.2
##  4 Egypt                      53758   37325  14327   2106  26.7   3.9
##  5 Philippines                29400   20600   7650   1150  26     3.9
##  6 Ethiopia                    4469    3275   1122     72  25.1   1.6
##  7 Mauritania                  2813    2009    696    108  24.7   3.8
##  8 Venezuela                   3789    2921    835     33  22     0.9
##  9 Bolivia                    23512   17686   5086    740  21.6   3.1
## 10 Guatemala                  12755    9683   2558    514  20.1   4  
## 11 Nepal                       8605    7005   1578     22  18.3   0.3
## 12 Central African Republic    2686    2247    420     19  15.6   0.7
## 13 Congo (Kinshasa)            5672    4740    807    125  14.2   2.2
## 14 Honduras                   12306   10673   1275    358  10.4   2.9
## 15 Guinea-Bissau               1541    1371    153     17   9.9   1.1
## 16 South Sudan                 1882    1726    122     34   6.5   1.8
## 17 Haiti                       5077    4965     24     88   0.5   1.7
## 18 Netherlands                49710   43416    186   6108   0.4  12.3
## 19 United Kingdom            304580  260587   1319  42674   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         196724  92652  74436 29636  37.8  15.1
##  3 Italy          238275  21212 182453 34610  76.6  14.5
##  4 Hungary          4086    931   2585   570  63.3  14  
##  5 United Kingdom 304580 260587   1319 42674   0.4  14  
##  6 Netherlands     49710  43416    186  6108   0.4  12.3
##  7 Mexico         175202  23567 130854 20781  74.7  11.9
##  8 Spain          245938  67240 150376 28322  61.1  11.5
##  9 Sweden          56043  50990      0  5053   0     9  
## 10 Ecuador         49731  21129  24446  4156  49.2   8.4
## 11 Canada         102762  29470  64826  8466  63.1   8.2
## 12 Algeria         11631   2470   8324   837  71.6   7.2
## 13 Slovenia         1519     51   1359   109  89.5   7.2
## 14 Ireland         25374    961  22698  1715  89.5   6.8
## 15 Niger            1035     57    911    67  88     6.5
## 16 Romania         23730   5495  16735  1500  70.5   6.3
## 17 Switzerland     31243    387  28900  1956  92.5   6.3
## 18 Sudan            8580   4734   3325   521  38.8   6.1
## 19 Greece           3256   1692   1374   190  42.2   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                    39145  8100 30726   319  78.5   0.8
##  2 Saudi Arabia             154233 54086 98917  1230  64.1   0.8
##  3 Zambia                     1430   225  1194    11  83.5   0.8
##  4 Central African Republic   2686  2247   420    19  15.6   0.7
##  5 Cote d'Ivoire              7276  4232  2992    52  41.1   0.7
##  6 Kazakhstan                17225  6436 10671   118  62     0.7
##  7 United Arab Emirates      44533 12478 31754   301  71.3   0.7
##  8 Belarus                   57936 20844 36749   343  63.4   0.6
##  9 Costa Rica                 2127  1101  1014    12  47.7   0.6
## 10 Ghana                     13717  3558 10074    85  73.4   0.6
## 11 Sri Lanka                  1950   467  1472    11  75.5   0.6
## 12 Guinea                     4960  1303  3630    27  73.2   0.5
## 13 Iceland                    1822     7  1805    10  99.1   0.5
## 14 Maldives                   2187   391  1788     8  81.8   0.4
## 15 Oman                      28566 13658 14780   128  51.7   0.4
## 16 Bahrain                   21331  5481 15790    60  74     0.3
## 17 Nepal                      8605  7005  1578    22  18.3   0.3
## 18 Uzbekistan                 6153  1844  4290    19  69.7   0.3
## 19 Qatar                     86488 19631 66763    94  77.2   0.1
## 20 Singapore                 41833  7583 34224    26  81.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           84553    380  79534  4639  94.1   5.5
## 2 India          410461 169451 227756 13254  55.5   3.2
## 3 Burma             287     85    196     6  68.3   2.1
## 4 Afghanistan     28424  19563   8292   569  29.2   2  
## 5 Pakistan       176617 105224  67892  3501  38.4   2  
## 6 Bangladesh     108775  63357  43993  1425  40.4   1.3
## 7 Sri Lanka        1950    467   1472    11  75.5   0.6
## 8 Nepal            8605   7005   1578    22  18.3   0.3
## 9 Bhutan             68     38     30     0  44.1   0

Acknowledgment: JHU CCSE repository developers