Map of California COVID-19 Cases
Implications of COVID-19
Discussion and looking forward
Data collection will continue, with the map being updated as new data comes in. For next steps, more data will be collected on COVID-19 patients, including those who have been tested and suspected cases. Unfortunately, the data for “positive COVID-19 patients” and “positive COVID-19 ICU patients” is not mutually-exclusive, meaning we cannot predict the ratio of people per county who will need ICU-level care. Therefore, mutually-exclusive data for COVID-19 ICU patients will be explored. How many people have been tested per county will be investigated, as well as each counties’ testing capabilities.
Data on the number of ventilators per county will also be investigated to calculate the ratio of ventilators to people in each county. Data on the race, gender, and age for COVID-19 patients would be helpful to find other possible correlations and to further map out and understand COVID-19 in California.
References
Mapping COVID-19 in California
Rosie Lehnhard
Dr. Omayra Ortega
What is COVID-19?
* Illustration of the morphology of coronaviruses; the club-shaped viral spike peplomers, colored red, create the look of a corona surrounding the virion when observed with an electron microscope.
* Above is an example of the COVID-19 statistics given by interacting with the map (each county will display these variables.
To interact with the map and learn more, please visit: https://public.tableau.com/profile/rosie.lehnhard6634#!/
Using data collected from CalMatters over a one-month period, I created this map of each county’s COVID-19 statistics. This map was created using Tableau, a data visualization software. Using this software, I made the map interactive, where the user can use their cursor to search each county for these statistics. I computed the statistics for each county, those statistics being: positive COVID-19 cases, positive COVID-19 ICU patients, population, etc. I created the map using a blue spectrum gradient, meaning the darker the blue, the more COVID-19 cases are present.
Looking at the map, Los Angeles County has the highest number of COVID-19 patients in California. This could be explained by Los Angeles County having the largest population in California (over 10 million). There are also entire counties that, as of April 20th, appear to have zero COVID-19 cases, such as Del Norte and Modoc. Like Los Angeles County, this could be attributed to population, as both counties have a small population (27, 812 and 8,841 respectively).