| Literature DB >> 16597337 |
Bing Li1, Hude Quan, Andrew Fong, Mingshan Lu.
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.Entities:
Mesh:
Year: 2006 PMID: 16597337 PMCID: PMC1534029 DOI: 10.1186/1472-6963-6-48
Source DB: PubMed Journal: BMC Health Serv Res ISSN: 1472-6963 Impact factor: 2.655
Figure 1Matching Process between Vital Statistics registry and Population registry.
Figure 2Matching Process between Vital Statistics registry and In-hospital death data.
Linkage Rate (%) between Vital Statistics registry and Population registry
| A combination of common identifiers | 1998/99 (N = 4717) | 1999/00 (N = 5024) | 2000/01 (N = 5299) | 2001/02 (N = 5182) | |
| Surname, Sex and Date of Birth | |||||
| Total | 85.6 | 85.6 | 87.2 | 88.0 | |
| Sex: | Female | 85.0 | 86.0 | 86.9 | 88.2 |
| Male | 86.2 | 85.3 | 87.5 | 87.7 | |
| Age: | 1 to 9 years | 47.2 | 26.0 | 32.7 | 39.7 |
| 10 to 19 years | 70.5 | 77.8 | 67.4 | 66.7 | |
| 20 to 29 years | 75.0 | 69.7 | 64.0 | 66.7 | |
| 30 to 39 years | 86.4 | 80.1 | 80.9 | 82.8 | |
| 40 to 49 years | 84.1 | 87.6 | 87.4 | 85.9 | |
| 50 to 64 years | 83.2 | 85.6 | 87.2 | 88.0 | |
| Over 65 years | 87.2 | 87.5 | 89.0 | 90.0 | |
| First Name, Sex and Date of Birth | |||||
| Total | 78.8 | 79.5 | 81.2 | 82.4 | |
| Sex: | Female | 76.6 | 78.0 | 80.1 | 81.7 |
| Male | 80.9 | 81.0 | 82.2 | 83.2 | |
| Age: | 1 to 9 years | 41.5 | 26.0 | 34.6 | 36.5 |
| 10 to 19 years | 59.1 | 68.9 | 61.2 | 50.0 | |
| 20 to 29 years | 70.0 | 71.6 | 67.4 | 73.1 | |
| 30 to 39 years | 87.6 | 80.1 | 77.8 | 79.1 | |
| 40 to 49 years | 83.7 | 83.0 | 87.0 | 84.0 | |
| 50 to 64 years | 76.8 | 81.2 | 82.4 | 83.4 | |
| Over 65 years | 79.5 | 80.3 | 81.8 | 83.7 | |
| Surname, First Name, Sex and Date of Birth | |||||
| Total | 75.5 | 76.0 | 78.7 | 79.5 | |
| Sex: | Female | 73.0 | 74.5 | 77.1 | 78.9 |
| Male | 77.8 | 77.5 | 80.1 | 80.0 | |
| Age: | 1 to 9 years | 41.5 | 22.1 | 32.7 | 34.9 |
| 10 to 19 years | 52.3 | 60.0 | 51.0 | 47.0 | |
| 20 to 29 years | 63.0 | 60.6 | 59.3 | 62.8 | |
| 30 to 39 years | 79.9 | 73.3 | 71.6 | 71.6 | |
| 40 to 49 years | 73.9 | 76.3 | 81.1 | 78.1 | |
| 50 to 64 years | 72.2 | 76.9 | 78.8 | 79.4 | |
| Over 65 years | 77.2 | 77.8 | 80.2 | 81.5 | |
Correct Linkage Rates (%) among Records Matched between Vital Statistics registry and Population registry
| A combination of common identifiers | 1998/99 | 1999/00 | 2000/01 | 2001/02 | |
| Surname, Sex and Date of Birth | (N = 2620) | (N = 3014) | (N = 3445) | (N = 3530) | |
| Total | 96.1 | 96.3 | 96.9 | 96.9 | |
| Sex: | Female | 96.4 | 96.2 | 97.2 | 97.3 |
| Age: | Male | 95.8 | 96.4 | 96.5 | 96.6 |
| 1 to 9 years | 100.0 | 92.3 | 100.0 | 93.3 | |
| 10 to 19 years | 86.7 | 94.7 | 100.0 | 96.0 | |
| 20 to 29 years | 96.2 | 87.9 | 87.5 | 90.5 | |
| 30 to 39 years | 90.9 | 92.4 | 90.8 | 94.8 | |
| 40 to 49 years | 93.9 | 93.5 | 96.0 | 94.5 | |
| 50 to 64 years | 93.8 | 95.9 | 94.5 | 96.0 | |
| Over 65 years | 96.8 | 96.8 | 97.5 | 97.4 | |
| First Name, Sex and Date of Birth | (N = 2405) | (N = 2777) | (N = 3202) | (N = 3298) | |
| Total | 89.3 | 89.1 | 89.3 | 89.6 | |
| Sex: | Female | 89.5 | 90.0 | 89.3 | 90.5 |
| Male | 89.1 | 88.1 | 89.3 | 88.7 | |
| Age: | 1 to 9 years | 100.0 | 91.7 | 70.0 | 85.7 |
| 10 to 19 years | 76.9 | 87.5 | 73.7 | 84.2 | |
| 20 to 29 years | 91.7 | 80.0 | 86.4 | 76.0 | |
| 30 to 39 years | 74.2 | 74.6 | 67.7 | 73.7 | |
| 40 to 49 years | 71.7 | 66.4 | 68.2 | 71.6 | |
| 50 to 64 years | 82.9 | 88.5 | 82.0 | 85.2 | |
| Over 65 years | 91.9 | 91.9 | 92.8 | 92.2 | |
| Surname, First Name, Sex and Date of Birth | (N = 2311) | (N = 2672) | (N = 3120) | (N = 3188) | |
| Total | 97.3 | 97.6 | 98.2 | 98.5 | |
| Sex: | Female | 97.6 | 97.8 | 98.1 | 98.3 |
| Male | 97.1 | 97.4 | 98.2 | 98.7 | |
| Age: | 1 to 9 years | 100.0 | 100.0 | 100.0 | 100.0 |
| 10 to 19 years | 91.7 | 100.0 | 100.0 | 94.1 | |
| 20 to 29 years | 100.0 | 96.2 | 100.0 | 100.0 | |
| 30 to 39 years | 96.6 | 98.3 | 96.7 | 98.2 | |
| 40 to 49 years | 95.8 | 96.3 | 99.3 | 98.2 | |
| 50 to 64 years | 95.3 | 97.7 | 98.0 | 98.5 | |
| Over 65 years | 97.8 | 97.6 | 98.1 | 98.5 | |
Linkage Rates (%) between Vital Statistics registry and In-hospital death data
| A combination of common identifiers | 1998/99 (N = 1639) | 1999/00 (N = 1637) | 2000/01 (N = 1707) | 2001/02 (N = 1779) | |
| Surname, Sex and Date of Birth | |||||
| Total | 89.6 | 89.3 | 91.5 | 93.1 | |
| Sex: | Female | 88.0 | 88.3 | 90.8 | 93.8 |
| Male | 90.9 | 90.1 | 92.0 | 92.4 | |
| Age: | 1 to 9 years | 100.0 | 100.0 | 88.9 | 77.8 |
| 10 to 19 years | 100.0 | 85.7 | 88.9 | 92.3 | |
| 20 to 29 years | 88.2 | 80.0 | 78.6 | 70.0 | |
| 30 to 39 years | 92.1 | 80.6 | 83.9 | 85.2 | |
| 40 to 49 years | 87.7 | 90.1 | 90.7 | 88.2 | |
| 50 to 64 years | 85.5 | 87.1 | 91.1 | 94.7 | |
| Over 65 years | 90.2 | 90.0 | 91.9 | 93.5 | |
| First Name, Sex and Date of Birth | |||||
| Total | 80.1 | 82.3 | 82.8 | 85.0 | |
| Sex: | Female | 76.6 | 80.8 | 82.7 | 83.3 |
| Male | 83.2 | 83.6 | 82.9 | 86.6 | |
| Age: | 1 to 9 years | 77.8 | 83.3 | 100.0 | 88.9 |
| 10 to 19 years | 70.0 | 78.6 | 66.7 | 76.9 | |
| 20 to 29 years | 94.1 | 70.0 | 78.6 | 80.0 | |
| 30 to 39 years | 89.5 | 86.1 | 74.2 | 74.1 | |
| 40 to 49 years | 80.3 | 79.0 | 84.0 | 83.9 | |
| 50 to 64 years | 77.9 | 80.6 | 82.1 | 85.1 | |
| Over 65 years | 80.2 | 82.9 | 83.1 | 85.4 | |
| Surname, First Name, Sex and Date of Birth | |||||
| Total | 78.2 | 79.8 | 81.7 | 83.3 | |
| Sex: | Female | 74.2 | 78.1 | 81.2 | 81.9 |
| Male | 81.6 | 81.4 | 82.2 | 84.5 | |
| Age: | 1 to 9 years | 77.8 | 83.3 | 88.9 | 77.8 |
| 10 to 19 years | 70.0 | 71.4 | 55.6 | 76.9 | |
| 20 to 29 years | 88.2 | 60.0 | 78.6 | 60.0 | |
| 30 to 39 years | 86.8 | 77.8 | 71.0 | 74.1 | |
| 40 to 49 years | 76.5 | 77.8 | 80.0 | 81.7 | |
| 50 to 64 years | 73.6 | 77.6 | 81.3 | 83.7 | |
| Over 65 years | 78.8 | 80.8 | 82.3 | 83.7 | |
Correct linkage Rates (%) among Matched Records between Vital Statistics registry and In-hospital death data
| A combination of common identifiers | 1998/99 | 1999/00 | 2000/01 | 2001/02 | |
| Surname, Sex and Date of Birth | (N = 1056) | (N = 1102) | (N = 1253) | (N = 1411) | |
| Total | 98.1 | 97.1 | 98.7 | 98.9 | |
| Sex: | Female | 98.4 | 96.7 | 98.8 | 98.7 |
| Male | 97.9 | 97.4 | 98.6 | 99.2 | |
| Age: | 1 to 9 years | 100.0 | 100.0 | 100.0 | 100.0 |
| 10 to 19 years | 100.0 | 88.9 | 100.0 | 85.7 | |
| 20 to 29 years | 100.0 | 90.9 | 100.0 | 100.0 | |
| 30 to 39 years | 100.0 | 95.0 | 94.4 | 100.0 | |
| 40 to 49 years | 96.3 | 98.3 | 98.1 | 100.0 | |
| 50 to 64 years | 95.9 | 97.3 | 99.5 | 98.7 | |
| Over 65 years | 98.5 | 97.2 | 98.7 | 99.0 | |
| First Name, Sex and Date of Birth | (N = 960) | (N = 1019) | (N = 1142) | (N = 1286) | |
| Total | 97.8 | 96.8 | 98.4 | 98.8 | |
| Sex: | Female | 98.1 | 96.3 | 98.7 | 98.7 |
| Male | 97.6 | 97.2 | 98.2 | 98.9 | |
| Age: | 1 to 9 years | 100.0 | 100.0 | 100.0 | 100.0 |
| 10 to 19 years | 100.0 | 88.9 | 75.0 | 80.0 | |
| 20 to 29 years | 100.0 | 88.9 | 100.0 | 100.0 | |
| 30 to 39 years | 100.0 | 95.0 | 94.4 | 100.0 | |
| 40 to 49 years | 95.9 | 97.9 | 97.9 | 100.0 | |
| 50 to 64 years | 95.6 | 97.1 | 98.8 | 98.6 | |
| Over 65 years | 98.2 | 96.8 | 98.5 | 98.8 | |
| Surname, First Name, Sex and Date of Birth | (N = 936) | (N = 990) | (N = 1126) | (N = 1261) | |
| Total | 97.9 | 96.8 | 98.7 | 99.1 | |
| Sex: | Female | 98.1 | 96.3 | 98.9 | 98.8 |
| Male | 97.7 | 97.2 | 98.5 | 99.3 | |
| Age: | 1 to 9 years | 100.0 | 100.0 | 100.0 | 100.0 |
| 10 to 19 years | 100.0 | 87.5 | 100.0 | 80.0 | |
| 20 to 29 years | 100.0 | 87.5 | 100.0 | 100.0 | |
| 30 to 39 years | 100.0 | 94.7 | 94.1 | 100.0 | |
| 40 to 49 years | 95.8 | 97.9 | 97.8 | 100.0 | |
| 50 to 64 years | 95.4 | 97.0 | 99.4 | 98.5 | |
| Over 65 years | 98.3 | 96.9 | 98.6 | 99.2 | |