Versions Compared

Key

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

...


A Perl script covid-us.pl was developed to gather the above information and cast it in a suitable form for the www.charte.ca motion charts and correlation data.

Results

Motion plot

Notes:

Ungrouped

Deaths vs Confirmed:

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

    Linear plotLog Log plot
    Image AddedImage Added


    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))
    Image Removed

    .

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

...

  • The leading states in terms of deaths per million population are: NY, NJ, CT, MA, LA, MI, DE,DC, RI.
    The leading states in terms of confirmed per million of population are: NY, NJ, MA, DE, CT,RI, LA, DC, MI

    If one does not normalize by population the NY and NJ standout followed by the top of the bunch being MA and MI
    .
    Looking at a log vs log plot the trailing states one sees the lowest deaths are for AK SD, HI, MT, WY, ND. The lowest Confirmed cases are for AK, SD, SD,HI, MT, WY, ND.


  • 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.
  • % 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.

Grouped data

If we color the bubbles by each state's political leaning the chart appears below. It is apparent that Covid-19 is impacting democratic states the hardest, followed by the swing states.

Image Added

Possible further work

Looks at dividing states into 0-12%, 25-50%, 50%-75%, 75%-100% for the education and income demographics, and using these to group the states.

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