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 ascNo comparison cohort available for this artist yet — showing its own indexed series only.
Indexed 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 |
|---|---|---|
| Twentythree | 267k | +0.71% |
| CHARBO | 51k | +30.22% |
| Console Allstars | 56k | +86.25% |
| Erika | 376k | +12.50% |
| Janina | 55k | +111.59% |
| Mattyeux | 156k | +76.22% |
| pathetic240px | 178k | +21.09% |
| Sonic Mine | 109k | +7.13% |
| Lex Amarni | 236k | +0.98% |
| akkiemi | 64k | +51.37% |
| HellBlade | 87k | +55.96% |
| L.P. Rhythm | 130k | +26.87% |
| Luu | 66k | +55.29% |
| Roy Bee | 344k | +8.90% |
| azrxel | 80k | +16.97% |
| ProdArvee | 56k | +88.47% |
| DelinQuent | 120k | +1.42% |
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