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
21821 ecce36bba5542ae8b03edfa2195e5103a7748151a4ca5a9aed2be751b9a7ae46 688940b764f911b046d77884 6865a9ab6cf1465927ef7a25 Ekaterina Tulchinsky Ekaterina Tulchinsky etulchinsky@gmail.com 017566 7 2025-08-12 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-12 22:01:08 0.0 hrs 688940b764f911b046d77883 000014695 3.00 80.00 64.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:52:07
21820 bc160ac7a13d6bb6440abceb9cfcf06b84b49c6c09f5a3110562ac0b29ddd5ff 688245441dec57083325f357 67ced3a77abf9f3ed8fea5f6 Elena Hershey Elena Hershey elena.hershey@gmail.com 006587 13 2025-08-12 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Ranjini Ridgway - Peter Gagnon 2025-08-12 22:09:04 0.2 hrs 688245441dec57083325f356 000014152 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:52:07
21819 2e57482808450b4ca2bc5216e808051eab58148ac08901e539e526b5719f07c5 68758596e230508047efc59a 6875842f81ade06002029cf5 Sandra Farkas Sandra Farkas srfarkas@yahoo.com 017628 7 2025-08-12 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/6 Sophia L. 2025-08-06 16:57:53 -149.0 hrs 68758596e230508047efc598 000012902 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:52:07
21818 f9d5ef174e569cab48cf5f71e2fdc494ee0f20b99cda40dae0422ce426664723 683765b7aaae2f07a2218666 67ced3e17abf9f3ed8feb4cc Jennifer Kirk Jennifer Kirk jenniferjkirk@comcast.net 007853 24 2025-08-12 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-07-09 18:24:51 -819.6 hrs 683765b7aaae2f07a2218661 000007286 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:52:07
21817 96e6765d767682596071b883c696c86d30749872ba9910772ea0a64ac27140d7 685c2bdf4a620f8401714f18 685573f546fd016bba3147d3 Jamie Thayer Jamie Thayer munkabean@gmail.com 017483 5 2025-08-12 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 8/1 Sophia L. 2025-08-01 14:18:54 -271.9 hrs 685c2bdf4a620f8401714f17 000010734 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:52:07
21816 a6a241f045a9ee31e2e331499fd9db20b19194e842ec6d0281dd1210d54674c2 6837415a08bf7834fc7a83b5 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-08-12 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Maia H. 2025-08-12 22:10:53 -0.1 hrs 6837415a08bf7834fc7a83b4 000007240 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21815 4202a1a0e966b13ffa6347f530894152fdace4d960920a9207f315747b4911fe 6830d4660d3dfb08294912fc 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-08-12 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Maia H. 2025-08-12 22:11:40 -0.1 hrs 6830d4660d3dfb08294912f7 000006860 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21814 988fb89ed2e91475993ecbabb578d224ba089685ba72d114d4b75084a02137e6 682667b945d2b8087d099287 67ced57d7abf9f3ed8fefd7d Brooke Underbrink Brooke Underbrink brooke@brookeandcompany.com 014053 10 2025-08-12 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. Pt conf cxl - sick Sophia L. 2025-08-12 16:17:02 -6.0 hrs 682667b945d2b8087d099286 000005894 1.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21813 5fc3f172916de56d180223071d980997d471caf684cbd2624ac43b2f42b573bf 68a818dcb625571f004557fd 68a799fef2ba2f9b4873fa3a Ana Rey Ayala Ana Rey Ayala anamaria.rey@gmail.com 017903 4 2025-08-12 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:14:35 224.9 hrs 68a818dcb625571f004557fc 000161166 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21812 c9fd48aedeee3f75e0732b8227b3777125179df64b4c5be695da736e246cff2a 6889452efd323f4722894665 67ced54c7abf9f3ed8fef658 Ruchi Shekhar Ruchi Shekhar ruchi.shekhar@gmail.com 013444 34 2025-08-12 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Peter Gagnon - Sonya C. 2026-06-04 18:41:03 7100.2 hrs 6889452efd323f4722894664 000014703 4.00 95.83 95.83 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21811 dfa92a730312ce20c6b4c5ee1607689ad1b9d8b26f728db67f43eed020627540 68892e7e58d5b10974b481e0 67ced3d37abf9f3ed8feb184 Christine Kemp Christine Kemp christywkemp@gmail.com 007573 138 2025-08-12 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Sonya C. - Sophia L. 2025-08-12 22:30:24 0.0 hrs 689d1a329e0f14ade628a0b5 000014651 4.00 80.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21810 a1940036cd54f8ee7e2edad0d4bc080fbf0f14bb17d1f9bbee2a92ecd3a12a43 686fef67179d30c8c7e2f698 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-08-12 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-13 16:48:00 18.3 hrs 686fef67179d30c8c7e2f693 000012459 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21809 6f4121ec033da75f49893be426fcee98f2184f85a9b7236451775e29465982c7 6866f801e06c276c2a65cb31 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-08-12 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-30 21:24:55 430.9 hrs 68b36c3704f8d7e1f9f4d3e1 000011841 3.00 81.66 81.66 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21808 0faf9d81bb743745dccedc1aa86817a776a8be5369a10ccff584df45f8fd3646 6840cf6aa406d9e36175acb0 67ced3617abf9f3ed8fe915c Kelly Fertitta Kelly Fertitta kellyfertitta@icloud.com 004829 23 2025-08-12 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-12 22:30:17 0.0 hrs 6840cf6aa406d9e36175acac 000008349 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21807 298353b740bf3dea7c9967a7bd6645fefd509fff75aa9091ceb491bce6145ab8 6838e0c0f21ad30787d28748 67ced30b7abf9f3ed8fe6f7c Allen Chavez Allen Chavez allen.chavez@bvsd.org 001939 101 2025-08-12 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Pt conf cxl (Steph OUT) SL 6/19 Sophia L. 2025-06-19 22:36:43 -1295.9 hrs 6838e0c0f21ad30787d28747 000007541 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21806 9a58365d4a2dc508f2442aa15048f46ee1b9252c5c67ebcb7b4b72a4fa3cbade 6892963622e70f07b2add08d 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-08-12 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Hope Adair - Ranjini Ridgway 2025-08-22 19:25:56 236.4 hrs 6892963622e70f07b2add08c 000015461 3.00 233.00 25.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21805 36b04f0d72f22bdb53d327cfe8b6a765a69cfb07d31c450cad04b0c20e909ae7 687544ea4cfb29085b4e9570 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-08-12 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-12 23:03:49 0.1 hrs 687544ea4cfb29085b4e9568 000012824 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21804 7d041b0ad5b7d6a1a2199df9caea3f79c8772623bfcffc2966fee01e12326c3e 6838d7bb5446f9089650bed7 6838d6f7dec53c07ddab1f11 Lillian McDonough Lillian McDonough lillyroseerling@gmail.com 017342 6 2025-08-12 No Show 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Anne Majewski 2025-08-12 23:32:28 0.5 hrs 6838d7bb5446f9089650bed2 000007530 1.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21803 3c8dd540d4be78f9794b3a08035d57bf416da1da7e7a22a3bf7fce2491dabbc8 6823946ee6f1660780a4170e 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-08-12 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Maia H. 2025-08-12 17:04:29 -5.9 hrs 6823946ee6f1660780a41705 000005403 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21802 c34f3ee618d0f0c50348a4853d24f47cea781c0129ac754bfd941a2dbe33d743 688cdb3a5933ce082f3fc3e5 67ced32f7abf9f3ed8fe7eee Alexandra Baris Alexandra Baris barisalex70@gmail.com 003257 221 2025-08-12 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Laura Shove - Laura Shove 2025-08-13 00:03:21 0.8 hrs 688cdb3a5933ce082f3fc3e4 000015088 3.00 78.70 62.70 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21801 d403fb02231175aaead54b30c6a9fafe77feb9f65a37bfe9ce7cdee4c14982cd 687030ca63c8730850e426c8 68702eb2d732760872857a97 Kerri Corzine Burks Kerri Corzine Burks kerri.burks@gmail.com 017605 11 2025-08-12 No Show 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. - Sonya C. 2025-08-13 14:36:22 15.1 hrs 687030ca63c8730850e426c7 000012559 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
21800 7edf5971dedffc51c4b781dea8e984326c01e8d3ea3f99173288d74f599a901b 684347e7b9a09807d2736f24 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-08-12 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-30 19:31:03 -316.0 hrs 684347e7b9a09807d2736f1c 000008632 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:24:17 2026-06-11 23:51:53
22092 ed6e6852009e3552300a4f158385a75eba58ece36bcc3c05b6c951ebdded4afa 688a840f4a058b078b3b0009 688a83b37d0edf08a27c33e2 David Grant David Grant goblin8u2@gmail.com 017724 16 2025-08-11 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-08-11 13:25:41 0.4 hrs 688a840f4a058b078b3b0008 000014858 5.00 85.00 85.00 - - - - - - - - 2026-02-19 23:25:08 2026-06-11 23:52:38
22091 ef41d1557d69255d7307ddf21d50d4952a6866a2b91e070003694493e7ab3274 6875094b53230207fe6cc11e 682747e77e4dce07d584ea87 Robert Shapiro Robert Shapiro robertlshapiro@gmail.com 017252 26 2025-08-11 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Emily Pickner - Ranjini Ridgway 2025-08-12 14:44:14 25.7 hrs 6875094b53230207fe6cc11d 000012752 4.00 310.00 28.50 - - - - - - - - 2026-02-19 23:25:08 2026-06-11 23:52:38
22090 a7aade6f871aaa4e8b08ae4190ca776f54afa1e82a666f65f76337fcf2eed09a 68000f338e2b1c95e8fa6e60 67ced3117abf9f3ed8fe72dc Evan Christenson Evan Christenson evancolorado@msn.com 002227 56 2025-08-11 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-04-16 20:19:06 -2800.7 hrs 68000f338e2b1c95e8fa6e59 000002505 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:25:08 2026-06-11 23:52:38