Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2006

Open Access 01-12-2006 | Research article

Linking community pharmacy dispensing data to prescribing data of general practitioners

Authors: Stefan R Florentinus, Patrick C Souverein, Fabiënne AMG Griens, Peter P Groenewegen, Hubert GM Leufkens, Eibert R Heerdink

Published in: BMC Medical Informatics and Decision Making | Issue 1/2006

Login to get access

Abstract

Background

Databases are frequently used for pharmacoepidemiological research. However, most of these databases consist either of prescribing, dispensing or administrative data and therefore lack insight in the interaction between the several health professionals around the patient.

Methods

To determine the success rate of linking records from the dispensing database of the Foundation for Pharmaceutical Statistics to the prescribing database of the second Dutch national survey of general practice, conducted by NIVEL (Netherlands Institute for Health Services Research), a deterministic record linkage approach was used with patient and prescription characteristics as matching variables between the two databases.

Results

The catchment area included 123 community pharmacies, 90 GP practices and approximately 170,000 unique patients. Overall 110,102 (64.8%) unique patients were linked using the matching variables patient's gender, year of birth, the 4-digit part of the postal code, date of dispensing/prescribing and ATC-code. The final database contains of the 110,102 both prescribing data from 83 GP practices and dispensing data of 112 community pharmacies.

Conclusion

This study shows that linkage of dispensing to prescribing data is feasible with a combination of patient characteristics, such as gender, year of birth and postal code, and prescription characteristics like prescription date and ATC-code. We obtained a linkage proportion of 64.8% resulting in complete prescribing and dispensing history of 110,102 patients. This offers an opportunity to gain insight in the mechanisms and factors influencing drug utilisation in general practice.
Appendix
Available only for authorised users
Literature
1.
go back to reference Herings RM, Erkens JA: Increased suicide attempt rate among patients interrupting use of atypical antipsychotics. Pharmacoepidemiol Drug Saf. 2003, 12: 423-424. 10.1002/pds.837.CrossRefPubMed Herings RM, Erkens JA: Increased suicide attempt rate among patients interrupting use of atypical antipsychotics. Pharmacoepidemiol Drug Saf. 2003, 12: 423-424. 10.1002/pds.837.CrossRefPubMed
2.
go back to reference Herings RMC, Urquhart J, Leufkens HGM: Venous thromboembolism among new users of different oral contraceptives. Lancet. 1999, 354: 127-128. 10.1016/S0140-6736(99)01257-X.CrossRefPubMed Herings RMC, Urquhart J, Leufkens HGM: Venous thromboembolism among new users of different oral contraceptives. Lancet. 1999, 354: 127-128. 10.1016/S0140-6736(99)01257-X.CrossRefPubMed
3.
go back to reference Wood L, Martinez C: The general practice research database: role in pharmacovigilance. Drug Saf. 2004, 27: 871-881. 10.2165/00002018-200427120-00004.CrossRefPubMed Wood L, Martinez C: The general practice research database: role in pharmacovigilance. Drug Saf. 2004, 27: 871-881. 10.2165/00002018-200427120-00004.CrossRefPubMed
4.
go back to reference Herings RMC, Bakker A, Stricker BH, Nap G: Pharmaco-morbidity linkage: a feasibility study comparing morbidity in two pharmacy based exposure cohorts. J Epidemiol Community Health. 1992, 46: 136-140.CrossRefPubMedPubMedCentral Herings RMC, Bakker A, Stricker BH, Nap G: Pharmaco-morbidity linkage: a feasibility study comparing morbidity in two pharmacy based exposure cohorts. J Epidemiol Community Health. 1992, 46: 136-140.CrossRefPubMedPubMedCentral
5.
go back to reference Carroll NV: Do community pharmacists influence prescribing?. J Am Pharm Assoc (Wash DC). 2003, 43: 612-621.CrossRef Carroll NV: Do community pharmacists influence prescribing?. J Am Pharm Assoc (Wash DC). 2003, 43: 612-621.CrossRef
6.
7.
8.
go back to reference Tinke JL, Griens AMGF: Facts and Figures 2004. 2004, The Hague; The Netherlands. www.sfk.nl, Foundation for Pharmaceutical Statistics Tinke JL, Griens AMGF: Facts and Figures 2004. 2004, The Hague; The Netherlands. www.sfk.nl, Foundation for Pharmaceutical Statistics
9.
go back to reference Westert GP, Schellevis FG, de Bakker DH, Groenewegen PP, Bensing JM, van der Zee J: Monitoring health inequalities through general practice: the Second Dutch National Survey of General Practice. Eur J Public Health. 2005, 15: 59-65. 10.1093/eurpub/cki116.CrossRefPubMed Westert GP, Schellevis FG, de Bakker DH, Groenewegen PP, Bensing JM, van der Zee J: Monitoring health inequalities through general practice: the Second Dutch National Survey of General Practice. Eur J Public Health. 2005, 15: 59-65. 10.1093/eurpub/cki116.CrossRefPubMed
10.
go back to reference Jones R, Schellevis F, Westert G: The changing face of primary care: the second Dutch national survey. Fam Pract. 2004, 21: 597-598. 10.1093/fampra/cmh603.CrossRefPubMed Jones R, Schellevis F, Westert G: The changing face of primary care: the second Dutch national survey. Fam Pract. 2004, 21: 597-598. 10.1093/fampra/cmh603.CrossRefPubMed
11.
go back to reference WHO: Guidelines for ATC Classification and DDD assignment. 1999, Oslo, WHO Collaborating Centre for Drug Statistics Methodology - Nordic Council on Medicines WHO: Guidelines for ATC Classification and DDD assignment. 1999, Oslo, WHO Collaborating Centre for Drug Statistics Methodology - Nordic Council on Medicines
12.
go back to reference Lamberts H, Woods M, Hofmans-Okkes I: The international classification of primary care in the European Community. 1993, Oxford, Oxford University Press Lamberts H, Woods M, Hofmans-Okkes I: The international classification of primary care in the European Community. 1993, Oxford, Oxford University Press
13.
go back to reference Beardon PH, McGilchrist MM, McKendrick AD, McDevitt DG, MacDonald TM: Primary non-compliance with prescribed medication in primary care. BMJ. 1993, 307: 846-848.CrossRefPubMedPubMedCentral Beardon PH, McGilchrist MM, McKendrick AD, McDevitt DG, MacDonald TM: Primary non-compliance with prescribed medication in primary care. BMJ. 1993, 307: 846-848.CrossRefPubMedPubMedCentral
14.
go back to reference Buurma H, De Smet PA, Leufkens HG, Egberts AC: Evaluation of the clinical value of pharmacists' modifications of prescription errors. Br J Clin Pharmacol. 2004, 58: 503-511. 10.1111/j.1365-2125.2004.02181.x.CrossRefPubMedPubMedCentral Buurma H, De Smet PA, Leufkens HG, Egberts AC: Evaluation of the clinical value of pharmacists' modifications of prescription errors. Br J Clin Pharmacol. 2004, 58: 503-511. 10.1111/j.1365-2125.2004.02181.x.CrossRefPubMedPubMedCentral
15.
go back to reference Tobi H, van den Heuvel NJ, de Jong-van den Berg LT: Does uncollected medication reduce the validity of pharmacy dispensing data?. Pharmacoepidemiol Drug Saf. 2004, 13: 497-500. 10.1002/pds.928.CrossRefPubMed Tobi H, van den Heuvel NJ, de Jong-van den Berg LT: Does uncollected medication reduce the validity of pharmacy dispensing data?. Pharmacoepidemiol Drug Saf. 2004, 13: 497-500. 10.1002/pds.928.CrossRefPubMed
16.
go back to reference http://www.whocc.no/atcddd. (accessed on December 19th, 2005)/ http://www.whocc.no/atcddd. (accessed on December 19th, 2005)/
17.
go back to reference De Smet PA, Dautzenberg M: Repeat prescribing: scale, problems and quality management in ambulatory care patients. Drugs. 2004, 64: 1779-1800. 10.2165/00003495-200464160-00005.CrossRefPubMed De Smet PA, Dautzenberg M: Repeat prescribing: scale, problems and quality management in ambulatory care patients. Drugs. 2004, 64: 1779-1800. 10.2165/00003495-200464160-00005.CrossRefPubMed
18.
go back to reference Buurma H, de Smet PA, van den Hoff OP, Egberts AC: Nature, frequency and determinants of prescription modifications in Dutch community pharmacies. Br J Clin Pharmacol. 2001, 52: 85-91. 10.1046/j.0306-5251.2001.01406.x.CrossRefPubMedPubMedCentral Buurma H, de Smet PA, van den Hoff OP, Egberts AC: Nature, frequency and determinants of prescription modifications in Dutch community pharmacies. Br J Clin Pharmacol. 2001, 52: 85-91. 10.1046/j.0306-5251.2001.01406.x.CrossRefPubMedPubMedCentral
19.
go back to reference Bright RA, Avorn J, Everitt DE: Medicaid data as a resource for epidemiologic studies: strengths and limitations. J Clin Epidemiol. 1989, 42: 937-945. 10.1016/0895-4356(89)90158-3.CrossRefPubMed Bright RA, Avorn J, Everitt DE: Medicaid data as a resource for epidemiologic studies: strengths and limitations. J Clin Epidemiol. 1989, 42: 937-945. 10.1016/0895-4356(89)90158-3.CrossRefPubMed
20.
go back to reference Stergachis AS: Evaluating the quality of linked automated databases for use in pharmacoepidemiology. Hartzema AG Porta, MS Tilson, HH eds Pharmacoepidemiology: an introduction 2nd ed. 1991, Cincinnati, Harvey Withney, 222-235. 2nd Stergachis AS: Evaluating the quality of linked automated databases for use in pharmacoepidemiology. Hartzema AG Porta, MS Tilson, HH eds Pharmacoepidemiology: an introduction 2nd ed. 1991, Cincinnati, Harvey Withney, 222-235. 2nd
21.
go back to reference Simel DL, Samsa GP, Matchar DB: Likelihood ratios with confidence: sample size estimation for diagnostic test studies. J Clin Epidemiol. 1991, 44: 763-770. 10.1016/0895-4356(91)90128-V.CrossRefPubMed Simel DL, Samsa GP, Matchar DB: Likelihood ratios with confidence: sample size estimation for diagnostic test studies. J Clin Epidemiol. 1991, 44: 763-770. 10.1016/0895-4356(91)90128-V.CrossRefPubMed
Metadata
Title
Linking community pharmacy dispensing data to prescribing data of general practitioners
Authors
Stefan R Florentinus
Patrick C Souverein
Fabiënne AMG Griens
Peter P Groenewegen
Hubert GM Leufkens
Eibert R Heerdink
Publication date
01-12-2006
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2006
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/1472-6947-6-18

Other articles of this Issue 1/2006

BMC Medical Informatics and Decision Making 1/2006 Go to the issue