Aug 5, 2020
I’ve been obsessively checking the Washington Post Coronavirus Map to see how my state is doing, and to try to evaluate when it would be safe for the kids to return to school. I wanted to be able to use the raw data, and then I found The COVID Tracking Project. The COVID Tracking Project offers an API to query COVID data, both nationally and on a state by state basis. They also offer a raw download of the entire dataset.
The API is OK, but I wanted to be able to slice and dice the data, as well as make simple plots. I remembered Simon Willison had written a tool for analyzing data using SQL, and that it had a plotting plugin. I decided to download the raw data and package it up into a COVID datasette site. I’ve added some 7-day running average columns to help with analysis, but it’s out there if you want to try it out. It has a built in query showing the added columns I made for 7 day rolling averages of currently hospitalized people, daily positive test results, daily deaths, daily number of tests, and pending tests (though it seems this is no longer reported for most states). To plot anything, just hit the “show charting options” button. Feel free to give it a try.