Notice of Compliance (NOC) Data Extract

Some of the following hyperlinks are to sites of organizations or other entities that are not subject to the  Official Languages Act. The material found there is therefore in the language(s) used by the sites in question.

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.

What is the Notice of Compliance (NOC) Data Extract?

The data extract is a series of compressed ASCII text files of the database. The uncompressed size of the files is approximately 8.5 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. A casual user of this file must be familiar with database structure and capable of setting up queries. The "Read me" file contains the data structure required to download the zipped files.

The NOC extract files have been updated. They contain Health Canada authorization dates for all drugs dating back to 1994 that have received an NOC.  There are four types of NOCs: Biological, Prescription, Nonprescription and Veterinary. All NOCs issued between 1991 and 1993 can be found in the NOC listings.

Please note any Portable Document Format (PDF) files visible on the NOC database are not part of the data extracts.

For more information, please go to the Read Me File.

Data Extracts - Last updated: June 28, 2013

• Qry_NOC_MAIN: noc_main (Text File - 4914 K )
• Qry_NOC_BRAND: noc_brand (Text File - 505 K )
• Qry_NOC_DIN_PRODUCT: noc_din_product (Text File - 905 K )
• Qry_NOC_PRODUCT_INGREDIENT: noc_ingredient (Text File - 2518 K )
• Qry_NOC_PRODUCT_FORM: noc_form (Text File - 1189 K )
• Qry_NOC_PRODUCT_ROUTE: noc_route (Text File - 1093 K )
• Qry_NOC_VET_SPECIES: vet_species (Text File - 78 K )
• All NOC Files: nocfiles (Zip File - 1699 K )

Copyright

Notice of Compliance Online Database. © Her Majesty the Queen in Right of Canada. All rights reserved. No part of the NOC online 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 NOC online please contact:

Public Works and Government Services Canada
Publishing and Depository Services
350 Albert Street, 4th Floor
Ottawa, Ontario
Canada
K1A 0S5

e-mail: copyright.droitdauteur@pwgsc.gc.ca