Johns Hopkins University posts COVID-19 data daily 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE (as of February 2020). I wrote an open source program to download the data, filter and aggregate, and then store in a format that is convenient for analysis using tools like Microsoft Excel or Tableau.
The following data are updated most days. Using the program, you can retrieve the data yourself with different filters and aggregation. See below for details.
- World Data, broken down by country: COVID-19-Time-Series-World.csv
- US Data, broken down by state and county: COVID-19-Time-Series-US.csv
- Updated: 18 Jun 2020
Here are two video tutorials:
- Retrieve and Analyze COVID-19 Data using Microsoft Excel
- Retrieve and Analyze COVID-19 Data using Tableau
The video tutorials are the best way to get started. You can view the help file for the program by downloading it and running the following command line: