2024-02-01 19:20:00
The data extract is a series of compressed UTF-8 files from the database. The uncompressed format takes up approximately 65 MB. To use the data, you must load the file into an existing database or information system. Typical users are usually third party reviewers, provincial drug formularies, insurance companies, etc. To use the file, the casual user must be familiar with the structure of the database and be able to formulate their own inquiries. The “Readme” folder contains the data structure required to download the compressed files.
The BDPP extraction files now contain complete information on all approved (ap_filename.zip), marketed (filename.zip), canceled (ia_filename.zip) and dormant (dr_filename.zip) products for human, veterinary, disinfectant and radiopharmaceutical.
For more information regarding the structure of the data extract, see the readme file.
Notice: Change effective July 4, 2022
Beginning March 1, 2022, American Hospital Formulary Service (AHFS) classification information will no longer be available in Drug Product Database data extracts.
Beginning July 4, 2022, Allfiles will contain the Therapeutic Class File (previously called Therapeutic Class File Version 2) which does not have the AHFS code and description fields and which has the format described below.
1708225314
#data #extract #Extract #data #Pharmaceutical #Product #Database #DPDB #Health #Canada