Previously and for more context:

First, I created a two table SQLite database using Simon Willison’s csvs-to-sqlite

  • one table for 2019-roland-flickr-metadata.csv and one table for 2020-roland-flickr-metadata.csv
csvs-to-sqlite *.csv -dt datetaken -dt dateupload \
-dt lastupdate roland2019-2020.db

Then, I uploaded it to Dropbox because at 67 Megabytes it’s too large for github

Leave a comment on github