Development and evaluation of an algorithm to link mothers and infants in two US commercial healthcare claims databases for pharmacoepidemiology research

Weaver, James; Hardin, Jill H.; Blacketer, Clair; Krumme, Alexis A.; Jacobson, Melanie H.; Ryan, Patrick B.

doi:10.1186/s12874-023-02073-6

Table 1 Selected characteristics of linked and non-linked mothers, measured 365 days before and including pregnancy start

From: Development and evaluation of an algorithm to link mothers and infants in two US commercial healthcare claims databases for pharmacoepidemiology research

	CCAE			Clinformatics®
Characteristic	Linked % (n = 2,528,482)	Non-linked % (n = 995,892)	SMD	Linked % (n = 1,589,010)	Non-linked % (n = 420,199)	SMD
Index year
2000	0.61	0.72	0.013	1.35	1.39	0.003
2001	0.94	1.13	0.019	3.83	3.77	-0.003
2002	1.92	2.04	0.009	4.71	4.54	-0.008
2003	3.11	2.64	-0.028	4.84	4.65	-0.009
2004	4.02	3.39	-0.033	4.8	4.49	-0.015
2005	3.97	3.27	-0.037	6.18	4.09	-0.095
2006	4.74	4.11	-0.031	6.3	4.76	-0.067
2007	4.93	4.36	-0.027	6.31	4.81	-0.065
2008	6.07	5.25	-0.036	5.93	4.64	-0.058
2009	6.17	5.83	-0.014	5.12	5.18	0.003
2010	7.45	6.47	-0.039	4.54	6.01	0.066
2011	8.16	8.36	0.007	4.37	6.45	0.092
2012	6.85	7.69	0.032	4.87	5.33	0.021
2013	6.96	7.26	0.012	4.71	4.81	0.005
2014	5.9	6.82	0.038	4.41	4.78	0.018
2015	5.34	5.99	0.028	4.6	5.02	0.02
2016	4.96	5.45	0.022	4.67	5.17	0.023
2017	4.87	5.11	0.011	4.81	5.28	0.022
2018	5.09	5.27	0.008	4.78	5.11	0.015
2019	4.5	4.79	0.014	4.44	4.89	0.021
2020	3.43	4.06	0.033	4.33	4.65	0.015
2021	0	0.01	0.008	0.11	0.18	0.017
Index month
1	10	9.71	-0.01	9.05	9.14	0.003
2	7.58	10.71	0.109	7.79	8.32	0.019
3	6.1	14.36	0.275	7.86	9.19	0.048
4	7.4	8.38	0.037	7.42	7.7	0.011
5	8.48	7.07	-0.053	8.24	7.97	-0.01
6	8.42	6.8	-0.061	8.07	7.8	-0.01
7	8.88	6.89	-0.074	8.41	8.11	-0.011
8	8.79	6.84	-0.073	8.37	8.01	-0.013
9	8.7	7.1	-0.059	8.52	8.18	-0.012
10	8.73	7.43	-0.048	8.79	8.48	-0.011
11	8.49	7.23	-0.047	8.7	8.4	-0.011
12	8.43	7.47	-0.036	8.78	8.71	-0.003
Age (years)
Mean	31.22	27.36	-0.483	30.93	27.94	-0.357
Std. deviation	4.68	6.48		4.88	6.81
Median	31	27		31	28
Prior observation time (days)
Mean	737.21	833.74	0.079	715.62	778.33	0.054
Std. deviation	743.73	978.46		741.25	893.25
Median	503	489		476	472
Post observation time (days)
Mean	1357.52	959.98	-0.265	1221.15	930.43	-0.212
Std. deviation	1193.69	905.81		1092.51	829.61
Median	929	648		825	642
Pregnancy episode length (days)
Mean	273.15	269.83	-0.111	272.73	270.33	-0.08
Std. deviation	18.44	23.58		18.89	23.27
Median	278	277		278	278
Distinct conditions
Mean	6.67	6.77	0.01	6.95	7.45	0.045
Std. deviation	6.73	7.34		7.38	8.18
Median	5	4		5	5
Distinct drug ingredients
Mean	4.68	4.62	-0.009	4.14	4.44	0.04
Std. deviation	5.39	5.49		5.17	5.5
Median	3	3		3	3
Distinct procedures
Mean	7.4	6.62	-0.075	7.08	6.92	-0.015
Std. deviation	7.39	7.28		7.61	7.71
Median	5	5		5	5
Distinct measurements
Mean	6.7	6.29	-0.025	13.62	12.48	-0.03
Std. deviation	11.93	11.86		27.48	25.9
Median	3	3		3	3
Distinct visit types
Outpatient Visit
Mean	6.61	5.51	-0.085	6.38	5.89	-0.036
Std. deviation	9.81	8.31		10.47	8.98
Median	4	3		3	3
Inpatient Visit
Mean	0.11	0.11	0	0.1	0.11	0.003
Std. deviation	1.11	1.25		0.77	0.94
Median	0	0		0	0
Emergency Room Visit
Mean	0.16	0.34	0.09	0.38	0.33	-0.007
Std. deviation	1.16	1.56		6.14	4.89
Median	0	0		0	0
Charlson comorbidity index
Mean	0.19	0.2	0.002	0.22	0.24	0.017
Std. deviation	0.85	0.89		0.93	1.02
Median	0	0		0	0

CCAE: IBM® Marketscan® Commercial Database; Clinformatics®: Optum’s de-identified Clinformatics® Data Mart Database; SMD: Standardized difference of means

Back to article page

ISSN: 1471-2288

Contact us

General enquiries: journalsubmissions@springernature.com

BMC Medical Research Methodology

Contact us