Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile

Eisen, Damon P., McBryde, Emma S., Vasanthakumar, Luke, Murray, Matthew, Harings, Miriam, and Adegboye, Oyelola (2020) Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile. BMJ Open, 10. e034845.

[img]
Preview
PDF (Published Version) - Published Version
Available under License Creative Commons Attribution Non-commercial.

Download (2MB) | Preview
View at Publisher Website: https://doi.org/10.1136/bmjopen-2019-034...
 
53


Abstract

Purpose: To design a linked hospital database using administrative and clinical information to describe associations that predict infectious diseases outcomes, including long-term mortality.

Participants: A retrospective cohort of Townsville Hospital inpatients discharged with an International Classification of Diseases and Related Health Problems 10th Revision Australian Modification code for an infectious disease between 1 January 2006 and 31 December 2016 was assembled. This used linked anonymised data from: hospital administrative sources, diagnostic pathology, pharmacy dispensing, public health and the National Death Registry. A Created Study ID was used as the central identifier to provide associations between the cohort patients and the subsets of granular data which were processed into a relational database. A web-based interface was constructed to allow data extraction and evaluation to be performed using editable Structured Query Language.

Findings to date: The database has linked information on 41 367 patients with 378 487 admissions and 1 869 239 diagnostic/procedure codes. Scripts used to create the database contents generated over 24 000 000 database rows from the supplied data. Nearly 15% of the cohort was identified as Aboriginal or Torres Strait Islanders. Invasive staphylococcal, pneumococcal and Group A streptococcal infections and influenza were common in this cohort. The most common comorbidities were smoking (43.95%), diabetes (24.73%), chronic renal disease (17.93%), cancer (16.45%) and chronic pulmonary disease (12.42%). Mortality over the 11-year period was 20%.

Future plans: This complex relational database reutilising hospital information describes a cohort from a single tropical Australian hospital of inpatients with infectious diseases. In future analyses, we plan to explore analyses of risks, clinical outcomes, healthcare costs and antimicrobial side effects in site and organism specific infections.

Item ID: 65429
Item Type: Article (Research - C1)
ISSN: 2044-6055
Copyright Information: © Author(s) (or their employer(s)) 2020. Re-use permitted under CC BY-NC. No commercial re-use. See rights and permissions. Published by BMJ.
Funders: Townsville Hospital and Health Services Study Education Research Trust
Date Deposited: 05 Jan 2021 23:34
FoR Codes: 11 MEDICAL AND HEALTH SCIENCES > 1117 Public Health and Health Services > 111799 Public Health and Health Services not elsewhere classified @ 40%
11 MEDICAL AND HEALTH SCIENCES > 1103 Clinical Sciences > 110309 Infectious Diseases @ 40%
10 TECHNOLOGY > 1005 Communications Technologies > 100504 Data Communications @ 20%
SEO Codes: 92 HEALTH > 9201 Clinical Health (Organs, Diseases and Abnormal Conditions) > 920109 Infectious Diseases @ 100%
Downloads: Total: 53
Last 12 Months: 53
More Statistics

Actions (Repository Staff Only)

Item Control Page Item Control Page