{"topic_id":"eu_ema_medicines_dataset_overview","category":"eu-2026-approvals","context":"---\ntopic_id: eu_ema_medicines_dataset_overview\ncategory: eu-2026-approvals\ntitle: \"EU EMA Medicines Output Dataset: Structure and Veterinary Coverage\"\nlang: en\nsource: \"ema-medicines-report.xlsx\"\ndate_parsed: \"2026-07-21\"\ntokens_estimated: 420\nverification:\n  method: substring_match\n  claims: 5\n  passed: 5\n  date: \"2026-07-21\"\n---\n\n## Source and Scope\n\nThe EMA \"medicines-output-medicines-report_en.xlsx\" is a machine-generated dataset published at `https://www.ema.europa.eu/en/medicines/download-medicine-data`, automatically updated overnight. The file contains all centrally authorised medicines — Human, Veterinary, and Herbal — published on the EMA website. The source XLSX header records the generation timestamp as 20/07/2026 - 18:00 CET. The dataset spans rows 10 to 2723 of the worksheet, a total of 2,714 data rows.\n\n## Dataset Columns\n\nThe worksheet \"Medicine\" contains 34 columns including:\n\n- `Category` — Human / Veterinary / Herbal\n- `Name of medicine` — brand/trade name\n- `EMA product number` — EMEA/H/C/... for Human; EMEA/V/C/... for Veterinary\n- `Medicine status` — Authorised / Withdrawn / Opinion / Application withdrawn / Refused / Expired / Lapsed\n- `International non-proprietary name (INN) / common name`\n- `Active substance`\n- `Therapeutic area (MeSH)`\n- `Species (veterinary)` — species name for vet products\n- `ATCvet code (veterinary)` — ATCvet classification\n- `Pharmacotherapeutic group (veterinary)`\n- `Therapeutic indication`\n- `Marketing authorisation date`\n- `Marketing authorisation holder`\n- `Medicine URL` — links to EMA product page\n\n## Veterinary Subset\n\nOut of 2,714 total data rows (rows 10–2723), **393 entries are classified as Veterinary** (`Category = \"Veterinary\"`). Within the veterinary subset, the species field identifies companion-animal products: **Dogs** (21 entries), **Cats** (11 entries), **Dogs;Cats** (4 entries), **Horses** (5 entries), and combination entries such as **Horses;Dogs;Cats** (1 entry) — totalling approximately **53 entries** explicitly targeting dogs, cats, or horses.\n\n## ATCvet Classification\n\nThe veterinary medicines use the **ATCvet** classification system (Anatomical Therapeutic Chemical classification for veterinary medicines), structured as `Q + Letter + 2 digits + 2 digits` (e.g., `QM01AC06` for meloxicam). Approximately **323 of 393** entries carry no ATCvet code in the dataset; among coded entries the most common prefixes are:\n\n- `QI` — Immunologicals (vaccines): QI02AA08 (bluetongue, 3 entries), QI04AA02 (bluetongue serotype 8, 4 entries), QI06AX (felidae immunologicals, 2 entries), QI07AO (canidae immunologicals, 2 entries)\n- `QM` — Musculo-skeletal system: QM01AC06 (meloxicam/oxicams, 5 entries)\n- `QP` — Antiparasitic products: QP53BX03 (spinosad, 1), QP53AC54 (indoxacarb/permethrin, 1), QP53AX65 (fipronil/amitraz, 1)\n- `QJ` — Antiinfectives for systemic use:QJ01MA94, QJ01MA96, QJ01FA94, QJ01AA02\n- `QA` — Alimentary tract: QA10BK90 (SGLT2 inhibitors: bexagliflozin, velagliflozin, 1 each)\n- `QN` — Nervous system: QN02AB03 (fentanyl, 1), QN02AE01 (buprenorphine, 1)\n- `QC` — Cardiovascular: QC03DA01 (spironolactone, 1), QC08CA01 (amlodipine, 1)\n- `QG` — Genito-urinary system: QG02CB03 (1 entry)\n- `QH` — Systemic hormones: QH01CA (azagly-nafarelin, 1)\n- `QV` — Various: QV03AN01 (medicinal oxygen, 1)\n\n## Data Download URL\n\nSource URL: `https://www.ema.europa.eu/en/medicines/download-medicine-data`\nDirect XLSX: `https://www.ema.europa.eu/en/documents/report/medicines-output-medicines-report_en.xlsx`\n(Generation date encoded in file: 20/07/2026 - 18:00)\n\nSource: EMA Download Medicine Data page, XLSX generated 2026-07-20 18:00 CET.\n","sources":[],"tokens_estimated":420,"generated_at":null,"tip":"Use /api/v1/topics to discover more topics. /api/v1/nutrient for precise single-point queries. /api/v1/cross_compare for 2-3 standard comparisons."}