Evidence map›Paper›PMID 37359950›Full record

ArticleJAMIA open2023

Research data warehouse: using electronic health records to conduct population-based observational studies.

Wansu Chen, Fagen Xie, Don P Mccarthy, Kristi L Reynolds, Mingsum Lee, Karen J Coleman, Darios Getahun, Corinna Koebnick, Steve J Jacobsen

Abstract read
In one paragraph

Article in JAMIA open, 2023. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 23 papers.

0numbers the graph read from it
0cells of the map it votes in
23citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

23 citing papers in PubMed.

  1. Article
  2. Asthma Burden in Mild Adult Asthma in the PEARL Survey: Asthma Control and Health Status.The journal of allergy and clinical immunology. In practice · 2026
    Article
  3. Article
  4. Article
  5. Article
  6. Symptom patterns before and after indolent systemic mastocytosis: A matched cohort analysis.The journal of allergy and clinical immunology. Global · 2026
    Article
  7. Article
  8. Article
  9. Article
  10. Article
  11. Article
  12. Article
  13. Impact of the Advent of CollagenaseThe Permanente journal · 2025
    Article
  14. Article
  15. Article
  16. Neighborhood Deprivation and Crime on Asthma Exacerbations and Utilization in Mild Adult Asthma.The journal of allergy and clinical immunology. In practice · 2024
    Article
  17. MASTering systemic mastocytosis: Lessons learned from a large patient cohort.The journal of allergy and clinical immunology. Global · 2024
    Article
  18. Article
  19. Risk Factors for Acute Asthma Exacerbations in Adults With Mild Asthma.The journal of allergy and clinical immunology. In practice · 2024
    Article
  20. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

9 authors.

Wansu ChenDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.
Fagen XieDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.
Don P MccarthyDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.
Kristi L ReynoldsDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.ORCID https://orcid.org/0000-0001-7619-1649
Mingsum LeeDepartment of Cardiology, Los Angeles Medical Center, Southern California Permanente Medical Group, Los Angeles, California, USA.
Karen J ColemanDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.
Darios GetahunDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.
Corinna KoebnickDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.ORCID https://orcid.org/0000-0001-8274-0309
Steve J JacobsenDepartment of Research and Evaluation, Kaiser Permanente Southern California, Pasadena, California, USA.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

Background: Electronic health records and many legacy systems contain rich longitudinal data that can be used for research; however, they typically are not readily available. Materials and methods: At Kaiser Permanente Southern California (KPSC), a research data warehouse (RDW) has been developed and maintained since the late 1990s and widely extended in 2006, aggregating and standardizing data collected from internal and a few external sources. This article provides a high-level overview of the RDW and discusses challenges common to data warehouses or repositories for research use. To demonstrate the application of the data, we report the volume, patient characteristics, and age-adjusted prevalence of selected medical conditions and utilization rates of selected medical procedures. Results: A total of 105 million person-years of health plan enrollment was recorded in the RDW between 1981 and 2018, with most healthcare utilization data available since early or middle 1990s. Among active enrollees on December 31, 2018, 15% were ≥65 years of age, 33.9% were non-Hispanic white, 43.3% Hispanic, 11.0% Asian, and 8.4% African American, and 34.4% of children (2-17 years old) and 72.1% of adults (≥18 years old) were overweight or obese. The age-adjusted prevalence of asthma, atrial fibrillation, diabetes mellitus, hypercholesteremia, and hypertension increased between 2001 and 2018. Hospitalization and Emergency Department (ED) visit rates appeared lower, and office visit rates seemed higher at KPSC compared to the reported US averages. Discussion and conclusion: Although the RDW is unique to KPSC, its methodologies and experience may provide useful insights for researchers of other healthcare systems worldwide in the era of big data analysis.

Indexed as

chronic disease prevalencedata qualityelectronic health recordhealth care utilizationintegrationresearch data warehousestandardization

Identifiers

PMID37359950
PMCPMC10284679

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.