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.

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.

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

https://coronavirustechhandbook.com/

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.

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

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.