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 ascselect
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 |
|---|---|---|
| Aaron Cherof | 140k | +10.48% |
| Lena Raine | 443k | +4.58% |
| Tobias Lilja | 64k | — |
| Amos Roddy | 69k | +4.77% |
| fingerspit | 80k | — |
| Alec Holowka | 114k | +4.35% |
| Sound Ideas | 73k | +3.65% |
| Ben Prunty | 139k | +2.55% |
| Kane Parsons | 87k | +1.81% |
| Aphex Twin | 3.1M | +1.80% |
| Aperture Science Psychoacoustics Laboratory | 53k | +0.72% |
| In Love With a Ghost | 482k | +1.27% |
| The Caretaker | 364k | +9.15% |
| Tomáš Dvořák | 133k | +4.32% |
| Boards of Canada | 2.1M | +2.30% |
| Valve | 166k | +2.54% |
| TileKid | 421k | +4.10% |
| Berlinist | 180k | +1.85% |
| my head is empty | 559k | +5.06% |
| Alvedon | 378k | +7.96% |
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