President Donald Trump and the White House Corona Virus Task
Force released “Opening Up America Again” guidelines on April 16,
2020. The guidelines provide “Proposed
State or Regional Gating Criteria” for proceeding to each of three phases of reduced
restrictions on economic and social activity.“Core State Preparedness Responsibilities” include robust testing and contact tracing capability, adequate healthcare system capacity to include a surge capability, and a plan to protect the health and safety of critical workers, vulnerable populations (e.g. nursing homes), and other related specific requirements.
The guidelines use criteria for transitions through the
three phases based on data within a state or even county or city level, as the granularity of data
is now available to those levels.
The guidelines do not set dates, but rely on states satisfy criteria to
transition through each phase called “Gating.”
Beyond the underpinning Core State Preparedness Responsibilities a state
would make decisions about transitioning based on an observed decrease in day to
day confirmed cases and positive tests
for the virus over a two week period.
This necessary plan is adequate to begin the
process of transition in balancing the risk of economic collapse with public
health. Twenty-two million Americans
have now lost their jobs as the result of the Covid-19 pandemic.
I keep my own databases to analyze the risk of Covid-19. I
do this to satisfy my own curiosity and analytical bent, but I also feel that
there is a weakness in journalism today that forces me to do my own
analysis. I have observed an
overemphasis on reporting raw numbers to indicate risk and impact with an
emphasis on rounded thresholds (e.g. 1000, 10,000) that make for good headlines. This distorts impressions and understanding. I believe a better way to understand virus
risk and impact is through relative comparison of a state against other states
and the national average by calculating the percentage of a state’s residents
that have been tested, have tested positive, have died, and are projected to die with Covid-19.
I set up download routines from databases that are reliable
and current. The COVID Tracking Project hosted at The Atlantic has a data file
that I use to track specific numbers tested, hospitalized, and deaths. The New York Times has a database that tracks similar data, but has an excellent
graphic presentation showing the increase or decrease in cases and deaths in a
day over day comparison. The University of Washington IHME database provides model projections for hospital bed
and ventilator shortfalls and anticipated number of deaths through August 4th
by state.
Below are some tables I created that are sorted to show
different rankings by state and the national average. I offer these tables to my blog readers in
the hope that it will help them better understand the situation in their state and appreciate that all states are different.



