General Visit (PT Boulder API)

Total rows: 99,566
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
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-04-27 22:50:11
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-04-27 22:50:11
583 432faa562083c7c27fee55c47c440b7545237496c43b988ea2dbddc9736f507e 695c06576820f8cc975087c3 67ced5277abf9f3ed8fef0cd Gabrielle Scott Gabrielle Scott kimo4325@gmail.com 012971 15 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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:11
580 0cbeec61b01214abd0f008423a21eaa94010fa15baeb83210978bef18beb86ae 6924c1a0ee2c73c090384ed5 67ced3907abf9f3ed8fe9ff6 Bruce Jaffe Bruce Jaffe bjaffe12@mac.com 006075 41 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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:11
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-04-27 22:50:39
859 fddbe4a54c5b2b283eba0ff9070ee9a0dd73b770e0aea5bcc8509ccb82ec6186 6972c120a5a116b944344a43 67ced3c17abf9f3ed8feacd4 Katherine Kaminski Katherine Kaminski khkaminski@gmail.com 007173 133 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-04-27 22:50:53
858 5fc83e238ea4f838aa161316bf0010e13c16d85ad47c3b348c32fca88608a16c 6952fc19e6d24e0bf4d5ced0 67ced31c7abf9f3ed8fe77b3 Karin Delany Karin Delany karindelany@gmail.com 002640 82 2026-02-13 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Renee Carr - Laura Shove 2026-02-13 00:48:17 0.6 hrs 6952fc19e6d24e0bf4d5cecf 000031903 4.00 95.60 60.60 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
857 3b6f554945ca3026d7f2f35c193ab0fc969b3673714f10e1aa4ea5782b746d14 697a9c2c1b7c529fa1bce5a0 6966b74ad1aada9579e78c6e Emily Portillo Emily Portillo meehan.melissaa@gmail.com 020506 21 2026-02-13 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2026-01-28 23:34:10 -374.4 hrs 697a9c2c1b7c529fa1bce598 000035827 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
856 7b696ec3b652ea0745ee8c6c491a8d8f606c76c347992c65adb8359907eed4d7 697a9c2a29797b443b00c165 6966b74ad1aada9579e78c6e Emily Portillo Emily Portillo meehan.melissaa@gmail.com 020506 21 2026-02-13 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-13 15:09:35 1.2 hrs 697a9c2a29797b443b00c15d 000035819 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
855 7522932fe211ffeb3b76d6f9b94299c807d1578498918fef96c08d2b80a7028e 697288c97ed9e2331cce000e 697288b7cfc39105a70e73e8 Carola Stirk Carola Stirk stirkcarola@cs.com 020611 8 2026-02-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-02-25 16:03:43 290.1 hrs 697288c97ed9e2331cce000d 000034925 5.00 85.00 85.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
854 6cee4f0beafdc1e21ece0f0884b6495b02e7806508139b952090f4fb2c7b7ed1 69696c7b44d873b5d63b5d5d 68a89a2b8f892d07ede2fd3b Sean Kemp Sean Kemp jskemp7602@gmail.com 019727 34 2026-02-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Sonya C. 2026-02-13 16:00:08 2.0 hrs 69696c7b44d873b5d63b5d5c 000033942 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
853 d257a0dc50aeaf7864c69232f5b9eca440809d5337fd5b5166764700a5815186 696184064ea9ed3ceee19826 68a8154599c65c4a78a5fd48 Karen Laszlo Karen Laszlo karen.laszlo@gmail.com 018844 21 2026-02-13 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-17 16:19:35 98.3 hrs 696184064ea9ed3ceee19822 000033248 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
852 3ac1496b216b116b468ca68c42fdf617e04456db088bc655d7d568a837d3b6bb 695ea019c8b76fa681718069 68a38e7aba796dc7de088f3a Kerstin Dickson Kerstin Dickson kl.dickson@comcast.net 017816 28 2026-02-13 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Renee Carr - Mark Jerome Para-ase 2026-02-17 18:52:37 100.9 hrs 695ea019c8b76fa681718068 000032894 3.00 83.24 83.24 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
851 af3c51dd751ed6885daa702367bca3ac811ad0da17729c1ea55059e3d96444bf 697a2bd005df057ab8ada3c2 67ced34a7abf9f3ed8fe8928 Matthew Elam Matthew Elam matthew.p.elam@gmail.com 004129 23 2026-02-13 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Mark Jerome Para-ase 2026-02-17 18:32:56 100.3 hrs 697a2bd005df057ab8ada3c1 000035664 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
850 8dd0615324efb772c00548a41b46122ae311025e7ac31b3526a41d3918d133db 698b51059761fde9b84bced0 698b50b03b1220d63151c5c5 Mario Morency Mario Morency mariomorency@gmail.com 020717 6 2026-02-13 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-03-04 23:11:02 464.7 hrs 698b51059761fde9b84bcecf 000037087 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
849 36ace3b2a258fb716bb7c38300e117318bb9c69812940bd8206aec5acef17323 6980e6fa2d6ce19fd475419e 68ac8cf6256b80b21ab77d5c Courtney Black Courtney Black cblack0115@yahoo.com 019736 37 2026-02-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-02-16 20:25:05 77.9 hrs 6980e6fa2d6ce19fd475419d 000036206 3.00 85.00 25.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
848 2abacbde2c304ca70f4b23f72c46ca58ff30bb5fb91f7590e76155e7a88646c3 696a61fd59448922fd503527 695d79b91cb1c358bf8bd0e0 Cole Smith Cole Smith cole.smith.bikes@gmail.com 020465 8 2026-02-13 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Michelle W. - Mark Jerome Para-ase 2026-02-17 16:20:56 97.8 hrs 696a61fd59448922fd503526 000033978 3.00 235.00 10.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53
847 0193378444b250677df319d39dd76c2ac0636b67b546ef46059464c6860857d6 695efdb60dd85f81c95cec28 68eea06d405e33e8d5ba401d Meg Reeder-Cramer Meg Reeder-Cramer meg.reeder.us@gmail.com 020064 28 2026-02-13 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Mark Jerome Para-ase 2026-02-17 18:38:57 100.1 hrs 695efdb60dd85f81c95cec27 000033006 4.00 85.00 85.00 - - - - - - - - 2026-02-19 22:27:00 2026-04-27 22:50:53