Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information Files for Order

Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information Files for Order

ATTENTION: Beginning in January 2021, these files are available as free downloads. Please note that these are large files and can take time to download.  The last two years of files (CY2019 and CY2020) are also available to download for free.  Please see the following link for these downloads:

To purchase older files, follow the directions below.

Overview of File: The Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information Files contain formulary, pharmacy network, and pricing data for Medicare Prescription Drug Plans and Medicare Advantage (MA) Prescription Drug Plans (with the exception of employer and Program of All-Inclusive Care for the Elderly plans). These non-identifiable files are available on a monthly and a quarterly basis and are comprised of the following tables:

  • Plan Information - Information such as plan name, contract ID, plan ID, service area, and plan type
  • Geographic Locator - MA and Prescription Drug Plans region codes and county codes
  • Formulary - Formulary details for each plan including National Drug Codes (NDCs), cost share tier level, and indicators for step therapy, quantity limits, and prior authorization
  • Beneficiary Cost - Plan level cost sharing details for preferred, non-preferred, and mail order network pharmacies
  • Pharmacy Network - National Provider Identifier (NPI) numbers for each network pharmacy including preferred, retail, and mail order indicators
  • Drug pricing - Plan level average monthly costs for formulary Part D drugs (note: this table is only available in the quarterly files) Data dictionaries for each table and information on how to link across the tables is available in the record layout in the Downloads section below. The record layout and data dictionary for the formulary file are subject to change.

Before beginning the process to request these files, please read the “Terms and Conditions for Use of Part D Formulary, Pharmacy Network, and Pricing Information” in the Downloads section below. This document contains important information regarding timeframes for obtaining data as well as data accuracy and integrity.

Data Availability Notes: These data are available in monthly or quarterly files. The first monthly data available is December 2005. The first quarterly data available is quarter 1 (January – March) of 2009.

Please note: The new year of Prescription Drug Plan data becomes available in October. The new year of data will begin to be reported in the October monthly file and in the January quarterly file (i.e., year 2018 data is available in the October 2017 monthly file and the January 2018 quarterly file). Drug pricing data is only available in quarterly files.

Cost: File cost differs between the monthly files and the quarterly files.

Monthly: $250.00 per month  

Quarterly: $750.00 per quarter

Data Format: CSV text file

Approximate Size: 2.5 GB

Media: CD-ROM or DVD

Compatible Software Programs: Microsoft SQL/DB2/Oracle, SAS or other statistical software. (Note: Microsoft Excel, Microsoft Access, or TextPad cannot be used to analyze the formulary files.)

Notes or Special Instructions: These record layout files can be downloaded from the files below.

Page Last Modified:
09/06/2023 04:57 PM