music

Custom SQL query

Tables

albums

id, artists_id, mbid, name, plays

42,156 rows

artists

id, url, name, image, mbid, plays

18,141 rows

listens

tracks_id, date_uts, date_#text, loved, @attr_nowplaying

240,002 rows

tracks

id, albums_id, mbid, name, image, url, streamable, tracks_id, avg_estimated_duration, plays, total_estimated_listen_time

66,806 rows

... and 15 hidden tables

Views

Download SQLite DB: music.db 72.7 MB