{
  "$type": "site.standard.document",
  "canonicalUrl": "https://unnecessary.tech/posts/covid-data",
  "path": "/posts/covid-data",
  "publishedAt": "2020-08-05T12:45:42.000Z",
  "site": "at://did:plc:jx54v4rmscfwzit7fmgz24ba/site.standard.publication/3mnrsqmzz3w2e",
  "tags": [
    "data"
  ],
  "textContent": "I've been obsessively checking the [Washington Post Coronavirus Map][wapo_covid]\nto see how my state is doing, and to try to evaluate when it would be safe\nfor the kids to return to school. I wanted to be able to use the raw data, and\nthen I found [The COVID Tracking Project][covid_project]. The COVID Tracking\nProject offers an API to query COVID data, both nationally and on a state by\nstate basis. They also offer a raw download of the entire dataset.\n\nThe API is OK, but I wanted to be able to slice and dice the data, as well as\nmake simple plots. I remembered Simon Willison\nhad written a tool for [analyzing data using SQL][datasette], and that it had a plotting\nplugin. I decided to download the raw data and package it up into a [COVID\ndatasette site][covid_data]. I've added some 7-day running average columns to\nhelp with analysis, but it's out there if you want to try it out. It has a\n[built in query][sample_query] showing the added columns I made for 7 day\nrolling averages of currently hospitalized people, daily positive test results,\ndaily deaths, daily number of tests, and pending tests (though it seems this\nis no longer reported for most states). To plot anything, just hit the \"show\ncharting options\" button. Feel free to give it a try.\n\n[wapo_covid]: https://www.washingtonpost.com/graphics/2020/national/coronavirus-us-cases-deaths/?hpid=hp_no-name_hp-in-the-news%3Apage%2Fin-the-news&itid=hp_no-name_hp-in-the-news%3Apage%2Fin-the-news\n[covid_project]: https://covidtracking.com/\n[covid_data]: https://covid.unnecessary.tech/\n[datasette]: https://github.com/simonw/datasette\n[sample_query]: https://covid.unnecessary.tech/daily_covid/state_averages?state=ME",
  "title": "COVID Data"
}