Currently Available Public Use Files
MN APCD logo

MN APCD Public Use Files

The Minnesota Department of Health (MDH) maintains the Minnesota All Payer Claims Database (MN APCD), a repository of health care claims data that supports statewide analyses of health care costs, quality, and utilization. MDH releases publically available summary data from the MN APCD in the form of public use files (PUFs). PUFs are available at no cost through web-based download. PUF data are formatted in spreadsheets with aggregated records that prevent the identification of individual members, providers, and health plans. During PUF development, MDH considers:

  • How to ensure compliance with data privacy guard rails required in statute
  • How to stratify the data in a way that is most useful to researchers
  • What documentation is needed to inform potential data users

We encourage users to send us questions, comments on existing PUFs, and suggestions for new PUF designs. Please email your feedback to health.apcd@state.mn.us.

Currently Available Public Use Files

This file is designed to analyze the distribution of health care service and procedural information for Minnesota residents. (Released: November 2018)

It presents the data in summarized form by age group and 3-digit ZIP code. Health care service information stems from the procedural or revenue codes reported on the medical claim using codes from the American Medical Association’s Current Procedural Terminology (CPT), the Centers for Medicare and Medicaid Services’ Healthcare Common Procedure Coding System (HCPCS), and the National Uniform Billing Committee Revenue Codes.

  • For example, this file permits identifying that in 2013, there were 120,283 claims for 25 minute outpatient office visits (CPT/HCPCS 99214) among 65,374 children and youth under the age of 18 in West Minneapolis (Zip Code 553), and that the combined spending for patient care related to the visits was about $16 million.

Descriptions of the procedural and revenue codes are not provided in this file. Code references may be obtained at:

For Level I HCPCS (CPT) codes, contact: The American Medical Association

For Level II HCPCS (non-CPT) codes, contact: The Centers for Medicare and Medicaid Services

For Revenue codes, contact: The National Uniform Billing Committee

For example analyses based on health care services information, please review MDH’s study on chronic pain procedures in Minnesota:

Chronic Pain Procedures in Minnesota, 2010-2012 (PDF)

This file is designed to analyze the distribution of diagnostic information recorded in health care use for Minnesota residents. (Released: November 2018)

It presents the data in summarized form by age group and 3-digit ZIP code. Diagnostic information stems from the primary diagnoses on the medical claim following the Clinical Modification of International Classification of Diseases, Ninth Revision (ICD-CM-9). It is summarized at the 3-digit level where it describes disease type or organ system.

  • For example, this file permits identifying that in 2013, there were 13,863 diagnoses for Streptococcal sore throat and scarlet fever (ICD-9-CM 034) among children and youth under the age of 18 in West Minneapolis (Zip Code 553), and that the combined spending for patient care related to the diagnoses was about $2 million.

Descriptions of the ICD-9 codes are not provided in this file. Code references may be obtained at CDC Classification of Diseases, Functioning, and Disability.

For example analyses based on diagnostic information, please review MDH’s recently published study on chronic disease in Minnesota:

Chronic Conditions in Minnesota: New Estimates of Prevalence, Cost and Geographic Variation for Insured Minnesotans, 2012 (PDF)

This file is designed to analyze common types of health care use by major categories, including hospital admission, use of ambulance services, clinic visits, and more for Minnesota residents. (Released: November 2018)

It presents the data in summarized form by age group and 3-digit ZIP code. Health care utilization information is derived using the place of service codes for professional services and type of bill codes for institutional claims as reported per the Centers for Medicare & Medicaid Service and National Uniform Billing Committee claim reporting standards.

  • For example, this file permits identifying that in 2013, there were 1,351,628 encounters in a clinic or office setting among children and youth under the age of 18 in West Minneapolis (Zip Code 553), and that the combined spending for patient care related to the visits was about $193 million.

For example analyses based on utilization information, please review MDH’s study on potentially preventable health care events in Minnesota:

Potentially Preventable Health Care Events in Minnesota (PDF)

Two versions of Prescription Drug PUFs are available:

  • The Summary Prescription Drug PUF contains retail pharmacy claims data that have been aggregated by nonproprietary drug name (i.e., active ingredient).
  • The Detail Prescription Drug PUF contains retail pharmacy claims data that have been aggregated by the first two segments of the National Drug Code (i.e., drug product).

Summary and Detail Prescription Drug PUFs are stratified by payer type (commercial, Medicare, and Minnesota Health Care Programs) and include data from 2012 and 2016. Drug characteristics were obtained from reference databases using National Drug Codes reported on pharmacy claims, and cost and supply measures were calculated from claims data. A data dictionary is included as a separate worksheet in each PUF. A user guide contains additional details on PUF design and data interpretation. (Released: March 2020)

For example use cases, please review the following Data Short Take:

Summary PUF

This file is designed to analyze retail prescription drug use and spending among Minnesota residents at the active ingredient level. This file includes demographic distributions of prescription drug users.

  • For example, this file permits identifying that in 2016, there were 350,232 prescriptions filled for amoxicillin among commercially insured individuals. The total spending on these prescriptions was $2,321,897, with an average cost per prescription of $6.63. Approximately 51% of filled amoxicillin prescriptions were for children and youth under the age of 19 years.

Detail PUF

This file is designed to analyze retail prescription drug use and spending among Minnesota residents at the drug product level.

  • For example, this file permits identifying that among commercially insured individuals in 2016, there were 58,328 prescriptions filled for the two segment NDC of 0093-3109, which is generic 500 mg capsule amoxicillin manufactured by Teva Pharmaceuticals. The total spending on these prescriptions was $255,391, with an average cost per prescription of $4.38.

This file is designed to analyze variation in payments to providers by individual provider specialty across a variety of stratifying variables. A data dictionary is included as a separate worksheet in the PUF. A user guide contains additional details on PUF design and data interpretation. (Released: December 2020)

The PUF stratifying variables represent payer type, site of service, patient resource utilization band, and provider and patient geography. Provider specialty was derived from the Medicare Provider Enrollment, Chain, and Ownership System (PECOS) and the National Plan and Provider Enumeration System (NPPES) using claim reported National Provider Identifier (NPI).

  • For example, this file includes information on 401 unique orthopedic surgeons located in an urban area who performed 11,967 procedures in a hospital or surgery center on commercially insured patients with urban residence and a resource utilization band level of 3 in 2017. The average patient paid amount for these procedures was $229.32, while the average insurer paid amount was $2,000.07.

This file is designed to analyze variation in medical and pharmaceutical expenditures by cost sharing, within or across payer type and additional stratifying variables. A data dictionary is included as a separate worksheet in the PUF. A user guide contains additional details on PUF design and data interpretation. (Released: December 2020)

The PUF stratifying variables represent member age group, sex, resource utilization band, geography, and median household income associated with member ZIP code. Expenditure variables include medical and pharmaceutical amounts paid by the insurer and member as well as combined medical and pharmaceutical costs.

  • For example, this file includes information on 23,936 commercially insured women aged 45 to 64 years living in an urban core area with high median household income and with a resource utilization band (RUB) of 0 in 2016. Collectively, these women accounted for 103,638 months of coverage, no hospitalizations, and no expenditures. In contrast, 3,548 women in RUB 5 accounted for 37,085 months of coverage, 2,593 hospitalizations, and a mean medical and pharmaceutical total paid amount of $5,374.94 per member month.

How to Request MN APCD Public Use Files

Request one or more of the PUFs by completing the MN APCD Downloadable Public Use Files.

Updated Thursday, December 03, 2020 at 12:00PM