The urge to merge: linking vital statistics records and Medicaid claims.
This paper describes a procedure used to link Medicaid claims data to California vital statistics records for very low birthweight infants. The linkage involved about 53,000 infants born from 1980 to 1987 and 1.46 million claims for delivery/birth-related hospital admissions during the same period. Because the two data files did not share a unique identifier, record linkage required combining evidence across several linking variables: delivery hospital, delivery/birth date or hospitalization period, names, mother's age, and zip code. To combine the various pieces of evidence, we used record linkage theory to compute scores that measure the likelihood of a match, i.e., that two records correspond to the same delivery. These scores appropriately weight the various pieces of evidence for or against a match. Implementation required dealing with large amounts of missing data in one of the files, errors and variations in reported names, and the need to minimize the number of incorrect links. The approach applies to a wide range of linkage problems. The ability to combine existing datasets to form new datasets containing analysis variables from each facilitates analyses that would otherwise be impossible, or prohibitively expensive.
Bell
R M
RM
RAND, Santa Monica, CA 90407-2138.
Keesey
J
J
Richards
T
T
D015982:Bias; D001719:Birth Certificates; D002140:California / Q000453:epidemiology; D016208:Databases, Factual; D003644:Death Certificates; D036861:Delivery, Obstetric / Q000191:economics / Q000706:statistics & numerical data / Q000639:trends; D005260:Female; D005313:Fetal Death / Q000453:epidemiology; D017048:Health Care Costs / Q000706:statistics & numerical data / Q000639:trends; D006760:Hospitalization / Q000191:economics / Q000706:statistics & numerical data / Q000639:trends; D006801:Humans; D007226:Infant Mortality; D007230:Infant, Low Birth Weight; D007231:Infant, Newborn; D007344:Insurance Claim Reporting; D016013:Likelihood Functions; D008484:Medicaid / Q000706:statistics & numerical data*; D008498:Medical Record Linkage / Q000379:methods*; D011247:Pregnancy; D015203:Reproducibility of Results; D012307:Risk Factors; D015996:Survival Rate; D014481:United States