LESSWRONG
LW

by Eli Tyre1 min read7th Mar 20206 answers4 comments

13

Covid-19
Frontpage

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

New Answer
Ask Related Question
New Comment

6 Answers sorted by
top scoring

jimrandomh

Mar 07, 2020

32

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.

[-]PeterH3y 22

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.

Reply
2Eli Tyre3y
Excellent. I was just starting to figure out how to do this.
[-]Eli Tyre3y 2

Amazing. Thank you!

Reply

Ouroborus

Mar 07, 2020

7

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

Mar 08, 2020

5

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

https://coronavirustechhandbook.com/

Elizabeth

Mar 07, 2020

4

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 Tyre3y 6

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.

Reply

Dustin

Mar 08, 2020

1

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

1 Related Questions

Parent Question
218Coronavirus: Justified Practical Advice ThreadQ
Ben Pace, Elizabeth, Connor_Flexman
3y
Q
338
Moderation Log

New to LessWrong?

Getting Started

FAQ

Library