Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 plotLog 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.
    .

...