Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts

That would be so useful to identify hotspots within counties. Also information about new cases such as if they are working from home or are considered "essential workers". How are transmissions occurring despite all the stay at home efforts? That would help us all tighten up our collective defenses. Hopefully the governments are doing at least some rudimentary "contact tracing" efforts and we're just not getting to see the data.

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

I don't believe this is a reliable metric.

Who gets tested is a moving target. Stanford a short time ago did a free-for-all testing binge in order to collect data, but finished that and is now restricting tests to people requiring specific risk factors to give a test.

The first time I tried to get a test from another provider I just wasn't able, they didn't know of anywhere that would test me outside of hospitalization-type symptoms.

So testing is uneven and not very available, any stats need to include some metric for the criteria to get tests in the first place.

In other words, there is likely an enormous population with no symptoms or mild symptoms who couldn't get tested if they tried.

After two video appointments with separate providers I was able to get tested yesterday and the result came back negative about 22 hours later. It took me about 8 hours of effort and time to get that done, a luxury many people do not have.

It seems like this disease is so successful because of a significant symptom-free-but-contageous period followed by a small percentage of very serious symptoms.

That's what a pandemic needs. If it is very deadly very quickly it kills its transmission vectors before they can transmit. If it is entirely symptom free, it is very evolutionarily successful, but no one cares because there aren't any negative effects.

There is an "optimum" of disease characteristics for maximum damage and we seem to be experiencing one.

The bottom line is that it seems to be very difficult to prevent a majority of the world population from getting this disease and the result is going to be a global fatality rate of somewhere in the neighborhood of 1%.

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.