select
snapshot_date, week_number, listeners, playcount,
listener_delta, listener_pct_change, listeners_indexed
from api_artist_timeseries
where artist_id = $1
order by snapshot_date ascIndexed to 100 at each series' first observation.
select
ts.snapshot_date, ts.week_number, ts.listeners, ts.listeners_indexed,
cw.artist_count, cw.p25_indexed, cw.median_indexed, cw.p75_indexed
from api_artist_timeseries ts
left join api_cohort_weekly cw
on cw.cohort_type = $2 -- 'genre' or 'size_band'
and cw.cohort_key = $3 -- primary_genre or size_band
and cw.snapshot_date = ts.snapshot_date
where ts.artist_id = $1
order by ts.snapshot_date asc| Artist | Listeners | 13-week growth |
|---|---|---|
| John Norum | 41k | +1.13% |
| Vandenberg | 46k | +1.16% |
| Y&T | 167k | +1.03% |
| TNT | 300k | +4.70% |
| Zebra | 54k | — |
| The Firm | 118k | +0.94% |
| Fair Warning | 23k | — |
| Badlands | 46k | — |
| Whitesnake | 1.8M | +2.03% |
| Lynch Mob | 74k | +1.11% |
| Mr. Big | 794k | +1.18% |
| McAuley Schenker Group | 35k | — |
| Alcatrazz | 99k | — |
| Michael Schenker | 40k | +0.32% |
| Winger | 311k | +1.24% |
| Michael Schenker Group | 200k | +0.56% |
| Thin Lizzy | 1.6M | +1.26% |
| Wild Horses | 16k | — |
| Coverdale/Page | 139k | +0.17% |
| Stone Fury | 16k | — |
select
similar_artist_id, slug, display_name, size_band,
latest_listeners, total_pct_growth, weeks_tracked, similarity_score, rank
from api_artist_similar
where artist_id = $1
order by rank ascselect *
from api_artist_profile
where artist_id = $1