ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
Non Blank9213292132921329213292132921329213292132902899213292132921329028992132921329213292132
2
Blanks0092132921320000184300018430000
3
Unique921323857173945740000328553319120818265010517963441/22/202601-22-2026
4
Duplicates092129641552675521325927758941713149028792126920829212290284903369212992128921281001
5
I need to check the Message_ID serial numbers for each Hospital
23
6
7
Message_IDEvent_CodeMessage_TimeArrival_TimeVisit_NumberMRNPatient_NameDOBGenderHospital_SiteAttending_DoctorDiagnosis_CodeDiagnosis_DescriptionRoom_IDBed_StatusAdmit_SourcePayer_StatusID_SuffixNew_MRNMessage_IDEvent_CodeMessage_TimeArrival_TimeVisit_NumberMRNPatient_NameDOBGenderHospital_SiteAttending_DoctorDiagnosis_CodeDiagnosis_DescriptionRoom_IDBed_StatusAdmit_SourcePayer_StatusID_SuffixNew_MRN
8
MSG-17566-1A015/22/23 2:065/22/23 1:47VIS-117566MRN-1000Christopher Dawson11/22/1940MSouth Trauma CenterGina MooreS82.4Fracture of FibulaRM-845 OccupiedWalk-InMedicare1MRN-1000-01MSG-0-1A017/22/23 2:077/21/23 20:55VIS-100000MRN-32380Christopher Dawson11/22/1940MaleSouth Trauma CenterGina MooreS824Fracture Of Fibula0OccupiedWalk-InMedicare1MRN-1000-01
9
MSG-17566-2A025/27/23 2:065/22/23 1:47VIS-117566MRN-1000Christopher Dawson11/22/1940MSouth Trauma CenterGina MooreS82.4Fracture of FibulaRM-215OccupiedEmergencyMedicaid1MRN-1000-01MSG-0-2A027/22/23 2:077/21/23 20:55VIS-100000MRN-32380Christopher Dawson11/22/1940MaleSouth Trauma CenterGina MooreS824Fracture Of Fibula1OccupiedEmergencyMedicaid1MRN-1000-01
10
MSG-17566-3A035/28/23 2:065/22/23 1:47VIS-117566MRN-1000Christopher Dawson11/22/1940MSouth Trauma CenterGina MooreS82.4Fracture of FibulaRM-845 FreeTransferPrivate1MRN-1000-01MSG-0-3A037/25/23 2:077/21/23 20:55VIS-100000MRN-32380Christopher Dawson11/22/1940MaleSouth Trauma CenterGina MooreS824Fracture Of Fibula0FreeTransferPrivate1MRN-1000-01
11
MSG-8068-1A011/2/21 0:431/1/21 20:26VIS-108068MRN-10005Alexander Lewis6/8/2005MNorth General HospitalSarah FastS82.4Fracture of FibulaRM-808OccupiedClinic ReferralSelf-Pay1MRN-10005-01MSG-1-1A0112/18/21 18:2412/18/21 17:28VIS-100001MRN-47404Alexander Lewis6/8/2005MaleNorth General HospitalSarah FastS824Fracture Of Fibula0OccupiedClinic ReferralSelf-Pay1MRN-10005-01
12
MSG-8068-2A021/2/21 0:431/1/21 20:26VIS-108068MRN-10005Alexander Lewis6/8/2005MNorth General HospitalSarah FastS82.4Fracture of FibulaRM-530OccupiedClinic ReferralMedicaid1MRN-10005-01MSG-1-2A0212/18/21 18:2412/18/21 17:28VIS-100001MRN-47404Alexander Lewis6/8/2005MaleNorth General HospitalSarah FastS824Fracture Of Fibula1OccupiedClinic ReferralMedicaid1MRN-10005-01
13
MSG-8068-3A031/3/21 0:431/1/21 20:26VIS-108068MRN-10005Alexander Lewis6/8/2005MNorth General HospitalSarah FastS82.4Fracture of FibulaRM-808FreeEmergencyMedicaid1MRN-10005-01MSG-1-3A0312/19/21 18:2412/18/21 17:28VIS-100001MRN-47404Alexander Lewis6/8/2005MaleNorth General HospitalSarah FastS824Fracture Of Fibula0FreeEmergencyMedicaid1MRN-10005-01
14
MSG-32671-1A019/3/23 10:329/3/23 9:34VIS-132671MRN-10005Katherine Williams1/4/1957FCity ClinicCristian SantosI10Essential HypertensionRM-273 OccupiedClinic ReferralMedicare2MRN-10005-02MSG-2-1A014/14/23 1:324/14/23 0:50VIS-100002MRN-81058Katherine Williams1/4/1957FemaleCity ClinicCristian SantosI10Essential Hypertension0OccupiedClinic ReferralMedicare2MRN-10005-02
15
MSG-32671-3A039/6/23 10:329/3/23 9:34VIS-132671MRN-10005Katherine Williams1/4/1957FCity ClinicCristian SantosI10Essential HypertensionRM-273 FreeEmergencyMedicaid2MRN-10005-02MSG-2-3A034/18/23 1:324/14/23 0:50VIS-100002MRN-81058Katherine Williams1/4/1957FemaleCity ClinicCristian SantosI10Essential Hypertension0FreeEmergencyMedicaid2MRN-10005-02
16
MSG-24787-1A0111/4/21 18:5911/4/21 18:00VIS-124787MRN-10011Ashley Perez7/5/1950FSouth Trauma CenterJames CarefulJ12.89Viral PneumoniaRM-344OccupiedClinic ReferralMedicare1MRN-10011-01MSG-3-1A018/16/23 18:398/16/23 12:06VIS-100003MRN-71768Ashley Perez7/5/1950FemaleSouth Trauma CenterJames CarefulJ1289Viral Pneumonia0OccupiedClinic ReferralMedicare1MRN-10011-01
17
MSG-24787-3A0311/14/21 18:5911/4/21 18:00VIS-124787MRN-10011Ashley Perez7/5/1950FSouth Trauma CenterJames CarefulJ12.89Viral PneumoniaRM-344FreeWalk-InMedicare1MRN-10011-01MSG-3-3A038/22/23 18:398/16/23 12:06VIS-100003MRN-71768Ashley Perez7/5/1950FemaleSouth Trauma CenterJames CarefulJ1289Viral Pneumonia0FreeWalk-InMedicare1MRN-10011-01
18
MSG-17984-1A013/3/21 5:003/3/21 4:30VIS-117984MRN-10014Eric Bell9/21/1957MSouth Trauma CenterGina MooreI10Essential HypertensionRM-619OccupiedClinic ReferralMedicare1MRN-10014-01MSG-4-1A019/16/21 12:419/16/21 6:40VIS-100004MRN-77337Eric Bell9/21/1957MaleSouth Trauma CenterGina MooreI10Essential Hypertension0OccupiedClinic ReferralMedicare1MRN-10014-01
19
MSG-17984-2A023/6/21 5:003/3/21 4:30VIS-117984MRN-10014Eric Bell9/21/1957MSouth Trauma CenterGina MooreI10Essential HypertensionRM-344OccupiedWalk-InMedicaid1MRN-10014-01MSG-4-3A039/17/21 12:419/16/21 6:40VIS-100004MRN-77337Eric Bell9/21/1957MaleSouth Trauma CenterGina MooreI10Essential Hypertension1OccupiedWalk-InMedicaid1MRN-10014-01
20
MSG-17984-3A033/7/21 5:003/3/21 4:30VIS-117984MRN-10014Eric Bell9/21/1957MSouth Trauma CenterGina MooreI10Essential HypertensionRM-619FreeTransferMedicare1MRN-10014-01MSG-5-1A0112/24/23 15:1612/24/23 6:26VIS-100005MRN-70165Eric Bell9/21/1957MaleSouth Trauma CenterGina MooreI10Essential Hypertension0FreeTransferMedicare1MRN-10014-01
21
MSG-32504-1A012/23/21 2:262/23/21 1:42VIS-132504MRN-10014Gregory Wells8/14/1994MSouth Trauma CenterCristian SantosS82.4Fracture of FibulaRM-663OccupiedTransferPrivate2MRN-10014-02MSG-5-3A0312/30/23 15:1612/24/23 6:26VIS-100005MRN-70165Gregory Wells8/14/1994MaleSouth Trauma CenterCristian SantosS824Fracture Of Fibula0OccupiedTransferPrivate2MRN-10014-02
22
MSG-32504-3A032/25/21 2:262/23/21 1:42VIS-132504MRN-10014Gregory Wells8/14/1994MSouth Trauma CenterCristian SantosS82.4Fracture of FibulaRM-663FreeClinic ReferralSelf-Pay2MRN-10014-02MSG-6-1A014/1/22 1:154/1/22 0:38VIS-100006MRN-26306Gregory Wells8/14/1994MaleSouth Trauma CenterCristian SantosS824Fracture Of Fibula0FreeClinic ReferralSelf-Pay2MRN-10014-02
23
MSG-33888-1A015/31/21 3:145/30/21 22:48VIS-133888MRN-10019Terri Nguyen6/11/1986MNorth General HospitalGina MooreS82.4Fracture of FibulaRM-937OccupiedEmergencyMedicaid1MRN-10019-01MSG-6-2A024/1/22 1:154/1/22 0:38VIS-100006MRN-26306Terri Nguyen6/11/1986MaleNorth General HospitalGina MooreS824Fracture Of Fibula0OccupiedEmergencyMedicaid1MRN-10019-01
24
MSG-33888-3A036/4/21 3:145/30/21 22:48VIS-133888MRN-10019Terri Nguyen6/11/1986MNorth General HospitalGina MooreS82.4Fracture of FibulaRM-937FreeEmergencySelf-Pay1MRN-10019-01MSG-6-3A034/7/22 1:154/1/22 0:38VIS-100006MRN-26306Terri Nguyen6/11/1986MaleNorth General HospitalGina MooreS824Fracture Of Fibula0FreeEmergencySelf-Pay1MRN-10019-01
25
MSG-28547-1A014/1/21 12:174/1/21 3:37VIS-128547MRN-10024David Hill2/19/1940MNorth General HospitalSarah FastI10Essential HypertensionRM-246OccupiedTransferPrivate1MRN-10024-01MSG-7-1A013/27/22 3:513/27/22 3:05VIS-100007MRN-40566David Hill2/19/1940MaleNorth General HospitalSarah FastI10Essential Hypertension0OccupiedTransferPrivate1MRN-10024-01
26
MSG-28547-3A034/2/21 12:174/1/21 3:37VIS-128547MRN-10024David Hill2/19/1940MNorth General HospitalSarah FastI10Essential HypertensionRM-246FreeTransferPrivate1MRN-10024-01MSG-7-3A033/29/22 3:513/27/22 3:05VIS-100007MRN-40566David Hill2/19/1940MaleNorth General HospitalSarah FastI10Essential Hypertension0FreeTransferPrivate1MRN-10024-01
27
MSG-20506-1A012/19/23 14:172/19/23 13:41VIS-120506MRN-10024Sara Miller6/29/1983MSouth Trauma Centerdr angie hendersonJ12.89Viral PneumoniaRM-995OccupiedEmergencyMedicaid2MRN-10024-02MSG-8-1A011/6/22 5:021/6/22 4:40VIS-100008MRN-25828Sara Miller6/29/1983MaleSouth Trauma CenterAngie HendersonJ1289Viral Pneumonia0OccupiedEmergencyMedicaid2MRN-10024-02
28
MSG-20506-3A032/25/23 14:172/19/23 13:41VIS-120506MRN-10024Sara Miller6/29/1983MSouth Trauma Centerdr angie hendersonJ12.89Viral PneumoniaRM-995FreeTransferMedicaid2MRN-10024-02MSG-8-3A031/9/22 5:021/6/22 4:40VIS-100008MRN-25828Sara Miller6/29/1983MaleSouth Trauma CenterAngie HendersonJ1289Viral Pneumonia0FreeTransferMedicaid2MRN-10024-02
29
MSG-37628-1A017/9/21 23:467/9/21 23:29VIS-137628MRN-10026Anita Wilson5/19/1935MCity ClinicNoah RhodesE11.9Type 2 DiabetesRM-178 OccupiedTransferMedicare1MRN-10026-01MSG-9-1A015/16/23 2:265/15/23 15:46VIS-100009MRN-33594Anita Wilson5/19/1935MaleCity ClinicNoah RhodesE119Type 2 Diabetes0OccupiedTransferMedicare1MRN-10026-01
30
MSG-37628-3A037/12/21 23:467/9/21 23:29VIS-137628MRN-10026Anita Wilson5/19/1935MCity ClinicNoah RhodesE11.9Type 2 DiabetesRM-178 FreeClinic ReferralSelf-Pay1MRN-10026-01MSG-9-3A035/21/23 2:265/15/23 15:46VIS-100009MRN-33594Anita Wilson5/19/1935MaleCity ClinicNoah RhodesE119Type 2 Diabetes0FreeClinic ReferralSelf-Pay1MRN-10026-01
31
MSG-11077-1A017/14/22 4:197/14/22 3:51VIS-111077MRN-10028Mr. Timothy Garcia5/10/1969MCity ClinicAngie HendersonE11.9Type 2 DiabetesRM-396OccupiedEmergencyMedicare1MRN-10028-01MSG-10-1A011/25/22 5:251/24/22 20:26VIS-100010MRN-79570Mr. Timothy Garcia5/10/1969MaleCity ClinicAngie HendersonE119Type 2 Diabetes0OccupiedEmergencyMedicare1MRN-10028-01
32
MSG-11077-3A037/20/22 4:197/14/22 3:51VIS-111077MRN-10028Mr. Timothy Garcia5/10/1969MCity ClinicAngie HendersonE11.9Type 2 DiabetesRM-396FreeClinic ReferralSelf-Pay1MRN-10028-01MSG-10-2A021/27/22 5:251/24/22 20:26VIS-100010MRN-79570Mr. Timothy Garcia5/10/1969MaleCity ClinicAngie HendersonE119Type 2 Diabetes0FreeClinic ReferralSelf-Pay1MRN-10028-01
33
MSG-12420-1A0110/13/23 4:5910/12/23 21:04VIS-112420MRN-10032Katie Miller12/21/1962MNorth General HospitalSarah FastE11.9Type 2 DiabetesRM-731 OccupiedTransferSelf-Pay1MRN-10032-01MSG-10-3A031/30/22 5:251/24/22 20:26VIS-100010MRN-79570Katie Miller12/21/1962MaleNorth General HospitalSarah FastE119Type 2 Diabetes0OccupiedTransferSelf-Pay1MRN-10032-01
34
MSG-12420-2A0210/14/23 4:5910/12/23 21:04VIS-112420MRN-10032Katie Miller12/21/1962MNorth General HospitalSarah FastE11.9Type 2 DiabetesRM-593OccupiedEmergencyPrivate1MRN-10032-01MSG-11-1A014/9/23 14:394/9/23 13:40VIS-100011MRN-2641Katie Miller12/21/1962MaleNorth General HospitalSarah FastE119Type 2 Diabetes1OccupiedEmergencyPrivate1MRN-10032-01
35
MSG-12420-3A0310/15/23 4:5910/12/23 21:04VIS-112420MRN-10032Katie Miller12/21/1962MNorth General HospitalSarah FastE11.9Type 2 DiabetesRM-731 FreeEmergencyMedicaid1MRN-10032-01MSG-11-2A024/11/23 14:394/9/23 13:40VIS-100011MRN-2641Katie Miller12/21/1962MaleNorth General HospitalSarah FastE119Type 2 Diabetes0FreeEmergencyMedicaid1MRN-10032-01
36
MSG-20676-1A018/28/22 3:468/28/22 2:49VIS-120676MRN-10033Kim Conley6/25/2007MCity ClinicDaniel WagnerE11.9Type 2 DiabetesRM-704OccupiedClinic ReferralPrivate1MRN-10033-01MSG-11-3A034/15/23 14:394/9/23 13:40VIS-100011MRN-2641Kim Conley6/25/2007MaleCity ClinicDaniel WagnerE119Type 2 Diabetes0OccupiedClinic ReferralPrivate1MRN-10033-01
37
MSG-20676-2A029/1/22 3:468/28/22 2:49VIS-120676MRN-10033Kim Conley6/25/2007MCity ClinicDaniel WagnerE11.9Type 2 DiabetesRM-844OccupiedTransferMedicare1MRN-10033-01MSG-12-1A014/8/21 23:094/8/21 22:11VIS-100012MRN-34860Kim Conley6/25/2007MaleCity ClinicDaniel WagnerE119Type 2 Diabetes1OccupiedTransferMedicare1MRN-10033-01
38
MSG-20676-3A039/3/22 3:468/28/22 2:49VIS-120676MRN-10033Kim Conley6/25/2007MCity ClinicDaniel WagnerE11.9Type 2 DiabetesRM-704FreeWalk-InPrivate1MRN-10033-01MSG-12-3A034/11/21 23:094/8/21 22:11VIS-100012MRN-34860Kim Conley6/25/2007MaleCity ClinicDaniel WagnerE119Type 2 Diabetes0FreeWalk-InPrivate1MRN-10033-01
39
MSG-1244-1A013/8/22 10:333/8/22 10:07VIS-101244MRN-10036Nathaniel Stewart2/10/1974FSouth Trauma CenterSarah FastS82.4Fracture of FibulaRM-514 OccupiedWalk-InMedicaid1MRN-10036-01MSG-13-1A019/9/23 14:549/9/23 14:38VIS-100013MRN-91280Nathaniel Stewart2/10/1974FemaleSouth Trauma CenterSarah FastS824Fracture Of Fibula0OccupiedWalk-InMedicaid1MRN-10036-01
40
MSG-1244-3A033/10/22 10:333/8/22 10:07VIS-101244MRN-10036Nathaniel Stewart2/10/1974FSouth Trauma CenterSarah FastS82.4Fracture of FibulaRM-514 FreeWalk-InPrivate1MRN-10036-01MSG-13-3A039/11/23 14:549/9/23 14:38VIS-100013MRN-91280Nathaniel Stewart2/10/1974FemaleSouth Trauma CenterSarah FastS824Fracture Of Fibula0FreeWalk-InPrivate1MRN-10036-01
41
MSG-26364-1A013/6/23 0:063/5/23 13:50VIS-126364MRN-10040Brian Hill12/24/1942FNorth General HospitalAbigail ShafferE11.9Type 2 DiabetesRM-785OccupiedEmergencyPrivate1MRN-10040-01MSG-14-1A0111/15/21 5:5411/15/21 1:36VIS-100014MRN-99395Brian Hill12/24/1942FemaleNorth General HospitalAbigail ShafferE119Type 2 Diabetes0OccupiedEmergencyPrivate1MRN-10040-01
42
MSG-26364-2A023/9/23 0:063/5/23 13:50VIS-126364MRN-10040Brian Hill12/24/1942FNorth General HospitalAbigail ShafferE11.9Type 2 DiabetesRM-105OccupiedTransferMedicare1MRN-10040-01MSG-14-3A0311/21/21 5:5411/15/21 1:36VIS-100014MRN-99395Brian Hill12/24/1942FemaleNorth General HospitalAbigail ShafferE119Type 2 Diabetes1OccupiedTransferMedicare1MRN-10040-01
43
MSG-26364-3A033/11/23 0:063/5/23 13:50VIS-126364MRN-10040Brian Hill12/24/1942FNorth General HospitalAbigail ShafferE11.9Type 2 DiabetesRM-785FreeTransferSelf-Pay1MRN-10040-01MSG-15-1A0111/16/23 10:5811/16/23 10:27VIS-100015MRN-93334Brian Hill12/24/1942FemaleNorth General HospitalAbigail ShafferE119Type 2 Diabetes0FreeTransferSelf-Pay1MRN-10040-01
44
MSG-4646-1A019/4/23 20:059/4/23 13:00VIS-104646MRN-10042Leah Brown8/25/1957MNorth General HospitalGina MooreS82.4Fracture of FibulaRM-535OccupiedTransferMedicaid1MRN-10042-01MSG-15-3A0311/19/23 10:5811/16/23 10:27VIS-100015MRN-93334Leah Brown8/25/1957MaleNorth General HospitalGina MooreS824Fracture Of Fibula0OccupiedTransferMedicaid1MRN-10042-01
45
MSG-4646-3A039/10/23 20:059/4/23 13:00VIS-104646MRN-10042Leah Brown8/25/1957MNorth General HospitalGina MooreS82.4Fracture of FibulaRM-535FreeTransferPrivate1MRN-10042-01MSG-16-1A0111/4/21 12:1911/4/21 11:31VIS-100016MRN-86382Leah Brown8/25/1957MaleNorth General HospitalGina MooreS824Fracture Of Fibula0FreeTransferPrivate1MRN-10042-01
46
MSG-26049-1A011/3/22 5:531/2/22 20:16VIS-126049MRN-10043Mark Schultz7/21/1940FNorth General HospitalJames CarefulJ12.89Viral PneumoniaRM-170OccupiedClinic ReferralSelf-Pay1MRN-10043-01MSG-16-3A0311/10/21 12:1911/4/21 11:31VIS-100016MRN-86382Mark Schultz7/21/1940FemaleNorth General HospitalJames CarefulJ1289Viral Pneumonia0OccupiedClinic ReferralSelf-Pay1MRN-10043-01
47
MSG-26049-3A031/12/22 5:531/2/22 20:16VIS-126049MRN-10043Mark Schultz7/21/1940FNorth General HospitalJames CarefulJ12.89Viral PneumoniaRM-170Over-CapacityTransferMedicaid1MRN-10043-01MSG-17-1A013/24/23 4:013/23/23 22:59VIS-100017MRN-36906Mark Schultz7/21/1940FemaleNorth General HospitalJames CarefulJ1289Viral Pneumonia0Over-CapacityTransferMedicaid1MRN-10043-01
48
MSG-19931-1A0111/6/21 22:2911/6/21 15:51VIS-119931MRN-10044Brandi Shaw10/24/1938MNorth General HospitalCristian SantosJ12.89Viral PneumoniaRM-590OccupiedEmergencySelf-Pay1MRN-10044-01MSG-17-3A033/28/23 4:013/23/23 22:59VIS-100017MRN-36906Brandi Shaw10/24/1938MaleNorth General HospitalCristian SantosJ1289Viral Pneumonia0OccupiedEmergencySelf-Pay1MRN-10044-01
49
MSG-19931-2A0211/6/21 22:2911/6/21 15:51VIS-119931MRN-10044Brandi Shaw10/24/1938MNorth General HospitalCristian SantosJ12.89Viral PneumoniaRM-323OccupiedTransferMedicaid1MRN-10044-01MSG-18-1A019/9/22 3:009/9/22 2:31VIS-100018MRN-37049Brandi Shaw10/24/1938MaleNorth General HospitalCristian SantosJ1289Viral Pneumonia1OccupiedTransferMedicaid1MRN-10044-01
50
MSG-19931-3A0311/9/21 22:2911/6/21 15:51VIS-119931MRN-10044Brandi Shaw10/24/1938MNorth General HospitalCristian SantosJ12.89Viral PneumoniaRM-590FreeTransferMedicaid1MRN-10044-01MSG-18-2A029/9/22 3:009/9/22 2:31VIS-100018MRN-37049Brandi Shaw10/24/1938MaleNorth General HospitalCristian SantosJ1289Viral Pneumonia0FreeTransferMedicaid1MRN-10044-01
51
MSG-20805-1A018/17/21 11:128/17/21 10:40VIS-120805MRN-10047Miss Samantha Scott PhD2/18/1937FSouth Trauma CenterGina MooreI10Essential HypertensionRM-292 OccupiedClinic ReferralSelf-Pay1MRN-10047-01MSG-18-3A039/17/22 3:009/9/22 2:31VIS-100018MRN-37049Miss Samantha Scott PhD2/18/1937FemaleSouth Trauma CenterGina MooreI10Essential Hypertension0OccupiedClinic ReferralSelf-Pay1MRN-10047-01
52
MSG-20805-3A038/21/21 11:128/17/21 10:40VIS-120805MRN-10047Miss Samantha Scott PhD2/18/1937FSouth Trauma CenterGina MooreI10Essential HypertensionRM-292 FreeClinic ReferralSelf-Pay1MRN-10047-01MSG-19-1A011/19/21 4:241/19/21 0:14VIS-100019MRN-25397Miss Samantha Scott PhD2/18/1937FemaleSouth Trauma CenterGina MooreI10Essential Hypertension0FreeClinic ReferralSelf-Pay1MRN-10047-01
53
MSG-6867-1A017/5/22 1:347/5/22 1:17VIS-106867MRN-10048Kayla Hunt8/26/1942MCity ClinicJames CarefulK35.8Acute AppendicitisRM-391OccupiedClinic ReferralMedicaid1MRN-10048-01MSG-19-3A031/21/21 4:241/19/21 0:14VIS-100019MRN-25397Kayla Hunt8/26/1942MaleCity ClinicJames CarefulK358Acute Appendicitis0OccupiedClinic ReferralMedicaid1MRN-10048-01
54
MSG-6867-3A037/15/22 1:347/5/22 1:17VIS-106867MRN-10048Kayla Hunt8/26/1942MCity ClinicJames CarefulK35.8Acute AppendicitisRM-391FreeWalk-InPrivate1MRN-10048-01MSG-20-1A015/20/23 18:505/20/23 18:03VIS-100020MRN-76158Kayla Hunt8/26/1942MaleCity ClinicJames CarefulK358Acute Appendicitis0FreeWalk-InPrivate1MRN-10048-01
55
MSG-34284-1A017/23/22 19:257/23/22 9:09VIS-134284MRN-10051Jessica James MD8/7/1945FNorth General HospitalGina MooreE11.9Type 2 DiabetesRM-652 OccupiedTransferSelf-Pay1MRN-10051-01MSG-20-3A035/23/23 18:505/20/23 18:03VIS-100020MRN-76158Jessica James MD8/7/1945FemaleNorth General HospitalGina MooreE119Type 2 Diabetes0OccupiedTransferSelf-Pay1MRN-10051-01
56
MSG-34284-3A037/29/22 19:257/23/22 9:09VIS-134284MRN-10051Jessica James MD8/7/1945FNorth General HospitalGina MooreE11.9RM-652 FreeClinic ReferralMedicaid1MRN-10051-01MSG-21-1A019/24/22 21:329/24/22 21:10VIS-100021MRN-10273Jessica James MD8/7/1945FemaleNorth General HospitalGina MooreE119Type 2 Diabetes0FreeClinic ReferralMedicaid1MRN-10051-01
57
MSG-14418-1A0110/31/21 22:2510/31/21 21:55VIS-114418MRN-10051Richard Lopez6/24/1988FSouth Trauma CenterAbigail ShafferI10Essential HypertensionRM-262OccupiedClinic ReferralMedicare2MRN-10051-02MSG-21-2A029/28/22 21:329/24/22 21:10VIS-100021MRN-10273Richard Lopez6/24/1988FemaleSouth Trauma CenterAbigail ShafferI10Essential Hypertension0OccupiedClinic ReferralMedicare2MRN-10051-02
58
MSG-14418-2A0210/31/21 22:2510/31/21 21:55VIS-114418MRN-10051Richard Lopez6/24/1988FSouth Trauma CenterAbigail ShafferI10Essential HypertensionRM-395OccupiedTransferPrivate2MRN-10051-02MSG-21-3A039/29/22 21:329/24/22 21:10VIS-100021MRN-10273Richard Lopez6/24/1988FemaleSouth Trauma CenterAbigail ShafferI10Essential Hypertension1OccupiedTransferPrivate2MRN-10051-02
59
MSG-14418-3A0311/3/21 22:2510/31/21 21:55VIS-114418MRN-10051Richard Lopez6/24/1988FSouth Trauma CenterAbigail ShafferI10Essential HypertensionRM-262FreeClinic ReferralMedicare2MRN-10051-02MSG-22-1A013/5/21 18:363/5/21 11:32VIS-100022MRN-45525Richard Lopez6/24/1988FemaleSouth Trauma CenterAbigail ShafferI10Essential Hypertension0FreeClinic ReferralMedicare2MRN-10051-02
60
MSG-22270-1A012/8/23 8:552/8/23 8:39VIS-122270MRN-10052Casey Barry1/18/1972FSouth Trauma Centerdr abigail shafferJ12.89Viral PneumoniaRM-941OccupiedEmergencySelf-Pay1MRN-10052-01MSG-22-3A033/7/21 18:363/5/21 11:32VIS-100022MRN-45525Casey Barry1/18/1972FemaleSouth Trauma CenterAbigail ShafferJ1289Viral Pneumonia0OccupiedEmergencySelf-Pay1MRN-10052-01
61
MSG-22270-3A032/14/23 8:552/8/23 8:39VIS-122270MRN-10052Casey Barry1/18/1972FSouth Trauma Centerdr abigail shafferJ12.89Viral PneumoniaRM-941FreeTransferSelf-Pay1MRN-10052-01MSG-23-1A011/2/23 12:381/2/23 2:44VIS-100023MRN-32921Casey Barry1/18/1972FemaleSouth Trauma CenterAbigail ShafferJ1289Viral Pneumonia0FreeTransferSelf-Pay1MRN-10052-01
62
MSG-5069-1A018/21/23 4:588/20/23 21:29VIS-105069MRN-1006Michael Thompson8/21/1972MNorth General HospitalAngie HendersonI10Essential HypertensionRM-255OccupiedTransferMedicaid1MRN-1006-01MSG-23-3A031/4/23 12:381/2/23 2:44VIS-100023MRN-32921Michael Thompson8/21/1972MaleNorth General HospitalAngie HendersonI10Essential Hypertension0OccupiedTransferMedicaid1MRN-1006-01
63
MSG-5069-3A038/26/23 4:588/20/23 21:29VIS-105069MRN-1006Michael Thompson8/21/1972MNorth General HospitalAngie HendersonI10Essential HypertensionRM-255FreeTransferMedicaid1MRN-1006-01MSG-24-1A013/30/22 23:573/30/22 23:36VIS-100024MRN-56530Michael Thompson8/21/1972MaleNorth General HospitalAngie HendersonI10Essential Hypertension0FreeTransferMedicaid1MRN-1006-01
64
MSG-32702-1A019/9/21 22:399/9/21 21:55VIS-132702MRN-10063Emily Wilson2/7/1943FCity ClinicNoah RhodesE11.9Type 2 DiabetesRM-772OccupiedTransferPrivate1MRN-10063-01MSG-24-2A023/30/22 23:573/30/22 23:36VIS-100024MRN-56530Emily Wilson2/7/1943FemaleCity ClinicNoah RhodesE119Type 2 Diabetes0OccupiedTransferPrivate1MRN-10063-01
65
MSG-32702-3A039/15/21 22:399/9/21 21:55VIS-132702MRN-10063Emily Wilson2/7/1943FCity ClinicNoah RhodesE11.9Type 2 DiabetesRM-772FreeWalk-InSelf-Pay1MRN-10063-01MSG-24-3A034/2/22 23:573/30/22 23:36VIS-100024MRN-56530Emily Wilson2/7/1943FemaleCity ClinicNoah RhodesE119Type 2 Diabetes0FreeWalk-InSelf-Pay1MRN-10063-01
66
MSG-14617-1A0111/29/22 12:3311/29/22 11:38VIS-114617MRN-10066Brittany Cervantes8/1/1940MSouth Trauma CenterGina MooreI10Essential HypertensionRM-479OccupiedClinic ReferralPrivate1MRN-10066-01MSG-25-1A0112/26/23 9:1312/26/23 8:57VIS-100025MRN-1347Brittany Cervantes8/1/1940MaleSouth Trauma CenterGina MooreI10Essential Hypertension0OccupiedClinic ReferralPrivate1MRN-10066-01
67
MSG-14617-3A0312/3/22 12:3311/29/22 11:38VIS-114617MRN-10066Brittany Cervantes8/1/1940MSouth Trauma CenterGina MooreI10Essential HypertensionRM-479FreeWalk-InSelf-Pay1MRN-10066-01MSG-25-3A031/1/24 9:1312/26/23 8:57VIS-100025MRN-1347Brittany Cervantes8/1/1940MaleSouth Trauma CenterGina MooreI10Essential Hypertension0FreeWalk-InSelf-Pay1MRN-10066-01
68
MSG-12066-1A012/6/22 12:132/6/22 2:26VIS-112066MRN-10066Steven Smith5/19/1938FNorth General HospitalAllison HillJ12.89Viral PneumoniaRM-207OccupiedTransferMedicaid2MRN-10066-02MSG-26-1A012/16/21 15:102/16/21 14:23VIS-100026MRN-91817Steven Smith5/19/1938FemaleNorth General HospitalAllison HillJ1289Viral Pneumonia0OccupiedTransferMedicaid2MRN-10066-02
69
MSG-12066-3A032/9/22 12:132/6/22 2:26VIS-112066MRN-10066Steven Smith5/19/1938FNorth General HospitalAllison HillJ12.89Viral PneumoniaRM-207FreeEmergencySelf-Pay2MRN-10066-02MSG-26-3A032/19/21 15:102/16/21 14:23VIS-100026MRN-91817Steven Smith5/19/1938FemaleNorth General HospitalAllison HillJ1289Viral Pneumonia0FreeEmergencySelf-Pay2MRN-10066-02
70
MSG-21499-1A0110/22/23 12:0510/22/23 0:06VIS-121499MRN-10068Jennifer Cook2/6/1987MNorth General HospitalDaniel Wagner MDS82.4Fracture of FibulaRM-847OccupiedEmergencyMedicare1MRN-10068-01MSG-27-1A013/11/22 13:073/11/22 12:30VIS-100027MRN-62469Jennifer Cook2/6/1987MaleNorth General HospitalDaniel WagnerS824Fracture Of Fibula0OccupiedEmergencyMedicare1MRN-10068-01
71
MSG-21499-2A0210/23/23 12:0510/22/23 0:06VIS-121499MRN-10068Jennifer Cook2/6/1987MNorth General HospitalDaniel Wagner MDS82.4Fracture of FibulaRM-276OccupiedWalk-InMedicare1MRN-10068-01MSG-27-3A033/17/22 13:073/11/22 12:30VIS-100027MRN-62469Jennifer Cook2/6/1987MaleNorth General HospitalDaniel WagnerS824Fracture Of Fibula1OccupiedWalk-InMedicare1MRN-10068-01
72
MSG-21499-3A0310/25/23 12:0510/22/23 0:06VIS-121499MRN-10068Jennifer Cook2/6/1987MNorth General HospitalDaniel Wagner MDS82.4Fracture of FibulaRM-847FreeTransferMedicaid1MRN-10068-01MSG-28-1A0112/28/23 7:3612/28/23 6:55VIS-100028MRN-96024Jennifer Cook2/6/1987MaleNorth General HospitalDaniel WagnerS824Fracture Of Fibula0FreeTransferMedicaid1MRN-10068-01
73
MSG-39602-1A018/12/21 2:158/11/21 19:17VIS-139602MRN-10069Betty Gill1/31/1979FNorth General HospitalNoah RhodesE11.9Type 2 DiabetesRM-638OccupiedClinic ReferralPrivate1MRN-10069-01MSG-28-3A0312/29/23 7:3612/28/23 6:55VIS-100028MRN-96024Betty Gill1/31/1979FemaleNorth General HospitalNoah RhodesE119Type 2 Diabetes0OccupiedClinic ReferralPrivate1MRN-10069-01
74
MSG-39602-3A038/14/21 2:158/11/21 19:17VIS-139602MRN-10069Betty Gill1/31/1979FNorth General HospitalNoah RhodesE11.9Type 2 DiabetesRM-638FreeEmergencyMedicaid1MRN-10069-01MSG-29-1A0111/22/21 11:4611/22/21 5:30VIS-100029MRN-44245Betty Gill1/31/1979FemaleNorth General HospitalNoah RhodesE119Type 2 Diabetes0FreeEmergencyMedicaid1MRN-10069-01
75
MSG-36775-1A012/12/21 17:552/12/21 17:27VIS-136775MRN-10070Jorge Meadows1/31/1976MSouth Trauma CenterSarah FastE11.9Type 2 DiabetesRM-954OccupiedEmergencyMedicare1MRN-10070-01MSG-29-3A0311/24/21 11:4611/22/21 5:30VIS-100029MRN-44245Jorge Meadows1/31/1976MaleSouth Trauma CenterSarah FastE119Type 2 Diabetes0OccupiedEmergencyMedicare1MRN-10070-01
76
MSG-36775-2A022/12/21 17:552/12/21 17:27VIS-136775MRN-10070Jorge Meadows1/31/1976MSouth Trauma CenterSarah FastE11.9Type 2 DiabetesRM-990OccupiedEmergencyPrivate1MRN-10070-01MSG-30-1A014/8/23 20:274/8/23 20:00VIS-100030MRN-68097Jorge Meadows1/31/1976MaleSouth Trauma CenterSarah FastE119Type 2 Diabetes1OccupiedEmergencyPrivate1MRN-10070-01
77
MSG-36775-3A032/13/21 17:552/12/21 17:27VIS-136775MRN-10070Jorge Meadows1/31/1976MSouth Trauma CenterSarah FastE11.9Type 2 DiabetesRM-954FreeEmergencySelf-Pay1MRN-10070-01MSG-30-3A034/18/23 20:274/8/23 20:00VIS-100030MRN-68097Jorge Meadows1/31/1976MaleSouth Trauma CenterSarah FastE119Type 2 Diabetes0FreeEmergencySelf-Pay1MRN-10070-01
78
MSG-2363-1A0110/21/22 2:3810/21/22 1:53VIS-102363MRN-10072James Wheeler8/25/1973MS.T.C.James CarefulK35.8Acute AppendicitisRM-436OccupiedTransferMedicare1MRN-10072-01MSG-31-1A017/1/22 5:337/1/22 4:40VIS-100031MRN-45072James Wheeler8/25/1973MaleCity ClinicJames CarefulK358Acute Appendicitis0OccupiedTransferMedicare1MRN-10072-01
79
MSG-2363-2A0210/25/22 2:3810/21/22 1:53VIS-102363MRN-10072James Wheeler8/25/1973MS.T.C.James CarefulK35.8Acute AppendicitisRM-870OccupiedEmergencyMedicaid1MRN-10072-01MSG-31-3A037/5/22 5:337/1/22 4:40VIS-100031MRN-45072James Wheeler8/25/1973MaleCity ClinicJames CarefulK358Acute Appendicitis1OccupiedEmergencyMedicaid1MRN-10072-01
80
MSG-2363-3A0310/31/22 2:3810/21/22 1:53VIS-102363MRN-10072James Wheeler8/25/1973MS.T.C.James CarefulK35.8Acute AppendicitisRM-436FreeEmergencyPrivate1MRN-10072-01MSG-32-1A015/11/21 3:005/11/21 2:04VIS-100032MRN-14963James Wheeler8/25/1973MaleCity ClinicJames CarefulK358Acute Appendicitis0FreeEmergencyPrivate1MRN-10072-01
81
MSG-4554-1A0110/6/21 9:3510/6/21 1:25VIS-104554MRN-10078Raven Harris6/18/1951MNorth General HospitalAllison HillI10Essential HypertensionRM-618OccupiedTransferPrivate1MRN-10078-01MSG-32-2A025/11/21 3:005/11/21 2:04VIS-100032MRN-14963Raven Harris6/18/1951MaleNorth General HospitalAllison HillI10Essential Hypertension0OccupiedTransferPrivate1MRN-10078-01
82
MSG-4554-3A0310/10/21 9:3510/6/21 1:25VIS-104554MRN-10078Raven Harris6/18/1951MNorth General HospitalAllison HillI10Essential HypertensionRM-618FreeClinic ReferralSelf-Pay1MRN-10078-01MSG-32-3A035/16/21 3:005/11/21 2:04VIS-100032MRN-14963Raven Harris6/18/1951MaleNorth General HospitalAllison HillI10Essential Hypertension0FreeClinic ReferralSelf-Pay1MRN-10078-01
83
MSG-39083-1A014/29/22 21:514/29/22 21:00VIS-139083MRN-10079Joe Rojas12/11/1980MCity ClinicAngie HendersonK35.8Acute AppendicitisRM-993OccupiedTransferPrivate1MRN-10079-01MSG-33-1A018/22/21 6:278/22/21 5:32VIS-100033MRN-77756Joe Rojas12/11/1980MaleCity ClinicAngie HendersonK358Acute Appendicitis0OccupiedTransferPrivate1MRN-10079-01
84
MSG-39083-3A035/4/22 21:514/29/22 21:00VIS-139083MRN-10079Joe Rojas12/11/1980MCity ClinicAngie HendersonK35.8Acute AppendicitisRM-993FreeWalk-InPrivate1MRN-10079-01MSG-33-3A038/25/21 6:278/22/21 5:32VIS-100033MRN-77756Joe Rojas12/11/1980MaleCity ClinicAngie HendersonK358Acute Appendicitis0FreeWalk-InPrivate1MRN-10079-01
85
MSG-29954-1A0110/31/22 22:3110/31/22 21:50VIS-129954MRN-10079John Bradley10/18/1947FCity ClinicAbigail ShafferI10Essential HypertensionRM-523OccupiedTransferMedicaid2MRN-10079-02MSG-34-1A014/10/21 7:154/10/21 0:07VIS-100034MRN-68904John Bradley10/18/1947FemaleCity ClinicAbigail ShafferI10Essential Hypertension0OccupiedTransferMedicaid2MRN-10079-02
86
MSG-29954-3A0311/2/22 22:3110/31/22 21:50VIS-129954MRN-10079John Bradley10/18/1947FCity ClinicAbigail ShafferI10Essential HypertensionRM-523FreeTransferMedicaid2MRN-10079-02MSG-34-3A034/12/21 7:154/10/21 0:07VIS-100034MRN-68904John Bradley10/18/1947FemaleCity ClinicAbigail ShafferI10Essential Hypertension0FreeTransferMedicaid2MRN-10079-02
87
MSG-6607-1A0112/19/21 4:4812/19/21 4:17VIS-106607MRN-10080Ryan Jordan5/17/1989FCity ClinicDOCTOR Connie LawrenceJ12.89Viral PneumoniaRM-768 OccupiedWalk-InMedicare1MRN-10080-01MSG-35-1A012/6/21 4:232/6/21 3:55VIS-100035MRN-85463Ryan Jordan5/17/1989FemaleCity ClinicConnie LawrenceJ1289Viral Pneumonia0OccupiedWalk-InMedicare1MRN-10080-01
88
MSG-6607-3A0312/22/21 4:4812/19/21 4:17VIS-106607MRN-10080Ryan Jordan5/17/1989FCity ClinicDOCTOR Connie LawrenceJ12.89Viral PneumoniaRM-768 Over-CapacityClinic ReferralSelf-Pay1MRN-10080-01MSG-35-3A032/8/21 4:232/6/21 3:55VIS-100035MRN-85463Ryan Jordan5/17/1989FemaleCity ClinicConnie LawrenceJ1289Viral Pneumonia0Over-CapacityClinic ReferralSelf-Pay1MRN-10080-01
89
MSG-27258-1A015/23/23 23:105/23/23 18:04VIS-127258MRN-10085Janet Adams3/29/1987FNorth General HospitalCristian SantosK35.8Acute AppendicitisRM-867OccupiedTransferMedicaid1MRN-10085-01MSG-36-1A016/7/23 22:056/7/23 10:59VIS-100036MRN-92981Janet Adams3/29/1987FemaleNorth General HospitalCristian SantosK358Acute Appendicitis0OccupiedTransferMedicaid1MRN-10085-01
90
MSG-27258-3A035/28/23 23:105/23/23 18:04VIS-127258MRN-10085Janet Adams3/29/1987FNorth General HospitalCristian SantosK35.8Acute AppendicitisRM-867FreeWalk-InPrivate1MRN-10085-01MSG-36-3A036/8/23 22:056/7/23 10:59VIS-100036MRN-92981Janet Adams3/29/1987FemaleNorth General HospitalCristian SantosK358Acute Appendicitis0FreeWalk-InPrivate1MRN-10085-01
91
MSG-31506-1A011/18/21 15:221/18/21 11:00VIS-131506MRN-10086Heidi Johnson7/5/1968MNorth General HospitalConnie LawrenceJ12.89Viral PneumoniaRM-938OccupiedEmergencyPrivate1MRN-10086-01MSG-37-1A011/19/23 11:411/19/23 7:20VIS-100037MRN-27839Heidi Johnson7/5/1968MaleNorth General HospitalConnie LawrenceJ1289Viral Pneumonia0OccupiedEmergencyPrivate1MRN-10086-01
92
MSG-31506-2A021/18/21 15:221/18/21 11:00VIS-131506MRN-10086Heidi Johnson7/5/1968MNorth General HospitalConnie LawrenceJ12.89Viral PneumoniaRM-711OccupiedTransferSelf-Pay1MRN-10086-01MSG-37-3A031/23/23 11:411/19/23 7:20VIS-100037MRN-27839Heidi Johnson7/5/1968MaleNorth General HospitalConnie LawrenceJ1289Viral Pneumonia1OccupiedTransferSelf-Pay1MRN-10086-01
93
MSG-31506-3A031/20/21 15:221/18/21 11:00VIS-131506MRN-10086Heidi Johnson7/5/1968MNorth General HospitalConnie LawrenceJ12.89Viral PneumoniaRM-938Over-CapacityClinic ReferralMedicaid1MRN-10086-01MSG-38-1A0111/12/23 9:0011/12/23 8:45VIS-100038MRN-4512Heidi Johnson7/5/1968MaleNorth General HospitalConnie LawrenceJ1289Viral Pneumonia0Over-CapacityClinic ReferralMedicaid1MRN-10086-01
94
MSG-14715-1A0112/26/21 23:2312/26/21 22:45VIS-114715MRN-10087Benjamin Smith1/24/2001MSouth Trauma CenterGina MooreJ1289Viral PneumoniaRM-688OccupiedClinic ReferralSelf-Pay1MRN-10087-01MSG-38-3A0311/17/23 9:0011/12/23 8:45VIS-100038MRN-4512Benjamin Smith1/24/2001MaleSouth Trauma CenterGina MooreJ1289Viral Pneumonia0OccupiedClinic ReferralSelf-Pay1MRN-10087-01
95
MSG-14715-2A0212/29/21 23:2312/26/21 22:45VIS-114715MRN-10087Benjamin Smith1/24/2001MSouth Trauma CenterGina MooreJ1289Viral PneumoniaRM-374OccupiedTransferPrivate1MRN-10087-01MSG-39-1A011/24/23 14:161/24/23 2:51VIS-100039MRN-74781Benjamin Smith1/24/2001MaleSouth Trauma CenterGina MooreJ1289Viral Pneumonia1OccupiedTransferPrivate1MRN-10087-01
96
MSG-14715-3A0312/31/21 23:2312/26/21 22:45VIS-114715MRN-10087Benjamin Smith1/24/2001MSouth Trauma CenterGina MooreJ1289Viral PneumoniaRM-688Over-CapacityWalk-InSelf-Pay1MRN-10087-01MSG-39-3A031/30/23 14:161/24/23 2:51VIS-100039MRN-74781Benjamin Smith1/24/2001MaleSouth Trauma CenterGina MooreJ1289Viral Pneumonia0Over-CapacityWalk-InSelf-Pay1MRN-10087-01
97
MSG-38454-1A011/5/22 13:401/5/22 13:24VIS-138454MRN-10087Rachael Jones2/4/1994FCity ClinicConnie LawrenceJ1289Viral PneumoniaRM-506OccupiedClinic ReferralPrivate2MRN-10087-02MSG-40-1A0112/25/22 8:2812/24/22 22:16VIS-100040MRN-71548Rachael Jones2/4/1994FemaleCity ClinicConnie LawrenceJ1289Viral Pneumonia0OccupiedClinic ReferralPrivate2MRN-10087-02
98
MSG-38454-3A031/7/22 13:401/5/22 13:24VIS-138454MRN-10087Rachael Jones2/4/1994FCity ClinicConnie LawrenceJ1289Viral PneumoniaRM-506Over-CapacityClinic ReferralMedicare2MRN-10087-02MSG-40-2A0212/25/22 8:2812/24/22 22:16VIS-100040MRN-71548Rachael Jones2/4/1994FemaleCity ClinicConnie LawrenceJ1289Viral Pneumonia0Over-CapacityClinic ReferralMedicare2MRN-10087-02
99
MSG-12651-1A019/24/22 11:009/24/22 3:33VIS-112651MRN-1009Dustin Kelley4/28/1994MNorth General HospitalSarah FastE11.9Type 2 DiabetesRM-101OccupiedTransferPrivate1MRN-1009-01MSG-40-3A0312/27/22 8:2812/24/22 22:16VIS-100040MRN-71548Dustin Kelley4/28/1994MaleNorth General HospitalSarah FastE119Type 2 Diabetes0OccupiedTransferPrivate1MRN-1009-01
100
MSG-12651-3A039/25/22 11:009/24/22 3:33VIS-112651MRN-1009Dustin Kelley4/28/1994MNorth General HospitalSarah FastE11.9Type 2 DiabetesRM-101FreeEmergencyMedicaid1MRN-1009-01MSG-41-1A012/3/23 19:572/3/23 19:02VIS-100041MRN-21461Dustin Kelley4/28/1994MaleNorth General HospitalSarah FastE119Type 2 Diabetes0FreeEmergencyMedicaid1MRN-1009-01