General Visit (PT Boulder API)

Total rows: 104,043
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
19988 70f2758fc1995396f8f167c9941e44865eb50175faa0efa435273505a8ad12f4 688cdb084cf6250132f4fd8c 67ced3917abf9f3ed8fea03b Evan Helmstetter Evan Helmstetter evhelmstetter@gmail.com 006098 31 2025-08-27 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Sonya C. 2025-08-27 21:29:16 -0.0 hrs 68b8874ad81a8ad848796f8d 000015086 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19987 2657a5891eb47f8b0803d4df0a4c7e9dcf6e7b8cc0f80a8610c179eb7a140d72 6876d5851feff75b1ed0cf22 67ced2f57abf9f3ed8fe639d Christopher Crisman-McQuarrie Christopher Crisman-McQuarrie cammcq86@gmail.com 000926 14 2025-08-27 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-27 23:43:13 2.2 hrs 6876d5851feff75b1ed0cf21 000013127 3.00 85.00 157.25 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19986 d2054372f8185843c15d15efb055a15ffa9760f725325dde7339604cee82d6c1 68236e1502032d56a1519bbe 67ced4d67abf9f3ed8fee3a9 Benjamin Prieb Benjamin Prieb benprieb@gmail.com 011850 123 2025-08-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Michelle W. - Sophia L. 2025-08-27 21:29:20 -0.0 hrs 68236e1502032d56a1519bbd 000005361 4.00 168.89 134.57 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19985 aa8cb2ea0eceb35faa1d02a93596b63ce8b0b7200b0b77ddfddd832b906e977d 682350b0953cff07bc2589a1 68234eb165215a088fcbc1ac Kelli Hintch Kelli Hintch khintch@bouldercounty.gov 017228 16 2025-08-27 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. 24+ rxl in Oct - in Laff, w/ Steph Sonya C. 2025-08-01 20:40:56 -624.8 hrs 682350b0953cff07bc2589a0 000005306 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19984 a92994d7f68305d350f1411e164134bd4aff6146decfcc7ef738176a33ba1803 685b1a3c5a7ffd0796e3e739 685b1967d04cdf07db1be800 John Foster John Foster foster.r.john@gmail.com 017517 19 2025-08-27 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/20 Sophia L. 2025-08-20 21:49:10 -167.9 hrs 685b1a3c5a7ffd0796e3e733 000010597 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19983 33c0664601936b9b175b53d649e44043f7e9ee9bc1e78f97c0b2bdafab7191da 6851f01e82c31567b7a483de 6851ee873033e707ac0ba789 Megan Martien Megan Martien dreamondodge@gmail.com 017467 30 2025-08-27 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-30 21:52:06 72.1 hrs 6851f01e82c31567b7a483dd 000009711 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19982 66b42067ff176b024898a09d7abd49641be5b35bd59f967d00fe7365434ac00a 689ba99c9a8cba516898ebbb 68965fe800ab350851bb1313 Samuel Bercholz Samuel Bercholz ratnasam@mac.com 017772 5 2025-08-27 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 8/25 Sophia L. 2025-08-25 19:45:42 -50.2 hrs 689ba99c9a8cba516898ebba 000016059 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19981 964adca168611ee51ed8a84ad721874aeb1fb6e53414b328cbdac9fd04dc30b1 6880fdd3e5c757a0094f460d 6880e83200e54407d73eac1f Helen Vickery Helen Vickery hvickery62@hotmail.com 017676 11 2025-08-27 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Michelle Osgood 2025-08-28 14:58:40 17.0 hrs 68b371b558acb49639f972fb 000013973 3.00 229.00 0.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19980 9c0b1dc2b353eba83cd7af690e372a93ad31474fd79faef2e760c851a052002e 687fb4ba714ebffc971aa870 67ed60f7a96d94932e899c54 Sheila Freehill Sheila Freehill scf429@gmail.com 016962 27 2025-08-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-27 22:30:03 0.5 hrs 687fb4ba714ebffc971aa86b 000013804 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19979 b15d970e504fa1dc069a666a9585c11da605f1250b4be6fd6c1117d49624654c 687abfd9fcd637213e700780 687abf199f3fe50867f764f5 Arielle Ades Arielle Ades ariellelist@gmail.com 017656 6 2025-08-27 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-29 13:27:05 -704.5 hrs 687abfd9fcd637213e70077b 000013611 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19978 038a328b54af7ceb8bdbe22b73d747df9f8a991d9b7cc2506334810257c61e6e 6866ff4afa340c0838d46399 68029123d90d52086235c513 David Baker David Baker davidkbakerhh@gmail.com 017091 21 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Maia H. - Sonya C. 2025-08-27 21:57:37 -0.0 hrs 6866ff4afa340c0838d46398 000011862 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19977 df002028302e7a8f788c644b388109d0e854be91cf271e6e79b40089b681eb56 689ca14bd725f254b2d9f523 688be47aa75fc360c2fdb230 Lisa Mcclellan Lisa Mcclellan lmcclellan18@gmail.com 017735 6 2025-08-27 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Primary - - Yes Michelle W. - Sophia Phillips 2025-08-27 20:55:02 -1.3 hrs 689ca14bd725f254b2d9f522 000016124 3.00 -151.74 41.26 - - - - - - - - 2026-02-19 23:18:51 2026-06-10 23:47:25
19976 47c8ef8e15f75fd5d696d1b41f9428f237319411c4367d37b40f30b6f71ecdb5 6879429acf7d36a70c8a29f0 67ced2ff7abf9f3ed8fe6925 Jeffrey Cutler Jeffrey Cutler jeffcutler@gmail.com 001398 29 2025-08-27 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. Eva gone Eva Tucker 2025-08-07 15:08:38 -487.1 hrs 6879429acf7d36a70c8a29ef 000013399 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19975 c810da3d4e2b5576211ccb3688f12dd1a531c97c7c64a47a0ab03694753cdba9 68af5dcced830916f84e6b20 68af4369f2725b078f7fdf8c Kai Phinney Kai Phinney kai.phinney08@gmail.com 019761 13 2025-08-27 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a6789a294b1b37ef18be50 AIM OT/PT Initial Evaluation - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-27 22:32:41 0.0 hrs 68cc264475fbc851f788f46a 000017872 4.00 180.00 80.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19974 db9de51aa1b79c6c06a923c7bb3d07fd2d09566b00817a28d4d6a72d47509e3c 6893d9a6991c8a07b507b8e7 6840792783dd9c0849bd2b05 Zachery Sarkis Zachery Sarkis zacherysarkis@gmail.com 017384 7 2025-08-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-12-08 16:25:22 2465.9 hrs 6893d9a6991c8a07b507b8e6 000015664 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19973 644d4fca6a1de6c65623a03684175a67a7fb1698e10f6e0df8c20c7a3094a6c7 6881124a52a32a07d514f845 67ced3707abf9f3ed8fe9648 Laurence Gorgemans Laurence Gorgemans laurie.marie375@gmail.com 005249 31 2025-08-27 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-22 17:13:28 -125.3 hrs 6881124a52a32a07d514f844 000014022 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19972 5339b792d16ce6323589d9ceec60f627c03c5da8e4a6451735628a4fa7c0b3d1 686d6f5145f3fbe43a172c2c 685d7e3c37e26aa9e5fbba45 Maritza De Mejia Maritza De Mejia demejia_maritza@svvsd.org 017531 6 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Maia H. - Ranjini Ridgway 2025-08-27 23:24:29 0.9 hrs 686d6f5145f3fbe43a172c2b 000012112 3.00 450.00 25.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19971 976f81ad84df0cb7b184c8fcb99e26c4a491de6abd0450cb00b4382094fec3a1 681d1f877a9079578faf6415 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2025-08-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-27 13:50:25 -8.9 hrs 681d1f877a9079578faf6411 000004963 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19970 da7af3feb829e2f7a2b1e8d7b237e1edf27af132821f4790853d89da6be3a1f4 687a9b334bcbfe083f9840a2 67ced3017abf9f3ed8fe6ae1 David Cavanaugh-Keyek David Cavanaugh-Keyek david.keyek@gmail.com 001546 60 2025-08-27 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Sarah Emrey 2025-08-21 13:48:26 -153.2 hrs 687a9b334bcbfe083f9840a1 000013586 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19969 87e00ea5820f68bb86e82f4efaad4c76eb504ae4d6ded7d21ddaed6dd1bd49cd 685d65c8f0e2a807759d8a18 685d640b138ccaa9326072d3 Rosemary Compston Rosemary Compston kristen.compston@gmail.com 017529 6 2025-08-27 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 8/20 Sophia L. 2025-08-20 23:04:41 -167.9 hrs 685d65c8f0e2a807759d8a17 000010890 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19968 7c68a8e379efbd3612dd8c1759342913e8f6efeb44f5bb4152585442ab403b5b 68ae1a28a23675335b190b02 67ced36d7abf9f3ed8fe9555 Nancy Fitzgerald Nancy Fitzgerald rjfnfitz@msn.com 005168 37 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-08-27 23:14:50 -0.0 hrs 68ae1a28a23675335b190b01 000017631 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19967 d2ea756b4c60f8238035c09d6097ba3405bafc339e17bbf7ace587ab6c0821ec 6849d9593716fd0cb1f54ba7 6849bf71494094ca13513198 Tanya Sadler Tanya Sadler Tanya@ptboulder.com 017437 11 2025-08-27 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. SL 8/26 24+ pt conf cxl Sophia L. 2025-08-26 19:29:43 -27.8 hrs 6849d9593716fd0cb1f54ba6 000009048 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19966 e1218997bae45d8163d457601791390e479f47098af144c191c6de6822579405 685c65c54959ae459cdb266b 67ced3c77abf9f3ed8feae63 Tina Kasson Tina Kasson tinakkasson@gmail.com 007306 123 2025-08-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-08-30 21:34:17 70.1 hrs 68b36e6804f8d7e1f9f4dad5 000010828 2.00 54.52 47.44 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
19965 4e77eaf98351c29c62bfe9343bfd9064b344af25a14d8944b6a1e65a167d5a7c 6851a3d5ce527c07a17720c1 67ced4177abf9f3ed8fec099 Debra Mannon Debra Mannon shanemannon7@gmail.com 008859 19 2025-08-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Sophia L. 2025-06-24 18:52:31 -1540.6 hrs 6851a3d5ce527c07a17720c0 000009621 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-10 23:47:25
20367 fbbd3bc1d83b38b9903c193ebc338e617725932f4f83cb1c5470ae4757e5c770 68910e1419c3e107a9fa348f 68128cf6c88f4807e49ed4ec Karen Shepard Karen Shepard kshepardinco@msn.com 017163 21 2025-08-26 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Samantha Saunders 2025-08-26 13:21:45 0.4 hrs 68add239ca160307acb9a31b 000015275 2.00 58.75 58.75 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26