Enhancement: COMORBIDITY table in CORE "pairs two FHIR Conditions recorded for the same patient"

[comorbidity]

Studies of many kinds benefit from knowing the most frequent "comorbidities", defined as two FHIR conditions in the same patient during an interval of time.

Existing examples:

• https://github.com/smart-on-fhir/cumulus-library-suicidality-los/blob/main/cumulus_library_suicidality_los/suicide_los/table_comorbidity.sql
• https://github.com/smart-on-fhir/cumulus-library-hypertension/blob/025bdaefb9c0dd40d6362153a0ca36123df7f9d1/cumulus_library_hypertension/htn/table_comorbidity.sql

CORE should support support comorbidity three intervals

• patient lifetime (Two FHIR conditions recorded during ANY encounters)
• same encounter (Two FHIR conditions recorded in the same encounter)
• HPI History of Present Illness (Two FHIR Conditions in the patient history including the present encounter but not future encounters)

[comorbidity]

Joke of the day: With a username like @comorbidity would be strange for me to not assign this ticket to myself.
These are the jokes, and they aren't good :)

[dogversioning]

Food for thought: what about a template to spit out a comorbidity table?

Here's my reasoning:

• these tables all have study specific dependencies
• this is not a US Core concept

Joke of the day: With a username like @comorbidity would be strange for me to not assign this ticket to myself. These are the jokes, and they aren't good :)

oofa doofa