Pesticide Product Information Database (PPID) API Guide
Table of contents
Introduction
This document is intended to support the Pest Management Regulatory Agency (PMRA) and Health Canada in fulfilling the requirements of the Government of Canada Standard on APIs, specifically the requirements of publishing and documenting the APIs.
One of the mandates of the Pest Control Products Act is to "encourage public awareness in relation to pest control products by informing the public, facilitating public access to relevant information and public participation in the decision-making process", commonly referred to as increasing openness and transparency. A key mechanism for meeting this mandate is the Pesticide Public Registry (Public Registry).
The Public Registry is a collection of non-confidential information on pesticides and the pesticide regulatory system. All publicly available information on currently registered pesticides is available through the Public Registry.
The Public Registry is made up of the following components:
The Pesticide Product Information Database (PPID) allows the public to access information on applications, products, active ingredients, maximum residue limits, product labels, and incident reports related to pesticides and pest control products that are regulated by Health Canada.
The reports in the database are grouped by:
- Applications
- Applications to register, renew, amend or discontinue the registration of a pest control product
- Re-evaluations
- Minor Use Applications
- Research Authorizations
- Reconsiderations and Notices of Objection
- Products
- Active ingredients
- Incident Reports
- Maximum Residue Limits
- Product Labels
For help on the reports available through the Pesticide Product Information Database, contact the Pest Management Information Service.
The database is updated every 24 hours, with information from the Electronic Pesticide Registration System (ePRS), to reflect changes such as the receipt of new applications and the posting of reports and other documents. This update occurs between 2:30 and 3:30 a.m Eastern Standard Time (EST) and during this time the registry reports section may be unavailable for browsing.
Please note that the database only contains information from decisions made under the Pest Control Products Act, which came into force June 28, 2006. Information regarding decisions prior to that date may not be available.
This Application Programming Interface (API) allows developers and applications to access that information in Comma-separated values (CSV) format for reuse in their own applications. The base URI for the Pesticide Product Information Database is https://pest-control.canada.ca/pesticide-registry-api/api/extract/ and you must add parameters to it. Any requests are made relative to this URI.
Application
Applications to register or amend pest control product are submitted from external parties to the PMRA for review. This search will allow you to search for information on current and historical applications.
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /application/id | Returns application according to the Application number specified in the request. | YYYY-#### : number of the Application |
No, but all available records will be returned if not specified. | |
| /application/id?lang=en | Changes language of the response. | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each application object consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Application number | Numéro d'identification de la demande | The number assigned to the Application |
| Date received | date de réception | The date the application was received by PMRA |
| Outcome | Résultat | The outcome of the application |
| Active ingredients - English | Principes actifs - anglais | A semi-colon delimited list of the active ingredients in English |
| Active ingredients - French | Principes actifs - français | A semi-colon delimited list of the active ingredients in French. In some cases, the active ingredient does not contain a French value, so this list may contain fewer items than the English active ingredient list. |
| Purpose | Objet | The purpose of the Application, such as whether to register a new product or amend an existing one. Possible values include:
* Major registration decisions are decisions granting or denying an application to register a new active ingredient for use in Canada; granting or denying an application to amend a registration decision involving a major new use; or confirming, amending or cancelling a registration of a pest control product (pesticide) on completion of a re-evaluation or a special review. |
| Product name - English | Nom du produit - anglais | The product name in English of the product referenced in the application |
| Product name – French | Nom du produit - français | The product name in French of the product referenced in the application. This value may be empty |
| Registration number | Numéro d'homologation | The registration number of the product referenced in the application |
| Name of registrant | Nom du titulaire | The name of the registrant associated with the product referenced in the application |
| Registration status | Statut de l'homologation | The registration status of the product associated with the application |
| Category | Catégorie | The category of the Application |
| Product type | Types du produit | The product type of the product associated with the application |
| Marketing type | Type de mise en marche | The marketing type of the product associated with the application. Possible values and their definitions include:
|
| Current / Historical | En cours / Historique | The current status of the application indicating whether an application is open (current) or closed (historical) |
Product
This search will allow you to search for information on current and historical products.
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query parameter.
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /product/id | Returns application according to the Application number specified in the request. | #####.## : number of the Product |
No, but all available records will be returned if not specified. | |
| /product/id?lang=en | Changes language of the response. | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each product object consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Registration number | Numéro d'homologation | The registration number of the product |
| Product name - English | Nom du produit - anglais | The English name of the product |
| Product name - French | Nom du produit - français | The French name of the product (if it exists) |
| Registration Status | Statut de l'homologation | The registration status of the product |
| Expiry date | Date d'expiration du statut | The expiry date of the registration of the product |
| Marketing type | Type de mise en marche | The marketing type of the product. Possible values and their definitions include:
|
| Date first registered | Date de la première homologation | The date the product was first registered |
| Exclusive period start date | Date du début de la période de protection exclusive | The exclusive period for the registration of the product |
| Active ingredient name - English | Principe actif - anglais | The list of the active ingredients in English |
| Active ingredient name - French | Principes actif - français | The list of the active ingredients in French |
| Product Type | Types du produit | The type of product |
| Registrant name | Nom du titulaire | The name of the registrant responsible for registering the product |
| Use Site Category | Catégories d'utilisation | The use site category of the product |
| Sites of Use | Sites d'utilisation | The sites of applicable use for the product |
| Pests | Organismes nuisibles | The targeted pests for the product |
| Current / Historical | En cours / Historique | The current status of the product indicating if the product is currently registered (current), or if it is no longer registered (historical). |
Active Ingredient
This search will allow you to search for information on current and historical active ingredients.
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query parameter.
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /ingredient/id | Returns application according to the Application number specified in the request. | AAA : three letter code of the Ingredient | No, but all available records will be returned if not specified. | |
| /ingredient/id?lang=en | Changes language of the response | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each ingredient object consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Active ingredient name - English | Principe actif - anglais | The name of the active ingredient, in English |
| Active ingredient name - French | Principe actif - français | The name of the active ingredient, in French |
| Re-evaluation status | Statut de réévaluation | The re-evaluation status of the ingredient |
| CAS number | Numéro CAS | The CAS number of the ingredient |
Incident Report
This search will allow you to search for incidents related to products.
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query parameter.
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /ingredient/id | Returns incidents according to the incident number specified in the request. | YYYY-#### : number of the incident | No, but all available records will be returned if not specified. | |
| /incident/id?lang=en | Changes language of the response | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each applicationobject consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Application number | Numéro de demande | The number assigned to the application |
| ID | Numéro d'identification | The number assigned to the incident |
| Date received - registrant | Date de reception - titulaire | The date the incident was received by the registrant |
| Date received - PMRA | Date de reception - ARLA | The date the incident was received by PMRA |
| Incident report type | Type d'incidents | The incident report type(s) |
| Country | Pays | The country the incident occurred in |
| Province / State | Province / Etat | The province or state the incident occurred in |
| Product name - English | Nom du composant - anglais | The name of the product, in English, that was related to the incident |
| Product name - French | Nom du composant - français | The name of the product, in French, that was related to the incident |
| Active ingredients - English | Principes actif - anglais | A list of the active ingredients, in English, contained by the product that was related to the incident |
| Active ingredients - French | Principes actif - français | A list of the active ingredients, in French, contained by the product that was related to the incident |
Maximum Residue Limit
This search will allow you to search for maximum residue limits related to products
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query parameter.
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /mrl/id | Returns maximum residue limit according to the chemical product | ###: Chemical ID | No | |
| /mrl/id?lang=en | Changes language of the response | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each MRL object consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Chemical Common Name | Produit chimique | Chemical Common Name |
| Food Commodity | Denrée alimentaire | The food commodity for which the MRL applies to |
| MRL Value (ppm) | Valeur de LMR (ppm) | The Maximum Residue Limit value in parts per million (ppm) |
| Comments | Commentaires | Comments |
| Established via | Réglementé selon | The regulatory action that results in the establishment of the MRL |
Label
This search will allow you to search for product labels.
Parameters
There are two parameters: id, and lang. "id" is a path parameter, "lang" is a query parameter.
| Parameter | Meaning | Value | Required? | Note |
|---|---|---|---|---|
| /label/id | Returns labels according to the registration number specified in the request | #### or #####: four to five digit registration number of the Product | No | |
| /label/id?lang=en | Changes language of the response | en - English fr - French |
No, but defaults to English if not specified. | Determines whether the response is in English or French. |
Applications can be accessed via these URIs:
Contents of the response
The response consists of a csv file that contains one or multiple objects.
Each Label object consists of the following values:
| Key (en) | Key (fr) | Value |
|---|---|---|
| Registration number | Numéro d'homologation | The registration number of the product label |
| Registrant name | Nom du titulaire | The registrant of the product |
| Product name | Nom du produit | The name of the product |
| Registration Status | Statut de l'homologation | The registration status of the product |