Estimating disease prevalence using a population-based administrative healthcare database

• Published in: Scandinavian journal of public health Vol. 35; no. 4; pp. 424 - 431
• Main Authors: WIRÉHN, ANN-BRITT E., KARLSSON, H. MIKAEL, CARSTENSEN, JOHN M.
• Format: Journal Article
• Language: English
• Published: London, England Taylor & Francis 01.01.2007; Sage Publications; Sage
• Subjects: Adult; Aged; Asthma; Asthma - epidemiology; Biological and medical sciences; Chronic Disease; Chronic diseases; Chronic obstructive pulmonary disease, asthma; COPD; Databases, Factual; diabetes mellitus; Diabetes Mellitus - epidemiology; Epidemiologic Methods; Epidemiology; Female; General aspects; healthcare; Humans; hypertension; Hypertension - epidemiology; inpatients; Inpatients - statistics & numerical data; Male; Medical sciences; MEDICIN; MEDICINE; Middle Aged; Miscellaneous; Outpatients - statistics & numerical data; Patient Discharge - statistics & numerical data; Pneumology; Prevalence; Primary health care; Primary Health Care - statistics & numerical data; primary outpatients; Public health. Hygiene; Public health. Hygiene-occupational medicine; Pulmonary Disease, Chronic Obstructive - epidemiology; Registries; STUDY DESIGN ARTICLES; Sweden; Sweden - epidemiology; Sweden; epidemiology; prevalence; inpatients; primary outpatients; diabetes mellitus; registries; hypertension; Asthma; COPD; healthcare; Endocrinopathy; Prevalence; Disease; Administrative data; Cardiovascular disease; Epidemiology; Bronchus disease; Population; Chronic obstructive pulmonary disease; Obstructive pulmonary disease; Ambulatory; Hospital; Public health; Human; Hypertension; Lung disease; Respiratory disease; Diabetes mellitus; Estimation; Patient; Hospitalization; Care; Register
• ISSN: 1403-4948; 1651-1905; 1651-1905
• DOI: 10.1080/14034940701195230

Aims: In Östergötland County, Sweden, all data on hospital care and primary healthcare (PHC) have been entered in a diagnosis-related administrative database since 1999. This database was used to estimate the prevalence of four chronic diseases and to examine the capture of data in PHC, outpatient hospital care, and inpatient hospital care, considered in different time frames. Methods: A case-finding algorithm identified patients with at least one healthcare contact involving a diagnosis of diabetes, hypertension, asthma, or chronic obstructive pulmonary disease (COPD) in 1999-2003. Prevalence rates were calculated as the ratio of the number of identified patients alive to the total number of inhabitants on 31 December 2003 (n≈415,000). Results: Prevalence rates were 4.4% for diabetes, 10.3% for hypertension, 4.5% for asthma, and 1.2% for COPD. For all four diagnoses, the proportions of patients identified on only one healthcare level were greatest for PHC, reaching rates of 23%, 68%, 53%, and 48%, respectively. The cases identified solely in PHC comprised larger proportions of women and patients over the age of 65 years. Considering the proportion of patients identified in 2003 in relation to the total five-year period gave values of 71%, 50%, 38%, and 58%, respectively, for the four diagnoses. Conclusions: The administrative healthcare databases in Sweden today can be important tools in epidemiological research. However, data on several consecutive years and both PHC and hospital data are needed to achieve valid prevalence estimates.