{"queries":[{"id":"trip","compiledQueryString":"select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000)","inputQueryString":"select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000)","compiled":false,"inline":true},{"id":"trip_stats","compiledQueryString":"select\n count(*) as listens,\n count(distinct track || artist) as tracks,\n count(distinct artist) as artists,\n count(distinct album) as albums\nfrom (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000))","inputQueryString":"select\n count(*) as listens,\n count(distinct track || artist) as tracks,\n count(distinct artist) as artists,\n count(distinct album) as albums\nfrom ${trip}","compiled":true,"inline":true},{"id":"trip_days","compiledQueryString":"select d::date as day, coalesce(n, 0) as listens\nfrom generate_series(date '2026-10-08', date '2026-10-19', interval 1 day) as g(d)\nleft join (\n select ts::date as day, count(*) as n from (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000)) group by 1\n) t on t.day = g.d::date\norder by 1","inputQueryString":"select d::date as day, coalesce(n, 0) as listens\nfrom generate_series(date '2026-10-08', date '2026-10-19', interval 1 day) as g(d)\nleft join (\n select ts::date as day, count(*) as n from ${trip} group by 1\n) t on t.day = g.d::date\norder by 1","compiled":true,"inline":true},{"id":"trip_artists","compiledQueryString":"select artist, count(*) as listens, count(distinct track) as tracks\nfrom (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000))\ngroup by artist\norder by listens desc\nlimit 10","inputQueryString":"select artist, count(*) as listens, count(distinct track) as tracks\nfrom ${trip}\ngroup by artist\norder by listens desc\nlimit 10","compiled":true,"inline":true},{"id":"trip_albums","compiledQueryString":"select album, artist, count(*) as listens\nfrom (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000))\nwhere album is not null\ngroup by album, artist\norder by listens desc\nlimit 5","inputQueryString":"select album, artist, count(*) as listens\nfrom ${trip}\nwhere album is not null\ngroup by album, artist\norder by listens desc\nlimit 5","compiled":true,"inline":true},{"id":"trip_tracks","compiledQueryString":"select track, artist, count(*) as listens\nfrom (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000))\ngroup by track, artist\norder by listens desc, track\nlimit 10","inputQueryString":"select track, artist, count(*) as listens\nfrom ${trip}\ngroup by track, artist\norder by listens desc, track\nlimit 10","compiled":true,"inline":true},{"id":"trip_all","compiledQueryString":"select\n strftime(ts, '%a %b %-d') as day,\n strftime(ts, '%-I:%M %p') as time,\n track,\n artist,\n album\nfrom (select *\nfrom music.listens\nwhere ts >= '2026-10-08' and ts < '2026-10-20'\n and (source <> 'spotify' or ms_played >= 30000))\norder by ts","inputQueryString":"select\n strftime(ts, '%a %b %-d') as day,\n strftime(ts, '%-I:%M %p') as time,\n track,\n artist,\n album\nfrom ${trip}\norder by ts","compiled":true,"inline":true}]}

Soundtrack to Ireland

Soundtrack to Ireland

Day by day

Top artists

Albums played most

Most-played tracks

Every listen