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

quote:

---

while the deaths are exactly that number.

---

Not really, though. The "deaths" is "deaths with Wuhan", not "deaths from Wuhan", which is, by definition, going to be a smaller number.

I am on vacation until Sunday. Today the COVID Tracking Project changed their data file format and as a result the import process I created to update the tracker must be rewritten. I won't be able to do that until probably Monday 6/15. Until that time, I will update the Older US Tracker based on the WoM numbers. I will not be updating anything else other than the US tab, no other countries, states, etc...I'm on Vacation.

Link to the old tracker: Chromdome's Original COVID Tracker

Poncho...I have no idea what that means, would you care to elaborate?

Unfortunately Florida up to 2,581 positive cases and 44 deaths. 7.3% positive.

I am on vacation until Sunday. Today the COVID Tracking Project changed their data file format and as a result the import process I created to update the tracker must be rewritten. I won't be able to do that until probably Monday 6/15. Until that time, I will update the Older US Tracker based on the WoM numbers. I will not be updating anything else other than the US tab, no other countries, states, etc...I'm on Vacation.

Link to the old tracker: Chromdome's Original COVID Tracker

Why do the case numbers have that “wave cycle” to them? I understand the low numbers in Sundays, by why do they decrease all through the week? Seems like these numbers are too highly tied to the rate of testing.

We'll be home about 8pm tonight. Looking forward to fixing the new tracker. I'm also going to look at standing up a state/county level tracker. We'll see.

The new tracker is repaired and up and running again.

This is the link to the New COVID-19 tracker that I have shared on Google Drive.
If you want to view the shared sheet, follow this link New COVID-19 Tracker
If you want to download a copy of this sheet and manipulate it follow this link Downloadable New COVID-19 Tracker
The source for the data is from https://covidtracking.com/data/

NOTE: Be sure to view the READ ME page on the new tracker

Links to the old Tracker
Chromdome's Old COVID Tracker

Old Tracker


New Tracker

Thanks for 233 pages of non political information. GF that reads news and listens is all worried and telling me about the dangerous spiking ...

One of your tables shows more tests and less positives...hmmmmm

Well, thanks again.

I looked at doing a state/county level tracker. There are currently 236,000 rows of data (3000+ Counties X 80ish days). Google sheets can't handle that volume of data and not slow to a crawl.

If this was all done in Excel with Access as the backend, I could pull it off fairly easily; however, that doesn't really help with an online google sheets based system.

Google has some database software called BigQuery but I haven't ever used it and I think you have to pay per GB of data, which eliminates that as an option.

For now, no county-level data until I can figure something out.