Spreadsheet: 816114d1675371529-vlookup-and-duplicates-sample-list-v2
Sheet: SAMPLE DUPLICATE DATA

Patient ID | Sending Facility | Patient Name | DOB | PCP | Intk. Date | Intk. Time | Visit Type | Diagnosis | D/C Date | D/C Time | helpper column | Lookup
UNIQUE1 | Arizona General Hospital Mesa:HL7 | BOB | 1992-01-14 00:00:00 | DR. 1 | 2023-01-25 00:00:00 | 2023-02-25 00:00:00 | [NAME] | N/A | 2023-01-25 00:00:00 | 14:02:00
UNIQUE2 | Dignity Health St. Joseph's Hospital and Medical Center:HL7 | [NAME] | 1975-01-27 00:00:00 | DR. 2 | 2023-01-26 00:00:00 | 2023-02-25 01:00:00 | [NAME] | N/A | 2023-01-26 00:00:00 | 06:50:00
UNIQUE3 | [NAME]:HL7 | MARY | 1994-02-27 00:00:00 | DR. 3 | 2023-01-27 00:00:00 | 2023-02-25 02:00:00 | [NAME] | 13 WKS PREG- HEAVY BLEEDING | 2023-01-25 00:00:00 | 07:48:00
UNIQUE4 | Banner Thunderbird Medical  Center:HL7 | KELLY | 1990-12-20 00:00:00 | DR. 4 | 2023-01-28 00:00:00 | 2023-02-25 03:00:00 | [NAME] | N/A | 2023-01-25 00:00:00 | 19:41:00
UNIQUE5 | HonorHealth Thompson Peak Hospital:HL7 | BARB | 1999-10-11 00:00:00 | DR. 5 | 2023-01-29 00:00:00 | 2023-02-25 04:00:00 | [NAME] | N/A | 2023-01-25 00:00:00 | 20:52:00
UNIQUE6 | [NAME]:HL7 | AMY | 1990-08-07 00:00:00 | DR. 6 | 2023-01-30 00:00:00 | 2023-02-25 05:00:00 | Unspecified Admit | EDC 022723 EBP | 2023-01-25 00:00:00 | 17:53:00
UNIQUE7 | [NAME]:HL7 | KRISTY | 1977-01-02 00:00:00 | DR. 7 | 2023-01-31 00:00:00 | 2023-02-25 06:00:00 | Inpatient Discharge | R FEMORAL NECK FRACTURE | 2023-01-25 00:00:00 | 14:42:00
UNIQUE5 | [NAME]:HL7 | BARB | 1999-10-11 00:00:00 | DR. 5 | 2023-02-03 00:00:00 | 07:25:21.853000 | IP Admit | N/A | 2023-01-27 00:00:00 | 01:29:38.985000
UNIQUE6 | [NAME]:HL7 | AMY | 1990-08-07 00:00:00 | DR. 6 | 2023-02-03 00:00:00 | 15:40:58.107000 | IP Admit | N/A | 2023-01-27 00:00:00 | 06:00:15.617000
UNIQUE7 | [NAME]:HL7 | KRISTY | 1977-01-02 00:00:00 | DR. 7 | 2023-02-04 00:00:00 | 07:39:19.055000 | IP Admit | N/A | 2023-01-28 00:00:00 | 00:07:14.228000
UNIQUE1 | Arizona General Hospital Mesa:HL7 | BOB | 1992-01-14 00:00:00 | DR. 1 | 2023-02-05 00:00:00 | 17:11:01.896000 | IP Admit | N/A | 2023-01-29 00:00:00 | 05:52:36.110000
UNIQUE5 | [NAME]:HL7 | BARB | 1999-10-11 00:00:00 | DR. 5 | 2023-02-06 00:00:00 | 15:47:01.888000 | IP Admit | N/A | 2023-01-30 00:00:00 | 05:17:28.593000
UNIQUE6 | [NAME]:HL7 | AMY | 1990-08-07 00:00:00 | DR. 6 | 2023-02-06 00:00:00 | 16:40:33.017000 | IP Admit | N/A | 2023-01-30 00:00:00 | 12:55:22.966000
UNIQUE6 | HonorHealth Thompson Peak Hospital:HL7 | AMY | 1990-08-07 00:00:00 | DR. 6 | 2023-02-07 00:00:00 | 03:50:59.666000 | IP Admit | N/A | 2023-01-31 00:00:00 | 02:23:00.977000
UNIQUE2 | [NAME]:HL7 | [NAME] | 1975-01-27 00:00:00 | DR. 2 | 2023-02-08 00:00:00 | 12:13:31.545000 | IP Admit | N/A | 2023-02-01 00:00:00 | 01:53:21.330000
UNIQUE3 | [NAME]:HL7 | MARY | 1994-02-27 00:00:00 | DR. 3 | 2023-02-08 00:00:00 | 15:07:20.475000 | IP Admit | N/A | 2023-02-01 00:00:00 | 03:53:08.339000
UNIQUE5 | [NAME]:HL7 | BARB | 1999-10-11 00:00:00 | DR. 5 | 2023-02-09 00:00:00 | 21:49:27.919000 | IP Admit | N/A | 2023-02-02 00:00:00 | 04:56:32.352000
UNIQUE6 | [NAME]:HL7 | AMY | 1990-08-07 00:00:00 | DR. 6 | 2023-02-09 00:00:00 | 15:32:00.025000 | IP Admit | N/A | 2023-02-02 00:00:00 | 07:55:37.427000
UNIQUE4 | [NAME]:HL7 | KELLY | 1990-12-20 00:00:00 | DR. 4 | 2023-02-09 00:00:00 | 22:37:09.588000 | IP Admit | N/A | 2023-02-02 00:00:00 | 09:06:43.816000