Data Investigation

The Trillion Dollar Network

A visual journey through $1.09 trillion in Medicaid spending. Seven years of claims data. 617,000 providers. Every dollar traced.

$0T

Total Spending

0K

Providers

0M

Records

Top 1% of providers account for 80% of all spending

Chapter 1

Every Dollar Tells a Story

Before we can follow the money, we need to grasp the sheer magnitude of what we are looking at. These are not abstractions - they are the vital signs of America's safety net.

Scale

$1.09T

= $4,400 per American

Total Medicaid provider payments across 7 years of claims data. Enough to buy every NFL team five times over.

Reach

618K

unique providers

From solo practitioners to billion-dollar hospital systems. Each one touches lives - and collects taxpayer dollars.

Depth

11,881

procedure codes

Every office visit, emergency response, therapy session, and drug injection - cataloged and priced.

Where does the money go?

Chapter 2

The Rising Tide

Monthly Medicaid spending from January 2018 to December 2024. Watch a pandemic reshape spending patterns, followed by an unprecedented surge - and then a sudden cliff.

$0$4.5B$9.0B$13.5B$18.0B2018201920202021202220232024COVID dip Apr 20202024 cliff

Chapter 3

The Power Law

Medicaid spending follows a brutal concentration curve. A tiny fraction of providers collect the vast majority of payments. This is not a bell curve - it's a power law.

0%0%25%25%50%50%75%75%100%100%% of Providers (ranked by spending)% of Total Spending18% providers = 80% spending
1%

Top 1% of providers

~50% of spending

10%

Top 10%

~27% of spending

80%

Bottom 80%

<7% of spending

G

Gini Coefficient

~0.84 (extreme)

Chapter 4

The Connectors

Behind the numbers lies a network. Providers refer patients to each other, creating invisible corridors through which billions flow. Some nodes sit at critical junctions - the connectors who move the most money.

Community 1
Community 2
Community 3
Community 4
Community 5
Community 6

91

Provider Nodes

13

Referral Edges

$476.3M

Top Link Value

Chapter 5

Where the Money Goes

The top 20 procedure codes by total spending. Personal care services dwarf everything else - a sign of the long-term care system that Medicaid has become.

T1019$122.7BT1015$49.2BT2016$34.9B99213$33.0BS5125$31.3B99214$29.9B99284$20.2BH2016$19.7B99283$16.9BH2015$16.5B99285$15.1B90837$12.1BS5102$9.3B90834$8.8BT2021$8.7BH2017$8.5BT1017$8.4BT1020$8.2B90999$7.7BA0427$7.7B
Personal Care
Office Visit
Emergency
Mental Health
Residential
Attendant Care
Community Support
Clinic Visit
Case Management
Ambulance
Dialysis

Chapter 6

The Few Who Move Billions

Meet the top 25 Medicaid providers by total spending. Each NPI represents an entity - a hospital system, a pharmacy benefit manager, a home care agency - that commands billions in public funds.

RankNPITotal SpendingClaimsAvg Cost/Claim
11417262056$7.2B90M$80
21699703827$6.8B31M$220
31376609297$5.6B64M$88
41699725143$3.1B108M$29
51922467554$3.0B22M$138
61710176151$2.7B36M$75
71629436241$2.6B16M$159
81982757688$2.3B2M$1K
91538649983$2.1B22M$95
101528263910$1.7B5M$371
111962650622$1.7B11M$150
121720151046$1.5B8M$186
131356709976$1.5B5M$275
141396051694$1.4B9M$154
151538144910$1.4B104M$14
161447261540$1.4B9M$161
171750504064$1.3B2M$812
181417099789$1.3B6M$217
191073055208$1.3B11M$122
201376554592$1.2B2M$769
211518096411$1.1B2M$734
221700090834$1.1B15M$75
231780816991$1.1B7M$160
241275657553$1.1B8M$145
251134250475$1.1B1M$766

Click column headers to sort. NPI = National Provider Identifier.

Chapter 7

The Ecosystem

You have seen the numbers, the curves, and the connections. Now explore the full network yourself - an immersive canvas where every node is a provider, every edge a referral, and every dollar is traced.

Ready to explore the full network?

Interactive canvas with force-directed layout, zoom, search, and real-time filtering. See every connection in the $1.09 trillion ecosystem.

Explore the Full Network
Canvas renderingForce-directed layoutReal-time search
“The system isn't broken. It's working exactly as designed. The question is: designed for whom?”

Data source: HHS T-MSIS · 2018–2024