opensafely / tpp-sql-notebook

2 stars 0 forks source link

*DISEASE* Heart Failure #80

Open annaschultze opened 4 years ago

annaschultze commented 4 years ago

Subset of #7 including only HF codes.

annaschultze commented 4 years ago

I'm going to extract from this file - if @laurietomlinson can check for clinical sign off and @CarolineMorton confirm we are getting the process right...? CVD_CTV3_REVIEWED.xlsx

annaschultze commented 4 years ago

Draft code list attached. I pulled all codes marked "Heart Failure", I then searched for "Failure" in the other conditions and found a single additional code "heart&renal dis wth (congestive) heart failure", marked "other heart disease" which I added in.

HF_CTV3.xlsx @laurietomlinson if you can check and then sign off?

annaschultze commented 4 years ago

DRAFT SIGN OFF

DEFINITION: Patients who have any heart failure Read 3 code ever on their medical records held by TPP. Absence of a code on the record is taken as no presence of disease.

patient_id hf_bin condition date
123 1 H/O: heart failure 1/2/2009
332 1 Hypertensive heart&renal dis wth (congestive) heart failure 12/1/2015

CODE LISTS: [Enter when checked]

Created as a subset of codelist #7 by:

  1. Selecting codes marked "Heart Failure" as reason for inclusion
  2. Selecting codes containing the term "Failure"

FLEXIBILITY NEEDED BETWEEN STUDIES: Not anticipated.

EFFECTS ON COHORT SELECTION: Patients must have been registered for at least 12 months before the index date, in order to allow for recording of disease codes.

POTENTIAL BIASES: HF suspected to be somewhat inaccurately diagnosed, and may be better identified using combinations of diagnostic codes and treatment.

CLINICAL SIGN OFF & DATE:

EPIDEMIOLOGY SIGN OFF & DATE:

SHARED WITH WIDER TEAM:

FINAL SIGN OFF DATE (and apply label):

laurietomlinson commented 4 years ago

My review of the code list. I am worried that some may have not been picked up. Is there any cor pulmonale remaining on the IHD list. Would you like me to check the IHD one too @annaschultze ?

HF_CTV3_LT.xlsx

annaschultze commented 4 years ago

Yes please! They should be in the original list in the second comment. You'll need to make sure all terms are selected as some are filtered out, but I can see some cor pulmonle in there... Not as simple as I thought perhaps..

laurietomlinson commented 4 years ago

I have been back through the original list and redefined heart failulre codes and also flagged those specific to right heart failure. Hope this is ok @annaschultze CVD_CTV3_REVIEWED_LT.xlsx

annaschultze commented 4 years ago

Thanks @laurietomlinson! I've created a clean version of this for sign off and will post in a second. To note, I cross-referenced this with the final chronic heart disease list and excluded codes that were not in this - specifically those that were not specific to the heart (see below). Please flag if you disagree.

image

annaschultze commented 4 years ago

Finalised code list attached here.

DEFINITION: Any record of Heart Failure ever in existing patient history. Absence of a code is taken as absence of HF

Example Output:

patient_id code hf date
123 H/O: heart failure 1 1/2/2009
332 Rheumatic left ventricular failure 1 2/4/2016

CODE LISTS: HF_CTV3_FINAL.xlsx

This was created as a subset of #7 by:

  1. Selecting codes marked "Heart Failure" as reason for inclusion
  2. Selecting codes containing the term "Failure"
  3. Clinical review of the entire list to add in codes potentially missed.

FLEXIBILITY NEEDED BETWEEN STUDIES: None.

EFFECTS ON COHORT SELECTION: None.

POTENTIAL BIASES: HF suspected to be somewhat inaccurately diagnosed, and may be better identified using combinations of diagnostic codes and treatment.

CLINICAL SIGN OFF & DATE:

EPIDEMIOLOGY SIGN OFF & DATE: @annaschultze 28/04/2020 10:59

SHARED WITH WIDER TEAM:

FINAL SIGN OFF DATE (and apply label):

laurietomlinson commented 4 years ago

Thanks @laurietomlinson! I've created a clean version of this for sign off and will post in a second. To note, I cross-referenced this with the final chronic heart disease list and excluded codes that were not in this - specifically those that were not specific to the heart (see below). Please flag if you disagree.

image

Hi @annaschultze Not sure what you mean here - whether they were in or out. Pulmonary oedema is basically what happens when your left ventricle fails so should be specific to heart failure. Will check later to see where you put these ones

laurietomlinson commented 4 years ago

Hi @annaschultze I think there is an error here. The codes I had intended to use are in column G (Confirmed 1/0 LT) in file CVD_CTV3_REVIEWED_LT.xlsx The list HF_CTV3_FINAL.xlsx included codes that I had excluded. Do you want to check? Sorry if I wasn't clear

annaschultze commented 4 years ago

You're right - I'd extracted indicators from the wrong column. Very sorry. I'll update and repost.

annaschultze commented 4 years ago

Finalised code list attached here.

DEFINITION: Any record of Heart Failure ever in existing patient history. Absence of a code is taken as absence of HF.

Example Output:

patient_id code hf date
123 H/O: heart failure 1 1/2/2009
332 Rheumatic left ventricular failure 1 2/4/2016

CODE LISTS: HF_CTV3_FINAL_v1.1.xlsx

This was created as a subset of #7 by:

  1. Selecting codes marked "Heart Failure" as reason for inclusion
  2. Selecting codes containing the term "Failure"
  3. Clinical review of the entire list to add in codes potentially missed (cor pulmonale, acute pulmonary oedemas)

Note that the list includes acute pulmonary oedemas, but not chronic pulmonary oedema as this may be indicative of other conditions. This also ensures the list is a true subset of the CHD list.

FLEXIBILITY NEEDED BETWEEN STUDIES: None.

EFFECTS ON COHORT SELECTION: None.

POTENTIAL BIASES: HF suspected to be somewhat inaccurately diagnosed, and may be better identified using combinations of diagnostic codes and treatment.

CLINICAL SIGN OFF & DATE: Laurie Tomlinson @laurietomlinson 30/04/2020

EPIDEMIOLOGY SIGN OFF & DATE: @annaschultze 30/4/2020 10:06

SHARED WITH WIDER TEAM:

FINAL SIGN OFF DATE (and apply label): 04/5/2020 14:58