Quality Payment Program Experience

The Quality Payment Program (QPP) Experience dataset provides participation and performance information in the Merit-based Incentive Payment System (MIPS)…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.QUALITY_PAYMENT_PROGRAM_EXPERIENCE on Snowflake and Databricks — nine annual reporting periods (2017–2024) aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.QUALITY_PAYMENT_PROGRAM_EXPERIENCE
Databricks	cms_dwv.quality_payment_program_experience
Coverage	Jan 2017 – Dec 2024 (8 of 8 annual reporting periods)
Rows	6,678,962 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned — each file adds one reporting year
CMS published	2026-05-19
Loaded	2026-05-19
Columns	237 data + 6 lineage
Identifiers	NPI
File versions	9
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-05-19. Coverage is complete through the 2024 reporting year. Next CMS release expected ~May 2027.

Time-partitioned feed — each file version covers one reporting year, so history is additive. Query the full table for all years; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2024 reporting year.

Sample queries

Snowflake

-- Each file version covers one reporting period — history is additive
SELECT *
FROM DWV.QUALITY_PAYMENT_PROGRAM_EXPERIENCE
LIMIT 100;

Databricks

About this feed

The Quality Payment Program (QPP) Experience dataset provides participation and performance information in the Merit-based Incentive Payment System (MIPS) during each performance year. They cover eligibility and participation, performance categories, and final score and payment adjustments. The dataset provides additional details at the TIN/NPI level on what was published in the previous performance year. You can sort the data by variables like clinician type, practice size, scores, and payment adjustments.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Health Care Use & Payments Theme: Medicare

Coverage timeline

2017–2024 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

8 of 8 annual reporting periods present — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2024-01-01 – 2024-12-31	2026-05-19	2026-05-19	✓
2023-01-01 – 2023-12-31	2025-07-21	2025-10-18
2023-01-01 – 2023-12-31	2025-06-30	2025-06-30
2022-01-01 – 2022-12-31	2024-05-08	2024-05-08
2021-01-01 – 2021-12-31	2023-06-12	2023-08-29
2020-01-01 – 2020-12-31	2023-05-11	2023-08-29
2019-01-01 – 2019-12-31	2023-05-11	2023-08-29
2018-01-01 – 2018-12-31	2023-04-26	2023-08-29
2017-01-01 – 2017-12-31	2023-05-11	2023-08-29

Data dictionary

📋 237 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Quality Payment Program Experience data dictionary.

Data columns

Column	Type
PROVIDER_KEY	NUMBER
PRACTICE_STATE_OR_US_TERRITORY	TEXT
PRACTICE_SIZE	NUMBER
CLINICIAN_TYPE	TEXT
CLINICIAN_SPECIALTY	TEXT
YEARS_IN_MEDICARE	NUMBER
NPI	NUMBER
NON_REPORTING	BOOLEAN
REPORTING_OPTION	TEXT
PARTICIPATION_OPTION	TEXT
MIPS_VALUE_PATHWAY_ID	TEXT
MIPS_VALUE_PATHWAY_TITLE	TEXT
MEDICARE_PATIENTS	NUMBER
ALLOWED_CHARGES	NUMBER
SERVICES	TEXT
OPTED_INTO_MIPS	BOOLEAN
SMALL_PRACTICE_STATUS	BOOLEAN
RURAL_STATUS	BOOLEAN
HEALTH_PROFESSIONAL_SHORTAGE_AREA_STATUS	BOOLEAN
AMBULATORY_SURGICAL_CENTER_BASED_STATUS	BOOLEAN
HOSPITAL_BASED_STATUS	BOOLEAN
NON_PATIENT_FACING_STATUS	BOOLEAN
FACILITY_BASED_STATUS	BOOLEAN
DUAL_ELIGIBILITY_RATIO	NUMBER
SAFETY_NET_STATUS	BOOLEAN
EXTREME_UNCONTROLLABLE_CIRCUMSTANCE_EUC_	BOOLEAN
RECEIVED_FACILITY_SCORE	BOOLEAN
FINAL_SCORE	NUMBER
PAYMENT_ADJUSTMENT_PERCENTAGE	NUMBER
COMPLEX_PATIENT_BONUS	TEXT
QUALITY_REWEIGHTING_EUC_	BOOLEAN
QUALITY_CATEGORY_SCORE	NUMBER
QUALITY_CATEGORY_WEIGHT	NUMBER
QUALITY_IMPROVEMENT_SCORE	NUMBER
SMALL_PRACTICE_BONUS	NUMBER
QUALITY_MEASURE_ID_1	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_1	TEXT
QUALITY_MEASURE_SCORE_1	NUMBER
QUALITY_MEASURE_ID_2	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_2	TEXT
QUALITY_MEASURE_SCORE_2	NUMBER
QUALITY_MEASURE_ID_3	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_3	TEXT
QUALITY_MEASURE_SCORE_3	NUMBER
QUALITY_MEASURE_ID_4	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_4	TEXT
QUALITY_MEASURE_SCORE_4	NUMBER
QUALITY_MEASURE_ID_5	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_5	TEXT
QUALITY_MEASURE_SCORE_5	NUMBER
QUALITY_MEASURE_ID_6	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_6	TEXT
QUALITY_MEASURE_SCORE_6	NUMBER
QUALITY_MEASURE_ID_7	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_7	TEXT
QUALITY_MEASURE_SCORE_7	NUMBER
QUALITY_MEASURE_ID_8	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_8	TEXT
QUALITY_MEASURE_SCORE_8	TEXT
QUALITY_MEASURE_ID_9	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_9	TEXT
QUALITY_MEASURE_SCORE_9	TEXT
QUALITY_MEASURE_ID_10	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_10	TEXT
QUALITY_MEASURE_SCORE_10	TEXT
QUALITY_MEASURE_ID_11	NUMBER
QUALITY_MEASURE_COLLECTION_TYPE_11	TEXT
QUALITY_MEASURE_SCORE_11	NUMBER
QUALITY_MEASURE_ID_12	TEXT
QUALITY_MEASURE_COLLECTION_TYPE_12	TEXT
QUALITY_MEASURE_SCORE_12	TEXT
PROMOTING_INTEROPERABILITY_PI_CATEGORY_SCORE	NUMBER
PROMOTING_INTEROPERABILITY_PI_CATEGORY_WEIGHT	NUMBER
PI_REWEIGHTING_EUC_	BOOLEAN
PI_REWEIGHTING_HARDSHIP_EXCEPTION_	BOOLEAN
PI_REWEIGHTING_SPECIAL_STATUS_OR_CLINICIAN_TYPE_	BOOLEAN
CEHRT_ID	TEXT
PI_MEASURE_ID_1	TEXT
PI_MEASURE_TYPE_1	TEXT
PI_MEASURE_SCORE_1	NUMBER
PI_MEASURE_ID_2	TEXT
PI_MEASURE_TYPE_2	TEXT
PI_MEASURE_SCORE_2	NUMBER
PI_MEASURE_ID_3	TEXT
PI_MEASURE_TYPE_3	TEXT
PI_MEASURE_SCORE_3	NUMBER
PI_MEASURE_ID_4	TEXT
PI_MEASURE_TYPE_4	TEXT
PI_MEASURE_SCORE_4	NUMBER
PI_MEASURE_ID_5	TEXT
PI_MEASURE_TYPE_5	TEXT
PI_MEASURE_SCORE_5	NUMBER
PI_MEASURE_ID_6	TEXT
PI_MEASURE_TYPE_6	TEXT
PI_MEASURE_SCORE_6	NUMBER
PI_MEASURE_ID_7	TEXT
PI_MEASURE_TYPE_7	TEXT
PI_MEASURE_SCORE_7	NUMBER
PI_MEASURE_ID_8	TEXT
PI_MEASURE_TYPE_8	TEXT
PI_MEASURE_SCORE_8	TEXT
PI_MEASURE_ID_9	TEXT
PI_MEASURE_TYPE_9	TEXT
PI_MEASURE_SCORE_9	TEXT
PI_MEASURE_ID_10	TEXT
PI_MEASURE_TYPE_10	TEXT
PI_MEASURE_SCORE_10	TEXT
PI_MEASURE_ID_11	TEXT
PI_MEASURE_TYPE_11	TEXT
PI_MEASURE_SCORE_11	TEXT
PI_MEASURE_ID_12	TEXT
PI_MEASURE_TYPE_12	TEXT
PI_MEASURE_SCORE_12	NUMBER
PI_MEASURE_ID_13	TEXT
PI_MEASURE_TYPE_13	TEXT
PI_MEASURE_SCORE_13	NUMBER
PI_MEASURE_ID_14	TEXT
PI_MEASURE_TYPE_14	TEXT
PI_MEASURE_SCORE_14	NUMBER
PI_MEASURE_ID_15	TEXT
PI_MEASURE_TYPE_15	TEXT
PI_MEASURE_SCORE_15	NUMBER
PI_MEASURE_ID_16	TEXT
PI_MEASURE_TYPE_16	TEXT
PI_MEASURE_SCORE_16	NUMBER
PI_MEASURE_ID_17	TEXT
PI_MEASURE_TYPE_17	TEXT
PI_MEASURE_SCORE_17	NUMBER
PI_MEASURE_ID_18	TEXT
PI_MEASURE_TYPE_18	TEXT
PI_MEASURE_SCORE_18	TEXT
PI_MEASURE_ID_19	TEXT
PI_MEASURE_TYPE_19	TEXT
PI_MEASURE_SCORE_19	TEXT
PI_MEASURE_ID_20	TEXT
PI_MEASURE_TYPE_20	TEXT
PI_MEASURE_SCORE_20	TEXT
PI_MEASURE_ID_21	TEXT
PI_MEASURE_TYPE_21	TEXT
PI_MEASURE_SCORE_21	TEXT
IMPROVEMENT_ACTIVITIES_IA_CATEGORY_SCORE	NUMBER
IMPROVEMENT_ACTIVITIES_IA_CATEGORY_WEIGHT	NUMBER
IA_REWEIGHTING_EUC_	BOOLEAN
IA_CREDIT	BOOLEAN
IA_MEASURE_ID_1	TEXT
IA_MEASURE_SCORE_1	NUMBER
IA_MEASURE_ID_2	TEXT
IA_MEASURE_SCORE_2	NUMBER
IA_MEASURE_ID_3	TEXT
IA_MEASURE_SCORE_3	NUMBER
IA_MEASURE_ID_4	TEXT
IA_MEASURE_SCORE_4	NUMBER
COST_CATEGORY_SCORE	NUMBER
COST_IMPROVEMENT_SCORE	NUMBER
COST_CATEGORY_WEIGHT	NUMBER
COST_REWEIGHTING_EUC_	BOOLEAN
COST_MEASURE_ID_1	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_1	NUMBER
COST_MEASURE_ID_2	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_2	NUMBER
COST_MEASURE_ID_3	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_3	NUMBER
COST_MEASURE_ID_4	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_4	NUMBER
COST_MEASURE_ID_5	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_5	NUMBER
COST_MEASURE_ID_6	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_6	NUMBER
COST_MEASURE_ID_7	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_7	NUMBER
COST_MEASURE_ID_8	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_8	NUMBER
COST_MEASURE_ID_9	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_9	NUMBER
COST_MEASURE_ID_10	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_10	NUMBER
COST_MEASURE_ID_11	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_11	NUMBER
COST_MEASURE_ID_12	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_12	NUMBER
COST_MEASURE_ID_13	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_13	NUMBER
COST_MEASURE_ID_14	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_14	NUMBER
COST_MEASURE_ID_15	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_15	NUMBER
COST_MEASURE_ID_16	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_16	NUMBER
COST_MEASURE_ID_17	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_17	NUMBER
COST_MEASURE_ID_18	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_18	NUMBER
COST_MEASURE_ID_19	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_19	NUMBER
COST_MEASURE_ID_20	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_20	NUMBER
COST_MEASURE_ID_21	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_21	NUMBER
COST_MEASURE_ID_22	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_22	NUMBER
COST_MEASURE_ID_23	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_23	NUMBER
COST_MEASURE_ID_24	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_24	NUMBER
ENGAGED	BOOLEAN
PARTICIPATION_TYPE	TEXT
SMALL_PRACTITIONER	BOOLEAN
RURAL_CLINICIAN	BOOLEAN
HPSA_CLINICIAN	BOOLEAN
AMBULATORY_SURGICAL_CENTER	BOOLEAN
HOSPITAL_BASED_CLINICIAN	BOOLEAN
NON_PATIENT_FACING	BOOLEAN
FACILITY_BASED	BOOLEAN
EXTREME_HARDSHIP	BOOLEAN
EXTREME_HARDSHIP_QUALITY	BOOLEAN
QUALITY_IMPROVEMENT_BONUS	NUMBER
QUALITY_BONUS	BOOLEAN
EXTREME_HARDSHIP_PI	BOOLEAN
PI_HARDSHIP	BOOLEAN
PI_REWEIGHTING	BOOLEAN
PI_BONUS	BOOLEAN
PI_CEHRT_ID	TEXT
IA_SCORE	NUMBER
EXTREME_HARDSHIP_IA	BOOLEAN
IA_STUDY	BOOLEAN
COST_SCORE	TEXT
EXTREME_HARDSHIP_COST	BOOLEAN
COST_MEASURE_SCORE_1	TEXT
COST_MEASURE_SCORE_2	TEXT
COST_MEASURE_ID_25	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_25	NUMBER
COST_MEASURE_ID_26	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_26	NUMBER
COST_MEASURE_ID_27	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_27	NUMBER
COST_MEASURE_ID_28	TEXT
COST_MEASURE_ACHIEVEMENT_POINTS_28	NUMBER

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.PROVIDER_KEY, d.PRACTICE_STATE_OR_US_TERRITORY, d.PRACTICE_SIZE,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.QUALITY_PAYMENT_PROGRAM_EXPERIENCE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS data dictionary

• 2024 Qpp Puf Methodology

Frequently asked questions

How often is Quality Payment Program Experience updated?

Annually. CMS last published this feed on 2026-05-19, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Quality Payment Program Experience cover?

2017 through 2024 — eight annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Quality Payment Program Experience?

6,678,962 rows across all nine reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Quality Payment Program Experience data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.QUALITY_PAYMENT_PROGRAM_EXPERIENCE directly — no pipeline setup required.

Related feeds

Medicare Post-Acute Care Utilization - Long-Term Care HospitalProvider of Services File - Clinical LaboratoriesPayroll Based Journal Daily Non-Nurse StaffingMedicare Outpatient Hospitals - by Provider and ServiceMedicare Durable Medical Equipment, Devices & Supplies - by Referring Provider and Service

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →