I developed code that converts the Hopkins cumulative counts into a count of new COVID cases per day for each USA county. This daily case count data is saved in one csv file per month. These csv files are designed to be easy to import into GIS or spreadsheet software and are free for all to use. The only limitation is that your use must be non-commercial. This daily count of new cases per county will be updated each night as the pandemic continues.
Here is a PDF file with a bit more background, links to the csv data files and a link that will open an interactive map.