ZA Excess Mortality: Surveillance Episodes with Clinic Records ZA011-000001 The MRC/Wits Rural Public Health and Health Transitions Research Unit The MRC/Wits Rural Public Health and Health Transitions Research Unit 2023 @ The MRC/Wits Rural Public Health and Health Transitions Research Unit 2023-12-18 Nesstar Publisher ZA011_RawCensoredEpisodesWithClinic_Public_v3 ZA Excess Mortality: Surveillance Episodes with Clinic Records ZA011-000001 The MRC/Wits Rural Public Health and Health Transitions Research Unit The MRC/Wits Rural Public Health and Health Transitions Research Unit 2023-12-18 Nesstar Publisher Bill & Melinda Gates Foundation, Seattle, WA South African Population Research Infrastructure Network, ZA Wellcome Trust, UK INV-030309 & INV-050361 INV-030309 & INV-050361 058893/Z/99/A; 069683/Z/02/Z; 085477/Z/08/Z; 085477/B/08/Z The MRC/Wits Rural Public Health and Health Transitions Research Unit 1.0 HIV Hypertension Diabetes South Africa Individuals The data used for the study comes from the Agincourt HDSS-clinic-hospital record linkage system. This system collects healthcare services utilisation data from the health facilities in the Agincourt HDSS study area and two district hospitals located some 25-60km away from the HDSS study area. The data collected through the record-linkage system for each individual is linked to the corresponding HDSS data for that individual using a combination of deterministic and probabilistic record linkage techniques applied to conventional personal identifiers 2015-2021 The surveillance data is collected from annual visits to households whereas clinical data is collected from the patient files at the health facilities for individuals who have consented to be part of the linkage platform. ZA011_RawCensoredEpisodesWithClinic_Public.NSDstat 17000 26 Nesstar 200801 Individual ID 17000 0 HDSS/Nodal Centre ID 17000 0 ZA011 17000 Country Id 17000 0 710 17000 Sex 17000 0 1 male 4929 2 female 12071 Episode 17000 0 1 17000 Start date 17000 2015-01-01 2020-06-15 2015-01-01 16419 2015-01-02 1 2015-01-03 1 2015-01-04 2 2015-01-05 1 2015-01-12 1 2015-01-15 36 2015-02-02 1 2015-02-10 1 2015-02-12 2 2015-02-15 8 2015-02-21 1 2015-03-02 1 2015-03-03 1 2015-03-09 1 2015-03-14 1 2015-03-15 13 2015-03-17 2 2015-03-20 1 2015-03-27 1 2015-04-10 1 2015-04-15 7 2015-04-20 1 2015-04-21 1 2015-05-04 1 2015-05-05 1 2015-05-15 11 2015-05-17 1 2015-05-20 1 2015-06-15 55 2015-06-26 1 2015-06-27 1 2015-07-04 1 2015-07-05 1 2015-07-11 1 2015-07-15 10 2015-08-01 1 2015-08-03 1 2015-08-10 1 2015-08-15 7 2015-08-17 3 2015-08-20 1 2015-09-01 2 2015-09-02 1 2015-09-06 1 2015-09-10 1 2015-09-15 16 2015-09-30 1 2015-10-11 1 2015-10-15 9 2015-11-03 2 2015-11-07 1 2015-11-15 11 2015-11-18 1 2015-11-22 1 2015-11-30 1 2015-12-04 1 2015-12-15 50 2015-12-19 1 2015-12-20 1 2015-12-23 1 2015-12-27 1 2016-01-01 4 2016-01-02 1 2016-01-09 1 2016-01-10 1 2016-01-15 3 2016-01-16 1 2016-01-25 1 2016-01-30 1 2016-02-10 1 2016-02-15 12 2016-02-21 1 2016-03-03 1 2016-03-15 10 2016-03-25 2 2016-04-15 4 2016-04-24 1 2016-05-12 1 2016-05-15 8 2016-05-30 2 2016-06-11 1 2016-06-12 1 2016-06-15 30 2016-06-26 1 2016-07-01 1 2016-07-02 1 2016-07-04 1 2016-07-08 2 2016-07-15 5 2016-07-30 1 2016-08-02 2 2016-08-15 6 2016-09-03 1 2016-09-05 1 2016-09-11 1 2016-09-15 1 2016-10-15 5 2016-11-01 1 2016-11-06 1 2016-11-15 3 2016-11-24 3 2016-12-15 7 2016-12-20 1 2016-12-26 1 2017-01-01 2 2017-01-02 1 2017-01-06 1 2017-01-07 1 2017-01-12 1 2017-01-13 1 2017-01-15 11 2017-01-29 1 2017-01-30 1 2017-02-02 1 2017-02-15 1 2017-03-09 1 2017-03-15 4 2017-04-15 1 2017-05-15 3 2017-06-15 10 2017-06-18 1 2017-07-02 1 2017-07-07 1 2017-07-12 1 2017-07-15 1 2017-07-18 2 2017-08-15 4 2017-09-01 1 2017-09-06 2 2017-09-15 3 2017-10-03 1 2017-10-06 1 2017-10-15 2 2017-11-02 1 2017-11-15 2 2017-11-28 1 2017-12-01 2 2017-12-05 2 2017-12-12 1 2017-12-15 5 2017-12-18 1 2017-12-22 2 2017-12-23 2 2017-12-25 2 2018-01-03 1 2018-01-12 1 2018-01-15 9 2018-01-29 1 2018-01-31 1 2018-02-15 2 2018-03-15 5 2018-04-11 1 2018-04-15 3 2018-05-15 2 2018-06-09 3 2018-06-10 1 2018-06-15 7 2018-06-30 1 2018-08-15 3 2018-09-15 2 2018-09-22 1 2018-10-02 2 2018-10-06 1 2018-10-15 2 2018-11-15 1 2018-12-15 5 2018-12-19 1 2018-12-25 1 2019-01-01 1 2019-03-15 3 2019-05-15 1 2019-06-15 1 2019-08-15 1 2019-09-15 1 2019-10-29 1 2019-11-01 1 2019-11-15 1 2020-01-01 1 2020-01-15 3 2020-03-15 1 2020-04-15 1 2020-06-15 1 End date 17000 2015-01-01 2022-12-31 Start Event 17000 0 BTH 890 ENT 7189 ENU 6554 IMG 2367 End Event 17000 0 DTH 1812 EXT 2402 OBS 11744 OMG 1042 Has HIV 17000 0 0 no 6514 1 yes 10486 Has Hypertension 17000 0 0 no 11308 1 yes 5692 Has Diabetes 17000 0 0 no 16137 1 yes 863 First HIV Visit 10868 2001-02-01 2022-12-19 Last Hiv Visit 10685 2014-05-14 2022-12-21 Last HIV results 8311 0 NEGATIVE 4308 POSITIVE 4000 UNKNOWN 3 Date of HIV diagnosis 7103 0 Year of HIV diagnosis 3524 0 1993 1 2000 3 2001 3 2002 4 2003 7 2004 19 2005 47 2006 91 2007 158 2008 219 2009 255 2010 328 2011 546 2012 434 2013 269 2014 275 2015 258 2016 161 2017 141 2018 69 2019 72 2020 37 2021 39 2022 88 First Hypertension Visit 6668 2002-09-30 2022-12-20 Last Hypertension Visit 6378 2013-02-11 2022-12-21 First Diabetes Visit 1199 2011-02-15 2022-12-13 2011-02-15 1 2014-01-05 1 2014-01-07 1 2014-01-10 1 2014-01-17 1 2014-01-29 1 2014-02-27 1 2014-03-03 1 2014-03-04 1 2014-03-05 4 2014-03-06 2 2014-03-11 1 2014-03-12 2 2014-03-13 3 2014-03-17 1 2014-03-18 2 2014-03-19 3 2014-03-20 3 2014-03-24 1 2014-03-25 5 2014-03-26 2 2014-03-28 1 2014-04-01 3 2014-04-02 2 2014-04-03 5 2014-04-04 6 2014-04-05 1 2014-04-07 3 2014-04-08 8 2014-04-09 3 2014-04-10 4 2014-04-11 1 2014-04-14 3 2014-04-15 5 2014-04-16 7 2014-04-17 9 2014-04-18 1 2014-04-22 2 2014-04-23 4 2014-04-24 5 2014-04-25 2 2014-04-29 7 2014-04-30 6 2014-05-02 3 2014-05-04 1 2014-05-05 9 2014-05-06 7 2014-05-07 2 2014-05-08 4 2014-05-09 10 2014-05-12 2 2014-05-13 9 2014-05-14 7 2014-05-15 9 2014-05-16 4 2014-05-17 1 2014-05-19 7 2014-05-20 7 2014-05-21 5 2014-05-22 9 2014-05-23 6 2014-05-25 1 2014-05-26 3 2014-05-27 7 2014-05-28 7 2014-05-29 8 2014-05-30 6 2014-06-01 2 2014-06-02 2 2014-06-03 4 2014-06-04 2 2014-06-05 2 2014-06-06 3 2014-06-07 1 2014-06-09 1 2014-06-10 3 2014-06-11 1 2014-06-12 8 2014-06-13 1 2014-06-14 2 2014-06-16 1 2014-06-17 3 2014-06-18 3 2014-06-19 1 2014-06-20 2 2014-06-23 1 2014-06-24 3 2014-06-25 4 2014-06-26 4 2014-06-30 1 2014-07-01 1 2014-07-02 2 2014-07-03 5 2014-07-04 1 2014-07-07 1 2014-07-08 1 2014-07-10 2 2014-07-11 1 2014-07-14 3 2014-07-16 1 2014-07-17 1 2014-07-18 2 2014-07-22 1 2014-07-23 2 2014-07-24 2 2014-07-25 1 2014-08-01 1 2014-08-05 1 2014-08-06 4 2014-08-07 3 2014-08-11 1 2014-08-13 2 2014-08-14 2 2014-08-21 2 2014-08-22 1 2014-08-28 1 2014-08-29 2 2014-09-01 1 2014-09-02 1 2014-09-03 1 2014-09-04 2 2014-09-11 1 2014-09-12 1 2014-09-16 2 2014-09-17 2 2014-09-18 1 2014-09-19 1 2014-09-21 1 2014-09-24 1 2014-09-25 2 2014-10-02 1 2014-10-03 3 2014-10-06 1 2014-10-07 1 2014-10-09 1 2014-10-13 2 2014-10-14 1 2014-10-16 3 2014-10-20 1 2014-10-21 1 2014-10-22 1 2014-10-24 1 2014-10-28 1 2014-10-30 2 2014-11-06 1 2014-11-07 1 2014-11-11 1 2014-11-12 1 2014-11-14 2 2014-11-20 1 2014-11-24 1 2014-11-25 3 2014-11-27 1 2014-12-09 1 2014-12-15 1 2014-12-17 1 2014-12-19 1 2014-12-22 1 2014-12-23 1 2015-01-02 1 2015-01-07 1 2015-01-08 2 2015-01-13 1 2015-01-14 2 2015-01-15 1 2015-01-17 1 2015-01-20 1 2015-01-21 1 2015-01-22 1 2015-01-26 1 2015-01-29 2 2015-01-30 1 2015-02-03 1 2015-02-07 1 2015-02-11 1 2015-02-14 1 2015-02-16 1 2015-02-17 2 2015-02-23 1 2015-02-24 2 2015-02-26 1 2015-03-02 1 2015-03-09 2 2015-03-10 1 2015-03-11 1 2015-03-12 1 2015-03-13 1 2015-03-17 1 2015-03-18 1 2015-03-19 1 2015-03-23 1 2015-03-26 4 2015-03-27 2 2015-03-30 1 2015-04-04 1 2015-04-09 1 2015-04-13 1 2015-04-14 1 2015-04-15 1 2015-04-16 1 2015-04-20 1 2015-04-21 1 2015-04-24 1 2015-04-25 1 2015-04-30 2 2015-05-05 1 2015-05-06 2 2015-05-11 1 2015-05-15 1 2015-05-18 1 2015-05-20 1 2015-05-21 1 2015-05-25 1 2015-05-26 1 2015-05-28 1 2015-05-29 1 2015-06-04 1 2015-06-05 1 2015-06-08 1 2015-06-17 2 2015-06-23 1 2015-06-24 1 2015-06-26 1 2015-07-01 1 2015-07-02 2 2015-07-03 1 2015-07-06 1 2015-07-09 1 2015-07-10 1 2015-07-14 1 2015-07-15 1 2015-07-17 3 2015-07-21 1 2015-07-22 1 2015-07-24 1 2015-07-31 1 2015-08-01 1 2015-08-10 1 2015-08-11 3 2015-08-12 1 2015-08-13 1 2015-08-22 1 2015-08-28 1 2015-09-08 1 2015-09-09 1 2015-09-10 2 2015-09-11 1 2015-09-13 1 2015-09-23 1 2015-10-08 2 2015-10-12 1 2015-10-26 1 2015-10-27 1 2015-11-11 1 2015-11-12 1 2015-11-16 1 2015-11-19 2 2015-11-25 1 2015-12-04 1 2015-12-17 1 2016-01-02 1 2016-01-07 1 2016-01-18 1 2016-01-21 1 2016-01-22 1 2016-01-28 1 2016-02-01 1 2016-02-04 1 2016-02-05 2 2016-02-08 1 2016-02-09 1 2016-02-10 1 2016-02-12 1 2016-02-15 1 2016-02-23 2 2016-02-24 1 2016-02-25 2 2016-03-02 1 2016-03-03 3 2016-03-08 1 2016-03-12 1 2016-03-22 1 2016-03-26 1 2016-03-29 2 2016-03-30 1 2016-03-31 2 2016-04-04 1 2016-04-13 1 2016-04-14 2 2016-04-16 1 2016-04-22 1 2016-04-25 1 2016-04-26 1 2016-05-03 1 2016-05-05 1 2016-05-06 1 2016-05-07 1 2016-05-11 2 2016-05-16 1 2016-05-20 1 2016-05-22 1 2016-05-24 2 2016-05-26 1 2016-06-03 1 2016-06-10 1 2016-06-13 1 2016-06-21 1 2016-06-23 2 2016-06-29 2 2016-06-30 1 2016-07-07 2 2016-07-08 1 2016-07-11 1 2016-07-19 1 2016-07-20 2 2016-07-21 1 2016-07-26 1 2016-08-08 1 2016-08-13 1 2016-08-31 1 2016-09-02 1 2016-09-09 1 2016-09-15 2 2016-09-20 1 2016-09-23 1 2016-09-25 1 2016-09-28 1 2016-09-29 1 2016-10-04 2 2016-10-11 1 2016-10-13 1 2016-10-24 1 2016-10-26 1 2016-10-27 1 2016-11-05 1 2016-11-12 1 2016-11-16 1 2016-11-18 1 2016-11-30 1 2016-12-01 2 2016-12-08 2 2016-12-20 1 2016-12-22 1 2016-12-30 1 2017-01-05 1 2017-01-12 1 2017-01-19 1 2017-01-24 1 2017-01-25 1 2017-01-31 1 2017-02-02 1 2017-02-09 1 2017-02-10 2 2017-02-19 1 2017-02-24 2 2017-02-28 1 2017-03-08 1 2017-03-10 1 2017-03-15 1 2017-03-22 1 2017-03-23 1 2017-03-28 2 2017-04-03 1 2017-04-04 1 2017-04-06 1 2017-04-13 1 2017-04-18 1 2017-04-24 1 2017-04-26 1 2017-04-28 1 2017-05-03 1 2017-05-08 1 2017-05-16 1 2017-05-17 1 2017-05-30 1 2017-06-05 1 2017-06-07 1 2017-06-08 1 2017-06-12 2 2017-06-20 1 2017-06-22 1 2017-06-28 1 2017-06-30 1 2017-07-02 1 2017-07-07 1 2017-07-10 1 2017-07-11 1 2017-07-17 2 2017-07-18 1 2017-07-21 1 2017-07-26 1 2017-07-30 1 2017-08-04 1 2017-08-11 1 2017-08-16 1 2017-08-18 1 2017-08-21 2 2017-08-22 1 2017-08-24 1 2017-09-04 1 2017-09-05 2 2017-09-08 2 2017-09-12 1 2017-09-13 1 2017-09-14 1 2017-09-27 1 2017-09-29 1 2017-10-02 1 2017-10-09 2 2017-10-11 1 2017-10-14 1 2017-10-16 1 2017-10-19 1 2017-10-20 1 2017-10-21 1 2017-11-01 1 2017-11-07 1 2017-11-15 1 2017-11-24 1 2017-12-05 1 2017-12-21 2 2017-12-28 1 2018-01-02 1 2018-01-05 1 2018-01-10 1 2018-01-11 1 2018-01-15 1 2018-01-17 2 2018-01-28 1 2018-01-30 1 2018-02-07 1 2018-02-08 1 2018-02-12 1 2018-02-13 2 2018-02-15 1 2018-02-18 1 2018-02-22 1 2018-03-01 1 2018-03-02 1 2018-03-08 1 2018-03-15 1 2018-03-16 1 2018-03-19 1 2018-04-04 1 2018-04-08 1 2018-04-10 2 2018-04-13 1 2018-04-16 2 2018-04-30 1 2018-05-02 1 2018-05-08 2 2018-05-14 2 2018-05-31 1 2018-06-04 1 2018-06-12 1 2018-06-13 1 2018-06-19 1 2018-06-20 1 2018-06-21 1 2018-06-29 1 2018-07-09 1 2018-07-23 1 2018-07-25 1 2018-07-26 1 2018-07-27 1 2018-07-30 1 2018-08-02 1 2018-08-13 1 2018-08-14 1 2018-08-15 1 2018-08-26 1 2018-08-27 1 2018-08-29 1 2018-09-12 1 2018-09-19 1 2018-09-25 2 2018-09-26 2 2018-10-01 1 2018-10-09 1 2018-10-11 1 2018-10-17 1 2018-10-18 1 2018-10-22 1 2018-10-23 1 2018-10-24 1 2018-10-26 1 2018-11-06 1 2018-11-12 2 2018-11-17 2 2018-11-19 1 2018-11-20 1 2018-11-30 1 2019-01-14 1 2019-01-18 1 2019-01-19 1 2019-01-23 1 2019-02-03 1 2019-02-05 2 2019-02-08 1 2019-02-12 2 2019-02-15 1 2019-02-20 1 2019-02-27 2 2019-03-01 1 2019-03-05 1 2019-03-11 1 2019-03-15 1 2019-03-21 1 2019-03-28 3 2019-03-29 1 2019-03-31 1 2019-04-01 1 2019-04-02 1 2019-04-08 1 2019-04-09 1 2019-04-11 1 2019-04-16 2 2019-04-17 1 2019-04-30 1 2019-05-02 1 2019-05-06 1 2019-05-12 1 2019-05-13 1 2019-05-17 1 2019-05-23 2 2019-06-05 1 2019-06-07 2 2019-06-13 1 2019-06-14 1 2019-06-16 1 2019-06-18 1 2019-06-28 1 2019-07-01 1 2019-07-03 2 2019-07-04 1 2019-07-10 1 2019-07-11 1 2019-07-18 1 2019-07-20 1 2019-07-30 1 2019-08-14 1 2019-08-15 2 2019-08-16 2 2019-08-27 1 2019-08-30 1 2019-09-02 1 2019-09-05 1 2019-09-06 1 2019-09-10 1 2019-09-11 2 2019-09-12 1 2019-09-16 1 2019-09-20 1 2019-09-25 2 2019-09-28 1 2019-09-30 1 2019-10-03 2 2019-10-04 1 2019-10-07 1 2019-10-09 1 2019-10-10 1 2019-10-11 1 2019-10-14 2 2019-10-17 1 2019-10-22 1 2019-10-24 1 2019-10-28 1 2019-10-31 1 2019-11-04 1 2019-11-13 1 2019-11-18 1 2019-12-06 1 2019-12-11 1 2019-12-12 1 2020-01-06 1 2020-01-08 1 2020-01-09 1 2020-01-14 1 2020-02-08 1 2020-02-11 1 2020-02-14 2 2020-02-24 1 2020-02-27 1 2020-03-02 1 2020-03-04 1 2020-03-08 1 2020-03-09 1 2020-03-10 1 2020-03-13 1 2020-03-19 1 2020-03-25 1 2020-03-26 1 2020-03-30 2 2020-04-01 1 2020-04-08 1 2020-04-17 1 2020-04-27 1 2020-05-01 1 2020-05-11 1 2020-05-14 2 2020-05-25 1 2020-05-28 2 2020-06-04 2 2020-06-05 1 2020-06-11 1 2020-06-23 1 2020-06-29 1 2020-07-03 1 2020-07-07 1 2020-07-27 1 2020-07-28 1 2020-07-29 1 2020-08-02 1 2020-08-04 1 2020-08-05 1 2020-08-13 1 2020-08-25 1 2020-08-27 2 2020-09-01 1 2020-09-03 1 2020-09-09 2 2020-09-22 1 2020-09-27 1 2020-09-28 1 2020-09-30 1 2020-10-01 1 2020-10-08 1 2020-10-14 1 2020-10-16 1 2020-10-19 1 2020-10-22 1 2020-10-28 1 2020-11-04 1 2020-11-06 1 2020-11-10 1 2020-11-11 3 2020-11-13 1 2020-11-26 1 2020-11-30 1 2020-12-02 1 2020-12-07 2 2020-12-08 1 2020-12-10 1 2020-12-15 1 2020-12-17 1 2020-12-23 1 2020-12-26 1 2021-01-05 1 2021-01-21 1 2021-01-22 1 2021-02-04 1 2021-02-09 1 2021-02-10 1 2021-02-11 1 2021-02-15 2 2021-02-17 1 2021-02-19 1 2021-02-23 1 2021-03-01 1 2021-03-02 1 2021-03-04 2 2021-03-05 1 2021-03-08 1 2021-03-09 1 2021-03-11 1 2021-03-30 1 2021-03-31 1 2021-04-01 1 2021-04-08 1 2021-04-12 1 2021-04-13 1 2021-04-14 1 2021-04-15 2 2021-04-19 1 2021-04-22 2 2021-04-28 1 2021-04-29 1 2021-05-04 1 2021-05-05 1 2021-05-17 1 2021-05-18 1 2021-05-21 1 2021-06-07 1 2021-06-11 1 2021-06-14 1 2021-06-18 1 2021-06-21 1 2021-06-24 2 2021-07-02 1 2021-07-06 1 2021-07-09 1 2021-07-14 1 2021-07-16 1 2021-07-20 1 2021-07-23 1 2021-07-29 1 2021-08-02 3 2021-08-05 1 2021-08-11 1 2021-08-12 1 2021-08-18 1 2021-08-19 1 2021-08-20 1 2021-08-23 1 2021-08-26 1 2021-08-31 1 2021-09-01 2 2021-09-02 1 2021-09-04 1 2021-09-06 1 2021-09-10 1 2021-09-13 1 2021-09-16 1 2021-09-23 2 2021-10-05 1 2021-10-15 1 2021-10-18 1 2021-10-19 1 2021-10-20 1 2021-10-21 1 2021-10-27 1 2021-11-03 2 2021-11-13 1 2021-11-18 2 2021-11-24 2 2021-11-29 2 2021-12-02 1 2021-12-07 1 2021-12-20 1 2021-12-22 1 2021-12-23 1 2022-01-03 1 2022-01-05 1 2022-01-06 1 2022-01-07 1 2022-01-12 1 2022-01-13 1 2022-01-20 1 2022-02-07 1 2022-02-08 1 2022-02-09 1 2022-02-12 1 2022-02-15 1 2022-02-18 1 2022-02-25 1 2022-03-03 2 2022-03-10 1 2022-03-11 1 2022-03-17 1 2022-03-28 1 2022-03-29 1 2022-04-04 1 2022-04-06 1 2022-04-07 1 2022-04-08 1 2022-04-11 1 2022-04-19 1 2022-04-28 2 2022-05-03 2 2022-05-04 1 2022-05-05 1 2022-05-10 2 2022-05-11 1 2022-05-13 1 2022-05-18 1 2022-05-19 1 2022-05-23 1 2022-05-24 1 2022-05-26 1 2022-05-30 1 2022-05-31 1 2022-06-01 1 2022-06-02 1 2022-06-03 1 2022-06-07 1 2022-06-10 1 2022-06-17 1 2022-06-20 1 2022-06-23 1 2022-06-24 2 2022-07-04 1 2022-07-06 3 2022-07-10 2 2022-07-19 1 2022-07-20 1 2022-07-21 1 2022-08-02 1 2022-08-04 1 2022-08-12 2 2022-08-16 1 2022-08-17 2 2022-08-19 1 2022-08-22 1 2022-08-23 1 2022-08-26 1 2022-08-29 2 2022-09-01 1 2022-09-04 1 2022-09-06 1 2022-09-08 1 2022-09-12 1 2022-09-15 1 2022-09-22 2 2022-09-27 1 2022-09-29 1 2022-10-11 1 2022-10-12 2 2022-10-17 1 2022-10-18 1 2022-10-20 1 2022-10-25 1 2022-11-02 2 2022-11-03 1 2022-11-04 1 2022-11-07 1 2022-11-11 1 2022-11-14 3 2022-11-15 1 2022-11-18 2 2022-11-22 1 2022-11-24 1 2022-11-28 2 2022-12-02 1 2022-12-08 1 2022-12-12 1 2022-12-13 1 Last Diabetes Visit 1060 2014-04-17 2022-12-21 2014-04-17 1 2014-05-19 1 2014-05-27 1 2014-06-03 1 2014-07-14 1 2014-07-24 1 2014-08-15 1 2014-09-16 1 2014-09-17 1 2014-10-01 1 2014-10-10 1 2014-10-22 1 2014-10-23 1 2014-12-01 1 2015-01-07 1 2015-01-14 1 2015-01-15 1 2015-01-20 1 2015-01-27 1 2015-02-07 1 2015-02-24 1 2015-02-25 1 2015-03-05 1 2015-03-11 1 2015-04-09 1 2015-04-15 1 2015-04-29 2 2015-05-07 1 2015-05-12 1 2015-05-14 1 2015-05-25 1 2015-05-28 1 2015-06-17 1 2015-07-02 1 2015-07-03 1 2015-08-04 1 2015-08-09 1 2015-08-11 1 2015-08-18 1 2015-08-27 1 2015-09-02 1 2015-09-08 1 2015-10-02 1 2015-10-06 1 2015-10-15 1 2015-11-03 1 2015-11-10 1 2015-11-26 1 2015-12-02 1 2015-12-11 1 2015-12-13 1 2016-01-18 1 2016-01-19 1 2016-01-26 1 2016-02-01 1 2016-02-02 1 2016-02-05 1 2016-02-16 1 2016-03-02 1 2016-03-03 1 2016-03-10 1 2016-04-04 1 2016-04-05 1 2016-04-07 1 2016-04-17 1 2016-04-26 1 2016-05-05 1 2016-05-06 1 2016-05-19 1 2016-05-24 1 2016-06-02 2 2016-06-21 1 2016-07-25 1 2016-07-26 1 2016-08-09 1 2016-08-25 1 2016-08-30 1 2016-09-15 1 2016-09-24 1 2016-11-03 1 2016-11-04 1 2016-11-07 1 2016-11-09 1 2016-11-18 1 2016-11-28 1 2016-12-12 1 2016-12-19 1 2017-01-13 1 2017-02-14 1 2017-02-25 1 2017-02-28 1 2017-03-02 1 2017-03-14 1 2017-03-20 1 2017-03-23 1 2017-04-12 1 2017-05-11 1 2017-06-01 1 2017-06-03 1 2017-06-12 1 2017-06-14 1 2017-06-28 1 2017-07-06 1 2017-07-18 1 2017-08-07 1 2017-08-10 1 2017-08-22 1 2017-09-05 1 2017-09-11 1 2017-09-13 1 2017-10-05 1 2017-10-11 1 2017-11-11 1 2017-11-25 1 2017-11-30 1 2017-12-05 1 2017-12-14 1 2018-01-23 2 2018-02-27 2 2018-03-08 2 2018-04-06 1 2018-04-10 1 2018-04-13 1 2018-04-16 1 2018-04-17 1 2018-04-24 1 2018-04-25 1 2018-04-26 1 2018-05-14 1 2018-06-01 1 2018-06-08 1 2018-06-29 1 2018-07-12 1 2018-07-16 1 2018-07-17 2 2018-07-19 1 2018-07-20 1 2018-07-26 1 2018-07-27 1 2018-08-02 1 2018-08-05 1 2018-08-08 1 2018-08-22 1 2018-08-23 1 2018-08-31 1 2018-09-04 1 2018-09-05 3 2018-09-19 1 2018-10-12 1 2018-10-22 1 2018-10-24 1 2018-10-25 1 2018-11-15 1 2018-11-16 1 2019-01-06 1 2019-01-23 1 2019-01-29 1 2019-02-20 1 2019-03-01 1 2019-03-13 1 2019-03-28 1 2019-03-29 1 2019-04-04 1 2019-04-10 2 2019-04-24 1 2019-05-07 1 2019-05-11 1 2019-05-15 1 2019-05-22 1 2019-05-23 1 2019-05-24 1 2019-06-04 1 2019-06-05 1 2019-06-06 1 2019-06-18 2 2019-06-19 2 2019-06-20 1 2019-06-21 1 2019-06-27 1 2019-07-03 2 2019-07-09 1 2019-07-12 1 2019-07-17 1 2019-07-21 1 2019-07-31 1 2019-08-05 1 2019-08-13 1 2019-08-14 1 2019-08-19 1 2019-09-04 1 2019-09-05 1 2019-09-11 1 2019-09-18 1 2019-09-19 1 2019-09-20 1 2019-10-10 1 2019-10-21 1 2019-10-31 1 2019-11-01 1 2019-11-04 1 2019-11-05 1 2019-11-06 2 2019-11-11 1 2019-11-20 1 2019-11-22 2 2019-12-04 1 2019-12-17 1 2020-01-07 1 2020-01-13 1 2020-01-14 2 2020-01-17 1 2020-01-20 1 2020-01-21 1 2020-01-30 1 2020-02-20 1 2020-02-25 1 2020-03-04 2 2020-04-07 1 2020-04-23 1 2020-04-30 1 2020-05-01 1 2020-05-07 1 2020-05-20 1 2020-05-21 1 2020-05-26 1 2020-05-27 1 2020-06-11 1 2020-06-12 1 2020-06-21 1 2020-06-22 1 2020-06-23 1 2020-06-25 1 2020-06-29 1 2020-07-09 1 2020-07-19 1 2020-07-22 1 2020-07-28 1 2020-08-18 1 2020-08-28 1 2020-09-14 1 2020-09-16 1 2020-09-17 1 2020-09-23 1 2020-09-28 1 2020-10-08 1 2020-10-09 1 2020-10-15 1 2020-10-20 2 2020-10-24 1 2020-11-01 1 2020-11-05 1 2020-11-08 1 2020-11-10 1 2020-11-18 2 2020-11-19 1 2020-11-24 1 2020-11-28 1 2020-12-08 1 2020-12-10 3 2020-12-11 2 2020-12-15 1 2020-12-17 1 2020-12-18 1 2021-01-11 1 2021-01-15 1 2021-01-20 1 2021-01-21 1 2021-01-27 1 2021-02-10 1 2021-02-18 1 2021-02-23 1 2021-03-15 1 2021-03-24 1 2021-04-09 1 2021-04-15 1 2021-04-16 1 2021-04-23 1 2021-04-26 1 2021-05-04 1 2021-05-06 1 2021-05-07 2 2021-05-19 1 2021-05-24 1 2021-05-27 1 2021-06-07 1 2021-06-08 2 2021-06-15 1 2021-06-18 1 2021-06-28 1 2021-07-01 1 2021-07-02 1 2021-07-05 1 2021-07-06 1 2021-07-14 1 2021-07-23 1 2021-07-29 1 2021-08-02 1 2021-08-03 1 2021-08-10 1 2021-08-17 1 2021-08-18 1 2021-08-20 2 2021-09-02 1 2021-09-04 1 2021-09-15 1 2021-09-16 1 2021-09-27 1 2021-10-04 1 2021-10-07 2 2021-10-08 3 2021-10-13 3 2021-10-18 1 2021-11-03 1 2021-11-10 1 2021-11-15 1 2021-11-19 1 2021-12-02 1 2021-12-09 1 2021-12-10 1 2021-12-13 1 2021-12-23 1 2021-12-29 1 2022-01-03 1 2022-01-10 2 2022-01-12 2 2022-01-13 1 2022-01-14 1 2022-01-18 1 2022-01-19 1 2022-01-24 1 2022-01-28 1 2022-01-31 2 2022-02-11 1 2022-02-16 1 2022-02-17 1 2022-02-24 1 2022-02-25 3 2022-03-03 1 2022-03-07 1 2022-03-11 2 2022-03-15 1 2022-03-16 1 2022-03-22 1 2022-03-23 1 2022-03-25 1 2022-03-28 1 2022-03-29 1 2022-03-31 1 2022-04-19 2 2022-05-03 1 2022-05-04 4 2022-05-10 1 2022-05-12 2 2022-05-13 1 2022-05-18 1 2022-05-19 4 2022-05-20 1 2022-05-23 3 2022-05-26 1 2022-05-31 1 2022-06-01 1 2022-06-03 5 2022-06-06 2 2022-06-07 1 2022-06-08 1 2022-06-13 1 2022-06-14 1 2022-06-15 1 2022-06-17 2 2022-06-20 1 2022-06-21 1 2022-06-24 1 2022-06-27 2 2022-06-28 1 2022-06-29 1 2022-06-30 2 2022-07-04 1 2022-07-05 3 2022-07-06 4 2022-07-08 1 2022-07-13 2 2022-07-14 2 2022-07-17 1 2022-07-19 1 2022-07-20 2 2022-07-21 1 2022-07-23 1 2022-07-25 1 2022-07-26 1 2022-07-27 1 2022-07-28 1 2022-07-29 2 2022-08-01 2 2022-08-02 1 2022-08-03 1 2022-08-04 1 2022-08-08 3 2022-08-11 2 2022-08-12 1 2022-08-15 2 2022-08-16 4 2022-08-18 2 2022-08-19 1 2022-08-25 4 2022-08-26 2 2022-08-29 1 2022-08-31 5 2022-09-01 1 2022-09-05 1 2022-09-06 1 2022-09-07 2 2022-09-08 6 2022-09-09 2 2022-09-12 2 2022-09-13 1 2022-09-14 2 2022-09-15 3 2022-09-16 1 2022-09-19 2 2022-09-20 2 2022-09-21 5 2022-09-22 2 2022-09-27 4 2022-09-28 3 2022-09-29 6 2022-09-30 1 2022-10-03 4 2022-10-04 1 2022-10-05 5 2022-10-06 5 2022-10-07 5 2022-10-10 9 2022-10-11 8 2022-10-12 4 2022-10-13 5 2022-10-14 10 2022-10-15 1 2022-10-17 6 2022-10-18 6 2022-10-19 9 2022-10-20 2 2022-10-21 3 2022-10-24 5 2022-10-25 2 2022-10-26 6 2022-10-27 10 2022-10-28 9 2022-10-31 4 2022-11-01 11 2022-11-02 9 2022-11-03 8 2022-11-04 5 2022-11-05 1 2022-11-07 8 2022-11-08 10 2022-11-09 8 2022-11-10 11 2022-11-11 9 2022-11-14 24 2022-11-15 12 2022-11-16 9 2022-11-17 8 2022-11-18 12 2022-11-19 1 2022-11-21 9 2022-11-22 11 2022-11-23 14 2022-11-24 16 2022-11-25 10 2022-11-26 1 2022-11-28 16 2022-11-29 4 2022-11-30 8 2022-12-01 9 2022-12-02 12 2022-12-05 14 2022-12-06 16 2022-12-07 9 2022-12-08 15 2022-12-09 10 2022-12-12 20 2022-12-13 18 2022-12-14 12 2022-12-15 15 2022-12-16 1 2022-12-19 12 2022-12-20 9 2022-12-21 1 Clinic Visit Year 17000 0 2001 2022 2018.847 2.554 Days 17000 0 1 2922 2383.493 830.407 Date of birth 17000 1900-03-11 2015-08-03 Date of death 1820 2015-01-01 2022-12-31 Died ? 17000 0 0 no 15188 1 yes 1812