Skip to main content
Top
Published in: BMC Health Services Research 1/2006

Open Access 01-12-2006 | Research article

Assessing record linkage between health care and Vital Statistics databases using deterministic methods

Authors: Bing Li, Hude Quan, Andrew Fong, Mingshan Lu

Published in: BMC Health Services Research | Issue 1/2006

Login to get access

Abstract

Background

We assessed the linkage and correct linkage rate using deterministic record linkage among three commonly used Canadian databases, namely, the population registry, hospital discharge data and Vital Statistics registry.

Methods

Three combinations of four personal identifiers (surname, first name, sex and date of birth) were used to determine the optimal combination. The correct linkage rate was assessed using a unique personal health number available in all three databases.

Results

Among the three combinations, the combination of surname, sex, and date of birth had the highest linkage rate of 88.0% and 93.1%, and the second highest correct linkage rate of 96.9% and 98.9% between the population registry and Vital Statistics registry, and between the hospital discharge data and Vital Statistics registry in 2001, respectively. Adding the first name to the combination of the three identifiers above increased correct linkage by less than 1%, but at the cost of lowering the linkage rate almost by 10%.

Conclusion

Our findings suggest that the combination of surname, sex and date of birth appears to be optimal using deterministic linkage. The linkage and correct linkage rates appear to vary by age and the type of database, but not by sex.
Appendix
Available only for authorised users
Literature
1.
go back to reference Goldberg MS, Carpenter M, Thériault G, Fair M: The accuracy of ascertaining vital status in a historical cohort study of synthetic textiles workers using computerized record linkage to the Canadian Mortality Data Base. Can J Public Health. 1993, 84: 201-4.PubMed Goldberg MS, Carpenter M, Thériault G, Fair M: The accuracy of ascertaining vital status in a historical cohort study of synthetic textiles workers using computerized record linkage to the Canadian Mortality Data Base. Can J Public Health. 1993, 84: 201-4.PubMed
2.
go back to reference Herrchen B, Gould JB, Nesbitt TS: Vital statistics linked birth/infant death and hospital discharge record linkage for epidemiological studies. Comput Biomed Res. 1997, 30: 290-305. 10.1006/cbmr.1997.1448.CrossRef Herrchen B, Gould JB, Nesbitt TS: Vital statistics linked birth/infant death and hospital discharge record linkage for epidemiological studies. Comput Biomed Res. 1997, 30: 290-305. 10.1006/cbmr.1997.1448.CrossRef
3.
go back to reference Howe GR: Use of computerized record linkage in cohort studies. Epidemiol Rev. 1998, 20: 112-21.CrossRef Howe GR: Use of computerized record linkage in cohort studies. Epidemiol Rev. 1998, 20: 112-21.CrossRef
4.
go back to reference Muse AG, Mikl J, Smith PF: Evaluating the quality of anonymous record linkage using deterministic procedures with the New York State AIDS registry and a hospital discharge file. Stat Med. 1995, 14: 499-509.CrossRef Muse AG, Mikl J, Smith PF: Evaluating the quality of anonymous record linkage using deterministic procedures with the New York State AIDS registry and a hospital discharge file. Stat Med. 1995, 14: 499-509.CrossRef
5.
go back to reference Newcombe HB, Kennedy JM, Axford SJ, James AP: Automatic linkage of vital records. Science. 1959, 130: 954-9.CrossRef Newcombe HB, Kennedy JM, Axford SJ, James AP: Automatic linkage of vital records. Science. 1959, 130: 954-9.CrossRef
6.
go back to reference Newcombe HB, Smith ME, Howe GR, Mingary J, Strugnell A, Abbatt JD: Reliability of computerized versus death searches in a study of the health of Eldorado uranium workers. Comput Biol Med. 1983, 13: 157.CrossRef Newcombe HB, Smith ME, Howe GR, Mingary J, Strugnell A, Abbatt JD: Reliability of computerized versus death searches in a study of the health of Eldorado uranium workers. Comput Biol Med. 1983, 13: 157.CrossRef
7.
go back to reference Newman TB, Brown A, Easterling MJ: Obstacles and approaches to clinical database research: experience at the University of California, San Francisco. Proc Annu Symp Comput Appl Med Care. 1994, 568-72. Newman TB, Brown A, Easterling MJ: Obstacles and approaches to clinical database research: experience at the University of California, San Francisco. Proc Annu Symp Comput Appl Med Care. 1994, 568-72.
8.
go back to reference Roos LL, Wajda A, Nicol JP: The art and science of record linkage: methods that work with few identifiers. Comput Biol Med. 1986, 16: 45-57. 10.1016/0010-4825(86)90061-2.CrossRef Roos LL, Wajda A, Nicol JP: The art and science of record linkage: methods that work with few identifiers. Comput Biol Med. 1986, 16: 45-57. 10.1016/0010-4825(86)90061-2.CrossRef
9.
go back to reference Roos LL, Wajda A, Record linkage strategies: Part I: Estimating information and evaluating approaches. Methods Inf Med. 1991, 30: 117-23.CrossRef Roos LL, Wajda A, Record linkage strategies: Part I: Estimating information and evaluating approaches. Methods Inf Med. 1991, 30: 117-23.CrossRef
10.
go back to reference Kelman CW, Bass AJ, Holman CDJ: Research use of linked health data – a best practice protocol. Aust N Z J Pulic Health. 2002, 26: 251-5.CrossRef Kelman CW, Bass AJ, Holman CDJ: Research use of linked health data – a best practice protocol. Aust N Z J Pulic Health. 2002, 26: 251-5.CrossRef
11.
go back to reference Van den Brandt PA, Schouten LJ, Goldbohm RA, Dorant E, Hunen PM: Development of a record linkage protocol for use in the Dutch Cancer Registry for Epidemiological Research. Int J Epidemiol. 1990, 19: 553-8.CrossRef Van den Brandt PA, Schouten LJ, Goldbohm RA, Dorant E, Hunen PM: Development of a record linkage protocol for use in the Dutch Cancer Registry for Epidemiological Research. Int J Epidemiol. 1990, 19: 553-8.CrossRef
12.
go back to reference Waien SA: Linking large administrative databases: a method for conducting emergency medical services cohort studies using existing data. Acad Emerg Med. 1997, 4: 1087-95.CrossRef Waien SA: Linking large administrative databases: a method for conducting emergency medical services cohort studies using existing data. Acad Emerg Med. 1997, 4: 1087-95.CrossRef
13.
go back to reference Knuth D: The art of computer programming: sorting and searching, Reading. 1973, Massachusetts: Addison-Wesley Knuth D: The art of computer programming: sorting and searching, Reading. 1973, Massachusetts: Addison-Wesley
Metadata
Title
Assessing record linkage between health care and Vital Statistics databases using deterministic methods
Authors
Bing Li
Hude Quan
Andrew Fong
Mingshan Lu
Publication date
01-12-2006
Publisher
BioMed Central
Published in
BMC Health Services Research / Issue 1/2006
Electronic ISSN: 1472-6963
DOI
https://doi.org/10.1186/1472-6963-6-48

Other articles of this Issue 1/2006

BMC Health Services Research 1/2006 Go to the issue