Notice of Compliance (NOC) Data Extract
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 22.7 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. 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: February 19, 2021
- Qry_NOC_MAIN: noc_main
- Qry_NOC_BRAND: noc_brand
- Qry_NOC_DIN_PRODUCT: noc_din_product
- Qry_NOC_PRODUCT_INGREDIENT: noc_ingredient
- Qry_NOC_PRODUCT_FORM: noc_form
- Qry_NOC_PRODUCT_ROUTE: noc_route
- Qry_NOC_VET_SPECIES: vet_species
- All NOC Files: noc_files
For information on copyright and who to contact, please visit the Notice of Compliance Online Database Terms and Conditions.
Report a problem or mistake on this page
- Date modified: