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
597 34d6510043b0e9b943f9bfb0886cec44332342588bb1ba9219277c25cb3d131a 697947effe60502fe4977dd9 6979464c72b5ce8994529503 Dominic Beer Dominic Beer lascervezas@gmail.com 020645 14 2026-02-16 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 2/13 Sophia L. 2026-02-13 22:45:17 -71.2 hrs 697947effe60502fe4977dcf 000035625 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
596 8efde2f8b70e5d0078cc6f6eebd70079a6991f06de7509b225425e7f27d2f62b 69779db3f7e34e0ec57567f0 67ced5fb7abf9f3ed8ff0e89 Christopher Tennant Christopher Tennant christopher.j.tennant@gmail.com 015507 12 2026-02-16 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins 2/13 - HP Haley Paull 2026-02-13 18:45:59 -75.2 hrs 69779db3f7e34e0ec57567ef 000035267 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
595 bdafdfe6cb2c9a7a7bb2bfb12ccdfe7fb2f2887c8cab868fda8cc075bc748d9d 69715a9eae63c6a4f5729e7a 690134300caa82196f5b48c3 Eileen Conway Eileen Conway conwayeg@gmail.com 020163 40 2026-02-16 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Haley Paull 2026-02-16 22:44:33 0.7 hrs 69962875bc255ad804872b70 000034800 3.00 79.66 79.66 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
594 022e6730eb0a1af0f4375c448cc5e9da821c61ed34d9770c02d0a9fc852e1c55 696eb5d08a090854d30f2277 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2026-02-16 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr 24+ Only needs once per week now. -RC Renee Carr 2026-01-21 19:11:59 -626.8 hrs 696eb5d08a090854d30f2276 000034353 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
593 4c74fb325ee1b13b65e974fc1102be8ea8ff4bc907ac0d2d9de35bb4da169c80 6968296a14575ff78b0f2616 69372e059f9775fecd41c899 Kari Taft Kari Taft etaft2@gmail.com 020347 13 2026-02-16 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. decreased visit frequency Miranda Samson 2026-02-02 22:49:06 -335.2 hrs 6968296a14575ff78b0f2615 000033761 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
592 7a0ecf770bb657d302949e889a9fd3478a6ac6bb280e43b90335b5635099e67c 69603b7520aa94e2bc69c883 6925f5e1f7662f113d1569dc James McMaster James McMaster jim.mcmaster@gmail.com 020301 7 2026-02-16 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Renee Carr - Mark Jerome Para-ase 2026-02-18 20:53:33 46.9 hrs 699626e11aab7f3373f247de 000033127 2.00 54.44 54.44 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
591 684e892e6a9c810758f0aeacbb6b4c097f9e4557db729ecaa85311a7437ee72f 694ebcea796ec21241a8c68d 67ced54c7abf9f3ed8fef658 Ruchi Shekhar Ruchi Shekhar ruchi.shekhar@gmail.com 013444 34 2026-02-16 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr 24+ Per VM, she needs to go to appt w/son - sc Sonya C. 2026-02-15 23:58:31 -22.0 hrs 694ebcea796ec21241a8c68c 000031742 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
590 db94a678e420c352d4b259c151b73116b85689fdf3b832684af98a872a3d10e6 692e1fb4e0110da2e2b04720 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2026-02-16 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt out of town Julie Petersen-Hanson 2026-01-12 22:58:30 -839.0 hrs 692e1fb4e0110da2e2b04718 000029251 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
589 bcaeca7458b6f808f1118020491173ff1f9d390e29fe2bf50452502caca3e1ea 68e93fe38b35a5064b6e82a5 67ced4207abf9f3ed8fec27c Gail Miller Gail Miller gemiller07@gmail.com 009020 240 2026-02-16 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Haley Paull 2026-02-16 22:47:17 0.8 hrs 68e93fe38b35a5064b6e82a4 000023059 3.00 83.38 83.38 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
588 c1ff69310911de2b693a6a0f04fd9e09d7799744132553474d181bc2395c39fc 698f53df5664e10458c37366 67ced4807abf9f3ed8fed4e7 Robert Murphy Robert Murphy rmurphyb17@gmail.com 010591 69 2026-02-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Emily Pickner 2026-02-16 22:16:53 0.0 hrs 698f53df5664e10458c37365 000037531 3.00 83.38 83.38 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
587 e24398b2919a6f8ede5c2b152176f0c005de816d750bea14b7b8766b8f8ea8a2 6957e1cdea1a1918d67b29ce 6957e0bfb6df66488b5a4620 Kathryn Sparks Kathryn Sparks ksparks@gmail.com 020441 7 2026-02-16 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 1/21 (Sophia gone Sophia L. 2026-01-21 18:43:43 -627.5 hrs 6957e1cdea1a1918d67b29cd 000032310 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
586 86b092ca5b8e46ce57f545e5d61285b9622942f4cdb30d82b11979898908d0a7 698ceefc403f4bff1acf4730 69398f4f66a511d0fadfd682 Marjorie Gaylord Marjorie Gaylord harvey.gaylord@att.net 020356 10 2026-02-16 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Mark Jerome Para-ase 2026-02-18 21:31:54 46.8 hrs 698ceefc403f4bff1acf472f 000037307 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
585 e466083c1e90894c3a819c9a5bcb0f0796131d2c64fac1d580103990c4c2ba71 698391003592413203895981 67e1258d54aaaa3a80096cc9 Bruce Harbison Bruce Harbison bharbison@comcast.net 016779 32 2026-02-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Laura Sage - Mark Jerome Para-ase 2026-02-25 20:18:15 213.6 hrs 698391003592413203895980 000036551 3.00 235.00 10.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
584 77ac380014ae25339d7be2ffb11a610ef86f81db1c645250b6651839481fa457 6973daebb54d07992025b0cb 6973d98bdb8f2b4da415178b Alison VanLeeuwen Alison VanLeeuwen alisonvanl@gmail.com 020622 15 2026-02-16 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2026-02-16 22:44:27 -0.0 hrs 699746f35cc9086399f3ed7a 000035166 3.00 87.35 87.35 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
583 432faa562083c7c27fee55c47c440b7545237496c43b988ea2dbddc9736f507e 695c06576820f8cc975087c3 67ced5277abf9f3ed8fef0cd Gabrielle Scott Gabrielle Scott kimo4325@gmail.com 012971 21 2026-02-16 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-03-04 19:02:15 380.3 hrs 695c06576820f8cc975087c2 000032474 5.00 95.70 120.70 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
582 5916a680fec345ccdafa8bcf1d6d3a16d718022d89fde8b6f40cb32410fb14ca 691dfdbcfb6e66cfbe6b9be0 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2026-02-16 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 2/11 cxl d/t conflict LS Laura Sage 2026-02-11 15:58:29 -126.8 hrs 691dfdbcfb6e66cfbe6b9bd7 000027779 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
581 a59e2d44269676f5dd4f20abbf6327c3673a61275543572ed05d88c1a6a5357d 696e6f6b7e4df5ef448f571f 68af323a1a47a9255c6d0f67 Lynn Helmstetter Lynn Helmstetter lghelmstetter@gmail.com 019758 33 2026-02-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2026-02-16 23:03:12 0.1 hrs 696e6f6b7e4df5ef448f571e 000034197 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
580 0cbeec61b01214abd0f008423a21eaa94010fa15baeb83210978bef18beb86ae 6924c1a0ee2c73c090384ed5 67ced3907abf9f3ed8fe9ff6 Bruce Jaffe Bruce Jaffe bjaffe12@mac.com 006075 48 2026-02-16 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Haley Paull 2026-02-16 23:02:41 0.0 hrs 6924c1a0ee2c73c090384ed1 000028227 3.00 80.56 80.56 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
579 2217cdcc47c4d6cf9b50f6934def85dd6a04d15f5f8d349564887176ef9e6992 6981232cce48be5b96625ee4 6981228610e45624e41595bb Sean Hogan Sean Hogan cardinav@gmail.com 020680 12 2026-02-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-16 23:25:22 -0.1 hrs 6981232cce48be5b96625ee0 000036299 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
578 4b392ab6104961484f03fdcf537ec3cb24f76a8d36f231ff32b7f5e417ae9e9d 6981232c2be4796dbd642c73 6981228610e45624e41595bb Sean Hogan Sean Hogan cardinav@gmail.com 020680 12 2026-02-16 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. duplicate Haley Paull 2026-02-10 18:23:09 -149.1 hrs 6981232c2be4796dbd642c6f 000036303 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
577 e72e035a978e6a475ad56b0b9a1e05df14ec1690503b403bf90c67325ebd1a66 6977ecc94b9ba42fe2bc5521 692ddc76ea9b56dcd3de646d Leanne Riker Leanne Riker leanneriker@gmail.com 020309 11 2026-02-16 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Peter Gagnon - Angela Faith GereƱa 2026-02-19 18:56:11 67.4 hrs 6993b9b43f2f9066e67e8022 000035363 3.00 85.00 8.50 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
576 62e8e99be6f5d09b8297719459014ca2be5f3447055163928fa63855ba8357c3 69739fb0508592260056e705 67ced4fa7abf9f3ed8fee989 Kate Riddle Kate Riddle riddle_kate@svvsd.org 012351 85 2026-02-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-16 23:28:03 -0.0 hrs 69739fb0508592260056e703 000035080 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
575 8cc9912c7e0f4da0d466a098e84c2f64ce3ab6fc28bded63697091a1e3cf46f1 695426285731862f105f286c 67ced3017abf9f3ed8fe6acc Patricia Bosak Patricia Bosak tbosak1018@aol.com 001539 168 2026-02-16 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Renee Carr - Laura Shove 2026-02-16 23:53:53 0.1 hrs 695426285731862f105f286b 000032061 3.00 83.38 83.38 - - - - - - - - 2026-02-19 22:26:14 2026-06-11 22:59:27
728 9baa93d191f888904dd12b0c97606ed4005dbc5f335c49e2dc7d0fce82a6bbaf 695e8ebabb3cd32c5364094e 681bdff3eee67e08643ccf48 Thomas Glenn Thomas Glenn tom.s.glenn@gmail.com 017201 33 2026-02-14 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. admin error Laura Sage 2026-02-12 15:40:48 -32.3 hrs 695e8ebabb3cd32c5364094d 000032878 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:26:44 2026-06-11 22:59:54
859 fddbe4a54c5b2b283eba0ff9070ee9a0dd73b770e0aea5bcc8509ccb82ec6186 6972c120a5a116b944344a43 67ced3c17abf9f3ed8feacd4 Katherine Kaminski Katherine Kaminski khkaminski@gmail.com 007173 135 2026-02-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - John Reed 2026-02-13 17:15:36 17.3 hrs 6972c120a5a116b944344a42 000035013 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:27:00 2026-06-11 23:00:09