Skip to main content

The FDA offers an NDC searchable database.

The National Drug Code (NDC) Directory data is offered here in SAS, Stata, and CSV formats to make the whole database a bit easier to use.

Updates and changes.

Data

Data Type File Type Documentation
Package dta, 244, sas, csv doc, desc
Product dta, 244, sas, csv doc, desc

Pre-Stata13 had a string length limit of 244 characters.

Some additional historic files are available in the CCYY/CCYYMMDD folders where CCYY is the year, MM is the month, and DD is the day.

Deliveries from June 2, 2012 and earlier do not contain the NDC variable. Instead, they include the three segments of the NDC variable: the labeler code, product code, and package size code.

Jean Roth created the NDC to labeler code product code crosswalk based on the FDA NDC data deliveries from January 8, 2007 through June 2, 2012. and the NDC to labeler code, product code, and package size crosswalk based upon CMS' Medicaid State Drug Utiization data for 1991 on to address this.

Jean Roth created the ndc to labeler code and product code crosswalk files below to address this.

20120602

Data Type File Type Documentation
DEA Schedule Designation source, dta, sas, csv desc
Dosage Form source, dta, sas, csv desc
Dosage Form Codes source, dta, sas, csv desc
Firm Name source, dta, sas, csv desc
Formulations source, dta, sas, csv desc
Listings source, dta, sas, csv desc
New Drug Application source, dta, sas, csv desc
Packages source, dta, sas, csv desc
Potency Unit Abbreviations source, dta, sas, csv desc
Registered Sites source, dta, sas, csv desc
Route Codes source, dta, sas, csv desc
Route of Administration source, dta, sas, csv desc

Old NDC Data File 10/20/2011

Data Type File Type Documentation
DEA Schedule Designation source, dta, sas, csv desc
Dosage Form source, dta, sas, csv desc
Dosage Form Codes source, dta, sas, csv desc
Firm Name source, dta, sas, csv desc
Formulations source, dta, sas, csv desc
Listings source, dta, sas, csv desc
New Drug Application source, dta, sas, csv desc
Packages source, dta, sas, csv desc
Potency Unit Abbreviations source, dta, sas, csv desc
Registered Sites source, dta, sas, csv desc
Route Codes source, dta, sas, csv desc
Route of Administration source, dta, sas, csv desc

Old NDC Data File 06/11/2011

Data Type File Type Documentation
DEA Schedule Designation source, dta, sas, csv desc
Dosage Form source, dta, sas, csv desc
Dosage Form Codes source, dta, sas, csv desc
Firm Name source, dta, sas, csv desc
Formulations source, dta, sas, csv desc
Listings source, dta, sas, csv desc
New Drug Application source, dta, sas, csv desc
Packages source, dta, sas, csv desc
Potency Unit Abbreviations source, dta, sas, csv desc
Registered Sites source, dta, sas, csv desc
Route Codes source, dta, sas, csv desc
Route of Administration source, dta, sas, csv desc

 

 

Old NDC Data File 01/03/2011

Data Type File Type Documentation
DEA Schedule Designation source, dta, sas, csv desc
Dosage Form source, dta, sas, csv desc
Dosage Form Codes source, dta, sas, csv desc
Firm Name source, dta, sas, csv desc
Formulations source, dta, sas, csv desc
Listings source, dta, sas, csv desc
New Drug Application source, dta, sas, csv desc
Packages source, dta, sas, csv desc
Potency Unit Abbreviations source, dta, sas, csv desc
Registered Sites source, dta, sas, csv desc
Route Codes source, dta, sas, csv desc
Route of Administration source, dta, sas, csv desc

20100701

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

20100520

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

20100402

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

20100301

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

 

20081203

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

 

20080902

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Scehdule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

 

20070706

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Schedule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

 

20070108

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Schedule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

--

 

20060608

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

--

--

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Schedule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

--

 

20050630

Listings

Packages

Formulations

New Drug Application

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

Firm Name

Route of Administration

Dosage Form

Registered Sites

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

--

--

Dosage Form Codes

Route Codes

Potency Unit Abbreviations

DEA Schedule Designation

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

Source

Stata

SAS

CSV

Desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

txt

dta

sas7bdat

csv

desc

--

Some additional historic files are available in the CCYY/CCYYMMDD folders where CCYY is the year, MM is the month, and DD is the day.

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, and the Bulletin on Health — as well as online conference reports, video lectures, and interviews.

 

 

feldsteinlecture2021.JPG
  • Lecture
Alan J. Auerbach, the Robert D. Birch Professor of Economics and Law at the University of California, Berkeley, and...
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...
2021methodslecture.jpg
  • Lecture
The credible estimation of causal effects is a central task of applied econometrics. Two tools for this purpose that...