Medicare Drug Stats

Clinical Use Cases

• Formulary cost management: A health plan pharmacy director can query total Medicare spending for all drugs within a therapeutic class (e.g., PCSK9 inhibitors), compare per-unit costs, and identify the most cost-effective formulary choices supported by real utilization data.
• Prescribing pattern benchmarking: A medical director at an ACO can pull prescribing data for all primary care providers in their network, compare opioid prescribing rates against regional and national benchmarks, and identify outlier prescribers for targeted education.
• Drug pricing research: A health economist studying insulin affordability can track year-over-year spending per beneficiary for all insulin products in the Medicare Part D program, quantify the impact of manufacturer rebates, and model projected savings from proposed policy changes.
• Hospital efficiency analysis: A hospital administrator can compare their facility's average Medicare payment and length of stay for a specific DRG against peer hospitals in the same region, identifying opportunities for cost reduction and care pathway improvement.

Safety & Evidence

• Safety Classification: Safe -- This skill queries publicly available, de-identified CMS administrative datasets. It does not access individual patient records, contain protected health information, or make clinical recommendations. All data is aggregate-level and publicly released by the U.S. federal government.
• Evidence Level: High -- CMS datasets are the authoritative source for U.S. Medicare program utilization and spending data. These datasets are used extensively in peer-reviewed health services research, congressional reports, and federal policy analysis. Data undergoes rigorous quality checks before public release.

Example Usage

Analyze drug spending trends:

Query Medicare Part D drug spending data for semaglutide (Ozempic
and Wegovy) from 2020 to 2024. Show total spending, number of
beneficiaries, per-beneficiary cost, and year-over-year percentage
change. Compare against liraglutide (Victoza) for the same period.

Examine prescribing patterns by region:

Pull Medicare prescriber data for all opioid prescriptions in
West Virginia, Kentucky, and Ohio for 2023. Aggregate by state
and show total claim counts, total beneficiaries, and per-capita
opioid prescribing rate. Compare to the national average.

Technical Details

• Category: Administrative
• Author: OMS Contributors (original: openpharma-org)
• License: MIT
• API: Socrata Open Data API (SODA) for CMS datasets
• Key Datasets: Medicare Part D Spending by Drug, Medicare Provider Utilization and Payment, Medicare Part D Prescribers, Inpatient Prospective Payment System (IPPS)
• Data Source: Centers for Medicare & Medicaid Services (data.cms.gov)
• Rate Limits: 1,000 requests/hour without app token; higher limits with free Socrata app token
• Dependencies: HTTP client (curl/fetch), JSON parser, SoQL query syntax

References

• CMS Data Portal: https://data.cms.gov/
• Socrata Open Data API (SODA) Documentation: https://dev.socrata.com/
• Medicare Part D Drug Spending Dashboard: https://data.cms.gov/summary-statistics-on-use-and-payments/medicare-medicaid-spending-by-drug/medicare-part-d-spending-by-drug
• Medicare Provider Utilization and Payment Data: https://data.cms.gov/provider-summary-by-type-of-service
• CMS Research, Statistics, Data & Systems: https://www.cms.gov/data-research

This skill is part of Open Medical Skills, a curated marketplace of medical AI skills maintained by physicians for physicians and the healthcare industry.