Facts Over Time


Created

Last Modified

Click on the thumbnail above to preview images.

Domain

Category

Parameters

Publisher

PEDSnet

Abstract

A network data quality check which computes different clinical facts over a range of time, as defined by the user. The check can examine facts by month or by year, and row, patient, and visit counts are able to be computed.

Results of this check for the current data cycle can be explored on the PEDSnet Data Quality Dashboard. Data quality results for previous data cycles have been archived in the Facts Over Time Network Results collection.

Probe

Clinical Assessment

Access Package

Visualization Output

NOTE: The visualizations are NOT part of the packaged code. This description applies to the visualizations available on the PEDSnet Data Quality Dashboard.

There are two different types of line plots included for this module. The first is a smoothed line graph with a Loess regression applied, displaying the rate of records per 10,000 visits across time. The second displays the raw row count (shown on the left Y axis) compared to a normalized row count (shown on the right Y axis). We applied normalization using the following heuristic: (current month)/((month-1).25+(month+1).25+(month-12)*.5). In plain words, it is the current month divided by the weighted average of the previous month, the next month, and the value from the current month in the previous year.

Raw Output

This check produces a raw data output containing 11 columns of data:

Column Data Type Definition
row_cts numeric the number of rows for that year and domain
row_visits numeric the number of visits for that year and domain
row_pts numeric the number of patients for that year and domain
site character the name of the site being targeted
database_version character the database version from which the counts originated
check_type character a short string identifier for the module
check_name character a short string identifier for the check
check_desc character the fact type being evaluated
domain character the table from which the fact type originated
time_end date the end date of the time period being evaluated
time_start date the start date of the time period being evaluated

Funder(s)

Provenance

Description

Clinical Subjects Headings

Related Data Quality Result

Related Person

Related Code

Network Data Quality
Created:2025-09Affiliation:PEDSnet Data Coordinating Center
The [Network Data Quality (NDQ)](https://pedsnet.github.io/ndq/) package contains several data quality modules intended to evaluate the overall condition of the data in a clinical research network. These modules, which cover a broad range of data quality domains from conformance to plausibility, are flexible and can be configured to execute checks specific to desired use cases in both the OMOP and PCORnet common data models (CDMs).

##### [View pkgdown summary here.](https://pedsnet.github.io/ndq/)
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

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. & Dickinson, K. (2023, December). Facts Over Time. [D Q Check]. PEDSpace Knowledge Bank. https://doi.org/10.24373/pdsp-481