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

Open Access 01-12-2007 | Research article

Methods for dealing with discrepant records in linked population health datasets: a cross-sectional study

Authors: Christine L Roberts, Charles S Algert, Jane B Ford

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

Login to get access

Abstract

Background

Linked population health data are increasingly used in epidemiological studies. If data items are reported on more than one dataset, data linkage can reduce the under-ascertainment associated with many population health datasets. However, this raises the possibility of discrepant case reports from different datasets.

Methods

We examined the effect of four methods of classifying discrepant reports from different population health datasets on the estimated prevalence of hypertensive disorders of pregnancy and on the adjusted odds ratios (aOR) for known risk factors. Data were obtained from linked, validated, birth and hospital data for women who gave birth in a New South Wales hospital (Australia) 2000–2002.

Results

Among 250173 women with linked data, 238412 (95.3%) women had perfect agreement on the occurrence of hypertension, 1577 (0.6%) had imperfect agreement; 9369 (3.7%) had hypertension reported in only one dataset (under-reporting) and 815 (0.3%) had conflicting types of hypertension. Using only perfect agreement between birth and discharge data resulted in the lowest prevalence rates (0.3% chronic, 5.1% pregnancy hypertension), while including all reports resulted in the highest prevalence rates (1.1 % chronic, 8.7% pregnancy hypertension). The higher prevalence rates were generally consistent with international reports. In contrast, perfect agreement gave the highest aOR (95% confidence interval) for known risk factors: risk of chronic hypertension for maternal age ≥40 years was 4.0 (2.9, 5.3) and the risk of pregnancy hypertension for multiple birth was 2.8 (2.5, 3.2).

Conclusion

The method chosen for classifying discrepant case reports should vary depending on the study question; all reports should be used as part of calculating the range of prevalence estimates, but perfect matches may be best suited to risk factor analyses. These findings are likely to be applicable to the linkage of any specialised health services datasets to population data that include information on diagnoses or procedures.
Literature
1.
go back to reference Roos NP, Black C, Roos LL, Frohlich N, DeCoster C, Mustard C, Brownell MD, Shanahan M, Fergusson P, Toll F, Carriere KC, Burchill C, Fransoo R, MacWilliam L, Bogdanovic B, Friesen D: Managing health services: how the Population Health Information System (POPULIS) works for policymakers. Med Care. 1999, 37: JS27-JS41. 10.1097/00005650-199906001-00007.CrossRef Roos NP, Black C, Roos LL, Frohlich N, DeCoster C, Mustard C, Brownell MD, Shanahan M, Fergusson P, Toll F, Carriere KC, Burchill C, Fransoo R, MacWilliam L, Bogdanovic B, Friesen D: Managing health services: how the Population Health Information System (POPULIS) works for policymakers. Med Care. 1999, 37: JS27-JS41. 10.1097/00005650-199906001-00007.CrossRef
2.
go back to reference Schwartz RM, Gagnon DE, Muri JH, Zhao QR, Kellogg R: Administrative data for quality improvement. Pediatrics. 1999, 103: 291-301. 10.1542/peds.103.5.1045.CrossRef Schwartz RM, Gagnon DE, Muri JH, Zhao QR, Kellogg R: Administrative data for quality improvement. Pediatrics. 1999, 103: 291-301. 10.1542/peds.103.5.1045.CrossRef
3.
go back to reference Stanley FJ, Croft ML, Gibbins J, Read AW: A population database for maternal and child health research in Western Australia using record linkage. Paediatr Perinat Epidemiol. 1994, 8: 433-447.CrossRef Stanley FJ, Croft ML, Gibbins J, Read AW: A population database for maternal and child health research in Western Australia using record linkage. Paediatr Perinat Epidemiol. 1994, 8: 433-447.CrossRef
4.
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.CrossRef 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.CrossRef
5.
go back to reference Sibthorpe B, Kliewer E, Smith L: Record linkage in Australian epidemiological research: health benefits, privacy safeguards and future potential. Aust J Public Health. 1995, 19: 250-256.CrossRef Sibthorpe B, Kliewer E, Smith L: Record linkage in Australian epidemiological research: health benefits, privacy safeguards and future potential. Aust J Public Health. 1995, 19: 250-256.CrossRef
6.
go back to reference Parrish KM, Holt VL, Connell FA, Williams B, LoGerfo JP: Variations in the accuracy of obstetric procedures and diagnoses on birth records in Washington State, 1989. American Journal of Epidemiology. 1993, 138: 119-127.CrossRef Parrish KM, Holt VL, Connell FA, Williams B, LoGerfo JP: Variations in the accuracy of obstetric procedures and diagnoses on birth records in Washington State, 1989. American Journal of Epidemiology. 1993, 138: 119-127.CrossRef
7.
go back to reference Lydon-Rochelle MT, Holt VL, Cardenas V, Nelson JC, Easterling TR, Gardella C, Callaghan WM: The reporting of pre-existing maternal medical conditions and complications of pregnancy on birth certificates and in hospital discharge data. American Journal of Obstetrics and Gynecology. 2005, 193: 125-134. 10.1016/j.ajog.2005.02.096.CrossRef Lydon-Rochelle MT, Holt VL, Cardenas V, Nelson JC, Easterling TR, Gardella C, Callaghan WM: The reporting of pre-existing maternal medical conditions and complications of pregnancy on birth certificates and in hospital discharge data. American Journal of Obstetrics and Gynecology. 2005, 193: 125-134. 10.1016/j.ajog.2005.02.096.CrossRef
8.
go back to reference Lydon-Rochelle MT, Holt VL, Nelson JC, Cardenas V, Gardella C, Easterling TR, Callaghan WM: Accuracy of reporting maternal in-hospital diagnoses and intrapartum procedures in Washington State linked birth records. Paediatr Perinat Epidemiol. 2005, 19: 460-471. 10.1111/j.1365-3016.2005.00682.x.CrossRef Lydon-Rochelle MT, Holt VL, Nelson JC, Cardenas V, Gardella C, Easterling TR, Callaghan WM: Accuracy of reporting maternal in-hospital diagnoses and intrapartum procedures in Washington State linked birth records. Paediatr Perinat Epidemiol. 2005, 19: 460-471. 10.1111/j.1365-3016.2005.00682.x.CrossRef
9.
go back to reference Malenka DJ, McLerran D, Roos N, Fisher ES, Wennberg JE: Using administrative data to describe casemix: a comparison with the medical record. J Clin Epidemiol. 1994, 47: 1027-1032. 10.1016/0895-4356(94)90118-X.CrossRef Malenka DJ, McLerran D, Roos N, Fisher ES, Wennberg JE: Using administrative data to describe casemix: a comparison with the medical record. J Clin Epidemiol. 1994, 47: 1027-1032. 10.1016/0895-4356(94)90118-X.CrossRef
10.
go back to reference Roberts CL, Algert CS, Morris JM, Ford JB, Henderson-Smart DJ: Hypertensive disorders in pregnancy: a population-based study. Med J Aust. 2005, 182: 332-335.CrossRef Roberts CL, Algert CS, Morris JM, Ford JB, Henderson-Smart DJ: Hypertensive disorders in pregnancy: a population-based study. Med J Aust. 2005, 182: 332-335.CrossRef
11.
go back to reference National High Blood Pressure Education Program Working Group on High Blood Pressure in Pregnancy: Report of the National High Blood Pressure Education Program Working Group on High Blood Pressure in Pregnancy. American Journal of Obstetrics and Gynecology. 2000, 183: S1-S22. 10.1067/mob.2000.107928.CrossRef National High Blood Pressure Education Program Working Group on High Blood Pressure in Pregnancy: Report of the National High Blood Pressure Education Program Working Group on High Blood Pressure in Pregnancy. American Journal of Obstetrics and Gynecology. 2000, 183: S1-S22. 10.1067/mob.2000.107928.CrossRef
12.
go back to reference Brown MA, Hague WM, Higgins J, Lowe S, McCowan L, Oats J, Peek MJ, Rowan JA, Walters BN, Austalasian Society of the Study of Hypertension in P: The detection, investigation and management of hypertension in pregnancy: full consensus statement. Australian & New Zealand Journal of Obstetrics & Gynaecology. 2000, 40: 139-155.CrossRef Brown MA, Hague WM, Higgins J, Lowe S, McCowan L, Oats J, Peek MJ, Rowan JA, Walters BN, Austalasian Society of the Study of Hypertension in P: The detection, investigation and management of hypertension in pregnancy: full consensus statement. Australian & New Zealand Journal of Obstetrics & Gynaecology. 2000, 40: 139-155.CrossRef
13.
go back to reference Parrish KM, Holt VL, Easterling TR, Connell FA, LoGerfo JP: Effect of changes in maternal age, parity, and birth weight distribution on primary cesarean delivery rates. Jama. 1994, 271: 443-447. 10.1001/jama.271.6.443.CrossRef Parrish KM, Holt VL, Easterling TR, Connell FA, LoGerfo JP: Effect of changes in maternal age, parity, and birth weight distribution on primary cesarean delivery rates. Jama. 1994, 271: 443-447. 10.1001/jama.271.6.443.CrossRef
14.
go back to reference Lydon-Rochelle M, Holt VL, Easterling TR, Martin DP: Cesarean delivery and postpartum mortality among primiparas in Washington State, 1987-1996(1). Obstet Gynecol. 2001, 97: 169-174. 10.1016/S0029-7844(00)01119-4.PubMed Lydon-Rochelle M, Holt VL, Easterling TR, Martin DP: Cesarean delivery and postpartum mortality among primiparas in Washington State, 1987-1996(1). Obstet Gynecol. 2001, 97: 169-174. 10.1016/S0029-7844(00)01119-4.PubMed
15.
go back to reference Zetterstrom K, Lindeberg SN, Haglund B, Hanson U: Maternal complications in women with chronic hypertension: a population-based cohort study. Acta Obstet Gynecol Scand. 2005, 84: 419-424. 10.1111/j.0001-6349.2005.00508.x.PubMed Zetterstrom K, Lindeberg SN, Haglund B, Hanson U: Maternal complications in women with chronic hypertension: a population-based cohort study. Acta Obstet Gynecol Scand. 2005, 84: 419-424. 10.1111/j.0001-6349.2005.00508.x.PubMed
16.
go back to reference International Working Group for Disease Monitoring and Forecasting: Capture-recapture and multiple-record systems estimation I: History and theoretical development. American Journal of Epidemiology. 1995, 142: 1047-1058.CrossRef International Working Group for Disease Monitoring and Forecasting: Capture-recapture and multiple-record systems estimation I: History and theoretical development. American Journal of Epidemiology. 1995, 142: 1047-1058.CrossRef
17.
go back to reference Corrao G, Bagnardi V, Vittadini G, Favilli S: Capture-recapture methods to size alcohol related problems in a population. J Epidemiol Community Health. 2000, 54: 603-610. 10.1136/jech.54.8.603.CrossRef Corrao G, Bagnardi V, Vittadini G, Favilli S: Capture-recapture methods to size alcohol related problems in a population. J Epidemiol Community Health. 2000, 54: 603-610. 10.1136/jech.54.8.603.CrossRef
18.
go back to reference Bruno G, LaPorte RE, Merletti F, Biggeri A, McCarty D, Pagano G: National diabetes programs. Application of capture-recapture to count diabetes?. Diabetes Care. 1994, 17: 548-556.CrossRef Bruno G, LaPorte RE, Merletti F, Biggeri A, McCarty D, Pagano G: National diabetes programs. Application of capture-recapture to count diabetes?. Diabetes Care. 1994, 17: 548-556.CrossRef
19.
go back to reference NSW Health Department: NSW Mothers and Babies 2002. 2003, Sydney, NSW Public Health Bulletin Supplement, State Publication No. (PH) 030277 NSW Health Department: NSW Mothers and Babies 2002. 2003, Sydney, NSW Public Health Bulletin Supplement, State Publication No. (PH) 030277
20.
go back to reference NSW Health Department: Inpatient Statistics Collection Instruction Manual. 1999, Sydney, NSW Health Department NSW Health Department: Inpatient Statistics Collection Instruction Manual. 1999, Sydney, NSW Health Department
21.
go back to reference National Centre for Classification in Health: The international statistical classification of diseases and related health problems, 10th revision, Australian modification (ICD-10-AM). 2004, Sydney, National Centre for Classification in Health, University of Sydney, 5. National Centre for Classification in Health: The international statistical classification of diseases and related health problems, 10th revision, Australian modification (ICD-10-AM). 2004, Sydney, National Centre for Classification in Health, University of Sydney, 5.
22.
go back to reference NSW Health Department: Validation Study: NSW Midwives Data Collection 1998. New South Wales Mothers and Babies 1998. 2000, NSW Public Health Bulletin, State Publication No. (EPI) 000029, 9(S-2):97-99. NSW Health Department: Validation Study: NSW Midwives Data Collection 1998. New South Wales Mothers and Babies 1998. 2000, NSW Public Health Bulletin, State Publication No. (EPI) 000029, 9(S-2):97-99.
23.
go back to reference Taylor L, Travis S, Pym M, Olive E, Henderson-Smart D: How useful are hospital morbidity data for monitoring conditions occurring in the perinatal period?. Australian and New Zealand Journal of Obstetrics and Gynaecology. 2005, 45: 36-41. 10.1111/j.1479-828X.2005.00339.x.CrossRef Taylor L, Travis S, Pym M, Olive E, Henderson-Smart D: How useful are hospital morbidity data for monitoring conditions occurring in the perinatal period?. Australian and New Zealand Journal of Obstetrics and Gynaecology. 2005, 45: 36-41. 10.1111/j.1479-828X.2005.00339.x.CrossRef
24.
go back to reference Ford JB, Roberts CL, Taylor LK: Characteristics of unmatched maternal and baby records in linked birth records and hospital discharge data. Paediatr Perinat Epidemiol. 2006, 20 (4): 329-37. 10.1111/j.1365-3016.2006.00715.x.CrossRef Ford JB, Roberts CL, Taylor LK: Characteristics of unmatched maternal and baby records in linked birth records and hospital discharge data. Paediatr Perinat Epidemiol. 2006, 20 (4): 329-37. 10.1111/j.1365-3016.2006.00715.x.CrossRef
25.
go back to reference Dawson LM, Parfrey PS, Hefferton D, Dicks EL, Cooper MJ, Young D, Marsden PA: Familial risk of preeclampsia in Newfoundland: a population-based study. Journal of the American Society of Nephrology. 2002, 13: 1901-1906. 10.1097/01.ASN.0000017224.24670.82.CrossRef Dawson LM, Parfrey PS, Hefferton D, Dicks EL, Cooper MJ, Young D, Marsden PA: Familial risk of preeclampsia in Newfoundland: a population-based study. Journal of the American Society of Nephrology. 2002, 13: 1901-1906. 10.1097/01.ASN.0000017224.24670.82.CrossRef
26.
go back to reference Lee W, O'Connell CM, Baskett TF: Maternal and perinatal outcomes of eclampsia: Nova Scotia, 1981-2000. Journal of Obstetrics and Gynaecology Canada. 2004, 26: 119-123.CrossRef Lee W, O'Connell CM, Baskett TF: Maternal and perinatal outcomes of eclampsia: Nova Scotia, 1981-2000. Journal of Obstetrics and Gynaecology Canada. 2004, 26: 119-123.CrossRef
27.
go back to reference Jacobs DJ, Vreeburg SA, Dekker GA, Heard AR, Priest KR, Chan A: Risk factors for hypertension during pregnancy in South Australia. Australian & New Zealand Journal of Obstetrics & Gynaecology. 2003, 43: 421-428. 10.1046/j.0004-8666.2003.00120.x.CrossRef Jacobs DJ, Vreeburg SA, Dekker GA, Heard AR, Priest KR, Chan A: Risk factors for hypertension during pregnancy in South Australia. Australian & New Zealand Journal of Obstetrics & Gynaecology. 2003, 43: 421-428. 10.1046/j.0004-8666.2003.00120.x.CrossRef
28.
go back to reference Xiong X, Fraser WD, Demianczuk NN: History of abortion, preterm, term birth, and risk of preeclampsia: a population-based study. American Journal of Obstetrics and Gynecology. 2002, 187: 1013-1018. 10.1067/mob.2002.126282.CrossRef Xiong X, Fraser WD, Demianczuk NN: History of abortion, preterm, term birth, and risk of preeclampsia: a population-based study. American Journal of Obstetrics and Gynecology. 2002, 187: 1013-1018. 10.1067/mob.2002.126282.CrossRef
29.
go back to reference Robles SC, Marrett LD, Clarke EA, Risch HA: An application of capture-recapture methods to the estimation of completeness of cancer registration. J Clin Epidemiol. 1988, 41: 495-501. 10.1016/0895-4356(88)90052-2.CrossRef Robles SC, Marrett LD, Clarke EA, Risch HA: An application of capture-recapture methods to the estimation of completeness of cancer registration. J Clin Epidemiol. 1988, 41: 495-501. 10.1016/0895-4356(88)90052-2.CrossRef
30.
go back to reference Iezzoni LI, Foley SM, Daley J, Hughes J, Fisher ES, Heeren T: Comorbidities, complications, and coding bias. Does the number of diagnosis codes matter in predicting in-hospital mortality?. Jama. 1992, 267: 2197-2203. 10.1001/jama.267.16.2197.CrossRef Iezzoni LI, Foley SM, Daley J, Hughes J, Fisher ES, Heeren T: Comorbidities, complications, and coding bias. Does the number of diagnosis codes matter in predicting in-hospital mortality?. Jama. 1992, 267: 2197-2203. 10.1001/jama.267.16.2197.CrossRef
31.
go back to reference Juurlink DN, Mamdani MM, Lee DS, Kopp A, Austin PC, Laupacis A, Redelmeier DA: Rates of hyperkalemia after publication of the Randomized Aldactone Evaluation Study. N Engl J Med. 2004, 351: 543-551. 10.1056/NEJMoa040135.CrossRef Juurlink DN, Mamdani MM, Lee DS, Kopp A, Austin PC, Laupacis A, Redelmeier DA: Rates of hyperkalemia after publication of the Randomized Aldactone Evaluation Study. N Engl J Med. 2004, 351: 543-551. 10.1056/NEJMoa040135.CrossRef
32.
go back to reference Hall S, Holman CD, Sheiner H, Hendrie D: The influence of socio-economic and locational disadvantage on survival after a diagnosis of lung or breast cancer in Western Australia. J Health Serv Res Policy. 2004, 9 Suppl 2: 10-16. 10.1258/1355819042248116.CrossRef Hall S, Holman CD, Sheiner H, Hendrie D: The influence of socio-economic and locational disadvantage on survival after a diagnosis of lung or breast cancer in Western Australia. J Health Serv Res Policy. 2004, 9 Suppl 2: 10-16. 10.1258/1355819042248116.CrossRef
33.
go back to reference Mahonen M, Salomaa V, Keskimaki I, Moltchanov V: The feasibility of routine mortality and morbidity register data linkage to study the occurrence of acute coronary heart disease events in Finland. European Journal of Epidemiology. 2004, 16: 701-711. 10.1023/A:1026599805969.CrossRef Mahonen M, Salomaa V, Keskimaki I, Moltchanov V: The feasibility of routine mortality and morbidity register data linkage to study the occurrence of acute coronary heart disease events in Finland. European Journal of Epidemiology. 2004, 16: 701-711. 10.1023/A:1026599805969.CrossRef
34.
go back to reference Ellekjaer H, Holmen J, Kruger O, Terent A: Identification of incident stroke in Norway. Stroke. 1999, 30: 56-60.CrossRef Ellekjaer H, Holmen J, Kruger O, Terent A: Identification of incident stroke in Norway. Stroke. 1999, 30: 56-60.CrossRef
Metadata
Title
Methods for dealing with discrepant records in linked population health datasets: a cross-sectional study
Authors
Christine L Roberts
Charles S Algert
Jane B Ford
Publication date
01-12-2007
Publisher
BioMed Central
Published in
BMC Health Services Research / Issue 1/2007
Electronic ISSN: 1472-6963
DOI
https://doi.org/10.1186/1472-6963-7-12

Other articles of this Issue 1/2007

BMC Health Services Research 1/2007 Go to the issue