Skip to main content

Dental Prescribing Data Extracts

Womans teeth being examined
From April 2022, prescribing data by Dentists in Wales will be made available at presentation level. The information is obtained from our prescribing and dispensing information systems.
The data covers prescriptions that are prescribed in Wales through Dental practices that are then dispensed in the community within Wales. The data includes all prescribed medicines, dressings and appliances that are dispensed each month. If a patient does not take a prescription to the pharmacy for dispensing, then the information will not be included in the dataset.
The data does not include private prescriptions.
Data will be published on the 1st working day of each month and will be available for the current and two complete financial years. Each compressed file will contain three individual files which can be viewed in applications such as Microsoft WordPad and Excel.
Prescribing data requires careful interpretation and should not be used in isolation.
Each month a compressed file containing three files will be available to download.


  • DentalDataFileCCYYMM The file contains the following:
    • the responsible Health Board
    • Responsible Locality
    • BNF classification
    • Drug name
    • Number of items prescribed 
    • NIC - The Drug Tariff cost cost of the drug
    • Actual Cost of the drug (Drug cost minus a discount plus container allowance)
    • Quantity (number of capsules, tubes etc.)
    • Defined Daily Dose (DDD)
    • Average Daily Quantity (ADQ)
    • Period in which the prescription was submitted for reimbursement
  • ChemSubstance - This provides the chemical substance using the first 9 characters of the BNF code included in the main Dental data file.  
  • Address File - This file will provide details of the dental presriber's locality.

This data is available for use and re-use under the Open Government Licence (OGL). Please ensure that you understand the terms of the OGL before using our data.

Please refer to the documents below for information on the individual files.