...
N.b. I am having problems with using www.charte.ca as one increases the number of Excel lines of data beyond around 2500. It often times-out after several minutes and asks if I wish to continue to wait, this may happen several times and there appears to be no guarantee it will finally provide a result, instead basically locking up and requiring relogging re-logging into www.charte.ca. This is the reason the data is divided up by Jan-Apr and May-Jun.
US States
Motion chart of Covid-19 deaths vs Confirmed cases with bubbles sized by population for US states and colored by political leaning
Motion chart of deaths vs Covid-19 Confirmed cases with bubbles sized by population for US states and colored by % Bachelor degrees
Motion chart of deaths vs Covid-19 Confirmed cases with bubbles sized by population for US states and colored by median income (Jan 28, 2020 - Apr 28, 2000)
Motion chart of Covid-19 deaths vs Confirmed cases per million population with bubbles sized by US state population (May 1, 2020 - Jun 22, 2020)
California Counties
...
We tend to use a log log chart which provides a greater visibility of a wide range of data (compare the two charts below), and since both the confirmed data and deaths are exponential in their behavior for most states. Also note that with a logarithmic scale: a straight line means exponential growth, and the steeper a line, the faster the total number of confirmed coronavirus cases or deaths is doubling.
Linear plot Log Log plot
.- The first confirmed cases were seen by WA 1/22/20, IL a day later and AZ & CA on 1/25/20
. - First deaths reported for Washington State were at the start of March
. - Deaths start to really increase in the second week in March
. - By the start of April, NY followed by NJ were leading the way in both deaths and confirmed cases
. - By the end of the second week in April, SD and UT are noticeably below the general line followed by other states
. - On 3/30/20 WV was the last state to record a Covid-19 death
- At the end of the second week in April, WY appears to be the last state to have greater than one Corona-19 death.
.
...