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.

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 Tuesday, March 24, 2020 at 04:07PM