Patient Data
|
Patient ID
|
First Name
|
Last Name
|
Gender
|
Birth Date
|
Address
|
Age
|
Age Group
|
|
P001
|
Alice
|
Smith
|
F
|
1985-07-12
|
123 Oak St, NY
|
39
|
<40
|
|
P002
|
Bob
|
Johnson
|
M
|
1990-03-05
|
456 Maple Ave, TX
|
35
|
<40
|
|
P003
|
Clara
|
Davis
|
F
|
1978-11-22
|
789 Pine Rd, CA
|
46
|
40–60
|
|
P004
|
David
|
Wilson
|
M
|
1982-06-10
|
101 Elm St, FL
|
42
|
40–60
|
|
P005
|
Ella
|
Martinez
|
F
|
1995-01-15
|
202 Birch Blvd, WA
|
30
|
<40
|
|
P006
|
Frank
|
Brown
|
M
|
1988-09-30
|
303 Cedar Ct, IL
|
36
|
<40
|
Visit Data
|
Visit ID
|
Patient ID
|
Visit Date
|
Visit Type
|
Physician
|
|
V1001
|
P001
|
2025-03-15
|
Routine Check
|
Dr. Stone
|
|
V1002
|
P002
|
2025-03-20
|
Follow-Up
|
Dr. Lee
|
|
V1003
|
P001
|
2025-04-01
|
Urgent Care
|
Dr. White
|
|
V1004
|
P003
|
2025-04-05
|
Annual Physical
|
Dr. Brooks
|
|
V1005
|
P004
|
2025-04-07
|
Emergency
|
Dr. Khan
|
|
V1006
|
P005
|
2025-04-10
|
Routine Check
|
Dr. Patel
|
|
V1007
|
P006
|
2025-04-09
|
Follow-Up
|
Dr. West
|
Vital Signs Data
|
Vital ID
|
Visit ID
|
Patient ID
|
Blood Pressure
|
Heart Rate
|
Temperature
|
Respiration Rate
|
|
VT001
|
V1001
|
P001
|
120/80
|
72 bpm
|
98.6 °F
|
16 bpm
|
|
VT002
|
V1002
|
P002
|
130/85
|
78 bpm
|
99.1 °F
|
18 bpm
|
|
VT003
|
V1003
|
P001
|
140/90
|
85 bpm
|
100.2 °F
|
20 bpm
|
|
VT004
|
V1005
|
P004
|
135/88
|
80 bpm
|
98.9 °F
|
17 bpm
|
Visits Missing Vital Signs
Visits Missing Vital Signs
|
Visit ID
|
Patient ID
|
Visit Date
|
Visit Type
|
Physician
|
|
V1004
|
P003
|
2025-04-05
|
Annual Physical
|
Dr. Brooks
|
|
V1006
|
P005
|
2025-04-10
|
Routine Check
|
Dr. Patel
|
|
V1007
|
P006
|
2025-04-09
|
Follow-Up
|
Dr. West
|
Summary by Patient
Summary of Missing Vitals by Patient
|
Patient ID
|
Number of Missing Visits
|
First Missing Visit
|
Last Missing Visit
|
|
P003
|
1
|
2025-04-05
|
2025-04-05
|
|
P005
|
1
|
2025-04-10
|
2025-04-10
|
|
P006
|
1
|
2025-04-09
|
2025-04-09
|