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.

https://towardsdatascience.com/using-python-to-create-spotify-playlists-of-the-samples-on-an-album-e3f20187ee5e