Compare
Compare archived captures
This view highlights text differences between two archived captures. It does not interpret meaning or provide guidance.
Descriptive changes only
This comparison highlights text changes between archived captures. It does not interpret the change or provide medical advice. For up-to-date recommendations, always consult the official source website.
Need to cite this comparison? See /cite.
Earlier capture
What is the DPD Data Extract? - Drug Product Database (DPD) Data Extract - Health Canada - Canada.ca
Apr 19, 2025
legacy-hc-2025-04-21
ID 206571
Later capture
Health Canada Drug Product Database (DPD) data extract - Canada.ca
Jan 1, 2026
hc-20260101
ID 404972
High-noise change
This change may include layout or boilerplate updates (such as navigation or footer adjustments). Treat the diff as descriptive, not definitive.
updated1 sections changed; 2 added; 3 removed (high-noise change)
1 sections changed2 added3 removed+59 / -66 linesChange ratio: 43%
--- +++ @@ -1,17 +1,11 @@-What is the DPD Data Extract? - Drug Product Database (DPD) Data Extract - Health Canada+Health Canada Drug Product Database (DPD) data extract The data extract is a series of compressed UTF-8 text files of the database. The uncompressed size of the files is approximately 108 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: April 1, 2025 Data Extracts-In late March, the Health Products and Food Branch modernized the database application that populates the DPD extracts.-As a result, the extracts published on April 1, 2025, will contain data up to and including March 21, 2025, and have a Last Updated date of March 27, 2025.-This will mean some product changes made later in March will not be available in those extracts. However, these products and changes will be in the DPD online.-On May 1, 2025, the extracts will reflect a full dataset.-Mailing List+Get more information about the DPD data extract structure:+About the drug product database data extract structure+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+osip.sys-bppi@hc-sc.gc.ca . NOTE: Do NOT rename any of the zip files, stakeholders will have trouble if you do DPD Extract Files@@ -21,128 +15,127 @@ Last Updated QRYM_BIOSIMILARS bios.zip-2025-03-27+2025-12-01 bios_ia.zip-2025-03-27+2025-12-01 bios_ap.zip-2025-03-27+2025-12-01 bios_dr.zip-2025-03-27+2025-12-01 QRYM_COMPANIES comp.zip-2025-03-27+2025-12-01 comp_ia.zip-2025-03-27+2025-12-01 comp_ap.zip-2025-03-27+2025-12-01 comp_dr.zip-2025-03-27+2025-12-01 QRYM_DRUG_PRODUCT drug.zip-2025-03-27+2025-12-01 drug_ia.zip-2025-03-27+2025-12-01 drug_ap.zip-2025-03-27+2025-12-01 drug_dr.zip-2025-03-27+2025-12-01 QRYM_FORM form.zip-2025-03-27+2025-12-01 form_ia.zip-2025-03-27+2025-12-01 form_ap.zip-2025-03-27+2025-12-01 form_dr.zip-2025-03-27+2025-12-01 QRYM_ACTIVE_INGREDIENTS ingred.zip-2025-03-27+2025-12-01 ingred_ia.zip-2025-03-27+2025-12-01 ingred_ap.zip-2025-03-27+2025-12-01 ingred_dr.zip-2025-03-27+2025-12-01 QRYM_INACTIVE_PRODUCTS inactive.zip-2025-03-27+2025-12-01 QRYM_PACKAGING package.zip-2025-03-27+2025-12-01 package_ia.zip-2025-03-27+2025-12-01 package_ap.zip-2025-03-27+2025-12-01 package_dr.zip-2025-03-27+2025-12-01 QRYM_PHARMACEUTICAL_STD pharm.zip-2025-03-27+2025-12-01 pharm_ia.zip-2025-03-27+2025-12-01 pharm_ap.zip-2025-03-27+2025-12-01 pharm_dr.zip-2025-03-27+2025-12-01 QRYM_ROUTE route.zip-2025-03-27+2025-12-01 route_ia.zip-2025-03-27+2025-12-01 route_ap.zip-2025-03-27+2025-12-01 route_dr.zip-2025-03-27+2025-12-01 QRYM_SCHEDULE schedule.zip-2025-03-27+2025-12-01 schedule_ia.zip-2025-03-27+2025-12-01 schedule_ap.zip-2025-03-27+2025-12-01 schedule_dr.zip-2025-03-27+2025-12-01 QRYM_STATUS status.zip-2025-03-27+2025-12-01 status_ia.zip-2025-03-27+2025-12-01 status_ap.zip-2025-03-27+2025-12-01 status_dr.zip-2025-03-27+2025-12-01 QRYM_THERAPEUTIC_CLASS ther.zip-2025-03-27+2025-12-01 ther_ia.zip-2025-03-27+2025-12-01 ther_ap.zip-2025-03-27+2025-12-01 ther_dr.zip-2025-03-27+2025-12-01 QRYM_VETERINARY_SPECIES vet.zip-2025-03-27+2025-12-01 vet_ia.zip-2025-03-27+2025-12-01 vet_ap.zip-2025-03-27+2025-12-01 vet_dr.zip-2025-03-27+2025-12-01 ALL FILES allfiles.zip-2025-03-27+2025-12-01 allfiles_ia.zip-2025-03-27+2025-12-01 allfiles_ap.zip-2025-03-27+2025-12-01 allfiles_dr.zip-2025-03-27+2025-12-01 Copyright For information on copyright and who to contact, please visit the Drug Product Database Terms and Conditions . Page details-Date modified:-2025-03-31+2025-12-02