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.
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.
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.
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.
Amazing. Thank you!