Data Dictionary

Data standards

Data dictionary

Every field a consumer of this dataset receives, what it means, and how completely it is populated today.

FieldTypeMeaningPopulated
registration_nostringDRAP registration number. The regulatory identity of the product.100%
brand_namestringBrand as published by the regulator.100%
genericstringActive ingredient(s), normalised to a canonical molecule.100%
atc_codestringWHO Anatomical Therapeutic Chemical code, carried on the molecule.100%
strengthstringStrength per dosage unit, as published.100%
dosage_formstringNormalised dosage form (tablet, injection, suspension...).100%
pack_sizestringRetail pack as published. The basis for unit-price conversion.100%
companystringMarketing authorisation holder, resolved to a canonical company record.100%
presentation_keysha-256Deterministic identity for the presentation. Stable across observations.100%
price.amountdecimalNotified maximum retail price for the pack, in PKR.99.9%
price.effective_fromdateDate the price took effect, as published by the regulator.
price.source_urlurlThe regulator page the price was read from. Every price carries one.100%
price.is_currentbooleanWhether this row is the price in force. Superseded rows are kept, not deleted.100%
price.quality_statusenumverified | trusted | quarantined_*. Only verified and trusted prices are published.100%
unit_pricedecimalPrice per comparable unit. Absent where the pack could not be resolved confidently.
comparator_countintegerNumber of like-for-like peers the position was computed against.

Populated is the share of published presentations carrying a non-empty value, computed live. A blank means the field applies only to priced or compared records and a single percentage would mislead.

Controlled vocabularies

  • presentation_validation_status — validated (published), review (held), duplicate (merged into a survivor).
  • quality_status — verified (matched to an official source record), trusted, quarantined_unbound, quarantined_source_collision. Quarantined prices are never published.

Identity and stability

presentation_key is a deterministic hash of the identifying attributes and is versioned, so a change in the identity rules is visible rather than silent. Consumers should key on presentation_key rather than on internal row ids.

Every figure on this page is computed from the live database when the page is built, not written by hand. Generated 2026-10-29 02:13:25.

Medicine brands A–Z:ABCDEFGHIJKLMNOPQRSTUVWXYZ0-9