Table 1 Description of data. Absolute and relative frequencies and mean, standard deviation, median and interquartile range (Q1 - Q3), minimum and maximum of the observed/predicted variables of the EHR data, occupancy data, matched, unmatched EHR and unmatched occupancy data sets are given, respectively. In case the predicted variables are described, boxes indicate the model and data set used (– - – - –: predictions made on the basis of model of Sect. 2.3.2 and 2.3.1 modelling relationships 2 (patient-occupancy ratio when occupancy data is given) and 1 (disease incidence); -----: predictions made on the basis of model of Sect. 2.3.2 modelling relationship 2 (patient-occupancy ratio when occupancy data is given); \(\cdot\cdot\cdot\cdot\cdot\cdot\cdot\): predictions made on the basis of model of Sect. 2.3.3 modelling relationship 3 (patient-occupancy ratio when patient data is given)). In the Tables of Appendix A.1, the description is done stratified for the type of centre
Variables | EHR | occupancy data | matched | EHR unmatched | occupancy unmatched |
|---|---|---|---|---|---|
(N = 445) | (N = 215) | (N = 147) | (N = 270) | (N = 40) | |
Centre | |||||
1 | 22 (5%) | 5 (2%) | 3 (2%) | 19 (7%) | 2 (5%) |
2 | 6 (1%) | 8 (4%) | 2 (1%) | 1 (0%) | 3 (8%) |
3 | 0 (0%) | 1 (0%) | 0 (0%) | 0 (0%) | 1 (2%) |
4 | 37 (8%) | 17 (8%) | 11 (7%) | 21 (8%) | 1 (2%) |
5 | 22 (5%) | 13 (6%) | 13 (9%) | 9 (3%) | 0 (0%) |
6 | 32 (7%) | 19 (9%) | 15 (10%) | 15 (6%) | 2 (5%) |
7 | 38 (9%) | 33 (15%) | 27 (18%) | 8 (3%) | 3 (8%) |
8 | 7 (2%) | 1 (0%) | 1 (1%) | 6 (2%) | 0 (0%) |
9 | 23 (5%) | 14 (7%) | 5 (3%) | 10 (4%) | 1 (2%) |
10 | 19 (4%) | 14 (7%) | 7 (5%) | 12 (4%) | 7 (18%) |
11 | 27 (6%) | 14 (7%) | 13 (9%) | 14 (5%) | 1 (2%) |
12 | 16 (4%) | 0 (0%) | 0 (0%) | 16 (6%) | 0 (0%) |
13 | 27 (6%) | 14 (7%) | 9 (6%) | 16 (6%) | 3 (8%) |
14 | 16 (4%) | 17 (8%) | 9 (6%) | 7 (3%) | 8 (20%) |
15 | 17 (4%) | 12 (6%) | 11 (7%) | 6 (2%) | 1 (2%) |
16 | 0 (0%) | 1 (0%) | 0 (0%) | 0 (0%) | 1 (2%) |
17 | 25 (6%) | 18 (8%) | 16 (11%) | 9 (3%) | 2 (5%) |
18 | 16 (4%) | 4 (2%) | 4 (3%) | 12 (4%) | 0 (0%) |
19 | 22 (5%) | 2 (1%) | 1 (1%) | 21 (8%) | 1 (2%) |
20 | 44 (10%) | 0 (0%) | 0 (0%) | 44 (16%) | 0 (0%) |
21 | 6 (1%) | 8 (4%) | 0 (0%) | 1 (0%) | 3 (8%) |
22 | 5 (1%) | 0 (0%) | 0 (0%) | 5 (2%) | 0 (0%) |
23 | 18 (4%) | 0 (0%) | 0 (0%) | 18 (7%) | 0 (0%) |
type of centre | |||||
REC | 345 (78%) | 137 (64%) | 104 (71%) | 234 (87%) | 26 (65%) |
REG | 100 (22%) | 78 (36%) | 43 (29%) | 36 (13%) | 14 (35%) |
Male | |||||
N | 445 | 215 | 147 | 270 | 40 |
mean | 60 | 66 | 60 | 59 | 69 |
sd | 14 | 14 | 13 | 14 | 17 |
median | 60 | 65 | 58 | 60 | 65 |
Q1 - Q3 | 54–68 | 59–74 | 52–69 | 54–67 | 61–72 |
min - max | 0–100 | 24–98 | 23–90 | 0–100 | 24–98 |
Adult | |||||
N | 445 | 215 | 147 | 270 | 40 |
mean | 80 | 77 | 80 | 80 | 78 |
sd | 10 | 10 | 10 | 11 | 13 |
median | 81 | 77 | 81 | 81 | 75 |
Q1 - Q3 | 74–87 | 70–84 | 72–87 | 75–86 | 69–86 |
min - max | 0–100 | 54–114 | 48–100 | 0–100 | 58–100 |
diseases of the digestive system | |– - – - – - – - – - – - | ||||
N | 445 | 0 | 147 | 270 | 24 |
Nmiss | 0 (0%) | 215 (100%) | 0 (0%) | 0 (0%) | 16 (40%) |
mean | 23 | NA | 21 | 23 | 17 |
sd | 23 | NA | 23 | 24 | 7.2 |
median | 12 | NA | 11 | 12 | 15 |
Q1 - Q3 | 5–35 | NA -- NA | 5–31 | 5–37 | 12–19 |
min - max | 0–89 | NA -- NA | 0–83 | 0–89 | 6.6–40 |
n_pat | – - – - – -|/|------------ | ||||
N | 445 | 0 | 147 | 270 | 40 |
Nmiss | 0 (0%) | 215 (100%) | 0 (0%) | 0 (0%) | 0 (0%) |
mean | 230 | NA | 212 | 233 | 153 |
sd | 202 | NA | 195 | 208 | 121 |
median | 149 | NA | 127 | 150 | 118 |
Q1 - Q3 | 93–304 | NA -- NA | 95–227 | 85–316 | 95–169 |
min - max | 5–934 | NA -- NA | 29–934 | 5–934 | 25–552 |
n_occup | |················· | -----------------------| | |||
N | 0 | 215 | 147 | 270 | 40 |
Nmiss | 445 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) |
mean | NA | 348 | 394 | 448 | 263 |
sd | NA | 287 | 312 | 394 | 209 |
median | NA | 244 | 266 | 286 | 210 |
Q1 - Q3 | NA -- NA | 164–449 | 193–503 | 182–583 | 130–296 |
min - max | NA -- NA | 32–1516 | 32–1516 | 14–1821 | 56–958 |
Incidence of diseases of the digestive system with respect to patients | ·················| | |– - – - – - – - – - – - | |||
N | 445 | 0 | 147 | 270 | 24 |
Nmiss | 0 (0%) | 215 (100%) | 0 (0%) | 0 (0%) | 16 (40%) |
mean | 0.092 | NA | 0.088 | 0.096 | 0.12 |
sd | 0.059 | NA | 0.051 | 0.064 | 0.029 |
median | 0.092 | NA | 0.094 | 0.092 | 0.12 |
Q1 - Q3 | 0.056–0.12 | NA -- NA | 0.054–0.12 | 0.057–0.13 | 0.099–0.14 |
min - max | 0–0.3 | NA -- NA | 0–0.23 | 0–0.3 | 0.081–0.19 |
Incidence of diseases of the digestive system with respect to occupancy | |················· | – - – - – - – - – - – - | |||
N | 0 | 0 | 147 | 270 | 24 |
Nmiss | 445 (100%) | 215 (100%) | 0 (0%) | 0 (0%) | 16 (40%) |
mean | NA | NA | 0.047 | 0.048 | 0.074 |
sd | NA | NA | 0.032 | 0.033 | 0.027 |
median | NA | NA | 0.043 | 0.045 | 0.073 |
Q1 - Q3 | NA -- NA | NA -- NA | 0.023–0.069 | 0.027–0.068 | 0.051–0.091 |
min - max | NA -- NA | NA -- NA | 0–0.14 | 0–0.16 | 0.037–0.13 |
ratio = n_pat/n_occup | ················· | – - – - – -|/|------------ | |||
N | 0 | 0 | 147 | 270 | 40 |
Nmiss | 445 (100%) | 215 (100%) | 0 (0%) | 0 (0%) | 0 (0%) |
mean | NA | NA | 0.54 | 0.51 | 0.6 |
sd | NA | NA | 0.19 | 0.083 | 0.14 |
median | NA | NA | 0.5 | 0.5 | 0.59 |
Q1 - Q3 | NA -- NA | NA -- NA | 0.39–0.69 | 0.47–0.53 | 0.49–0.67 |
min - max | NA -- NA | NA -- NA | 0.13–0.99 | 0.23–0.77 | 0.38–0.91 |
················· | |-----------------------| |