Improved Santa Clara County Dashboard

Improved Santa Clara County Dashboard - Printable Version

+- The CardBoard (https://thecardboard.org/board)
+-- Forum: Emergency (https://thecardboard.org/board/forum-11.html)
+--- Forum: Covid-19 (https://thecardboard.org/board/forum-12.html)
+--- Thread: Improved Santa Clara County Dashboard (/thread-19299.html)

Improved Santa Clara County Dashboard - Leftcoast - 04-02-2020

The improved Santa Clara dashboard we've been asking for unveiled today displaying graphical BI type dashboards covering three areas - Cases, Hospital utilization and Laboratory Testing. There's even data on hospital bed surge capacity and ventilator usage. I'm pretty impressed and hope they have the time and process to keep the data current. Check it out.

It's encouraging to see local government and local agencies doing well and stepping into the leadership void during this crisis.

https://www.sccgov.org/sites/phd/DiseaseInformation/novel-coronavirus/Pages/dashboard.aspx

RE: Improved Santa Clara County Dashboard - Farm93 - 04-02-2020

(04-02-2020, 01:23 AM)Leftcoast Wrote: The improved Santa Clara dashboard we've been asking for unveiled today displaying graphical BI type dashboards covering three areas - Cases, Hospital utilization and Laboratory Testing. There's even data on hospital bed surge capacity and ventilator usage. I'm pretty impressed and hope they have the time and process to keep the data current. Check it out.

It's encouraging to see local government and local agencies doing well and stepping into the leadership void during this crisis.

https://www.sccgov.org/sites/phd/DiseaseInformation/novel-coronavirus/Pages/dashboard.aspx

I sure wish the USA had something like this, but I wouldn't prioritize it over getting testing.

A few things jumped out at me.

The 31-60 age groups capture the majority of cases. I couldn't help but wonder if those 30 and under are getting disease at greater rates, but are just not identified in our system. If their rates are at or close to their older peers than it would imply there are a number of asymptomatic or mild case people essentially serving as super spreaders.

Sample size is, thankfully, small, so the death by age looks in line with global experiences. However males representing 75% of deaths is rather shocking. I know there is a bias to male deaths, but 75/25 is rather noteworthy.

RE: Improved Santa Clara County Dashboard - martyup - 04-02-2020

(04-02-2020, 06:15 AM)Farm93 Wrote: I sure wish the USA had something like this, but I wouldn't prioritize it over getting testing.

https://infection2020.com/

RE: Improved Santa Clara County Dashboard - oldalum - 04-02-2020

"California's SF Bay Area nailed coronavirus response, everyone should heed its lessons"

article on the effects of the SF Bay Area's 4-day head start on the rest of California with SiP: article

lauds SCC's Dr. Sara Cody for leading the response.

Leftcoast - Leftcoast - 04-02-2020

I believe Sarah Cody is class of ‘85

RE: Improved Santa Clara County Dashboard - BostonCard - 04-02-2020

(04-02-2020, 10:29 AM)oldalum Wrote: "California's SF Bay Area nailed coronavirus response, everyone should heed its lessons"

article on the effects of the SF Bay Area's 4-day head start on the rest of California with SiP: article

lauds SCC's Dr. Sara Cody for leading the response.

While I think the response here has been very good, I would hold off on celebrating. WE are still a long way from the end of this.

BC

RE: Leftcoast - 82lsju - 04-02-2020

(04-02-2020, 10:56 AM)Leftcoast Wrote: I believe Sarah Cody is class of ‘85

she is

RE: Improved Santa Clara County Dashboard - Farm93 - 04-02-2020

(04-02-2020, 09:08 AM)martyup Wrote:
(04-02-2020, 06:15 AM)Farm93 Wrote: I sure wish the USA had something like this, but I wouldn't prioritize it over getting testing.

https://infection2020.com/

Thanks..
There are actually a number of sites that track cases and deaths by state. My favorite is worldometer.com.

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

The parts of the Santa Clara County dashboard I found useful related to the cases and deaths by age and gender.

RE: Improved Santa Clara County Dashboard - oldalum - 04-02-2020

(04-02-2020, 01:17 PM)Farm93 Wrote: The parts of the Santa Clara County dashboard I found useful depressing related to the cases and deaths by age and gender.

(fixed it for me)

RE: Improved Santa Clara County Dashboard - M T - 04-02-2020

Some things to note about the new dashboard.

First, the hospitalization numbers are about the beds in use now, not the total number of hospitalizations. The new number is a critical number to help us understand the situation at the hospital today, and it is probably good for estimating the number of currently infected individuals, but it doesn't give us a way to estimate whether the total number of positive results is close to the total number of cases. We'll probably need to use something like today's positives vs today's new hospitalizations. BUT, then we don't have today's new hospitalizations; we only have today's net hospitalizations (we will cheer when it goes negative). If we only have one number, probably what we are given now is the critical one.

In case you didn't notice, you can click on the graphs and do things, such as show as a table or to show a single's day's numbers. (I'm haven't found a way to export the table)

The number of cases that tested positive, ordered by date received, is a LOT SMOOTHER than what had previously been reported. i'd guess a lot of the noisy behavior was probably the collection & posting of the numbers by the Public Health Department. By eyeball, a fitted curve should peak around March 26 (55) or March 27 (72). (Discount March 31's numbers as I'm guessing that is a partial day total.)

If you take the number of positive results through the (partial) day of March 31 (956), and add the main dashboard's new cases (63), you get today's new total of 1019. Some of that 63 probably belongs on March 31 and some April 1.

I initially was impressed that the 1758 acute hospital bed + 300 ICU beds can be supplemented by a surge capacity of 1461.
But then the total seemed low. A recent Mother Jones article indicated 3760 beds. AHD.org indicates 1.85 beds in short-term acute hospitals per 1000 population for the state, which would correspond to 3700 beds)
But the total is only 3519 beds, or 1.76 per 1000 people. The only states with a lower ratio are Washington(1.7) and Oregon (1.6) per KFF.org.
At the country level, of the 41 listed at Wikipedia, only Colombia, Mexico and India have fewer beds per capita.

No wonder the Public Health Directory pulled the trigger early on stay-at-home: Santa Clara County is very short of hospital beds, based on the number of people.