# Animated choropleth of vaccinations by US county

<https://simonwillison.net/2021/Apr/4/animated-choropleth-of-vaccinations-by-us-county/>

- Host: [simonwillison.net](https://links.thingelstad.xyz/hosts/simonwillison.net/)
- Saved: April 5, 2021 (2021-04-06T01:27:11Z)
- Record: https://links.thingelstad.xyz/links/d4a5c8dc75f1/
- JSON: https://links.thingelstad.xyz/links/d4a5c8dc75f1.json

## What Jamie wrote

I so love this post from Willison, the creator of [Datasette](https://datasette.io). 

> 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](https://wikiapiary.com/wiki/) 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.** 🤘

## Facts

- Kind: [Page](https://links.thingelstad.xyz/kinds/page/)

## Appears in

- [WT181: Weekly Thing #181 / Grit, Collectible, Crypto](https://weekly.thingelstad.com/archive/181/), Recommended Links

## Same host

- [Git scraping: track changes over time by scraping to a Git repository](https://links.thingelstad.xyz/links/e989627ee1a1/) (simonwillison.net, October 15, 2020)
- [Personal Data Warehouses: Reclaiming Your Data](https://links.thingelstad.xyz/links/e16be8656c6f/) (simonwillison.net, November 19, 2020)
- [Datasette Desktop — a macOS desktop application for Datasette](https://links.thingelstad.xyz/links/ebeca422f155/) (simonwillison.net, September 12, 2021)
- [It looks like I’m moving to Mastodon](https://links.thingelstad.xyz/links/1641ae7ee6bb/) (simonwillison.net, November 10, 2022)
- [What to blog about](https://links.thingelstad.xyz/links/bde4b4669c29/) (simonwillison.net, November 10, 2022)

## Saved the same week

- [1729 - Learn Skills & Earn Crypto](https://links.thingelstad.xyz/links/5b895f552b6e/) (1729.com, April 5, 2021)
- [How to Value an NFT (or any Collectible) - The Contrarian Mindset](https://links.thingelstad.xyz/links/c070c4a340a4/) (contrarianmindset.substack.com, April 5, 2021)
- [Novel HIV vaccine approach shows promise in “landmark” trial](https://links.thingelstad.xyz/links/04675807b28e/) (europeanpharmaceuticalreview.com, April 5, 2021)
- [grit: A multitree-based personal task manager](https://links.thingelstad.xyz/links/eb99f37bbe2b/) (github.com, April 5, 2021)
- [Balaji Srinivasan on The Future of Bitcoin and Ethereum, How to Become Noncancelable, the Path to Personal Freedom and Wealth in a New World, the Changing Landscape of Warfare, and More (#506) – The Blog of Author Tim Ferriss](https://links.thingelstad.xyz/links/1a266302ddb8/) (tim.blog, April 5, 2021)

## Elsewhere

- Wayback Machine: https://web.archive.org/web/*/https://simonwillison.net/2021/Apr/4/animated-choropleth-of-vaccinations-by-us-county/