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 |
|---|---|---|
| Nebu Kiniza | 412k | +3.85% |
| NLE Choppa | 1.5M | +2.89% |
| YNW Melly | 1.1M | +3.10% |
| Sleepy Hallow | 935k | +1.66% |
| Sheff G | 398k | +1.74% |
| Lil Skies | 889k | +3.48% |
| Roddy Ricch | 1.6M | +3.56% |
| Calboy | 300k | +1.92% |
| Rob $tone | 603k | +2.27% |
| Rich the Kid | 837k | +1.99% |
| A Boogie wit da Hoodie | 1.5M | +3.76% |
| Smokepurpp | 465k | +1.13% |
| $NOT | 886k | +1.93% |
| DaBaby | 1.6M | +4.33% |
| Moneybagg Yo | 762k | +3.22% |
| Tee Grizzley | 760k | +2.49% |
| YBN Nahmir | 748k | +2.85% |
| Kodak Black | 1.9M | +3.55% |
| Lil Mosey | 1.0M | +3.71% |
| Lil Tjay | 976k | +2.21% |
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