Started By
Message

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

Posted on 3/23/20 at 9:43 am to
Posted by Ace Midnight
Between sanity and madness
Member since Dec 2006
96134 posts
Posted on 3/23/20 at 9:43 am to
quote:

the size of the spreadsheet is getting so large that when I take the screen shots and then link them in here, the size is getting pretty small to read.


I don't want to speak for everyone, but most folks are focused on total active cases, new cases, deaths and new deaths.

If I were you, I would keep expanding the charts and graphs any way you see fit and allow folks who want to drill down more access it through a link to your Google Docs. That's a little more work, but once you figure out the links, you can do that a heck of a lot faster than making a bunch of specialty graphs.

Then, folks who want to highlight various bits can do that - you would be crowd sourcing the presentation that way. And the thread would still be based on a common operating picture - your hard work at the data collection/input level.

(And to keep it from adding a lot of inline posts, once you get a base package of Google Docs - just keep updating the link in the OP, as another efficiency method).

This post was edited on 3/23/20 at 9:44 am
Posted by DMAN1968
Member since Apr 2019
13518 posts
Posted on 3/23/20 at 9:48 am to
quote:

I could use some feedback from you guys

I can't help with the presentation but my feedback is that this information is awesome!

I haven't said it yet but thank you. I know this must be time consuming but it is greatly appreciated.
Posted by tiger91
In my own little world
Member since Nov 2005
40251 posts
Posted on 3/23/20 at 9:55 am to
Dude me too. Hope you’re well. Seriously that was super great work back then. I literally hand write a list of what you said needed to happen and as they did I scratched them off and met myself get excited. You’re a hero to me
Posted by LSURussian
Member since Feb 2005
135363 posts
Posted on 3/23/20 at 10:35 am to
WorldOMeter just updated their numbers.

The U.S. mortality rate continues to fall, now down to 1.19%.
Posted by Ace Midnight
Between sanity and madness
Member since Dec 2006
96134 posts
Posted on 3/23/20 at 10:52 am to
quote:

The U.S. mortality rate continues to fall, now down to 1.19%.


And as a continued reminder for those new to following the crisis at this level of detail, CFR (and it had a headstart because of a single, poorly run nursing home in Washington State, that sole source is still a respectable percentage of current U.S. Wuhan flu deaths) IS NOT the "infection mortality rate". Over time, the two numbers converge a bit, but the "C" in "CFR" represents a documented case under medical supervision/treatment.

Understandably it cannot capture the significant numbers of purely asymptomatic or only mildly symptomatic (unless caught by monitoring of those with known exposure, health care providers, etc.) who do not seek treatment, or even those with more moderate symptoms that treat with self-care.

And, we probably still have many scores (although the number is probably dropping) of presumptive cases that have not been confirmed/denied by testing yet.

So, the actual fatality rate of all infections (IFR) will likely have to be estimated when this is all over and a reasonable number of asymptomatic/never treated folks get antibody testing down the line (could take years).

And when it is so estimated, it will be no more than a few tenths of a percentage. Yes, that means roughly equivalent to a really strong strain of seasonal flu.

Amazing how that comparison comes up again and again, isn't it?
This post was edited on 3/23/20 at 10:53 am
Posted by NYNolaguy1
Member since May 2011
21785 posts
Posted on 3/23/20 at 10:59 am to
quote:

And as a continued reminder for those new to following the crisis at this level of detail, CFR (and it had a headstart because of a single, poorly run nursing home in Washington State, that sole source is still a respectable percentage of current U.S. Wuhan flu deaths) IS NOT the "infection mortality rate". Over time, the two numbers converge a bit, but the "C" in "CFR" represents a documented case under medical supervision/treatment.

Understandably it cannot capture the significant numbers of purely asymptomatic or only mildly symptomatic (unless caught by monitoring of those with known exposure, health care providers, etc.) who do not seek treatment, or even those with more moderate symptoms that treat with self-care.

And, we probably still have many scores (although the number is probably dropping) of presumptive cases that have not been confirmed/denied by testing yet.

So, the actual fatality rate of all infections (IFR) will likely have to be estimated when this is all over and a reasonable number of asymptomatic/never treated folks get antibody testing down the line (could take years).

And when it is so estimated, it will be no more than a few tenths of a percentage. Yes, that means roughly equivalent to a really strong strain of seasonal flu.

Amazing how that comparison comes up again and again, isn't it?


Well said sir.
Posted by bogeypro
North Alabama
Member since Sep 2012
4052 posts
Posted on 3/23/20 at 11:05 am to
But they'll say its because we shut down the country... otherwise it would have been 25% cfr
Posted by NYNolaguy1
Member since May 2011
21785 posts
Posted on 3/23/20 at 11:20 am to
quote:

But they'll say its because we shut down the country... otherwise it would have been 25% cfr


Thats assuming theres been no effect due to the measures taken. Obviously there has been some effect, but thats a much harder number to calculate.
Posted by Chromdome35
Fast lane, behind a slow driver
Member since Nov 2010
8289 posts
Posted on 3/23/20 at 11:34 am to
Guys, bear with me while I figure out the best way to link this google sheet in.

https://docs.google.com/spreadsheets/d/17R0Z5T063iqskP--0VXYtbnJqtkhU8RJ-5jL5_V1OZM/edit?usp=sharing
This post was edited on 3/23/20 at 11:45 am
Posted by Ace Midnight
Between sanity and madness
Member since Dec 2006
96134 posts
Posted on 3/23/20 at 11:39 am to
I can't see it, but it looks like you tried to paste an image.

You want to go into Google Docs itself and get a link from that file and then paste it as a link, not an image.

Image is for your graphs and that's fine, but the actual data is better as a link, IMHO.

I would protect that file from changes other than yourself, though. You don't want thousands of yahoos accidentally altering your data.
Posted by nerd guy
Grapevine
Member since Dec 2008
13838 posts
Posted on 3/23/20 at 11:43 am to
Huh. That image worked for me a minute ago. Now shows up as a link.
Posted by Ace Midnight
Between sanity and madness
Member since Dec 2006
96134 posts
Posted on 3/23/20 at 12:13 pm to
He's experimenting with links to Google Docs - so if folks want to drill down or pull out different data sets, they can do that and Chrome doesn't have to feel like he needs to format it 100 different ways.

We're just testing the process here, baw.
Posted by Ace Midnight
Between sanity and madness
Member since Dec 2006
96134 posts
Posted on 3/23/20 at 12:14 pm to
Yeah, that looks like that works. I can look at the whole thing and I can't make any changes that I can tell.
Posted by Freight Joker
Member since Aug 2019
4121 posts
Posted on 3/23/20 at 12:16 pm to
Italy reports 602 deaths yesterday. A decrease in death count two days in a row!
Posted by NYNolaguy1
Member since May 2011
21785 posts
Posted on 3/23/20 at 12:19 pm to
Looking at their trend that's not surprising. They look to be on the backside of the curve at the moment.
Posted by Chromdome35
Fast lane, behind a slow driver
Member since Nov 2010
8289 posts
Posted on 3/23/20 at 12:23 pm to
Thanks, I've created a whole new tracking doc that is the link posted. I needed to clean up my old file, decided it was just easier to create a new one.

I can create any graph and add it if anyone has a request.
Posted by nerd guy
Grapevine
Member since Dec 2008
13838 posts
Posted on 3/23/20 at 12:23 pm to
quote:

Looking at their trend that's not surprising. They look to be on the backside of the curve at the moment.



Unreal how it ran over their country. Hopefully they are on the backside of it for good.
Posted by NYNolaguy1
Member since May 2011
21785 posts
Posted on 3/23/20 at 12:25 pm to
Thanks. My only word of advice is to try and figure out a way of posting it while making sure you aren't doxxing yourself.

Google sheets has a function where you can see others who have viewed the document you made.
Posted by mmcgrath
Indianapolis
Member since Feb 2010
37391 posts
Posted on 3/23/20 at 12:26 pm to
Looks like Mexico is starting to experience a lot of spread. That could be bad for the US as well if they overrun their healthcare system.
Posted by Chromdome35
Fast lane, behind a slow driver
Member since Nov 2010
8289 posts
Posted on 3/23/20 at 12:27 pm to
Can you see anything reveling? I am not an expert at this?
Jump to page
Page First 53 54 55 56 57 ... 331
Jump to page
first pageprev pagePage 55 of 331Next pagelast page

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram