Is anyplace in the Bay Area sharing stats by age brackets?
Santa Clara County (South Bay Area) shares a dashboard with cases by age group and deaths by age group: https://www.sccgov.org/sites/phd/DiseaseInformation/novel-co...
Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
21–30 of 49 posts
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#22Where is the most important metric? Daily tested vs tested positive stats.
Honestly, the most important metric is deaths, and from what I can see, the SF Bay Area has done relatively well in that metric. No overcrowded hospitals, for example.
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#23Where is the most important metric? Daily tested vs tested positive stats.
The one I pay attention to is daily growth rate of confirmed cases. It can't cover people who aren't tested. But, it approximates the velocity of the problem's magnitude. And, over time it shows the acceleration --which reflects on how we are improving the situation, or not...
https://paroj.github.io/arewedeadyet/#rate
The good news is that the US has gone from a 30+% daily growth rate 10 days ago down to a 15% growth rate and falling. We need to keep falling into the negative rates to solve this problem.
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#24Earlier quoted context omitted.
This is not released by most counties, unfortunately. There are some limited stats to the very far right side of the "SF Bay Area Actuals" sheet. Anecdotally, Bay Area is seeing <10% positivity rates
Another important data point to assess testing is Case Fatality Rate (CFR). This is about 2.5% in the SF Bay Area. In other places with higher testing, such as Australia, the CFR is 0.6% or less. This implies that the true number of cases is 4-5 times higher... probably a lot more.
The Diamond Princess numbers are 11 deaths out of 712 cases, with 82 still outstanding (15 serious or critical).
The CFR should end up being about 1.5% (or possibly somewhat higher).
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#25California unfortunately has a huge backlog of pending test results. The cause seems to be the private labs (Quest in particular) accepted test samples and build up a huge backlog of the earlier manually processed test samples. Other labs would push back if their queue got too long. The newer samples are run on the Roche high speed machines.
Do you happen to have a source for the cause of the backlog? Not doubting you, just curious to read more information.
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#26California unfortunately has a huge backlog of pending test results. The cause seems to be the private labs (Quest in particular) accepted test samples and build up a huge backlog of the earlier manually processed test samples. Other labs would push back if their queue got too long. The newer samples are run on the Roche high speed machines.
Do you happen to have a source for the cause of the backlog? Not doubting you, just curious to read more information.
here you go: https://covidtracking.com/data/state/california
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#27Where is the most important metric? Daily tested vs tested positive stats.
The one I pay attention to is daily growth rate of confirmed cases. It can't cover people who aren't tested. But, it approximates the velocity of the problem's magnitude. And, over time it shows the acceleration --which reflects on how we are improving the situation, or not... https://paroj.github.io/arewedeadyet/#rate The good news is that the US has gone from a 30+% daily growth rate 10 days ago down to a 15% growt…
me too. it has some noise from variation in testing rate, but it's directionally accurate.
for example the bay area has recently been seeing some days with single digit growth rates. shelter in place IS WORKING, but it's going to take time / we may need some additional measures. I was just reading it may also be spread in the air from breathing.
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#28Earlier quoted context omitted.
Do you happen to have a source for the cause of the backlog? Not doubting you, just curious to read more information.
here you go: https://covidtracking.com/data/state/california
I’m asking for a source on why the backlog happened. Unless I’m missing something, that just shows the number of pending cases.
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#29Where is the most important metric? Daily tested vs tested positive stats.
Honestly, the most important metric is deaths, and from what I can see, the SF Bay Area has done relatively well in that metric. No overcrowded hospitals, for example.
yes, but it lags 2-3 weeks behind confirmed cases
Re: Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
#30I developed this for myself but data junkies trying to get a feel for what is happening with the coronavirus spread across the San Francisco Bay Area will appreciate it. I am updating it regularly.
Where are you getting the raw data? I'm extracting it from the New York Times dataset for my own graphing. They have the data for all counties in the US. I've been meaning to automate the graphing but for now doing it manually. I wish you had the new cases per day graphed for all the bay area counties because that is what I monitor.
Raw data was originally from SF Chronicle, but they removed their timelapse view so I am now getting it direct from county websites. Stanford Open Data project also has a reasonable historical dataset that comes from the county websites.
I'll add a new cases graph for each county.