Day 57 of Isolation – Barb’s Data

We’ve been tracking the Coronavirus data for quite a while.  Once we realized that most news sites just update the same page over and over, it was difficult to see trends.  The news organizations try to put it into the simplest form (understandably) but being science nerds, we want to play with the data ourselves.

My spread sheet has 3 components:

  1. Our community data since 3/27 when the first positive case was identified.
    1. Looking at this data, our curve has not hit its peak.  Why would our county rescind the mask order? data
  2.  Our community data showing the daily increases in confirmed cases and the 14 day average – the standard for “reopening states” was that the 14 day average needs to decrease.
    1. Does this look like it is decreasing to you?data 1
  3.  This 3rd page was started because I was unable to find data showing increases by state on a week to week basis.  It was sparked because I did a screenshot of the US map showing county infections on CNN.  When I looked a week later, they had changed the scale for the various colors!  How can you make a comparison when you keep changing the scale???  Unfortunately, I didn’t anticipate that and did not include the scale on the first one (4/20/2020).  Second one was screenshot on 5/8/2020.  If you look at Colorado, some of the counties decreased in their color intensity.  WHY?  Because CNN changed the scale!  How can I really see a spread and increase if you make it look “mild”.  Also the scale doesn’t make it obvious you are looking at cases per 100,000 of population.
    1. COVID county map 4_20_2020COVID all counties 5_9_2020
  4. I only started my 3rd page on 4/28/2020  You’ll notice I added Los Angeles County to the sheet.  Did you know Los Angeles County has more people than 41 other states?
    1. Interesting when you look at this data based on 2