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 2 Selected characteristics of linked and non-linked mothers, measured 365 days before and including pregnancy end

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.1	0.31	0.047	0.01	0.02	0.01
2001	0.64	0.87	0.026	2.01	2.2	0.013
2002	1.14	1.51	0.032	4.27	4.29	0.001
2003	2.21	2.26	0.003	4.82	4.67	-0.007
2004	3.32	2.87	-0.026	4.78	4.57	-0.01
2005	4.08	3.44	-0.034	5.07	4.05	-0.049
2006	4.03	3.37	-0.035	6.37	4.42	-0.087
2007	4.81	4.21	-0.029	6.3	4.84	-0.064
2008	5.26	4.71	-0.025	6.26	4.79	-0.064
2009	6.38	5.4	-0.042	5.81	4.58	-0.055
2010	6.17	6.26	0.004	4.8	5.62	0.037
2011	7.65	6.81	-0.033	4.49	6.14	0.074
2012	8.04	8.94	0.032	4.4	6.46	0.091
2013	6.7	6.97	0.01	5.07	4.9	-0.008
2014	6.97	7.38	0.016	4.56	4.74	0.009
2015	5.45	6.15	0.03	4.47	4.86	0.018
2016	5.44	6.03	0.025	4.73	5.12	0.018
2017	4.95	5.25	0.014	4.68	5.2	0.024
2018	4.91	5.18	0.012	4.8	5.23	0.02
2019	4.97	5.12	0.007	4.74	5.1	0.017
2020	4.43	4.68	0.012	4.34	4.76	0.021
2021	2.33	2.28	-0.003	3.23	3.43	0.011
Index month
1	8.08	6.7	-0.053	7.55	7.44	-0.004
2	7.77	6.19	-0.062	7.43	7.04	-0.015
3	8.74	6.84	-0.071	8.32	8.01	-0.011
4	8.56	6.65	-0.072	8.14	7.83	-0.012
5	8.97	6.9	-0.077	8.58	8.13	-0.016
6	8.7	7.2	-0.055	8.47	8.19	-0.01
7	8.71	7.48	-0.045	8.76	8.51	-0.009
8	8.73	7.46	-0.047	8.96	8.74	-0.008
9	8.52	7.6	-0.034	8.71	8.63	-0.003
10	9.68	8.96	-0.025	8.77	8.85	0.003
11	8.37	10.81	0.083	8.27	8.64	0.013
12	5.17	17.22	0.389	8.04	9.99	0.068
Age (years)
Mean	31.99	27.98	-0.504	31.68	28.66	-0.36
Std. deviation	4.67	6.44		4.87	6.81
Median	32	27		32	28
Prior observation time (days)
Mean	1010.36	1103.57	0.076	988.36	1048.67	0.052
Std. deviation	743.4	978.27		741	893.1
Median	777	758		749	743
Post observation time (days)
Mean	1084.37	690.15	-0.263	948.41	660.09	-0.21
Std. deviation	1192.66	905.33		1091.46	828.86
Median	656	377		552	371
Distinct conditions
Mean	19.81	20.75	0.061	20.21	21.43	0.076
Std. deviation	10.21	11.4		10.64	11.96
Median	18	18		18	19
Distinct drug ingredients
Mean	5.3	5.65	0.045	5.4	6	0.074
Std. deviation	5.35	5.61		5.39	5.84
Median	4	4		4	4
Distinct procedures
Mean	17.46	16.82	-0.054	18.6	18.55	-0.004
Std. deviation	8.44	8.51		8.72	9.11
Median	16	15		18	17
Distinct measurements
Mean	20.85	20.95	0.004	44.01	41.65	-0.046
Std. deviation	15.57	16.57		36.44	36.03
Median	18	18		32	27
Distinct visit types
Outpatient Visit
Mean	15.53	14.21	-0.089	15.7	14.76	-0.054
Std. deviation	11.33	9.52		13.44	10.96
Median	13	12		12	12
Inpatient Visit
Mean	1.13	1.14	0.006	1.14	1.12	-0.019
Std. deviation	0.67	0.69		0.71	0.64
Median	1	1		1	1
Emergency Room Visit
Mean	0.33	0.67	0.146	1.03	0.98	-0.007
Std. deviation	1.36	1.85		5.63	4.52
Median	0	0		0	0
Charlson comorbidity index
Mean	0.3	0.3	0.001	0.32	0.34	0.016
Std. deviation	0.9	0.94		0.98	1.08
Median	0	0		0	0

CCAE: IBM 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