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
15453 8d383a69cd9ab6ab93190479a26bef0263d36e241526c3d3ec8d9e7f2cf5aeb4 68c084ad346696080b20990a 683e2243b8ecd2c9d651a06e Marshall Frech Marshall Frech mfrech@tec.org 017372 43 2025-10-06 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per VM request - Cigna not paying for appts - sc Sonya C. 2025-10-06 12:42:30 -7.3 hrs 68c084ad346696080b209907 000019249 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:53
15452 fe5a96a76b20dd8aabf6d0471c9110d6aaf5acdd7fd1810bd6664dbd25a2a2fd 68bb27d7842ce706c2fe9a09 689df1c5d4bed0085e0d7339 Kenton Younkin Kenton Younkin kent.younkin@gmail.com 017796 7 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-10 15:13:19 91.2 hrs 68bb27d7842ce706c2fe9a08 000018940 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15451 8bd00f8dff7784ef6f2e404b518b11d8964957b036ac5a9974c8dc1a7e6d030e 68adf5fc15d4d207dafade8e 68adf51e15d4d207dafad28b Susan Anderson Susan Anderson andersonsusane@msn.com 019745 6 2025-10-06 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Michelle W. - Sonya C. 2025-10-06 19:58:41 -0.0 hrs 69827960bca44c5d10653ee3 000017584 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15450 311d774bb48cce04db5c23118b7e87e9d5f9449317c12341af6027916fdb11aa 685d6df47d774308254c3614 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-10-06 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - Rosey Reed 2025-10-06 20:47:39 0.8 hrs 68e6e896d58429eb22dd9036 000010901 4.00 133.86 106.65 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15449 842102025facb1b472cbfaebad3ca97cf929ac18df10d1248013a50f3ec15646 68caf12943dc8a0758c994b9 67ced52e7abf9f3ed8fef1db Andrea Sedlmayr Andrea Sedlmayr andreasedlmayr@gmail.com 013061 92 2025-10-06 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Laura Shove 2025-10-06 20:58:58 0.7 hrs 68caf12943dc8a0758c994b8 000020029 4.00 104.99 104.99 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15448 9f36d9f68062bc9ec101f9e4835707b4b562df8bb73454277275e022615e0c54 68b83f4f77fc5ebcf6beecd1 67ced34a7abf9f3ed8fe8928 Matthew Elam Matthew Elam matthew.p.elam@gmail.com 004129 24 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-09 15:03:13 66.8 hrs 68b83f4f77fc5ebcf6beecd0 000018463 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15447 7c3affb65bb41e369edac4f31b952816e25eff07685e71791fc006ab926c16cc 688920020f95600f74c84f2b 67ced4ce7abf9f3ed8fee253 Andrea Poniers Andrea Poniers andrealeni@earthlink.net 011736 24 2025-10-06 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/12 Sophia L. 2025-09-12 17:14:35 -579.0 hrs 688920020f95600f74c84f27 000014628 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15446 7a54182d94c53b6e340c55e49cbb3f146a525d9b9f2b60874e2ea70681addbf2 68e3df57753b0509a0a0986c 67ced6587abf9f3ed8ff1a62 Tracy Zaik Tracy Zaik tracyzaik@comcast.net 016517 55 2025-10-06 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed Spoke to pt at 1:24pm - PJ sick - RAR 10/6 Rosey Reed 2025-10-06 19:24:52 -1.1 hrs 68e3df57753b0509a0a0986b 000022282 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15445 6269f38137e5e760c3ae50fedf4f394a9e3a56b8cf0e43f6c1e78a7d4141f590 68d441619af4d01890fcf5c0 67ced5d97abf9f3ed8ff0a15 Virginia Wadsworth Virginia Wadsworth vawads@gmail.com 015127 188 2025-10-06 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+, per VM - Pt is in alot of pain and needs to go have Xrays- sc Sonya C. 2025-10-06 12:47:24 -7.7 hrs 68d441619af4d01890fcf5bf 000020866 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15444 b23ce327b8888d1631ecf03d05e5497affd41a9f2e3dae106eb6848868359f56 68c08396f284f5f7cbd76046 67ced5b07abf9f3ed8ff04b7 Kayla Smith Kayla Smith thekaylajsmith@gmail.com 014669 28 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 16:41:06 68.2 hrs 68c08396f284f5f7cbd76045 000019230 3.00 80.48 115.48 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15443 68391e7ca1cab98b2156797861458d38734fe709c2631f4cbda89ea80a753596 68bf2ce0171f3f1c911a5ded 67ced40a7abf9f3ed8febdca Nicole LeBoeuf-Little Nicole LeBoeuf-Little ferdinand@littlebull.com 008620 38 2025-10-06 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Peter Gagnon 24+ pt conf cxl SL 10/3 (MD appt) Sophia L. 2025-10-03 15:24:03 -77.1 hrs 68bf2ce0171f3f1c911a5dec 000019076 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15442 0ade577412b34f5a9612b4914cdf0b4e8a2041040a1b6173c24ff7e32dfa6198 68bf21593238690fe639762f 68bf1ece4c373c9c32dc0a2d Benjamin Mcchesney Benjamin Mcchesney kmcchesn@gmail.com 019819 40 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ schedule conflict - sc Sonya C. 2025-10-02 18:04:00 -98.4 hrs 68bf21593238690fe639762e 000019051 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15441 4fdda2f8e76b1b0ceca8d23a4f945e28a0c862aca443d1681a72c28b4eea6a94 68c8819223a386e1614ae6b9 68c880399ec5d41f375d6e58 Lynn Hildebrand Lynn Hildebrand lynn.hildebrand@colorado.edu 019861 17 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-10 14:25:14 89.7 hrs 68c8819223a386e1614ae6b8 000019829 3.00 235.00 20.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15440 04c21a0d76746510e0108a6c8ca1253578c504029927442c82d157784c9b5607 68c87eb3cc327823700d6183 67ced3777abf9f3ed8fe985e Colleen Grande Colleen Grande collgrande@gmail.com 005427 70 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-10-09 15:05:41 66.3 hrs 68c87eb3cc327823700d6182 000019822 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15439 19d78f26811a1854d95a30c88e3c16066647e87f1d2dec833d37e2ff02e88ad0 68b9d2a7fe5f00df0ba7effd 6890cded11a7af0803467727 Judy Hinks Judy Hinks hudy@ptboulder.com 017745 24 2025-10-06 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 20:42:52 -0.0 hrs 68f13da0b72986f10f16be90 000018717 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15438 716fdf9bc27e8c909717d3b928f1d35aac726bb4f966a5468aabcfc3317dd4ae 68dc488f445921091736eada 68dc485c899c2e09550fcec4 Lisa Beshore Lisa Beshore lhbeshore@gmail.com 019961 18 2025-10-06 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 18:11:37 357.2 hrs 68dc488f445921091736ead9 000021720 4.00 82.00 8.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15437 57d3405a2935ffc294483d8d5723bb299bf02594af0e786e80f797c73fd0c717 68b8aabf9990e008485498b1 67ced6617abf9f3ed8ff1b76 Emily Zora Emily Zora emilysartgrove@gmail.com 016609 147 2025-10-06 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. LVM for pt that PJ is out sick - mw 10/6 Rosey Reed 2025-10-06 20:43:09 -0.3 hrs 68b8aabf9990e008485498b0 000018608 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15436 fa1f1005323563f263ac4a9c7fa63f28bcb3c683dc70b54ab498df27ff37c856 68b7551040f54d21c350ece5 67ced4857abf9f3ed8fed5ce Clark Myers Clark Myers myers.clark712@gmail.com 010668 97 2025-10-06 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-09-03 16:22:20 -796.6 hrs 68b7551040f54d21c350ecd9 000018397 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15435 341e8ba5cc74da38fbd13738a6d55ac783bd46ccc207665cc26463b294e18980 68ae43fb58eeb35d48fccc85 68a499beca96e381ab336765 Natalie St Denis Natalie St Denis natalie@stdenislong.net 017821 54 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Frances Lawrence - Sophia L. 2025-10-06 21:00:17 0.0 hrs 68ae43fb58eeb35d48fccc84 000017680 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15434 5a23027d3d9832743336e5161e6e8efa164360d66995b71c09c87ec121dd49ae 68911c7519c3e107a9faa05e 67ced5d97abf9f3ed8ff0a15 Virginia Wadsworth Virginia Wadsworth vawads@gmail.com 015127 188 2025-10-06 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+, per VM - Pt is in alot of pain and needs to go have Xrays- sc Sonya C. 2025-10-06 12:47:34 -8.2 hrs 68911c7519c3e107a9faa05d 000015305 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15433 c57b6dee697a81b1defde3f0dde6a45ff47e9ad91e2e398dc730daf9f23d3e81 688108747a52071948c6dbb5 67ced5857abf9f3ed8fefeaf Deborah Usrey Deborah Usrey dusrey2@msn.com 014155 14 2025-10-06 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. No longer need appt - sc Sonya C. 2025-09-29 21:35:02 -167.4 hrs 688108747a52071948c6dbb0 000013984 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15432 fa6275099cf16ffafa5c21dfe9e925462f9135abe120ab5e4ade96dfaaf5a51a 68b9bf91131055860d0256f4 67ced38d7abf9f3ed8fe9f00 Julie Heins Julie Heins itnotpa@comcast.net 005993 68 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-10-06 20:09:23 -1.1 hrs 68b9bf91131055860d0256f3 000018680 3.00 63.74 63.74 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15431 bfebcdafd8e4da2d13e528014c25706562d078c65af682474d0b83c052f764d2 68d2b6e7fa23865441a78003 68d2b6c2a59b20a62e165909 Pearl Crespin Pearl Crespin crespinpearl@gmail.com 019917 8 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67fea39d8c6bf607d763e7ee Kaiser Pelvic Floor Initial Eval 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-20 21:45:50 336.3 hrs 68d2b6e7fa23865441a78002 000020576 1.00 150.00 150.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15430 59f7de2ff4a2c7eaee126ed2252e9f7933cee73d7fa724a4a37f816e40a19053 68c47fbffc7646cf06b572f8 68c47e778ddde062ad6a73c8 Jeanne Visvader Jeanne Visvader jpvisvader@gmail.com 019849 22 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-10 14:28:19 89.0 hrs 68c47fbffc7646cf06b572f5 000019726 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52
15429 4ec6ba6cfc52b05671767076d1f55d07e3ba115e1aa0d2f1b304a8b3f48b705d 68ba01b1fbbbe6085617849e 68a8153699c65c4a78a5fa31 Charles Izurieta Charles Izurieta charles.izurieta@gmail.com 018691 18 2025-10-06 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl didn't say reason SL 9/22 Sophia L. 2025-09-22 22:16:05 -335.2 hrs 68ba01b1fbbbe6085617849c 000018795 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-06-11 23:35:52