General Visit (PT Boulder API)

Total rows: 101,513
id row_key pte_visit_id pte_patient_id patient_full_name patient_first_name patient_last_name patient_email patient_code patient_total_appointment_visit date_of_service appointment_status provider_id provider_name service_id service_name location_id location_name invoice_status invoice_number current_responsibility package_invoice_number package_invoice_name claim_created_info created_by reason last_update_by last_update_date cancellation_notice treatment_note_id treatment_note_number units charges payments summary_total_appointments summary_total_charges summary_total_payments summary_total_units summary_total_patients summary_average_charges summary_average_payments summary_average_units created_at updated_at
15977 c033106f60d203a54f742a72ad3227041ab1cd4cec73ed59d41639f09ffb28de 68af38eb512c7eacf7131454 68af3766aeacebaa1f71bdc2 Glen DUPLICATE Alleman Glen DUPLICATE Alleman glenallema@niwotridge.com 019759 4 2025-10-01 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-08-27 17:06:40 -840.4 hrs 68af38eb512c7eacf7131453 000017804 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15976 8d1731af01d8183baab35938490dcb5663bf0c45436a14eaebd917f634648576 68a6241b6bb8b66ef8cee949 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-10-01 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-29 19:45:10 -789.7 hrs 68a6241b6bb8b66ef8cee948 000016970 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15975 6ea1f7e03a0d5a62889b953befbfc1982ca72d584aa68ac9fc9974cd5da0f52a 68a391252db0500861e6d494 68a390322dac430785c21ed1 Serena Randolph Serena Randolph serena.randolph@gmail.com 017817 16 2025-10-01 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. per VM , she is seeing Julie instead- sc Sonya C. 2025-09-30 20:25:31 -21.1 hrs 68a391252db0500861e6d490 000016590 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15974 205abe88377396f126388e275f204db611409028de315cf3b1a25fbf02c9f35b 6864516c6fc5eb214982d59b 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-10-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Gillian B. - Kenneth Dave Francisco 2025-10-02 17:52:18 24.4 hrs 6864516c6fc5eb214982d596 000011520 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15973 cd52b7fbb0c64d858c669c7e227523771ecfa75d0a0b21ee781b04b949f55523 68d18bf6c20ba7d151757e0f 6841af06901a6124dff405e8 Jodie Simmons Jodie Simmons jodie.e.simmons@gmail.com 017395 25 2025-10-01 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. sophia is out sick -mw Michelle W. 2025-10-01 13:43:22 -4.0 hrs 68d18bf6c20ba7d151757e0e 000020491 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15972 9813e315b80cc9c0d0549d910483ac38de13505a661de921bd64547677bbd5eb 68ac9e73c04e600823abc8b6 67ced2ee7abf9f3ed8fe5e5d Caitlin Cottrill Caitlin Cottrill caco6467@colorado.edu 000478 58 2025-10-01 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. SCHEDULING CONFLICT-MW Michelle W. 2025-09-22 13:45:02 -220.0 hrs 68ac9e73c04e600823abc8b3 000017412 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15971 de206e50787e088ed0cfca6d63b16d15a2541048ad05b0e50ecb8391f630732e 68a782d43fb82189c2f53ea9 67ced6287abf9f3ed8ff1470 Mary Whited Mary Whited mpwhited@gmail.com 016010 42 2025-10-01 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Stephanie Braun - Michelle W. 2025-10-01 17:41:19 -0.1 hrs 68a782d43fb82189c2f53ea8 000017159 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15970 e46527ef3ce1bb1489323ad02d74d37bbebc6dea995e44e35195924d52f8c4ae 68d7115a81f7d675e6170274 68a747d4c2c418079316aceb Massimo Alpian Massimo Alpian Massimo.alpian@gmail.com 017883 37 2025-10-01 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Primary - - Yes Julie Petersen-Hanson - Mark Leo Guevarra 2025-10-10 15:13:26 213.2 hrs 68d7115a81f7d675e6170273 000021273 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15969 31bf3b8ddb8c06c05dab9bba67177ab1580a5247c9b501826eb2e9d49cdd43c7 68cdc34c491fbe08120ac979 67e1258754aaaa3a80096beb Matthew Atkins Matthew Atkins matthew.atkins11@gmail.com 016705 42 2025-10-01 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed scheduling conflict Michelle W. 2025-10-01 14:21:23 -3.6 hrs 68cdc34c491fbe08120ac978 000020366 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15968 5d052b5820cafaeac49c7186cacad6ce623685b33b3378557894d72926a32e86 68b7466f779d0f16b6656bce 68b74610c13a9ad5b5d59028 Marielos Perezcano Marielos Perezcano marielos@marielos.com 019786 5 2025-10-01 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-09-09 20:53:17 -525.1 hrs 68b7466f779d0f16b6656bcd 000018364 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15967 292eb677d80d4debc5cc691345df78f612d89f1cd00c5d06f26a9e51abb2867b 688a83c037f5b45dcdd2aecc 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-10-01 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-01 18:27:42 0.2 hrs 688a83c037f5b45dcdd2aec5 000014857 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15966 422ee4a453181bf2e8c79ddd9da5c688dc7d4e9b8850b4c2600daaf4b9c73c35 68dbfb042ab66d09992bc7ae 67ced4db7abf9f3ed8fee496 Philip Queen Philip Queen queen.philip@gmail.com 011929 50 2025-10-01 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Sonya C. 2025-10-01 18:46:40 0.3 hrs 68df02daad976d08b3c67209 000021611 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15965 3e4c28253e9c18bf120887f2b9dc0ad705c2e3698ab33318f3106a46fbfc2628 68d433b64f9ae224bbeb22b5 687fbddf5e228bca59ccf349 James Macintosh James Macintosh jmacintosh01@gmail.com 017671 17 2025-10-01 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Rosey Reed 2025-10-01 18:33:05 0.1 hrs 68d433b64f9ae224bbeb22b4 000020862 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15964 def7577514d13c65290c9dd2fbb39ac919eb9f54ae098d2703d1ad433a7b05f2 68c82fc00718ae29a86d5da1 688b939d7cd0650800dda926 Donna Colville Donna Colville draye@comcast.net 017730 13 2025-10-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-10-01 18:31:28 0.0 hrs 68c82fc00718ae29a86d5da0 000019742 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15963 646e6963c59bf9f21447676f6ea503c21d2bfb979c4b52d0d0e5744f3d04633f 68bf46853e77990388a6a01e 68bf44e3b59c3c04227083f0 Aaron Pinsker Aaron Pinsker noraa@mac.com 019824 7 2025-10-01 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-09-16 15:01:34 -363.5 hrs 68bf46853e77990388a6a01a 000019112 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15962 09b2b8b239c1b79c8c101a60a1e3684eb977f6f9f9740d47bc8cb99829ee7c0a 68af22a3fd4e04080d6eaf95 67e6654befbf2c53d8d5de52 Lindsay Goodrich Lindsay Goodrich lindsbg@gmail.com 016819 52 2025-10-01 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Miranda Samson 2025-09-30 15:41:49 -26.8 hrs 68af22a3fd4e04080d6eaf90 000017733 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15961 8ab25d766b99fdb72ae9e5d77166d15c1dbca3f6439c6c1b3cdaf4a7b5b5ea18 689f84d8b32aa320fc398898 67ced4767abf9f3ed8fed2fb Scott McGonigal Scott McGonigal mrscottmcgonigal@gmail.com 010427 41 2025-10-01 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-10-01 18:30:21 0.0 hrs 689f84d8b32aa320fc398892 000016454 3.00 234.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15960 29d7b935f0f36c979d80d4ecdefc9d8609ef2b7beb51c843d4f33e1f620e770a 689f45cb309d014c35019188 67ced5797abf9f3ed8fefd02 Theresa Simmons-Smith Theresa Simmons-Smith smithtess444@aol.com 014012 102 2025-10-01 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-01 18:34:35 0.1 hrs 6913c50da4e852cda7033608 000016383 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15959 4500199b16456e417d2b4216e527103a2466499c68c0db6ab697b7a673f754e9 6887bb3ab91e65374119de1c 67ced5a37abf9f3ed8ff02d8 Aaron Stoddard Aaron Stoddard builderaaron@hotmail.com 014510 125 2025-10-01 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. cx Samantha Saunders 2025-09-08 20:35:06 -549.9 hrs 6887bb3ab91e65374119de14 000014497 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15958 b4151618c642e76dc872b9a4b31d259b13418f7221996099b39044d9f0597ba1 687a9a1a3a9f4f0880d48a6a 67ced30a7abf9f3ed8fe6f49 Eiko Arentzen Eiko Arentzen eiko.arentzen@gmail.com 001922 131 2025-10-01 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ still hospitized Sonya C. 2025-09-23 18:47:18 -191.7 hrs 687a9a1a3a9f4f0880d48a62 000013580 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15957 f1734a2df4799fdfec18a3c44b464fc24d17a589bcff3bfb4ed9fc0ce9cef17e 686fe86ac15eed8b13038d4d 67ced36e7abf9f3ed8fe9573 Karen Goodwin Karen Goodwin kvg17@aol.com 005178 50 2025-10-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Rosey Reed 2025-10-01 18:32:57 0.0 hrs 686fe86ac15eed8b13038d4c 000012444 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15956 0dc2bc5754687f502deecafd5dfede3632db60b995d26c1f1a251e044ee3db1b 68af416e15bc57af347154a7 68af40df67c7e38a2c806107 John Bliley John Bliley cjbliley@earthlink.net 019760 4 2025-10-01 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-10-01 18:41:45 -0.1 hrs 68af416e15bc57af347154a6 000017825 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15955 3a17ba90fea583429c225e8f0d2ad43b333c2c55447aff992ec0cccdb8a1cc26 68d4161db97902e191c6da21 68a8158499c65c4a78a6092e Stuart Smith Stuart Smith smitstu@gmail.com 019428 5 2025-10-01 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-10-01 21:24:58 2.4 hrs 68d4161db97902e191c6da20 000020815 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15954 d0736eb7f5aa427be0fe2aa9f214a9aba56628515162d81c4a3add18c06f8cb4 68c9c064cb346412ab458ad1 68c9bf5f0a0dc60c1d045231 Amber Williams Amber Williams ambyrlight@gmail.com 019876 11 2025-10-01 Checked Out 68535c6303dd08c79c018795 John Reed 67e84dd55868616a0a1bdc44 Kaiser Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Jayvee Totanes 2025-10-22 15:44:51 500.7 hrs 68c9c064cb346412ab458ad0 000019937 4.00 310.00 20.00 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46
15953 50addfb8adec7fbf06a8cfbf5fc38bc7f489b30ea84551e05356d0940b1cbcfc 68af2d3eacd1c0bcac6ac035 67ced2e97abf9f3ed8fe5aeb Charles Berginc Charles Berginc berginc4@gmail.com 000184 42 2025-10-01 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-01 19:35:57 0.6 hrs 691df96302882a1deb04f7c0 000017760 3.00 82.47 82.47 - - - - - - - - 2026-02-19 23:07:38 2026-05-13 23:32:46