Drug Approvals and Databases > Drugs@FDA Data Files

-Drugs@FDA Data Files


NOTE: Data files are now tab-delimited format, without quotes.

Below you will find a compressed data file of the Drugs@FDA database. It does not include the scripts (programming) we use to produce the online version of Drugs@FDA. We are providing this technical information for users who are familiar with working with databases or spreadsheets. All fields are separated by tab delimters. Each table's primary key, data types, field lengths and nulls appear in the list below. While the official online application, Drugs@FDA, is updated daily, this data file is updated once per week, on Wednesday.

Once you have downloaded the compressed file (drugsatfda.zip), you can unzip the file into 9 text tables. You can then import the tables into a database, spreadsheet or word processing program. Generally, a database program is the best program to use for these types of files.

We cannot offer guidance on how to construct your database design, as each user has different requirements or uses.

Download the Drugs@FDA Data File (Zip - 1.5MB) Last updated: 1/5/2011.
Entity Relationship Diagram
Drug Approvals and Databases > Drugs@FDA Data Files