Licensed Natural Health Product Database Data Extract

The LNHPD data extract is a series of compressed ASCII text files of the content within the database. The uncompressed size of the files is approximately 30 MB. In order to utilize the data, the file must be loaded into an existing database or information system. 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 LNHPD data extract files are updated on a periodic basis. They contain product specific information on natural health products that have been issued a product licence by Health Canada.

Note: Stakeholders can identify whether a natural health product previously held a drug identification number (DIN) by the zero (0) as the first digit of the eight (8) digit Natural Product Number (NPN) or Homeopathic Medicine Number (DIN-HM).

For more information, please go to the Read me file.

Data Extracts - Last updated: September 28, 2017

NHP Products

• NHP_Products (Zip File - 1636 K )

NHP Products purpose

• NHP_Products_purpose (Zip File - 3120 K )

NHP Products recommended dose

• NHP_Prod_recommended_dose (Zip File - 860 K )

NHP Products risk

• NHP_Products_risk (Zip File - 5744 K )

NHP Companies

• NHP_Companies (Zip File - 950 K )

NHP Medicinal ingredients

• NHP_Medicinal_ingredients (Zip File - 10376 K )

NHP Route

• NHP_Route (Zip File - 231 K )

NHP Non medicinal ingredients

• NHP_Nonmedicinal_ingredients (Zip File - 3044 K )

NHP Product names

• NHP_Product_names (Zip File - 1319 K )

All NHP Files

• All_NHP_files (Zip File - 27274 K )

Copyright

For information on copyright and who to contact, please visit the Licensed Natural Health Product Database Terms and Conditions.

For more information

• Self-care products
  How self-care products, including natural heath products, cosmetics and over-the-counter drugs, are regulated in Canada.