CV19 Pandemic Update!

US has stepped up testing rapidly, and so while social distancing is at -40%, we still show +1% of the new model prediction.

03-26 Thursday
1-day Projection: WW 524523/24175; PRC 81731/3289; NON 442792/20886; IT 79988/8254; US 80513/1257; TX 1582/19 non+IT 1.2%, US 5.1%
1-Day Distancing: WW 524523/24175; PRC 81731/3289; NON 442792/20886; IT 79988/8254; US 82170/1244; TX 1632/20 TX 5% high, US 2% low
Actual Numbers: WW 529591/23970; PRC 81782/3291; NON 447809/20679; IT 80589/8215; US 83836/1209; TX 1563/21

The rapid rise in US testing (127% per day average) may numerically counter the decrease in disease spread from social distancing (-40%). I hope that is factored into the policy plans, because it may look a lot more spooky over the next week than it really is.

03-27 Friday
1-Day Projection: WW 601509/27192; PRC 81903/3297; NON 519605/23895; IT 87309/8995; US 106851/1552; TX 1988/29
1-Day Distancing: WW 601509/27192; PRC 81903/3297; NON 519605/23895; IT 87309/8995; US 103554/1554; TX 1971/27
1=Day US Prototype: Positive: 89,618 Negative: 486,863 Pending: 66,880 Hospitalized: 13,923 Dead: 1,471

I added the Number of Tests and number hospitalized in the US to the spreadsheet. This is somewhat complete for the US and TX, but other countries are hit or miss. Those checkpoint earlier in the day than other stats, but that is fine. Those are much better numbers to track hospital overload than trying to extrapolate from confirmed cases, but much less data. I am still tweaking it all.

Midday Thursday, the US had 10131 hospitalized, and 1163 dead from COVID-19. The rates of increase of these are still climbing at the typical 135% per day. There is not yet a clear correlation between social distancing and death or hospitalization rates, but I am still testing ideas.

Since I only have that for the whole US, I am still tracking confirmed, death, and projecting with social distancing in the main sheet.

2020-04-01 7-day Comparison
7-Day Projection: WW 1169645/61852; PRC 82134/3338; NON 1087512/58514; IT 157313/19560; US 477863/6398; TX 9131/162
7-Day Distancing: WW 1169645/61852; PRC 82134/3338; NON 1087512/58514; IT 157313/19560; US 232880/4603; TX 5875/72
7-Day US Prototype: Positive: 134,035 Negative: 728,160 Pending: 100,028 Hospitalized: 68,262 Dead: 4,770 Overrun: 04-06 295-335k

The old formula pushes Texas overrun slightly further out for late-stage events:

04-06 29k TEXAS ICU OVERRUN STAGE 1
04-07 36k TEXAS VENT OVERRUN STAGE 1
04-12 146k TEXAS ICU STG3
04-13 178k TEXAS VENT STG3 & Hosp STG1
04-16 400k may be the inflection point for Texas if 14% like China, but our death rate is lower than theirs or the world.
04-17 532k TEXAS HOSP STG3
04-20 1.2m Inflection point for R0 of 2.2 is 60% with detection rate of 39.08

The new distancing prototype formula looks like this after tweaking:

04-15 2929 TEXAS ICU OVERRUN STAGE 1
04-17 1787 TEXAS VENT OVERRUN STAGE 1
05-02 2929 TEXAS ICU OVERRUN STAGE 3
05-03 1787 TEXAS VENT OVERRUN STAGE 2
05-04 26633 TEXAS HOSPITAL OVERRUN STAGE 1
05-09 4550 TEXAS VENT OVERRUN STAGE 3
05-09 400k may be the inflection point for Texas if 14% like China, but our death rate is lower than theirs or the world.
05-16 26633 TEXAS HOSPITAL OVERRUN STAGE 2
06-05 47441 TEXAS HOSPITAL OVERRUN STAGE 3
05-21 1.2m Inflection point for R0 of 2.2 is 60% with detection rate of 39.08

The growth in hospitalizations puts overrun at 04-06. I do not know what to believe.

Here are the milestones from 04-23 data for comparison to track our progress flattening the curve:

04-06 33k TEXAS ICU OVERRUN STAGE 1
04-07 45k TEXAS VENT OVERRUN STAGE 1
04-10 150k TEXAS VENT/ICU STG2 & Hosp STG 1
04-13 366k TEXAS VENT/ICU STG3 & Hosp STG 2
04-15 660k TEXAS Hosp STG 3

Milestones are based on guesstimates: TX 28.7m pop; 2.9 beds per 1000 in TX (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787); 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)

Testing has ramped up substantially, and the US has a capacity around 350k tests per week, or 50k per day. The increased testing, and the shift in social distancing makes these numbers more fuzzy. I tweaked my multipliers for regression testing.

Our hospital load may be 31.86% of the world average for the same number of confirmed. Korea had 8652 confirmed from 316664 tests on 03-20 with 94 deaths. Their death rate is 1.42%. Ours is 1.44% with 579k tests, 83836 confirmed, 1209 deaths. The world rate is 4.52% I suppose that the death to confirmed case is tied to the test percentage.

Inflection point for R0 of 2.2 is 60% of the population, times the percentage of infected people who get confirmed. It was estimated elsewhere that China at 4.02% mortality rate per confirmed was 14% tested. That means our hospital load will be 35.82% for the same number of confirmed, or that our confirmed cases are 39.08% of our total cases.

TX has 28.7 million, and 39.08% of that is 1.12 million as our inflection point.

Unknown accuracy because testing inputs are changing, and I am just making things up.

Social distancing data lags by 3 days. Statistics lag by 1 day. Detection lags by 9-12 days. Impact delay of SD on Confirmations is 9 days.

https://drive.google.com/file/d/1vocCN445AZyVBBLsv0kJR8ZDP9DM0UST/view