Not exactly what you're describing, but here's where someone did a fairly detailed analysis of which federal, state, and local programs their salary goes to using a Sankey diagram:
https://www.reddit.com/r/dataisbeautiful/comments/lkfjea/oc_...