COVID-19 Data Viz: U.S. County Hotspots

Data

COVID-19 Data Viz: U.S. County Hotspots

Last week, a White House pandemic task force report was leaked to the media, showing that coronavirus infection rates were spiking to new highs in communities across the country’s heartland. Immediately, everyone’s eyes went to the left table in red in the below image: locations with increased cases. Is the country really ready to open up when cases are spiking in new areas? Or is COVID-19 something we will have to learn to live with in the years to come?

Accessible and Interactive Data

Fortunately, all of the data used to make this report is public and easily accessible to people like myself, thanks to Starschema making their COVID-19 dataset available on Snowflake Data Marketplace. I took the criteria from the report as a starting point for this dashboard:

  • Locations with at least 10% week-to-week increased cases
  • At least 200 new cases in the last 7 days
  • At least 40 new cases per 100,000 people in the last 7 days

Additionally, this dashboard allows the user to toggle between cases and deaths and dynamically interact with the data. The fatality numbers are relatively small at the time I’m writing this article. We can only hope that proper action is taken to keep it that way.

By the way, if you’re working on the White House pandemic task force, and you’re tired of manually putting that report together every day in Excel for the Donald Trump and Anthony Fauci, be sure to give us a call.  😊

More About the Author

Benjamin Du

Solutions Lead
COVID-19 Data Viz: U.S. County Hotspots Last week, a White House pandemic task force report was leaked to the media, showing that coronavirus infection rates were spiking to ...
COVID-19 Data Viz: The Impact of Coronavirus on U.S. Deaths What is the impact of COVID-19 on deaths in the United States? As many states complete their second month of lockdown, and millions of ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072