Tracking the COVID-19-Virus in Germany, the USA, Italy and other hot spots in the world

Discussion in 'Coronavirus (COVID-19) News' started by Statistikhengst, Mar 14, 2020.

PF does not allow misinformation. However, please note that posts could occasionally contain content in violation of our policies prior to our staff intervening. We urge you to seek reliable alternate sources to verify information you read in this forum.

Tags:
  1. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    EYE-POPPING FIGURES OUT OF THE USA FOR 2021-12-027 & THE ADDITION OF AN EXTRA CALCULATION ROW FOR EOY 2021

    Yesterday, 2021-12-027, according to my excel table, the USA added almost +570,000 fresh infections in just one day. According to WorldOMeter, it was "just" +229,000, which means that another 340,000 cases were shunted into the past. We also saw this happen in 2020, but not on this scale.

    To illustrate this point, from the 2020 USA EOY Analysis from one year ago, here the excel table for all of December, 2020:

    [​IMG]

    The above is exactly the same graphic you will find at the EOY analysis from almost one year ago. You can see that after the Sunday value for 2020-12-027, the numbers did jump (to +207,871, 195,985, +239,287 and +228,663 for 2020-12-028, 029, 030 and 031, respectively.

    Compare that to the Monday value following the last Sunday in this year:

    2021-12-027 COVID-19 USA 000.png

    You can see a huge difference between the Monday after the last Sunday in this year vis-a-vis the same in 2020. The can now be no doubt that my homeland, the USA, is now deeper into a harder wave right now than it was one year ago.

    Again, the WorldOMeter table says something else:

    2021-12-027 COVID-19 Worldwide 001 - total cases.png

    But as you know, I record the end of day numbers the next day, they are as up to date as can be, which simply means that the various US states and territories all recorded total numbers that bring us to roughly +570,000, but a good 340,000 of them were shunted back in history to Sunday, Saturday or in this case, since Friday was Christmas Eve, even Friday as well.

    Take a look at the USA excel table again:

    2021-12-027 COVID-19 USA 000.png

    See something new? At the very top, the last day of this year, 2021-12-031, is listed in two rows instead of just one. Row 4 will list the regular daily +cases, deaths and tests, with U4 and V4 taking care of the +monthly values, as you have been accustomed to seeing the data. But Row 3 will take the same totals and compare to 2020-12-031, 365 days before. This is why the entire row is shaded in an aqua color and the date is in italics.

    You can see that in E3 at the moment, the +cases is listed as -20,445,564 and that I3 lists -354,215. This is because the USA ended last year with 20,445,564 total cases and 354,215 total deaths and we are now simply waiting on the data for 2021-12-031 to come in and then excel will do the calculations for me, of course.

    -Stat
     
    Last edited: Dec 28, 2021
    Sallyally likes this.
  2. freedom8

    freedom8 Well-Known Member

    Joined:
    Jul 17, 2018
    Messages:
    1,854
    Likes Received:
    1,117
    Trophy Points:
    113
    Kudos for your tireless work and dedication to this matter!!!

    I just noticed a small detail, just to show you I'm paying attention:smile:: in the last sentence, I suppose you meant "354,215 new deaths".
     
  3. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male

    No, I meant total deaths. Those were the end figures for the USA for 2020-12-031 and will be represented in the correct columns for "plus deaths" for 2021-12-031 as a negative number until the actual total figures for 2021-12-031 come in and then the table, because it is mathematically pre-programmed from me, will do the math automatically. Since as of yesterday, the USA stood at 846,121 total deaths, then 846,121 minus 354,215 = 491,906, which means that we will definitely end the year with no less than +491,906 and if the current 7-day rolling average of +1,596 holds, then 1.596 * 3 = 4,788 +491,906 = 496,694, which means that we will end the year 2021 with about +500,000 deaths over the year 2020.

    This is what I call tablecloth math, doing the quick math on a napkin. After the New Year I will come back to this posting and we will see how close to reality it was, because it could be just as possible that deaths in the USA will either drastically increase or decrease (I find this highly unlikely, however).

    Thanks for your input, glad that you are here.

    -Stat
     
    Last edited: Dec 29, 2021
    freedom8 and Sallyally like this.
  4. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    Dear PFers,

    Tuesday, December 28th 2021 was a record-setting, record-shattering day in a number of horrifying ways.

    First, our world advanced +1.3 million cases in just one day, breaking other both the 282,000,000 and the 283,000,000 mark in just one day and we are now far enough away from Christmas Day(s) to say that those numbers are an accurate reflection of that day. Yes, our world jumped +1.5 million cases way back on 2020-12-010, but that was the day when Turkey suddenly added +800,000 cases to its total and shunted most of them back to previous dates, so there is a real difference between 2021-12-028 and 2020-12-010.

    Second, for the very first time in our World's Covid-19 history, 3 nations reported over +100,000 fresh infections on the same day - and it was almost 4, with Spain reporting in at +99,671. The USA reported more than +300,000 cases in one day, also a verifiable record for that nation:

    2021-12-028 COVID-19 Worldwide 005 - plus cases.png 2021-12-028 COVID-19 Worldwide 006 - plus cases.png

    You may note that France far surpassed the UK in +cases on this day, pushing toward +200,000.

    On the list of nations around or over +1,000 fresh infections on that day, you may notice a large number of African nations that we rarely talk about: Uganda, Burundi, Rwanda, Morocco (which had come to a practical stillstand and for the first time since 2021-09-030, almost 3 months ago, and thensuddenly clocked-in yesterday with +1,184 fresh infections), Ghana, Kenya, Zimbabwe, Mozambique and Ethiopia. Of course, South Africa is also in the mix, but it is most definitely on the Omikron-downslope.

    You will notice that Australia reported in with +11,267 cases and today already, it stands at +18,149, a huge jump from one day to the next. Also, Australia's 7-day rolling average has jumped more than 9-fold (!!!) from 2021-12-008 to 2021-12-029, putting it on exactly the same trajectory as both Thailand and Vietnam from earlier this year, where both sailed over the million mark about 2.5 months after I started tracking them.

    Also, Canada is most obviously now deep in the Omikron-wave, having clocked in with +27,023 cases. Seems like nothing compared to the USA's +322,000, but when you look at the development just far this month in Canada:

    2021-12-028 COVID-19 CANADA 000 - as an example.png

    You can clearly see that just as was the case for Australia, Canada has also experienced a 9-fold increase in the 7-day rolling average, only, over a slightly longer time frame.

    Also, all over the place I am seeing nations go either over 10,000 or over 100,000 active cases in their statistics, a number they have either never before had or not for a long time. If you peruse through the excel tabs, you will see what I mean.

    Also, where the Delta variant was dying out in a number of Eastern European nations, I am seeing the turnaround point in their statistics, where they are starting to rise again, telling me that this is likely the Omikron wave now hitting them.

    The odd-man-out in all of this is Germany, but only for now, because the RKI (Robert Koch Institute), the German version of the USA's CDC, is incredibly picky about this numbers and has a double-triple-quadruple-quintuple methods of checking data before releasing it and the numbers you see from Germany are guaranteed to be between 9-11 days old. So, the Omikron wave is guaranteed to hit here in good old Germany as well, it will just appear on paper later.

    What is not rising yet are the number of deaths, but I will again remind that deaths from Covid-19, as with every pandemic, are a lagging indicator.

    And finally, I would like to note that these extreme numbers on Tuesday are but a harbinger of things to come this week, all the way through Friday, because Tuesdays have never even once been the heaviest day in weekly C-19 statistics, that honor has gone mostly to Wednesdays or Thursdays, sometimes even on Fridays.

    -Stat
     
    Last edited: Dec 29, 2021
    Sallyally likes this.
  5. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    So, today, 2021-12-029 (Wednesday), the UK clocked in at +221,250 fresh infections, according to my excel table. WorldOMeter says that the UK clocked-in at +183,037, which means that since I recorded the numbers for yesterday this morning during my morning math work, the UK shunted +38,213 newly recorded infections from today's grand total over to past days, probably the day before. Either way, the UK has once again set a horrific record and its 7-day rolling average stands at +130,350 per day. The UK is likely to end the year at around 13,000,000 total confirmed C-19 cases.

    France clocked in at +208,099 fresh infections , thereby also setting an internal record. France's 7-day rolling avg currently = +105,190 per day and this is the first time in France's C-19 history that its average has gone into the 6-digit zone.

    The USA is already over +100,000 fresh infections, with only 10 out of 50 states having reported in, and 5 of those 10 well over +10,000 cases:

    2021-12-029 COVID-19 USA worldometer table as example.png

    Just let that sink in for a second....

    I see the USA easily topping +350,000, maybe even +400,000 fresh infections today, when all is said and done.

    Italy has already posted its numbers for today: +98,030 fresh infections, also a new record for that country and just a hair's breadth away from +100,000. Italy's 7-day rolling avg currently = +54,566 per day. It's entirely likely that Italy will sail over +100,000 either on Thursday or Friday, or both. If Spain, which has not yet reported in yet and is tending to produce numbers after midnight my time as of late, does this as well, then we are looking at at least 5 nations recording more than +100,000 daily infections: the USA, the UK, France, Spain and Italy. I suspect that today's worldwide +cases will involve 4 of those nations over +100,000 apiece an on the whole will be between +1.5 to +1.6 million fresh infections.

    Horrifying. And yet, here we are.

    I mentioned this morning that my eyes are very clearly seeing a number of nations where there is a precipitous rise in active cases and now I am also seeing a rise in ICU cases as well. This forbodes a lot of deaths to come, not necessarily because Omikron is more deadly than Delta by the severity of the disease in this variant form itself, but simply by the math that clearly indicated that many, many more will be infected by Omikron than ever were infected by Delta.

    Both @CenterField and I have been making this point vis-a-vis Omikron. Example, using made-up math, just for the purpose of visualization:

    Death rate, Delta: 3% of 100 = 3 deaths
    Death rate, Omikron: 0.5% of 10,000 = 50 deaths

    So, if we end up with 100 times more cases than we ever had with Delta (and this is entirely possible) when all is said and done, but only 1/6 of the deaths in terms of death rate, we will still end up with considerably more deaths due to the sheer number of infections.

    Remember, as the curve of +cases starts to eventually fall, the curve of +deaths (after 4-6 weeks) is pretty much guaranteed to rise, or so it has been with every other wave until now.

    -Stat
     
    CenterField and Sallyally like this.
  6. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    With a little more than 6 hours to go in the day on the east coast of the USA, the USA is already at +411,000 fresh infections and California has barely reported in. The USA may actually come closer to +500,000 cases today.
     
    Sallyally likes this.
  7. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    From yesterday:


    and....


    Regarding yesterday:
    "and so it was".

    Yesterday, 2021-12-029, our world clocked-in at
    +1,711,216 fresh infections, according to my excel table. According to WorldOMeter, it was +1,614,356, meaning that 96,860 cases reflected in my excel table were shunted by a number of nations into past dates. No matter how you look at it, our world jumped at least +1.6 MILLION Covid-19 cases in just one day, exactly as I predicted.

    Spain indeed came in over +100,000 cases, also meeting my prediction that at least 4 nations on earth would reflect more than +100,000 fresh infections. Actually, in all three rubriks (over +100,000, over +10,000, over +1,0000) records were set, with 76 nations total over +1,000 in just one day, of them, 20 over +10,000 in the same time frame and then of those 20, 4 in the dreadnaught category of +100,000 or more. Here, see for yourself:

    2021-12-029 COVID-19 Worldwide 005 - plus cases.png 2021-12-029 COVID-19 Worldwide 006 - plus cases.png 2021-12-029 COVID-19 Worldwide 007 - plus cases.png

    That's an interesting constellation of nations between +1,000 and +10,000 fresh infections: alongside the long list of African nations that are obviously now in the Omikron wave, there are also nations like Laos, Malawi, Malta, Panama, Uruguay, Channel Islands (pop. 177,000!!!), Norway and a couple of baltic states.

    You can also see that according to Worldometer, the USA was pushing +500,000 fresh infections (+465,670), whilst my excel table says +508,322, which means that 42,652 of the 96,860 worldwide "shunted" +cases were to be found in the USA. So, my prediction about the USA and +500,000 was also correct.

    This makes Wednesday, December 29th, 2021 verifiably and without a shadow of a doubt the heaviest C-19 day in the history of the pandemic thus far. Our world is now averaging +1,055,598 cases per day, which, if we hold this course, will bring the world to 287,000,000 total cases by years end, 203,000,000 more than end of 2020.

    The remaining question is to see what will happen today (2021-12-030) and tomorrow (2021-12-031, New Years Eve). Don't forget, there is also a financial aspect to this: many nations' budgets run from year's begin to year's end and not from July to July, as is the case in the USA, so a number of nations will need to use up the rest of their alloted budgets for Covid-19 related issues, otherwise, they risk losing some money in their budgets for 2022 and so I can see heightened testing across the board in the vast majority of nations over the next two days, if for no other reason than purely financial. I spoke to this point at the end of 2020 and indeed, it was so.

    PS. on an interesting side-note, Denmark (pop. 5.8 million) registered more +cases on this day than Russia.
     
    Last edited: Dec 30, 2021
    Sallyally likes this.
  8. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    It is very much looking as if today, 2021-12-030, is going to be an even heavier Covid-19 day than yesterday was, and yesterday was just a horrifying day, to say the least.

    First, we are already guaranteed FIVE nations over the +100,000 fresh infections-mark, which means that a new record has already been set today:

    1.) USA, with only 40 of 63 units reporting in thus far, the USA is already atr +411,000 and is sure to sail over +500,000 since there are still 8 hours left in the day on the East Coast of the USA. 7 day rolling as of yesterday = +306,555 per day.

    2.) France, with just over +206,000 fresh infections, 7 day rolling = +121,566 per day.

    3.) UK, with just under +190,000 fresh infections, 7 day rolling = +140,113 per day.

    4.) Spain, with just under +162,000 fresh infections, 7 day rolling = +82,391 per day.

    5.) Italy, with just under +127,000 fresh infections, 7 day rolling = +66,339 per day.

    Second, there are increases across the board in just oodles of nations, foremost among them, Canada, Australia, Greece and Denmark. But Israel and the UAE are also showing that the curve is going upwards as well. And Africa is now lighting up like a Christmas Tree in terms of Covid-19 infections.

    Third, I am estimating that we will be between +1.8 and +1.9 million fresh infections from today, it may even go as high as +2 million.

    I will recap this tomorrow when all of the figures for today are in.

    -Stat
     
    Last edited: Dec 30, 2021
    Sallyally likes this.
  9. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male

    So, the stats for the 2nd last day of 2021 are now ad acta and indeed, 5 nations were over the +100,000 mark. The USA was actually pushing +600,000 cases, when all was said and done.

    Records were set in all 3 top major +case rubriks over the record setting day of 2021-12-029, the day before, from 76 up to 77 nations over +1,000 cases, of them, from 20 to 23 with over +10,000 cases and as already noted, of those 23 - from 4 to 5 nations with over +100,000 cases, a true horror scenario that may become daily reality for a while.

    Yesterday I predicted that our planet would eventually clock in with "between +1.8 and +1.9 million fresh infections" and according to my excel table, it was +1,937,467, whilst WorldOMeter recorded +1,891,856, meaning that 45,611 cases were shunted to past dates. So, yeah, +1.9 million it was

    Again, just to see the immensity of this, the nations above +1,000 from yesterday:

    2021-12-030 COVID-19 Worldwide 005 - plus cases.png 2021-12-030 COVID-19 Worldwide 006 - plus cases.png 2021-12-030 COVID-19 Worldwide 007 - plus cases.png

    This time, Australia clocked-in with more cases than Russia, with both Ireland and Denmark just a hair's breadth away from Russia.

    The most disturbing part of this development is the very sudden rise in "active" cases, and therefore, also a rise in ICU cases, but this is really hard to quantify as different nations have different ways of defining "active" and "resolved", a point I spoke to close to the beginning of this thread in March of 2020.

    Today is now the last day of the year 2021 and we shall see what the day brings. I will be spending the next many hours crunching oodles of numbers as they come out, screenshotting like a pro and working detail tables until my eyes glaze over, but hey, that's what EOY is there for, eh???

    Also, later I will be updating the disclaimer and describing how I will be proceeding in both 2022 and 2023.

    Let's all hope and pray that this Omikron wave will be fast and furious, with emphasis on "fast".

    Oh, and HAPPY NEW YEAR TO ALL!!!

    -Stat
     
    Last edited: Dec 31, 2021
    Sallyally likes this.
  10. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    ADJUSTED DISCLAIMER AND CO., EFFECTIVE January 2nd, 2022

    [​IMG]

    HOW DO THESE ANALYSES WORK?
    WHAT'S THE "DISCLAIMER" ALL ABOUT?
    WHAT ABOUT THOSE ONLINE LIBRARIES AND OVERFLOW THREADS?

    WHY HAS THE ONLINE TRACKING BEEN EXPANDED TO WORLDWIDE +65 NATIONS?


    Things change with time, and so must I with them. In November of 2020, I posted a disclaimer about the analyses and then linked to it in every report. That disclaimer has changed with time and was re-presented on May 2, 2021 and then again in July 2021. The disclaimer from today is now the newest & will remain in place until the end of 2023, two years from now. Everything under the dotted line is pretty much the text from May 2, 2021 disclaimer and still applies. Everything above the dotted-line is new/adusted information.

    First, I have been working this thread virtually every day for 21+ months now, it's time for me to relax quite a bit more.

    Second, I am moving from tracking the numbers every single day to tracking them once per week at the end of every calendar week of the year. "Calendar week" will be defined by the European standard, where the last day of the week is Sunday, not Saturday. Since WorldOMeter has a "2 days ago" function, this means that all CW analyses will come out two days later, on Tuesdays.

    The 52nd calendar week of the year 2021 will end on January 2, 2022. These CWs (calendar weeks) are often called "straddle weeks" because they straddle the fence between two years. The first full calendar week of 2022 will end on Sunday, January 9th.

    On the surface, little will change for you the reader as you have become used to reading what I had been calling the "weekly concise analyses", which will now be called "calendar week analyses"

    At end of each quarter: the entire slew of tracked nation screenshots and intensive analyses for Q1, Q2 (half-year), Q3 and Q4 (EOY) will be presented, but you can see the weekly/quartely figures roll by at the online excel table (see: SIG FILE or THIS LINK). These analyses will also be published 2 days after the event.

    As a result of moving to tracking on a weekly instead of daily basis, the excel table will have a new look for 2022:

    2021-12-031 COVID-19 template as example.png

    First you can see that all calendar week analyses are for weeks that end on Sundays, which is why you see a ton of "Sunday" in Column B. Column C was added a number of weeks ago and registers the number of the calendar week, also for end of Quarter. You can see that EOY 2021 ends on a Friday whereas the end of both Q1 and Q2 (half-year) are on a Thursday. You will also see that although they are not part of 2022, both 2021-12-026 and EOY 2021 are in this table as those figures will be needed to calculate the first CW of 2022 and also the EOQ reports. Those specialty reports are highighted in a sort of aqua-color to set them apart from the rest. You will also notice that the color coding for CW days is different than you saw in 2020 and 2021: cases are now blue, deaths are now green, recovereds are black, actives are dark brown and tests are more of a dark gold color.

    The numbers you see in the cells in the screenshot above have no meaning, I plugged them in just to make sure that the math works correctly. It works correctly!

    It's actually kind of cool: in just one standard screenshot, you can see a half-year's worth of data. And this also reduces my clerical load quite a bit.

    Third, the daily tracking started in 2020 with worldwide and 3 nations, then 4, and then as of Election Day 2020, the list started to grow very quickly, landing at 50 tracked nations in the last quarter of 2021. As of 2022, I am starting the tracking with 65 nations but when you consider that in 2020, 18 nations sprung over the 1,000,000-mark and then in 2021, 24 more nations did the same, leaving us with 42 nations in the million-club as of end of December 2021, and then considering the severity of the Omikron wave, it's entirely likely that that at least 30 nations will jump over the 1,000,000-barrier in the course of 2022, so I figure that the tracking will land at about 80 nations at the end of 2022 and probably at 110 at the end of 2023. This is very doable for me as I am only tracking the numbers every seven days (plus 4 end-of-quarters), which is only about 1/7th of the work I have been doing until now.


    Fourth, as for the USA, it will receive a half-year and EOY analysis.

    Finally, even if massive waves continue to hit our world, I will not be going back to daily tracking, it is just too time-consuming for me to get things 100% right.

    I would like to thank @Falena personally for allowing this thread to flourish this long. I would bet that you don't get thanked enough to the good things you do. I would also like to thank the mods for doing good work helping to keep a (mostly) neutral thread "clean". Tikkun Olam, baby, Tikkun Olam!

    Folks, please remember that conversation here is always welcome, we just like to stick to the hard data in this corner of PF.


    Associated links:

    Chronological online PF C-19 analysis Library-links: 2020 / 2021 / 2022 & 2023
    That is a really handy tool to find analyses by date or by topic without having to sift through the many thousands of postings on this huge Covid-19 thread.

    Then, the screenshot overflow links for:
    2020 / 2021-01, 2021-02, 2021-03, 2021-04, 2021-05, 2021-06, 2021-07, 2021-08, 2021-09, 2021-10, 2021-11, 2021-12, 2022, first half / 2022, second half / 2023, first half / 2023, second half

    Of course, the links for 2022 and 2023 are not full with information yet, but they will be tended to regularly.

    Third, these are the current parameters for the calendar week concise reports:

    -CWs: just barebones data for the worldwide figures and the top nations, from 10,000,000 total C19 cases upwards and as of Q3 2022, from 20,000,000 cases upwards.

    -End of Quarter (EOQ, half year, EOY): very large analyses, which you can interpret for yourselves.

    -Whatever is not screenshotted during the week, you can always see for yourself at the online-excel-document (see: sig-file).

    -To do a one-year lookback: simply use the online library-link for the year before, where applicable.


    -----------------------------------------------------------------------------------------------------------------------​

    -DISCLAIMER-

    If you want to see the analysis for any day I have analyzed, then either use the online library link or go to my sig-file, open the excel table, go to the tab that you want and click on the date you want. My sig-file is going to be here for a long, long time, but when the time comes that it is gone, then feel free to click HERE.

    Rolling averages are based on weekly data (daily cases / daily deaths).

    Confirming/sorting the data for the analyses? Then go here: WORLDOMETER for the current date -or- here: WAYBACK MACHINE when searching for today's date in the future: search for one or two days later than you want, then use the "yesterday" or "2 days ago" function at the top their large excel table.

    Value discrepancies: sometimes there are discrepancies in the +-values (new cases, new deaths) between my excel table and WorldOMeter. This is always and without exception because WorldOMeter changed totals out of the past, usually from one or two days before, after I wrote the analysis. This is what I call "shunting datsa into the past" and it is happening more often as countries are revising figures more often. Either way, I stick with the + values on my excel table as they are the correct reflection of the numbers as I recorded them. I simply do not have time to be constantly hunting numerical "ghosts" back into the past. If the discrepancy is extreme, I will note it briefly.

    Pertinent only to the USA: when that country is analyzed, it is analysed in 63 Units instead of 50 states.



    -Stat
     
    Last edited: Dec 31, 2021
    Sallyally likes this.
  11. Sallyally

    Sallyally Well-Known Member Donor

    Joined:
    Mar 12, 2017
    Messages:
    15,863
    Likes Received:
    28,304
    Trophy Points:
    113
    Gender:
    Female
    Happy New Year to you .
     
    Statistikhengst likes this.
  12. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male

    And to you as well!
     
    Sallyally likes this.
  13. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    HAPPY NEW YEAR TO ALL PFers!
    Later today I will start dumping out all sorts of EOY 2021 statistics. It is a long and arduous process to get everything right, but here is a statistic from EOD yesterday, 2021-12-031 concerning this thread:

    2021-12-031 C-19 THREAD VIEWS.png

    I'll just let that statistic speak for itself....
     
    Sallyally likes this.
  14. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 1 of 7:
    Worldwide and and top 65 nations (split into seven postings)


    READ!
    The disclaimer at the top of this posting is new, I recommend that you read it if you have not already.

    The end-of-year analyses are very intensive and take time to do well. Here the schedule:

    -the following seven postings are the screenshots of the Worldwide figures and the top 65 nations. I upped the total of tracked nations from 50 to 65 by adding the pre-tracked nations to the already tracked nations, calling other nations that were once mothballed out of mothballs and adding 3 or 4 new nations as well. As you can imagine, it was a lot of work.

    The Worldwide excel table figures will not be posted here as they will receive an individual analysis. Instead, a screenshot (2 pages) of the preliminary Worldwide figures from WorldOMeter plus the 65 nations currently being tracked will be posted as proof of the veracity of the data.

    -later this evening, I will publish a USA EOY analysis.

    -Tomorrow, on 2022-01-002, I will then publish the end-analysis for the Worldwide figures for EOY 2021. WorldOMeter has a "2 days ago" function at its main table, which allows us to wait one more day to see the final numbers. The advantage to this is that nations that may be adjusting their total figures will have one more day to do so. The worldwide analysis will be quite extensive, with the tables tooled to look at yearly values.

    I've eliminated a lot of extra text in these five postings. If you want to see where the virus has grown or receded, then take a good look at the monthly + numbers (+cases and +deaths over EOM of the month before), at columns P and Q in row three for EOM this month and in row 34 for EOM of the month before. The exact growth rates will be calculated on a separate table, as always.

    Note: as was the case with Christmas Eve 2021, New Year's Eve fell on a Friday and there are some nations that report no values at some or all of weekend (Spain, Belgium, Hungary, Switzerland). Three of those four nations have not yet reported in for New Years Eve and due to the weekend, they may not. One has to work with the data one is given, eh...

    The highlighting in the screenshots is different this time: I have only highlighted BOTH rows for 2021-12-031. The upper row, in an aqua color, is for the yearly calculations, while the lower row is for the daily and monthly calculations.

    So, let's get started.

    WORLDWIDE:
    The Worldwide EOM analysis for will be published on 2022-01-002

    For in the meantime:


    [​IMG]
    [​IMG]



    USA (preliminary):
    2021-12-031 USA 000 - PROVISIONAL.png

    The USA EOY analysis will come out in the next hours.



    INDIA:
    2021-12-031 INDIA 000.png


    BRAZIL:
    2021-12-031 BRASIL 000.png


    UK:
    2021-12-031 UK 000.png


    RUSSIA:

    2021-12-031 RUSSIA 000.png


    FRANCE:


    2021-12-031 FRANCE 000.png


    TURKEY:
    2021-12-031 TURKEY 000.png



    GERMANY:
    2021-12-031 GERMANY 000.png


    SPAIN:

    2021-12-031 SPAIN 000.png


    IRAN:

    2021-12-031 IRAN 000.png
     
    Sallyally likes this.
  15. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    [
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 2 of 7:
    Worldwide and and top 65 nations (split into seven postings)


    ITALY:

    2021-12-031 ITALY 000.png



    ARGENTINA:
    2021-12-031 ARGENTINA 000.png


    COLOMBIA:

    2021-12-031 COLOMBIA 000.png



    INDONESIA:
    2021-12-031 INDONESIA 000.png



    POLAND:
    2021-12-031 POLAND 000.png



    MEXICO:
    2021-12-031 MEXICO 000.png



    UKRAINE:
    2021-12-031 UKRAINE 000.png




    SOUTH AFRICA:
    2021-12-031 SOUTH AFRICA 000.png


    NETHERLANDS:
    2021-12-031 NETHERLANDS 000.png



    PHILLIPPINES:
    2021-12-031 PHILLIPPINES 000.png
     
    Sallyally likes this.
  16. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 3 of 7:
    Worldwide and and top 65 nations (split into seven postings)


    MALAYSIA:
    2021-12-031 MALAYSIA 000.png


    CZECHIA:
    2021-12-031 CZECHIA 000.png


    PERU:
    2021-12-031 PERU 000.png


    THAILAND:
    2021-12-031 THAILAND 000.png


    CANADA:
    2021-12-031 CANADA 000.png


    IRAQ:
    2021-12-031 IRAQ 000.png



    BELGIUM:
    2021-12-031 BELGIUM 000.png


    ROMANIA:
    2021-12-031 ROMANIA 000.png



    CHILE:
    2021-12-031 CHILE 000.png


    JAPAN:
    2021-12-031 JAPAN 000.png
     
    Sallyally likes this.
  17. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 4 of 7:
    Worldwide and and top 65 nations (split into seven postings)


    VIETNAM:
    2021-12-031 VIETNAM 000.png


    BANGLADESH:
    2021-12-031 BANGLADESH 000.png



    PORTUGAL:
    2021-12-031 PORTUGAL 000.png


    ISRAEL:
    2021-12-031 ISRAEL 000.png


    SWITZERLAND:
    2021-12-031 SWITZERLAND 000.png


    SWEDEN:
    2021-12-031 SWEDEN 000.png


    SERBIA:
    2021-12-031 SERBIA 000.png



    PAKISTAN:
    2021-12-031 PAKISTAN 000.png



    AUSTRIA:
    2021-12-031 AUSTRIA 000.png



    HUNGARY:
    2021-12-031 HUNGARY 000.png
     
    Sallyally likes this.
  18. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 5 of 7:
    Worldwide and and top 65 nations (split into seven postings)



    GREECE:
    2021-12-031 GREECE 000.png



    JORDAN:
    2021-12-031 JORDAN 000.png


    KAZAKHSTAN:

    2021-12-031 KAZAKHSTAN 000.png

    CUBA:

    2021-12-031 CUBA 000.png


    MOROCCO:
    2021-12-031 MOROCCO 000.png


    GEORGIA:
    2021-12-031 GEORGIA 000.png


    SLOVAKIA:
    2021-12-031 SLOVAKIA 000.png



    NEPAL:
    2021-12-031 NEPAL 000.png


    IRELAND:

    2021-12-031 IRELAND 000.png


    DENMARK:
    2021-12-031 DENMARK 000.png
     
    Sallyally likes this.
  19. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    Analysis tables for EOY (End of Year): December 31, 2021

    (UTC +0, Greenwich = 20:00 UTC -5, East Coast of the USA), Part 6 of 7:
    Worldwide and and top 65 nations (split into seven postings)



    UAE:
    2021-12-031 UAE 000.png



    BULGARIA:
    2021-12-031 BULGARIA 000.png


    LEBANON:

    2021-12-031 LEBANON 000.png


    TUNISIA:

    2021-12-031 TUNISIA 000.png


    CROATIA:
    2021-12-031 CROATIA 000.png


    BELARUS:
    2021-12-031 BELARUS 000.png


    SOUTH KOREA:

    2021-12-031 SOUTH KOREA 000.png



    GUATEMALA:
    2021-12-031 GUATEMALA 000.png


    AZERBAIJAN:

    2021-12-031 AZERBAIJJAN 000.png


    BOLIVIA:
    2021-12-031 BOLIVIA 000.png
     
    Sallyally likes this.
  20. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    Last edited: Jan 1, 2022
    Sallyally likes this.
  21. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    Sooooo.... that was the final time where I post so many screenshots here in PF.

    So the Quarterly, half-year and EOY analyses as of 2022, these pre-analysis screeenshots will simply be uploaded to the screenshot overflow link, which you can then go to.
     
    Sallyally likes this.
  22. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    REFERENCE LINK, 2022 EDITION (new standing disclaimer as of 2022, written December 31,2021, online libraries, screenshot overflow links) - please read at least once and use as needed - there is new info to be gleaned.


    USA COVID-19 statistical analysis EOY (End of Year), 2021-12-031
    (UTC +0, Greenwich = 20:00 ET)

    ֍֍֍֍֍***** 55,696,500 *****֍֍֍֍֍
    THE USA DATA IS FINAL
    +6,243,189 cases over the month before (➚
    ) / +43,534 deaths over the month before ()
    +35,250,846 cases over the YEAR before (➚) / +492,690 deaths over the YEAR before ()


    USA 7-day rolling averages:
    +387,170 new C19 cases per day (➚ one month ago: +88,209) / +1,319 deaths per day (➚ one month ago: +1,007)

    USA yearly calculated daily averages:
    +95,578 new C19 cases per day / +1,350 deaths per day

    ---------------------------------------------------------
    The number of serious/critical (ICU) cases in the USA: 18,028 (one YEAR ago: 29,214 )
    Total USA C19 tests administered: at year's end, the USA exceeded 800,000,000 total tests

    ---------------------------------------------------------------------------------------------------------------------------------------

    STAT'S EXCEL-TABLE:
    2021-12-031 COVID-19 USA 000 - FINAL.png

    Again, the disclaimer at the top of this posting is new, I recommend that you read it if you have not already.

    In one year's time, the USA went from 20.4 to 55.7 million COVID-19 cases and from 354,000 to 847,000 COVID-19 deaths. Before you read farther, re-read that last sentence and reflect for a moment. Believe me, it's a good idea. Let that sad news sink in for a while. This means that worldwide I will soon need to open a sub-rubrik on the worldwide rubrik table for "1,000,000 total deaths" and also for "1,000,000,000 total tests performed".

    What the averages mean: +387,170, +1,319 = 268.9 fresh C19 cases and 0.9 C19 deaths per minute in the USA. EVERY MINUTE OF EVERY DAY.

    The 4-rubriks worksheet that I used for the USA in 2021 was discontinued as of July 2021. However, the worldwide rubrik worksheet still exists and will continue into 2022-2023.

    The big difference between 2021 and 2020, also worldwide, was the infusion of vaccines into the public domain.

    I could write a lot of technical, flowery stuff, but the long and short of this is that the Omikron wave is kicking the world, and very specifically, the USA, in the ass. What remains to be see if whether or not Omikron will cause more or less deaths than the variant before (Delta).


    COVID-19 in the USA, by all 57 UNITS, Total cases (WorldOMeter):
    2021-12-031 COVID-19 USA worldometer 001 - total cases.png

    That's the 1st screenshot. You can find at the 2nd screenshot overflow link (see: disclaimer)

    I bet that it kind of took your breath away to see that Florida and New York clocked in at +75,000 and +70,000 fresh infections at New Year's Eve, respectively, and in just one day's time.


    COVID-19 in the USA, by all 57 UNITS, total cases, deaths and tests:

    For the last year I went an entirely different way when it came to monthly statistics for the USA. At the online excel document (see: sig-file), I created a multi-table, porting over the data from the last day of the month and also the month before and then adding some calculation functions that are not at the WorldOMeter site. Here the +cases, something you cannot see at WorldOMeter and in this case the calculations are for the yearly figures instead of the usual monthly figures:

    2021-12-031 COVID-19 USA 001 - total cases, deaths.png 2021-12-031 COVID-19 USA 002 - total cases, deaths.png

    As of EOY 2021, 19 units (all of them states) have jumped over the million-mark in total confirmed C-19 cases. Worlwide, that number = 42 nations.
    Also, as of EOY 2021, 4 units (all of them states) have suffered more than 50,000 total deaths.


    2021-12-031 COVID-19 USA 003 - total tests.png 2021-12-031 COVID-19 USA 004 - total tests.png

    1 unit in the USA (CA) has performed more than 100,000,000 C-19 tests. 25 units have performed over 10,000,000 total tests.​

    COVID-19 in the USA, by all 57 UNITS, YEARLY + cases, +deaths, +tests:


    2021-12-031 COVID-19 USA 005 - plus cases, deaths.png 2021-12-031 COVID-19 USA 006 - plus cases, deaths.png


    It should be noted that right before Joe Biden's inauguration on 2021-01-020, the C19 death toll in the USA stood at 411,520. That number was slightly more than doubled as of 2021-12-015, so pretty much the same number of people died under the Trump administration as have now died during the Biden administration and in both cases, it happened within 11 months. Covid-19 knows no politics, it is an equal opportunity killer.

    2021-12-031 COVID-19 USA 007 - plus tests.png 2021-12-031 COVID-19 USA 008 - plus tests.png
    FACIT: after hopes that the USA had quashed its second wave, then came Delta, and now, Omikron. The pandemic is actually now an endemic.

    -Stat
     
    Last edited: Jan 1, 2022
    Sallyally likes this.
  23. Statistikhengst

    Statistikhengst Well-Known Member

    Joined:
    Oct 8, 2015
    Messages:
    16,828
    Likes Received:
    19,377
    Trophy Points:
    113
    Gender:
    Male
    Representatives Bobby Rush (D-IL) and Ayanna Pressley (D-MA) have tested Covid-19 positive.
     
  24. Sallyally

    Sallyally Well-Known Member Donor

    Joined:
    Mar 12, 2017
    Messages:
    15,863
    Likes Received:
    28,304
    Trophy Points:
    113
    Gender:
    Female
    Holy moly!
     
  25. freedom8

    freedom8 Well-Known Member

    Joined:
    Jul 17, 2018
    Messages:
    1,854
    Likes Received:
    1,117
    Trophy Points:
    113
    All the Best to you in 2022!

    And thanks for the good work you're doing.
     
    Statistikhengst and Sallyally like this.

Share This Page