Search tips
Search criteria 


Logo of clinepidDove Medical PressThis ArticleSubscribeSubmit a ManuscriptSearchFollowDovepressClinical Epidemiology
Clin Epidemiol. 2010; 2: 273–279.
Published online 2010 December 2. doi:  10.2147/CLEP.S13458
PMCID: PMC2998817

Existing data sources for clinical epidemiology: Aarhus University Prescription Database


Population-based prescription databases in Nordic countries have become a mainstay of epidemiologic research. Denmark has both national and regional population-based prescription databases. Aarhus University Prescription Database collects data on reimbursed medications dispensed at all community pharmacies of the North Denmark Region and the Central Denmark Region. The regions have a combined population of 1.8 million inhabitants, or one-third of the Danish population. Denmark’s primary health care sector, which includes general practitioners, specialists, and dentists, generates about 96% of the prescription sales, most of which are reimbursable and are dispensed by the community pharmacies. The Aarhus University Prescription Database combines the region’s pharmacy records in a single database, maintained and updated for research purposes. Each dispensation record contains patient-, drug-, and prescriber-related data. Dispensation records retain patients’ universal personal identifier, which allows for individual-level linkage to all Danish registries and medical databases. The linked data have many applications in clinical epidemiology, including drug utilization studies, safety monitoring, etiologic research, and validation studies.

Keywords: epidemiology, prescriptions, registry-based research

Prescription registries in Nordic countries have become a mainstay of epidemiologic research.1,2 Since its inception, in 1994, The Danish Registry of Medicinal Products Statistics has collected records on sales of all medicinal products nationwide, including individual-level data on outpatient dispensations and aggregate data on in-hospital dispensations.1 These data are accessible for research purposes via a database copy in Statistics Denmark. Advantages of the Registry of Medicinal Products Statistics for epidemiologic research include availability of records since the mid-1990s, the possibility to achieve large sample size due to nationwide coverage, and inclusion of all prescription medications regardless of reimbursement status. Important drawbacks of the Registry of Medicinal Products Statistics are potentially high costs associated with data acquisition from Statistics Denmark and restrictions on the export of raw data outside Statistics Denmark.2 These are barriers to potentially more widespread use of the Danish National Prescription Registry for epidemiologic research.13

In addition to the Registry of Medicinal Products Statistics, Denmark has two regional databases maintained for research purposes. One database is hosted by the University of Southern Denmark (the Odense University Pharmacoepidemiological Database), and the other database is hosted by Aarhus University (the Aarhus University Prescription Database). The regional databases are more easily accessible for data linkage and authorized export than the Registry of Medicinal Products Statistics, while containing largely overlapping information. The regional databases thus represent an alternative source of populationbased prescription data. Recently, Furu et al provided a brief comparative overview of all Nordic prescription databases.1 The early description of Aarhus University Prescription Database was published in 1996,4 before Denmark’s municipal reform of 2007.5 This paper aims to provide a detailed and up-to-date description of the Aarhus University Prescription Database as a resource for epidemiologic research. Other names of this database used in published literature include “Pharmacoepidemiologic Prescription Database of North Jutland”6 and “Prescription Databases of the North Denmark and Central Denmark Regions”.1

Health care and prescribed medicine in Denmark

Denmark is a welfare state, with tax-financed universal access to health services.7 Except for emergencies, patients’ initial contact with the health care system is through their general practitioners, who provide referrals to hospitals and specialists as necessary. The primary health care sector is represented by about 4100 general practitioners, 1200 specialists, and 4600 dentists, as well as physiotherapists, chiropractors, and home nurses. There are about 300 community pharmacies. 7 Prescriptions originating from the primary health care sector account for approximately 96% of the total volume of medicinal product sales in Denmark.8

Most prescription medications in Denmark are eligible for full or partial general reimbursement by the National Health Service (Sygesikringer). Adults (persons aged 18 years or older) become eligible for reimbursement after exceeding 850 Danish kroner (~114 Euro, ~151 US dollars) in annual out-of-pocket expenditure for prescription medicine; children (persons under age 18 years) are exempt from the out-of-pocket expense requirement.9 Drugs ineligible for general reimbursement include sedatives, hypnotics, oral contraceptives, and over-the-counter (OTC) medicine. Conditional reimbursement, however, may be granted for prescription-only and OTC medicines, if they are prescribed for chronic conditions or to certain patient groups (eg, senior citizens).10 The Danish Medicines Agency (Lægemiddelstyrelsen, regularly posts on its website updated rosters of generally and conditionally reimbursable medicines.10 Changes in reimbursement policies have been described, since 2005, on a dedicated website ( = 6301).11

Population and period covered by the Aarhus University Prescription Database

Aarhus University Prescription Database covers the population of the Central Denmark Region and the North Denmark Region. These are two of the five Danish regions, with a combined population of 1.8 million inhabitants, or about one-third of the total Danish population (Table 1, Figure 1). Following the municipal reform, which went into effect on 1 January 2007, regions replaced counties as administrative units in Denmark. As a result, the Central Denmark Region and the North Denmark Region now encompass four former counties: Aarhus, North Jutland, Ringkjøbing, and Viborg, as well as seven municipalities of the former Vejle county (Table 1).5

Figure 1
The five regions of Denmark formed by the 2007 municipal reform (source:
Table 1
The Danish regions after the 2007 municipal reform and corresponding former counties

Before the municipal reform, the Aarhus University Prescription Database received and merged prescription data from Aarhus, North Jutland, Ringkjøbing, and Viborg counties. Because counties started contributing at different times, they differ with respect to the earliest availability of the data. Data from the former North Jutland county are available since 1992,6 from the former Aarhus county since 1996, and from the former Viborg and Ringkjøbing counties since 1998. After the municipal reform, the Aarhus University Prescription Database has been merging prescription data from the community pharmacies of the Central Denmark Region and the North Denmark Region.

Data flow

Ambulatory patients redeem prescriptions at community pharmacies, which electronically transmit dispensation data to the regional subdivisions of the National Health Service for reimbursement. Prescription reimbursement records must be de-identified within two months of sale.2 In order to enable individual-level linkage of prescription data to other medical databases, patient records need to remain identifiable. According to an agreement with Aarhus University, the National Health Service subdivisions of the Central Denmark Region and the North Denmark Region transfer individually identifiable dispensation data collected from the community pharmacies to the Department of Clinical Epidemiology at Aarhus University Hospital. The transfer is conducted using a password-protected encrypted connection, and the data are kept on a secure server. Data protection is further discussed below. The dispensation data are also reported to the Registry of Medicinal Products Statistics.1


One drug dispensation represents the unit of observation in the Aarhus University Prescription Database. Each line of record contains the following variables:

  1. Patient’s identifier (the so-called CPR number), which is a unique 10-digit numeric code assigned at birth or immigration by Denmark’s Central Personal Registry. The first six digits of the CPR number correspond to the day, month, and year of birth, and the last digit encodes sex (odd digits for male; even digits for female).12 Prescriptions for children younger than 16 years were registered under the CPR numbers of their parents until April 1, 1996 and under the children’s own CPR numbers thereafter;
  2. Date of sale, which, in combination with the CPR number, enables calculation of the patient’s age at dispensation;
  3. Type of drug, which is coded according to the anatomical therapeutic chemical (ATC) classification;13
  4. Universal product number (Varenummer), which encodes medication name, strength, pack size, dose units (eg, mg or mL), defined daily dose (DDD), and manufacturer;
  5. Provider code, which corresponds to a clinic, a practice, or a single physician. The provider code enables identification of the prescriber’s specialty, name, and address, and in case of single practitioners, their age and sex.

What is registered in the Aarhus University Prescription Database?

Aarhus University Prescription Database records prescription medications that receive general or conditional reimbursement dispensed at the community pharmacies of the Central Denmark Region and the North Denmark Region. In 2009, 14.9 million dispensations were reported to the database. Table 2 and Figure 2 show the distribution of these dispensations by the major ATC classification group. Dispensations in group C (cardiovascular system) account for more than one-quarter of all dispensations, followed by dispensations in group N (nervous system), which account for more than one-fifth (Figure 2).

Figure 2
Percentage of dispensations recorded in the Regional Prescriptions Databases of the North Denmark region and Central Denmark region by anatomical therapeutic chemical group (2009).
Table 2
Distribution of prescribed medicine recorded in the Aarhus University Prescription Database according to the 14 main ATC anatomic groups (2009)

Thirty ATC codes account for half of all dispensations. The five most frequently dispensed medications are simvastatin (ATC code C10AA01), acetylsalicylic acid (ASA, B01AC06), paracetamol (N02BE01), metoprolol (C07AB02), and bendroflumethiazide (C03AB01) (Table 3).

Table 3
ATC codes of the 30 most frequently dispensed prescription medications in 2009. These account for half of all dispensations recorded in the Aarhus University Prescription Database in 2009

The distribution of dispensations reflects the extent of byprescription use of ASA and paracetamol, which can be sold over the counter. ASA is reimbursed (and therefore recorded) if prescribed for specific indications, including primary and secondary prophylaxis of cardiovascular diseases.10 Therefore, prescriptions for ASA recorded in the Aarhus University Prescription Database are expected to originate primarily from persons older than 55 years, or those with increased risk of cardiovascular morbidity. Paracetamol is reimbursable if prescribed for chronic pain.10 An estimated 11% of ASA and 80% of paracetamol packages prescribed in the primary sector are not reimbursed8 and therefore not recorded in the Aarhus University Prescription Database. Thus, for conditionally reimbursed medications, the proportion of dispensations recorded in the Aarhus University Prescription Database varies by pharmaceutical. The Internetbased database provides on-demand statistics (in Danish) on annual sales of pharmaceuticals with and without reimbursement in all sectors of health care. The aggregate statistics are available for each medication sold in Denmark and can be defined in packages or in daily doses. Using these data, degree of underascertainment of medication use due to lack of reimbursement can be estimated on a case-by-case basis.

What is not registered

The Aarhus University Prescription Database does not contain data on drugs that do not receive general or conditional reimbursement or drugs dispensed outside the community pharmacies of the two regions. The non-reimbursable medications include, for example, oral contraceptives and OTC medications (unless prescribed for chronic conditions, as discussed above). Reimbursed medications dispensed outside community pharmacies include medications dispensed directly to patients in hospitals or outpatient clinics. These include, for example, outpatient anti-neoplastic treatments, antiretroviral treatments for patients with human immunodeficiency virus infection, or substitution therapy for substance abusers.14 For drug-specific information regarding reimbursement rules9,10 and distribution of pharmaceutical sales according to reimbursement status and health care sector,8 the readers are referred to the relevant publications by the Danish Medicines Agency that are freely available on the Internet, the latter publication also in English.8

Quality of data

Pharmacies use bar code scanning to enter drug information into their database, making drug-related data entry errors highly unlikely. Potential dispensation of a wrong drug to a patient cannot be detected by examining the electronic data, but the frequency of such occasions is assumed to be negligible to meaningfully affect most study results. For the population of the two regions, dispensation records of reimbursed medications from community pharmacies, which are reported to the Aarhus University Prescription Database, are expected to be the same as records reported to the Registry of Medicinal Products Statistics. A cross-tabulation, at our department, of records with available data from both sources confirmed this expectation (unpublished data).

An estimated completeness of the Aarhus University Prescription Database is 96%, based on cross-tabulation of insulin prescriptions with hospitalization records of diabetes mellitus in the former North Jutland county.4 However, completeness may vary by drug type. Furthermore, although dispensation record represents patients with primary adherence (those who purchase medications), it reflects neither the fact nor the exact timing of the actual medication intake.

Record linkage and use of data in clinical research

Thanks to patient-identifiable data in the Aarhus University Prescription Database, it is technically easy to link it to all other Danish registries, both nationwide and regional, using the CPR number. Because Denmark’s registries are numerous and far-reaching even by the standards of Nordic countries,15 such linkage opens many possibilities for epidemiologic and interdisciplinary research. Linkage can be done, for example, to migration and vital status data in the Civil Registration System,12 hospitalization records in the Danish National Patient Registry, cancer diagnoses in the Danish Cancer Registry, or birth records in the Danish Medical Birth Registry.16 Linkage to the birth records is a valuable resource for studies of medication safety in pregnancy. Birth records contain both maternal and paternal CPR numbers of live- or still-born babies, allowing linkage of prescription and hospital records of parents and children. Examples of studies involving linkage to different data sources are given below. Even unlinked dispensation data can provide a wealth of information. Because each dispensation is identified by CPR number, it is possible to study patterns of drug utilization by patient age and sex and to reconstruct individual dispensation trajectories over time. The availability of prescription data since the mid-1990s enables the conduct of intergenerational studies. Besides Denmark, Finland is the only other Nordic country in which this is possible, because of the availability of prescription data since the 1990s, eg, parental use of medication before conception or birth can be examined for today’s young adults.1

Data access

The Danish Act on Processing of Personal Data (Persondataloven) provides the legal basis for the ability of public institutions, including universities, to retain person-identifiable health data for research purposes.17 In order to access the data from the Aarhus University Prescription Database, researchers may apply to the Department of Clinical Epidemiology, at Aarhus University Hospital ( Furthermore, use of any health data requires project-specific permission from the Data Protection Agency (Datatilsynet,, and often additional permission for linkage from the National Board of Health (Sundhedsstyrelsen,

Examples of studies conducted with data from the Aarhus University Prescription Database

Reports of studies based on data from the Aarhus University Prescription Database have been published in several major international peer-reviewed journals and include both safety investigations and epidemiologic studies that use prescription record as a proxy measure of disease. A non-exhaustive list of examples includes investigations among pregnant women based on linkage to birth registry, including safety of non-steroidal anti-inflammatory drugs (NSAIDs),18 loratadine, 19 fluconazole,20 selective serotonin reuptake inhibitors (SSRIs),21 and clomifene.22 Nørgaard et al used linkage with hospitalization records to investigate risk of miscarriage among pregnant users of pivmecillinam, while using data on the women’s dispensation of anti-epileptic and anti-diabetic medications to control potential confounding by epilepsy and diabetes.23 Likewise, by linkage to hospitalization records, Johnsen et al examined the risk of myocardial infarction among users of several NSAIDs,24 Fryzek et al studied cancer risk among women using antihypertensive medications,25 Nørgaard et al used prescriptions for SSRIs as a marker of depression in a study of acute pancreatitis,26 and Lash et al and Cronin-Fenton et al studied the role of tamoxifen and SSRIs in preventing the recurrence of breast cancer.2729 Finally, several investigations demonstrated socioeconomic differences in drug utilization by linking prescription dispensation records from Aarhus University Prescription Database to individual-level socioeconomic indicators.3033


Routinely recorded person-identifiable prescription data have many uses, including post-approval research or etiologic studies. The Aarhus University Prescription Database contains, with few exceptions, dispensation data on reimbursed medicine for the entire population of two Danish geographic regions representing one-third of the country’s population. The data are accessible for research and are linkable to all other Danish databases and registries. The main drawbacks of the Aarhus University Prescription Database are a lack of nationwide coverage and the absence of data of certain medication types. At the same time, a vast majority of prescription dispensations are routinely recorded, with more than 15 years’ worth of follow-up data accumulated to date. Thus, the Aarhus University Prescription Database represents a valuable research tool for many epidemiologic applications.



The authors report no conflict of interest for this work.


1. Furu K, Wettermark B, Andersen M, Martikainen JE, Almarsdottir AB, Sørensen HT. The Nordic countries as a cohort for pharmacoepidemiological research. Basic Clin Pharmacol Toxicol. 2010;106(2):86–94. [PubMed]
2. Hallas J. Conducting pharmacoepidemiologic research in Denmark. Pharmacoepidemiol Drug Saf. 2001;10(7):619–623. [PubMed]
3. Frank L. Epidemiology. The epidemiologist’s dream: Denmark. Science. 2003;301(5630):163. [PubMed]
4. Nielsen GL, Sørensen HT, Pedersen AB, Sabroe S. Analyses of data quality in registries concerning diabetes mellitus – a comparison between a population based hospital discharge and an insulin prescription registry. J Med Syst. 1996;20(1):1–10. [PubMed]
5. Danish Regions. The Danish regions in brief. 2008. [Accessed 2010 Oct 6]. Available from:
6. Nielsen GL, Sørensen HT, Zhou W. The Pharmacoepidemiologic Prescription Database of North Jutland – a valid tool in pharmacoepidemiological research. Int J Risk Safety Med. 1997;10:203–205. [PubMed]
7. Ministry of Interior and Health. Health Care in Denmark 2008. [Accessed 2010 May 17]. Available from:
8. Danish Medicines Agency. Medicinal Products Statistics. Denmark, 2004–2008. Total sales. [Accessed 2010 Oct 6]. Available from:
9. Danish Medicines Agency. Reimbursement. [Accessed 2010 Oct 6]. Available from:
10. Danish Medicines Agency. Medicines eligible for reimbursement [in Danish: Skrivelse om tilskudsberettigede lægemidler] [Accessed 2010 Oct 6]. Available from:
11. Danish Medicines Agency. Reassessment of reimbursement status for medicinal products. [Accessed 2010 Oct 6]. Available from:
12. Pedersen CB, Gotzsche H, Moller JO, Mortensen PB. The Danish Civil Registration System. A cohort of eight million persons. Dan Med Bull. 2006;53(4):441–449. [PubMed]
13. WHO Collaborating Centre for Drug Statistics Methodology Norwegian Institute of Public Health. WHO ATC/DDD Index. [Accessed 2010 Oct 6]. Available from:
14. Kildemoes HW, Sorensen HT, Hallas J. The Danish National Prescription Registry. (unpublished work) [PubMed]
15. Frank L. Epidemiology. When an entire country is a cohort. Science. 2000;287(5462):2398–2399. [PubMed]
16. Knudsen LB, Olsen J. The Danish Medical Birth Registry. Dan Med Bull. 1998;45(3):320–323. [PubMed]
17. Persondataloven (Data Protection Act) [Accessed 2010 Oct 6]. [Accessed 2010 Oct 6]. Available from: Available from:
18. Nielsen GL, Sorensen HT, Larsen H, Pedersen L. Risk of adverse birth outcome and miscarriage in pregnant users of non-steroidal anti-inflammatory drugs: population based observational study and case-control study. BMJ. 2001;322(7281):266–270. [PMC free article] [PubMed]
19. Pedersen L, Norgaard M, Rothman KJ, Sorensen HT. Loratadine during pregnancy and hypospadias. Epidemiology. 2008;19(2):359–360. [PubMed]
20. Norgaard M, Pedersen L, Gislum M, et al. Maternal use of fluconazole and risk of congenital malformations: a Danish population-based cohort study. J Antimicrob Chemother. 2008;62(1):172–176. [PubMed]
21. Wogelius P, Norgaard M, Gislum M, et al. Maternal use of selective serotonin reuptake inhibitors and risk of congenital malformations. Epidemiology. 2006;17(6):701–704. [PubMed]
22. Sorensen HT, Pedersen L, Skriver MV, Norgaard M, Norgard B, Hatch EE. Use of clomifene during early pregnancy and risk of hypospadias: population based case-control study. BMJ. 2005;330(7483):126–127. [PMC free article] [PubMed]
23. Norgaard M, Skriver MV, Sorensen HT, Schonheyder HC, Pedersen L. Risk of miscarriage for pregnant users of pivmecillinam: a populationbased case-control study. APMIS. 2008;116(4):278–283. [PubMed]
24. Johnsen SP, Larsson H, Tarone RE, et al. Risk of hospitalization for myocardial infarction among users of rofecoxib, celecoxib, and other NSAIDs: a population-based case-control study. Arch Intern Med. 2005;165(9):978–984. [PubMed]
25. Fryzek JP, Poulsen AH, Lipworth L, et al. A cohort study of antihypertensive medication use and breast cancer among Danish women. Breast Cancer Res Treat. 2006;97(3):231–236. [PubMed]
26. Norgaard M, Jacobsen J, Gasse C, Pedersen L, Mortensen PB, Sorensen HT. Selective serotonin reuptake inhibitors and risk of acute pancreatitis: a population-based case-control study. J Clin Psychopharmacol. 2007;27(3):259–262. [PubMed]
27. Lash TL, Pedersen L, Cronin-Fenton D, et al. Tamoxifen’s protection against breast cancer recurrence is not reduced by concurrent use of the SSRI citalopram. Br J Cancer. 2008;99(4):616–621. [PMC free article] [PubMed]
28. Cronin-Fenton D, Lash TL, Sorensen HT. Selective serotonin reuptake inhibitors and adjuvant tamoxifen therapy: risk of breast cancer recurrence and mortality. Future Oncol. 2010;6(6):877–880. [PubMed]
29. Lash TL, Cronin-Fenton D, Ahern TP, et al. Breast cancer recurrence risk related to concurrent use of SSRI antidepressants and tamoxifen. Acta Oncol. 2010;49(3):305–312. [PMC free article] [PubMed]
30. Thrane N, Olesen C, Schonheyder HC, Sorensen HT. Socioeconomic factors and prescription of antibiotics in 0- to 2-year-old Danish children. J Antimicrob Chemother. 2003;51(3):683–689. [PubMed]
31. Thomsen RW, Johnsen SP, Olesen AV, et al. Socioeconomic gradient in use of statins among Danish patients: population-based cross-sectional study. Br J Clin Pharmacol. 2005;60(5):534–542. [PMC free article] [PubMed]
32. Olesen C, Thrane N, Henriksen TB, Ehrenstein V, Olsen J. Associations between socio-economic factors and the use of prescription medication during pregnancy: a population-based study among 19,874 Danish women. Eur J Clin Pharmacol. 2006;62(7):547–553. [PubMed]
33. Mortensen JT, Olesen AV, Boggild H, Olsen J, Westergard-Nielsen NC. Socioeconomic correlates of drug use based on prescription data: a population-based cross-sectional register study in Denmark 1999. Dan Med Bull. 2007;54(1):62–66. [PubMed]

Articles from Clinical Epidemiology are provided here courtesy of Dove Press