Daily Covid-19 Statistics

Covid data for Thursday, 21 July 2022

Global Cases: 571,707,689
Increase: 1,919,516
Global Deaths: 6,396,131
Increase: 4,343

Australia
Cases 8,953,637 Change: 51,053
Deaths 10,943 Change: 83
Critical 162
Cases per Million 342,985

UK
Cases 23,212,565 Change: 137,205
Deaths 182,727 Change: 1,147
Critical 146
Cases per Million 338,300

USA
Cases 91,767,460 Change: 237,598
Deaths 1,050,702 Change: 1,019
Critical 4,444
Cases per Million

South Africa
Cases 4,001,444 Change: 550
Deaths 101,939 Change: 4
Critical 192
Cases per Million 65,772

France
Cases 33,258,481 Change: 89,982
Deaths 151,104 Change: 125
Critical 869
Cases per Million 507,230

Germany
Cases 30,131,303 Change: 136,624
Deaths 142,948 Change: 177
Critical 1,325
Cases per Million 357,295

Data from www.worldometers.info/coronavirus/

Covid data for Friday, 22 July 2022

Global Cases: 572,508,191
Increase: 800,502
Global Deaths: 6,398,234
Increase: 2,103

Australia
Cases 9,007,099 Change: 53,462
Deaths 11,018 Change: 75
Critical 154
Cases per Million 345,022

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,295

USA
Cases 91,942,744 Change: 175,284
Deaths 1,051,235 Change: 533
Critical 4,501
Cases per Million

South Africa
Cases 4,001,816 Change: 372
Deaths 101,942 Change: 3
Critical 192
Cases per Million 65,776

France
Cases 33,339,350 Change: 80,869
Deaths 151,237 Change: 133
Critical 869
Cases per Million 508,460

Germany
Cases 30,131,303 Change: 0
Deaths 142,948 Change: 0
Critical 1,325
Cases per Million 357,292

Data from www.worldometers.info/coronavirus/

1 Like

Joe Biden has covid again according the the evening news

Covid data for Saturday, 23 July 2022

Global Cases: 573,860,872
Increase: 1,352,681
Global Deaths: 6,401,119
Increase: 2,885

Australia
Cases 9,055,004 Change: 47,905
Deaths 11,126 Change: 108
Critical 164
Cases per Million 346,847

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,290

USA
Cases 92,145,839 Change: 203,095
Deaths 1,051,912 Change: 677
Critical 4,530
Cases per Million

South Africa
Cases 4,002,133 Change: 317
Deaths 101,943 Change: 1
Critical 192
Cases per Million 65,779

France
Cases 33,413,698 Change: 74,348
Deaths 151,350 Change: 113
Critical 869
Cases per Million 509,591

Germany
Cases 30,239,122 Change: 107,819
Deaths 143,061 Change: 113
Critical 1,395
Cases per Million 358,567

Data from www.worldometers.info/coronavirus/

Covid data for Sunday, 24 July 2022

Global Cases: 574,743,477
Increase: 882,605
Global Deaths: 6,402,428
Increase: 1,309

Australia
Cases 9,088,734 Change: 33,730
Deaths 11,162 Change: 36
Critical 153
Cases per Million 348,128

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,286

USA
Cases 92,172,336 Change: 26,497
Deaths 1,051,979 Change: 67
Critical 4,451
Cases per Million

South Africa
Cases 4,002,133 Change: 0
Deaths 101,943 Change: 0
Critical 192
Cases per Million 65,777

France
Cases 33,482,230 Change: 68,532
Deaths 151,350 Change: 0
Critical 869
Cases per Million 510,633

Germany
Cases 30,331,131 Change: 92,009
Deaths 143,177 Change: 116
Critical 1,395
Cases per Million 359,655

Data from www.worldometers.info/coronavirus/

As from the 1st July 2022 I will only be uploading the Covid figures weekly. I will try to do it every Friday arvo (AEST) but occasionally It may be Saturday or Sunday. The UK figures only seem to be updated weekly anyway.

It doesn’t require too much change to the VBA except for the Monthly Report because that will now have to happen on the first Friday after the 1st of the month so instead of merely searching for text files dated the 1st it will have to look for the first file of a particular month and also activate itself once it sees that the month has changed (currently it just checks for the last day of the month). There may be a few wrinkles with this process but hopefully I can fix it pretty quickly.

The “Increase” and “Change” numbers will obviously be for a week rather than a daily increase.

1 Like

Thank you @Bruce for keeping us updated with the daily Covid figures all this time, it has been very much appreciated. Continuing with weekly updates is a good idea. :+1:

1 Like

Thanks Bruce and, yes, the UK figures are only updated once/week now on a Friday.

1 Like

Covid data for Monday, 25 July 2022

Global Cases: 575,333,602
Increase: 590,125
Global Deaths: 6,403,242
Increase: 814

Australia
Cases 9,131,471 Change: 42,737
Deaths 11,181 Change: 19
Critical 154
Cases per Million 349,754

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,281

USA
Cases 92,194,892 Change: 22,556
Deaths 1,051,996 Change: 17
Critical 4,442
Cases per Million

South Africa
Cases 4,002,133 Change: 0
Deaths 101,943 Change: 0
Critical 192
Cases per Million 65,774

France
Cases 33,532,262 Change: 50,032
Deaths 151,350 Change: 0
Critical 869
Cases per Million 511,393

Germany
Cases 30,331,131 Change: 0
Deaths 143,177 Change: 0
Critical 1,395
Cases per Million 359,652

Data from www.worldometers.info/coronavirus/

Thanks for your comments, I checked to see if it was being viewed late last week and was surprised to find that average daily views have remained fairly constant at about 11/12 per day. I last checked just over a month ago over a longer period and it was about the same.

Covid data for Tuesday, 26 July 2022

Global Cases: 576,183,852
Increase: 850,250
Global Deaths: 6,405,083
Increase: 1,841

Australia
Cases 9,176,747 Change: 45,276
Deaths 11,293 Change: 112
Critical 176
Cases per Million 351,477

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,276

USA
Cases 92,339,925 Change: 145,033
Deaths 1,052,467 Change: 471
Critical 4,413
Cases per Million

South Africa
Cases 4,002,981 Change: 848
Deaths 101,955 Change: 12
Critical 192
Cases per Million 65,786

France
Cases 33,543,457 Change: 11,195
Deaths 151,560 Change: 210
Critical 869
Cases per Million 511,561

Germany
Cases 30,476,605 Change: 145,474
Deaths 143,364 Change: 187
Critical 1,440
Cases per Million 361,374

Data from www.worldometers.info/coronavirus/

Covid data for Wednesday, 27 July 2022

Global Cases: 577,325,731
Increase: 1,141,879
Global Deaths: 6,407,502
Increase: 2,419

Australia
Cases 9,225,519 Change: 48,772
Deaths 11,360 Change: 67
Critical 149
Cases per Million 353,334

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,271

USA
Cases 92,494,018 Change: 154,093
Deaths 1,052,935 Change: 468
Critical 4,575
Cases per Million

South Africa
Cases 4,003,502 Change: 521
Deaths 101,962 Change: 7
Critical 192
Cases per Million 65,793

France
Cases 33,631,019 Change: 87,562
Deaths 151,679 Change: 119
Critical 869
Cases per Million 512,893

Germany
Cases 30,598,385 Change: 121,780
Deaths 143,545 Change: 181
Critical 1,440
Cases per Million 362,814

Data from www.worldometers.info/coronavirus/

Covid data for Thursday, 28 July 2022

Global Cases: 578,351,573
Increase: 1,025,842
Global Deaths: 6,410,663
Increase: 3,161

Australia
Cases 9,271,946 Change: 46,427
Deaths 11,462 Change: 102
Critical 155
Cases per Million 355,101

UK
Cases 23,212,565 Change: 0
Deaths 182,727 Change: 0
Critical 146
Cases per Million 338,267

USA
Cases 92,761,865 Change: 267,847
Deaths 1,053,969 Change: 1,034
Critical 4,730
Cases per Million

South Africa
Cases 4,003,883 Change: 381
Deaths 101,967 Change: 5
Critical 192
Cases per Million 65,797

France
Cases 33,689,657 Change: 58,638
Deaths 151,782 Change: 103
Critical 869
Cases per Million 513,784

Germany
Cases 30,598,385 Change: 0
Deaths 143,545 Change: 0
Critical 1,440
Cases per Million 362,811

Data from www.worldometers.info/coronavirus/

Covid data for Friday, 29 July 2022

Global Cases: 579,775,880
Increase: 1,424,307
Global Deaths: 6,414,565
Increase: 3,902

Australia
Cases 9,317,792 Change: 45,846
Deaths 11,658 Change: 196
Critical 162
Cases per Million 356,846

UK
Cases 23,304,479 Change: 91,914
Deaths 183,953 Change: 1,226
Critical 146
Cases per Million 339,601

USA
Cases 92,917,658 Change: 155,793
Deaths 1,054,422 Change: 453
Critical 9,737
Cases per Million

South Africa
Cases 4,004,201 Change: 318
Deaths 101,977 Change: 10
Critical 192
Cases per Million 65,800

France
Cases 33,741,251 Change: 51,594
Deaths 151,894 Change: 112
Critical 869
Cases per Million 514,568

Germany
Cases 30,787,309 Change: 188,924
Deaths 143,855 Change: 310
Critical 1,587
Cases per Million 365,048

Data from www.worldometers.info/coronavirus/

Covid data for Saturday, 30 July 2022

Global Cases: 580,837,020
Increase: 1,061,140
Global Deaths: 6,417,643
Increase: 3,078

Australia
Cases 9,349,602 Change: 31,810
Deaths 11,776 Change: 118
Critical 168
Cases per Million 358,053

UK
Cases 23,304,479 Change: 0
Deaths 183,953 Change: 0
Critical 146
Cases per Million 339,596

USA
Cases 93,054,184 Change: 136,526
Deaths 1,055,020 Change: 598
Critical 4,723
Cases per Million

South Africa
Cases 4,004,555 Change: 354
Deaths 101,982 Change: 5
Critical 192
Cases per Million 65,803

France
Cases 33,786,766 Change: 45,515
Deaths 151,983 Change: 89
Critical 869
Cases per Million 515,259

Germany
Cases 30,787,309 Change: 0
Deaths 143,855 Change: 0
Critical 1,550
Cases per Million 365,045

Data from www.worldometers.info/coronavirus/

Covid data for Sunday, 31 July 2022

Global Cases: 581,800,129
Increase: 963,109
Global Deaths: 6,419,050
Increase: 1,407

Australia
Cases 9,402,604 Change: 53,002
Deaths 11,831 Change: 55
Critical 169
Cases per Million 360,072

UK
Cases 23,304,479 Change: 0
Deaths 183,953 Change: 0
Critical 146
Cases per Million 339,591

USA
Cases 93,069,863 Change: 15,679
Deaths 1,055,051 Change: 31
Critical 4,691
Cases per Million

South Africa
Cases 4,004,555 Change: 0
Deaths 101,982 Change: 0
Critical 192
Cases per Million 65,801

France
Cases 33,828,040 Change: 41,274
Deaths 151,983 Change: 0
Critical 869
Cases per Million 515,885

Germany
Cases 30,853,312 Change: 66,003
Deaths 143,972 Change: 117
Critical 1,550
Cases per Million 365,825

Data from www.worldometers.info/coronavirus/

How did we get here?

One Month Ago

Covid data for Friday, 1 July 2022

Global Cases: 552,746,623
Global Deaths: 6,358,063

Australia
Cases 8,155,638
Deaths 9,918
Critical 105
Cases per Million 312,610

UK
Cases 22,720,345
Deaths 180,330
Critical 146
Cases per Million 331,220

USA
Cases 89,360,080
Deaths 1,042,678
Critical 3,333
Cases per Million 266,853

South Africa
Cases 3,993,843 9
Deaths 101,793
Critical 192
Cases per Million 65,691

France
Cases 31,083,859
Deaths 149,533
Critical 869
Cases per Million 474,121

Germany
Cases 28,293,960
Deaths 141,189
Critical 934
Cases per Million 335,566


Three Months Ago

Covid data for Sunday, 1 May 2022

Global Cases: 513,340,212
Global Deaths: 6,260,720

Australia
Cases 5,952,153
Deaths 7,236
Critical 145
Cases per Million 228,581

UK
Cases 22,038,340
Deaths 174,912
Critical 302
Cases per Million 321,556

USA
Cases 83,066,907
Deaths 1,020,833
Critical 1,576
Cases per Million 248,299

South Africa
Cases 3,791,925
Deaths 100,363
Critical 192
Cases per Million 62,498

France
Cases 28,645,285
Deaths 145,930
Critical 1,677
Cases per Million 437,086

Germany
Cases 24,761,600
Deaths 135,900
Critical 1,446
Cases per Million 293,827


Six Months Ago

Covid data for Tuesday, 1 February 2022

Global Cases: 377,973,780
Global Deaths: 5,691,732

Australia
Cases 2,579,240
Deaths 3,835
Critical 376
Cases per Million 99,325

UK
Cases 16,468,522
Deaths 155,698
Critical 549
Cases per Million 240,592

USA
Cases 76,222,215
Deaths 910,104
Critical 23,104
Cases per Million 228,161

South Africa
Cases 3,605,222
Deaths 95,093
Critical 546
Cases per Million 59,599

France
Cases 19,140,730
Deaths 130,931
Critical 3,641
Cases per Million 292,216

Germany
Cases 9,896,344
Deaths 118,527
Critical 2,274
Cases per Million 117,523


One Year Ago

Covid data for Sunday, 1 August 2021

Global Cases: 198,547,026
Global Deaths: 4,232,892

Australia
Cases 34,381
Deaths 924
Critical 59
Cases per Million 1,332

UK
Cases 5,856,528
Deaths 129,654
Critical 869
Cases per Million 85,783

USA
Cases 35,745,024
Deaths 629,315
Critical 11,516
Cases per Million 107,311

Canada
Cases 1,430,825
Deaths 26,598
Critical 231
Cases per Million 37,555

Sweden
Cases 1,100,040
Deaths 14,617
Critical 16
Cases per Million 108,194

France
Cases 6,127,019
Deaths 111,867
Critical 1,099
Cases per Million 93,643


Data from Worldometers.info web site

NB: In future Covid data will be uploaded weekly on a Thursday or Friday(ish).

Covid data for the week, uploaded Thursday, 4 August 2022

NB: Increase & Change numbers refer to increases since 31 Jul 2022

Global Cases: 585,530,708
Increase: 3,730,579
Global Deaths: 6,428,138
Increase: 9,088

Australia
Cases 9,546,591 Change: 143,987
Deaths 12,103 Change: 272
Critical 153
Cases per Million 365,541

UK
Cases 23,368,899 Change: 64,420
Deaths 185,052 Change: 1,099
Critical 146
Cases per Million 340,511

USA
Cases 93,593,214 Change: 523,351
Deaths 1,057,239 Change: 2,188
Critical 4,627
Cases per Million

South Africa
Cases 4,004,555 Change: 0
Deaths 101,982 Change: 0
Critical 192
Cases per Million 65,792

France
Cases 33,960,131 Change: 132,091
Deaths 152,370 Change: 387
Critical 869
Cases per Million 517,887

Germany
Cases 31,119,199 Change: 265,887
Deaths 144,552 Change: 580
Critical 1,445
Cases per Million 368,964

Data from www.worldometers.info/coronavirus/

This is the new weekly format, same as before but note that the “Increase” and “Change” now refer to the period since the last upload, which may not always be exactly a week though I will try to keep it consistent.

Covid data for the week, uploaded Thursday, 11 August 2022

NB: Increase/Change numbers refer to increases since Thursday, 4 August 2022

Global Cases: 592,487,828
Increase: 6,957,120
Global Deaths: 6,446,278
Increase: 18,140

Australia
Cases 9,726,472 Change: 179,881
Deaths 12,598 Change: 495
Critical 136
Cases per Million 372,348

UK
Cases 23,420,826 Change: 51,927
Deaths 186,087 Change: 1,035
Critical 146
Cases per Million 341,234

USA
Cases 94,348,507 Change: 755,293
Deaths 1,060,755 Change: 3,516
Critical 4,570
Cases per Million

South Africa
Cases 4,007,080 Change: 2,525
Deaths 101,982 Change: 0
Critical 192
Cases per Million 65,818

France
Cases 34,144,969 Change: 184,838
Deaths 152,910 Change: 540
Critical 869
Cases per Million 520,684

Germany
Cases 31,439,645 Change: 320,446
Deaths 145,394 Change: 842
Critical 1,406
Cases per Million 372,741

Data from www.worldometers.info/coronavirus/

yea thanks bruce! - it’s when people make an effort that we start progressing

1 Like