Duplicate Records: Single Site, Exploratory, Cross-Sectional Analysis


Created

2026-03-27

Last Modified

Click on the thumbnail above to preview images.

Files

1 Download↓
dr_ss_exp_cs.png (41.05 KB)
↓

Domain

Category

Parameters

Publisher

PEDSnet

Abstract

This check provides raw data and visualizations to aid a user in evaluating whether duplicate records are present in a dataset of interest. It summarizes the proportion of duplciate rows & patients with duplicate rows, as well as the median number of duplicate rows per patient.

Data Requirements

cohort , dr_input_file , omop_or_pcornet , single_or_multi_site , anomaly_or_exploratory , time , patient_level_tbl , output_level

Probe

Clinical Assessment

Access Package

# install.packages("devtools") devtools::install_github('ssdqa/duplicaterecords')

Visualization Output

This check outputs a bar graph displaying the user-specified numeric value with one bar for each duplicate definition. It can display any of: duplicate_row_prop, duplicate_pt_prop, median_all_with0s / median_site_with0s, or median_all_without0s / median_site_without0s

Raw Output

This check produces a raw data output containing 14 columns:

Column Data Type Definition
site character the name of the site being targeted
duplicate_definition character an alias to describe the definition of duplication being investigated
duplicate_columns character the name(s) of the column(s) included or excluded to define duplication
total_rows numeric the total number of rows in the domain
total_pt numeric the total number of patients in the domain
duplicate_rows numeric the number of duplicate rows
duplicate_pt numeric the number of patients with at least one duplicate row
duplicate_row_prop numeric the proportion of duplicate rows
duplicate_pt_prop numeric the proportion of patients with at least one duplicate row
median_all_with0s numeric the median number of duplicate rows per patient, for all patients, across all sites
median_all_without0s numeric the median number of duplicate rows per patient, for only patients with evidence of duplication, across all sites
median_site_with0s numeric the median number of duplicate rows per patient, for all patients, across a specific site
median_site_without0s numeric the median number of duplicate rows per patient, for only patients with evidence of duplication, for a specific site
output_function character a string indicating the type of visualization that should be generated by dr_output

Affiliation(s)

PEDSnet Data Coordinating Center

Funder(s)

This research was made possible through the generous support of Patient-Centered Outcomes Research Institute. The statements presented in this work are solely the responsibility of the author(s) and do not necessarily represent the views of PCORI, its Board of Governors, or its Methodology Committee.

Provenance

Description

Development Code

https://github.com/ssdqa/duplicaterecords

Clinical Subjects Headings

Related Data Quality Result

Related Person

Related Code

Thumbnail Image
Study-Specific Quality, Utility, and Breadth Assessment
Created:2025-11Affiliation:PEDSnet Data Coordinating Center
This suite of R packages allows one to investigate multiple facets of data quality and customize analyses based on your study-specific needs. Each module allows up to 8 different analyses in either the OMOP or PCORnet CDM, all aimed at taking a different view of the data while still addressing the same data quality probe.

##### [View pkgdown summary here.](https://ssdqa.github.io/squba/)

Related Data Quality Check

Related Publications

Creative Commons license

a CC-BY Attribution 4.0 License.
Except where otherwised noted, this item's license is described as a CC-BY Attribution 4.0 License.

Cite this Data Quality Check

Wieand, K. & Razzaghi, H. (2026, March). Duplicate Records: Single Site, Exploratory, Cross-Sectional Analysis. [D Q Check]. PEDSpace Knowledge Bank. https://doi.org/10.24373/pdsp-708