re: Daily COVID Updated as of 11/2/20 8:00 PM

This is the link to the US state level tracker that I have shared via Google Drive. Chromdome's State Level COVID-19 Daily Tracker
This is the link to the COVID-19 Country tracker that I have shared on Google Drive. Chromdome's COVID-19 Daily Tracker

On the state level tracker the states I have available right now are listed below. I will be adding additional states in the coming days.
Arkansas, Louisiana, New York, Georgia, Florida, California

The source for the data is https://www.worldometers.info/coronavirus/
The source for the testing data is from https://covidtracking.com/data/

On the tracker sheet you will see tabs for the following data:
1) US Summary
2) Country Comparables: This shows you how the US stacks up vs. select other countries dealing with COVID-19
3) Logarithmic Comparisons - Shows the US vs the other countries on the tracker.
4) Covid Vs Other Outbreaks - Compares the current COVID numbers to the last 10 years of flue and H1N1
5) US Weighted Averages - Explores 7 day vs 3 day weight average trends
6) Italy Summary
7) UK Summary
8) France Summary
9) Germany Summary
10) Sweden Summary
11) World Summary

NOTE: The daily growth rate data will not be accurate until the end of the day's postings. It will change throughout the day.
NOTE: I am not tracking individual states, I don't have a reliable consistent source for that data.
NOTE: I am not a mathematician, statistics guru, scientist, sharpest tack in the box, I'm just a guy who likes to understand for myself what is happening and to share it with others. This thread was not created to debate if you should or shouldn't take this seriously, it is simply to present the numbers and foster conversation.

NOTE: I have added a prediction number to the bottom of the data grid. This simply takes the previous days numbers and grows them at the previous day's growth rate. It should give the viewer some idea of what the numbers will look like today. Obviously, the final number for the day will be higher or lower based on what today's growth rate actualy is. This is just a simple indicator.

Another strong drop in Spain. Fewest deaths since 3/21, fewest new cases since 3/17.

I could be wrong on this, but I think their official numbers come out in the early evening each day. So around lunchtime on the east coast of the US.

I just refreshed it and it went from 100 to almost 900 for the US

New York reported a fairy hefty jump in deaths today

But remember, Tuesday is often the day when the weekend backlog is reported

If the hospitals aren't projected to be unable to provide caee for the projected patients, then none of these stats should weigh on the decision to reopen things.

Chrome,

Your U.S. mortality rate in the country comparison bar charts show ~ 2.5% instead of > 4%.

Thanks for the catch Nawlens!

When I added the 7 day rolling average new cases column, I forgot to update the hard reference to the mortality cell, it was mistakenly pointing at the serious case %.

quote:

---

Things are still tight in several regions. In NJ 56% of all ventilators are in use right now. Considering that every major hospital should have a few free and there should be at least one free at every critical care center, that doesn't leave a lot.

---

Lol. That’s about the normal percentage of vents in use.

I hope one of the takeaways after this is all over is the need for a much tighter reporting protocol.

We have been hamstrung throughout this event by the lack of solid information. Even the numbers being generated now are still not consistently reliable, ie the weekend hangover or the reclassification of death numbers.