Medicare NPI Physician And Other Supplier Payment Aggregate Report

$716 / year

The dataset contains information on utilization and payments (Total submitted charges, Medicare allowed amount, Medicare Payment amount, Medicare standardized payment amount) organized by National Provider Identity. Sub-totals for medical type services and drug type services are included as well as overall utilization, payment and charges.

Complexity

The Physician and Other Supplier Public Use File contains information on utilization, payment (Total submitted charges, Medicare allowed amount, Medicare Payment amount, Medicare standardized payment amount) organized by National Provider Identifier (NPI)and Healthcare Common Procedure Coding System (HCPCS) code. The data in the Physician and Other Supplier PUF is from physician/supplier Part B non-institutional line items for the Medicare fee-for-service (FFS) population. Claims processed by Durable Medical Equipment, Prosthetic, Orthotics and Supplies (DMEPOS) Medicare Administrative Contractor (MAC) are not included in the Physician and Other Supplier PUF. The 2015 data are available from the Centres for Medicaid and Medicare Services (CMS) Chronic Condition Data Warehouse (CCW), a database with 100% of Medicare enrollment and fee-for-service claims data. For all Physician and Other Supplier PUF data years, provider demographics (name, credentials, gender, complete address and entity type) are taken from the National Plan & Provider Enumeration System (NPPES). CMS developed the NPPES to assign unique identifiers, known as National Provider Identifiers (NPIs), to health care providers. The demographic information provided in the 2015 Physician and Other Supplier PUF was extracted from NPPES at the end of the calendar year 2015.

The spending and utilization data in the Physician and Other Supplier PUF are aggregated to the following:
a) the NPI for the performing provider,
b) the Healthcare Common Procedure Coding System (HCPCS) code, and
c) the place of service (either facility or non-facility).

There can be multiple records for a given NPI based on the number of distinct HCPCS codes that were billed and where the services were provided. Data have been aggregated based on the place of service because separate fee schedules apply depending on whether the place of service submitted on the claim is facility or non-facility. The Physician and Other Supplier PUF and the supplemental summary tables including the “Medicare Physician and Other Supplier Aggregate Table” (i.e., one record per NPI) have been updated to include Medicare standardized payment amounts. The “Medicare Physician and Other Supplier Aggregate Table” (i.e., one record per NPI) have the Average beneficiary risk scores which provide information on the health status of the beneficiaries the providers serve. In addition, beneficiary demographic and health characteristics are provided which include age, sex, race, Medicare and Medicaid entitlement, chronic conditions and risk scores. NPI Physician And Other Supplier Payment Aggregate Report from 2012 to 2015 is merged here.

Date Created

2017-02-15

Last Modified

2019-06-05

Version

2019-06-05

Update Frequency

Annual

Temporal Coverage

2017

Spatial Coverage

United States

Source

John Snow Labs; Centers for Medicare And Medicaid Services;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

National Provider Identity, Aggregate Report, Medical Type Services, Drug Type Services, Utilization and Payment Data, Demographic and Health Characteristics, Medicare and Medicaid Entitlement, Chronic Conditions, Average Risk Scores

Other Titles

Medicare Physicians and Other Suppliers Utilization And Payment Data Aggregate Report, Medicare Beneficiaries Utilization, Payment And Charges Physician and Other Suppliers Aggregate Report, Medicare Physicians and Other Suppliers Utilization, Payment Data Demographic And Health Characteristics Aggregate Report, Medicare and Medicaid Entitlement, Physicians and Other Suppliers data, Chronic Conditions And Risk scores Aggregate Report

NameDescriptionTypeConstraints
National_Provider_IdentifierNational Provider Identifier (NPI) for the performing provider on the claim. The provider NPI is the numeric identifier registered in NPPES.integerlevel : Nominal
Last_Name_Of_The_Provider_Or_OrganizationWhen the provider is registered in NPPES as an individual (entity type code=’I’), this is the provider’s last name. When the provider is registered as an organization (entity type code = ‘O’), this is the organization name.string-
First_Name_Of_The_ProviderWhen the provider is registered in NPPES as an individual (entity type code=’I’), this is the provider’s first name. When the provider is registered as an organization (entity type code = ‘O’), this will be blank.string-
Middle_Initial_Of_The_ProviderWhen the provider is registered in NPPES as an individual (entity type code=’I’), this is the provider’s middle initial. When the provider is registered as an organization (entity type code = ‘O’), this will be blank.string-
Credentials_Of_The_ProviderWhen the provider is registered in NPPES as an individual (entity type code=’I’), these are the provider’s credentials. When the provider is registered as an organization (entity type code = ‘O’), this will be blankstring-
Gender_Of_The_ProviderWhen the provider is registered in NPPES as an individual (entity type code=’I’), this is the provider’s gender. When the provider is registered as an organization (entity type code = ‘O’), this will be blank.string-
Entity_Type_Of_The_ProviderType of entity reported in NPPES. An entity code of ‘I’ identifies providers registered as individuals and an entity type code of ‘O’ identifies providers registered as organizations.string-
Street_Address_1_Of_The_ProviderThe first line of the provider’s street address, as reported in NPPES.string-
Street_Address_2_Of_The_ProviderThe second line of the provider’s street address, as reported in NPPES.string-
CityThe city where the provider is located, as reported in NPPES. The ARMY areas were divided into three Military "States": AA - Armed Forces Americas, AE - Armed Forces Europe, AP - Armed Forces Pacific. Those States are divided into three "Cities": APO - Army Post Office, FPO - Fleet Post Office, DPO - Diplomatic Post Officestring-
Zip_CodeThe provider’s zip code, as reported in NPPES.string-
Provider_RUCAThe provider’s Rural-Urban Commuting Area Codes (RUCAs) based on zip code. RUCAs are a Census tract-based classification scheme that utilizes the standard Bureau of Census Urbanized Area and Urban Cluster definitions in combination with work commuting information to characterize all of the nation's Census tracts regarding their rural and urban status and relationships.numberlevel : Ratio
State_AbbreviationThe state where the provider is located, as reported in NPPES. The fifty U.S. states and the District of Columbia are reported by the state postal abbreviation.string-
Country_Code_Of_The_ProviderThe country where the provider is located, as reported in NPPES. The country code will be ‘US’ for any state or U.S. possession.string-
Specialty_Type_Of_The_ProviderDerived from the provider specialty code reported on the claim. For providers that reported more than one specialty code on their claims, this is the specialty code associated with the largest number of services.string-
Is_Medicare_Participation_IndicatorIdentifies whether the provider participates in Medicare and/or accepts assignment of Medicare allowed amounts. The value will be ‘true’ for any provider that had at least one claim identifying the provider as participating in Medicare or accepting assignment of Medicare allowed amounts within HCPCS code and place of service. A non-participating provider may elect to accept Medicare allowed amounts for some services and not accept Medicare allowed amounts for other services.boolean-
Number_Of_HCPCSTotal number of unique HCPCS codes.integerlevel : Ratio
Number_Of_ServicesTotal provider services.numberlevel : Ratio
Number_Of_Medicare_BeneficiariesTotal Medicare beneficiaries receiving the provider services. The beneficiary counts reported in the demographic sub-groups (i.e., age, sex, race and entitlement) may not aggregate to the ‘Number of Unique Beneficiaries’ due to the suppression of beneficiaries fewer than 11 within the demographic sub-groups. In addition, a small percentage of beneficiaries are reflected in the “Number of Unique Beneficiaries” but are not reflected in the beneficiary demographic information due to the lack of demographic information available at the time of reporting.numberlevel : Ratio
Total_Submitted_Charge_AmountThe total charges that the provider submitted for all services.number-
Total_Medicare_Allowed_AmountThe Medicare allowed amount for all provider services. This figure is the sum of the amount Medicare pays, the deductible and coinsurance amounts that the beneficiary is responsible for paying, and any amounts that a third party is responsible for paying.number-
Total_Medicare_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amount have been deducted for all the provider's line-item services.number-
Total_Medicare_Standardized_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item service and after standardization of the Medicare payment has been applied. Standardization removes geographic differences in payment rates for individual services, such as those that account for local wages or input prices and makes Medicare payments across geographic areas comparable, so that differences reflect variation in factors such as physicians’ practice patterns and beneficiaries’ ability and willingness to obtain care.number-
Drug_Suppress_IndicatorIdentifies whether the utilization, cost and payment information associated with HCPCS codes for drug services as listed on the Medicare Part B Drug Average Sales Price (ASP) list have been suppressed.string-
Number_Of_HCPCS_Associated_With_Drug_ServicesTotal number of HCPCS codes for drug services, as defined from the Medicare Part B Drug ASP Fileintegerlevel : Ratio
Number_Of_Drug_ServicesTotal drug services, as defined from the Medicare Part B Drug ASP File.numberlevel : Ratio
Number_Of_Medicare_Beneficiaries_With_Drug_ServicesTotal Medicare beneficiaries receiving drug services, as defined from the Medicare Part B Drug ASP File.integerlevel : Ratio
Total_Drug_Submitted_Charge_AmountThe total charges that the provider submitted for drug services, as defined from the Medicare Part B Drug ASP File.number-
Total_Drug_Medicare_Allowed_AmountThe Medicare allowed amount for drug services, as defined from the Medicare Part B Drug ASP File. This figure is the sum of the amount Medicare pays, the deductible and coinsurance amounts that the beneficiary is responsible for paying, and any amounts that a third party is responsible for paying.number-
Total_Drug_Medicare_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amount have been deducted for all the provider's line-item drug services, as defined from the Medicare Part B Drug ASP File.number-
Total_Drug_Medicare_Standardized_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item drug service, as defined from the Medicare Part B Drug ASP File and after standardization of the Medicare payment has been applied.number-
Medical_Suppress_IndicatorIdentifies whether the utilization, cost and payment information associated with HCPCS codes for Medical (non-ASP) services have been suppressed.string-
Number_Of_HCPCS_Associated_With_Medical_ServicesTotal number of HCPCS codes associated with medical (non-ASP) services.integerlevel : Ratio
Number_Of_Medical_ServicesTotal medical (non-ASP) services.numberlevel : Ratio
Number_Of_Medicare_Beneficiaries_With_Medical_ServicesTotal Medicare beneficiaries receiving medical (non-ASP) services.integerlevel : Ratio
Total_Medical_Submitted_Charge_AmountThe total charges that the provider submitted for medical (non-ASP) services.number-
Total_Medical_Medicare_Allowed_AmountThe Medicare allowed amount for medical (non-ASP) services. This figure is the sum of the amount Medicare pays, the deductible and coinsurance amounts that the beneficiary is responsible for paying, and any amounts that a third party is responsible for paying.number-
Total_Medical_Medicare_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amount have been deducted for all of the provider's line item medical (non-ASP) services.number-
Total_Medical_Medicare_Standardized_Payment_AmountTotal amount that Medicare paid after deductible and coinsurance amounts have been deducted for the line item medical (non-ASP) service, as defined from the Medicare Part B Drug ASP File and after standardization of the Medicare payment has been applied. Standardization removes geographic differences in payment rates for individual services, such as those that account for local wages or input prices and makes Medicare payments across geographic areas comparable, so that differences reflect variation in factors such as physicians’ practice patterns and beneficiaries’ ability and willingness to obtain care.number-
Average_Age_Of_BeneficiariesAverage age of beneficiaries. Beneficiary age is calculated at the end of the calendar year or at the time of death.integerlevel : Ratio
Number_Of_Beneficiaries_Age_Less_65Number of beneficiaries under the age of 65. Beneficiary age is calculated at the end of the calendar year or at the time of death.integerlevel : Ratio
Number_Of_Beneficiaries_Age_65_To_74Number of beneficiaries between the ages of 65 and 74. Beneficiary age is calculated at the end of the calendar year or at the time of death.integerlevel : Ratio
Number_Of_Beneficiaries_Age_75_To_84Number of beneficiaries between the ages of 75 and 84. Beneficiary age is calculated at the end of the calendar year or at the time of death.integerlevel : Ratio
Number_Of_Beneficiaries_Age_Greater_Than_84Number of beneficiaries over the age of 84. Beneficiary age is calculated at the end of the calendar year or at the time of deathintegerlevel : Ratio
Number_Of_Female_BeneficiariesNumber of female beneficiariesintegerlevel : Ratio
Number_Of_Male_BeneficiariesNumber of male beneficiaries.integerlevel : Ratio
Number_Of_Non_Hispanic_White_BeneficiariesNumber of non-Hispanic white beneficiaries.integerlevel : Ratio
Number_Of_Black_Or_African_American_BeneficiariesNumber of non-Hispanic black or African American beneficiariesintegerlevel : Ratio
Number_Of_Asian_Pacific_Islander_BeneficiariesNumber of Asian Pacific Islander beneficiariesintegerlevel : Ratio
Number_Of_Hispanic_White_BeneficiariesNumber of Hispanic beneficiariesintegerlevel : Ratio
Number_Of_American_Indian_Alaska_Native_BeneficiariesNumber of American Indian or Alaska Native beneficiaries.integerlevel : Ratio
Number_Of_Beneficiaries_With_Race_Not_Elsewhere_ClassifiedNumber of beneficiaries with race not elsewhere classified.integerlevel : Ratio
Number_Of_Beneficiaries_With_Medicare_Only_EntitlementNumber of Medicare beneficiaries qualified to receive Medicare only benefits. Beneficiaries are classified as Medicare only entitlement if they received zero months of any Medicaid benefits (full or partial) in the given calendar year.integerlevel : Ratio
Number_Of_Beneficiaries_With_Medicare_And_Medicaid_EntitlementNumber of Medicare beneficiaries qualified to receive Medicare and Medicaid benefits. Beneficiaries are classified as Medicare and Medicaid entitlement if in any month in the given calendar year they were receiving full or partial Medicaid benefits.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_Atrial_FibrillationPercent of beneficiaries meeting the CCW chronic condition algorithm for atrial fibrillation.integerlevel : Ratio
Percent_Of_Beneficiaries_With_Alzheimers_Disease_Or_DementiaPercent of beneficiaries meeting the CCW chronic condition algorithm for Alzheimer’s, related disorders, or dementia.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_AsthmaPercent of beneficiaries meeting the CCW chronic condition algorithm for Asthma.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_CancerPercent of beneficiaries meeting the CCW chronic condition algorithms for cancer. Includes breast cancer, colorectal cancer, lung cancer and prostate cancer.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_Heart_FailurePercent of beneficiaries meeting the CCW chronic condition algorithm for heart failure.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_Chronic_Kidney_DiseasePercent of beneficiaries meeting the CCW chronic condition algorithm for chronic kidney disease.integerlevel : Ratio
Percent_Of_Beneficiaries_With_Chronic_Obstructive_Pulmonary_DiseasePercent of beneficiaries meeting the CCW chronic condition algorithm for chronic obstructive pulmonary diseaseintegerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_DepressionPercent of beneficiaries meeting the CCW chronic condition algorithm for depression.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_DiabetesPercent of beneficiaries meeting the CCW chronic condition algorithm for diabetes.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_HyperlipidemiaPercent of beneficiaries meeting the CCW chronic condition algorithm for hyperlipidemia.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_HypertensionPercent of beneficiaries meeting the CCW chronic condition algorithm for hypertension.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_Ischemic_Heart_DiseasePercent of beneficiaries meeting the CCW chronic condition algorithm for ischemic heart disease.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_OsteoporosisPercent of beneficiaries meeting the CCW chronic condition algorithm for osteoporosis.integerlevel : Ratio
Percent_Of_Beneficiaries_With_Rheumatoid_Arthritis_OsteoarthritisPercent of beneficiaries meeting the CCW chronic condition algorithm for rheumatoid arthritis/osteoarthritis.integerlevel : Ratio
Percent_Of_Beneficiaries_With_Schizophrenia_Other_Psychotic_DisordersPercent of beneficiaries meeting the CCW chronic condition algorithm for schizophrenia and other psychotic disorders.integerlevel : Ratio
Percent_Of_Beneficiaries_Identified_With_StrokePercent of beneficiaries meeting the CCW chronic condition algorithm for stroke.integerlevel : Ratio
Average_HCC_Risk_Score_Of_BeneficiariesAverage Hierarchical Condition Category (HCC) risk score of beneficiaries. CMS developed a risk-adjustment model that uses HCCs (hierarchical condition categories) to assign risk scores. Those scores estimate how beneficiaries’ FFS spending will compare to the overall average for the entire Medicare population. The average risk score is set at 1.08; beneficiaries with scores greater than that are expected to have above-average spending, and vice versa.numberlevel : Ratio
National Provider IdentifierLast Name Of The Provider Or OrganizationFirst Name Of The ProviderMiddle Initial Of The ProviderCredentials Of The ProviderGender Of The ProviderEntity Type Of The ProviderStreet Address 1 Of The ProviderStreet Address 2 Of The ProviderCityZip CodeProvider RUCAState AbbreviationCountry Code Of The ProviderSpecialty Type Of The ProviderIs Medicare Participation IndicatorNumber Of HCPCSNumber Of ServicesNumber Of Medicare BeneficiariesTotal Submitted Charge AmountTotal Medicare Allowed AmountTotal Medicare Payment AmountTotal Medicare Standardized Payment AmountDrug Suppress IndicatorNumber Of HCPCS Associated With Drug ServicesNumber Of Drug ServicesNumber Of Medicare Beneficiaries With Drug ServicesTotal Drug Submitted Charge AmountTotal Drug Medicare Allowed AmountTotal Drug Medicare Payment AmountTotal Drug Medicare Standardized Payment AmountMedical Suppress IndicatorNumber Of HCPCS Associated With Medical ServicesNumber Of Medical ServicesNumber Of Medicare Beneficiaries With Medical ServicesTotal Medical Submitted Charge AmountTotal Medical Medicare Allowed AmountTotal Medical Medicare Payment AmountTotal Medical Medicare Standardized Payment AmountAverage Age Of BeneficiariesNumber Of Beneficiaries Age Less 65Number Of Beneficiaries Age 65 To 74Number Of Beneficiaries Age 75 To 84Number Of Beneficiaries Age Greater Than 84Number Of Female BeneficiariesNumber Of Male BeneficiariesNumber Of Non Hispanic White BeneficiariesNumber Of Black Or African American BeneficiariesNumber Of Asian Pacific Islander BeneficiariesNumber Of Hispanic White BeneficiariesNumber Of American Indian Alaska Native BeneficiariesNumber Of Beneficiaries With Race Not Elsewhere ClassifiedNumber Of Beneficiaries With Medicare Only EntitlementNumber Of Beneficiaries With Medicare And Medicaid EntitlementPercent Of Beneficiaries Identified With Atrial FibrillationPercent Of Beneficiaries With Alzheimers Disease Or DementiaPercent Of Beneficiaries Identified With AsthmaPercent Of Beneficiaries Identified With CancerPercent Of Beneficiaries Identified With Heart FailurePercent Of Beneficiaries Identified With Chronic Kidney DiseasePercent Of Beneficiaries With Chronic Obstructive Pulmonary DiseasePercent Of Beneficiaries Identified With DepressionPercent Of Beneficiaries Identified With DiabetesPercent Of Beneficiaries Identified With HyperlipidemiaPercent Of Beneficiaries Identified With HypertensionPercent Of Beneficiaries Identified With Ischemic Heart DiseasePercent Of Beneficiaries Identified With OsteoporosisPercent Of Beneficiaries With Rheumatoid Arthritis OsteoarthritisPercent Of Beneficiaries With Schizophrenia Other Psychotic DisordersPercent Of Beneficiaries Identified With StrokeAverage HCC Risk Score Of Beneficiaries
1003000126ENKESHAFIARDALANM.D.MI900 SETON DRCUMBERLAND215021854MDUSInternal MedicineTrue231670578800850.0177181.14137084.55138279.120.00.00.00.00.00.00.023.01670.0578.0800850.0177181.14137084.55138279.127584.0186187.0121.0338240525.038.00.042515324.029.011.014.047.06536.046516775569.0498.013.02.1178
1003000134CIBULLTHOMASLM.D.MI2650 RIDGE AVEEVANSTON HOSPITALEVANSTON602011718ILUSPathologyTrue20814937031272161.0319561.26243698.97235917.60.00.00.00.00.00.00.020.08149.03703.01272161.0319561.26243698.97235917.67686.015821298.0737.0180219013407.063.062.0118.0350320012.07.04.013.013.0198.012203455279.0361.03.01.1024
1003000142KHALILRASHIDM.D.MI4126 N HOLLAND SYLVANIA RDSUITE 220TOLEDO436233536OHUSAnesthesiologyTrue603085278288873.0161220.25119726.66123488.12.01609.013.019353.09578.297504.377510.7358.01476.0278.0269520.0151641.96112222.29115977.3765126.09146.015.0166112220.035.01671115.05.09.010.027.03529.0454150743910.0754.05.01.6807
1003000407GIRARDIDAVIDJD.O.MI100 HOSPITAL RDBROOKVILLE158251367PAUSFamily PracticeTrue29857260132744.088655.9466084.7870643.970.00.00.00.00.00.00.029.0857.0260.0132744.088655.9466084.7870643.977926.05476.0104.01561041718927.049.016.013.047.06247.0504466756420.04813.011.02.1173
1003000423VELOTTAJENNIFERAM.D.FI11100 EUCLID AVECLEVELAND441061716OHUSObstetrics & GynecologyTrue291557133700.014572.2811244.6812001.69*#6520.033710531818212035482315.0420.01.0032
1003000480ROTHCHILDKEVINBMDMI12605 E 16TH AVEAURORA800452545COUSGeneral SurgeryTrue45179124232097.047053.3536031.7135555.330.00.00.00.00.00.00.045.0179.0124.0232097.047053.3536031.7135555.336349.060745092.016.0735110.012.09.016.03113.0353339653110.0531.6625
1003000522WEIGANDFREDERICKJMDMI1565 SAXON BLVDSUITE 102DELTONA327255876FLUSFamily PracticeTrue491816384417695.2138111.71100501.48103117.669.0268.0211.059377.220394.519355.3619948.1840.01548.0384.0358318.0117717.2181146.1283169.487732.0119128.0105.0212172346.018.03562814.020.03.015.020.03218.0173075753813.0574.01.1979
1003000530SEMONCHEAMANDAMDOFI1021 PARK AVESUITE 203QUAKERTOWN189511.0PAUSInternal MedicineTrue291330346195656.0133093.899975.4495294.845.0146.0125.015160.010602.0610390.0310390.0324.01184.0346.0180496.0122491.7489585.4184904.817156.015698.036.0195151331.00.0298489.08.04.010.011.0248.023255869277.0303.01.1591
1003000597KIMDAEYM.D., PH.DMI1145 S UTICA AVESUITE 202TULSA741044000OKUSUrologyTrue942703652650400.0236693.8174629.25187109.85*#71113.0289190.060.0192460451.038.013.0132.052512713.017.07.018.027.04725.027395575456.0482.07.01.6786
1003000639BENHARASHPEYMANMDMIUCLA CARDIOTHORACIC SURGERY 10833 LECONTE AVE62-182 CHSLOS ANGELES900950001CAUSCardiac SurgeryTrue4210049434550.7868377.3653607.8749075.450.00.00.00.00.00.00.042.0100.049.0434550.7868377.3653607.8749075.45732018.0143527.00.0331645.022.075.07129.03145757575352.1769