Table 1.

Distribution of variables by antibiotic prescription for RTI visits in children

VARIABLEFULL DATA SET*SAMPLE OF 1 VISIT PER CHILD*
ALL VISITS (N = 2 996 186)ASSOCIATED WITH AN ANTIBIOTIC PRESCRIPTION (N = 834 673)NOT ASSOCIATED WITH AN ANTIBIOTIC PRESCRIPTION (N = 2 161 513)ALL VISITS (N = 671 342)ASSOCIATED WITH AN ANTIBIOTIC PRESCRIPTION (N = 183 118)NOT ASSOCIATED WITH AN ANTIBIOTIC PRESCRIPTION (N = 488 224)
Overall population, %100.027.972.1100.027.372.7
Year, %
  • 200511.330.369.713.231.668.4
  • 200615.429.470.616.230.669.4
  • 200714.728.571.613.728.971.1
  • 200814.128.871.212.628.471.6
  • 200916.922.977.216.121.278.9
  • 201013.128.072.012.225.874.3
  • 201114.628.671.516.125.474.6
Patient-level factors
Patient sex
  • Female, %47.527.972.148.927.372.7
  • Male, %52.527.872.251.227.372.7
  • Missing, n2NANA1NANA
Median (IQR) patient age, y4 (2–9)6 (3–10)4 (1–8)6 (2–11)8 (4–12)5 (1–10)
  • Missing, n2NANA2NANA
Follow-up RTI visit,§ %14.024.675.57.924.375.8
QAIPPE
  • 1 (lowest), %22.228.671.420.427.672.4
  • 2, %22.728.771.320.927.872.2
  • 3, %20.027.672.420.527.372.7
  • 4, %18.226.973.12026.973.1
  • 5 (highest), %15.727.172.918.226.773.3
  • Missing, n38 224NANA9157NANA
Diabetes, %0.233.166.90.233.366.7
Asthma, %12.431.568.58.131.168.9
Cystic fibrosis, %0.218.681.40.117.782.3
Immune deficiency, %0.230.269.80.228.771.3
Chronic liver disease, %< 0.127.872.20.026.473.6
Congestive heart failure, %< 0.127.272.80.022.977.1
COPD, %0.531.568.50.331.468.7
Chronic kidney disease, %0.128.771.40.128.571.6
Recent antibiotic use, %9.124.575.59.424.175.9
Median (IQR) ADG sum4 (2–5)4 (2–5)4 (2–5)3 (2–5)3 (2–4)3 (2–5)
  • Missing, n9NANA2NANA
Visits in past 3 y with this physician, %
  • 036.628.671.446.828.771.3
  • ≤ 30 (but > 0)30.228.671.425.527.972.1
  • > 3033.226.373.727.824.475.6
Median (IQR) no. of different GPs seen in past 3 y5 (3–7)5 (3–8)5 (3–7)4 (2–6)4 (2–6)4 (2–6)
Season, %
  • Mar–May24.229.170.924.529.071.0
  • Jun–Aug15.029.570.514.529.770.3
  • Sep–Nov29.325.474.628.824.076.0
  • Dec–Feb31.528.471.632.327.872.3
Physician-level factors
Physicians, n6404NANA6148NANA
Physician sex
  • Female, %27.723.576.628.323.077.0
  • Male, %72.329.570.571.728.971.1
  • Missing, n10 398NANA1910NANA
Specialty, %
  • Emergency medicine physician0.625.174.90.725.274.8
  • Pediatrician2.911.288.82.412.887.2
  • Other0.841.858.20.740.759.3
  • GP95.728.371.796.227.672.5
Visits for RTIs in the past 30 d, %
  • None0.620.479.60.721.079.0
  • ≤ 2.55.721.778.36.922.177.9
  • > 2.5–514.724.475.616.824.775.3
  • > 5–7.516.526.074.017.826.273.8
  • > 7.5–1014.827.972.214.827.472.6
  • > 10–1522.129.970.120.629.370.7
  • > 15–2014.031.968.112.230.969.1
  • > 2011.729.470.610.228.771.3
Medical school graduation location
  • Canada, %62.124.375.864.123.876.2
  • International, %37.933.866.236.033.466.6
  • Missing, n70 648NANA15 683NANA
Daily patient volume, %
  • 1st quartile (< 28 visits)22.823.276.925.323.376.7
  • 2nd quartile (28–37 visits)24.926.473.626.626.273.8
  • 3rd quartile (38–48 visits)26.028.971.125.728.771.3
  • 4th quartile (> 48 visits)26.332.367.722.431.468.6
Years since medical school graduation
  • 0–5, %4.621.878.25.220.879.3
  • 6–10, %9.322.177.99.822.477.6
  • 11–15, %13.024.076.013.424.375.7
  • 16–20, %18.526.973.118.227.073.1
  • 21–25, %16.828.771.316.527.772.3
  • 26–30, %13.930.070.013.729.370.7
  • 31–35, %11.930.769.311.629.770.3
  • 36–40, %7.430.769.37.229.770.3
  • > 40, %4.739.160.94.537.962.1
  • Missing, n4032NANA1050NANA
No. of RTIs seen in the past y, %
  • 1st quartile (≤ 248)20.420.879.224.821.578.5
  • 2nd quartile (249–490)22.225.674.525.125.974.1
  • 3rd quartile (491–972)25.228.271.825.028.571.5
  • 4th quartile (≥ 973)32.233.766.425.033.266.8
Regional-level factors
Median (IQR) proportion of LHA population aged > 65 y0.13 (0.10–10.15)0.13 (0.10–0.15)0.13 (0.11–0.15)0.13 (0.11–0.16)0.13 (0.10–0.16)0.13 (0.11–0.16)
Median (IQR) proportion of LHA population aged < 15 y0.18 (0.16–0.21)0.19 (0.17–0.22)0.18 (0.16–0.21)0.18 (0.16–0.21)0.19 (0.16–0.21)0.18 (0.16–0.21)
Median (IQR) age of LHA population, y39 (36–41)38 (35–41)39 (37–41)39 (37–42)39 (37–41)39 (37–42)
Health authority
  • Interior, %11.827.872.214.528.072.1
  • Fraser, %46.329.670.441.328.571.5
  • Vancouver Coastal, %23.222.477.622.321.978.1
  • Vancouver Island, %12.226.473.614.326.573.5
  • Northern, %6.537.562.57.536.663.4
  • Missing, n4689NANA1251NANA
Median (IQR) 28-d moving average apparent temperature, °C4.73 (0.57–11.76)4.62 (0.33–12.14)4.77 (0.66–11.57)4.49 (0.36–11.50)4.42 (0.17–12.14)4.52 (0.43–11.24)
  • ADG—aggregated diagnosis group, COPD—chronic obstructive pulmonary disease, IQR—interquartile range, LHA—local health area, NA—not applicable, QAIPPE—Quintile of Annual Income Per Person Equivalent, RTI—respiratory tract infection.

  • * Not all percentages add to 100 owing to rounding.

  • Overall values.

  • Within-category values.

  • § A follow-up visit is any visit within 14 d of another RTI visit.

  • Recent antibiotic use is any antibiotic prescription within the past 6 mo.

  • Daily patient volume is the total number of claims billed on the RTI visit day.