The following material originates with an organization not subject to the Official Languages Act and is available on this site in the language in which it was written.
Help on accessing alternative formats, such as Portable Document Format (PDF), Microsoft Word and PowerPoint (PPT) files, can be obtained in the alternate format help section.
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 have been updated. They contain complete product information for all discontinued (inactivated) products. The product information available for discontinued (inactivated) products will be the same as the one we have been providing for marketed (active) products in the extract files.
In addition to the new information available for all discontinued (inactivated) products, the previous "inactive.txt" extract will remain available to users and will not be removed.
For more information on the Data Extract structure consult the Read me file.
|QRYM_COMPANIES||comp.zip ( 122 K)||2013-05-02|
|comp_ia.zip ( 495 K)||2013-05-02|
|QRYM_DRUG_PRODUCT||drug.zip ( 360 K)||2013-05-02|
|drug_ia.zip ( 841 K)||2013-05-02|
|QRYM_FORM||form.zip ( 58 K)||2013-05-02|
|form_ia.zip ( 128 K)||2013-05-02|
|QRYM_ACTIVE_INGREDIENTS||ingred.zip ( 255 K)||2013-05-02|
|ingred_ia.zip ( 1222 K)||2013-05-02|
|QRYM_INACTIVE_PRODUCTS||inactive.zip ( 550 K)||2013-05-02|
|QRYM_PACKAGING||package.zip ( 80 K)||2013-05-02|
|package_ia.zip ( 159 K)||2013-05-02|
|QRYM_PHARMACEUTICAL_STD||pharm.zip ( 25 K)||2013-05-02|
|pharm_ia.zip ( 40 K)||2013-05-02|
|QRYM_ROUTE||route.zip ( 63 K)||2013-05-02|
|route_ia.zip ( 105 K)||2013-05-02|
|QRYM_SCHEDULE||schedule.zip ( 47 K)||2013-05-02|
|schedule_ia.zip ( 88 K)||2013-05-02|
|QRYM_STATUS||status.zip ( 256 K)||2013-05-02|
|status_ia.zip ( 446 K)||2013-05-02|
|QRYM_THERAPEUTIC_CLASS||ther.zip ( 88 K)||2013-05-02|
|ther_ia.zip ( 244 K)||2013-05-02|
|QRYM_VETERINARY_SPECIES||vet.zip ( 12 K)||2013-05-02|
|vet_ia.zip ( 10 K)||2013-05-02|
|ALL FILES||allfiles.zip ( 1366 K)||2013-05-02|
|allfiles_ia.zip ( 4327 K)||2013-05-02|
Drug Product Database. ęHer Majesty the Queen in Right of Canada. All rights reserved. No part of the DPD may be reproduced, in whole or in part, for any purpose, without prior written permission from the Government of Canada's copyright administrator, Communication Canada. To obtain permission to reproduce the DPD please contact:
Public Works and Government Services Canada
Publishing and Depository Services
350 Albert Street, 4th Floor