Hsa Sg Search
hsa_sg_searchSearch medicines registered in Singapore — the Health Sciences Authority (HSA) official listing of ~5,500 registered therapeutic products, live from data.gov.sg. Answers "is approved in Singapore", "which Singapore-registered products contain ", "what does hold a Singapore product licence for", "which products in ATC class are registered in Singapore". Each row: SIN licence number, product name, licence holder, approval date, forensic classification (Prescription Only / Pharmacy Only / General Sale List), ATC code, dosage form, route, manufacturers, country of manufacture, active ingredients with strengths. Real offset+limit pagination with a total match count; results newest approval first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows, default 25, max 200. | |
| query | No | Free text matched against product name, active ingredient, licence holder and licence number, e.g. "metformin", "KEYTRUDA", "SIN16061P". | |
| route | No | Route of administration contains, e.g. "ORAL", "INTRAVENOUS". | |
| holder | No | Product licence holder name contains, e.g. "PFIZER". | |
| offset | No | Row offset for pagination, default 0. | |
| country | No | Country of manufacture, exact name as HSA writes it, e.g. "INDIA", "GERMANY" (see hsa_sg_dataset_info). | |
| atc_code | No | ATC code prefix, e.g. "A10BA" (biguanides) or "L01" (antineoplastics). | |
| approved_to | No | Latest approval date, YYYY-MM-DD. | |
| dosage_form | No | Dosage form contains, e.g. "TABLET", "INJECTION". | |
| manufacturer | No | Manufacturer name contains. | |
| approved_from | No | Earliest approval date, YYYY-MM-DD. | |
| active_ingredient | No | Active ingredient contains (case-insensitive), e.g. "PARACETAMOL". | |
| forensic_classification | No | Supply category. |