Spotify Stats and other scripts
I requested my full listening history from Spotify this winter after seeing year after year of Spotify generated year end playlists. Regrettably, my Spotify account is only a few years old, going back to December of 2018 but I was still able to find some interesting facts out from my full listen history.
This is a work in progress, please let me know if you find errors. I'm still an SQL noob.
Queries here: Queries Reference
Here is DB Browser doing a query
Here is the finished playlist on Spotify
Here is the date checking script results from my data
This is wrong, I'm two days off because this is in GMT not Central. It's actually 18 days 2018: 0, 2019: 1, 2020: 10, 2021: 7
I got inspired to write the iCal script to make a more visual version. It takes the sqlite db and parses per day and creates iCal events in a file that I can import into my email. Below is that visualization. This also makes it easy to share my data to people who don't have the ability to parse through a SQLite database.