Welcome to the California Department of Health Care Services 

Medi-Cal Beneficiaries - Medicare/Medi-Cal Pivot Table

Medicare related aid codes:  80, 8A, 8C, and 8D.
Medi-Cal Beneficiaries by County, Aid Code, Health Care Plan, Age, Other Health Coverage, Special Aid Code, Special Aid Code County, Medicare Part A B D, and Month of Eligibility

The file has a Readme, a PivotTable, and a Data tab, and were created in Microsoft Excel. Note that PivotTables were added to permit the user to summarize and analyze the SOC data interactively. You can visit the MCSS General Information page and view MCSS's
Tips for Manipulating Microsoft's Excel Pivot Tables

Please view the "Readme" file before initiating the download

January 2003 thru April 2008
Download Excel Table (2.2M compressed and 14.5M uncompressed)

For Mac Users
The following files are compressed with WinZip and are not self-extracting.

Please send comments and suggestions regarding the Medical Care Statistics Section Website to: Medical Care Statistics Section

 

MCSS Home