Animated choropleth of vaccinations by US county

I so love this post from Willison, the creator of Datasette.

My build_database.py script then iterates over the accumulated git history of that counties.json file and uses sqlite-utils to build a SQLite table:

Years ago I made a project called Wikiapiary that collected data from thousands of wikis. It used versions wiki pages to track a lot of data about the sites. Willison's use of git to track versions of JSON objects and then capturing the time-series data by marching through the revision history is a relative of that same wiki method. I just love the simplicity and beauty of this. 🤘