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
22565 b3a7c4b44657a0cb533a784720c81e30e7fb21a71f53e3d53c716811e0f885d4 68813c76332435f904de552f 67ced5487abf9f3ed8fef5c2 Sheryl Runnells Sheryl Runnells sheryl.runnells@gmail.com 013394 49 2025-08-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Maia H. 2025-08-06 18:23:40 -0.1 hrs 6893c2c80a384908158ad0bf 000014086 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22564 6dae7e5a7c08141b8b58c9a4983fbbc7fdaacc7d5506582115e4641bf9caf34d 68711eda0ad2e33c2a686e13 6866f41cf297cfc1ca346f5a Mary Blatchley Mary Blatchley mar-mar@blatchley.org 017572 17 2025-08-06 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-08-06 18:20:18 -0.2 hrs 6895fcd46d4d81087849f78d 000012590 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22563 023ac1cbe80e94c18ae596f10988f92faa7bbf4765f8cd8a565a9bd7c81a4890 686d8888d243a007824417eb 686d83c53347a8916e8c0b3a Deborah Cook Deborah Cook dcook1606@gmail.com 017590 7 2025-08-06 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ sc Sonya C. 2025-08-05 15:30:33 -27.0 hrs 686d8888d243a007824417ea 000012167 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22562 8256d3c08c8ea50044107ac6566a53a502f1c9469688a42f89e3947a3ae285ee 686bddbd872f8e080209075c 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-08-06 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt is not feeling well - sc Sonya C. 2025-08-06 15:16:28 -3.2 hrs 686bddbd872f8e0802090757 000011876 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22561 c4b7e9e59b662fbaa3d98e74a3343080eb9d3aed2e54b53a9a28105cdd72adf7 6866c2763b259307d24e4f14 6866c06dded4c1d848142b3a Ann Bardwell Ann Bardwell annbardwell6@gmail.com 017569 11 2025-08-06 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-08-05 20:41:50 -21.8 hrs 6866c2763b259307d24e4f13 000011756 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22560 afdacc11377f491bf40f2d22b219134104e59ed0209206ddebc96fa26f68605c 686568f13fb9f8292ff19930 67ced5a37abf9f3ed8ff02d8 Aaron Stoddard Aaron Stoddard builderaaron@hotmail.com 014510 125 2025-08-06 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. - Maia H. 2025-07-28 17:58:46 -216.5 hrs 686568f13fb9f8292ff1992f 000011620 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22559 fa6306c0355521ce8b3ea69d83516880135b64a121bf9bc653b277b7af62ad2a 68645062c5ec6007f617e524 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-08-06 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-08-06 20:42:47 2.2 hrs 68645062c5ec6007f617e523 000011512 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22558 42d0a1c4d7b0107e2ae00b3a277c6d7f8177268d95a5596f953da9514c90664c 685acadb0be1b98d64771e02 68598a154349520843ad7c9e James Townsend James Townsend jdtownsend@comcast.net 017502 24 2025-08-06 No Show 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Sarah Emrey 2025-08-06 18:57:54 0.5 hrs 685acadb0be1b98d64771e01 000010483 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22557 b1c09a8b66e8f4c54381b16b382f0511bbcbd810fe6b2984cba11abfc5300ea6 6859d0a25f0a5d130b259885 67ced5877abf9f3ed8feff03 Elizabeth Vaillancourt Elizabeth Vaillancourt elizabethramaker@hotmail.com 014183 8 2025-08-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-06 21:04:50 2.6 hrs 6893bf91087f0547934ba3c2 000010442 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22556 4b079d5aa8118852ac3331daa4634543bc08ebef909866ad264a9ce009fd79b6 6809453380931908115ccaf9 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-08-06 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sarah Emrey 2025-08-06 18:43:25 -0.0 hrs 6809453380931908115ccaf8 000003278 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22555 9ba962eca51eb4509976b90bb7dde9fa3a954ae4c1de1e7afaac5535163502b8 688a8d25cdce5f07ede4fa44 6862eb32a05fdc610cc14082 Margaret Carter Margaret Carter gretchdavis@comcast.net 017547 8 2025-08-06 Checked Out 68535c6303dd08c79c018795 John Reed 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-07 14:51:37 19.9 hrs 6894beb67a3e6e082ea47a14 000014873 4.00 60.00 60.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22554 1ea448d9f9865681a430411739a166ad4d876b40a8efc86af3515dabe5d946fd 687e9722d1fdf007f7cd83c6 687e95f38a0f42fc75c492f8 Dina Cilke Dina Cilke dacilke@gmail.com 017664 2 2025-08-06 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-29 14:02:43 -197.0 hrs 687e9722d1fdf007f7cd83c5 000013692 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22553 59cd54d22b57843ec2a7b59c0f96c93105fabec460049550bb3a508875dbd5cb 6879359e64b40a0283746afc 67ced5277abf9f3ed8fef0c7 Debra Scott Debra Scott niwotskincare@yahoo.com 012969 8 2025-08-06 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Hope Adair 2025-08-06 19:13:37 0.2 hrs 6895fce85026f00787c055bb 000013381 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22552 556f9c3b182b44e3a3eac195a9281f8d8c2d6ad6c48867f703ed2425537d42df 687811737275e60790ac50b2 67ced3047abf9f3ed8fe6c61 Laura Dangelmayr- Rosenthal Laura Dangelmayr- Rosenthal lcdang84@gmail.com 001674 28 2025-08-06 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-12 16:05:40 141.1 hrs 687811737275e60790ac50b1 000013270 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22551 0b5e9943d4a7efe1e8d031819a84d9093d0d6100940a69225fa998ac4711ef65 686fff931b8c28ea0e145ccb 67ced4b37abf9f3ed8feddbe Elsebeth Nordlund Elsebeth Nordlund ednordlund@gmail.com 011345 24 2025-08-06 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Samantha Saunders - Sophia L. 2025-08-05 18:53:55 -24.1 hrs 686fff931b8c28ea0e145cca 000012478 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22550 ea8ee7960c75ffb04e88ec8d17f54bb6f842d8fe7152f02458658c2f44e14c5b 686e86afe04d4b07f1e6af0d 67ced2f27abf9f3ed8fe612d Adrienne Cannon Adrienne Cannon adriennecan1@gmail.com 000718 18 2025-08-06 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Emily Pickner 2025-08-06 18:27:57 -0.5 hrs 686e86afe04d4b07f1e6af0c 000012244 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22549 942038acd654ddec2197da205f21c360674ff8d8767985e51024fd49ccb44ed7 6866de2f4d9eded6714c142c 68433cce75c7b0f1beb7313c Neil Sherman Neil Sherman nsherman0@icloud.com 017413 56 2025-08-06 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-08-06 19:14:52 0.2 hrs 6866de2f4d9eded6714c142b 000011798 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22548 6c9610bfafacb50f047d257fc9a9fc3eb46dcdd2f1ca2a4fe79556310f9bebaf 685acaeb66dd7012e7d3bd40 68598a154349520843ad7c9e James Townsend James Townsend jdtownsend@comcast.net 017502 24 2025-08-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Ranjini Ridgway 2025-08-06 21:02:15 2.0 hrs 6893c2e24b76da5b183eacf8 000010484 2.00 60.00 40.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22547 d51830e5377689b13cc23b0842ce3a29d3bdbb98b07115cfab30cec2aa6a333d 684b45ea035a4c078498d641 67ced4ef7abf9f3ed8fee7de Anne Remley Anne Remley agr1@me.com 012209 37 2025-08-06 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Maia H. 2025-08-04 16:31:35 -50.5 hrs 684b45ea035a4c078498d640 000009221 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22546 cacd489c95b0eb6b6331f09b401f983673df3a0f5e190f1f6ee32a3c07a06049 683f5f03f47eb80393a13c13 67ced47d7abf9f3ed8fed460 Kathleen Parrish Kathleen Parrish kmcgparrish@gmail.com 010546 39 2025-08-06 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-07 14:35:59 19.6 hrs 683f5f03f47eb80393a13c12 000008033 3.00 90.49 90.49 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22545 ef1c064a3dda06e25f51070a0102333c93609d5ca8e9cfd3fb9e6b5e5594d524 682f6d7cafa325ab428a662e 67f3ff485bbcae0896dc99ca Angela Houghtaling Angela Houghtaling ahoughtaling17@gmail.com 017002 17 2025-08-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Ranjini Ridgway 2025-08-07 14:44:19 19.7 hrs 6893b30dc8638737a38a2449 000006633 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22544 6702dd177271fd939356897a421c6aeb4407878ea8b95dc6d8583f9d68e7b69c 68263d6acbcec6dde923ef02 67ced4177abf9f3ed8fec075 Jane Manning Jane Manning jhmanning5@gmail.com 008847 90 2025-08-06 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 6/12 steph out Sophia L. 2025-06-12 20:16:23 -1318.7 hrs 68263d6acbcec6dde923ef01 000005790 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22543 98580f528c0e273ff5d58959f3760a3cabcce3d25611a9d7eaf019a7f512bf45 6824e382a6f48da6fc31cbb0 67ced3007abf9f3ed8fe6a4e Kimberly Cates Kimberly Cates mscksc@gmail.com 001497 17 2025-08-06 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-06-11 20:35:31 -1342.4 hrs 6824e382a6f48da6fc31cbaf 000005560 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22542 efbc48443039231df22c25a4b96388cfdefed9ce3861cd010632696b19ac1275 681cd0bb34703907b4e13a91 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-08-06 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Ranjini Ridgway - Eva Tucker 2025-08-06 19:05:44 0.1 hrs 681cd0bb34703907b4e13a6b 000004794 5.00 253.38 253.38 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53
22541 7e2bfdedb2f401269da6d66fb34eb995ca0c5c627c335411aca3a3048efb9aeb 67e671ebceb9f104f028dd0f 67ced5cf7abf9f3ed8ff08cb Michael Sullivan Michael Sullivan jazzdharma@comcast.net 015017 225 2025-08-06 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-08-06 19:32:56 0.5 hrs 67e671ebceb9f104f028dd0e 000151836 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:26:17 2026-06-11 23:53:53