Verde Valley Virus
The Yavapai County Community Health Services website provides an excellent breakdown of COVID-19 in the county.
It includes information about the number of cases and their locations, testing, hospitilizations, and further details. (example below)
After checking this information a few days in a row, I realized I wanted to know more than what was displayed in this chart.
For example, what are the percentages based on the population of each city? How are the hospitilizations trending over time?
To answer those questions we need to be able to look back at the information. However, upon contacting the webmaster for historical data I was presented with the response below:
Thank you for visiting the Yavapai County Government website. We're sorry to hear that you're not finding the information you need. We don’t currently keep a history of all the numbers on our website. The history of news items can be found here: https://www.yavapai.us/chs/News, and some of the counts are available in the attached press releases, but not all counts. We recommend that you call the Yavapai County Emergency Phone Bank for COVID-19 (928-442-5103) or YCCHS (928-771-3134, email: [email protected]) for more information. Have a great day.
That's ridiculous! This data could be very useful to anyone in our area, especially amid the headlines around Arizona and the rapid spread of the virus.
Since they don't want to give out the data, I started taking screenshots of the chart each day since the end of June, and compiling the info into spreadsheet form.
We have a strong community here, and the cities in the Verde Valley are making great efforts to curb the spread of the virus. My hope is that this information helps eliminate fear and anxiety.
To view the spreadsheets on Github, visit the verdevalleyvirus/data folder.
To view the screen shots on Github, visit the verdevalleyvirus/screenshots folder.
To download the data directly, please use the links below:
Master Spreadsheet
Master
State
Hospitals
Cities
Populations