Return to Search

Medicaid Analytic eXtract MAX Rx

Guidance for Statistical Compendium table listing that enables users to choose to view Medicaid prescription drug tables for 1999 - 2009, and to select the tables for the nation as a whole or for individual states.

Issued by: Centers for Medicare & Medicaid Services (CMS)

Issue Date: January 01, 2020

The Statistical Compendium table listing (below) enables users to choose to view Medicaid prescription drug tables for 1999 - 2009, and to select the tables for the nation as a whole or for individual states. Within each zip file, you will find tables that focus on Medicare-Medicaid dual eligibles, nonduals, and all Medicaid beneficiaries combined.

The number of RX compendium tables varies by year, as indicated in this table:

Enrollee Groups

Years	All	Duals	Non-Duals	States¹	Number of Table Sets
1999	*	*		All	104
2000					0
2001	*	*	*	All	156
2002	*	*	*	All	156
2003	*	*	*	All	156
2004	*	*	*	All	156
2005	*	*	*	Excludes Maine	153
2006	*	*	*	Excludes Maine	153
2007	*	*	*	Excludes Maine	153
2008	*	*	*	Excludes Maine	153
2009	*	*	*	Excludes Hawaii, Idaho, Maine, Missouri, New Hampshire, Oklahoma, Utah, and Wisconsin	132

¹ Includes the District of Columbia and a separate file for the U.S. total. In some years, states were excluded because their Medicaid Statistical Information System (MSIS) files were unavailable or contained significant data problems.

Users can select subsets of these tables using the “filter on” feature by typing one or more key words in the “filter on” box. For example, typing “California” in the box would list all California tables.

HHS is committed to making its websites and documents accessible to the widest possible audience, including individuals with disabilities. We are in the process of retroactively making some documents accessible. If you need assistance accessing an accessible version of this document, please reach out to the guidance@hhs.gov.

DISCLAIMER: The contents of this database lack the force and effect of law, except as authorized by law (including Medicare Advantage Rate Announcements and Advance Notices) or as specifically incorporated into a contract. The Department may not cite, use, or rely on any guidance that is not posted on the guidance repository, except to establish historical facts.