Tag Archives: update

CV19 April 3

Posted by xaminmo

CV19 Pandemic Update for 2020-04-03

I did not make screenshots of my favorite graphs, but check out http://91-divoc.com/pages/covid-visualization/ and play with log vs normal, and etc on the interactive graphs.  Deaths and confirmations log chart is very visibly bending in the right direction. We still have a ways to go.

Executive Summary:

  • Worldwide, 1,095,917 confirmed cases and 58,787 deaths, which is within 1% of the 1-day estimate.
  • US is 275k infected, and 7382 dead, which is also within 1% of 1-day estimates.
  • China probably has ~400k unconfirmed cases, and ~16,500 unconfirmed deaths.
  • We need our confirmed and death exponents to fall to as close to 100% as possible. (vs 113% & 119% respectively).
  • US & TX confirmed exponents are stalled in the 113% range. The death date exponent has not yet fallen, averaging over 120%.
  • US deaths per confirmed case continues to increase, and will do so until as far as 47 days after the last new infection.
  • Many places in the US extended their stay-at-home plans to May 20.

1-Day Estimate for April 3
Non-China 1,018,824/56,704; Italy 120,107;14,719; USA 277,775/7,382; TX 5,900/90; ME 411/8
SD Adjusted USA 287,625/7,557; Texas 6,139/100

Actual April 3
Non-China 1,013,406/55,461; Italy 119,827/14,681; USA 275,586/7,087; TX 5,734/100; ME 432/9

1-Day Estimate for April 4
Non-China 1,103,432/61,938; Italy 124,594/15,489; USA 311,960/8,475; TX 6,486/130; ME 496/9
SD Adjusted USA 318,885/9,052; Texas 6,853/129

7-day Estimate for April 8
non-China 1,917,505/109,549; Italy 169,991/23,851; USA 745,176/25,239; Texas 15,874/306; Maine 656/26
SD Adjusted USA 707,819/21,874; Texas 14,357/317
This is falling due to our curve getting flatter. US 500k, TX 11.2k

Commentary:

Day to Day deaths are still climbing nationally. No consistent major slowing there. CA and NY/NJ/MA areas have a lot going on. It may take some time for them to dig out of this.

After lockdown, confirmed cases take 9-12 days to be affected, and deaths another 8-11 days after that. Anywhere that is overloaded will have a higher death rate, which may offset this prediction

As expected with the slow-down in spread, our mortality rate keeps climbing. 1.44%, 1.55%, 1.67%, 1.75%, 1.84%, 2.06%, 2.23%, 2.43%, 2.57%.

Inflection point for outbreaks with an R0 of 2.2 is 60% of the population becoming immune. Divide that by whatever you think our detection rate is. I think we get about 38%, so maybe 75m people in the US showing as confirmed. In other words, we are clamping down on the spread. It is not slowing due to going through the bulk of the population. If we all started mingling again tomorrow, we would see a big surge in cases 2 weeks later.

Average is 6 days to onset and 14 days from onset to death for those who do not survive. Social distancing data lags by 3-5 days. Statistics lag by 1 day. Detection lags by 9-12 days. Impact delay of social distancing on confirmations MAY BE 9 days. The correlation is fuzzy, but may be around 9 days lag.

Research for improving mortality rates could put things back to normal, but we are not there yt. Even if it is solved now, logistics of getting it deployed are not instantaneous.

Spreadsheet is updated, and downloadable here:
https://drive.google.com/file/d/1vocCN445AZyVBBLsv0kJR8ZDP9DM0UST/view

My favorite charts:
http://91-divoc.com/pages/covid-visualization/
https://www.unacast.com/covid19/social-distancing-scoreboard

Additional Data Sources:
https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data
https://github.com/COVID19Tracking/covid-tracking-data/tree/master/data
https://ourworldindata.org/covid-testing

China Underreporting Claims:
I do not think this is willful deception, so much as, they are only reporting what they can confirm. It just happens that they can confirm only a small subset of the infections prior to March.

China cremation rates, I lost the URL for the older data, but current data is here:
http://mzj.wuhan.gov.cn/tjxx/387166.jhtml
2019    Number of cremated remains    JZH014221000    56,007
It varies by about 2500 per quarter, so roughly 5k per month in Wuhan province.

The number of urns and cremations are very high, and “the funeral homes are unable to keep up.”
https://www.bloomberg.com/news/articles/2020-03-27/stacks-of-urns-in-wuhan-prompt-new-questions-of-virus-s-toll
https://english.alarabiya.net/en/features/2020/03/31/Delivery-of-5-000-urns-undermines-China-s-coronavirus-official-death-toll-Report
http://www.asianews.it/news-en/Wuhan,-endless-queues-for-ashes-of-coronavirus-dead-cast-doubts-on-numbers-49673.html

There are multiple sources indicating people who were not checked into a hospital were not counted.
Journalistic sources include
https://www.rfa.org/english/news/china/cremate-02142020105822.html
https://www.scmp.com/news/china/society/article/3050311/its-pneumonia-everybody-china-knows-about-many-deaths-will-never
https://www.who.int/bulletin/volumes/84/3/news30306/en/

I did not save teh ones from February where the WHO felt they were underestimating because they had no way to count those otuside of the hospitals. They said 4-8 times higher rates were likely.

This exclusion has been common in other countries, including Italy, Iran, etc:
https://www.wsj.com/articles/italys-coronavirus-death-toll-is-far-higher-than-reported-11585767179
https://www.space.com/iran-coronavirus-graves-satellite-images.html


CV19 April First

Posted by xaminmo

CV19 Pandemic Update for 2020-04-01

Executive Summary:
* Worldwide, 850,244 confirmed cases and 43,493 deaths, which is 22% lower than predicted 7 days ago.
* China probably has ~400k unconfirmed cases, and ~16,500 unconfirmed deaths.
* US is 213k infected, and 4757 dead, matching the social-distancing estimates, and 55% under un-adjusted 7-day predictions.
* US confirmed exponent continues to fall, but death exponent has not yet fallen. Maybe by Monday if NY & WA not too overloaded.
* US deaths per confirmed case continues to increase, and will do so until as far as 47 days after the last new infection.
* Many places in the US extended their stay-at-home plans to May 4.

Numbers for 03-31 1-day projection was within 1% as usual, but on the low side like the last 5 days. Except Italy.
1-Day Projection: NON-China 768,398/38,363; IT 105,957/12,464; US 185,835/3,595; TX 3,547/55; ME 299/5
Actual Numbers: NON-China 775,208/38,798; IT 105,792/12,428; US 188,172/3,873; TX 3,809/54; ME 303/5

Numbers for 04-01 7-day projection on the distancing formula was within 10%, which is impressive.
7-Day Distancing: US 232,880/4,603; TX 5,875/72
4-day Distancing: US 237,600/4,513; TX 5,003/68
3-day Distancing: US 231,486/4,464; TX 4,761/68
2-day Distancing: US 227,620/4,475; TX 4,583/55
Actual Numbers: US 213,372/4,757; TX 4,355/66

Numbers for 04-01 7-day projection on the averaging formula are 55% low for the US, 32% low for Italy, and about 22% low for non-China. When things are as expected, it comes up within 25% for a 7-day projection. This means the US and Italy are improving, and the rest of the world as a whole is still doing poorly at containing it.
7-Day Projection: WW 1,169,645/61,852; PRC 82,134/3,338; NON 1,087,512/58,514; IT 157,313/19,560; US 477,863/6,398; TX 9,131/162
4-day Projection: WW 1,097,956/54,118; PRC 82,357/3,321; NON 1,015,599/50,796; IT 132,717/16,052; US 333,315/5,929; TX 7,263/90; ME 468/5
3-day Projection: WW 1,017,269/50,218; PRC 82,428/3,321; NON 934,841/46,897; IT 124,403/14,738; US 278,237/5,179; TX 5,427/83; ME 426/5
2-day Projection: WW 964,689/48,019; PRC 82,366/3,318; NON 882,322/44,702; IT 115,671/13,966; US 240,828/4,723; TX 4,543/69; ME 350/5
Actual Numbers: WW 932,605/46,809; PRC 82,361/3,316; NON 850,244/43,493; IT 110,574/13,155; US 213,372/4,757; TX 4,355/66; ME 303/5*
* PRC numbers are likely 1/6th of the actual due to creamatorium activity.
* Maine did not update on 4/01.

Hospitalizations were 7-day projected at 68,262, but came in at 31,142. The hospitalization chart estimated 4770 deaths and we had 4700.
7-Day US Testing: POS 134,035 NEG 728,160 PEND 100,028 HOSP 68,262 DEAD 4,770 Overrun: 04-06 335k
4-Day US Testing: POS 150,376 NEG 785,328 PEND 83,576 HOSP 64,012 DEAD 5,886 Overrun: 04-06 342k
3-Day US Testing: POS 164,152 NEG 817,199 PEND 77,376 HOSP 44,840 DEAD 4,592 Overrun: 04-09 408k
2-Day US Testing: POS 197,908 NEG 966,946 PEND 80,606 HOSP 36,789 DEAD 4,604 Overrun: 04-11 349k
ACTUAL April 1 : POS 210,770 NEG 939,190 PEND 59,687 HOSP 31,142 DEAD 4,700 Overrun: 04-14 336k

1-day Estimate for April 2
non-China 932,543/48,756; Italy 115,572/13,925; USA 241,947/5,843; Texas 4,979/81; Maine 303/5
Adjusted USA 258,180/5,970; Texas 5,400/84
Tweaked USA 256,985/5,982; Texas 5,331/83

7-day Estimate for April 8
non-China 1,917,505/109,549; Italy 169,991/23,851; USA 745,176/25,239; Texas 15,874/306; Maine 656/26
Adjusted USA 679,037/18,955; Texas 15,401/282
Tweaked USA 707,819/21,874; Texas 14,357/317

Day to Day deaths are still climbing at 126%/day. They should start falling short by Monday. After lockdown, confirmed cases take 12 days to be affected, and deaths another 10 days after that. Anywhere that is overloaded will have a higher death rate, which may offset this prediction

As expected with the slow-down in spread, our mortality rate keeps climbing. 1.44%, 1.55%, 1.67%, 1.75%, 1.84%, 2.06%, 2.23%.

Inflection point for outbreaks with an R0 of 2.2 is 60% of the population becoming immune. Divide that by whatever you think our detection rate is. I think we get about 38%, so maybe 75m people in the US showing as confirmed. In other words, we are clamping down on the spread. It is not slowing due to going through the bulk of the population. If we all started mingling again tomorrow, we would see a big surge in cases 2 weeks later.

Average is 6 days to onset and 14 days from onset to death for those who do not survive. Social distancing data lags by 3-5 days. Statistics lag by 1 day. Detection lags by 9-12 days. Impact delay of social distancing on confirmations MAY BE 9 days. The correlation is a little fuzzy, but using 9 days got the estimates within 10% over 7 days.

Some good research is going on that promises to improve mortality rates, but that will probably be more for the next batch of people. Even if it is solved now, logistics of getting it deployed are not instantaneous.

Spreadsheet is updated, and downloadable here:
https://drive.google.com/file/d/1vocCN445AZyVBBLsv0kJR8ZDP9DM0UST/view


CV19 Update Sun 03-29

Posted by xaminmo

CV19 Pandemic Update for 2020-03-29 (Sunday Night).

Most of the numebrs are slowing down vs projections. On 03-24, our growth rate dropped from 135% to 123%, and the last 2 days have been in the 1-teens. TX lags by a couple days in that regard. We are stubborn. There are reports in the worst hit places of reaching a tipping point, but mostly in the highest density areas.

1-Day Projection: WW 736981/34604; PRC 82101/3302; NON 654880/31302; IT 98859/10999; US 145164/2596; TX 3112/35; ME 265/1
1-Day Distancing: WW 736981/34604; PRC 82101/3302; NON 654880/31302; IT 98859/10999; US 144607/2494; TX 2934/37; ME 265/1
2020-03-29 WW 720117/33925; PRC 82122/3304; NON 637995/30621; IT 97689/10779; US 140886/2467; TX 2792/37; ME 253/3
Reminder: PRC numbers are likely 1/6th of the actual due to creamatorium activity.

Social distancing rates have not been updated in a few days, but we are tracking similarly between the two formulae.

Found another error, so the estimates for testing and hospitalization were too high. One of my cells had a $ in it, so it did not change as I added new data.

1-Day US Testing: POS 126,269 NEG 659,435 PEND 70,178 HOSP 23,397 DEAD 2,585
20200329 POS 139,061 NEG 692,290 PEND 65,549 HOSP 19,730 DEAD 2,428

Fewer hospitalized now means fewer dead in 2 weeks.

2020-03-30 (Monday) Projections
1-Day Projection: WW 785,602/37,588; PRC 82,245/3,309; NON 703,357/34,279; IT 103,200/11,592; US 163,395/3,004; TX 3,175/46; ME 303/3
1-Day Distancing: US 164,555/2,970; TX 3,269/44

+1 Day US Testing POS 157,461 NEG 783,890 PEND 74,222 HOSP 24,311 DEAD 2,932

We are definitely slowing down. Look at the April 1 projection trends.

2020-04-01 7-day Projection April 1
7-Day Projection: WW 1,169,645/61,852; PRC 82,134/3,338; NON 1,087,512/58,514; IT 157,313/19,560; US 477,863/6,398; TX 9,131/162
4-day Projection: WW 1,097,956/54,118; PRC 82,357/3,321; NON 1,015,599/50,796; IT 132,717/16,052; US 333,315/5,929; TX 7,263/90; ME 468/5
3-day Projection: WW 1,017,269/50,218; PRC 82,428/3,321; NON 934,841/46,897; IT 124,403/14,738; US 278,237/5,179; TX 5,427/83; ME 426/5

The distancing formula has been tracking more consistently over the longer term.
7-Day Distancing: US 232,880/4,603; TX 5,875/72
4-day Distancing: US 237,600/4,513; TX 5,003/68
3-day Distancing: US 231,486/4,464; TX 4,761/68

Hospitalization rates are going down, while positive and total testing rates are going up.
7-Day US Testing: POS 134,035 NEG 728,160 PEND 100,028 HOSP 68,262 DEAD 4,770 Overrun: 04-06 335k
4-Day US Testing: POS 150,376 NEG 785,328 PEND 83,576 HOSP 64,012 DEAD 5,886 Overrun: 04-06 342k
3-Day US Testing: POS 164,152 NEG 817,199 PEND 77,376 HOSP 44,840 DEAD 4,592 Overrun: 04-09 408k

I am just giving the general overrun rate above. That is typically within 1 day of when the TX projections look bad, and tracking kinda bad vs super bad is a lot of effort.

Testing rates slowed a little, but not much.

Our mortality rate keeps climbing. 144, 155, 167, 175. TX just started the climb, 122 yesterday, and 133 today. Probably the spring break people. Average is 6 days to onset and 14 days from onset to death for those who do not survive.

Some good research is going on that promises to improve mortality rates.

Inflection point for outbreaks with an R0 of 2.2 is 60% of the population becoming immune. Divide that by whatever you think our detection rate is. I think we get about 38%, so maybe 75m people in the US showing as confirmed.

Social distancing data lags by 3-5 days. Statistics lag by 1 day. Detection lags by 9-12 days. Impact delay of SD on Confirmations MAY BE 9 days, or it may be longer. The correlation is hard to suss out, but it may be that it will become more evident as we get more days of data.

Spreadsheet is updated, and downloadable here:
https://drive.google.com/file/d/1vocCN445AZyVBBLsv0kJR8ZDP9DM0UST/view


CV19 US Hospitalization Rates

Posted by xaminmo

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


Overrun Planning

Posted by xaminmo

Stats for Sunday, Monday, and predictions for Tuesday, and Texas hospital overruns.

03-22 Sunday

  • 7-day Projection: WW 262771/11285; PRC 81266/3324; NON 259371/14696; IT 78550/8986; US 25567/280; TX 521/21. plus or minus 25%.
  • 1-day Projection: WW 340729/14895; PRC 81360/3265; NON 260988/11728; IT 61049/5774; US 34015/386; TX 857/5.
  • Actual Numbers: WW 335955/14632; PRC 81397/3265; NON 254558/11367; IT 59138/5476; US 33272/417; TX 627/8

03-23 Monday

  • 1-day Projection: WW 370630/16503; PRC 81489/3271; NON 290297/13301; IT 65275/6215; US 43432/566; TX 627/13. TX Deaths is Still early and erratic
  • Actual Numbers: WW 378287/18600; PRC 81496/3274; NON 296791/13223; IT 63927/6077; US 43667/552; TX 758/9. IT is slowing, which is good. JHU new dataset.

03-24 Tuesday

  • 1-day Projection: WW 425,953/18,600; PRC 81,595/3,283; NON 346,031/15,382; IT 69,104/6,744; US 57,310/731; TX 916/10
  • Actual Numbers: To be determined.  Infection spread for US is fluctuating slightly.

The following major milestones assume no gross change in testing rates nor confirmed infection rates.  Stage 1 is over standard capacity.  Stage 2 is over worst case reserve capacity.  Stage 3 is over best case reserve capacity.  This does not cover additional production, but does cover identified lower-function and out-of-date equipment from federal, military, and major hospital stockpiles.  At Stage 1, alternative locations are getting converted for use by patients, such as closed medical buildings.  At stage 2, we’re relying on medical and nursing students as front-line caregivers, and MASH style pop-up tent hospital expansions start getting deployed where possible. At stage 3, we’re draping parking garages, and getting scouts with first-aid badges to help.  Elderly or anyone with comorbidities will be comforted, but won’t get access to mechanical ventilation.  Only those with the best chance of survival with, and a high risk of death without, would get advanced care.

  • 04-05 33k TEXAS ICU OVERRUN STAGE 1 / 28.7m pop; 2.9 beds per 1000 (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787) and 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)
  • 04-06 45k TEXAS VENT OVERRUN STAGE 1 / 28.7m pop; 2.9 beds per 1000 (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787) and 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)
  • 04-10 150k TEXAS VENT/ICU STG2 & Hosp STG 1 / 28.7m pop; 2.9 beds per 1000 (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787) and 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)
  • 04-13 366k TEXAS VENT/ICU STG3 & Hosp STG 2 / 28.7m pop; 2.9 beds per 1000 (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787) and 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)
  • 04-15 660k TEXAS Hosp STG 3 / 28.7m pop; 2.9 beds per 1000 (83230); 32% unoccupied (26633) / 11% are ICU (2929); 6.7% ventilators (1787) and 10% limited function ventilation (2663) / 5-15% conf need hosp(532k-177k @ overrun); 2-10% ICU (29k-146k); 1-5% need vent (36k-178k)

The inflection point for R0 of 2.2 is 60%. Current reporting rate is 12-15%. Assuming we keep testing by same criteria, the Tx inflection point is about 400k confirmed. We may not reach this numerically due to testing/infrastructure failure. eg, we may reach stage 3 while our confirmed rate is much lower, but still around the same day, and still around the same number of actual infected.  Also, there are different groups between spreaders and isolators.  I don’t know the balance of those two groups. They could be 20/80 or 50/50.

Barring major changes, the model is +/- 25% per week.  That is +/- 1.5 days for stage 1. That is +/- 2.5 days for stage 2. That is +/- 3.5 days for stage 3.

If the Pandemic declaration helped, then 03-24 will be at least 2% low for US and TX. If the Emergency declaration helped, then 03-25 will be at least 2% low for US and TX.  Either of those should show a continual downward trend.  We have had a lot of people ignoring expert and government recommendations, so I do not expect an abrupt change.

If we did abruptly fall to, say, 112% on 03-24 and stay there, then Stage 1 starts April 23-26; then Stage 2 starts May 7-11; Stage 3 may never happen due to average disease cycle of 20 days, and ICU cycle of 30 days.  This would be a dream scenario, and is unlikely.  More likely to see a 5% drop several days in a row.  It’s unlikely to see the clam-down go below 110% until it looks really bad (and then it’s too late).

Texas is about 9% of the US capacity and slightly more capacity than average.  Look for 11x numbers in the US column for similar problems.

  • 33k -> 363k on 03/30 Stage 1 ICU
  • 45k -> 495k on 03/31 Stage 1 Vent
  • 150k -> 1650k on 04/04 Stage 2 / Stage 1 Hosp
  • 366k -> 4026k on 04/07 Stage 3 / Stage 2 Hosp
  • 660k -> 7260k on 04/09 Stage 3 Hosp

112% projections:

  • 112% ICU Stage 1 is 04/10
  • 112% Vent Stage 1 is 04/12
  • 112% V2 / Hosp Stage 1 is 04/23
  • 112% V3/H2 is 05/01
  • 112% H3 is 05/06
  • 112% numbers are +/- 3, 5, and 7 days.

This is all bistromath, and really, anything more than a week out is just guesswork. A lot can change in a week, and I’m expecting substantial changes over the next 3 days based on the activities 10-14 days ago.

The Spreadsheet has been updated. JHU replaced some data sources, so it was a little annoying, and a little more manual entry.

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