Appendix 3 : Frequency Counts Data

Page last updated: 26 September 2012

NADC - ANDIAB
Australian National Diabetes Information Audit & Benchmarking



Final Report
ANDIAB 2011
[November 2011]



Frequency Counts Data:

The following pages provide Frequency Counts data on each field for All Sites.

In the below tables 'Missing' represents the Missing Data [number and %] for that item. The Missing % figure is the percent of the complete cohort of patients for whom that item was missing or unknown (for example if there are 100 patients overall and 50 of them have no data the Missing% figure will be 50).

Number and % figures are given.The percentage figures {including Missing} add up to 100% and represent the percent of the available data that falls into each category. where relevant, data for Median, Average [Mean], Standard Deviation [SD], Minimum [Min] and Maximum [Max] are shown [for numeric fields].

Numbers in the Relative % column represent the relative Yes and No percent [%] of the total.

Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Active Foot Lesion ( Adult forms only )Yes 116 2.5% 3.5%
Active Foot Lesion ( Adult forms only )No 3225 69.7% 96.5%
Active Foot Lesion ( Adult forms only )Missing 1288 27.8%
Active Foot Lesion ( Adult forms only )Sum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
AgeAge458098.9%61.0057.2017.303.8099.40
AgeMissing491.1%
AgeSum4629100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Antiplatelet - Aspirin Therapy ( Adult forms only )Contraindicated1633.5%4.5%
Antiplatelet - Aspirin Therapy ( Adult forms only )Missing99821.6%
Antiplatelet - Aspirin Therapy ( Adult forms only )No159934.5%44.0%
Antiplatelet - Aspirin Therapy ( Adult forms only )Yes186940.4%51.5%
Antiplatelet - Aspirin Therapy ( Adult forms only )Sum4629100.0%
Top of page

Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Antiplatelet - Clopidogrel Therapy ( Adult forms only )Contraindicated100 2.2% 2.6%
Antiplatelet - Clopidogrel Therapy ( Adult forms only )Missing811 17.5%
Antiplatelet - Clopidogrel Therapy ( Adult forms only )No314 6.8% 8.2%
Antiplatelet - Clopidogrel Therapy ( Adult forms only )Yes3404 73.5% 89.2%
Antiplatelet - Clopidogrel Therapy ( Adult forms only )Sum4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Attended Diabetes Educator ( Adult forms only )Yes 2617 56.5% 70.5%
Attended Diabetes Educator ( Adult forms only )No 1097 23.7% 29.5%
Attended Diabetes Educator ( Adult forms only )Missing 915 19.8%
Attended Diabetes Educator ( Adult forms only )Sum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Attended Dietitian ( Adult forms only )Yes1535 33.2% 42.5%
Attended Dietitian ( Adult forms only )No 2074 44.8% 57.5%
Attended Dietitian ( Adult forms only )Missing 1020 22.0%
Attended Dietitian ( Adult forms only )Sum 4629 100.0%
Top of page

Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Attended OphthalmologistYes1897 41.0% 66.4%
Attended OphthalmologistNo 958 20.7% 33.6%
Attended OphthalmologistMissing 1774 38.3%
Attended OphthalmologistSum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Attended OptometristYes1764 38.1% 57.2%
Attended OptometristNo 1321 28.5% 42.8%
Attended OptometristMissing 1544 33.4%
Attended OptometristSum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Attended Podiatrist ( Adult forms only )Yes 1617 34.9% 43.9%
Attended Podiatrist ( Adult forms only )No 2064 44.6% 56.1%
Attended Podiatrist ( Adult forms only )Missing 948 20.5%
Attended Podiatrist ( Adult forms only )Sum 4629 100.0%
Top of page


Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blindness: new ( Adult forms only )Yes 40 0.9% 1.2%
Blindness: new ( Adult forms only )No 3416 73.8% 98.8%
Blindness: new ( Adult forms only )Missing 1173 25.3%
Blindness: new ( Adult forms only )Sum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blindness: previous ( Adult forms only )Yes 47 1.0% 1.4%
Blindness: previous ( Adult forms only )No 3309 71.5% 98.6%
Blindness: previous ( Adult forms only )Missing 1273 27.5%
Blindness: previous ( Adult forms only )Sum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - On anti-hypertensive treatmentYes263757.0%67.9%
Blood pressure - On anti-hypertensive treatmentNo124426.9%32.1%
Blood pressure - On anti-hypertensive treatmentMissing74816.2%
Blood pressure - On anti-hypertensive treatmentSum4629100.0%
Top of page

Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - On antihypertensive treatment ( Patients aged 18yrs+ only )Yes2600 57.4% 68.6%
Blood pressure - On antihypertensive treatment ( Patients aged 18yrs+ only )No1189 26.3% 31.4%
Blood pressure - On antihypertensive treatment ( Patients aged 18yrs+ only )Missing740 16.3%
Blood pressure - On antihypertensive treatment ( Patients aged 18yrs+ only )Sum4529 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - SystolicSystolBP4484 96.9% 130.00 130.10 17.80 75.00 220.00
Blood pressure - SystolicMissing145 3.1%
Blood pressure - SystolicSum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - DiastolicDiastBP4484 96.9% 73.00 73.70 10.50 5.00 130.00
Blood pressure - DiastolicMissing145 3.1%
Blood pressure - DiastolicSum4629 100.0%
Top of page

Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - On A2 + ThiazideYes 480 10.4% 13.7%
Blood pressure - On A2 + ThiazideNo 3016 65.2% 86.3%
Blood pressure - On A2 + ThiazideMissing 1133 24.5%
Blood pressure - On A2 + ThiazideSum 4629 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - On A2 + Thiazide ( Only patients on anti-hypertensives )Yes 431 16.3% 19.9%
Blood pressure - On A2 + Thiazide ( Only patients on anti-hypertensives )No 1733 65.7% 80.1%
Blood pressure - On A2 + Thiazide ( Only patients on anti-hypertensives )Missing 473 17.9%
Blood pressure - On A2 + Thiazide ( Only patients on anti-hypertensives )Sum 2637 100.0%
Field
Name
CategoryTotalRelative
%*
MedianMeanSDMinMax
Blood pressure - On A2 AntagonistsYes 805 17.4% 25.2%
Blood pressure - On A2 AntagonistsNo 2387 51.6% 74.8%
Blood pressure - On A2 AntagonistsMissing 1437 31.0%
Blood pressure - On A2 AntagonistsSum 4629 100.0%
Top of page


    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On A2 Antagonists ( Only patients on anti-hypertensives )
    Yes
    734
    27.8%
    34.2%
    Blood pressure - On A2 Antagonists ( Only patients on anti-hypertensives )
    No
    1411
    53.5%
    65.8%
    Blood pressure - On A2 Antagonists ( Only patients on anti-hypertensives )
    Missing
    492
    18.7%
    Blood pressure - On A2 Antagonists ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On ACE + Thiazide
    Yes
    222
    4.8%
    6.4%
    Blood pressure - On ACE + Thiazide
    No
    3262
    70.5%
    93.6%
    Blood pressure - On ACE + Thiazide
    Missing
    1145
    24.7%
    Blood pressure - On ACE + Thiazide
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On ACE + Thiazide ( Only patients on anti-hypertensives )
    Yes
    181
    6.9%
    8.4%
    Blood pressure - On ACE + Thiazide ( Only patients on anti-hypertensives )
    No
    1965
    74.5%
    91.6%
    Blood pressure - On ACE + Thiazide ( Only patients on anti-hypertensives )
    Missing
    491
    18.6%
    Blood pressure - On ACE + Thiazide ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On ACE Inhibitor
    Yes
    1263
    27.3%
    38.5%
    Blood pressure - On ACE Inhibitor
    No
    2015
    43.5%
    61.5%
    Blood pressure - On ACE Inhibitor
    Missing
    1351
    29.2%
    Blood pressure - On ACE Inhibitor
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On ACE inhibitor ( Only patients on anti-hypertensives )
    Yes
    1144
    43.4%
    52.2%
    Blood pressure - On ACE inhibitor ( Only patients on anti-hypertensives )
    No
    1048
    39.7%
    47.8%
    Blood pressure - On ACE inhibitor ( Only patients on anti-hypertensives )
    Missing
    445
    16.9%
    Blood pressure - On ACE inhibitor ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On Beta blockers
    Yes
    752
    16.2%
    24.0%
    Blood pressure - On Beta blockers
    No
    2376
    51.3%
    76.0%
    Blood pressure - On Beta blockers
    Missing
    1501
    32.4%
    Blood pressure - On Beta blockers
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On Beta Blockers ( Only patients on anti-hypertensives )
    Yes
    690
    26.2%
    32.9%
    Blood pressure - On Beta Blockers ( Only patients on anti-hypertensives )
    No
    1409
    53.4%
    67.1%
    Blood pressure - On Beta Blockers ( Only patients on anti-hypertensives )
    Missing
    538
    20.4%
    Blood pressure - On Beta Blockers ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On Calcium Antagonists
    Yes
    891
    19.2%
    28.2%
    Blood pressure - On Calcium Antagonists
    No
    2264
    48.9%
    71.8%
    Blood pressure - On Calcium Antagonists
    Missing
    1474
    31.8%
    Blood pressure - On Calcium Antagonists
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - On Calcium Antagonists ( Only patients on anti-hypertensives )
    Yes
    825
    31.3%
    39.0%
    Blood pressure - On Calcium Antagonists ( Only patients on anti-hypertensives )
    No
    1290
    48.9%
    61.0%
    Blood pressure - On Calcium Antagonists ( Only patients on anti-hypertensives )
    Missing
    522
    19.8%
    Blood pressure - On Calcium Antagonists ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - Other
    Yes
    383
    8.3%
    13.1%
    Blood pressure - Other
    No
    2534
    54.7%
    86.9%
    Blood pressure - Other
    Missing
    1712
    37.0%
    Blood pressure - Other
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - Other ( Only patients on anti-hypertensives )
    Yes
    335
    12.7%
    17.3%
    Blood pressure - Other ( Only patients on anti-hypertensives )
    No
    1597
    60.6%
    82.7%
    Blood pressure - Other ( Only patients on anti-hypertensives )
    Missing
    705
    26.7%
    Blood pressure - Other ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - Thiazides
    Yes
    154
    3.3%
    5.9%
    Blood pressure - Thiazides
    No
    2450
    52.9%
    94.1%
    Blood pressure - Thiazides
    Missing
    2025
    43.7%
    Blood pressure - Thiazides
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Blood pressure - Thiazides ( Only patients on anti-hypertensives )
    Yes
    143
    5.4%
    8.5%
    Blood pressure - Thiazides ( Only patients on anti-hypertensives )
    No
    1541
    58.4%
    91.5%
    Blood pressure - Thiazides ( Only patients on anti-hypertensives )
    Missing
    953
    36.1%
    Blood pressure - Thiazides ( Only patients on anti-hypertensives )
    Sum
    2637
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Body Mass Index
    BMI
    3989
    86.2%
    30.00
    31.30
    7.50
    7.90
    89.90
    Body Mass Index
    Missing
    640
    13.8%
    Body Mass Index
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    CABG: new ( Adult forms only )
    Yes
    125
    2.7%
    3.6%
    CABG: new ( Adult forms only )
    No
    3342
    72.2%
    96.4%
    CABG: new ( Adult forms only )
    Missing
    1162
    25.1%
    CABG: new ( Adult forms only )
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    CABG: previous ( Adult forms only )
    Yes
    440
    9.5%
    10.9%
    CABG: previous ( Adult forms only )
    No
    3603
    77.8%
    89.1%
    CABG: previous ( Adult forms only )
    Missing
    586
    12.7%
    CABG: previous ( Adult forms only )
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Cataract Left
    Yes
    697
15.1%
    22.6%
    Cataract Left
    No
    2393
    51.7%
    77.4%
    Cataract Left
    Missing
    1539
    33.2%
    Cataract Left
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Cataract Right
    Yes
    641
13.8%
    20.9%
    Cataract Right
    No
    2428
    52.5%
    79.1%
    Cataract Right
    Missing
    1560
    33.7%
    Cataract Right
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Creatinine
    Creatin
    3767
81.4%
    79.00
    95.00
    73.20
    23.00
    1005.00
    Creatinine
    Missing
    862
    18.6%
    Creatinine
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Current foot ulcer ( Adult forms only )
    Yes
    98
2.1%
    2.6%
    Current foot ulcer ( Adult forms only )
    No
    3677
    79.4%
    97.4%
    Current foot ulcer ( Adult forms only )
    Missing
    854
    18.4%
    Current foot ulcer ( Adult forms only )
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Date Of Birth
    DOB
    4580
98.9%
    100.0%
    Date Of Birth
    Missing
    49
    1.1%
    Date Of Birth
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Duration
    Duration
    4481
96.8%
    12.00
    13.90
    10.60
    0.00
    64.40
    Duration
    Missing
    148
    3.2%
    Duration
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    eGFR over 60 ( Adult forms only )
    Yes
    2781
60.1%
    73.2%
    eGFR over 60 ( Adult forms only )
    No
    1016
    21.9%
    26.8%
    eGFR over 60 ( Adult forms only )
    Missing
    832
    18.0%
    eGFR over 60 ( Adult forms only )
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    eGFRResult
    eGFRResult
    3360
    72.6%
77.00
    71.40
    22.60
    4.00
    174.00
    eGFRResult
    Missing
    1269
    27.4%
    eGFRResult
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    End stage renal disease: new ( Adult forms only )
    Yes
    107
    2.3%
2.8%
    End stage renal disease: new ( Adult forms only )
    No
    3753
    81.1%
    97.2%
    End stage renal disease: new ( Adult forms only )
    Missing
    769
    16.6%
    End stage renal disease: new ( Adult forms only )
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    End stage renal disease: previous ( Adult forms only )
    Yes
    110
    2.4%
3.3%
    End stage renal disease: previous ( Adult forms only )
    No
    3242
    70.0%
    96.7%
    End stage renal disease: previous ( Adult forms only )
    Missing
    1277
    27.6%
    End stage renal disease: previous ( Adult forms only )
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Foot Deformity ( Adult forms only )
    Yes
    203
    4.4%
6.1%
    Foot Deformity ( Adult forms only )
    No
    3147
    68.0%
    93.9%
    Foot Deformity ( Adult forms only )
    Missing
    1279
    27.6%
    Foot Deformity ( Adult forms only )
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Fundus examination (last 12 months)
    Yes
    2427
    52.4%
85.1%
    Fundus examination (last 12 months)
    No
    425
    9.2%
    14.9%
    Fundus examination (last 12 months)
    Missing
    1777
    38.4%
    Fundus examination (last 12 months)
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Glycated Haemoglobin
    HbA1c
    4244
    91.7%
8.00
    8.10
    1.70
    3.60
    18.30
    Glycated Haemoglobin
    Missing
    385
    8.3%
    Glycated Haemoglobin
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    HbA1c : upper limit
    6
    4054
    91.8%
91.8%
    HbA1c : upper limit
    Sum
    4418
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Height ( Adult forms only )
    Height
    4005
    86.5%
2.00
    1.70
    0.10
    1.00
    2.00
    Height ( Adult forms only )
    Missing
    624
    13.5%
    Height ( Adult forms only )
    Sum
    4629
    100.0%
Top of page


    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    If on Insulin: Since (year) ( Only patients using Insulin )
    InsSince
    2756
    91.9%
2005.00
    2001.30
    10.70
    1947.00
    2011.00
    If on Insulin: Since (year) ( Only patients using Insulin )
    Missing
    244
    8.1%
    If on Insulin: Since (year) ( Only patients using Insulin )
    Sum
    3000
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Impotence: new ( Adult forms only , Males )
    Yes
    513
    20.7%
30.8%
    Impotence: new ( Adult forms only , Males )
    No
    1154
    46.6%
    69.2%
    Impotence: new ( Adult forms only , Males )
    Missing
    809
    32.7%
    Impotence: new ( Adult forms only , Males )
    Sum
    2476
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Impotence: previous ( Adult forms only , Males )
    Yes
    560
    22.6%
31.3%
    Impotence: previous ( Adult forms only , Males )
    No
    1230
    49.7%
    68.7%
    Impotence: previous ( Adult forms only , Males )
    Missing
    686
    27.7%
    Impotence: previous ( Adult forms only , Males )
    Sum
    2476
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Indigenous - ATSI
    Yes
    85
    1.8%
2.3%
    Indigenous - ATSI
    No
    3604
    77.9%
    97.7%
    Indigenous - ATSI
    Missing
    940
    20.3%
    Indigenous - ATSI
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Initial Visit
    Yes
    657
    14.2%
14.3%
    Initial Visit
    No
    3943
    85.2%
    85.7%
    Initial Visit
    Missing
    29
    0.6%
    Initial Visit
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - Cholesterol
    LipChol
    3526
    76.2%
4.00
    4.30
    1.10
    1.60
    13.60
    Lipids - Cholesterol
    Missing
    1103
    23.8%
    Lipids - Cholesterol
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - Fasting Lipids
    Yes
    2449
    52.9%
82.7%
    Lipids - Fasting Lipids
    No
    511
    11.0%
    17.3%
    Lipids - Fasting Lipids
    Missing
    1669
    36.1%
    Lipids - Fasting Lipids
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - Fasting Lipids ( Only patients with any Lipid results )
    Yes
    2422
    68.5%
86.6%
    Lipids - Fasting Lipids ( Only patients with any Lipid results )
    No
    376
    10.6%
    13.4%
    Lipids - Fasting Lipids ( Only patients with any Lipid results )
    Missing
    740
    20.9%
    Lipids - Fasting Lipids ( Only patients with any Lipid results )
    Sum
    3538
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - HDL Cholesterol
    LipHDL
    3067
    66.3%
1.00
    1.20
    0.40
    0.10
    3.80
    Lipids - HDL Cholesterol
    Missing
    1562
    33.7%
    Lipids - HDL Cholesterol
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - LDL Cholesterol
    LipLDL
    2884
    62.3%
2.00
    2.20
    0.90
    -1.50
    6.80
    Lipids - LDL Cholesterol
    Missing
    1745
    37.7%
    Lipids - LDL Cholesterol
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lipids - Triglycerides
    LipTglyc
    3487
    75.3%
2.00
    1.80
    1.50
    0.10
    30.80
    Lipids - Triglycerides
    Missing
    1142
    24.7%
    Lipids - Triglycerides
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lower limb amputation - new ( Adult forms only )
    Yes
    33
    0.7%
0.9%
    Lower limb amputation - new ( Adult forms only )
    No
    3843
    83.0%
    99.1%
    Lower limb amputation - new ( Adult forms only )
    Missing
    753
    16.3%
    Lower limb amputation - new ( Adult forms only )
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Lower limb amputation - previous ( Adult forms only )
    Yes
    97
    2.1%
2.6%
    Lower limb amputation - previous ( Adult forms only )
    No
    3693
    79.8%
    97.4%
    Lower limb amputation - previous ( Adult forms only )
    Missing
    839
    18.1%
    Lower limb amputation - previous ( Adult forms only )
    Sum
    4629
    100.0%
Top of page


    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management method
    Diet Only
    224
    4.8%
5.0%
    Management method
    Insulin
    1650
    35.6%
    36.9%
    Management method
    Missing
    157
    3.4%
    Management method
    Nil
    1
    0.0%
    0.0%
    Management method
    Tablets
    1247
    26.9%
    27.9%
    Management method
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - Acarbose
    Yes
    38
    0.8%
1.1%
    Management Method - Acarbose
    No
    3359
    72.6%
    98.9%
    Management Method - Acarbose
    Missing
    1232
    26.6%
    Management Method - Acarbose
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - Diet Only
    Yes
    206
    4.5%
5.1%
    Management Method - Diet Only
    No
    3810
    82.3%
    94.9%
    Management Method - Diet Only
    Missing
    613
    13.2%
    Management Method - Diet Only
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - DPP4Inhibitor
    Yes
    190
    4.1%
5.6%
    Management Method - DPP4Inhibitor
    No
    3216
    69.5%
    94.4%
    Management Method - DPP4Inhibitor
    Missing
    1223
    26.4%
    Management Method - DPP4Inhibitor
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - Glitazone
    Yes
    146
    3.2%
4.3%
    Management Method - Glitazone
    No
    3269
    70.6%
    95.7%
    Management Method - Glitazone
    Missing
    1214
    26.2%
    Management Method - Glitazone
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - GLP1Agonist
    Yes
    80
    1.7%
2.4%
    Management Method - GLP1Agonist
    No
    3298
    71.2%
    97.6%
    Management Method - GLP1Agonist
    Missing
    1251
    27.0%
    Management Method - GLP1Agonist
    Sum
    4629
    100.0%
Top of page

    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - Insulin
    Yes
    3032
    65.5%
69.7%
    Management Method - Insulin
    No
    1321
    28.5%
    30.3%
    Management Method - Insulin
    Missing
    276
    6.0%
    Management Method - Insulin
    Sum
    4629
    100.0%
    Field
    Name
    Category
    Total
    Relative
    %*
    Median
    Mean
    SD
    Min
    Max
    Management Method - Metformin
    Yes
    2358
    50.9%
63.1%
    Management Method - Metformin
    No
    1380
    29.8%
    36.9%
    Management Method - Metformin
    Missing
    891
    19.2%
    Management Method - Metformin
    Sum
    4629
    100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Management Method - NilNo 2297 49.6% 100.0%
Management Method - NilMissing 2332 50.4%
Management Method - NilSum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Management Method - SulphonylureaYes1100 23.8% 31.1%
Management Method - SulphonylureaNo 2436 52.6% 68.9%
Management Method - SulphonylureaMissing 1093 23.6%
Management Method - SulphonylureaSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Microalbumin - All recordsuAlbumin3026 65.4% 4.00 65.30 306.70 0.10 6690.00
Microalbumin - All recordsMissing 1603 34.6%
Microalbumin - All recordsSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Microalbumin ( Only patients with defined uAlbumin units )uAlbumin2573 99.7% 4.00 62.40 314.10 0.10 6690.00
Microalbumin ( Only patients with defined uAlbumin units )Missing 9 0.3%
Microalbumin ( Only patients with defined uAlbumin units )Sum 2582 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Microalbumin units ( Only patients with a uAlbumin result )Missing 453 15.0%
Microalbumin units ( Only patients with a uAlbumin result )Ratio 1672 55.3% 65.0%
Microalbumin units ( Only patients with a uAlbumin result )mg/24 hr 81 2.7% 3.1%
Microalbumin units ( Only patients with a uAlbumin result )ug/min 232 7.7% 9.0%
Microalbumin units ( Only patients with a uAlbumin result )Sum 3026 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Myocardial infarction: new ( Adult forms only )Yes185 4.0% 4.8%
Myocardial infarction: new ( Adult forms only )No 3685 79.6% 95.2%
Myocardial infarction: new ( Adult forms only )Missing 759 16.4%
Myocardial infarction: new ( Adult forms only )Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Myocardial infarction: previous ( Adult forms only )Yes407 8.8% 12.0%
Myocardial infarction: previous ( Adult forms only )No 2993 64.7% 88.0%
Myocardial infarction: previous ( Adult forms only )Missing 1229 26.6%
Myocardial infarction: previous ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx - Fibrate Rx ( Adult forms only )Yes176 3.8% 5.2%
On Anti-Lipid Rx - Fibrate Rx ( Adult forms only )No 3218 69.5% 94.8%
On Anti-Lipid Rx - Fibrate Rx ( Adult forms only )Missing 1235 26.7%
On Anti-Lipid Rx - Fibrate Rx ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx - Statin Rx ( Adult forms only )Yes2466 53.3% 68.5%
On Anti-Lipid Rx - Statin Rx ( Adult forms only )No 1136 24.5% 31.5%
On Anti-Lipid Rx - Statin Rx ( Adult forms only )Missing 1027 22.2%
On Anti-Lipid Rx - Statin Rx ( Adult forms only )Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx - Statin Side Effects / Contraindicated ( Adult forms only )Yes88 1.9% 3.5%
On Anti-Lipid Rx - Statin Side Effects / Contraindicated ( Adult forms only )No 2395 51.7% 96.5%
On Anti-Lipid Rx - Statin Side Effects / Contraindicated ( Adult forms only )Missing 2146 46.4%
On Anti-Lipid Rx - Statin Side Effects / Contraindicated ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx -Ezetrol Rx ( Adult forms only )Yes146 3.2% 4.4%
On Anti-Lipid Rx -Ezetrol Rx ( Adult forms only )No 3186 68.8% 95.6%
On Anti-Lipid Rx -Ezetrol Rx ( Adult forms only )Missing 1297 28.0%
On Anti-Lipid Rx -Ezetrol Rx ( Adult forms only )Sum 4629 100.0%
Top of page


Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx Fish Oil Rx ( Adult forms only )Yes260 5.6% 10.6%
On Anti-Lipid Rx Fish Oil Rx ( Adult forms only )No 2203 47.6% 89.4%
On Anti-Lipid Rx Fish Oil Rx ( Adult forms only )Missing 2166 46.8%
On Anti-Lipid Rx Fish Oil Rx ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid Rx -Vytorin Rx ( Adult forms only )Yes93 2.0% 3.2%
On Anti-Lipid Rx -Vytorin Rx ( Adult forms only )No 2822 61.0% 96.8%
On Anti-Lipid Rx -Vytorin Rx ( Adult forms only )Missing 1714 37.0%
On Anti-Lipid Rx -Vytorin Rx ( Adult forms only )Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
On Anti-Lipid TherapyYes2786 60.2% 68.3%
On Anti-Lipid TherapyNo 129327.9% 31.7%
On Anti-Lipid TherapyMissing 550 11.9%
On Anti-Lipid TherapySum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Past history of ulcerationYes256 5.5% 6.8%
Past history of ulcerationNo 3531 76.3% 93.2%
Past history of ulcerationMissing 842 18.2%
Past history of ulcerationSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Peripheral NeuropathyYes1013 21.9% 22.9%
Peripheral NeuropathyNo 3414 73.8% 77.1%
Peripheral NeuropathyMissing 202 4.4%
Peripheral NeuropathySum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Peripheral Vascular Disease ( Adult forms only )Yes540 11.7% 12.3%
Peripheral Vascular Disease ( Adult forms only )No 3865 83.5% 87.7%
Peripheral Vascular Disease ( Adult forms only )Missing 224 4.8%
Peripheral Vascular Disease ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Pregnant: Currently ( Adult forms only , Females, 15-55 yrs only )Yes105 12.0% 13.5%
Pregnant: Currently ( Adult forms only , Females, 15-55 yrs only )No 670 76.4% 86.5%
Pregnant: Currently ( Adult forms only , Females, 15-55 yrs only )Missing 102 11.6%
Pregnant: Currently ( Adult forms only , Females, 15-55 yrs only )Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Referred to OphthalmologistYes2032 43.9% 62.9%
Referred to OphthalmologistNo 1201 25.9% 37.1%
Referred to OphthalmologistMissing 1396 30.2%
Referred to OphthalmologistSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Retina - left eyeDiabetes Abnormality775 16.7% 25.7%
Retina - left eyeMissing1613 34.8%
Retina - left eyeNon Diabetes Abnormality117 2.5% 3.9%
Retina - left eyeSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Retina - right eyeDiabetes Abnormality772 16.7% 25.6%
Retina - right eyeMissing1609 34.8%
Retina - right eyeNon Diabetes Abnormality112 2.4% 3.7%
Retina - right eyeSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Retinal cameraYes 751 16.2% 38.4%
Retinal cameraNo 1204 26.0% 61.6%
Retinal cameraMissing 2674 57.8%
Retinal cameraSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Severe hypoglycaemia ( Adult forms only )Yes 220 4.8% 5.7%
Severe hypoglycaemia ( Adult forms only )No 3657 79.0% 94.3%
Severe hypoglycaemia ( Adult forms only )Missing 752 16.2%
Severe hypoglycaemia ( Adult forms only )Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Sex of IndividualFemale2129 46.0% 46.2%
Sex of IndividualMale 2476 53.5% 53.8%
Sex of IndividualSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Smoker: currentlyYes 457 9.9% 13.5%
Smoker: currentlyNo 2920 63.1% 86.5%
Smoker: currentlyMissing 1252 27.0%
Smoker: currentlySum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Smoking StatusCurrent Smoker 457 9.9% 13.5%
Smoking StatusMissing 1254 27.1%
Smoking StatusNever Smoked 1830 39.5% 54.2%
Smoking StatusPast Smoker 1088 23.5% 32.2%
Smoking StatusSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Stroke: new ( Adult forms only )Yes 74 1.6% 1.9%
Stroke: new ( Adult forms only )No 3815 82.4% 98.1%
Stroke: new ( Adult forms only )Missing 740 16.0%
Stroke: new ( Adult forms only )Sum 4629 100.0%
Top of page


Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Stroke: previous ( Adult forms only )Yes 196 4.2% 5.8%
Stroke: previous ( Adult forms only )No 3195 69.0% 94.2%
Stroke: previous ( Adult forms only )Missing 1238 26.7%
Stroke: previous ( Adult forms only )Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Type of DiabetesType 1 1050 22.7% 23.0%
Type of DiabetesType 2 3357 72.5% 73.5%
Type of DiabetesGDM 88 1.9% 1.9%
Type of DiabetesDon’t Know 15 0.3% 0.3%
Type of DiabetesOther 59 1.3% 1.3%
Type of DiabetesMissing 60 1.3%
Type of DiabetesSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Visual acuity (Left)6/5 284 6.1% 12.6%
Visual acuity (Left)6/6 905 19.6% 40.3%
Visual acuity (Left)6/7.5 58 1.3% 2.6%
Visual acuity (Left)6/9 469 10.1% 20.9%
Visual acuity (Left)6/12 222 4.8% 9.9%
Visual acuity (Left)6/18 132 2.9% 5.9%
Visual acuity (Left)6/24 59 1.3% 2.6%
Visual acuity (Left)6/36 61 1.3% 2.7%
Visual acuity (Left)6/60 51 1.1% 2.3%
Visual acuity (Left)BL 2 0.0% 0.1%
Visual acuity (Left)CF 2 0.0% 0.1%
Visual acuity (Left)HM 2 0.0% 0.1%
Visual acuity (Left)Missing 2382 51.5%
Visual acuity (Left)Sum 4629 100.0%
Top of page

Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Visual acuity (Right)6/5 291 6.3% 12.9%
Visual acuity (Right)6/6 898 19.4% 39.9%
Visual acuity (Right)6/7.5 46 1.0% 2.0%
Visual acuity (Right)6/9 484 10.5% 21.5%
Visual acuity (Right)6/12 249 5.4% 11.1%
Visual acuity (Right)6/18 96 2.1% 4.3%
Visual acuity (Right)6/24 65 1.4% 2.9%
Visual acuity (Right)6/60 105 2.3% 4.7%
Visual acuity (Right)BL 10 0.2% 0.4%
Visual acuity (Right)CF 2 0.0% 0.1%
Visual acuity (Right)HM 2 0.0% 0.1%
Visual acuity (Right)Missing 2381 51.4%
Visual acuity (Right)Sum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
WeightWeight4455 96.2% 85.00 87.60 22.50 12.30 217.00
WeightMissing 1238 26.7%
WeightSum 4629 100.0%
Field NameCategoryTotalRelative

%*

MedianMeanSDMinMax
Year of diagnosisYearDx4481 96.8% 1999.00 1997.30 10.50 1947.00 2011.00
Year of diagnosisMissing 148 3.2%
Year of diagnosisSum 4629 100.0%

*: Relative % = % of the total excluding the missing values

30 November 2011

Top of page