Daily Charts

609,325 Views | 2786 Replies | Last: 2 yr ago by AggieUSMC
Philip J Fry
How long do you want to ignore this user?
AG




Something like this?
Agsncws
How long do you want to ignore this user?
AG
This is a very, very good thread. Thank you gentlemen and ladies for your information and explanations
MBAR
How long do you want to ignore this user?
AG
Philip J Fry said:

I show the infected thread, but the one I care about really is the death curve. I think it tells us more about the true situation we're in. I cannot imagine what NY is about to go throw in the next weeks off this holds. It's got to start bending soon.
Hospitalization data is a better short term proxy but we're not getting enough of this data. Death's are very informative as well but the main issue with that data is the extreme lag time of up to a month. Deaths today tell you about the infection status several weeks to a month in the past.
BlackGoldAg2011
How long do you want to ignore this user?
AG
BlackGoldAg2011 said:

Here is a graph i have been keeping, to track the changing CFR for each country above 5k cases. i'll update this post as i update my graphs. Data from https://www.worldometers.info/coronavirus/








Data updated 0 GMT 3/27/2020

my interesting observations:
3/19/2020:
  • China and S. Korea are the only two that have exited exponential growth so should be settling in on their final numbers. looks like 4% for china and 1%-1.5% for S. Korea (who still has 76% of its cases as active)
  • The US is the only country in exponential growth with a declining CFR (since it was asked, CFR is Case Fatality rate, or simply the number of deaths divided by the number of cases). This could possibly be in part due to the fact that our early data skewed high due to the first tracked outbreak being in a nursing home. It looks like our final number and S. Korea's might meet.
  • Germany's number is a confusing anomaly. They are about 1 day ahead of us on the daily total case curve. Have almost no deaths. One possible explanation is that maybe their outbreak started in younger communities. I'm very interested to watch their number as they only really started having deaths a few days ago (3/15/2020)
3/23/2020:
  • Two more countries have joined the 5k+ but i haven't added them yet (UK and Switzerland). I'll add them once they pass S. Korea.
  • I added a CFR plot based on days past the 100th case to get a better look at how the countries compare to each other, not just where they are today. From that it looks like about 3 basic groupings with the upper tier (Italy, Iran, and Spain) looking like things are going to be really rough for them over the coming month. i think i read that for those cases ending in death, the average time to death after exposure was 17.5 days
  • With S. Korea down to only 66% active cases, I'm feeling pretty good about my original prediction
  • USA has zero separation between the active and total cases line but the CFR curve seems to be bottoming out. This would lead me to believe that we should expect our CFR to start climbing again sometime over the next week. Based on our volume of cases and looking at the shape of S. Korea's curve, i'm going to predict we settle in the 2%-2.25% range but that is a very loose guess at this point with a lot of variables still shaking out
  • Finally I added a new plot showing total cases vs days since the 100th case on a semi-log plot. I did this because adding new data this morning it seemed like a lot of countries had begun to see a drop in new cases. This plot confirms that. We will see if it holds true this week or was just a data lag due to the weekend, but with the exception of one, every country on my list has fallen off exponential growth. (for those unfamiliar, on a semi-log plot, exponential growth is a straight line)
  • Which brings me to my final observation of the morning. The USA. Based on the latest data update, we are still solidly exponential at a rate of 10x increase every 8 days. This is with widespread testing only just now rolling out, so i wouldn't expect to start see effects from that for another day or two. At this rate we will have surpassed China (their reported numbers at least) by my Thursday update, and broken 100k by Friday. I realize there are a lot of factors here, but this trend cause me to really hope our efforts as a country towards the end of this last week prove to be enough to start bending our curve down soon.
3/24/2020:
  • Switzerland passed S. Korea so got added to my list
  • Italy is seeing some real separation between their total and active cases curves so I added a detailed look for them. Hopefully this means their CFR will stop going up shortly and maybe even come back down a bit over the next few weeks
  • USA is starting to show a bit of separation between total and active curves, and consequently, with yesterday's data saw an increase in CFR for the first time 3/3/20
3/25/2020:
  • Unfortunately it looks like S. Korea's CFR rise has been accelerating a bit over the last few days. Not a good trend
  • Looks like USA's CFR has indeed started to bend back upwards.
3/27/2020:
  • UK passed S. Korea so they got added to the list
  • Had to adjust the CFR scale for Italy, really hope they bend that down very soon...
  • Also corrected two "mistakes" on the normalized time graph. I was off one day on where i started S.Korea (started them at 200 cases instead of 100). China was starting at 500 cases due to when data tracking began, so i estimated where there 100th case day should have been and shifted them forward to start on day 4 which lines them up with the fastest growing other country to 500 cases. This may have some inaccuracies but should be the fairest comparison (all might be garbage anyways depending on your view of the data out of china.)
  • Added a stand alone USA graph showing the exponential growth curve for the whole time as well as what it is over the last 7 days to show how our growth is or isn't changing.

updated and added a new plot
BlackGoldAg2011
How long do you want to ignore this user?
AG
One new one to add is total deaths normalized to the days since the 10th death


i'll add it to my first page plots too, but the thing i notice here is basically every country, when they start to bend over move from and exponential curve to a power law curve. I showed italy's curve and R^2 to show how well they fit that shape. Over the last 5 days, our data looks like it might be bending over. the most significant thing i see here, is even if you do take the power law curve for the last 5 days and extend it out assuming we have enter the power law growth phase in our death count, in 12 days we pass the total 2018-2019 USA flu death count. if we haven't bent over and are still in exponential growth, 13 days from now COVID will be at 56k deaths in the US, which using 2017 data, would put it as the number 8 cause of death in the US this year.
HotardAg07
How long do you want to ignore this user?
AG
This guy does a much higher quality one.


These are others he makes:


BlackGoldAg2011
How long do you want to ignore this user?
AG
His are quite nice, and he gets a lot of data in there without being too cluttered. i realize this is just splitting hairs but it's always been a pet peeve of mine though when log scales get labeled like this (1,2,5,10 etc) because it causes the scale to visually look very close to a linear scale at first glance.
PJYoung
How long do you want to ignore this user?
AG




proudaggie02
How long do you want to ignore this user?
AG
I was following everything closely for a while, but I have not kept up the last few days. Has anyone added a "US less NY State" metric to the graphs?

I looked at daily new cases and daily new cases per 1,000,000 for USA, USA less NY State, NY State, and Italy. It helped put things in perspective for me, and I'm wondering if others are charting the USA outside of the major hotspot? It looks like NY and NJ have accounted for 55%+ of the USA cases for several days.
PJYoung
How long do you want to ignore this user?
AG
proudaggie02 said:

I was following everything closely for a while, but I have not kept up the last few days. Has anyone added a "US less NY State" metric to the graphs?

I looked at daily new cases and daily new cases per 1,000,000 for USA, USA less NY State, NY State, and Italy. It helped put things in perspective for me, and I'm wondering if others are charting the USA outside of the major hotspot? It looks like NY and NJ have accounted for 55%+ of the USA cases for several days.

I just today started to look at that with yesterday's stats.

The danger in looking at all 50 states as one group is that your mind can't help but assume testing in all 50 is the same and we all know that's not close to true. In general, your reported infections will be a function of your testing.

So this is yesterday's % increase, total infections, yesterday's increase, total deaths and yesterday's deaths.




https://www.worldometers.info/coronavirus/country/us/

PJYoung
How long do you want to ignore this user?
AG
Post removed:
by user
RangerRick9211
How long do you want to ignore this user?
AG
Interesting way to visualize when a country bails off exponential growth: https://aatishb.com/covidtrends/.
PJYoung
How long do you want to ignore this user?
AG
RangerRick9211 said:

Interesting way to visualize when a country bails off exponential growth: https://aatishb.com/covidtrends/.
lol Japan suddenly back on the exponential growth train now that the Olympics have been postponed.
HotardAg07
How long do you want to ignore this user?
AG
PJYoung said:

RangerRick9211 said:

Interesting way to visualize when a country bails off exponential growth: https://aatishb.com/covidtrends/.
lol Japan suddenly back on the exponential growth train now that the Olympics have been postponed.
Probably has more to do with the fact that schools have reopened after being closed for a month and many businesses relaxed their WFH requirements.
Philip J Fry
How long do you want to ignore this user?
AG
Infection data:


Deaths


Hospitalization Data



Positive/Negative/Pending Tests

PJYoung
How long do you want to ignore this user?
AG

PJYoung
How long do you want to ignore this user?
AG
94chem
How long do you want to ignore this user?
NY confirmed 0.24% infected. Implies that ~10% of people statewide have it if we use a 40x assumption.
PJYoung
How long do you want to ignore this user?
AG
PJYoung
How long do you want to ignore this user?
AG
You could say Italy has a 10 day peak and still going. Not great news for New York.
AvidAggie
How long do you want to ignore this user?
AG
Would really like to see the Italy numbers start to go down
KidDoc
How long do you want to ignore this user?
AG
PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
No material on this site is intended to be a substitute for professional medical advice, diagnosis or treatment. See full Medical Disclaimer.
94chem
How long do you want to ignore this user?
Italy issued a formal shelter in place on March 9. If we assume that the system behaves like a steady state chemical reactor, it takes 3 residence times for the system to reach equilibrium, specifically the new steady state. In this case, the change to the system is the lock down, the residence time is the incubation period, and the new steady state is the 0% growth in new daily cases ( to be followed by a decrease eventually). The Italian data implies about a 12 day period to reach equilibrium, meaning about a 4 day incubation period. These numbers are roughly in line with what we've been hearing, and mean that the lockdowns must be about 2 weeks long just to see what the 0% growth number is.
94chem
How long do you want to ignore this user?
AvidAggie said:

Would really like to see the Italy numbers start to go down


Yes, but you have to see what 0 looks like before you can see negative. I would guess we will see that in about 3 - 5 days.
Old RV Ag
How long do you want to ignore this user?
AG
KidDoc said:

PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
Infection rates have stabilized but not yet decreasing. Deaths are still increasing - especially in last two days. I'd not give that a thumbs up just yet. Here's hoping to see falling numbers.
KidDoc
How long do you want to ignore this user?
AG
Old RV Ag said:

KidDoc said:

PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
Infection rates have stabilized but not yet decreasing. Deaths are still increasing - especially in last two days. I'd not give that a thumbs up just yet. Here's hoping to see falling numbers.
The drop off exponential increase in infection rates IS a victory. A small one but a victory. The death rates will follow a stabilization or lowering of death rates. It is good news just not great news.
No material on this site is intended to be a substitute for professional medical advice, diagnosis or treatment. See full Medical Disclaimer.
PJYoung
How long do you want to ignore this user?
AG
KidDoc said:

Old RV Ag said:

KidDoc said:

PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
Infection rates have stabilized but not yet decreasing. Deaths are still increasing - especially in last two days. I'd not give that a thumbs up just yet. Here's hoping to see falling numbers.
The drop off exponential increase in infection rates IS a victory. A small one but a victory. The death rates will follow a stabilization or lowering of death rates. It is good news just not great news.


Exactly. It makes me wonder what things wouldve been like if they hadn't shut things down.
Mordred
How long do you want to ignore this user?
AG
Old RV Ag said:

KidDoc said:

PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
Infection rates have stabilized but not yet decreasing. Deaths are still increasing - especially in last two days. I'd not give that a thumbs up just yet. Here's hoping to see falling numbers.
Deaths are a lagging indicator. Those people who died today got sick 10-21 days ago... back when new cases were rising exponentially.
Old RV Ag
How long do you want to ignore this user?
AG
Mordred said:

Old RV Ag said:

KidDoc said:

PJYoung said:

You could say Italy has a 10 day peak and still going. Not great news for New York.
You could also say that Italy has flattened the rise in daily cases and has therefore flattened their attack rate finally.
Infection rates have stabilized but not yet decreasing. Deaths are still increasing - especially in last two days. I'd not give that a thumbs up just yet. Here's hoping to see falling numbers.
Deaths are a lagging indicator. Those people who died today got sick 10-21 days ago... back when new cases were rising exponentially.
Yes, I understand that. But, accordingly, then death rates will continue still to increase. And until the infection rates actually decrease then death rates will increase and at best stabilize. Infection rates stabilization is good to see but until actual decrease is seen the system will continue to be overloaded more as patients don't roll out at the same rate they are rolling in due to the long incubation and recovery time. And until decrease is seen, it can always have been a pause before the next surge. Again, here's hoping to see falling numbers.
Irwin M. Fletcher
How long do you want to ignore this user?
AG
Very interesting chart on projected deaths and cases moving forward both nationally and each state. If social distancing remains in place looks like it could peak mid April and start to fall after.

projections
Philip J Fry
How long do you want to ignore this user?
AG
Infection data:


Deaths


Hospitalization Data
No updates today.


Positive/Negative/Pending Tests





Aust Ag
How long do you want to ignore this user?
AG
HotardAg07
How long do you want to ignore this user?
AG
The testing graph seems broken. Shows cumulative negative cases going away.
Philip J Fry
How long do you want to ignore this user?
AG
I believe the latest update is correct.

~500K negative
~100k. positive.
~60K pending

As of a couple days ago.
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.