How are people tracking confirmed Coronavirus cases / Coronavirus deaths?

post by Eli Tyre (elityre) · 2020-03-07T03:53:55.071Z · LW · GW · No comments

This is a question post.

Contents

  Answers
    32 jimrandomh
    7 Ouroborus
    5 PeterH
    4 Elizabeth
    1 Bildoon
    1 Dustin
None
No comments

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

Answers

answer by jimrandomh · 2020-03-07T06:23:19.105Z · LW(p) · GW(p)

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.

↑ comment by PeterH · 2020-03-07T20:20:10.656Z · LW(p) · GW(p)

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.

Replies from: elityre
↑ comment by Eli Tyre (elityre) · 2020-03-07T21:11:18.507Z · LW(p) · GW(p)

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

↑ comment by Eli Tyre (elityre) · 2020-03-07T19:06:33.243Z · LW(p) · GW(p)

Amazing. Thank you!

answer by Ouroborus · 2020-03-07T16:24:45.910Z · LW(p) · GW(p)

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.

answer by PeterH · 2020-03-08T00:37:35.519Z · LW(p) · GW(p)

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

https://coronavirustechhandbook.com/

answer by Elizabeth · 2020-03-07T04:20:45.269Z · LW(p) · GW(p)

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.

↑ comment by Eli Tyre (elityre) · 2020-03-07T05:06:20.955Z · LW(p) · GW(p)

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.

answer by Dustin · 2020-03-08T01:20:01.691Z · LW(p) · GW(p)

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.

covid-19 graph

No comments

Comments sorted by top scores.