Kizspy.me
PatientID for rows of the same doctor and the same diagnosis. Note that a doctor may have
many most common diagnoses and he/she could give one diagnosis for many different
patients. For example, Dr. David Davis has two different most common diagnosis 'Allergy'
and 'Flu' and he has already diagnosed the 'Allergy' for two distinct patients and the 'Flu' for
two distinct patients as shown in the following figure. Note that the results have in total 83
rows, the following figure shows as example only the 26 first rows of the results.
Diagnosis PatientID PatientFullName
DoctorID DoctorFullName
-23456789222315670122232
16
Dr. Chris Taylor
Arthritis 32
Laura Davis
16
Dr. Chris Taylor
Arthritis 46
Jane Wilson
1
Dr. David Davis
Allergy
41
John Davis
1
Dr. David Davis
Allergy
50
Laura Moore
1
Dr. David Davis
Flu
33
John Taylor
1
Dr. David Davis
Flu
67
Emma Taylor
2222255555FFFFFS222
21
Dr. David Miller
Asthma
19
Michael Miller
21
Dr. David Miller
Asthma
55
John Taylor
15
Dr. David Taylor
Dr. David Taylor
Dr. David Taylor
Dr. David Wilson
Dr. David Wilson
Dr. David Wilson
Dr. Emily Williams
Infection
39
David Jones
15
Dr. Emily Williams
Infection 69
Infection 77
Asthma 40
Asthma
46
Asthma 63
Diabetes 59
Diabetes 65
Chris Wilson
Jane Brown
Emily Taylor
Jane Wilson
Sarah Johnson
Emily Moore
Jane Miller
11
Dr. Emma Johnson Arthritis 57
James Davis
11
Dr. Emma Johnson Diabetes 72
Michael Moore
11
Dr. Emma Johnson Flu
49
David Wilson
11
Dr. Emma Johnson Infection
33
John Taylor
11
Dr. Emma Johnson
Migraine
Sarah Wilson
24
Dr. Emma Jones
Diabetes 38
Jane Williams
24
Dr. Emma Jones
Diabetes 66
Emma Smith
24
Dr. Emma Jones
Migraine 42
James Davis
Zoom
+ 95%
Close
