COVID-19 Data

COVID-19 data plots for Worcester, MA (and surrounding towns)

While there are several sites that collect and graphically summarize COVID-19 data at the national, state, and county level, I found it difficult to find regular updated graphs for my specific city. Inspired by this COVID-19 graphical website (http://91-divoc.com/pages/covid-visualization/), I’ve compiled data and made graphs for the city of Worcester, MA. As best as I can, I will update this daily. Data is pulled from the city of Worcester’s announcement page: http://www.worcesterma.gov/announcements

If you have questions or comments for improvement, please do not hesitate to contact me.

Note that the data are plotted on a linear scale (left panels) and log scale (right panels). Log scales are particularly useful in visualizing the growth of process that growth exponentially, like the growth of microbes and infection diseases. I’ve also added simple regressions for cases and daily new cases, as well as linear extrapolation of cases 2 weeks forward (assuming constant rate of increase). Yellow dots depict reported case numbers on Sundays to help visualize any weekly trends in numbers.

Worcester_COVID_v2

 

Surrounding cities/towns

In an effort to explore local variability in case rates, I have accessed and plotted cumulative case data for two surrounding towns: Shrewsbury and West Boylston. The data highlight sharp differences in case load, which is roughly 3-fold higher in Worcester. Note that the number of cases on the y-axis is normalized by the city’s population size, also listed in the legend.

 

Worcester_cities_cases

I was curious about how the case numbers per capita compare to population density, since population density is a likely driver of why reported cases are notably higher in Worcester. While most (n=4) of the towns and cities appear to have a nice linear relations, both Leceister and Millbury are two notably outliers from this trend.

Worcester_cities_dens_cases