OBJECTIVE: To determine the accuracy of record matching using "Link King" software that uses an ordinal score for the certainty that linked records are valid matches. METHODS: We linked records in North Carolina Medicaid files to public health surveillance files using Link King matching software. We selected a stratified random sample of 230 of 45,295 linked records and 50 of 35,119 non-linked surveillance records, then manually reviewed the records. Sensitivity (Sn) and Specificity (Sp) were calculated based on each cut point of the Link King score, using manual review as the gold standard. RESULTS: The Sn increased from 0.837 (95% CI: 0.785, 0.892) to 0.935 (0.879, 0.994) and Sp decreased from 0.893 (0.816, 0.976) to 0.865 (0.790, 0.947) as cut points were varied to widen the scope of declared matches. With a goal of both Sn and Sp being large, accuracy was best when linked record pairs from the top three levels of certainty were included in the match. CONCLUSIONS: This study found that a publicly available software program accurately merged Medicaid and surveillance data. The Link King could be useful to researchers in merging administrative databases.
OBJECTIVE: To determine the accuracy of record matching using "Link King" software that uses an ordinal score for the certainty that linked records are valid matches. METHODS: We linked records in North Carolina Medicaid files to public health surveillance files using Link King matching software. We selected a stratified random sample of 230 of 45,295 linked records and 50 of 35,119 non-linked surveillance records, then manually reviewed the records. Sensitivity (Sn) and Specificity (Sp) were calculated based on each cut point of the Link King score, using manual review as the gold standard. RESULTS: The Sn increased from 0.837 (95% CI: 0.785, 0.892) to 0.935 (0.879, 0.994) and Sp decreased from 0.893 (0.816, 0.976) to 0.865 (0.790, 0.947) as cut points were varied to widen the scope of declared matches. With a goal of both Sn and Sp being large, accuracy was best when linked record pairs from the top three levels of certainty were included in the match. CONCLUSIONS: This study found that a publicly available software program accurately merged Medicaid and surveillance data. The Link King could be useful to researchers in merging administrative databases.
Authors: R Gary Rozier; Sally C Stearns; Bhavna T Pahel; Rocio B Quinonez; Jeongyoung Park Journal: Health Aff (Millwood) Date: 2010-12 Impact factor: 6.301
Authors: Richard A Deyo; Sara E Hallvik; Christi Hildebran; Miguel Marino; Eve Dexter; Jessica M Irvine; Nicole O'Kane; Joshua Van Otterloo; Dagan A Wright; Gillian Leichtling; Lisa M Millet Journal: J Gen Intern Med Date: 2016-08-02 Impact factor: 5.128
Authors: Richard A Deyo; Sara E Hallvik; Christi Hildebran; Miguel Marino; Rachel Springer; Jessica M Irvine; Nicole O'Kane; Joshua Van Otterloo; Dagan A Wright; Gillian Leichtling; Lisa M Millet; Jody Carson; Wayne Wakeland; Dennis McCarty Journal: J Pain Date: 2017-10-18 Impact factor: 5.820
Authors: Heather Beil; R Gary Rozier; John S Preisser; Sally C Stearns; Jessica Y Lee Journal: Am J Public Health Date: 2013-10-17 Impact factor: 9.308
Authors: Ashley M Kranz; R Gary Rozier; John S Preisser; Sally C Stearns; Morris Weinberger; Jessica Y Lee Journal: Am J Public Health Date: 2014-05-15 Impact factor: 9.308