Biometrics Northwest LLC

Performing Data Analysis and Modeling



About Us


Contact Us


Project: Dynamic Covid-19 visualizations (a.k.a movies)

I had not seen any dynamic visualizations (a.k.a. movies) of the spread of Covid-19 in the U.S., or the world for tha matter, so I made state and county level visualizations for the U.S. using the Covid-19 data from the New York Times.

The metric used for determining the risk class was the seven (7) day average of the number of new daily Covid-19 cases per 100,000 people. Four risk classes were used: good, spreading, fast spread, and bad (my name choices), plus a zero value or no data class. A rationale for this metric can be found here.

Covid-19 daily case counts from the New York Times for the United States
 Covid-19 spread by U.S. State Starting date: January 21, 2020
 Covid-19 spread by U.S. County Starting date: January 21, 2020
Covid-19 daily trends (experimental)
Covid-19 Daily trends by U.S. State, Starting date: January 21, 2020
See also
The New York Times Covid-19 U.S. tracking page
The New York Times. (2021). Coronavirus (Covid-19) Data in the United States.
Data Retrieved and Processed on 2021-12-19

For these visualizations states or counties not reporting data are shown in a gray color. In addition, states or counties having a metric value of exactly zero on a particular date are also shown as gray. This was done for three reasons.

  1. Zero values could have occurred from rounding down to a small number of decimal places. While these would still have been in the good category, it was not possible to distinguish a rounded to zero value from the following two situations.
  2. Zero values could have been reported by a state or county because they were no longer tracking new cases and reporting actual case counts.
  3. Zero values could have been used as a default value for the numeric data during processing, so a state or county that was not reporting could have been assigned a zero value for the metric.
  4. An additional risk class was added for values of the the seven day average of new daily cases per 100,000 people greater than 40, using the color purple. This was done to provide a little bit more granularity when daily case counts were rising rapidly.
  5. For the experimental daily trends a 14 day moving average was used to reduce jitter in the daily trend color changes.

Back to top

For information send email to:

Last Update: September 22, 2021 11:00 AM

Copyright 2005-2021 Biometrics Northwest LLC