Thread by @COVID19Tracking

Here's the latest in our ongoing effort to help data users find, understand, and use federal COVID-19 data.

We've created a bit of code that combines federal testing, case, death, and hospitalization data in a single spreadsheet.

covidtracking.com/analysis-updat…

One major caveat—we are not committed to maintaining this script should the federal data pages undergo material changes. This is simply a set of instructions for interested data users (and an example of what's possible with federal data).

For inexperienced data users, this process is no more than 2 clicks. For users familiar with Python and pandas, feel free to take this code as a starting point for further exploration.

Once you've downloaded your CSV, you can create visualizations in nearly identical fashion to our prior daily work

Please read the notes section carefully to get a handle on these data sources before you viz. We hope this makes federal data more approachable for a wider audience

We have also updated our list of federal data 101 posts to point to new and relocated federal datasets.

covidtracking.com/analysis-updat…

And we have released a summary of all @COVID19Tracking datasets with comparable federal replacements where they exist.

covidtracking.com/about-data/dat…

Lastly, big thank you to @zachlipton and @anthropoco for streamlining these federal data into a single CSV. They have been tireless data wranglers behind the scenes and we deeply appreciate their work.