The NBA Payroll Stack

{`select * from public.rows`}{`select * from public.rows`}{`select * from public.rows`} The NBA Payroll Stack {`select distinct season as value, season as label from source_wuVScy order by 1`} {`select distinct team as value, team_name as label from source_wuVScy where season = $season order by 2`} {` with base as ( select season, team, team_name, player, salary, cap, tax, first_apron, second_apron from source_wuVScy where season = $season ), totals as ( select team, sum(salary) as team_total from base group by 1 ), ranked as ( select b.*, t.team_total, row_number() over (partition by b.team order by b.salary desc, b.player) as player_rank from base b join totals t using (team) ), positioned as ( select *, coalesce(sum(salary) over ( partition by team order by salary desc, player rows between unbounded preceding and 1 preceding ), 0) as salary_start from ranked ) select p.season, p.team, p.team_name, p.player, p.salary, p.team_total, round(p.salary / 1000000.0, 2) as salary_m, round(p.team_total / 1000000.0, 2) as team_total_m, round(p.salary_start / 1000000.0, 3) as start_m, round((p.salary_start + p.salary) / 1000000.0, 3) as end_m, round((p.salary_start + p.salary / 2.0) / 1000000.0, 3) as center_m, 0.0 as team_label_x, case when p.player_rank = 1 then lg.logo end as logo, case when p.player_rank <= 5 then pf.pic end as pic, round(p.cap / 2000000.0, 3) as half_cap_m, round(p.cap / 1000000.0, 3) as cap_m, round(p.tax / 1000000.0, 3) as tax_m, round(p.first_apron / 1000000.0, 3) as first_apron_m, round(p.second_apron / 1000000.0, 3) as second_apron_m, p.player_rank, case when p.player_rank = 1 then '1 · largest' when p.player_rank = 2 then '2' when p.player_rank = 3 then '3' when p.player_rank % 2 = 0 then '4' else '5' end as salary_band, case when $team is null or p.team = $team then 1 else 0 end as selected from positioned p left join source_0AN7dH lg on lg.team = p.team left join source_T2sQyc pf on pf.player = p.player order by p.team_total desc, p.team, p.salary desc `} {` with base as ( select team, team_name, player, salary, case when player like '% III' then substr(player, 1, length(player) - 4) when player like '% Jr.' or player like '% Sr.' then substr(player, 1, length(player) - 4) when player like '% II' or player like '% IV' then substr(player, 1, length(player) - 3) when player like '% Jr' or player like '% Sr' then substr(player, 1, length(player) - 3) when player like '% V' then substr(player, 1, length(player) - 2) else player end as clean from source_wuVScy where season = $season and ($team is null or team = $team) ), agg as ( select team, min(team_name) as team_name, sum(salary) as team_total from base group by 1 ), ranked as ( select b.team, b.team_name, b.player, b.salary, a.team_total, substr(b.clean, instr(b.clean, ' ') + 1) as surname, row_number() over (partition by b.team order by b.salary desc, b.player) as player_rank from base b join agg a using (team) ) select r.team || '/' || r.player as id, r.team || '/root' as parent, r.team, r.team_name, r.player, r.surname, r.salary, r.team_total, r.player_rank, pc.pic, null as team_logo, r.team_name as head_name, null as head_total, r.salary * 1.0 / r.team_total as share, case when r.player_rank = 1 then '1 · largest' when r.player_rank = 2 then '2' when r.player_rank = 3 then '3' when r.player_rank % 2 = 0 then '4' else '5' end as salary_band from ranked r left join source_T2sQyc pc on pc.player = r.player union all select a.team || '/root', null, a.team, a.team_name, null, null, null, a.team_total, 0, null, lg.logo, a.team_name, '$' || printf('%.0f', a.team_total / 1000000.0) || 'm', null, null from agg a left join source_0AN7dH lg on lg.team = a.team order by team_total desc, team, player_rank `} {` with t as ( select team, sum(salary) as total, min(cap) as cap, min(tax) as tax, min(first_apron) as fa, min(second_apron) as sa from source_wuVScy where season = $season group by 1 ) select sum(case when total < cap then 1 else 0 end) as under_cap, sum(case when total >= cap and total < tax then 1 else 0 end) as over_cap, sum(case when total >= tax and total < fa then 1 else 0 end) as over_tax, sum(case when total >= fa and total < sa then 1 else 0 end) as apron_1, sum(case when total >= sa then 1 else 0 end) as apron_2 from t `} {` select min(cap) / 2000000.0 as half_cap_m, min(cap) / 1000000.0 as cap_m, min(tax) / 1000000.0 as tax_m, min(first_apron) / 1000000.0 as first_apron_m, min(second_apron) / 1000000.0 as second_apron_m from source_wuVScy where season = $season `} {` with base as ( select team, team_name, player, salary from source_wuVScy where season = $season and ($team is null or team = $team) ), totals as ( select team, sum(salary) as team_total from base group by 1 ) select team, player, salary, salary * 1.0 / team_total as share from base join totals using (team) order by salary desc `}

NBA · Payroll Stack

● Contracts snapshot · 02 Sep 2026

½ cap Cap Tax 1st apron 2nd apron

Teams by payroll tier

Under cap

Cap → tax

Tax → 1st apron

1st → 2nd apron

Over 2nd apron

= 25"}],"mark":{"type":"image","width":19,"height":16,"baseline":"middle"},"encoding":{"y":{"field":"team","type":"nominal","sort":{"field":"team_total_m","order":"descending"},"axis":null},"x":{"field":"start_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"xOffset":{"value":12},"url":{"field":"pic","type":"nominal"},"opacity":{"condition":[{"test":"datum.selected == 1","value":1}],"value":0.16}}},{"transform":[{"filter":"isValid(datum.pic) && datum.salary_m >= 25"}],"mark":{"type":"text","font":"Inter","fontSize":9,"fontWeight":600,"limit":80,"align":"left","dx":26},"encoding":{"color":{"condition":{"test":"datum.player_rank <= 3","value":"#ffffff"},"value":"#123047"},"y":{"field":"team","type":"nominal","sort":{"field":"team_total_m","order":"descending"},"axis":null},"x":{"field":"start_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"text":{"field":"player"},"opacity":{"field":"selected","type":"quantitative","scale":{"domain":[0,1],"range":[0,1]},"legend":null}}},{"transform":[{"filter":"datum.salary_m >= 25 && !(isValid(datum.pic) && datum.salary_m >= 25)"}],"mark":{"type":"text","font":"Inter","fontSize":9,"fontWeight":600,"limit":80,"align":"left","dx":6},"encoding":{"color":{"condition":{"test":"datum.player_rank <= 3","value":"#ffffff"},"value":"#123047"},"y":{"field":"team","type":"nominal","sort":{"field":"team_total_m","order":"descending"},"axis":null},"x":{"field":"start_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"text":{"field":"player"},"opacity":{"field":"selected","type":"quantitative","scale":{"domain":[0,1],"range":[0,1]},"legend":null}}},{"transform":[{"filter":"datum.player_rank == 1"}],"mark":{"type":"image","width":16,"height":16,"align":"right","baseline":"middle"},"encoding":{"y":{"field":"team","type":"nominal","sort":{"field":"team_total_m","order":"descending"},"axis":null},"x":{"field":"team_label_x","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"xOffset":{"value":-38},"url":{"field":"logo","type":"nominal"}}},{"transform":[{"filter":"datum.player_rank == 1"}],"mark":{"type":"text","align":"right","dx":-6,"font":"JetBrains Mono","fontSize":10,"fontWeight":700,"color":"#0f172a"},"encoding":{"y":{"field":"team","type":"nominal","sort":{"field":"team_total_m","order":"descending"},"axis":null},"x":{"field":"team_label_x","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"text":{"field":"team"}}},{"transform":[{"filter":"isValid(datum.half_cap_m)"}],"mark":{"type":"rule","color":"#64748b","strokeWidth":1.25},"encoding":{"x":{"aggregate":"min","field":"half_cap_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"tooltip":[{"aggregate":"min","field":"half_cap_m","type":"quantitative","title":"Half the cap","format":"$,.3f"}]}},{"transform":[{"filter":"isValid(datum.cap_m)"}],"mark":{"type":"rule","color":"#16a34a","strokeWidth":2},"encoding":{"x":{"aggregate":"min","field":"cap_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"tooltip":[{"aggregate":"min","field":"cap_m","type":"quantitative","title":"Salary cap","format":"$,.3f"}]}},{"transform":[{"filter":"isValid(datum.tax_m)"}],"mark":{"type":"rule","color":"#ca8a04","strokeWidth":2},"encoding":{"x":{"aggregate":"min","field":"tax_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"tooltip":[{"aggregate":"min","field":"tax_m","type":"quantitative","title":"Luxury tax","format":"$,.3f"}]}},{"transform":[{"filter":"isValid(datum.first_apron_m)"}],"mark":{"type":"rule","color":"#ea580c","strokeWidth":2},"encoding":{"x":{"aggregate":"min","field":"first_apron_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"tooltip":[{"aggregate":"min","field":"first_apron_m","type":"quantitative","title":"First apron","format":"$,.3f"}]}},{"transform":[{"filter":"isValid(datum.second_apron_m)"}],"mark":{"type":"rule","color":"#be123c","strokeWidth":2},"encoding":{"x":{"aggregate":"min","field":"second_apron_m","type":"quantitative","scale":{"domain":[0,240],"nice":false}},"tooltip":[{"aggregate":"min","field":"second_apron_m","type":"quantitative","title":"Second apron","format":"$,.3f"}]}}]}}} />

Roster shape · every contract on the team, sized by salary

44 && (datum.y1 - datum.y0) > 44) ? 1 : 0"}}}},{"type":"text","from":{"data":"leaves"},"encode":{"update":{"x":{"signal":"(datum.x0 + datum.x1) / 2"},"y":{"signal":"(datum.pic != null && (datum.x1 - datum.x0) > 44 && (datum.y1 - datum.y0) > 44) ? datum.y0 + 9 : (datum.y0 + datum.y1) / 2"},"align":{"value":"center"},"baseline":{"value":"middle"},"text":{"field":"surname"},"font":{"value":"Inter"},"fontSize":{"value":9},"fontWeight":{"value":600},"limit":{"signal":"max(0, datum.x1 - datum.x0 - 4)"},"fill":{"signal":"datum.player_rank <= 3 ? '#ffffff' : '#123047'"},"opacity":{"signal":"(datum.x1 - datum.x0) > 32 && (datum.y1 - datum.y0) > 12 ? 1 : 0"}}}}]}}} />