I'm keeping a log of the number of Corronavirus cases (both active and total), in local-areas that I care about.
Currently, I'm using the dashboard put together by John Hopkins Center For Systems Science and Engineering. Every day, I manually open it, zoom into the Bay area (for instance), and count the number of active cases, total cases, and total deaths. I log those numbers in a personal google sheet, for each relevant metropolitan area.
Is there a better way to do this? Does anyone know of a system that is automatically recording the number of cases and number of deaths, in different populations (in the US)?
Edit 2020-03-08: I made a Google Sheet that makes it easy to view Johns Hopkins data for up to 5 locations of interest.
If you want to get raw data from the Johns Hopkins Github Repo into a Google Sheet, use these formulas:
With these formulas, the data in your sheet should update within a few hours of Johns Hopkins updating their data. If you want to force an update, bust the Google Sheets cache by sticking
?v=1on the end of the URL.