National Provider Identifier (NPI) to Drug Enforcement Agency Number (DEA) Crosswalk
The National Provider Indetifier (NPI) became the national standard identifier in May 2007.
The Centers for Medicare & Medicaid Services (CMS) has developed the
National Plan and Provider Enumeration System (NPPES)
to assign unique identifiers to health care providers.
The NPPES files contain all of the FOIA-disclosable data
for active and deactivated providers in NPPES.
The source NPPES files for 2008 on contain up to 50 other identifiers per NPI which can have any of the following types:
Jean Roth created the NPI to DEA 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 DEA associated with it. The DEA number format is 9 alpha-numeric characters with the first two characters alpha and the last seven numeric. The crosswalk includes identifiers of any stated type if they look like the could be a DEA number. That is, if they have two letters and six digits, or the Other Provider Identifier Issuer variable OTHPIDISS matches "DEA" (and not "DEAN"). Obviously, this definition is quite liberal.
A second limitation this dataset is that providers don't have to include their DEA number or any other type of other identifier in their NPI application to request an NPI. My understanding is that health care providers must apply for DEA numbers in order to be able to write prescriptions.
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, you could drop records where entity == 2 (Entity is an Organization, not an Individual) or the DEA type looks like an institution rather than a practioner per the DUATYPE variable.
The deatype and pcredential variables might be helpful for identifying and keeping only providers of certain types.
The first character of the DEA number seems to represent the following
per the Department of Justice:
A Deprecated (used by some older entities)
D Teaching Institution
H Analytic Lab
L Reverse Distributor
M Mid-Level Practitioner
P/R/S/T Narcotic Treatment Program
X Suboxone/Subutex Prescribing Program
The pcredential variable contains the credential information (e.g. M.D., D.O.) from the NPI Application form.
December 2017 -- Last delivery with fuller range of Medicare Other Provider Identifier Type Codes
To report problems or if you have comments or suggestions , e-mail Jean Roth at email@example.com