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
27769 e7d9520cbc51c80702e239613e901d63d9747b8be9d8511eee33dcf8176f5ee1 682b4e2da1256781fa4f069e 682b4d2356f7b207bca1e778 Peter Shelley Peter Shelley pshelley@canyonoffices.com 017260 26 2025-06-26 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Maia H. 2025-06-26 18:58:51 -0.0 hrs 68c703296f3422e28e6eefea 000006059 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27768 93dc34ed05ffc7f563e50de14fe153f6c37b4f8eb9f1c9e956fc396702a6a503 6823b0a1935ee0f657874cf4 6823b00248048d03791a9751 Cheryl Barnes Cheryl Barnes revcheryl.barnes@gmail.com 017233 26 2025-06-26 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Gillian B. - Maia H. 2025-06-26 19:48:21 0.8 hrs 685dd8f910240ca9c35658cf 000005432 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27767 b386c284b5b5ce6f9161227a1c0ecf8e5400d01758f718d287410faa71a5843e 6823a55b53b37f07b153f03c 67ced4907abf9f3ed8fed7a8 Portia Pearson Portia Pearson portia0217@yahoo.com 010826 13 2025-06-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips - Sophia Phillips 2025-06-12 18:01:41 -337.0 hrs 6823a55b53b37f07b153f03b 000005423 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27766 bde757cf10946e9e38ad742bb495fc615a221f95388ec18e921ef3aadec0b969 682262ec07a60c078df2564d 67ced4547abf9f3ed8fecc8e Gregory McAuliffe Gregory McAuliffe gregg@mnpclaw.com 009879 11 2025-06-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-06-26 19:04:08 0.1 hrs 682262ec07a60c078df2564c 000005275 2.00 57.12 57.12 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27765 5fdeda68b5bd5b31adeda94c98b4575af9a57cd6afc03e536b9012e798090307 681cbd6b98c58250de80f353 67ced5757abf9f3ed8fefc63 Richard Silverman Richard Silverman benjisilverman@gmail.com 013959 126 2025-06-26 Checked Out 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Maia H. 2025-06-26 19:00:43 0.0 hrs 681cbd6b98c58250de80f352 000004743 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27764 a372fe260fa2930722444a188e1ad6240abbc6863ed4c55b90ee4657cc5fcf65 680bf4545514944a041e958a 6806972243b7fe84d4f9f04c Glenda Russell Glenda Russell gmrussell5@hotmail.com 017099 48 2025-06-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia Phillips 2025-05-12 21:07:31 -1077.9 hrs 680bf4545514944a041e9588 000003591 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27763 f4096bb3c81af90add548845c5a76379211dbeddeb183e19cca142b4c2f7dd9c 67f955dd47daf407b6ed9915 67ced32e7abf9f3ed8fe7e70 Carole Collom Carole Collom carolebob1960@gmail.com 003215 93 2025-06-26 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-04-29 15:32:01 -1395.5 hrs 67f955dd47daf407b6ed9911 000001966 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27762 1d8a92f8a7077d8f572970b86e5165c4089f24ccd857ea2e74628e22ab0eeb89 67e672b6ceb9f104f02915f8 67ced2ee7abf9f3ed8fe5ddc Raquel Cagan Raquel Cagan raquelsfishing@yahoo.com 000435 220 2025-06-26 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton 24+ sc Sonya C. 2025-05-27 15:59:42 -723.0 hrs 67e672b6ceb9f104f02915f7 000152149 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27761 7de018a6d79caf31f0fae703de4ceb9f9b64117e6906e3ac36031f1d38649399 67e672b5ceb9f104f029155a 67ced6587abf9f3ed8ff1a62 Tracy Zaik Tracy Zaik tracyzaik@comcast.net 016517 55 2025-06-26 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton CB OOT Marguerite Barth 2025-06-12 18:18:55 -336.7 hrs 67e672b5ceb9f104f0291559 000152148 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27760 4f55a9b4d31628f38869b49bb2d739e2bbc6e7b8c9c963fc4efd3cbae5de52d0 68016002e9c52c00729a2b4c 67ced3357abf9f3ed8fe813a Michael Divjak Michael Divjak keschmeyer@yahoo.com 003453 459 2025-06-26 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. Wed 6:24pm Sally calling for Michael Divjak apt with Libby at 1:15 or 1:30pm on Thursday - his care giver is out of town this week. I was going to bring him, but I have a foot injury. Isn’t sure she can bring him. Canceling for now. If my pain is better, she’ll call to get him in with Libby. 219.781.0117 Ranjini Ridgway 2025-06-26 12:16:10 -7.0 hrs 68016002e9c52c00729a2b4b 000002717 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27759 a505455f4be29039163b0cbd8f1edefa93760447f809a633bb5bafee74f4cc65 6835fd865c24afee3c337299 67e666f9efbf2c53d8d60298 David Sutherland David Sutherland sutheda@yahoo.com 016889 7 2025-06-26 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-06-23 17:11:14 -74.3 hrs 6835fd865c24afee3c337298 000007008 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:01 2026-06-12 00:07:06
27758 586b42ed07abe20ffe81047b4b2fabb301def456fc6d7004e805b42adfbc8c04 682f7409ed4091089c67fc34 67e1258d54aaaa3a80096cc9 Bruce Harbison Bruce Harbison bharbison@comcast.net 016779 32 2025-06-26 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Ranjini Ridgway 2025-06-27 17:23:09 21.9 hrs 6861a04466b44939aab65490 000006637 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27757 fc451befa995e9d0ef0f8f399edee828280dad1265e514d44d6636ec9481cd53 68236d3e65215a088fcd10d9 68236c301ceb1007d97971ba Jean Vogel Jean Vogel jeanvogel06@gmail.com 017229 9 2025-06-26 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Gillian B. 2025-06-26 19:26:50 -0.1 hrs 68236d3e65215a088fcd10d4 000005352 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27756 7999f1c67af13ec0c0693e4d9d8afccf3edc91198ef312c587a49333604cf07e 681a2b745904814a881c8cb1 67ced4147abf9f3ed8febfd6 Karina Lenser Karina Lenser karina.lenser@bvsd.org 008794 79 2025-06-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-06-26 19:32:00 0.0 hrs 681a2b745904814a881c8cb0 000004394 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27755 6f5e07bcd6d12ad3677771b9bd15b325266d4c6e2ad6cfc051c2fac5a3a1f70e 6819229f12ac5577f787bc3e 681921793697d107807166fd Kay Miller Kay Miller kaymmiller@gmail.com 017178 6 2025-06-26 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-06-27 17:13:30 21.7 hrs 6819229f12ac5577f787bc39 000004324 5.00 464.00 130.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27754 4b53eb0db14f1fdc66e90422fb1cba2c34dea8f36bbd4957e2a40cf9ebddc720 68114b8ae03eca6702fe2db3 681149bf14b3a0089af3b6b9 Maria Bradshaw Maria Bradshaw nenakat@msn.com 017153 17 2025-06-26 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-26 19:30:45 0.0 hrs 68114b8ae03eca6702fe2dab 000003886 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27753 f0f84e89a4abbfcfb9fb4c325789182127b4a5d5ff9f76b1da12f8d72abe41b2 67ead99f19eaf107980f7111 67ced2fe7abf9f3ed8fe68f2 Diana Anderson Diana Anderson oldsend44@gmail.com 001381 27 2025-06-26 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ SL pt conf cxl Sophia L. 2025-04-04 20:14:31 -1991.3 hrs 67ead99f19eaf107980f7110 000000485 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27752 987e8363c7dcbb486f379e982fd5b28cfb78708ac0dc49c950043f92d5fdb442 67e672b5ceb9f104f0291535 67ced4ef7abf9f3ed8fee7de Anne Remley Anne Remley agr1@me.com 012209 37 2025-06-26 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Dawn Singleton - Gillian B. 2025-06-26 19:39:17 0.2 hrs 67e672b5ceb9f104f0291534 000152147 4.00 106.45 96.45 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27751 9f715b21394002b45a65ddfc288d0d964f67076b954b9222d7e3d6329e744fc7 6852f0a0a7ebe634b71011e5 67ced4b87abf9f3ed8fedeb4 Andrew Novak Andrew Novak amynovak10@gmail.com 011427 13 2025-06-26 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Samantha Saunders OOT Marguerite Barth 2025-06-25 14:17:34 -29.5 hrs 6852f0a0a7ebe634b71011e4 000009754 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27750 a684f0f0d688ab99f5d93156e0d89be2e8b42f97a084d7cc82e4c4aa3f08266d 6841d483da0b4d66f3ac1221 67ced3397abf9f3ed8fe82d2 Kim Copeland Kim Copeland kccopeland28@gmail.com 003589 45 2025-06-26 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Peter Gagnon 2025-06-26 19:51:31 0.1 hrs 6841d483da0b4d66f3ac1220 000008451 3.00 40.00 40.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27749 1eef722befe691165919648159c86c1038b47231a3205a1ee69c06f20ff9369a 68308c3c19407ce0a2d5dbb8 67ea9760128d6a27c05dd70a Kerrie Lessway Kerrie Lessway klessway91@gmail.com 016917 15 2025-06-26 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Maia H. 2025-06-26 19:39:42 -0.1 hrs 68308c3c19407ce0a2d5dbb7 000006766 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27748 95102bab584c07ce0c8a5b634df602fe863813dc8301be9e3a175daab6aaeac5 68264883a0079da4d4ffc51c 67ced4bb7abf9f3ed8fedf23 Dale Picciano Dale Picciano piccianodale@gmail.com 011464 37 2025-06-26 No Show 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-06-26 20:20:47 0.6 hrs 68264883a0079da4d4ffc51b 000005809 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27747 44a9b705776b88af5c67580404117d1d5cc3bf4549c5ed5684838cfca1560a9e 681bc265c6d9c9974599e25d 681bc031b1836d080ad0ba91 Carole Strong Carole Strong strongcwith3@gmail.com 017196 17 2025-06-26 No Show 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia L. 2025-06-26 20:00:14 0.3 hrs 681bc265c6d9c9974599e25a 000004680 5.00 0.00 0.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27746 7a21a8d7929161822dbbd902043f0f8cc7ff4dd63673af5c62e8f633a80e5f0b 67ffdac562cbd068ad1bf230 67ced2ff7abf9f3ed8fe6931 John Anderson John Anderson anderson.john@comcast.net 001402 50 2025-06-26 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Maia H. - Elizabeth Cousins 2025-06-26 23:44:25 4.0 hrs 67ffdac562cbd068ad1bf22f 000002420 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06
27745 af30e0f560dc13846e775175045d3de7838f3c5111c7bf734d03443cc527e6ed 67e672b4ceb9f104f0291513 67ced4297abf9f3ed8fec426 Asher Liles Asher Liles asherjliles@gmail.com 009162 51 2025-06-26 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-06-27 17:26:04 21.7 hrs 67e672b4ceb9f104f0291512 000152146 3.00 55.00 55.00 - - - - - - - - 2026-02-19 23:41:00 2026-06-12 00:07:06