Where can i find county case data from previous dates?

1511
9
Jump to solution
04-07-2020 06:54 AM
SarahHubbard
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
TiaLemon
New Contributor II

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"

View solution in original post

9 Replies
TiaLemon
New Contributor II

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
New Contributor II

Hi thank you Tia! 

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

Stay safe and stay healthy!

0 Kudos
TiaLemon
New Contributor II

it is a csv text file

DerekLaw
Esri Esteemed Contributor

Hi Tia,

Thanks for sharing links to this data. Great resource!

0 Kudos
TiaLemon
New Contributor II

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

0 Kudos
TiaLemon
New Contributor II

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

DerekLaw
Esri Esteemed Contributor

Thanks for stating the source Tia, appreciate it.

0 Kudos
SarahHubbard
New Contributor II

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!

0 Kudos
DerekLaw
Esri Esteemed Contributor

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,

0 Kudos