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
20615 7fa4c5fd15ac889db554ee62552dbc02b2652898840d010f76483ce13ceccf39 687544ea4cfb29085b4e9573 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-08-21 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - John Reed 2025-08-19 23:27:54 -47.5 hrs 687544ea4cfb29085b4e956b 000012827 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:49 2026-06-10 23:48:57
20614 21b20a081694c9c42c4941009e2aaaf4bb47ae80c4243b3f0e5954b5b898e4af 685acb0f5f0a5d130b29f63c 685ac9ef81553907e81f9307 Tracy Bugielski Tracy Bugielski tbugielski@gmail.com 017510 6 2025-08-21 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-08-22 19:24:12 20.2 hrs 685acb0f5f0a5d130b29f637 000010486 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:20:49 2026-06-10 23:48:57
20613 79d7e9b9bb0e7d036c9bb5f64fed9cf880a1d032047fb31ac1f465b5124f26cc 68a818a3b625571f0045436e 68a6318f43c9afe848883835 Alexandria Henderson Alexandria Henderson skysailer001@gmail.com 017868 4 2025-08-21 New 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:13:39 7.9 hrs 68a818a3b625571f0045436d 000161083 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:49 2026-06-10 23:48:57
20612 4e5ffd7863c96b6c7661397bf39fdd5e1e5d468c5a131b8e6f554f5ba5dc255f 684347e7b9a09807d2736f27 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-08-21 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. conflict Laura Shove 2025-08-20 00:28:29 -47.0 hrs 684347e7b9a09807d2736f1f 000008635 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:49 2026-06-10 23:48:57
21025 273fa009ff5c942abd0b6ecdd771ca6e98708678ef8237be2c502dc3c61b680f 688d2e418b03db56e5905f07 67ced3217abf9f3ed8fe791b Lana Clymore Lana Clymore lclymore@gmail.com 002760 66 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Samantha Saunders 2025-08-20 13:05:20 0.1 hrs 688d2e418b03db56e5905f06 000015170 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21024 f63ba1558fe90756bd52958477455a020591d478fe480ff0940768b5633ea982 686eebb69de00f077c4051e1 67ced53c7abf9f3ed8fef3e5 Greg Sparks Greg Sparks gregsparks@hotmail.com 013235 13 2025-08-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-20 21:33:18 8.6 hrs 686eebb69de00f077c4051de 000012371 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21023 6d909f781f6bb52ac2cf54a8ff7f35fd6c9f135ccc571af5bc757563c2063c40 689364bc59e7aa08378d51b3 6888e114dc80142d6a2c2097 TM Frey Morris TM Frey Morris drpiefrey@mac.com 017716 29 2025-08-20 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle Osgood - Michelle Osgood 2025-08-20 13:36:12 0.1 hrs 68f254e1c4e7fb9c0b1bc979 000015469 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21022 6ba9f865e28c7d3ac5a9d9f360b0dd591427b4a6285cf51c99f316e514df8a35 688a2d2d6bc9ca9db4e2392c 67f565823e33cd07a9cbb938 Tessa Allen Tessa Allen tessaeallen4@gmail.com 017012 15 2025-08-20 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-08-20 21:17:17 7.8 hrs 688a2d2d6bc9ca9db4e2392b 000014751 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21021 fbf29effd08bc3d5f51f60ad5326965706220339dd5e88405a3eae0b8e490bf1 688a1e9e7d0edf08a278cffe 6862e20c8612670816f07eb2 Radu Popescu Radu Popescu radasca@gmail.com 017545 14 2025-08-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Reed - Sonya C. 2025-08-20 14:00:20 0.5 hrs 688a1e9e7d0edf08a278cffd 000014741 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21020 bfbef3115255b5f8a9662e7e21512364c29eb893ec70842461d328408d7d8d81 68717af4a75683188e54c7cf 6871790c18f3cc3c599d5d0f Mark Saunders Mark Saunders mark@health-otb.com 017616 6 2025-08-20 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sarah Emrey 2025-08-20 13:30:52 0.0 hrs 68717af4a75683188e54c7cb 000012721 4.00 103.39 103.39 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21019 4227bf4da05ac129bdc969f789e2617d8d251c66e7971a2955e605fa9ba2ae64 685976f4b2c290080d927681 68597562fa75d4decd98342f Leslie Dodson Leslie Dodson lesliedodson@mac.com 017497 7 2025-08-20 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-08-20 13:34:57 0.1 hrs 68a75fa727f003c155332d5e 000010267 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21018 7b91c87c86ffc46212eccc720ddcaf53089bf052e63b8f7e6ae9bbde031a3757 6855775d4194f096e8424b09 67ced3eb7abf9f3ed8feb6e8 Mary A Kolbeck Mary A Kolbeck mariakolbeck@gmail.com 008033 48 2025-08-20 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-20 13:45:04 0.3 hrs 6855775d4194f096e8424b04 000010107 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21017 ff3f18c211d05dacfe487a38fb6c4e725b5f2dd78c45e0066e7bba1020fabb8c 68308f19cdbcce0814944f5d 67ced3c77abf9f3ed8feae75 Martina Kastengren Martina Kastengren kastengrenm@gmail.com 007312 39 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Marguerite Barth - Rosey Reed 2025-09-09 19:50:37 486.3 hrs 68308f19cdbcce0814944f5c 000006778 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:50:13
21016 4388fe043c3a6b840cf9ea55241357ee3244480c05861a3b9b0d02a2b3339764 6893b547491ba2078996a32a 688be47aa75fc360c2fdb230 Lisa Mcclellan Lisa Mcclellan lmcclellan18@gmail.com 017735 6 2025-08-20 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 6:29am Lisa M patient has an apt at 7:45am in Laff, is sick, won’t make it. Ranjini Ridgway 2025-08-20 12:49:16 -0.9 hrs 6893b547491ba2078996a329 000015548 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21015 4c3a4c137a5a8455b98d80384bb58e7b4f000ea188d27c8399f5a37714b82fa9 68795b842eeed5020ca80f70 68795a5ffee8dab7b5b8263d Reba Kahlon Reba Kahlon rebaKahlon@hotmail.com 017648 11 2025-08-20 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/6 Michelle W. 2025-08-06 14:39:29 -335.1 hrs 68795b842eeed5020ca80f6f 000013424 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21014 1896218d0ac85e284112cdd8aa2d61ec25bb1ca7fdf06fe56a33fd709468713b 68a37e78be1fc97cea1f7fae 6866e661ded4c1d848153ee5 Joanna Piatek-Swat Joanna Piatek-Swat joannapiatekswat@gmail.com 017571 11 2025-08-20 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-18 19:29:52 -42.5 hrs 68a37e78be1fc97cea1f7fad 000016553 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21013 1d22b7c693a5de26887d5b94f7253a5c6ad5686336542229ba14a5138d0e91ea 689a05d5df2ba0ae9e7e3fc2 67e1258754aaaa3a80096beb Matthew Atkins Matthew Atkins matthew.atkins11@gmail.com 016705 42 2025-08-20 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins Patient states he called on 8/19 to cancel this appt and reschedule it Elizabeth Cousins 2025-08-20 14:38:31 0.6 hrs 689a05d5df2ba0ae9e7e3fc1 000015893 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21012 f394ce8d9a36b732f1e225603f901f2d7850debc864101b8c6fe75f1b3a0ef37 689125ed685f4746ac83aaef 680b9a4f7d35bc085ade558f William Evans William Evans william.evans.53@outlook.com 017131 10 2025-08-20 Checked Out 67ace27f67327b083edb451f Michelle Osgood 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Maia H. 2025-08-20 14:48:52 0.8 hrs 68c715d16f3422e28e6f4983 000015325 3.00 150.11 150.11 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21011 554c0e9e6627d8901e217ecdd32611575f60accbc8923ff0785e7bf1c9a5c239 6876d493d65827658a50f2c8 6876d34bef366199e4a75a6f Nilza Kallos Nilza Kallos nilza@comcast.net 017634 10 2025-08-20 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-08-14 17:15:59 -140.7 hrs 6876d493d65827658a50f2c7 000013117 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21010 9ad51b5753c2b3e1af82e93bf10f7d4a7e3b0e967b7c4e0893e4a20b3f7fdd5d 67fe75bc1945e807b9797730 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-08-20 15:17:51 1.3 hrs 67fe75bc1945e807b979772a 000002237 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21009 501c50585cce926ac69eac385c614cc5735ad996a5dd02017461fa4c1ff3aa77 67e671cfceb9f104f028d5a5 67e1258c54aaaa3a80096c90 Steve Atherton Steve Atherton stevea1962@gmail.com 016760 17 2025-08-20 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton 6:12am Steve Atherthon apt with John at 8am, cannot make - is sick. Ranjini Ridgway 2025-08-20 12:49:56 -1.2 hrs 67e671cfceb9f104f028d5a4 000151791 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21008 c9dc2d64b448d1b4bf907bb9d401f50a087d6d1cf1c2cf91a0c0e3d9bd7da761 688a4f14c6bfecb06ef2f9dc 6853434ac624ff0866f61271 Kathryn Butler Kathryn Butler kathryn.mary.butler@gmail.com 017475 10 2025-08-20 No Show 683aa08158eaf318442499e4 James Fowlkes 67a67ab091753108089752a5 RTM READY 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia L. 2025-08-20 15:03:13 0.8 hrs 688a4f14c6bfecb06ef2f9db 000014781 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21007 4e08ca718221dbf639024eb9502149da764299a4625a021cd65993ee80470e29 687feb75fc35fe079a81243e 67ced3d47abf9f3ed8feb19f Mary Hudson Mary Hudson hudson@ucar.edu 007582 9 2025-08-20 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sarah Emrey 2025-08-20 14:19:48 0.1 hrs 687feb75fc35fe079a81243a 000013882 3.00 79.51 79.51 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21006 3d042d88af2355ff104658b0f4f2f9b0a2927424794a565f7c49e741d764525d 6877fa501feff75b1ed6516f 67ced6427abf9f3ed8ff17a6 Kathy Wittman Kathy Wittman kathy@wittman.biz 016284 43 2025-08-20 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-20 14:06:12 -0.1 hrs 6877fa501feff75b1ed6516e 000013219 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59
21005 d4871476c0c4fcebf0f041bbc7e0cbca2597835d4466f757d6c13051deae7060 685c10ce04c89707d6858e70 6841b65239bb100829b4835c Sara Amodio Sara Amodio drsaraamodio@gmail.com 017397 38 2025-08-20 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-20 21:14:05 7.0 hrs 685c10ce04c89707d6858e67 000010668 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:59 2026-06-10 23:49:59