Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This interactive report is built using data from the New York Times’ Github-hosted coronavirus dataset. The report’s data updates twice a day, at 10pm and 10am. We originally built this just to use internally, but our hope is that you’ll find value in it as well.
Our Report adds a modeling layer on top of the New York Times’ raw data. Their datasets track daily reports of the cumulative cases and fatalities in every county in the US. We used those totals to derive a model that includes:
We built this report to highlight what we believe are the two most important metrics to monitor for any given geography – the growth rate in cases, and the growth rate in fatalities. These are the two primary drivers for the federal government’s phased re-entry guidelines.
Those guidelines specifically call for a downward trajectory of cases and fatalities in a 14-day window as the primary criteria for phased re-opening. But with so much variation in new cases and fatality counts from day-to-day, it can be challenging to understand what the “trajectory” is over a 2 week period.
Establishing the 2 week period growth rate is the best model we’ve seen for identifying if a particular geographic region, down to the county level, is achieving the federal guidelines for “Downward trajectory”. If the growth rate is negative, that means that in the most recent two week period, the average new cases or average fatalities were lower than in the previous two week. Likewise, if the % growth is positive, that means the most recent two weeks demonstrated an upward trajectory of new cases or fatalities.
Being able to visualize how these two numbers are changing over time, as well as being able to identify which states and counties are or aren’t consistently trending down, has helped us to make more informed decisions about how and when to best re-open our physical offices.
We’re also able to help our distributed team members around the country to understand what’s happening in their parts of the country, so they can make more informed decisions about their own health and well-being.
We hope you find this tool educational and insightful. And, our Business Intelligence and Data Visualization teams would love to hear your feedback on how you’re using it! You can reach them anytime at reporting@headspring.com.
eyJrIjoiOGY3MGI1OWEtNmRhOC00ZGRlLWExNWUtY2RkNzdkNDZmNGI0IiwidCI6IjU3MjU2NThmLTU1ZWYtNDBjYy04MGE1LTgzYjA0MDdiNzJkOSIsImMiOjZ9