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.
?v=1
Excellent. I was just starting to figure out how to do this.
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.Excellent. I was just starting to figure out how to do this.