Comment

Comment by simonw

If anyone wants the raw data, it's available in window._Flourish_data variable on https://flo.uri.sh/visualisation/16818696/embed

Which means you can extract it with my https://shot-scraper.datasette.io/ tool like this:

    shot-scraper javascript \
      'https://flo.uri.sh/visualisation/16818696/embed' _Flourish_data \
      > /tmp/data.json

That's a 25MB file.

I loaded it into SQLite like this:

    cat /tmp/data.json | jq .events | \
      sqlite-utils insert /tmp/shots.db locations -

Then opened it up in Datasette with https://datasette.io/plugins/datasette-cluster-map to see them on a map.

parent simonw 2 years ago

Discussion