data.medicaid.govHand-written summary
State Drug Utilization Data
Covered outpatient drugs paid for by state Medicaid agencies, by state, drug name and National Drug Code, with prescriptions and dollars reimbursed.
Freshness
- Last posted
- Period covered
- Update frequency
- Every 10 years
Dates as CMS lists them in its catalog.
Before you use it
- Each year is a separate file on data.medicaid.gov. The newest year is linked here and older years are listed under versions.
Columns 15
| Column | What it means | Type |
|---|---|---|
Record IDutilization_type | Constant of “FFSU” or “MCOU” - The FFSU Record ID indicates that the information for this NDC represents a Fee-for-Service Utilization record. The MCOU Record ID indicates that the information for this NDC represents a Managed Care Organization Utilization record. Valid Values: 4Q2009 and earlier = Constant record of FFSU 1Q2010 and beyond = FFSU & MCOU | string |
State Codestate | State Abbreviation - Two character post office abbreviation for State | string |
NDCndc | The National Drug Code (NDC) is a numerical code maintained by the FDA that includes the labeler code, product code, and package code. The NDC is an 11-digit code. | string |
Labeler Codelabeler_code | NDC #1 - First segment of National Drug Code that identifies the manufacturer, labeler, relabeler, packager, repackager or distributor of the drug. | string |
Product Codeproduct_code | NDC #2 - Second segment of National Drug Code | string |
Package Sizepackage_size | NDC #3 - Third segment of National Drug Code | string |
Yearyear | Calendar year covered by data. | integer |
Quarterquarter | Calendar quarter covered by data. Valid values: 1 = January 1 - March 31 2 = April 1 - June 30 3 = July 1 - September 30 4 = October 1 - December 31. | integer |
Suppression Usedsuppression_used | string | |
Product FDA List Nameproduct_name | Product Name as appears on FDA listing form (1st 10 characters). | string |
Units Reimbursedunits_reimbursed | The total number of units (based on Unit Type) of the drug (11-digit NDC level) reimbursed by the state during the period covered. [Numeric 15 positions: 11 whole numbers, decimal (.), 3 decimals] (99999999999.999). | number |
No. of Prescriptionsnumber_of_prescriptions | The number of prescriptions reimbursed (by the Medicaid Program ONLY) to pharmacists for the (11-digit NDC) drug for the period covered. [Numeric 9 whole numbers] (999999999). | integer |
Total Amount Reimbursedtotal_amount_reimbursed | The total amount reimbursed by both Medicaid and non-Medicaid entities to pharmacies for the (11-digit NDC) drug in the period covered (two below fields added together). This total is not reduced or affected by Medicaid rebates paid to the state. This amount represents both the Federal and State Reimbursement and is inclusive of dispensing fees. [Numeric 15 positions: 12 whole numbers, decimal (.), 2 decimal places] (999999999999.99). | number |
Medicaid Amount Reimbursedmedicaid_amount_reimbursed | The amount reimbursed (by the Medicaid Program ONLY) to pharmacies for the (11-digit NDC) drug in the period covered. ([Numeric 13 positions: 10 whole numbers, decimal (.), 2 decimal places] (9999999999.99). | number |
Non-Medicaid Amount Reimbursednon_medicaid_amount_reimbursed | The amount reimbursed (by non-Medicaid entities) to pharmacies for the (11-digit NDC) drug in the period covered. The Non-Medicaid Amount Reimbursed includes any reimbursement amount for which the state is not eligible for Federal Matching Funds. [Numeric 13 positions: 10 whole numbers, decimal (.), 2 decimal places] (9999999999.99). | number |
No column matches that filter.
At a glance
- Catalog
- data.medicaid.gov
- Publisher
- Centers for Medicare & Medicaid Services (CMS), data.medicaid.gov
- Rows
- 1,287,884
- Columns
- 15
- State column
state- Contact
- Medicaid.gov@cms.hhs.gov
API
Free, no key needed. This request returns the first 10 rows as JSON:
https://data.medicaid.gov/api/1/datastore/query/2957a7f9-9a15-453e-9afd-3bbdcbac8fd3/0?limit=10
To keep only one state, filter on the state column.
Versions 36
The newest version is the one linked above. Older releases stay on the official site.
- 2026posted Jul 10, 2026
- 2025posted Jul 13, 2026
- 2024posted Jul 13, 2026
- 2023posted Jul 13, 2026
- 2022posted Jul 13, 2026
- 2021posted Jul 13, 2026
- 2020posted Jul 13, 2026
- 2019posted Apr 3, 2026
Show 28 older versions
- 2018posted Apr 3, 2026
- 2017posted Apr 3, 2026
- 2016posted Apr 3, 2026
- 2015posted Apr 3, 2026
- 2014posted Apr 3, 2026
- 2013posted Apr 3, 2026
- 2012posted Apr 3, 2026
- 2011posted Apr 3, 2026
- 2010posted Apr 3, 2026
- 2009posted Apr 3, 2026
- 2008posted Apr 3, 2026
- 2007posted Apr 3, 2026
- 2006posted Apr 3, 2026
- 2005posted Apr 3, 2026
- 2004posted Apr 3, 2026
- 2003posted Apr 3, 2026
- 2002posted Apr 3, 2026
- 2001posted Apr 3, 2026
- 2000posted Apr 3, 2026
- 1999posted Apr 3, 2026
- 1998posted Apr 3, 2026
- 1997posted Apr 3, 2026
- 1996posted Apr 3, 2026
- 1995posted Apr 3, 2026
- 1994posted Apr 3, 2026
- 1993posted Apr 3, 2026
- 1992posted Apr 3, 2026
- 1991posted Apr 3, 2026
CMS's description
Drug utilization data are reported by states for covered outpatient drugs that are paid for by state Medicaid agencies since the start of the Medicaid Drug Rebate Program. The data includes state, drug name, National Drug Code, number of prescriptions and dollars reimbursed. Data descriptions are available on Medicaid.gov: https://www.medicaid.gov/medicaid/prescription-drugs/state-drug-utilization-data/state-drug-utilization-data-faq/index.html
The summary at the top was written by hand from this description. Record id mcd:2957a7f9-9a15-453e-9afd-3bbdcbac8fd3. This record as JSON.