You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Introduction

I extracted the Ciovid-19 statistics from Johns Hopkins University (JHU) . There are raw data for confirmed cases and deaths by date for each county in each state. For each state, I also extracted state population, area and population density from https://www.states101.com/populations. I wrote a Perl script covid-us.pl to gather the above information and cast it in a suitable form for the www.charte.ca motion charts and correlation data.

Results

 USUS with fit
Deaths vs Confirmed casesHereHere
Deaths vs % population confirmed with Corona-19 virusHereHere

Notes:

Deaths vs Confirmed:

  • Straight-line in log-log plot followed by most states. This indicates it follows a power law (exponential increase in both measures (deaths and confirmed)).
  • The first confirmed cases seen by CA towards the end of January, followed by IL at the end of January.
  • WA and IL started getting confirmed cases first starting at the end of February.
  • First deaths reported for Washington State 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 are leading the way in both deaths and confirmed cases. 
  • By the end of the second week in April, SD and UT are noticeable below the general line followed by other states. 
  •  At the end of the second week in April, WY appears to be the last state to have greater than one Corona-19 death.

Deaths vs %population confirmed

  • Note that since it is a log-log scale no bubble appears for a state until there is at least 1 confirmed case and 1 death for the state.
  • Wide dispersion (not all states on line as seen in the log-log plot)
  • % Confirmed and deaths both low for AK, VT, NH, ID
  • Cluster of DE, DC and RI with low deaths compared to the % confirmed cases
  • NY, NJ, MA, DE, CT, LA, RI DC have the highest % confirmed cases.
  • By March 14th, WA, NY, CA, FL were reporting deaths.

Possible further work

Look at the California counties data from JHU using the same analysis and visualization.

Maybe look at red states vs blue states (e.g. see https://en.wikipedia.org/wiki/Red_states_and_blue_states)..

 

 

  • No labels