Skip to main content
. Author manuscript; available in PMC: 2020 Sep 1.
Published in final edited form as: J Public Health Manag Pract. 2019 Sep-Oct;25(5):498–507. doi: 10.1097/PHH.0000000000000810

Table 1.

Types of electronic health record data* in the Colorado Health Observation Regional Data Service (CHORDS) and their relevance to chronic conditions surveillance, 2017.

Data type Description Relevance Example
Patient demographics Age, gender, race/ethnicity, primary language Examines prevalence, management, and disparities in chronic conditions by individual characteristics What percent of children are diagnosed with asthma?
Geographic location and demographics County and census tract of residence, American Community Survey measures Examines how differences in social and environmental characteristics within a region are associated with chronic conditions How is neighborhood poverty associated with treatment adherence for diabetes?
Encounters Date, and encounter type Examines how frequency and timing of patient visits affect prevention and management of chronic conditions How frequently are adults with depression seen?
Diagnoses and procedures ICD-9/10 diagnosis code, date of diagnosis, procedure type and date Calculates prevalence of diagnosed chronic health conditions and related procedures What percent of adults have been diagnosed with high blood pressure?
Laboratory results Test type, date of test, result Captures undiagnosed chronic conditions and examine screening rates What percent of Denver adults have been tested for hepatitis C virus?
Pharmacy Outpatient prescription orders and dispenses Examines relationship between diagnosis of chronic conditions and pharmaceutical treatment for these conditions What percent of adults with high cholesterol are prescribed cholesterol-lowering medication?
Vital signs Objectively-measured height, weight, blood pressure Adds to diagnostic information to examine relationships of vital signs to chronic condition prevalence What percent of adults are overweight or obese? What percent of adults with hypertension are well controlled?
Social History Self-reported data on tobacco use and exposure, alcohol/drug use Examines the relationship between health behaviors and chronic conditions What percent of children are exposed to second hand smoke?
*

Note: Table is organized to the common data model (CDM); only a portion of the 17 CDM tables are presented here.