Where can i find county case data from previous dates?

[SarahHubbard]

I'm analyzing trends and spread of the disease for WV Army Guard and would like to have county case data from each day to show changes and spreads.

[TiaLemon · Accepted solution]

COVIDRecovered= "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv"
COVIDDeaths = "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv"
COVIDConfirmed = "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv"
COVIDUSConfirmed = "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"
COVIDUSDeaths = "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_US.csv"

[SarahHubbard]

Hi thank you Tia! 

What data type is this called so i can look up how to use it?

Stay safe and stay healthy!

[TiaLemon]

it is a csv text file

[DerekLaw]

Hi Tia,

Thanks for sharing links to this data. Great resource!

[TiaLemon]

2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSESent from Samsung tablet.

[TiaLemon]

2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSEhttps://github.com/CSSEGISandData/COVID-19Sent from Samsung tablet.

[DerekLaw]

Thanks for stating the source Tia, appreciate it.

[SarahHubbard]

I've tried everything, but i can't seem to convert this text to a csv file through excel. The finished csv file i create and export won't convert to a shapefile, nor can i create parameters in arcgis pro. Is there a link you can find that shows a method to properly transfer this data to a shapefile? 

Thanks!

[DerekLaw]

Hi Sarah,

> I've tried everything, but i can't seem to convert this text to a csv file through excel.

Try using Notepad++, it's a free download

https://notepad-plus-plus.org/downloads/ 

You can copy/paste the data into a new file, then save as .csv. Next, you can use it to upload directly into ArcGIS Online to create a new hosted feature layer. Then you could export to shapefile.

Hope this helps,