COVID-19 Update - 06/30/2020

My own workup | 06/30/2020 | DoughtyOne

[DoughtyOne]

PING LIST - Please contact me as needed...

COVID-19 Update # 104

As of 06/29/2020 23:15 PDST     United States CDC - Provisional Numbers
As of 00/00/2020 23:45 PDST     Johns Hopkins University - Capture Nations Informaton
As of 00/00/2020 23:45 PDST     Johns Hopkins University - Capture Counties Information
As of 00/00/2020 23:46 PDST     Johns Hopkins University - Process JHU Data
As of 00/00/2020 23:59 PDST     WorldofMeters - Document Core Numbers
As of 00/00/2020 23:59 PDST     WorldofMeters - Capture Nations Information
As of 00/00/2020 23:59 PDST     WorldofMeters - Capture States Information
As of 00/00/2020 00:00 PDST     WorldofMeters - Data Processing begins...
As of 00/00/2020 ??:?? PDST     Publish COVID-19 Update - 00/00/00

Thank you for stopping by to check out the COVID-19 Update.

Here you can find...

Section: 01     Commentary, Special Reports, COVID-19 Update Info, & System Notes
Section: 02     the United States Situation
Section: 03     the Global Community Situation Outside China
Section: 04     the Global Community Situation Including China with reservations
Section: 05     the Mortality Report
Section: 06     Miscellaneous Reports of Interest
Section: 07     the United States, Counties (alphabetical / case no descending)
Section: 08     the United States, States Ranking, Provisional Numbers, & Territories
Section: 09     the United States, Ranked with Other Nations
Section: 10     the End of this COVID-19 Update
Section: 11     Data Sources and a Link to My Own Spreadsheet
Section: 12     Linked Spreadsheet: Counties, States, Provisional, Territories, & Nations
Section: 13     Links to Other Resources

Section: 01

Commentary, Special Reports, and COVID-19 Update Information¹
Interesting Tid-bits (hopefully)

China Decides to Play the 'Who Did the Most Testing Game?"

This note will remain here for a while.

Around 06/23, China started putting out it's testing numbers. I thought
they were suspect. The number they put out was 90,410,000. Ours and most
everyone else's numbers are specific. For instance on 06/28, our number of
of tests at the ned of the day was 32,592,368. That specificity separates it
from the number China put out. It was rounded to the 10 thousandth place. In
addition, China has not updated that number once. So I do not inlude China in
the Nation's Comparison Sort regarding Testing.

Section: 02

The Following Addresses the Numbers Here in
the United Staetes of America

Here we go...

New Cases are still reporting out higher than I'd like. Yesterday's number rose.
As the week progresses, it will get a lot higher.

Concept of adding in Active Cases and Serious Critical here, courtesy of amorphous

Here are more of our numbers...

Active cases continue to climb.

Our Slice of the COVID-19 Pie

The growth of our slice of the pie has been dropping recently.

Here are the numbers I've been tracking, Globally Declared and Active Cases.

We're struggling here, as our slice of the pie looks to be headed back up again.

Active Cases in the United States / Chart

Unlike some of the other charts here, we should see a good rise and
fall at some point withone.

Note that this presents the one day and then 7 and 14 day averaging versions.

Remember, these are not new Declared Cases. These are remaing Active Cases.

Clearly the single, seven, and fourteen day lines are moving way up.

Testing and New Case Figures
Requested by stocksthatgoup

Some folks have shown an interest in seeing the COVID-19 Test figures compared
to the New Cases being declared. The following Data addresses that.

Take a look at those positive testing percentages, where they have been and
where we are now. Not good. Yesterday was a little worse here.

Not liking the new direction here.

The U. S. Stats / w 10 Day Averaging / Fr: 03/17
Requested by: Texas Eagle

This data and chart presents things in a little different way. In the
chart it is easy to see the relationship of these numbers.

The Chart will use the data all the way back to 03/17, but the data displayed
here will only go back one month.

Here is the chart to match.

These seemed to be getting closer each day, but now they may actually be close
to heading away from each other.

Section: 03

The Following Addresses the Global Numbers
without Mainland China

Here is the first set of Data for the Global Outside China
Territories

Yesterday's numbers came in on a traditonally low count day. Get ready for the
large reporting days coming up.

Fata.lities, Recoveries, Resolved, Active Cases, and
Serious/Critical Cases - Globally, Excluding M/L China
Concept of adding in Active Cases and
Serious/Critical here, courtesy of amorphous

Here we go...

For your review...

How is the Global Community Outside China Doing,
Without U. S. numbers?

Let's see...

Well, a little improvement outside China and the U. S.

Look where we're resting, as the big days loom large. Not good.

Ouch! That hurts...

These charts are now not only seeing growth internationally, but domestically
as well.

The Active Cases outside China Globally / Chart

As in the U. S. version of this, we should see a good rise and fall at
some point these two.

Note that these present the one day and then 7 and 14 day averaging versions.

Remember, these are not new declared Cases. These are remaing active cases.

That single day line is active, up and down, or should I say up and up more.

Special Section on France, Germany, Italy, Spain, and the U. K.
Case growth.

Jim Noble mentioned he'd like to see the US numbers added here. I added them
in on 06/21/2020. I did not add them to the chart because it would have
dwarfed the European nations chart lines. (they would have been reduced to
about 15% of their normal size)

Let's Look at Some Numbers in Five Day Increments:

Everyone including the U. K. seems to be flattening out there. Hope they
can keep that up, or begin to slide back down soon.

Sweden and It's Neighbors, Who Has the Best Tactic Against COVID-19?

Sweden is doing its own thing with regard to isolating. I think most people
are aware of it by now.

Here are some numbers to help us look at this issue.

Sweden still remains a hot topic, and it's tragectory IS NOT looking good
on that Chart. In it's own group, it's not good at all. If you compare it
to some European Nations, it looks no worse.

Movers and Shakers...

I will present the top fifty nations with the most New Cases and New
Fatilities.

Here we go...

Still on the top of The New Cases stack.

Global osChina Stats / w 10 Day Averaging / Fr: 03/05
Requested by: Texas Eagle

This data and chart presents things in a little different way. In the
chart it is easy to see the relationship of these numbers.

The Chart will use the data all the way back to 03/05, but the data
displayed here will only go back one month.

Here is the chart to match.

I like being able to follow the movement of these stats visually.

Section: 04

The Following Addresses the Global Numbers
including Mainland China*

Mainland China's numbers are 0.010% of today's total global numbers.

A Look at Declared, Resolved, and Active Cases, Includes M/L China

End of day figures follow:

It was nice to see a bit of an uptick here. I was afraid it would turn around
and start dropping. Maybe we will make it to 60%. Would be nice.

Fatalities, Recoveries, Resolved, Active, and Serious/Critical
Cases Globally, Including M/L China
Concept of adding in Active Cases and
Serious/Critical here, courtesy of amorphous

For your review...

Section: 05

the Mortality Report

Here is the data for four entities...

Here are the figures for the growing case totals for four entities.

We hear all sorts of stories about how these figures are wildly off. The CDC
has studied them and seems to think they may actually be on the low side of
things. I am providing the CDC Provential Numbers down below. Not sure if
anyone has a rock solid number. I doubt it is possible. This is what is
reported out by WoM and JHU. Check out the CDC numbers too.

Charts like this one only show growth. That's why I recently took the advice
of a FReeper and added in a new chart for the U. S. and Global outside China
regions.

Here are figures revealing the daily growth for those four entities.

US Fatalities for the day were down 4.68% from the same day the previous week.

Folks this isn't a be all end all stat. It just gives us some comparson back
seven days. The dashboard lets us look at the current day's comparison to the
prior seven days.

If people want more information, I've provided the last 30 days just above.

If people want more than that, I have made my entire database available for
for download down below. You can play with the numbers to your heart's
content.

We have looked very good in this area recently, but I am very concerned what we
will look like in a week, what with the growth in new cases. IMO < deaths are
about to join New Cases in growth. Who knows, maybe I'll be surprised by no
growth.

Here, let's look at data for the U. S. broken out by itself.

In the lasts 24 days, we've had just one legitimate day over 1000. That is
impressive.

New York, New Jersey, I'm sure you'll have a very hard time figuring out where
they botched things... /s

Section: 06

Population Saturation

Here are figures revealing how many people in each population base represent one
case. I'm also showing what percent of each population base is infected at this
time.

We're still slipping here, and I'm looking forward to better numbers.

Nations With Lots of Cases

At the end of the day yesterday, there were:

It's hard to belive there are that many nations with massive numbers.

Daily Case Report Evaluation

I'll be keeping tabs on the daily tallies for days of the week for a while. Folks have
noticed some patterns of larger and smaller data entry on certain days, and on Fridays
sometimes the numbers get noticeably larger because of it.

And we now know Thursdays have potential to break out also. Yikes!

IMO Let's check out the numbers and a chart.

Look at the growth over the last seven days, compared to the historic levels
since March. Will be interesting to see what comes of this.

Section: 07

The Top 200 Counties in the U. S., by Number of Cases

This little report lists 200 Counties in the United States in declining Case numbers.
There is also a listing that is alphabetical. This report list only the entities
and the number of Cases in the two different sorts.

It will also be available as a downloadable Excel file in Section 12.

Section: 08

States of the Union and the District of Columbia, Compared to Each Other

Each of these pages is sorted differently. Look at the red header above
the columns to see which column was used for the sort on any given page.

For your review...

For your review...

For your review...

For your review...

For your review...

For your review...

For your review...

For your review...

For your review...

If this area interests you, please use this LINK to the source, and review
the lengthy description and explanation of it's development process.

There are two reports. The presentation above comes from the second one,
and the detailed segmented information below it, may interest you.

These can now also be found under the states on the Alphabetical list. The
states and these entity's numbers should be combined to match that of the
U. S. figures each day.

Section: 09

The United States, Where it Ranks With Other Nations?

Each of these pages is sorted differently. Look at the red header above
the columns to see which column was used for the sort on any given page.

The U. S. will be highlighted red here so we can find it easily in the list.
There was 215 nations on this list last night now. I didn't want to post
seven lists with 215 nations on it, so I picked the top 50. Coincidentally,
one report category had the U. S. at 41st, so it wasn't showing up on the
list with the 31 top nations on it. That wasn't the reason why I extended the
list length, but it did work out well.

I work on the nations right next to the states on my spreadsheet. The
states with the District of Columbia come in at a total of 51 lines.
I decided to keep the international reports near that length, and 50
was good enough.

Here we go... for your review.

For your review...

For your review...

For your review...

For your review...

For your review...

For your review...

Look at that. We have come down from 43rd, and now reside at 26.

That's the best we've reported out as so far, and we seem to be resting up
here for a while. Testing has been ramping up, so that was just a figure
of speech about being 26th for a while.

Progress...

Section: 10

Here is what it is all about. From January 20th to the present.

This concludes our look back at yesterday's data. Take care...

Court Sesy of: foldspace

Section: 11

Data for this Report Sourced From:

LINK   WorldoMeters

LINK   Johns Hopkins University
               The Center for Systems Science and Engineering (CSSE)

LINK   United States Center for Disease Control - Provisional Numbers

Listed in the order of current utilization...

LINK   You are Invited to Review My COVID-19 Spreadsheet (XLSX)
               There is not an XLS version available for distribution at this time.

Section: 12

Other Features:

LINK   US Counties²⁰⁰, States & DC⁵¹, Territories & Other Entities¹¹, Nations²¹⁴,
                and the CDC Provisional Counts⁵³
                Five Excel Spreadsheet datasets you can sort for your own studies...

Section: 13

Links to other resources:
I cannot vouch for these sites. Please use your own judgement.

LINK   Adventist Health Coronavirus Resource Hub - Scroll down for useful info

LINK   Antibiotic Vitamin, the (Vitamin D)
               Good article on Vitamin D's likely role in prevention of infection. Thanks Blam.

LINK   CDC Data for Download - Scroll down - Excel required. Includes death stats.

LINK   CDC National Center for Health Services
               Provisional deaths as determined by review of vital documents. Much lower...

LINK   CDC Secondary Data and Statistics - Portal Entry / Look around

LINK   Coronavirus (COVID-19) Map

LINK   Coronavirus infection risk may be reduced by Vitamin D
               by Former CDC Chief Dr. Tom Frieden

LINK   Coronavirus Spread Quickly Around the World in Late 2019, Study Shows
               the University College London Genetics Institute

LINK   COVID-19 Deaths Broken Out by Thirds, 05/07/20 Map of US Counties
               Very revealing display of Concentrated Death Zones - thanks hoosiermama

LINK   COVID-19 First U.S. Case, Treatment, features Remdesivir
               New England Journal of Medicine article

LINK   Cytokine Storm, med Actemra, Physician near death saved

LINK   Diamond Princess Review at 634 Case Point of Eventual 712

LINK   Hydroxychloroquine Article: International Poll
               Daily Mail Reports, Most Effective Treatment According to 6,000 Physicians

LINK   Hydroxychloroquine Has about 90 Percent Chance of Helping COVID-19 Patients
               the Association of American Physicians and Surgeons, reports 91.6% of patients improved clinically

LINK   IHME - Institute for Health Matrix and Evaluation

LINK   National Institutes of Health - Cornavirus (COVID-19)

LINK   Nasal Irrigation is the Key, COVID-19 Related

LINK   New York City - interesting breakdown, borough, age, sex

LINK   On the Origin of CCP Virus, A Documentary Movie (turn up the sound)
               Epoch Times: I highly recommend this very well documented report.

LINK   R_t COVID-19
               Calculates and displays the R_t Factor for each state. Thanks FreedomPoster.

LINK   World Health Organization

[DoughtyOne]

[reasonisfaith]

Fear is the enemy of reason.

[DoughtyOne]

Thinking we know it all, trumps fear.

[traderrob6]

Indeed. This thread is certainly taking on a whiff of “concern trollism”.

Remember, it’s all about deaths not positive test results. We are averaging over 40K positives per day now but the average for deaths per day is less than 500.

The ONLY people that need to be protected are the particularly vulnerable to dying from the disease which are obviously the elderly and those with significant preexisting conditions.

Per the CDC:

“A total of 31,934 laboratory-confirmed COVID-19-associated hospitalizations were reported by sites between March 1, 2020 and June 20, 2020”

Read it twice, that is NOTHING! Over a third of a year less than 32,000 people were admitted to the hospital for Covid-19 related issues.

Btw, that’s approximately 5 admissions per US hospital over a 4 month period.... TOTAL!

[Sam Gamgee]

Seems to be a little surge here in deaths. California leading in new deaths. Could this be the second wave we were told about?

[Sam Gamgee]

I’m not worried and have never been worried this whole over reaction. What worries me only is other people worrying too much about it, so the sooner we can get it behind us, the better. The Democrats are going to play every death for what its worth against Trump.

[God luvs America]

California is importing patients with the chinese flue from mexico....several threads about it here.

[traderrob6]

Unfortunately herd immunity is going to take some time. Hopefully the virus will help us out by slowly reducing it’s virulence as time goes on.

Right now we need to take FDR’s advice concerning “fear”.

[Presbyterian Reporter]

“””Remember, it’s all about deaths not positive test results. We are averaging over 40K positives per day now but the average for deaths per day is less than 500.”””

---

Well stated.

Keep in mind that the recent increase in positive tests results is the only thing the media has to complain about at this point.

Before new cases the media was complaining that there was not enough testing.

Before testing the media was complaining that there were not enough ventilators.

Before ventilators the media was complaining that there was not enough PPE.

Before PPE the media was complaining that Trump had not shutdown early enough.

Before PPE the media was complaining that Trump had shut off travel from Europe to the USA.

Before travel from Europe the media was complaining that Trump had shut off travel from China to the USA.

Before travel from China the media was complaining that Trump must be impeached. And on and on and on.

The trend is obvious. And, oh yes, the emerging complaint from the media is that Trump does not wear a mask.

[odawg]

Two years ago, 385 deaths per day in the U S from the flu.

[reasonisfaith]

I never knew that, although I agree the thing you describe would be a significant disadvantage.

How did you know it to be the case?

[reasonisfaith]

I’m convinced the Chinese and the Wuhan Institute can never be used against us again.

I’m also convinced that these lowlifes would hurl another virus at us if they could.

Unbeknownst to them, their ultimate accomplishment will be self-infection.

[SaxxonWoods]

“California leading in new deaths. Could this be the second wave we were told about?”

What is the date of the end of the first wave, and how do you identify it as the end?

[DoughtyOne]

Take a look at what is going on on the Left and in the streets today.

It isn’t taking place of fear. It’s taking place because millions of our youth have been led to believe they know everything.

This nation could cease to exist because of it.

The Deep State, Fauci, they all think they know everything.

There’s no moderation in these folks. They are sure they couldn’t possibly be wrong.

[Impy]

Recent spike correlates precisely to the BLM riots, doesn’t it?

[reasonisfaith]

Got it. You have a good point.

[exDemMom]

We are averaging over 40K positives per day now but the average for deaths per day is less than 500.

The death rate is a lagging indicator. People with fatal cases of Covid-19 die from 2 to 6 weeks after infection. So we won't see increased deaths from the recent surge in cases for another week or so.

There were actually 1,284 daily deaths in the US as of 7:25 this morning, compared to 338 over the previous 24 hour period. That's a jump of nearly 4 fold.

[traderrob6]

I don’t know where you’re getting your “figures” from but as of 7:30 this morning Worldometer had 12 deaths listed so far today.

Yesterday they had a total of 764.

You are buying into the misbelief that those most vulnerable are being equally as infected as those that are not. That is a erroneous assumption.

Also look at the initial spikes in infection in March/April.....there was no “lagging effect” They mirrored each other.

Also look at hospitalizations.....No major surge.

Perhaps you’re hoping for something very negative or maybe you’re a concern troll or maybe you actually believe the pap you’re posting. Regardless, it is spurious.

[exDemMom]

I get my figures from the Johns Hopkins Center for Systems Science and Engineering. I update my own spreadsheet daily at around the same time each day.

On Jun 29 at 7:37 AM, I recorded 125,803 US deaths posted at the Johns Hopkins website.

Yesterday at 6:31 AM, I recorded 126,141 US deaths, or a total of 338 deaths over a one day period.

Today at 7:25 AM, I recorded 127,425 US deaths, or an increase of 1,284 over the previous day.

I have been recording daily case, death, and recovery data from both Johns Hopkins and Worldometer since March. I have been recording separate US numbers since April. So I have a fairly comprehensive data set.

Perhaps you’re hoping for something very negative or maybe you’re a concern troll or maybe you actually believe the pap you’re posting. Regardless, it is spurious.

There is nothing spurious about presenting the facts about the pandemic situation. My hope is that through arming people with accurate information, they will recognize the seriousness of the pandemic and cooperate with efforts to reduce and stop the spread. Unfortunately, too many people have bought into misinformation and are therefore behaving in ways that will keep the virus spreading.

I want the virus gone.

I want life to go back to normal.

Every person who does not take the pandemic seriously delays our return to a normal life.