ABCDEFG
1
Field nameTypeCategorySub-categoryDescription
Date of addition of field to schema
Date of removal of field from schema
2
batch_dateDate--Date when they entry was extracted from the data warehouse.4.14
3
test_nameStringOutpatient FacilitiesName of the COVID-19 test, used to infer its sensitivity and specificity.4.07
4
swab_typeString (Nasopharyngeal, Oropharyngeal, Nasal)COVID-19 test sample collection area.4.14
5
covid19_test_resultsString (Positive, Negative)COVID-19 test results.4.07
6
ageIntEpidemiological FactorsNoise-added patient age.4.07
7
high_risk_exposure_occupation
BooleanWhether patient in a profession with a high risk of exposure.4.07
8
high_risk_interactionsBooleanWhether patient may have been exposed through contact with a known infected person.4.07
9
diabetesBooleanComorbiditiesWhether patient has diabetes.4.07
10
chdBooleanWhether patient has coronary heart disease.4.07
11
htnBooleanWhether patient has hypertension.4.07
12
cancerBooleanWhether patient has cancer.4.07
13
asthmaBooleanWhethe patient has asthma.4.07
14
copdBooleanWhether patient has chronic obstructive pulmonary disease.4.07
15
autoimmune_disBooleanWhether patient has an autoimmune disease.4.07
16
smokerBooleanWhether patient is a smoker.5.05
17
temperatureFloatVitals°C4.07
18
pulseIntHeart rate measured as the number of heartbeats per minute (bpm).4.07
19
sysIntSystolic blood pressure measured in units of millimeters of mercury (mmHg).4.07
20
diaIntDiastolic blood pressure measured in units of millimeters of mercury (mmHg).4.07
21
rrIntRespiratory rate measured in breaths per minute.4.07
22
satsIntOxygen saturation (cka "sat") measured as the percentage of hemoglobin binding sites in the bloodstream occupied by oxygen.4.07
23
rapid_flu_resultsString (Positive, Negative)Lab ResultsRapid flu test result if administered.4.07
24
rapid_strep_resultsString (Positive, Negative)Rapid strep test result if administered.4.07
25
ctabBooleanClinician Assessed SymptomsWhether the lung exam is normal, that is, lungs clear to auscultation bilaterally.4.07
26
labored_respirationBooleanWhether patient is experiencing abnormal respiration characterized by increased effort to breathe.4.07
27
rhonchiBooleanWhether patient is experiencing rhonchi, which is a coarse rattling sound like snoring, usually caused by secretion in a bronchial tube.4.07
28
wheezesBooleanWhether patient is experiencing wheezing, which is a high-pitched whistling sound made while breathing.4.07
29
days_since_symptom_onsetIntPatient Reported SymptomsPatient reported days from symptom onset.4.21
30
coughBooleanWhether patient has cough symptoms.4.07
31
cough_severityString (Mild, Moderate, Severe)Severity of cough as reported by patient4.07
32
feverBooleanWhether patient has fever.4.07
33
sobBooleanWhether patient has shortness of breath.4.07
34
sob_severityString (Mild, Moderate, Severe)Severity of shortness of breath.4.07
35
diarrheaBooleanWhether patient has diarrhea.4.07
36
fatigueBooleanWhether patient is experiencing fatigue.4.07
37
headacheBooleanWhether patient is experiencing a headache.4.07
38
loss_of_smellBooleanWhether patient is experiencing loss of smell.4.07
39
loss_of_tasteBooleanWhether patient is experiencing loss of taste.4.07
40
runny_noseBooleanWhether patient has a running nose.4.07
41
muscle_soreBooleanWhether patient has sore muscles.4.07
42
sore_throatBooleanWhether patient has a sore throat.4.07
43
cxr_findingsStringRadiological FindingsObservations about the lungs and chest as seen on the chest radiograph.4.07
44
cxr_impressionStringSummary of the clinically relevant chest radiograph finding(s).4.07
45
cxr_labelString (Negative, Significant, Critical)Categorized label based on cxr_impression.5.12
46
cxr_linkString (url)Link to the dagnostic quality radiology images, with annotations and report.4.07
47
er_referralBooleanInitial DispoWhether patient was referred to ER (true), or sent home (false).4.148.18
48
WBCIntInpatient FacilitiesExtended Laboratory Results

White blood cell count (per mcL).4.07
49
HgbInt
Hemoglobin concentration (per mcL).
4.07
50
PltIntPlatelet count (per mcL).4.07
51
NaFloatBlood sodium levels measured in mEq/L.4.07
52
KFloatBlood potassium levels measured in mEq/L.4.07
53
ClFloatBlood chloride levels measured in mEq/L.4.07
54
CO2FloatBlood CO2 levels measured in mEq/L.4.07
55
BUNFloatBlood Urea Nitrogen measured in mg/dL.4.07
56
CrFloatCreatinine levels measured in mg/dL.4.07
57
TroponinFloatTroponin levels measured in ng/ML.4.07
58
D-dimerFloatD-dimer levels measured in ng/mL.4.07
59
FerritinFloatBlood ferritin levels measured in ng/mL used to measure iron deficiency, it is also an acute phase reactant4.07
60
Pro-calcitoninFloatPCT levels measured in ng/mL used for the diagnosis of sepsis or other serious bacterial infections.4.14
61
INRFloatInternational normalized ratio.4.14
62
BNPFloatB-type natriuretic peptide levels measured in pg/mL.4.14
63
FibrinogenFloatFibrinogen levels in blood plasma (mg/dL).4.14
64
GlucFloatBlood glucose concentration, measured in mmol/L.4.07
65
A1CFloatPercentage of glycated hemoglobin.4.07
66
CRPFloatConcentration of C reactive protein in blood plasma (mg/L).4.07
67
HCQBooleanMedications AdministeredWhether hydroxychloroquine was administered.4.07
68
chloroquineBooleanWhether chloroquine was administered.4.07
69
azithromycinBooleanWhether the antibiotic drug azithromycin was administered.4.07
70
remdesivirBooleanWhether remdesivir was administered.4.07
71
lopinavir/ritonavirBooleanWhether the combination of lopinavir and ritonavir were administered.4.07
72
tocilizumabBooleanWhether tocilizumab, aka atlizumab was administered.4.07
73
ACEiBooleanMedications Prior to PresentationWhether patient was taking any "ACE inhibitor" medication class prior to presentation.4.14
74
statinBooleanWhether patient was taking any "statin" medication class prior to presentation.4.14
75
admitted_to_icuBooleanTreatment / CourseWhether patient has been admitted to the ICU.4.07
76
mech_ventilationBooleanWhether mechanical ventilation was used.4.07
77
ECMOBooleanWhether an extracorporeal membrane oxygenation machine was used.4.07
78
LOSIntLength of stay in days, subtract day of admission from the day of discharge.4.07
79
ARDSBooleanComplicationsWhether patient is diagnosed with acute respiratory distress syndrome.4.07
80
shockBooleanWhether patient is diagnosed with shock, an acute circulatory failure.4.07
81
acute_kidney_injuryBooleanWhether patient is diagnosed with acute kidney injury.4.07
82
secondary_pneumoniaBooleanWhether patient is diagnosed with secondary bacterial pneumonia, following an initial presentation of viral pneumonia.4.07
83
recoveryBooleanFinal DispoWhether patient survived to discharge (excluding patients discharged to hospice).4.07
84
deathBooleanWhether patient died while in hospital, or was sent to hospice care.4.07