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 |
|---|---|---|
| Samia | 587k | +3.95% |
| girlpuppy | 138k | +4.90% |
| Blondshell | 393k | +6.64% |
| Rosie Tucker | 98k | +1.10% |
| Truman Sinclair | 81k | +13.69% |
| Dora Jar | 298k | +3.33% |
| Indigo De Souza | 733k | +4.79% |
| Claud | 361k | +1.34% |
| Tommy Lefroy | 326k | +1.27% |
| Miya Folick | 308k | +1.17% |
| The Greeting Committee | 360k | +1.64% |
| quinnie | 506k | +2.12% |
| Hannah Jadagu | 217k | +4.59% |
| Wallice | 257k | +1.43% |
| Devon Again | 234k | +10.27% |
| MUNA | 787k | +2.87% |
| SASAMI | 305k | +1.30% |
| Daisy the Great | 297k | +3.49% |
| Remi Wolf | 1.0M | +4.50% |
| Haley Blais | 190k | — |
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