MIPS_TABLE

This table takes the monthly updates to the CMS MIPS database, cleans, normalizes and orients their output into a concise feature set built for consumption.

Queries that source from MIPS_TABLE table

What is in the MIPS_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

featuredescriptionexample
npiNational Provider Identifier (NPI) assigned to the individual provider1962493296
org_pac_idUnique group ID assigned by PECOS to the group this individual participated in42128548
nameIndividual clinician's full nameallen noorily
sourceMethod by which the clinician achieved scores (“individual”, “group”, “virtual group”, or “apm”); if the source is “apm”, this indicates that the MIPS APM scoring standard was applied for this set of scoresapm
quality_scoreQuality performance category score86.13
interop_scorePromoting Interoperability (PI) performance category score24
improvement_scoreImprovement Activities (IA) performance category score100
mips_score_without_cpbMIPS Final Score without the Complex Patient Bonus (CPB). The CPB is part of the MIPS final score based on the overall medical complexity and social risk for one’s patients treated93.07
mips_scoreFinal Merit-based Incentive Payment System (MIPS) score100
update_dateThe last date in which MIPS table has been updated2023-01-01

Helper Function within the CareQuery API to help understand the underlying MIPS_TABLE dataset.

# import package
from care_query.care_query import CareQuery

# instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token")

# return details 
print(cq.glossary.table_detail('MIPS_TABLE'))