[Question] How are people tracking confirmed Coronavirus cases /​ Coronavirus deaths?

[Eli Tyre]

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)?

Thanks

[jimrandomh]

All of the data on that dashboard is in this GitHub repository, by the creators of the dashboard. You probably want this folder, which has a CSV file for each day, added once per day, with all the locations and case counts.

[PeterH]

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:

=IMPORTDATA("https://​​raw.githubusercontent.com/​​CSSEGISandData/​​COVID-19/​​master/​​csse_covid_19_data/​​csse_covid_19_time_series/​​time_series_19-covid-Confirmed.csv″) =IMPORTDATA(”https://​​raw.githubusercontent.com/​​CSSEGISandData/​​COVID-19/​​master/​​csse_covid_19_data/​​csse_covid_19_time_series/​​time_series_19-covid-Deaths.csv″) =IMPORTDATA(”https://​​raw.githubusercontent.com/​​CSSEGISandData/​​COVID-19/​​master/​​csse_covid_19_data/​​csse_covid_19_time_series/​​time_series_19-covid-Recovered.csv″)

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=1 on the end of the URL.

[Eli Tyre]

Excellent. I was just starting to figure out how to do this.

[Eli Tyre]

Amazing. Thank you!

[Ouroborus]

I’m finding this Spreadsheet useful. Like it’s one thing to see current numbers, but it’s also useful to see the numbers for each country and a graph.

[PeterH]

This website is compiling links to datasets, dashboards, tools etc:

https://​​coronavirustechhandbook.com/​​

[Elizabeth]

https://​​projects.sfchronicle.com/​​2020/​​coronavirus-map/​​ has more bay-area specific information, although not everything I want.

Also that spreadsheet is a public service and if you were willing to share it that would be great.

[Eli Tyre]

Here it is. I haven’t gotten very far yet, but perhaps it will be of some use to someone reading this comment in the future.

[Bildoon]

I find this doc useful. https://​​docs.google.com/​​spreadsheets/​​d/​​18oVRrHj3c183mHmq3m89_163yuYltLNlOmPerQ18E8w/​​htmlview?sle=true#

[Dustin]

I use Home Assistant for my home automation needs. It has a coronavirus sensor which pulls from the John Hopkins data. I then do two things with that data:

1. I have HA configured to send notifications to my phone when deaths and confirmed cases change by X%.

2. I use the influxdb integration with HA to ship the sensor data to...influxdb. I graph that data with Grafana.