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 |
|---|---|---|
| Hank Williams III | 205k | +0.63% |
| Ray Wylie Hubbard | 91k | +1.31% |
| Ryan Bingham | 233k | +1.69% |
| Cody Jinks | 145k | +5.39% |
| Sturgill Simpson | 383k | +2.40% |
| Cross Canadian Ragweed | 92k | +1.11% |
| Scott H. Biram | 95k | — |
| Hayes Carll | 148k | +0.83% |
| Whitey Morgan and the 78's | 59k | +2.41% |
| Whiskey Myers | 294k | +14.84% |
| Jamey Johnson | 231k | +1.51% |
| Robert Earl Keen | 144k | +1.07% |
| Blackberry Smoke | 132k | +1.63% |
| Chris Knight | 72k | +0.02% |
| The Steel Woods | 32k | +2.15% |
| Waylon Jennings | 734k | +1.77% |
| Brent Cobb | 202k | +3.80% |
| American Aquarium | 50k | +1.93% |
| Charlie Daniels | 134k | +0.44% |
| Roger Alan Wade | 63k | +2.55% |
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