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 |
|---|---|---|
| Wolfgang Gartner | 503k | +0.34% |
| Quintino | 233k | +1.51% |
| Adrian Lux | 314k | — |
| Hardwell | 775k | +1.22% |
| Autoerotique | 134k | — |
| Nicky Romero | 514k | +0.89% |
| Moguai | 367k | +0.88% |
| Laidback Luke | 423k | +1.30% |
| Bingo Players | 673k | +1.56% |
| Dannic | 119k | +1.03% |
| Chuckie | 219k | +0.80% |
| Felguk | 127k | — |
| Cazzette | 478k | — |
| Feed Me | 637k | +0.49% |
| Afrojack | 977k | +1.55% |
| Axwell | 653k | +0.99% |
| Swedish House Mafia | 2.8M | +2.72% |
| DVBBS | 641k | +2.39% |
| Don Diablo | 703k | +1.83% |
| Borgeous | 200k | +0.73% |
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