Approved Pharmaceutical Products
Data as of 25 Jul 2024, 23:59Complete list of pharmaceutical products approved by the Drug Control Authority. The table provides a preview of the dataset using 10 records as a sample.
0 views·0 downloads
How is this data produced?
In accordance with the Control of Drugs and Cosmetics Regulations 1984, all pharmaceutical, health and personal care products marketed in Malaysia must be registered and approved by the Drug Control Authority (DCA). In the present day, registrations are conducted using the QUEST3+ system, which is the administrative system used by NPRA to enable the online management of product registrations, variations, licensing, market sampling, renewal and others. This dataset is an exact copy of the administrative record of approved products, with any columns containing personal data excluded.
What caveats I should bear in mind when using this data?
Although this data represents administrative records, it nevertheless remains a static dataset which is updated once per day, rather than in real time. As such, this dataset should not be used as the basis for any legal action. Any queries on enforcement of the relevant laws of Malaysia should always be referred to the National Pharmaceutical Regulatory Agency (NPRA).
Publication(s) using this data
—
Metadata
Dataset description
Complete list of pharmaceutical products approved by the Drug Control Authority. The table provides a preview of the dataset using 10 records as a sample.
Variable definitions
- Registration Number
- Reference Number
- Product Name
- Status
- Description
- Holder
- Holder OSA Code
- Manufacturer
- Manufacturer OSA Code
- Importer
- Importer OSA Code
- Registration Date
- Expiry Date
- Active Ingredient(s)
- MDC Code
- Generic Name
Name in Dataset | Variable | Definition |
|---|---|---|
reg_no (String) | Registration Number | Unique identifier for the product's registration |
ref_no (String) | Reference Number | Reference number for official checking purposes |
product (String) | Product Name | Name of the product |
status (Categorical) | Status | Either approved or conditionally registered |
description (Categorical) | Description | Type of product |
holder (String) | Holder | Company or entity holding the registration |
holder_osa (String) | Holder OSA Code | Unique identifier for the product license holder |
manufacturer (String) | Manufacturer | Name of the manufacturer of the product |
manufacturer_osa (String) | Manufacturer OSA Code | Unique identifier for the manufacturer |
importer (String) | Importer | Company responsible for importing the product |
importer_osa (String) | Importer OSA Code | Unique identifier for the importer |
date_reg (Date) | Registration Date | Date when the product was registered in YYYY-MM-DD format |
date_end (Date) | Expiry Date | Date when the product's registration expires in YYYY-MM-DD format |
active_ingredient (String) | Active Ingredient(s) | List of active ingredients in the product, including quantities |
mdc_code (String) | MDC Code | Code indicating the medical device classification |
generic_name (String) | Generic Name | Generic name of the product or its active ingredients |
Last updated:
26 Jul 2024, 01:00
Next update:
02 Aug 2024, 01:00
Data source(s)
- National Pharmaceutical Regulatory Agency
- Ministry of Health Malaysia
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.data.gov.my/healthcare/pharmaceutical_products.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
This data catalog is not available through OpenAPI as the nature of the data makes it unsuitable for API access. For the full dataset, please use the provided download link as shown in the above section.
© 2024 Ministry of Health Malaysia