Chapter 9

Step 4

Step 4

Create time-dependent variables Create time windows of exposure

D3_Total_study_population

Study population with entry and exit dates, date of birth, gender, dates and type of vaccinations

D3_study_population_by_dose

This is a time-dependent dataset, reporting status of vaccination in periods of time: each person is observed as many times as the vaccines they have received + the time since baseline. Moreover, date of first covid infection ever is stored

D3_study_population_by_window_and_dose

Time period after each dose (each week, from 1 to 4)

D3_study_population_SCRI

Contains the baseline characteristics of the study population, for the cohort study

D3_study_population_cohort

Contains the baseline characteristics of the study population, for the cohort study

D3_TD_variable_condition

Contains the time-dependent evolution of the binary variable condition. Only changes of status are recorded, with date of when the condition changes; the components of the condition last 365 days if they are diagnosis, and 90 days if they are drug proxies; unique spells are created when the algorithm is 1 (if either a dianosis or a drug proxy is active), and the algorithm is reverted to values 0 whenever no component is active

D3_TD_variable_comedication

Contains the time-dependent evolution of the binary variable comedication. Only changes of status are recorded, with date of when the condition changes; a recording of the medication lasts 90 days and the algorithm is reverted to values 0 whenever no drug records active

D3_TD_variable_NUMBER_CONDITIONS

Contains the time-dependent evolution of the ordinal variable NUMBER_CONDITIONS, which counts the number of comorbidities in a list of 9 associated with covid severity (see specifications in the Data Model tab). Only changes of status are recorded, with date of change

Subsections of Step 4

D3_Total_study_population

D3_study_population_by_dose

D3_study_population_by_window_and_dose

D3_study_population_SCRI

D3_study_population_cohort

D3_TD_variable_condition

D3_TD_variable_comedication

D3_TD_variable_NUMBER_CONDITIONS