Others titles
- Medicare Part D Prescriber Public Use File Data 2014
- Medicare Provider Utilization and Payment Part D Prescriber Data 2014
Keywords
- Prescriber Data
- Prescription Drug Plans
- Medicare Part D
- Medicare Advantage
- Medicare Prescription Drug Coverage
- Medicare Claims Data
- Provider Summary
Medicare Part D Prescriber Utilization and Payment Data 2014
The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2014. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The Part D Prescriber Public Use File (PUF) provides information on prescription drugs prescribed by individual physicians and other healthcare providers and paid for under the Medicare Part D Prescription Drug Program. The Part D Prescriber PUF is based on information from CMS’s Chronic Conditions Data Warehouse, which contains Prescription Drug Event records submitted by Medicare Advantage Prescription Drug (MAPD) plans and by stand-alone Prescription Drug Plans (PDP). The dataset identifies providers by their National Provider Identifier (NPI) and the specific prescriptions that were dispensed at their direction, listed by brand name (if applicable) and generic name. For each prescriber and drug, the dataset includes the total number of prescriptions that were dispensed, which include original prescriptions and any refills, and the total drug cost. The total drug cost includes the ingredient cost of the medication, dispensing fees, sales tax, and any applicable administration fees and is based on the amount paid by the Part D plan, Medicare beneficiary, government subsidies, and any other third-party payers.
Although the Part D Prescriber PUF has a wealth of information on payment and utilization for Medicare Part D prescriptions, the dataset has a number of limitations. Of particular importance is the fact that the data may not be representative of a physician’s entire practice or all of Medicare as it only includes information on beneficiaries enrolled in the Medicare Part D prescription drug program (i.e., approximately two-thirds of all Medicare beneficiaries).
About this Dataset
Data Info
Date Created | 2015-04-30 |
---|---|
Last Modified | 2017-05-25 |
Version | 2017-05-25 |
Update Frequency |
Annual |
Temporal Coverage |
2014 |
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 | Prescriber Data, Prescription Drug Plans, Medicare Part D, Medicare Advantage, Medicare Prescription Drug Coverage, Medicare Claims Data, Provider Summary |
Other Titles | Medicare Part D Prescriber Public Use File Data 2014, Medicare Provider Utilization and Payment Part D Prescriber Data 2014 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
National_Provider_Identifier | National Provider Identifier (NPI) for the performing provider on the claim. | string | - |
Last_Name_Organization_Name | When the provider is registered in NPPES as an individual, this is the provider’s last name. When the provider is registered as an organization, this is the organization name. | string | - |
First_Name | When the provider is registered in NPPES as an individual, this is the provider’s first name. When the provider is registered as an organization, this will be blank. | string | - |
Middle_Initial | Middle Initial of the Provider | string | - |
Credentials | Credentials of the Provider | string | - |
Gender | Gender of the Provider | string | - |
Entity_Code | Entity Type of the Provider | string | - |
Street_Address_1 | Street Address 1 of the Provider | string | - |
Street_Address_2 | Street Address 2 of the Provider | string | - |
City | The city where the provider is located, as reported in NPPES | string | - |
Zip_Code_5 | Zip Code of the Provider- First five digits | string | - |
Zip_Code_4 | Zip Code of the Provider- Last four digits | string | - |
State_Abbreviation | The 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 | Country Code of the Provider | string | - |
Provider_Specialty_Type | Provider Specialty Type | string | - |
Source_Of_Provider_Specialty | Source of Provider Specialty | string | - |
Medicare_Provider_Enroll_Status | Enrollment Status of the Provider in the Medicare Program | string | - |
Beneficiaries_Count | The total number of unique Medicare Part D beneficiaries with at least one claim for the drug. Counts fewer than 11 are suppressed and are indicated by a blank. | integer | level : Ratio |
Total_Claim_Count | The number of Medicare Part D claims. This includes original prescriptions and refills. Aggregated records based on total_claim_count fewer than 11 are not included in the data file. | number | level : Ratio |
Total_Drug_Cost | The aggregate total drug cost paid for all associated claims. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. The total drug cost is based on the amounts paid by the Part D plan, Medicare beneficiary, government subsidies, and any other third-party payers. | number | - |
Total_Day_Supply | The aggregate number of day’s supply for which this drug was dispensed. | number | level : Ratio |
Beneficiary_Count_Of_Age_65 | The total number of unique Medicare Part D beneficiaries age 65 and older with at least one claim for the drug. A blank indicates the value is suppressed | integer | level : Ratio |
Supression_Reason_Of_Beneficiary_Count_Age_65 | A flag indicating the reason the bene_count_ge65 variable is suppressed. * = Primary suppressed due to bene_count_ge65 between 1 and 10. # = Counter suppressed because the “less than 65 year old” group (not explicitly displayed) contains a beneficiary count between 1 and 10, which can be mathematically determined from bene_count_ge65 and bene_count. | string | - |
Total_Claim_Count_Age_65 | The number of Medicare Part D claims for beneficiaries age 65 and older. This includes original prescriptions and refills. A blank indicates the value is suppressed | number | level : Ratio |
Supression_Reason_Age_65 | A flag that indicates the reason the variable is suppressed. * = Primary suppressed due to total_claim_count_ge65 between 1 and 10. # = Counter suppressed because the “less than 65 year old” group (not explicitly displayed) contains a small claim count between 1 and 10, which can be mathematically determined from the total_claim_count_ge65 and total_claim_count. | string | - |
Total_Drug_Cost_Age_65 | The aggregate total drug cost paid for all associated claims for beneficiaries aged 65 and older. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. If total_claim_count_ge65 is suppressed, this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Total_Day_Supply_Age_65 | The aggregate number of day’s supply for which this drug was dispensed, for beneficiaries age 65 or older. If total_claim_count_ge65 is suppressed, this variable is suppressed. A blank indicates the value is suppressed. | number | level : Ratio |
Brand_Claim_Count | Total claims of brand-name drugs, including refills. This is based on the Food and Drug Administration approval category of New Drug Application (NDA), NDA authorized generic, or Biologic License Application (BLA). A blank indicates the value is suppressed. | number | level : Ratio |
Brand_Supression_Flag | A flag indicating the reason the brand_claim_count and brand_drug_cost variables are suppressed. * = Primary suppressed due to brand_claim_count between 1 and 10. # = Counter suppressed because the claim count from at least one of the corresponding claim count categories (generic_claim_count or other_claim_count) is between 1 and 10. Counter suppression prevents the disclosure of a primary suppressed value when all categories sum to the total value. | string | - |
Brand_Drug_Cost | Aggregate total drug cost paid for brand-name drugs. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. This is based on the Food and Drug Administration approval category of NDA, NDA authorized generic, or BLA. If brand_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Generic_Claim_Count | Total claims of generic drugs, including refills. This is based on the Food and Drug Administration approval category of Abbreviated New Drug Application (ANDA). A blank indicates the value is suppressed. | number | level : Ratio |
Generic_Supression_Flag | A flag indicating the reason the generic_claim_count and generic_drug_cost variables are suppressed. * = Primary suppressed due to generic_claim_count between 1 and 10. # = Counter suppressed because the claim count from at least one of the corresponding claim count categories (brand_claim_count or other_claim_count) is between 1 and 10. Counter suppression prevents the disclosure of a primary suppressed value when all categories sum to the total value. | string | - |
Generic_Drug_Cost | Aggregate cost paid for generic drugs. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. This is based on the Food and Drug Administration approval category of ANDA. If generic_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Other_Claim_Count | Total claims of other drugs, including refills. This is based any other Food and Drug Administration approval categories not included in the brand or generic definitions above. A blank indicates the value is suppressed. | number | level : Ratio |
Other_Supression_Flag | A flag indicating the reason other_claim_count and other_drug_cost variables are suppressed. * = Primary suppressed due to other_claim_count between 1 and 10. # = Counter suppressed because the claim count from at least one of the corresponding claim count categories (brand_claim_count or generic_claim_count) is between 1 and 10. Counter suppression prevents the disclosure of a primary suppressed value when all categories sum to the total value. | string | - |
Other_Drug_Cost | Aggregate cost paid for all other drugs not classified as brand or generic. This amount includes ingredient cost, dispensing fee and sales tax. This is based any other Food and Drug Administration approval categories not included in the brand or generic definitions above. If other_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
MAPD_Claim_Count | The number of claims for beneficiaries covered by MAPD plans. A blank indicates the value is suppressed. | number | level : Ratio |
MAPD_Supression_Flag | A flag indicating the reason the mapd_claim_count and mapd_drug_cost variables are suppressed. * = Primary suppressed due to mapd_claim_count between 1 and 10. # = Counter suppressed because the pdp_claim_count contains a claim count between 1 and 10, which can be mathematically determined from the mapd_claim_count and total_claim_count. | string | - |
MAPD_Drug_Cost | Aggregate cost paid for claims filled by beneficiaries in MAPD plans. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. If mapd_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
PDP_Claim_Count | The number of claims for beneficiaries covered by stand-alone PDPs. A blank indicates the value is s suppressed. | number | level : Ratio |
PDP_Supression_Flag | A flag indicating the reason the pdp_claim_count and pdp_drug_cost variables are suppressed. * = Primary suppressed due to pdp_claim_count between 1 and 10. # = Counter suppressed because the mapd_claim_count contains a claim count between 1 and 10, which can be mathematically determined from the pdp_claim_count and total_claim_count. | string | - |
PDP_Drug_Cost | Aggregate total drug cost paid for claims filled by beneficiaries in stand-alone PDPs. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. If pdp_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | level : Ratio |
LIS_Claim_Count | Total number of claims from this prescriber, including refills, for beneficiaries with a Part D low-income subsidy. A blank indicates the value is suppressed. | number | level : Ratio |
LIS_Supression_Flag | A flag indicating the reason the lis_claim_count and lis_drug_cost variables are suppressed. * = Primary suppressed due to lis_claim_count between 1 and 10. # = Counter suppressed because nonlis_claim_count contains a claim count between 1 and 10, which can be mathematically determined from the lis_claim_count and total_claim_count. | string | - |
LIS_Drug_Cost | Aggregate total drug cost paid for claims for beneficiaries with a Part D low-income subsidy. This amount includes ingredient cost, dispensing fee and sales tax. If lis_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Non_LIS_Claim_Count | Total number of claims from this prescriber, including refills, for beneficiaries without a Part D low-income subsidy. A blank indicates the value is suppressed. | number | level : Ratio |
Non_LIS_Supression_Flag | A flag indicating the reason the nonlis_claim_count and nonlis_drug_cost variables are suppressed. * = Primary suppressed due to nonlis_claim_count between 1 and 10. # = Counter suppressed because lis_claim_count contains a claim count between 1 and 10, which can be mathematically determined from the nonlis_claim_count and total_claim_count. | string | - |
Non_LIS_Drug_Cost | Aggregate total drug cost paid for claims for beneficiaries without a Part D low-income subsidy. This amount includes ingredient cost, dispensing fee, sales tax, and any applicable vaccine administration fees. If nonlis_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Opioid_Beneficiary_Count | The total number of unique Medicare Part D beneficiaries with at least one opioid claim. The opioid_bene_count is suppressed when opioid beneficiary count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Opioid_Claim_Count | Total claims of opioid drugs, including refills. The opioid_claim_count is suppressed when opioid_claim_count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Opioid_Drug_Cost | Aggregate cost paid for opioid drugs. This amount includes ingredient cost, dispensing fee and sales tax. If opioid_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed | number | - |
Opioid_Day_Supply | The aggregate number of day’s supply for opioid drugs. If opioid_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | level : Ratio |
Antibiotic_Beneficiary_Count | The total number of unique Medicare Part D beneficiaries with at least one antibiotic claim. The antibiotic_bene_count is suppressed when antibiotic_bene_count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Antibiotic_Claim_Count | Total claims of antibiotic drugs, including refills. The antibiotic_claim_count is suppressed when antibiotic_claim_count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Antibiotic_Drug_Cost | Aggregate cost paid for antibiotic drugs. If antibiotic_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
HRM_Beneficiary_Count_Age_65 | The total number of unique Medicare Part D beneficiaries 65 and older with at least one high-risk medication claim. A blank indicates the value is suppressed. See hrm_bene_ge65_suppress_flag regarding suppression of data. | number | level : Ratio |
HRM_Beneficiary_Age_65_Suppress_Flag | A flag indicating the reason the hrm_bene_count_ge65 variable is suppressed. * = Primary suppressed due to hrm_bene_count_ge65 counts between 1 and 10. # = Counter suppressed because the bene_count_ge65 is suppressed. See bene_count_ge65_suppress_flag regarding suppression of bene_count_ge65. | string | - |
HRM_Claim_Count_Age_65 | Total claims of high-risk medication drugs, including refills for beneficiaries 65 and older. A blank indicates the value is suppressed. See hrm_ge65_suppress_flag regarding suppression of data. | number | level : Ratio |
HRM_Age_65_Suppress_Flag | A flag indicating the reason the hrm_claim_count_ge65 and hrm_drug_cost_ge65 variables are suppressed. * = Primary suppressed due to hrm_claim_count_ge65 between 1 and 10. # = Counter suppressed because claim_count_ge65 is suppressed. See ge65_suppress_flag regarding suppression of claim_count_ge65. | string | - |
HRM_Drug_Cost_Age_65 | Aggregate cost paid for high-risk medication drugs for beneficiaries 65 and older. If hrm_claim_count_ge65 is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Anti_Psych_Beneficiary_Count | The total number of unique Medicare Part D beneficiaries with at least one anti-psychotic claim. The anti_psych_bene_count is suppressed when anti_psych_bene_count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Anti_Psych_Claim_Count | Total claims of antipsychotic drugs, including refills. The anti_psych_claim_count is suppressed when anti_psych_claim_count is between 1 and 10. A blank indicates the value is suppressed. | number | level : Ratio |
Anti_Psych_Drug_Cost | Aggregate cost paid for anti-psychotic drugs. If anti_psych_claim_count is suppressed this variable is suppressed. A blank indicates the value is suppressed. | number | - |
Data Preview
National Provider Identifier | Last Name Organization Name | First Name | Middle Initial | Credentials | Gender | Entity Code | Street Address 1 | Street Address 2 | City | Zip Code 5 | Zip Code 4 | State Abbreviation | Country Code | Provider Specialty Type | Source Of Provider Specialty | Medicare Provider Enroll Status | Beneficiaries Count | Total Claim Count | Total Drug Cost | Total Day Supply | Beneficiary Count Of Age 65 | Supression Reason Of Beneficiary Count Age 65 | Total Claim Count Age 65 | Supression Reason Age 65 | Total Drug Cost Age 65 | Total Day Supply Age 65 | Brand Claim Count | Brand Supression Flag | Brand Drug Cost | Generic Claim Count | Generic Supression Flag | Generic Drug Cost | Other Claim Count | Other Supression Flag | Other Drug Cost | MAPD Claim Count | MAPD Supression Flag | MAPD Drug Cost | PDP Claim Count | PDP Supression Flag | PDP Drug Cost | LIS Claim Count | LIS Supression Flag | LIS Drug Cost | Non LIS Claim Count | Non LIS Supression Flag | Non LIS Drug Cost | Opioid Beneficiary Count | Opioid Claim Count | Opioid Drug Cost | Opioid Day Supply | Antibiotic Beneficiary Count | Antibiotic Claim Count | Antibiotic Drug Cost | HRM Beneficiary Count Age 65 | HRM Beneficiary Age 65 Suppress Flag | HRM Claim Count Age 65 | HRM Age 65 Suppress Flag | HRM Drug Cost Age 65 | Anti Psych Beneficiary Count | Anti Psych Claim Count | Anti Psych Drug Cost |
1518048750 | A VILES | OMAR | P | MD | M | I | 161 SAVILLE ROAD | MINEOLA | 11501 | 2341 | NY | US | Pediatric Medicine | S | N | 61 | 8040.37 | 2389 | # | # | 20.0 | 7204.01 | 41.0 | 836.36 | 0.0 | 0.0 | 46.0 | 5676.05 | 15.0 | 2364.32 | 32.0 | 5315.92 | 29.0 | 2724.45 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | ||||||||||||||||||
1952310666 | A'BODJEDI | ENENGE | MD | M | I | 32 STRAWBERRY HILL CT | BENNETT BEHAVIORAL HEALTH CENTER | STAMFORD | 6902 | 2594 | CT | US | Psychiatry | S | E | 221.0 | 4476 | 489179.73 | 133208 | 78.0 | 1311.0 | 83870.36 | 40370.0 | 620.0 | 313624.85 | 3856.0 | 175554.88 | 0.0 | 0.0 | 702.0 | 36452.03 | 3774.0 | 452727.7 | 4198.0 | 459342.32 | 278.0 | 29837.41 | 0.0 | 0.0 | 0.0 | 0.0 | 22.0 | 200.0 | 11325.0 | 112 | 1200 | 312118.2 | |||||||||||||||
1467482471 | AAB | BARRY | N | D.D.S. | M | I | 1101 DEFIANCE ST | WAPAKONETA | 45895 | 1058 | OH | US | Dentist | T | N | 24.0 | 41 | 192.11 | 317 | 24.0 | 41.0 | 192.11 | 317.0 | 0.0 | 0.0 | # | * | * | # | 0.0 | 0.0 | 41.0 | 192.11 | 19.0 | 28.0 | 118.23 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | ||||||||||||||||||||
1801093968 | AABERG | MELANIE | L | DO | F | I | 5450 FORT ST | EMERGENCY DEPT | TRENTON | 48183 | 4601 | MI | US | Emergency Medicine | S | E | 80.0 | 124 | 2635.65 | 1066 | 51.0 | 71.0 | 1651.17 | 660.0 | * | # | 0.0 | 0.0 | 25.0 | 634.37 | 99.0 | 2001.28 | 49.0 | 1146.15 | 75.0 | 1489.5 | 32.0 | 33.0 | 184.8 | 131.0 | 34.0 | 39.0 | 858.57 | * | * | 0 | 0 | 0.0 | ||||||||||||||
1588763981 | AABERG | RANDAL | A | MD | M | I | 3288 MOANALUA RD | HONOLULU | 96819 | 1469 | HI | US | Urology | S | E | 268.0 | 936 | 64554.41 | 58082 | # | 907.0 | 62593.17 | 56513.0 | 36.0 | 17592.42 | 900.0 | 46961.99 | 0.0 | 0.0 | # | * | 54.0 | 2139.24 | 882.0 | 62415.17 | 28.0 | 32.0 | 575.67 | 208.0 | 84.0 | 120.0 | 1429.37 | * | 11.0 | 323.0 | 0 | 0 | 0.0 | ||||||||||||||
1194753186 | AABERG | THOMAS | M | MD | M | I | 5030 CASCADE RD SE | GRAND RAPIDS | 49546 | 3725 | MI | US | Ophthalmology | S | E | 180.0 | 590 | 84860.97 | 19215 | 140.0 | 444.0 | 42928.52 | 14499.0 | 302.0 | 79041.14 | 250.0 | 5244.55 | 38.0 | 575.28 | 246.0 | 50040.46 | 344.0 | 34820.51 | 184.0 | 22603.24 | 406.0 | 62257.73 | 11.0 | 11.0 | 55.51 | 35.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | ||||||||||||
1750491783 | AABERG | THOMAS | M | MD | M | I | 1365 CLIFTON RD NE # B | ROOM 4405 | ATLANTA | 30322 | 1013 | GA | US | Ophthalmology | S | E | 14.0 | 24 | 4015.12 | 764 | # | # | # | * | * | * | # | * | # | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | ||||||||||||||||||||
1891993317 | AABIDA | AFEERA | M.D | F | I | 9717 Q ST | OMAHA | 68127 | 3272 | NE | US | Family Practice | S | E | 94.0 | 130 | 3438.55 | 1254 | 65.0 | 88.0 | 2415.52 | 803.0 | 16.0 | 1208.16 | 114.0 | 2230.39 | 0.0 | 0.0 | 22.0 | 736.83 | 108.0 | 2701.72 | 48.0 | 1140.29 | 82.0 | 2298.26 | 67.0 | 71.0 | 1984.72 | * | * | 0 | 0 | 0.0 | ||||||||||||||||||
1164404232 | AABY | AAZY | A | MD | M | I | 1955 NW NORTHRUP ST | PORTLAND | 97209 | 1614 | OR | US | Ophthalmology | S | E | 136.0 | 605 | 60988.53 | 23359 | # | 563.0 | 55120.71 | 21845.0 | 406.0 | 54935.49 | 199.0 | 6053.04 | 0.0 | 0.0 | 387.0 | 35151.87 | 218.0 | 25836.66 | 75.0 | 6205.4 | 530.0 | 54783.13 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | |||||||||||||||||||
1508090481 | AABY | KELLI | A | DDS | F | I | 2028 E RIVERSIDE BLVD | SUITE 210 | LOVES PARK | 61111 | 4804 | IL | US | Dentist | T | N | 46.0 | 66 | 436.84 | 441 | # | 52.0 | 348.96 | 364.0 | 0.0 | 0.0 | 66.0 | 436.84 | 0.0 | 0.0 | 15.0 | 119.25 | 51.0 | 317.59 | * | # | 44.0 | 56.0 | 341.59 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 |