Cancelled Pharmaceutical Products
Data as of 25 Jul 2024, 23:59Complete list of pharmaceutical products with registrations cancelled 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 products with cancelled registrations, 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 with registrations cancelled by the Drug Control Authority. The table provides a preview of the dataset using 10 records as a sample.
Variable definitions
- Registration Number
- Product Name
- Description
- Holder
- Manufacturer
- Registration Date
- Expiry Date
Name in Dataset | Variable | Definition |
|---|---|---|
reg_no (String) | Registration Number | Unique identifier for the product's registration |
product (String) | Product Name | Name of the product |
description (Categorical) | Description | Type of product |
holder (String) | Holder | Company or entity holding the registration |
manufacturer (String) | Manufacturer | Name of the manufacturer of the product |
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 cancellation took or takes effect in YYYY-MM-DD format |
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_cancelled.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 Public Sector Open Data