COVID in the Counties

We all need to do our part to avoid catching and spreading COVID-19. Here, we attempt to visualize how the places we all live are doing at preventing the virus from spreading.

Disclaimer: New York City data is not broken out by county.

New Cases in

This chart is useful for seeing where on the curve a particular locale is. Since the x-axis shows the number of days since 50 cases were reported in a locale, it allows for comparing the curve across time.

New Cases in

New Cases Total Cases

Data Definitions

County State
Row County State Confirmed Cases Cases Per Capita Growth Factor Doubling Time (Days)
Only showing top 100 counties for a given column sort.

Data Source

We're using the New York Times county-level data for reporting this data. Thanks to the Times for making this information publicly available.

Data Methods

The code we used to process and present this data is publicly available: https://github.com/mattparrilla/chartingcovid.

Modifications

We tried to keep the data as close to the source as we could, however, many counties had entries erroneously reporting the same or a decreasing case count for a given date. This is a known issue in the dataset.

To account for these holes in the data, we used the growth rate (discussed below) to estimate the case count for days with zero new cases. We only did this for historical data and we only did it when we had good case data for adjacent dates.

Calculations

The original data included cases and deaths. We focused on cases and pulled some additional metrics out of that figure: new cases, growth factor, and doubling time.

New Cases

New cases is the difference in total cases between adjacent days.

Growth Factor

The growth factor is defined as the ratio of new cases in one day to the ratio of new cases the previous day. It is a useful metric for knowing where we are on "the curve". A growth factor greater than 1 implies we are still on the exponential portion of the curve, while a growth factor less than 1 implies new cases are slowing down.

To provide a smoother, less noisy figure we averaged the growth factor for the previous 5 days.

3Blue1Brown has an excellent video explaining the importance of growth factor

Doubling Time

The doubling time of cases was calculated for every locale in the dataset for which we had sufficient data. It measures the days that it will take for the number of cases to double at the current growth rate.

The growth rate used to calculate doubling time is the exponential growth rate (as opposed to the growth factor mentioned above).

Who Made This

This website was made by Matt Parrilla and Brian Holdefehr. We're a couple of software guys who wanted to get a better idea for what was going on around us.