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

#1

Post by andfrob » Thu, Apr 02, 2020, 5:33 PM UTC

Spreadsheet of San Francisco Bay Area Covid-19 Data and Charts
docs.google.com

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

#2

Post by andfrob » Thu, Apr 02, 2020, 5:35 PM UTC

I 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.

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

#3

Post by the_crocodile » Thu, Apr 02, 2020, 5:57 PM UTC

Very helpful. Thank you for sharing!

Have you been able to find data on # of tests carried out?

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

#4

Post by norifukuoka » Thu, Apr 02, 2020, 5:59 PM UTC

Very cool. By the way did you intend for the Y-axis on the "Days since 100 cases" chart to be "Days since 100 cases"? It seems like the Y-axis is "cases" and the X-axis is "Days since 100 cases".

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

#5

Post by testfoobar » Thu, Apr 02, 2020, 6:03 PM UTC

Is anyplace in the Bay Area sharing stats by zipcode?

For example, San Diego has zipcode breakdown here: https://www.sandiegocounty.gov/content/sdc/hhsa/programs/phs...

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

#6

Post by andfrob » Thu, Apr 02, 2020, 6:32 PM UTC

testfoobar wrote: post #5

Is anyplace in the Bay Area sharing stats by zipcode? For example, San Diego has zipcode breakdown here: https://www.sandiegocounty.gov/content/sdc/hhsa/programs/phs...

Not that I am aware of. And the counties vary a lot in terms of the data they provide. The best is Napa County.

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

#7

Post by jhammons » Thu, Apr 02, 2020, 6:33 PM UTC

testfoobar wrote: post #5

Is anyplace in the Bay Area sharing stats by zipcode? For example, San Diego has zipcode breakdown here: https://www.sandiegocounty.gov/content/sdc/hhsa/programs/phs...

Austin has a decent breakdown here: http://www.austintexas.gov/covid19

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

#8

Post by andfrob » Thu, Apr 02, 2020, 6:34 PM UTC

norifukuoka wrote: post #4

Very cool. By the way did you intend for the Y-axis on the "Days since 100 cases" chart to be "Days since 100 cases"? It seems like the Y-axis is "cases" and the X-axis is "Days since 100 cases".

Thanks, fixed!

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

#9

Post by andfrob » Thu, Apr 02, 2020, 6:35 PM UTC

the_crocodile wrote: post #3

Very helpful. Thank you for sharing! Have you been able to find data on # of tests carried out?

Very, very limited data on the Bay Area. Under the "SF Bay Area Actuals" you can scroll all the way to the right you will see what I have been able to find.

California does report them on aggregate, but the purpose of this sheet was to focus on the Bay Area.

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

#10

Post by Jommi » Thu, Apr 02, 2020, 6:38 PM UTC

Where is the most important metric? Daily tested vs tested positive stats.