Skip to main content

The source NPPES files for 2008 on contain up to 50 other identifiers per NPI which can have any of the following types:

  • 1 Other
  • 2 Medicare UPIN
  • 4 Medicare ID-Type Unspecified
  • 5 Medicaid
  • 6 Medicare Oscar/Certification
  • 7 Medicare NSC
  • 8 Medicare PIN

Jean Roth created the NPI to UPIN crosswalk below from the National Plan and Provider Enumeration System (NPPES) downloadable data file for greater ease of use. An NPI can and often does have more than one UPIN associated with it. The crosswalk includes identifiers of any stated type if they look like a UPIN. That is, if they begin with a letter followed by five digits.

One limitation this dataset is that the provider had to include their old UPIN on the NPI application in order for the UPIN to appear here.

 

Another limitation is that CMS stopped delivering the medicare other provider identifers in January 2018. The files here are based on the December 2017 delivery.

To keep only records for individuals, I suggest dropping records with upintype == 4 (Group UPIN) or entity == 2 (Entity is an Organization, not an Individual).

The upintype and pcredential variables may be helpful for identifying and keeping only providers of certain types.

UPIN types are the following:
1 "Medical Doctors (Medical Doctors and Doctors of Osteopathy) (Char 1 UPIN A-M)"
2 "Non-physician Practicioners (Such as Anesthesia Assistants, Physician Assistants, Clinical Nurse Practioners) (Char 1 UPIN P-S)"
3 "Other Doctors (Such as Chiropractors, Dentists, Podiatrists, and Optometrists) (Char 1 UPIN T-V)"
4 "Group UPIN UPIN (Char 1 UPIN W-Z)"

The pcredential variable contains the credential information (e.g. M.D., D.O.) from the NPI Application form.

Processed versions of the source NPPES data these files are made from and an NPI to state license crosswalk, and an NPI to Medicare crosswalk and an NPI to Medicaid crosswalk are also available.

 

Updates and changes.

December 2017 -- Last delivery with fuller range of Medicare Other Provider Identifier Type Codes

 

Stata

SAS

CSV

Desc

  npi2upinxw.dta     npi2upinxw.sas7bdat     npi2upin.csv     desc_npi2upin.txt  
  upin2npixw.dta     upin2npixw.sas7bdat     upin2npi.csv     desc_upin2npi.txt  

Current

Stata

SAS

CSV

Desc

  npi2upinxw.dta     npi2upinxw.sas7bdat     npi2upin.csv     desc_npi2upin.txt  
  upin2npixw.dta     upin2npixw.sas7bdat     upin2npi.csv     desc_upin2npi.txt  

Contact data@nber.org with questions, comments, or suggestions.

Related

Topics

More from NBER

In addition to working papers, the NBER disseminates affiliates’ latest findings through a range of free periodicals — the NBER Reporter, the NBER Digest, the Bulletin on Retirement and Disability, the Bulletin on Health, and the Bulletin on Entrepreneurship — as well as online conference reports, video lectures, and interviews.

Gita Gopinath The 2022 Martin Feldstein Lecture: Managing a Turn in the Global Financial Cycle Primary tabs
  • Lecture
Gita Gopinath, the first deputy managing director of the International Monetary Fund, delivered the 2022 Martin...
 2022 Summer Institute Methods Lectures: Empirical Bayes Methods, Theory and Application image
  • Lecture
Large data sets that include observations on many workers at a given firm, multiple decisions by individual judges,...
2021_NobelPrizewinners_Angrist_Card_Imbens
  • Article
Long-time NBER research associates Joshua Angrist, David Card, and Guido Imbens have been awarded the 2021 Nobel Prize in Economic Sciences in recognition of...