My Authors
Read all threads
1/7 Each day #JohnsHopkins publishes *cumulative* counts of #COVID19 cases for each county in the USA. As a public service I wrote code to convert that cumulative count data into *daily* counts for all USA counties. #CovidData #Covid19Data
2/7 This daily count data is in one csv file per month. There is one set of files with daily *case* counts and another set of files with daily *death* counts. Anyone can download and use this data. The only limitation is no commercial use.
3/7 These files include a latitude longitude centroid for each county and will be easy to import into spreadsheet or #GIS software. Each night the count of new #COVID cases for the prior day is added to the current monthly csv file.
4/7 Here is the link for the July cases file. To download the csv files for March (data starts on 24th), April, May and June change the number of the month in the download link.
mappingsupport.com/p2/disaster/co…
5/7 Here is the link for the July deaths file. Again, you can change the 2-digit month code to download earlier months back through March.
mappingsupport.com/p2/disaster/co…
6/7 I plan to keep producing and hosting these monthly files as long as the pandemic continues. And my intent is to monitor the erratas the Johns Hopkins posts on the GitHub site and to update these csv files accordingly.
7/7 I hope this information makes its way to any teaches that might find it useful.
Missing some Tweet in this thread? You can try to force a refresh.

Keep Current with Joseph Elfelt

Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

Twitter may remove this content at anytime, convert it as a PDF, save and print for later use!

Try unrolling a thread yourself!

how to unroll video

1) Follow Thread Reader App on Twitter so you can easily mention us!

2) Go to a Twitter thread (series of Tweets by the same owner) and mention us with a keyword "unroll" @threadreaderapp unroll

You can practice here first or read more on our help page!

Follow Us on Twitter!

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!