Silicon Valley Live Hospital Bed Data
sccgov.org
sccgov.org
I used PowerBI in one project before, with charts embedded in a web page, and this was my experience too - they just took forever to load!
On top of that, the documentation around embedding charts was pretty poor, and the licensing model was very confusing - I don't think we ever did really understand it!
Santa Clara county is about 2-3 weeks behind NY, which means the peak there will be roughly in 4-6 weeks. It's going to be a major disaster and emergency healthcare will be essentially unusable until mid June.
Santa Clara County was the first in the nation to go under SIP protocols officially.
Sadly the data doesn't seem to be readily accessible.
There's approx. 860 acute and ICU beds empty (from the text chart) for Santa Clara County, which has about 3-4 million people. So that will be full in about 1-2 weeks.
In addition, the California emergency stockpiles were neglected, so all that material rotted.
But it gets worse.
We're in lockdown to "flatten the curve" on how many ventilators are needed. But it turns out 2/3 of corona ventilator patients die in 2-3 weeks, and the rest are too ill to leave the hospital.
So it calls into question why we are in lockdown if ventilators are in fact irrelevant. That needs to be re-evaluated from a public health policy.
It looks to me like corona should be treated like a regular flu, and the only lockdown should be for plane flights.
Ventilators Are No Panacea For Critically Ill COVID-19 Patients
https://www.npr.org/sections/health-shots/2020/04/02/8261052...
That's not irrelevant.
Btw, you're right that we're not capitalizing on the lockdown as much as we could: we're supposed to build out the testing, contract tracing and early detection infrastructure (temperature checks at every office and grocery shops... Italy just started)
Shutting down plane flights is actually not that useful: we should just do what South Korea is doing and test every single arrival, and then we could keep that infrastructure in place (obviously, if the number of flights make it untenable to test every arrival, that should be heavily capped)
If you read the article, they're expecting 90% to either die or have organ damage.
So out of 50 patients, they's expecting 2 patients to walk out of the hospital with some kind of normal life.
Ventlators don't appear to tbe the answer beyond, "Well, we tried to do something. Too bad they don't work."
The additional problem is that using ineffective ventilators kills your hospital staff for little gain. In SARs-1 (2002) in Toronto, more hospital staff got infected or died than in the general population. Hospital ventilation systems circulate airborne diseases.
Now that we have data that ventilators don't work, we need to look at what the next steps are. There's no point in destroying the economy waiting for ventilators when they're not a treatment for corona virus.