Review data from all countries for internal purposes. NOT FOR CIRCULATION.

(last update: 2022-09-27 10:26:55)

Goal of this analysis is to identify major or patterns of data quality issues:
1. Clear errors: results that are impossible (aka “sanity check”)
2. Outliers unexpected outliers - only select indicators
3. Possible errors: probably unlikely results, depending on assumptions - only select indicators

Number of surveys included in this analysis:
* C19CM data are available for 22 surveys from 18 countries.
* CEHS data are available for 26 surveys from 21 countries.
* COMMUNITY data are available for 19 surveys from 17 countries.

See here for implementation results, including sample size information

See note at the end for data source and where to find files, etc.

1. Clear errors

  • Simply impossible based on the definition of each indicator.
  • Likely caused by code errors. But, if so, it should be consistent across all group/grouplabels within a survey. If it is just one off, code may not be the only source of the error.
  • If country-specific indicators are flagged, they are excluded from this note, since we do not know exact definitions (e.g., xbed_icu in Kenya C19CM Round 2 or later).

1.1 C19CM

1.1.1. Exceeding range (percent and score indicators)

Results: list of surveys that have outside boundary estimates
survey
GHA_R2
KEN_R2
KEN_R3
PER_R1
SUR_R1
Detailed results: list of surveys and indicator estimates that are outside the boundary
survey group grouplabel xcovid_occ_lastnight xpcr_capacity xcovid_occ_lastmonth staff_pct_covaxany staff_pct_covaxfull
GHA_R2 Location Rural NA NA NA 103 103
KEN_R2 All All 2598 NA 3878 NA NA
KEN_R2 Level Level 4 1901 NA 3149 NA NA
KEN_R2 Level Level 5 4417 NA 6343 NA NA
KEN_R2 Level Level 6 5291 NA 4733 NA NA
KEN_R2 Location Rural 2107 NA 2994 NA NA
KEN_R2 Location Urban 2888 NA 4401 NA NA
KEN_R2 Sector Non-public 4882 NA 5218 NA NA
KEN_R2 Sector Public 2125 NA 3601 NA NA
KEN_R3 Location Rural NA 110 NA NA NA
PER_R1 All All NA NA NA 102 NA
PER_R1 Level Hospital grande NA NA NA 103 NA
PER_R1 Location Lima Metropolitana NA NA NA 103 NA
PER_R1 Sector Public NA NA NA 102 NA
SUR_R1 Level Tertiary NA NA NA 159 153
SUR_R1 Sector Non-public NA NA NA 248 243

1.1.2. _100 vs. _50

TRUTH: _100 must be lower than _50

Results: list of surveys that have one or more red flags, the indicator pairs (and the number of estimates) that are problematic

Detailed results: list of surveys and indicator pairs that are problematic

survey group grouplabel xsafe_100 xsafe_50
MLI_R1 All All 88 29
MLI_R1 Level Hôpitaux 86 25
MLI_R1 Level Polyclinique 95 50
MLI_R1 Sector Non-public 88 33
MLI_R1 Sector Public 88 27

1.1.3. Other More restrictive vs. less restrictive

TRUTH: More restrictive must be lower than less restrictive

  • xtrainingsupport_score vs. xtraining_score
  • xppe_all_score vs. xppe_allsome_score
  • xequip_all vs. zequip_any
Results: list of surveys that have one or more red flags, the indicator pairs (and the number of estimates) that are problematic
survey flag_xtraining
AFG_R1 1
GHA_R1 1
GHA_R2 1
LCA_R1 1
MLI_R1 1
NAM_R1 1
PER_R1 6
SUR_R1 1
TCD_R1 3
Results: details
survey group grouplabel xtrainingsupport_score xtraining_score
AFG_R1 Location Urban 64 60
GHA_R1 Location Rural 62 57
GHA_R2 Sector Non-public 69 64
LCA_R1 All All 89 80
MLI_R1 Level Polyclinique 44 40
NAM_R1 Level Primary/Secondary 78 74
PER_R1 All All 63 61
PER_R1 Level Hospital grande 61 59
PER_R1 Level Hospital mediano 65 62
PER_R1 Location Lima Metropolitana 57 53
PER_R1 Location Urban 66 64
PER_R1 Sector Public 63 61
SUR_R1 Level Tertiary 87 84
TCD_R1 All All 48 39
TCD_R1 Level Tertiary 48 39
TCD_R1 Sector Public 48 39

1.1.4. Other

  • Severe + critical is greater than total beds for COVID: Data entry for the number of beds? or problems in sum across rows?
Results: list of surveys that have one or more red flags
survey flag_bed1
BDI_R1 1
CMR_R1 1
KEN_R2 1
KEN_R3 1
LBY_R1 1
LCA_R1 1
SEN_R1 1
ZMB_R1 4
Results: list of surveys that have one or more red flags and indicator pairs that are problematic
Results: details
survey group grouplabel ybed_cap_covid_severe ybed_cap_covid_critical ybed_cap_covid
BDI_R1 All All 187 114 206
CMR_R1 Sector Non-public 25 21 34
KEN_R2 Sector Non-public 391 74 455
KEN_R3 Level Level 6 936 91 997
LBY_R1 Location Rural 64 17 64
LCA_R1 All All 115 115 130
SEN_R1 All All 214 255 442
ZMB_R1 All All 1045 417 1405
ZMB_R1 Level Tertiary 1024 417 1384
ZMB_R1 Location Urban 920 345 1208
ZMB_R1 Sector Public 835 382 1150

1.2 CEHS

1.2.1. Exceeding range (percent and score indicators)

Results: list of surveys that have outside boundary estimates
survey
BDI_R1
CMR_R1
COG_R1
LBY_R1
LCA_R1
MDA_R1
MLI_R1
NAM_R1
PER_R1
PRY_R1
SEN_R1
SUR_R1
SYC_R1
UKR_R1
UKR_R2
VCT_R1
YEM_R1
ZMB_R1
ZMB_R2
Detailed results: list of surveys and indicator estimates that are outside the boundary
survey group grouplabel X xbedrate xsafe__hygiene_instructions xdiagbasic_score xdiag_score staff_pct_covaxany staff_pct_covaxfull
BDI_R1 All All NA 116 NA NA NA NA NA
BDI_R1 Sector 3.2 Privé laic NA 127 NA NA NA NA NA
BDI_R1 Sector 3.3 Privé confessionnel NA NA NA 103 103 NA NA
BDI_R1 Sector 3.4 Associatif NA 259 NA NA NA NA NA
BDI_R1 Sector Public NA 129 NA NA NA NA NA
CMR_R1 All All NA 252 NA NA NA NA NA
CMR_R1 Sector 3.1 Publique NA 296 NA NA NA NA NA
CMR_R1 Sector Non-public NA 205 NA NA NA NA NA
CMR_R1 Sector Non-public NA 209 NA NA NA NA NA
COG_R1 Level Secondary NA 272 NA NA NA NA NA
COG_R1 Sector Public NA 101 NA NA NA NA NA
LBY_R1 All All NA 200 NA NA NA NA NA
LBY_R1 Level Primary NA 200 NA NA NA NA NA
LBY_R1 Location Urban NA 200 NA NA NA NA NA
LBY_R1 Sector Public NA 200 NA NA NA NA NA
LCA_R1 All All 108 NA NA NA NA NA NA
MDA_R1 All All NA 104 NA NA NA NA NA
MDA_R1 Level Secondary NA 106 NA NA NA NA NA
MDA_R1 Location Urban NA 104 NA NA NA NA NA
MDA_R1 Sector Public NA 104 NA NA NA NA NA
MLI_R1 All All NA 111 NA NA NA NA NA
MLI_R1 Level CSCOM et assimilés NA 183 NA NA NA NA NA
MLI_R1 Location Rural NA 118 NA NA NA NA NA
MLI_R1 Location Urbain NA 107 NA NA NA NA NA
MLI_R1 Sector Non-public NA 159 NA NA NA NA NA
NAM_R1 Level Secondary NA 115 NA NA NA NA NA
NAM_R1 Location Urban NA 113 NA NA NA NA NA
NAM_R1 Sector Non-public NA 129 NA NA NA NA NA
PER_R1 Level I4 Centro de ateción Primaria con camas de internamiento 101 NA NA NA NA NA NA
PER_R1 Location Lima Metropolitana 102 121 NA NA NA NA NA
PER_R1 Location Rural 103 NA NA NA NA NA NA
PER_R1 Location Urban 104 107 NA NA NA NA NA
PER_R1 Sector Public 105 NA NA NA NA NA NA
PRY_R1 All All NA 250 NA NA NA NA NA
PRY_R1 Level Primary NA 250 NA NA NA NA NA
PRY_R1 Location Urban NA 250 NA NA NA NA NA
PRY_R1 Sector Public NA 250 NA NA NA NA NA
SEN_R1 All All 106 1596 NA NA NA NA NA
SUR_R1 All All 115 NA NA NA NA 104 NA
SUR_R1 Level Primary 116 NA NA NA NA 149 135
SUR_R1 Level Secondary 117 NA NA NA NA NA NA
SUR_R1 Location 118 NA NA NA NA NA NA
SUR_R1 Location Interior 119 NA NA NA NA NA NA
SUR_R1 Location Rural 120 NA NA NA NA NA NA
SUR_R1 Location Urban 121 NA NA NA NA 111 103
SUR_R1 Sector Non-public 122 NA NA NA NA NA NA
SUR_R1 Sector Public 123 NA NA NA NA 121 108
SYC_R1 All All 107 NA NA NA NA NA NA
UKR_R1 All All 124 NA NA NA NA NA NA
UKR_R1 Level Hospitals 125 NA NA NA NA NA NA
UKR_R1 Level Primary 126 NA 101 NA NA NA NA
UKR_R1 Location Rural 127 NA NA NA NA NA NA
UKR_R1 Location Urban 128 NA 101 NA NA NA NA
UKR_R1 Sector Non-public 129 NA NA NA NA NA NA
UKR_R1 Sector Public 130 NA 101 NA NA NA NA
UKR_R2 All All 131 2178 NA NA NA NA NA
UKR_R2 Level Hospitals 132 2113 NA NA NA NA NA
UKR_R2 Level Primary 133 2615 NA NA NA NA NA
UKR_R2 Location Rural 134 5666 NA NA NA NA NA
UKR_R2 Location Urban 135 1958 NA NA NA NA NA
UKR_R2 Sector Non-public 136 214 NA NA NA NA NA
UKR_R2 Sector Public 137 2279 NA NA NA NA NA
VCT_R1 All All 109 NA NA NA NA NA NA
VCT_R1 Level Primary 110 NA NA NA NA NA NA
VCT_R1 Location Rural 111 NA NA NA NA NA NA
VCT_R1 Location Urban 112 NA NA NA NA NA NA
VCT_R1 Sector Non-public 113 NA NA NA NA NA NA
VCT_R1 Sector Public 114 NA NA NA NA NA NA
YEM_R1 All All 138 NA NA NA NA NA NA
YEM_R1 Level Primary 139 NA NA NA NA NA NA
YEM_R1 Level Secondary 140 NA NA NA NA NA NA
YEM_R1 Location Rural 141 NA NA NA NA NA NA
YEM_R1 Location Urban 142 NA NA NA NA NA NA
YEM_R1 Sector Non-public 143 NA NA NA NA NA NA
YEM_R1 Sector Public 144 NA NA NA NA NA NA
ZMB_R1 All All 145 NA NA NA NA NA NA
ZMB_R1 Level Primary 146 NA NA NA NA NA NA
ZMB_R1 Level Secondary 147 NA NA NA NA NA NA
ZMB_R1 Location Rural 148 NA NA NA NA NA NA
ZMB_R1 Location Urban 149 NA NA NA NA NA NA
ZMB_R1 Sector Non-public 150 NA NA NA NA NA NA
ZMB_R1 Sector Public 151 NA NA NA NA NA NA
ZMB_R2 All All 152 NA NA NA NA NA NA

1.2.2. _100 vs. _50

TRUTH: _100 must be lower than _50

Results: list of surveys that have one or more red flags

Results: details

1.2.3. More restrictive vs. less restrictive

TRUTH: More restrictive must be lower than less restrictive

  • xtrainingsupport_score vs. xtraining_score
  • xppe_all_score vs. xppe_allsome_score
  • xdiag_score vs. xdiagbasic_score
  • xcovax_offerav__pfizer vs. xcovax_offer__pfizer (Pfizer as an example)
Results: list of surveys that have one or more red flags
survey flag_xtraining
AFG_R1 7
BDI_R1 5
COG_R1 5
GHA_R2 1
KEN_R3 0
LBY_R1 6
LCA_R1 1
MDA_R1 6
PER_R1 7
PRY_R1 5
SEN_R1 1
SUR_R1 8
TCD_R1 1
UKR_R1 6
VCT_R1 5
Results: details
survey group grouplabel xtrainingsupport_score xtraining_score
AFG_R1 All All 21 15
AFG_R1 Level Primary 19 14
AFG_R1 Level Secondary 38 25
AFG_R1 Location Rural 11 8
AFG_R1 Location Urban 42 30
AFG_R1 Sector Non-public 16 12
AFG_R1 Sector Public 37 27
BDI_R1 All All 41 12
BDI_R1 Sector 3.2 Privé laic 28 9
BDI_R1 Sector 3.3 Privé confessionnel 53 15
BDI_R1 Sector 3.4 Associatif 26 9
BDI_R1 Sector Public 44 12
TCD_R1 Level Secondary 63 59
COG_R1 All All 28 21
COG_R1 Level Primary 27 21
COG_R1 Level Secondary 38 34
COG_R1 Sector Non-public 15 12
COG_R1 Sector Public 44 33
GHA_R2 Sector Non-public 50 47
LBY_R1 All All 35 30
LBY_R1 Level Primary 34 29
LBY_R1 Level Secondary 78 71
LBY_R1 Location Rural 27 25
LBY_R1 Location Urban 40 33
LBY_R1 Sector Public 35 30
MDA_R1 All All 89 88
MDA_R1 Level Secondary 90 88
MDA_R1 Location Rural 73 72
MDA_R1 Location Urban 91 90
MDA_R1 Sector Non-public 74 73
MDA_R1 Sector Public 91 90
PRY_R1 All All 57 53
PRY_R1 Level Primary 57 53
PRY_R1 Location Rural 57 56
PRY_R1 Location Urban 57 51
PRY_R1 Sector Public 58 54
PER_R1 All All 35 28
PER_R1 Level I3 Centro de atención Primaria 34 28
PER_R1 Level I4 Centro de ateción Primaria con camas de internamiento 37 30
PER_R1 Location Lima Metropolitana 34 28
PER_R1 Location Rural 29 24
PER_R1 Location Urban 41 32
PER_R1 Sector Public 35 28
SEN_R1 All All 36 28
LCA_R1 All All 16 11
VCT_R1 All All 19 10
VCT_R1 Level Primary 19 10
VCT_R1 Location Rural 15 10
VCT_R1 Location Urban 33 14
VCT_R1 Sector Public 20 11
SUR_R1 All All 49 40
SUR_R1 Level Primary 40 36
SUR_R1 Level Secondary 89 60
SUR_R1 Location Interior 41 38
SUR_R1 Location Rural 29 27
SUR_R1 Location Urban 63 49
SUR_R1 Sector Non-public 40 33
SUR_R1 Sector Public 68 56
UKR_R1 All All 82 78
UKR_R1 Level Hospitals 77 75
UKR_R1 Level Primary 83 78
UKR_R1 Location Rural 73 68
UKR_R1 Location Urban 83 78
UKR_R1 Sector Public 85 80
survey group grouplabel xdiag_score xdiagbasic_score
AFG_R1 All All 49 48
AFG_R1 Level Secondary 93 89
AFG_R1 Location Urban 72 70
AFG_R1 Sector Public 63 61
TCD_R1 Level Secondary 84 82
TCD_R1 Sector Public 46 45
MDA_R1 All All 65 56
MDA_R1 Level Secondary 74 54
MDA_R1 Location Urban 68 57
MDA_R1 Sector Public 69 58
PER_R1 All All 71 64
PER_R1 Level I3 Centro de atención Primaria 70 63
PER_R1 Level I4 Centro de ateción Primaria con camas de internamiento 78 66
PER_R1 Location Lima Metropolitana 70 61
PER_R1 Location Rural 69 62
PER_R1 Location Urban 74 68
PER_R1 Sector Public 71 64
UKR_R1 All All 73 60
UKR_R1 Level Hospitals 69 65
UKR_R1 Level Primary 74 59
UKR_R1 Location Rural 69 56
UKR_R1 Location Urban 73 60
UKR_R1 Sector Non-public 64 57
UKR_R1 Sector Public 74 60
survey group grouplabel xcovax_offerav__pfizer xcovax_offer__pfizer
KEN_R3 All All 41 8
KEN_R3 Level Level 2-3 33 7
KEN_R3 Level Level 4 46 8
KEN_R3 Location Rural 33 12
KEN_R3 Location Urban 48 3
KEN_R3 Sector Non-public 67 0
KEN_R3 Sector Public 39 8

1.3 Community

1.3.1. Exceeding range (percent and score indicators)

Results: Number of surveys/indicators that have outside boundary estimates [1] 0
Results: list of surveys that have outside boundary estimates

Detailed results: list of surveys and indicator estimates that are outside the boundary

1.3.2. Unmet need

Aggregate unmet need indicators tend to have errors. For example:

  1. xunmetmost_group + xunmetsome_group != xunmetsomemost_group
  2. xunmetmost_group + xunmetsome_group >100
  3. xunmetmost_group is smaller than minimum of individual detailed xunmetmost__item
1.3.2.1.
Results: Number of surveys/indicators that have a problem in aggregated unmet need indicators: `xunmetmost_group` + `xunmetsome_group` != `xunmetsomemost_group` [1] 0
1.3.2.2.
Results: Number of surveys/indicators that have a problem in aggregated unmet need indicators: `xunmetmost_group` + `xunmetsome_group` >100 [1] 0
1.3.2.3.
Results: list of surveys that have a problem in aggregated unmet need indicators: `xunmetmost_group` is smaller than minimum of individual detailed `xunmetmost__item`
survey
GHA_R2
Detailed results: list of surveys and indicator estimates with errors
survey group grouplabel xunmetmost_rmch xunmetmost__fp xunmetmost__anc xunmetmost__sba xunmetmost__immun
GHA_R2 All All 1 8 3 17 3
survey group grouplabel xunmetmost_chronic xunmetmost__chronicmeds xunmetmost__testing
GHA_R2 All All 19 27 35
GHA_R2 Location 1.1 Rural 9 20 27
GHA_R2 Location 1.2 Urban 23 30 38

2. Outliers

  • Outliers exist by default, but likely in a cluster of countries (with weak systems). Check if they exist in unexpected countries. Or, check if estimates seem too odd.
  • Analysis includes all national estimates (regardless of the sample size), and any sub-national estimates that have 30 or more observations.

2.1. C19CM

Detailed results: list of outliers: survey, indicator, estimates
survey grouplabel obs indicator estimate
AFG_R1 All 5 xppe_allsome_score 80
BDI_R1 All 65 xtraining_score 23
BDI_R1 All 65 xtrainingsupport_score 21
BDI_R1 All 65 xguideline_score 69
BDI_R1 All 65 xppe_allsome_score 74
BDI_R1 All 65 xspcmitem_score 35
CMR_R1 All 60 xequip_allfunction_score 40
CMR_R1 Public 56 xequip_allfunction_score 38
COG_R1 All 33 xtraining_score 24
COG_R1 All 33 xtrainingsupport_score 22
COG_R1 All 33 xsupp_score 76
COG_R1 All 33 xguideline_score 68
COG_R1 All 33 xppe_allsome_score 64
COG_R1 All 33 xipcitem_score 62
COG_R1 All 33 xxipcitem_score 69
LBY_R1 All 10 xtraining_score 26
LBY_R1 All 10 xtrainingsupport_score 19
LBY_R1 All 10 xguideline_score 65
LBY_R1 All 10 xspcmitem_score 30
LCA_R1 All 1 xtrainingsupport_score 89
LCA_R1 All 1 xppe_allsome_score 0
LCA_R1 All 1 xppe_all_score 0
LCA_R1 All 1 xequip_allfunction_score 100
LCA_R1 All 1 xxppe_all_score 0
MLI_R1 All 14 xtraining_score 30
MLI_R1 All 14 xtrainingsupport_score 24
PRY_R1 All 20 xtraining_score 93
PRY_R1 All 20 xtrainingsupport_score 93
SUR_R1 All 9 xtrainingsupport_score 78
TCD_R1 All 3 xtraining_score 39
TCD_R1 All 3 xtrainingsupport_score 48
VCT_R1 All 1 xtraining_score 100
VCT_R1 All 1 xtrainingsupport_score 100
VCT_R1 All 1 xequip_allfunction_score 100

2.2. CEHS

Detailed results: list of outliers: survey, indicator, estimates
survey grouplabel obs indicator estimate
COG_R1 Non-public 87 xsupp_score 56
GHA_R2 Secondary Facility 38 xcvd_pt_score 0
KEN_R2 Public 82 xsupp_score 35
KEN_R2 Rural 68 xsupp_score 56
KEN_R2 Urban 38 xsupp_score 15
KEN_R3 All 93 xsupp_score 49
KEN_R3 Level 4 40 xsupp_score 0
KEN_R3 Public 86 xsupp_score 50
KEN_R3 Urban 37 xsupp_score 23
MDA_R1 All 99 xtrainingsupport_score 89
MDA_R1 Primary 50 xtrainingsupport_score 88
MDA_R1 Public 89 xtrainingsupport_score 91
MDA_R1 Secondary 49 xtrainingsupport_score 90
MDA_R1 Secondary 49 xvac_score 20
MDA_R1 Urban 90 xtrainingsupport_score 91
PRY_R1 All 70 xdiagbasic_score 1
PRY_R1 All 70 xdiag_score 1
PRY_R1 Primary 70 xdiagbasic_score 1
PRY_R1 Primary 70 xdiag_score 1
PRY_R1 Public 68 xdiagbasic_score 1
PRY_R1 Public 68 xdiag_score 1
PRY_R1 Rural 34 xdiagbasic_score 1
PRY_R1 Rural 34 xdiag_score 1
PRY_R1 Urban 36 xdiagbasic_score 1
PRY_R1 Urban 36 xdiag_score 1
UKR_R1 All 250 xtrainingsupport_score 82
UKR_R1 Primary 214 xtrainingsupport_score 83
UKR_R1 Public 225 xtrainingsupport_score 85
UKR_R1 Urban 233 xtrainingsupport_score 83
ZMB_R1 All 242 xsupp_score 51
ZMB_R1 Primary 212 xsupp_score 48
ZMB_R1 Public 213 xsupp_score 48
ZMB_R1 Rural 104 xsupp_score 48
ZMB_R1 Urban 138 xsupp_score 53
ZMB_R2 All 248 xsupp_score 56

2.3. Community

Detailed results: list of outliers: survey, indicator, estimates
survey grouplabel obs indicator estimate
LBY_R1 1.2 Urban 43 xbar_covid_admin 44
LBY_R1 All 50 xbar_covid_admin 40
PER_R1 All 36 xbar_covid_rec 39
PER_R1 All 36 xbar_covid_info 39
PER_R1 All 36 xbar_covid_admin 86
PER_R1 All 36 xbar_covid_qinput 53
PER_R1 All 36 xbar_covid_qexp 58
SUR_R1 All 20 xbar_covid_info 45
SUR_R1 All 20 xbar_covid_admin 45
Results: details
survey grouplabel obs indicator estimate
CMR_R1 All 34 xvac_reason_exposure 26
CMR_R1 All 34 xvac_child_mostsome 3
LCA_R1 All 15 xvac_noaccess 7
VCT_R1 All 5 xvac_reason_antivac 100
VCT_R1 All 5 xvac_reason_time 20
YEM_R1 1.1 Rural 52 xvac_noaccess_reason__other 8
YEM_R1 1.2 Urban 44 xvac_noaccess_reason__eligible 4
YEM_R1 1.2 Urban 44 xvac_noaccess_reason_eligible 4

3. Possible errors

  • This requires subject and context knowledge. Still attempting some plausibility check based on observed patterns across surveys/analysis domains: is this result in a survey “very” different from that in other surveys?
  • Screening/assessment is restricted to estimates that have ‘sufficient’ sample size (i.e., denominator >=30 per analysis domain, including national).

3.1. C19CM

C19CM: Staff infection

ASSUMPTION: staff infection is higher among clinical staff than non-clinical staff

Results: details
survey grouplabel staff_num_total_clinical staff_pct_covid_clinical staff_num_total_nonclinical staff_pct_covid_nonclinical
KEN_R3 Level 6 3790 4.6 34 17.6
KEN_R3 Non-public 3273 1.6 30 3.3
LBY_R1 All 12314 23.2 2877 31.4
LBY_R1 Hospital 12285 23.2 2866 31.5
LBY_R1 Urban 11266 23.7 2688 32.3
LBY_R1 Public 12314 23.2 2877 31.4
SEN_R1 All 1194 0.3 389 0.8
SUR_R1 All 566 12.4 83 20.5
SUR_R1 Primary/Secondary 374 6.4 83 20.5
SUR_R1 Urban 566 12.4 83 20.5
SUR_R1 Public 367 15.0 83 20.5

C19CM: Associations among commodities: medicines, IPC items, and PPE

ASSUMPTION: commodity related scores are correlated. If a country-cluster estimates are outliers, check validity.

3.2. CEHS

CEHS: staff infection

ASSUMPTION: staff infection rates are correlated among clinical staff and non-clinical staff.

Results: details
survey grouplabel staff_num_total_clinical staff_pct_covid_clinical staff_num_total_nonclinical staff_pct_covid_nonclinical
AFG_R1 Secondary 2981.0000 5.6 1776.0000 13.0
AFG_R1 Public 2687.0000 6.7 1608.0000 14.6
CMR_R1 3.1 Publique 477.0000 9.0 304.0000 11.8
TCD_R1 All 1314.0000 3.2 791.0000 4.7
TCD_R1 Primary 909.0000 4.6 643.0000 5.8
TCD_R1 Rural 97.0000 4.1 58.0000 5.2
TCD_R1 Urban 1217.0000 3.1 733.0000 4.6
TCD_R1 Public 942.0000 3.4 641.0000 5.0
COG_R1 Primary 828.0000 1.1 216.0000 1.4
GHA_R2 Primary Facility 1669.0000 1.7 426.0000 2.3
KEN_R1 Rural 2551.0000 2.1 677.0000 2.8
KEN_R1 Non-public 1496.0000 2.2 746.0000 3.5
MDA_R1 Rural 159.0000 5.0 40.0000 7.5
PRY_R1 All 326.0000 2.1 200.0000 3.5
PRY_R1 Primary 326.0000 2.1 200.0000 3.5
PRY_R1 Public 312.0000 1.9 191.0000 3.1
SYC_R1 All 1600.0000 2.0 176.0000 4.5
SUR_R1 All 845.0000 14.2 181.0000 55.2
SUR_R1 Primary 328.0000 12.2 181.0000 55.2
SUR_R1 Urban 778.0000 13.6 127.0000 70.1
SUR_R1 Non-public 435.0000 11.0 63.0000 15.9
SUR_R1 Public 410.0000 17.6 118.0000 76.3
UKR_R2 Non-public 899.2562 1.6 166.0469 5.3
But, what if the assumption is not correct? See example fitted lines based on regression models. Not saying these relationships are correct, but just to demostrate that it's a judgement call.  

CEHS: COVID testing

ASSUMPTION: RDT is more available than PCR test among EHS facilities

Results: details
survey grouplabel obs xcvd_test_pcr xcvd_test_rdt
AFG_R1 Public 21 33 14
BDI_R1 3.4 Associatif 9 11 0
TCD_R1 All 191 2 1
TCD_R1 Primary 178 2 1
TCD_R1 Urban 164 2 1
TCD_R1 Public 157 2 1
GHA_R2 All 146 1 0
GHA_R2 Primary Facility 108 1 0
GHA_R2 Urban 73 3 0
GHA_R2 Non-public 18 10 0
KEN_R1 All 91 5 2
KEN_R1 Level 4-6 47 11 4
KEN_R1 Urban 33 15 6
KEN_R1 Non-public 24 8 4
KEN_R1 Public 67 4 1
LBY_R1 Urban 24 21 13
NAM_R1 Primary 106 8 6
NAM_R1 Urban 53 12 9
NAM_R1 Public 97 7 4
PRY_R1 All 70 3 1
PRY_R1 Primary 70 3 1
PRY_R1 Rural 34 3 0
PRY_R1 Non-public 2 50 0
PER_R1 Lima Metropolitana 36 19 11
SYC_R1 All 34 56 6
VCT_R1 Urban 3 67 33
YEM_R1 Primary 9 19 7
YEM_R1 Non-public 7 14 10

3.2. Community


Note:
* Indicator estimates from multiple surveys are combined/appended and then saved in one Excel file as well as multiple Stata data files in the sharepoint: “/BANICA, Sorin - HSA unit/4 Databases, analyses & dashboards/2 HFAs for COVID-19/HFA database/1 Database”
* This analysis uses the Stata data files (downloaded as of 2022-07-26 17:41:00). Analysis code will be saved in the sharepoint:”/BANICA, Sorin - HSA unit/4 Databases, analyses & dashboards/2 HFAs for COVID-19/HFA database/2 Analysis files”