General Visit (PT Boulder API)

Total rows: 101,513
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
15766 d28cc334ca019e7b4ae19207a07ccfe9b5f0a046d39d21c8a606456cc14583be 68d41e3e3cda52f0bf258526 68d404ab702b09089b886b23 Marion Mackay Marion Mackay mackaydesignllc@gmail.com 019925 21 2025-10-02 Checked Out 68535c6303dd08c79c018795 John Reed 67e84dd55868616a0a1bdc44 Kaiser Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-10-22 15:53:18 476.4 hrs 68d41e3e3cda52f0bf258525 000020831 5.00 150.00 150.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15765 4da3330a83afa895b526b8d0c7e6f925c62b1859e025f764dc7d5a3bae666443 68af73343b353a3c826289c1 68768f6512dec008227b82b5 Annie Burgos-Buenfil Annie Burgos-Buenfil aburgosbuenfil@gmail.com 017632 9 2025-10-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Sophia L. - Samantha Saunders 2025-10-02 19:31:55 0.0 hrs 68af73343b353a3c826289c0 000017904 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15764 3717b9429ae82b380a2f45824cac58918a3c53e9f898c66be8ff2606efd7eff4 68af20b044911820b454bdbc 68af1e5ded4ab7088d7ec5df Asher Echery Asher Echery echeryaa@gmail.com 019754 8 2025-10-02 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Sonya C. - Sophia L. 2025-10-02 19:56:32 0.4 hrs 68af20b044911820b454bdb7 000017725 2.00 85.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15763 94e32e5b0e8bd88c5ab44233da9feaf2c4db29548d7cbd2d823ef0caf2b798e9 6877d050f040d77fff5c3d90 67ced3327abf9f3ed8fe8029 Jennifer Dingman Jennifer Dingman devding@msn.com 003362 37 2025-10-02 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Kenneth Dave Francisco 2025-10-07 16:01:21 116.5 hrs 6877d050f040d77fff5c3d8f 000013166 3.00 84.92 84.92 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15762 868750b0c0c6da72061f8bdf7a00ad91fcf4e314b4dfc7932e2f0c83a749d904 686439be4a84fe082f14ca8b 67ced3357abf9f3ed8fe813a Michael Divjak Michael Divjak keschmeyer@yahoo.com 003453 459 2025-10-02 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-10-02 19:56:34 0.4 hrs 686439be4a84fe082f14ca6e 000011473 2.00 59.71 47.57 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15761 5c6c7d555ab8ac56763ad81833b61aa65054c5f6bedb8f5548cf5cdc745d4fe7 68dafeee40319f1a0eba9f7d 68c5941c5d39d86603721b8d Kathleen Candelaria Kathleen Candelaria kathleencandelaria@ptboulder.com 019850 18 2025-10-02 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-10-10 18:58:26 191.2 hrs 68dafeee40319f1a0eba9f7c 000021563 4.00 82.00 82.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15760 3ebf4f3a0fdecdee3d675d1d6d3d50fc0598bd1f1ae7ae1eadb62f3d8d347d59 68d5c8d7d9aa70d368d32a93 68d188cac20ba7d1517561da Donna Isaacson Donna Isaacson g_isaacson@msn.com 019912 12 2025-10-02 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Rayann Greer - Rayann Greer 2025-10-02 18:05:09 -1.7 hrs 68d5c8d7d9aa70d368d32a92 000021145 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15759 f0990ebf6048fa159215f2598f6362cc86e3df281cdc62d6b98fc2c5994ec61b 68d02effb2306a20a23748c3 68c9ae2ab1980b077ac60e90 Alyssa Grover Alyssa Grover ANKG@icloud.com 019872 10 2025-10-02 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 689983a679e412ce7c3dfcf6 Westminster Unpaid - Unidentified - - No Frances Lawrence out of town Frances Lawrence 2025-09-23 20:50:06 -214.9 hrs 68d02effb2306a20a23748c2 000020377 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15758 95542a76dbc97be15e8a085d8d21c5173f0cf055d87dbee49f848bcd2c198ef1 68b08db70ec9c9338600fbfa 67ced44f7abf9f3ed8fecbaa Wilma Ormsbee Wilma Ormsbee wormsbee@skybeam.com 009803 9 2025-10-02 No Show 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia L. 2025-10-02 20:04:54 0.3 hrs 68b08db70ec9c9338600fbf9 000018030 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15757 935edb8565f8cc8253ebc3d02cf751b1644340476981e76617adb386950bd05b 688bd0108b03db56e58a7663 67fd4353b995a307d33e336a Anita Vair Anita Vair atvjazz@yahoo.com 017046 31 2025-10-02 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. OOT- sc Sonya C. 2025-09-18 19:45:39 -336.0 hrs 688bd0108b03db56e58a765d 000015056 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15756 d9b794cf432d56e059faaab71e025c3f260c27b52e5fb90634876f21e4ace7f3 685c5a928e230c4bb43a843e 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-10-02 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Maia H. - Rosey Reed 2025-10-02 19:49:42 0.1 hrs 685c5a928e230c4bb43a8437 000010794 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15755 1c948b5f2fce538dfce2069b2272a57b31976e143920a8cdddaceb9c606e07fc 6822120de3c05b07deaa0916 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-10-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Ranjini Ridgway stuck behind an accident at the airport, won't make appointment today Ranjini Ridgway 2025-10-02 19:28:37 -0.3 hrs 6822120de3c05b07deaa08fe 000005153 6.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15754 da9155578ed3d4c1dc58ff48e66ce400a1b6353cce84138feb16c46a15805b66 68d4439e3be43cae3afcb1fc 67ced6617abf9f3ed8ff1b76 Emily Zora Emily Zora emilysartgrove@gmail.com 016609 147 2025-10-02 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Elizabeth Cousins - Sophia L. 2025-10-02 20:05:00 0.1 hrs 68d4439e3be43cae3afcb1fb 000020867 3.00 99.97 89.97 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15753 ae9dc5669f796b20782fbfd874de4ca11854fba5fce39cdaf87acca5ac3df9a0 68cc25f0905d06081987d0d1 68cc25192f8e8e088b7db45a Phillip Holt Phillip Holt chandlerholt2014@gmail.com 019889 9 2025-10-02 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-07 20:48:05 120.8 hrs 68cc25f0905d06081987d0d0 000020121 4.00 97.16 150.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15752 81ba39d110378f46739cb2772e12129e90b9a0fcf3bdb83d9568b210d64a9ab8 68c1ea976c21246ee7e7fe8d 68926efaa2296cf6d8663f1e Nathan Carr Nathan Carr nathancarr25@gmail.com 017755 8 2025-10-02 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Kenneth Dave Francisco 2025-10-07 18:17:10 118.3 hrs 68c1ea976c21246ee7e7fe8c 000019466 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15751 fcb7e8d823769e8d9c0b0f627667f6da50db03f123cf6c4b826da192f3e66418 68c1e834dda9b05547f03aa8 68c1e82a37432b1eb0a82954 Mary Furey'King Mary Furey'King maryfureyking@gmail.com 019837 5 2025-10-02 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2025-10-02 20:00:40 0.0 hrs 69174c48546f692bc6ba0335 000019459 4.00 387.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15750 71f288df904cfc785e8966f2920c389c793001e74e898b47324b3cc012823e94 6893cdea62d34708ac36523c 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-10-02 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-02 19:58:11 -0.0 hrs 6893cdea62d34708ac36523b 000015640 3.00 61.84 61.84 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15749 cb327be4b6bc20e5e007af8277cc98d7e17bbfc9583b808e4f58e9f3d569ea37 68dd7a7d4620e809e39995ef 67ced3617abf9f3ed8fe9138 Allie Winner Allie Winner allieferrey@gmail.com 004817 129 2025-10-02 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 68998453d9ae21be8001ca00 Boulder Julie Paid - Primary - - Yes Julie Petersen-Hanson - Sophia L. 2025-10-06 20:46:41 96.5 hrs 68dd7a7d4620e809e39995ee 000021911 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15748 618b72e7f60a32734f7c0b79c651c09524105c595d957da27e21ec082c840d2a 68d173428332aafbff3b2a45 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-10-02 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Sophia L. 24+ out of town. SMP Sarah Patterson 2025-10-01 13:51:22 -30.4 hrs 68d173428332aafbff3b2a44 000020429 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15747 13bed7e1912a8856c64f40755908aa84d2a2a77a33201abc0dd16b5cdca7d53b 68cb2de709cf39f2d8cce23d 68cb2cb2896d4d6d922bbdb8 Darcy Murray Darcy Murray darcy.lutes@gmail.com 019886 10 2025-10-02 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Frances Lawrence 24+ pt booked with EP instead - RAR 9/19 Rosey Reed 2025-09-19 17:11:41 -315.1 hrs 68cb2de709cf39f2d8cce23c 000020093 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15746 caa3b23225c3af03d6159c8e4b7e11f9ed199117717f9be17bba93dd68e49aad 68b88a69081b35c31ca8ad2d 682b4d2356f7b207bca1e778 Peter Shelley Peter Shelley pshelley@canyonoffices.com 017260 26 2025-10-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-02 20:06:19 -0.1 hrs 68b88a69081b35c31ca8ad2c 000018543 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15745 17ffbffe618091c915d2008e0c02f1b5d467c35972196d2a9864195b7d0af8c2 687680045e37c3086a7b35bc 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-10-02 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Maia H. - Kenneth Dave Francisco 2025-10-07 16:04:42 115.8 hrs 687680045e37c3086a7b35bb 000012976 5.00 390.00 5.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15744 b73d04182d30437ed23021d9cd33f38ae783d49d946e422b2ace5b0f751848dd 68ddbd69167a7afac641a11d 68dd43e2fb622cb5e10082cd Jill Mitchell Jill Mitchell jillm2010@gmail.com 019965 6 2025-10-02 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-02 20:27:23 -0.0 hrs 68ddbd69167a7afac641a11c 000021962 4.00 85.00 68.02 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15743 f0d235d1ed82e223d6d5899a321f7f425ec87d2c27315c6e58895226ff308543 68dc650f479d260c6e42a51a 68adf152536b9507b61b990d Rebecca Fitzpatrick Rebecca Fitzpatrick rebeccaredux@gmail.com 019744 16 2025-10-02 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Emmie Gebhardt 2025-10-02 21:41:52 1.2 hrs 69b9f0bf962984d6e59e63c3 000021794 4.00 143.07 143.07 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15
15742 e0a7185e53d2d7a8cf586265f4c6e0e94a4813193626e7475e59e6ff26e2e33f 68dc1169e270732ec0b394f3 68bc8214e8bd5ace48148121 Theodore Torrence Theodore Torrence ttorre22@icloud.com 019813 13 2025-10-02 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Emmie Gebhardt - Emmie Gebhardt 2025-10-02 21:10:53 0.7 hrs 68dc1169e270732ec0b394f2 000021626 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:07:04 2026-05-13 23:32:15