Here are csv files with Johns Hopkins data converted to *daily* case counts for all USA counties

1196
3
06-25-2020 11:18 AM
JosephElfelt1
Occasional Contributor

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.
https://mappingsupport.com/p2/help/COVID19-new-cases-per-day.pdf

Joseph Elfelt

Twitter: @mappingsupport

https://mappingsupport.com

Tags (2)
3 Replies
ClaudiaCaceres4
New Contributor II

Hi this is great! I generally make my own layer but only for the areas of my interest.  This wil be fantastic for a research study. Do you by any chance know of any layer that includes race/ethnicity by county? 

Thank you. 

JosephElfelt1
Occasional Contributor

There is a subreddit for 'datasets'.  You might ask there.

ClaudiaCaceres4
New Contributor II

I did but no response. We are currently making this layer but a lot of counties do not provide so much detail in their data. So we will have a layer with what is available in their websites. But thanks for the response.