Medicare Part D Drug Spending and Prescribers Scraper

Get Medicare Part D data in clean rows you can export to CSV or Excel: what Medicare spends on every drug, how that changed over five years, and how doctors and clinics prescribe. The data is published by the Centers for Medicare and Medicaid Services (CMS), and the Actor reads the latest release on every run.

CMS publishes the figures as very large tables with one column group per year and many suppressed cells. This Actor turns them into answers: which drugs gained the most rank since 2020, what share of total Part D spending each drug takes, how fast the price per unit is growing, and for every prescriber the cost per claim, the brand and generic split, the opioid prescribing rate and how that compares with other prescribers of the same specialty in the same state.

What can you do with this Medicare Part D scraper?

• List the top 100 drugs by Medicare Part D spending in 2024 with claims, patients and cost per claim.
• See which drugs moved up the spending ranking the most since 2020.
• Check the price per unit trend for a drug such as semaglutide or insulin over five years.
• Find drugs whose spending grew more than 100 percent since 2020.
• List all family practice doctors in a state with total claims, drug cost and brand share.
• Find prescribers with an opioid prescribing rate above 10 percent.
• Compare a prescriber with peers of the same specialty in the same state.
• See the patient mix of a prescriber: average age, sex, race, dual eligible patients and risk score.
• Download the drugs a single prescriber wrote, with cost per claim and cost per 30 day fill.
• Build lead lists of high prescribing specialists in a city for pharma sales and market research.

Three ways to collect data

Mode	One row is	Best for
Drug spending and price trends	one drug (or drug and manufacturer)	market sizing, pricing studies, news
Prescribers	one doctor or clinic	targeting, benchmarking, research
Drugs prescribed by each prescriber	one prescriber and drug	brand share, switching, audits

What data do you get for a drug?

• Brand name, generic name, manufacturer and number of manufacturers.
• For each year from 2020 to 2024: total spending, claims, patients, dosage units, average spending per claim, per patient and per dosage unit, and an outlier flag.
• Spending rank in 2024 and 2020 and the change in rank.
• Share of total Part D spending in 2024.
• Spending change in the last year and since 2020, claims change since 2020, unit price change and unit price growth rate per year.

What data do you get for a prescriber?

• NPI, name, credentials, specialty, address, city, state, ZIP code and rural or urban class.
• Total claims, 30 day fills, drug cost, days supply and patients.
• Brand and generic claims and cost, claims for patients aged 65 and over.
• Opioid claims, cost and prescribing rate, long acting opioid rate, antibiotic claims and antipsychotic claims for older patients.
• Patient profile: average age, women and men, race groups, dual eligible patients and average risk score.
• Derived fields: cost per claim, cost per patient, claims per patient, brand share of claims and cost, opioid share, antibiotic share, share of patients aged 65 and over, dual eligible share, and the percentile of cost per claim among prescribers of the same specialty in the same state.

Input example

Top drugs by spending growth since 2020:

{
    "mode": "drugSpending",
    "sortBy": "growth",
    "maxItems": 100
}

Family practice doctors in Wyoming with at least 1,000 claims:

{
    "mode": "prescribers",
    "states": ["WY"],
    "specialties": ["Family Practice"],
    "minClaims": 1000
}

Output example

A real drug row, shortened:

{
    "brandName": "Ozempic",
    "genericName": "Semaglutide",
    "totalSpending2024": 12970296347,
    "spendingRank2024": 2,
    "spendingRank2020": 20,
    "rankChange2020To2024": 18,
    "shareOfTotalSpending2024Pct": 4.49,
    "spendingChange2020To2024Pct": 790.9,
    "avgSpendingPerClaim2024": 1245.09
}

How much does it cost?

You pay for each row returned, and the price per row drops with higher Apify subscription plans. Free accounts can test the Actor with up to 10 rows per run. A state with thousands of prescribers finishes in under a minute.

Frequently asked questions

Which years are covered? Drug spending covers 2020 to 2024. Prescriber data covers the latest year CMS has published, which is 2024.

Why are some prescriber values empty? CMS hides counts below 11 to protect patient privacy. Those cells are returned as null, never as text.

Does Part D include all prescriptions? No. It covers prescriptions paid by Medicare Part D plans. Cash, commercial insurance and Medicaid prescriptions are not included.

Do the numbers include rebates? No. Spending is before manufacturer rebates, so it is higher than the net cost to Medicare.

How do I use the specialty filter? Use the exact CMS specialty name, for example Family Practice, Internal Medicine, Cardiology or Nurse Practitioner.

Can I get every prescriber in the country? Add several states. The Actor asks for at least one state, specialty or NPI, because the full table has more than a million prescribers.

Limits

The Actor covers Medicare Part D only. Spending is before rebates, prescriber counts below 11 are hidden by CMS, and the data is published once a year. The data is public and published by the Centers for Medicare and Medicaid Services.