General Visit (PT Boulder API)

Total rows: 100,726
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
12695 297bd56e2f9b9748b35e66e7f44228bda3df35a1b2f3b5487bdc4a83cd254942 68d2b69194a569e0172a447d 68d2b51907213e079588f54d Christopher Walzer Christopher Walzer chriswalzer@comcast.net 019916 28 2025-10-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sophia L. - Sonya C. 2025-10-29 14:55:11 -0.1 hrs 68d2b69194a569e0172a447c 000020575 3.00 75.12 59.85 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12694 5248b7b1296ef8849ff3c0e95c9c11b567b321e79bcc4c79457d97607ad89d19 68baf139f45d4ebac1e82cf0 67ced3737abf9f3ed8fe9711 Diane Flouris Diane Flouris dflouris@comcast.net 005316 25 2025-10-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-29 14:52:00 -0.1 hrs 68baf139f45d4ebac1e82ced 000018850 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12693 3cb53f214e986f62a6a3f787e6f3d8d7623e8c1abcd8da96f9b931eb4839bf14 68a5f26dc0168a32beaba8f4 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-10-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-30 18:06:04 27.1 hrs 68a5f26dc0168a32beaba8f0 000016901 2.00 85.00 85.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12692 0ef5decf26cb91ee57a03e49daf945e8245f5b447f1dd6346f0d824b97828209 68a5eea9867cb008473c278f 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2025-10-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24_ emergency came up- sc Sonya C. 2025-10-29 12:01:39 -3.0 hrs 68a5eea9867cb008473c278e 000016892 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12691 fcee9c7053cd5cb2c70a57a611d2b8969adbdafe659d25b02377d20515018ddd 68f24745cc78a608ab4c98a2 67ced3327abf9f3ed8fe801d Paula Connelly Paula Connelly paulamjconnelly@gmail.com 003358 44 2025-10-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Rosey Reed 2025-10-29 15:06:09 -0.1 hrs 68f24745cc78a608ab4c98a1 000023848 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12690 8025be4edc8688349a4e1e0fcfde5713aa873042ef7024921b7ca62471a40eb9 68daf51832795279c4d0494d 67ced3537abf9f3ed8fe8c6a Barry Gassman Barry Gassman barry.gassman@gmail.com 004407 41 2025-10-29 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt has DMV appt, need to rxl - RAR 10/21 Rosey Reed 2025-10-21 21:16:22 -186.0 hrs 68daf51832795279c4d0494c 000021558 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12689 181d8e119b68982fdb0d504f63cf2e153f46dbaa7095762e6c4de28d9fbbec75 68c42d04e77a3d07a6c9ed05 67ced4877abf9f3ed8fed616 Deanna Patton Deanna Patton dleet1951@gmail.com 010692 97 2025-10-29 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Mark Leo Guevarra 2025-10-30 19:12:41 28.0 hrs 68c42d04e77a3d07a6c9ed04 000019631 3.00 81.69 81.69 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12688 aa2b5a69b31f01d283751162af923d197f17edaa445f6a54604f829afbac9367 689b85431a0dcf08933b1e6e 67ced6577abf9f3ed8ff1a41 Anna Yu Anna Yu anna.paulson1@gmail.com 016506 88 2025-10-29 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl SL 8/13 Sophia L. 2025-08-13 17:38:28 -1845.6 hrs 689b85431a0dcf08933b1e6d 000016032 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12687 45a8bed3a6f6f44628a9ab565597371e08a44895fd33a297ba0255b91b953dd8 68782a9b1feff75b1ed79685 67f9602ca72fbb50374a4725 Renee Hopper Renee Hopper reneehopper@outlook.com 017038 20 2025-10-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-30 17:53:32 26.6 hrs 6903db5a02818e135f28501a 000013293 4.00 85.00 93.50 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12686 0d53e5a6d6a5e274ce4689b3fa155423d65106c60c62ebdca2171ec4a887bf73 68557688fa24df076410e5e4 67ced34d7abf9f3ed8fe8a3c Barbara Eng Barbara Eng bbeng5843@aol.com 004221 154 2025-10-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-10-29 15:29:03 0.2 hrs 6905062ca34eefb0569ae0c1 000010104 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12685 0e86072b846164ed7798e81cf379507d24e23fd2a04bafe6e39ffd0bb0957731 68c07ae0cb34102eb3de52d7 67e1258854aaaa3a80096c12 Vicki Hergott Vicki Hergott v.hergott57@gmail.com 016718 20 2025-10-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-31 19:00:26 51.5 hrs 68c07ae0cb34102eb3de52d6 000019219 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12684 1cfde459565d25819df9ab6e213ddcba366725960e453c17b83d586adf188553 68a7413c3d6cfb7e22f624bc 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-10-29 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-11-05 20:33:02 173.1 hrs 68a7413c3d6cfb7e22f624bb 000017044 4.00 95.48 100.48 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12683 f409e18b77c7bcc46b86936481f87b41b4dff1ea05a8776b7e0e312c8ee6e411 687faeec179750079aeeb432 67ced33b7abf9f3ed8fe839e Dennis Donigan Dennis Donigan ddonigan@att.net 003657 94 2025-10-29 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway 24+ per email request - sc Sonya C. 2025-10-28 12:43:58 -26.8 hrs 687faeec179750079aeeb431 000013789 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12682 2ba50e4336c3326549567229d1f7b2b8c04b931a49d1135778cc993f821e0e59 690123a049a3ed09e58e03dd 67ced2f97abf9f3ed8fe65e6 Ross Alper Ross Alper rossta33432@yahoo.com 001121 72 2025-10-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-29 16:02:38 0.3 hrs 690123a049a3ed09e58e03dc 000025116 5.00 95.48 95.48 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12681 972763ecaf564c347b7f52d0b896aea0993c016c5d1c0503c1639e739a32d3d3 68b8a42ade05962b56b58d7d 68518846e818be07f5bf4fd9 Lawrence Johnson Lawrence Johnson saredagj@mesanetworks.net 017458 29 2025-10-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-30 18:07:18 26.4 hrs 6903db219cff928f010f3b78 000018604 3.00 130.00 130.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12680 81553d0abc71114300f9ca25b77a5d8c983ad2ec7c0c66c3ffabaf5a67cdd364 68ff88dc6ce534092eaa65f2 68dc1d6e66e8a2afcd08ef45 Jannet Eggers Jannet Eggers jannet.eggers@gmail.com 019958 9 2025-10-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-10-29 16:04:37 0.1 hrs 68ff88dc6ce534092eaa65f1 000024854 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12679 70e1dc2dd1ea513661148249dd5b1b4a08da4ecda79d1159e80a3172bc607f49 68ff72c713900a09315397d0 68fa7ebb69e0fa6ec6803b84 Donald Craig Donald Craig brentcraig1021@hotmail.com 020137 11 2025-10-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-30 18:37:55 26.6 hrs 68ff72c713900a09315397cf 000024850 4.00 85.00 145.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12678 bf9faabdcb54a70be8f96de24aa9b7cc6871377ffc06caa31773a279dca9a78e 68f6554b9428d48bfa13585c 68e57edc6bb8aab7fdd69bad Elizabeth Bahnsen Elizabeth Bahnsen eabahnsen@gmail.com 020009 15 2025-10-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt conf cxl SL 10/27 Sophia L. 2025-10-27 16:13:59 -47.8 hrs 68f6554b9428d48bfa13585b 000023981 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12677 fc1233f41b036ab5397642769188ff04aa4a8de4cc210667918e99067a0222c4 68dd684db3b61d09d5c56b80 68780ba15e5c1c084cf2ff9a Arthur Saltarelli Arthur Saltarelli a.saltarelli@centurylink.net 017639 8 2025-10-29 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Miranda Samson 24+ pt conf clx SL 10/28 Sophia L. 2025-10-28 20:04:40 -19.9 hrs 68dd684db3b61d09d5c56b7f 000021869 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12676 6258fd6dd9bd8a170efc919f777a5601e70450899e91526a9ae903e64c47d9ad 68dd60bc4a7b4d7108443694 67ced6627abf9f3ed8ff1baf William Zuromski William Zuromski bjzuromski@yahoo.com 016628 36 2025-10-29 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 10/27 Sophia L. 2025-10-27 14:45:01 -49.2 hrs 68dd60bc4a7b4d7108443690 000021850 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12675 c48a066e22c6a289ec61dae08dd9221f90084b26d9644e2d0d41085a33b34808 68dd5d44df6b3708edec97d2 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2025-10-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Rosey Reed 2025-10-29 16:02:31 0.0 hrs 68dd5d44df6b3708edec97d1 000021846 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12674 716113e423f604f044ceb5dfbd1f9da5b7de89dfcec90090b57b00cbb94d541e 68d2d4691d0eb0b05ef62713 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-10-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ tendon undone, surgeon said stop PT for now - RAR 10/16 Rosey Reed 2025-10-16 17:41:29 -310.3 hrs 68d2d4691d0eb0b05ef62712 000020642 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12673 b6f025b95f245ef378671c6ced1db0ac0235bf059673352ca5257b36650ddc8d 68c9c128657dcdce00f1e72f 68c9bf5f0a0dc60c1d045231 Amber Williams Amber Williams ambyrlight@gmail.com 019876 11 2025-10-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Mark Leo Guevarra 2025-10-31 18:17:55 50.3 hrs 68c9c128657dcdce00f1e72e 000019942 4.00 310.00 20.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12672 766a313ba367863ef243e960a1afcc7459c037445b0f8f2c6d97f16d173f0f76 68c9a1f98cbdaf72c31bdaef 67ced4567abf9f3ed8fecd07 Arlene Osgood Arlene Osgood aosgood1937@gmail.com 009919 62 2025-10-29 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-10-29 15:50:31 -0.2 hrs 68c9a1f98cbdaf72c31bdaee 000019893 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28
12671 228987ecd0bfdbc771c7a039db7a8e1754d51007f4f540684f47502b666e4092 68c899e84948f4c9e89d068f 67f68f3fa46f33086765ff96 Paul Encinias Paul Encinias e-boys@comcast.net 017018 25 2025-10-29 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips 24+ pt needs Sx - RAR 10/17 Rosey Reed 2025-10-17 18:24:57 -285.6 hrs 68c899e84948f4c9e89d068e 000019854 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:37 2026-05-06 23:23:28