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

The data extract is a series of compressed  UTF-8 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 (filename_ap.zip), marketed (filename.zip), cancelled (filename_ia.zip) and dormant (filename_dr.zip) products, for human, veterinary, disinfectant and radiopharmaceutical use.

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

Notice: Changes effective September 1, 2017:

The DPD data extracts are being updated to comply with regulatory and technical requirements.

Starting September 1, 2017, a 6-month transition period will begin when both the old and new versions of the DPD data extracts will be posted simultaneously. The old DPD data extract files will no longer be posted as of February 1, 2018.

Changes to the New DPD Data Extracts

Four changes are being made to the new DPD data extracts. For further details on how these changes affect the structure of the extracts, please refer to the Read me file.

  • Where French data is available, these translations are now available in the extract files.
  • Fields for Lot Number and Expiration Date have been added to the QRYM_STATUS files.
    • For more details on the use of these fields, please refer to the Guidance Document: Cancellation of a Drug Identification Number (DIN) and Notification of the Discontinuation of Sales.
  • A new set of extract files have been created for Dormant products.
    • For more information on Dormant products, please refer to the Guidance Document: Cancellation of a Drug Identification Number (DIN) and Notification of the Discontinuation of Sales.
  • The text files are now being saved in UTF-8 format.

New vs. Old DPD Data Extracts

Both versions of the extracts will be posted on this landing page for the transition period. The zipped folders for the old DPD data extract files have been renamed to differentiate between the two. Note: The files within the zipped folders have not been renamed. E.g.:

Old DPD Data Extracts New DPD Data Extracts
Zipped folder: drug_ap_old_vieux.zip Zipped folder: drug_ap.zip
File: drug_ap.txt File: drug_ap.txt

No other changes to the old DPD data extracts have been made.

Mailing List

If you would like to receive communications regarding future changes to the DPD data extracts, please send an email to the following address to sign up for the mailing list: SIPD-Systems@hc-sc.gc.ca.

Table - DPD Extract Files
DPD Extract Files
Name
Old Files (ANSI format)
Filename
New Files (UTF-8 format)
Filename
Last Updated
QRYM_COMPANIES comp_old_vieux.zip (192 K) comp.zip (204 K) 2017-09-01
comp_ia_old_vieux.zip (414 K) comp_ia.zip (442 K) 2017-09-01
comp_ap_old_vieux.zip (91 K) comp_ap.zip (82 K) 2017-09-01
comp_dr.zip (16 K) 2017-09-01
QRYM_DRUG_PRODUCT drug_old_vieux.zip (306 K) drug.zip (332 K) 2017-09-01
drug_ia_old_vieux.zip (668 K) drug_ia.zip (686 K) 2017-09-01
drug_ap_old_vieux.zip (135 K) drug_ap.zip (110 K) 2017-09-01
drug_dr.zip (32 K) 2017-09-01
QRYM_FORM form_old_vieux.zip (43 K) form.zip (50 K) 2017-09-01
form_ia_old_vieux.zip (80 K) form_ia.zip (92 K) 2017-09-01
form_ap_old_vieux.zip (20 K) form_ap.zip (16 K) 2017-09-01
form_dr.zip (5.9 K) 2017-09-01
QRYM_ACTIVE_INGREDIENTS ingred_old_vieux.zip (278 K) ingred.zip (273 K) 2017-09-01
ingred_ia_old_vieux.zip (832 K) ingred_ia.zip (788 K) 2017-09-01
ingred_ap_old_vieux.zip (116 K) ingred_ap.zip (139 K) 2017-09-01
ingred_dr.zip (37 K) 2017-09-01
QRYM_INACTIVE_PRODUCTS inactive_old_vieux.zip (455 K) inactive.zip (462 K) 2017-09-01
QRYM_PACKAGING package_old_vieux.zip (65 K) package.zip (73 K) 2017-09-01
package_ia_old_vieux.zip (120 K) package_ia.zip (123 K) 2017-09-01
package_ap_old_vieux.zip (21 K) package_ap.zip (16 K) 2017-09-01
package_dr.zip (7.2 K) 2017-09-01
QRYM_PHARMACEUTICAL_STD pharm_old_vieux.zip (15 K) pharm.zip (16 K) 2017-09-01
pharm_ia_old_vieux.zip (25 K) pharm_ia.zip (25 K) 2017-09-01
pharm_ap_old_vieux.zip (4.9 K) pharm_ap.zip (2.6 K) 2017-09-01
pharm_dr.zip (2.6 K) 2017-09-01
QRYM_ROUTE route_old_vieux.zip (47 K) route.zip (55 K) 2017-09-01
route_ia_old_vieux.zip (70 K) route_ia.zip (81 K) 2017-09-01
route_ap_old_vieux.zip (23 K) route_ap.zip (18 K) 2017-09-01
route_dr.zip (6.8 K) 2017-09-01
QRYM_SCHEDULE schedule_old_vieux.zip (33 K) schedule.zip (37 K) 2017-09-01
schedule_ia_old_vieux.zip (55 K) schedule_ia.zip (62 K) 2017-09-01
schedule_ap_old_vieux.zip (15 K) schedule_ap.zip (12 K) 2017-09-01
schedule_dr.zip (4.5 K) 2017-09-01
QRYM_STATUS status_old_vieux.zip (173 K) status.zip (198 K) 2017-09-01
status_ia_old_vieux.zip (267 K) status_ia.zip (285 K) 2017-09-01
status_ap_old_vieux.zip (51 K) status_ap.zip (48 K) 2017-09-01
status_dr.zip (25 K) 2017-09-01
QRYM_THERAPEUTIC_CLASS ther_old_vieux.zip (129 K) ther.zip (131 K) 2017-09-01
ther_ia_old_vieux.zip (208 K) ther_ia.zip (214 K) 2017-09-01
ther_ap_old_vieux.zip (58 K) ther_ap.zip (44 K) 2017-09-01
ther_dr.zip (17 K) 2017-09-01
QRYM_VETERINARY_SPECIES vet_old_vieux.zip (9.6 K) vet.zip (9.7 K) 2017-09-01
vet_ia_old_vieux.zip (9.5 K) vet_ia.zip (11 K) 2017-09-01
vet_ap_old_vieux.zip (1.9 K) vet_ap.zip (2.1 K) 2017-09-01
vet_dr.zip  2017-09-01
ALL FILES allfiles_old_vieux.zip (1300 K) allfiles.zip (1408 K) 2017-09-01
allfiles_ia_old_vieux.zip (3200 K) allfiles_ia.zip (3200 K) 2017-09-01
allfiles_ap_old_vieux.zip (532 K) allfiles_ap.zip (485 K) 2017-09-01
allfiles_dr.zip (152 K) 2017-09-01

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: