What is the DPD Data Extract? - Drug Product Database (DPD) Data Extract - Health Canada

The data extract is a series of compressed ASCII text files of the database. The uncompressed size of the files is approximately 65 MB. In order to utilize the data, the file must be loaded into an existing database or information system. The typical user is most likely a third party claims adjudicator, provincial formulary, insurance company, etc. For a casual user to use this file, they must be familiar with database structure and capable of setting up their own queries. The "Read me" file contains the data structure required to download the zipped files.

The DPD extract files contain complete product information for all approved, marketed and cancelled products, for human, veterinary, disinfectant and radiopharmaceutical use.

Notice: Changes effective August 1, 2015: In the product files, the terminology for the 'Discontinued' statuses has been changed to 'Cancelled' to be consistent with the Regulatory terminology and will include the following:

  • 'CANCELLED POST MARKET'
  • 'CANCELLED PRE MARKET'

For more information on the Data Extract structure consult the Read me file.

DPD Extract Files
Name Filename Last Updated
QRYM_COMPANIES comp.zip (210 K) 2017-06-01
comp_ia.zip (397 K) 2017-06-01
comp_ap.zip (81 K) 2017-06-01
 
QRYM_DRUG_PRODUCT drug.zip (339 K) 2017-06-06
drug_ia.zip (645 K) 2017-06-06
drug_ap.zip (112 K) 2017-06-06
 
QRYM_FORM form.zip (47 K) 2017-06-06
form_ia.zip (77 K) 2017-06-06
form_ap.zip (16 K) 2017-06-06
 
QRYM_ACTIVE_INGREDIENTS ingred.txt (303 K) 2017-06-06
ingred_ia.zip (810 K) 2017-06-06
ingred_ap.zip (98 K) 2017-06-06
 
QRYM_INACTIVE_PRODUCTS inactive.zip (439 K) 2017-06-06
 
QRYM_PACKAGING package.zip (71 K) 2017-06-06
package_ia.zip (116 K) 2017-06-06
package_ap.zip (15 K) 2017-06-06
 
QRYM_PHARMACEUTICAL_STD pharm.zip (16 K) 2017-06-06
pharm_ia.zip (24 K) 2017-06-06
pharm_ap.zip (3 K) 2017-06-06
 
QRYM_ROUTE route.zip (51 K) 2017-06-06
route_ia.zip (67 K) 2017-06-06
route_ap.zip (18 K) 2017-06-06
 
QRYM_SCHEDULE schedule.zip (36 K) 2017-06-06
schedule_ia.zip (52 K) 2017-06-06
schedule_ap.zip (12 K) 2017-06-06
 
QRYM_STATUS status.zip (186 K) 2017-06-06
status_ia.zip (253 K) 2017-06-06
status_ap.zip (30 K) 2017-06-06
 
QRYM_THERAPEUTIC_CLASS ther.zip (142 K) 2017-06-06
ther_ia.zip (200 K) 2017-06-06
ther_ap.zip (44 K) 2017-06-06
 
QRYM_VETERINARY_SPECIES vet.zip (10 K) 2017-06-06
vet_ia.zip (9 K) 2017-06-06
vet_ap.zip (2 K) 2017-06-06
 
ALL FILES allfiles.zip (1411 K) 2017-06-06
allfiles_ia.zip (3089 K) 2017-06-06
allfiles_ap.zip (431 K) 2017-06-06

Copyright

For information on copyright and who to contact, please visit the Drug Product Database Terms and Conditions.

Report a problem or mistake on this page
Please select all that apply:

Privacy statement

Thank you for your help!

You will not receive a reply. For enquiries, contact us.

Date modified: