General Visit (PT Boulder API)

Total rows: 104,153
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
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
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-06-11 23:37:06
15952 b40a7b21ec4b3fc0f078472435f3e94f625e824b130ef512039be596f5eb742e 68af28436d5d6587269b92cb 68af26869840478ac34147ca Karlota Estevan Karlota Estevan karlesbee@gmail.com 019755 19 2025-10-01 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. Sophia is out sick -mw Michelle W. 2025-10-01 17:02:12 -2.0 hrs 68af28436d5d6587269b92c7 000017747 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15951 a6be3d9cc68f6cfd65d1b6385a2febc6a95d027a145d2e64ab43efc9bdbdee9d 689f7d146695144eb3854a5e 689f7b6cd5baa307dfd09310 Kyle Callahan Kyle Callahan kylecallahan1@msn.com 017807 5 2025-10-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-02 15:41:02 20.7 hrs 689f7d146695144eb3854a5d 000016442 3.00 101.00 101.00 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15950 4236451995ce6be007b8e6d471316dad3930cc445f3a93056cd6b7c2eed59a53 68813eecd3cdf9088b3df82a 67ced4177abf9f3ed8fec075 Jane Manning Jane Manning jhmanning5@gmail.com 008847 90 2025-10-01 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-02 20:23:24 25.4 hrs 68813eecd3cdf9088b3df829 000014095 2.00 156.00 10.00 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15949 71aa823f72b02ccc83868164827bb79fb1ca86c2460140f78997bea1cc97f55e 681cd0bb34703907b4e13a9f 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-01 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 14:46:41 -2572.2 hrs 681cd0bb34703907b4e13a79 000004808 7.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15948 9f20c5262dea3816985ecd80c8c71966511930f561ebedee9339451b8297811c 67e6718bceb9f104f028c386 67ced5cf7abf9f3ed8ff08cb Michael Sullivan Michael Sullivan jazzdharma@comcast.net 015017 225 2025-10-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-10-01 18:46:08 -0.2 hrs 67e6718bceb9f104f028c385 000151686 2.00 58.75 58.75 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15947 9d952a9eb7cf52f66f8e2f5c53ad87ccb88a256564cc64b028c860be686e85bb 68a4aaf1ca96e381ab33f8bc 67ced4867abf9f3ed8fed5dd Rachel Mclaughlin Rachel Mclaughlin rleighmac@gmail.com 010673 49 2025-10-01 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Maia H. - Rosey Reed 2025-10-01 19:36:06 0.4 hrs 68a4aaf1ca96e381ab33f8bb 000016706 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:07:38 2026-06-11 23:37:06
15946 2084a3449b8916108a3955828e4916405bcf16cf20712f5f704f62350db2e872 688a57c41997c6086050df1a 688a5714297fd59a76062d1a Agnieszka Magoye Agnieszka Magoye amagoye@gmail.com 017722 14 2025-10-01 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Primary - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 18:10:08 478.9 hrs 6914f0bb3d334e6e53e4587d 000014787 1.00 0.00 20.00 - - - - - - - - 2026-02-19 23:07:37 2026-06-11 23:37:06
15945 428621a9be733e0f793110028d1c35187166be5c33e86fee8c36c7cf9b23e42c 68757c372a780a5b5f6c5f13 67ced3067abf9f3ed8fe6d15 Deborah Appel Deborah Appel debbie2175@me.com 001734 90 2025-10-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-10-01 20:25:00 1.2 hrs 68757c372a780a5b5f6c5f12 000012884 3.00 78.70 62.70 - - - - - - - - 2026-02-19 23:07:37 2026-06-11 23:37:06
15944 58188f574d9e71899ddb76bebc3f57501f66d95cd5193a968822438a184963e4 685f1efdf1c9ab0818837a14 681b7df597c361e480a06d0f Chelsea Souza Chelsea Souza cjowell@gmail.com 017192 13 2025-10-01 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Miranda Samson - Michelle W. 2025-07-30 14:44:51 -1516.5 hrs 685f1efdf1c9ab0818837a13 000011250 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:37 2026-06-11 23:37:06
15943 c7d28822992925b008a39fadc3488820969c2d011dbf5ab77b919b3988b88a08 68bf12b53a8e318c875b2941 68bf0a6aa864912cce335d8d Connor Bettencourt Connor Bettencourt cbettencourt04@gmail.com 019818 6 2025-10-01 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. pt said his car battery died -mw Michelle W. 2025-10-01 19:24:54 -0.1 hrs 68bf12b53a8e318c875b293d 000019041 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:37 2026-06-11 23:37:05