search

opensafely / tpp-sql-notebook

2 stars 0 forks source link

*Outcome* ONS Data #73

Open CarolineMorton opened 4 years ago

sebbacon commented 4 years ago

This is deaths of any cause.

Desired outcome variables:

  1. Date of death
  2. Boolean, indicating covid-code-anywhere-in-icd-codes

Example row in table ONS_Deaths:


Patient_ID         10007
sex                    2
ageinyrs              99
dod           2020-02-01
icd10u              X590
ICD10001            J189
ICD10002            R688
ICD10003             R54
ICD10004            S720
ICD10005            X590
ICD10006            M259
ICD10007            Z966
ICD10008             I10
ICD10009            E210
ICD10010            None
ICD10011            None
ICD10012            None
ICD10013            None
ICD10014            None
ICD10015            None

CLINICAL SIGN OFF & DATE: Caroline Morton @CarolineMorton 20/4/2020 14:46

EPIDEMIOLOGY SIGN OFF & DATE: Alex Walker @alexwalkercebm 20/04/2020 14:15

SHARED WITH WIDER TEAM: Yes

FINAL SIGN OFF DATE (and apply label)