| patient_num | start_date | ICD10 | domain |
| num | date (y-m-d h:m:s) | char | char |
2 Non-ENACT
2.1 Data preparation process
The data preparation process is as follows:
- Query the case data set – include all patients with a positive lab test or a COVID diagnosis starting in 01-01-2017.
- Query patient demographics data – include sex, age, race, ethnicity and CHARLSON_INDEX.
2.2 Table example
Tables we need should have these columns:
Patient data (should be saved as cases.csv)
Demographic data (should be saved as dems_cases.csv)
| patient_num | age | sex_cd | race_cd | ethnicity_cd | CHARLSON_INDEX |
| num | num | char (F/M) | char | char | num |
2.3 Directory guide
Recommended directory tree on the server/device where docker is running in the next step:
- PASC
- data
- cases.csv
- dems_cases.csv
- output
- data