[simonw]

Made my own map:

    brew install datasette sqlite-utils

    curl 'https://groundhog-day.com/api/v1/predictions?year=2023' | \
      jq .predictions | \
      sqlite-utils insert day.db groundhogs - --flatten

    sqlite-utils convert day.db groundhogs \
      groundhog_coordinates --multi 'return {
      "latitude": value.split(",")[0],
      "longitude": value.split(",")[1]
    }'

    datasette install datasette-cluster-map
    datasette day.db

Screenshot of the map here: https://fedi.simonwillison.net/@simon/109796889732947452

sqlite-utils docs here: https://sqlite-utils.datasette.io/en/stable/cli.html