Others titles

  • Section 1927 of the Social Security Act
  • Drug Manufacturers National Rebate Agreement
  • Medicaid Drug Rebate Program Drugs Product Data


  • Medicare Rebate
  • 340b Drugs
  • Medicaid Gov
  • CMS Company
  • Drug Manufacturer
  • Drug Rebates
  • Drug Prices
  • Drug Rebate Reports

CMS Drug Manufacturer Rebate Drugs

The dataset consists of details of the most recent reports on covered outpatient active drugs by manufacturers participating in the Medicaid Drug Rebate Program of the Centers for Medicare and Medicaid Services (CMS) according to Section 1927 of the Social Security Act. The rebate drug product data file contains the active drugs that have been reported by participating drug manufacturers as of the most recent rebate reporting period under the Medicaid Drug Rebate Program.

Log in to download

Get The Data

For getting access to data download links please read and accept the end-user license agreement.
Your Data License
  • Research
    Non-Commercial, Share-Alike, Attribution Free Forever
  • Commercial
    Commercial Use, Remix & Adapt, White Label Log in to download


“The Medicaid Drug Rebate Program is a program that includes CMS, State Medicaid Agencies, and participating drug manufacturers that helps to offset the Federal and State costs of most outpatient prescription drugs dispensed to Medicaid patients. Approximately 600 drug manufacturers currently participate in this program.” (1) “It requires that drug manufacturers have a national rebate agreement with the Secretary of the Department of Health and Human Services (HHS) in order for states to receive Federal Medicaid coverage of their products.”(2) In the present data set drugs are presented with their National Drug Code, FDA product name, date of introduction to the market, among other details regarding the introduction and current status of the drug. It’s important to notice that “if a Market Date falls on a date that is earlier than 9/30/1990, CMS will change it to 9/30/1990 in both the Medicaid Drug Rebate (MDR) system and the Drug Data Reporting for Medicaid (DDR) system since dates earlier than the start of the Drug Rebate Program have no bearing on this aspect of the program.”(3)

Starting with the 3Q2014 drug product data file that will be posted in early November 2014, the file format for the drug product data file will be changed to include new FDA Application Number/OTC Monograph Number and Reactivation Date fields and to replace the Drug Efficacy Study Implementation (DESI) rating with the Covered Outpatient Drug (COD) status. Please note that the COD status and corresponding FDA Application Number/OTC Monograph Number field will contain blanks for those NDCs for which the manufacturers have not yet reported those fields to CMS. You may refer to the data definitions for more information regarding the valid values for each of these fields.

The drug product data file contains individual files for the current quarter plus the previous eight quarters. Please save and archive these files, including the file formats, for any future use you may have as we do not archive these files once posted and cannot honor individual requests for regenerated files. (Note: Only active drugs and drugs with a termination date on or after the last processed quarter are included in the file).

All drugs in the dataset are identified by National Drug Code (NDC), unit type, units per package size, product name, Food and Drug Administration (FDA) approval date, the date the drug entered the market, plus indicators to show whether the drug is an innovator or non-innovator drug; whether it is available by prescription or over-the-counter (OTC); the FDA therapeutic equivalency code; and the Drug Efficacy Study Implementation (DESI) rating and termination date, if applicable.

About this Dataset

Data Info

Date Created


Last Modified




Update Frequency


Temporal Coverage

1990 to 2020-07

Spatial Coverage



John Snow Labs; Centers for Medicare & Medicaid Services;

Source License URL

Source License Requirements


Source Citation

Centers for Medicare & Medicaid Service. Medicaid Drug Rebate Program. Published February, 2015. Accessed February 23, 2016. Wikipedia Medicaid Drug Rebate Program. https//en.wikipedia.org/wiki/Medicaid_Drug_Rebate_Program. Published November, 2013. Accessed February 23, 2016. Centers for Medicare & Medicaid Service. Drug Product Data Webfile Structure and Definitions. Published November, 2014. Accessed February 16, 2016.


Medicare Rebate, 340b Drugs, Medicaid Gov, CMS Company, Drug Manufacturer, Drug Rebates, Drug Prices, Drug Rebate Reports

Other Titles

Section 1927 of the Social Security Act, Drug Manufacturers National Rebate Agreement, Medicaid Drug Rebate Program Drugs Product Data

Data Fields

Name Description Type Constraints
YearThe year in which the data was submitteddate-
QuarterThe quarter of the year in which the data was submittedinteger-
Labeler_NameCompany associated with NDC 1string-
NDCNational drug codeinteger-
Labeler_CodeFirst segment of National Drug Code that identifies the labelerintegerlevel : Nominal
Product_CodeSecond segment of National Drug Codeintegerlevel : Nominal
Package_Size_CodeThird segment of National Drug Codeintegerlevel : Nominal
Drug_CategoryCategory of the drugstring-
Drug_Type_IndicatorIdentifies a drug as a prescription (Rx) or Over-the-counter (OTC).string-
Termination_DateDate drug was withdrawn from market or the drug's last lot expiration date.date-
Unit_TypeOne of the 8 unit types by which the drug can be dispensed.string-
Units_Per_Pkg_SizeTotal number of units in the smallest dispensable amount for the 11-digit NDCintegerlevel : Ratio
FDA_Approval_DateNDC or monograph approval datedate-
Market_DateFor S and I drugs, the Market Date is the date the drug was first marketed by the original labeler. If the S/I drug was purchased or otherwise acquired from another labeler, the Market Date should be equal to the Market Date of the original product. For N drugs, the Market Date is the date the drug was first marketed under the labeler’s rebate agreement. If an N drug was purchased or otherwise acquired from another labeler, the Market Date should be equal to the Market Date of the original product, if that date is available.date-
FDA_Ther_Equiv_CodeTherapeutic Equivalence Codestring-
FDA_Product_NameDrug name as approved by the FDAstring-
Is_Clotting_Factor_IndicatorIdentifies a Single Source or Innovator Multiple Source drug as a clotting factor.boolean-
Is_Pediatric_IndicatorIdentifies a Single Source or Innovator Multiple Source drug approved by the FDA exclusively for pediatric indications for patients in the FDA-defined pediatric age group.boolean-
Package_Size_Intro_DateThe date the package size is first available on the market.date-
Purchased_Product_DateThe date on which the company currently holding legal title to the NDC first markets the drug under this NDCdate-
COD_StatusCovered outpatient drug status. Identifies whether or not a product meets the statutory definition of a covered outpatient drug. NDCs with a COD Status of DESI 5/6 are not eligible for coverage or rebates under the Medicaid Drug Rebate Program.integerlevel : Nominal
FDA_Appl_NoFDA application number or OTC monograph numberstring-

Data Preview

YearQuarterLabeler NameNDCLabeler CodeProduct CodePackage Size CodeDrug CategoryDrug Type IndicatorTermination DateUnit TypeUnits Per Pkg SizeFDA Approval DateMarket DateFDA Ther Equiv CodeFDA Product NameIs Clotting Factor IndicatorIs Pediatric IndicatorPackage Size Intro DatePurchased Product DateCOD StatusFDA Appl No
20193ELI LILLY AND COMPANY2120001212001S1EA10002012-04-062012-05-01NRAMYVIDFalseFalse2012-05-013202008
20193ELI LILLY AND COMPANY2143301214331S1ML5002014-09-182014-10-20NRTRULICITYFalseFalse2014-10-202125469
20193ELI LILLY AND COMPANY21433802143380S1ML20002014-09-182014-10-20NRTRULICITYFalseFalse2014-10-202125469
20193ELI LILLY AND COMPANY2143401214341S1ML5002014-09-182014-10-20NRTRULICITYFalseFalse2014-10-202125469
20193ELI LILLY AND COMPANY21434802143480S1ML20002014-09-182014-10-20NRTRULICITYFalseFalse2014-10-202125469
20193ELI LILLY AND COMPANY2143601214361S1ML10002018-09-272018-10-08NREMGALITYFalseFalse2018-10-082761063
20193ELI LILLY AND COMPANY21436112143611S1ML10002018-09-272018-10-08NREMGALITYFalseFalse2018-10-082761063
20193ELI LILLY AND COMPANY2144501214451S1ML10002016-03-222016-04-15NRTALTZFalseFalse2016-04-152125521
20193ELI LILLY AND COMPANY2144509214459S1ML30002016-03-222016-04-15NRTALTZFalseFalse2016-05-032125521
20193ELI LILLY AND COMPANY21445112144511S1ML10002016-03-222016-04-15NRTALTZFalseFalse2016-04-152125521