Evidence map›Paper›PMID 33973865›Full record

ArticleJMIR medical informatics2021

Transforming a Patient Registry Into a Customized Data Set for the Advanced Statistical Analysis of Health Risk Factors and for Medication-Related Hospitalization Research: Retrospective Hospital Patient Registry Study.

Zhivko Taushanov, Henk Verloo, Boris Wernli, Saviana Di Giovanni, Armin von Gunten, Filipa Pereira

Open access · goldAbstract read
In one paragraph

Article in JMIR medical informatics, 2021. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 6 papers.

0numbers the graph read from it
0cells of the map it votes in
6citing papers in PubMed
1.5field-weighted citation impact, top 18% of its field
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

6 citing papers in PubMed, 10 citations in OpenAlex.

  1. Article
  2. Article
  3. Article
  4. Article
  5. Article
  6. 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

6 authors at 5 institutions in 2 countries.

Zhivko Taushanov *Faculty of Social and Political Sciences, University of Lausanne, Lausanne, Switzerland.ORCID https://orcid.org/0000-0002-3798-757X
Henk Verloo *School of Health Sciences, HES-SO Valais-Wallis, Sion, Switzerland.ORCID https://orcid.org/0000-0002-5375-3255
Boris Wernli *FORS, Swiss Centre of Expertise in the Social Sciences, University of Lausanne, Lausanne, Switzerland.ORCID https://orcid.org/0000-0002-5567-1317
Saviana Di GiovanniSchool of Health Sciences, HES-SO Valais-Wallis, Sion, Switzerland.ORCID https://orcid.org/0000-0001-5082-2780
Armin von GuntenService of Old Age Psychiatry, Lausanne University Hospital, Lausanne, Switzerland.ORCID https://orcid.org/0000-0001-7852-3803
Filipa PereiraSchool of Health Sciences, HES-SO Valais-Wallis, Sion, Switzerland.ORCID https://orcid.org/0000-0001-9207-4856
HES-SO Valais-Wallis · CHFORS – Swiss Centre of Expertise in the Social Sciences · CHUniversidade do Porto · PTUniversity of Geneva · CHUniversity of Lausanne · CH

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

backgroundHospital patient registries provide substantial longitudinal data sets describing the clinical and medical health statuses of inpatients and their pharmacological prescriptions. Despite the multiple advantages of routinely collecting multidimensional longitudinal data, those data sets are rarely suitable for advanced statistical analysis and they require customization and synthesis.

objectiveThe aim of this study was to describe the methods used to transform and synthesize a raw, multidimensional, hospital patient registry data set into an exploitable database for the further investigation of risk profiles and predictive and survival health outcomes among polymorbid, polymedicated, older inpatients in relation to their medicine prescriptions at hospital discharge.

methodsA raw, multidimensional data set from a public hospital was extracted from the hospital registry in a CSV (.csv) file and imported into the R statistical package for cleaning, customization, and synthesis. Patients fulfilling the criteria for inclusion were home-dwelling, polymedicated, older adults with multiple chronic conditions aged ≥65 who became hospitalized. The patient data set covered 140 variables from 20,422 hospitalizations of polymedicated, home-dwelling older adults from 2015 to 2018. Each variable, according to type, was explored and computed to describe distributions, missing values, and associations. Different clustering methods, expert opinion, recoding, and missing-value techniques were used to customize and synthesize these multidimensional data sets.

resultsSociodemographic data showed no missing values. Average age, hospital length of stay, and frequency of hospitalization were computed. Discharge details were recoded and summarized. Clinical data were cleaned up and best practices for managing missing values were applied. Seven clusters of medical diagnoses, surgical interventions, somatic, cognitive, and medicines data were extracted using empirical and statistical best practices, with each presenting the health status of the patients included in it as accurately as possible. Medical, comorbidity, and drug data were recoded and summarized.

conclusionsA cleaner, better-structured data set was obtained, combining empirical and best-practice statistical approaches. The overall strategy delivered an exploitable, population-based database suitable for an advanced analysis of the descriptive, predictive, and survival statistics relating to polymedicated, home-dwelling older adults admitted as inpatients. More research is needed to develop best practices for customizing and synthesizing large, multidimensional, population-based registries. INTERNATIONAL REGISTERED REPORT IDENTIFIER (IRRID): RR2-10.1136/bmjopen-2019-030030.

Indexed as

cluster analysishierarchical 2-step clusteringhospitalmultidimensionalpopulation basedraw dataregistryretrospective

Identifiers

PMID33973865
PMCPMC8150425
OpenAlexW3147447916

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.