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: Change effective April 1, 2022
Effective March 1, 2022, the American Hospital Formulary Service (AHFS) classification information is no longer available in the Drug Product Database data extracts.
Effective April 1, 2022 the two alternate versions of the therapeutic class files will be available for download. Please download the version of interest to you below.
The two versions of the therapeutic class files available are:
- Version 1 has the current format with the AHFS code and description fields blank, and
- Version 2 does not have the AHFS code and description fields and has the format outlined below:
| Name | Null? | Type |
|---|---|---|
| DRUG_CODE | NOT NULL | NUMBER(8) |
| TC_ATC_NUMBER | NULLABLE | VARCHAR2(8) |
| TC_ATC | NULLABLE | VARCHAR2(120) |
| TC_ATC_F | NULLABLE | VARCHAR2(240) |
The Allfiles files do not contain Version 1 or Version 2 of the therapeutic class files.
Finally, effective July 1, 2022, the AHFS code and description fields will be permanently removed from therapeutic class files and they will have the format outlined in Version 2 above.
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.
| DPD Extract Files Name |
New Files (UTF-8 format) Filename |
Last Updated |
|---|---|---|
| QRYM_BIOSIMILARS | bios.zip | 2022-05-02 |
| bios_ia.zip | 2022-05-02 | |
| bios_ap.zip | 2022-05-02 | |
| bios_dr.zip | 2022-05-02 | |
| QRYM_COMPANIES | comp.zip | 2022-05-02 |
| comp_ia.zip | 2022-05-02 | |
| comp_ap.zip | 2022-05-02 | |
| comp_dr.zip | 2022-05-02 | |
| QRYM_DRUG_PRODUCT | drug.zip | 2022-05-02 |
| drug_ia.zip | 2022-05-02 | |
| drug_ap.zip | 2022-05-02 | |
| drug_dr.zip | 2022-05-02 | |
| QRYM_FORM | form.zip | 2022-05-02 |
| form_ia.zip | 2022-05-02 | |
| form_ap.zip | 2022-05-02 | |
| form_dr.zip | 2022-05-02 | |
| QRYM_ACTIVE_INGREDIENTS | ingred.zip | 2022-05-02 |
| ingred_ia.zip | 2022-05-02 | |
| ingred_ap.zip | 2022-05-02 | |
| ingred_dr.zip | 2022-05-02 | |
| QRYM_INACTIVE_PRODUCTS | inactive.zip | 2022-05-02 |
| QRYM_PACKAGING | package.zip | 2022-05-02 |
| package_ia.zip | 2022-05-02 | |
| package_ap.zip | 2022-05-02 | |
| package_dr.zip | 2022-05-02 | |
| QRYM_PHARMACEUTICAL_STD | pharm.zip | 2022-05-02 |
| pharm_ia.zip | 2022-05-02 | |
| pharm_ap.zip | 2022-05-02 | |
| pharm_dr.zip | 2022-05-02 | |
| QRYM_ROUTE | route.zip | 2022-05-02 |
| route_ia.zip | 2022-05-02 | |
| route_ap.zip | 2022-05-02 | |
| route_dr.zip | 2022-05-02 | |
| QRYM_SCHEDULE | schedule.zip | 2022-05-02 |
| schedule_ia.zip | 2022-05-02 | |
| schedule_ap.zip | 2022-05-02 | |
| schedule_dr.zip | 2022-05-02 | |
| QRYM_STATUS | status.zip | 2022-05-02 |
| status_ia.zip | 2022-05-02 | |
| status_ap.zip | 2022-05-02 | |
| status_dr.zip | 2022-05-02 | |
| QRYM_THERAPEUTIC_CLASS | Version 1 | |
| ther.zip | 2022-05-02 | |
| ther_ia.zip | 2022-05-02 | |
| ther_ap.zip | 2022-05-02 | |
| ther_dr.zip | 2022-05-02 | |
| Version 2 | ||
| ther.zip | 2022-05-02 | |
| ther_ia.zip | 2022-05-02 | |
| ther_ap.zip | 2022-05-02 | |
| ther_dr.zip | 2022-05-02 | |
| QRYM_VETERINARY_SPECIES | vet.zip | 2022-05-02 |
| vet_ia.zip | 2022-05-02 | |
| vet_ap.zip | 2022-05-02 | |
| vet_dr.zip | 2022-05-02 | |
| ALL FILES | allfiles.zip | 2022-05-02 |
| allfiles_ia.zip | 2022-05-02 | |
| allfiles_ap.zip | 2022-05-02 | |
| allfiles_dr.zip | 2022-05-02 | |
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
- Date modified: