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
20458 cbc13b3b42a20e72949df3d128ccac8f19661c08346d590bfd2197c7cab9d57d 68a5edf3037824ee4a833f04 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2025-08-25 No Show 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Sophia L. 2025-08-25 14:38:22 0.4 hrs 68a5edf3037824ee4a833f03 000016883 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20457 9a9b66396ebf2442d64da7bacea3d2090adcce4f399eb5b0366f89af82e02a26 68a7922077a174ebf51e9940 68a79210787a59a3c10467de Tracy Brennan Tracy Brennan tracy.brennan@comcast.net 017899 16 2025-08-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-08-25 15:03:36 0.6 hrs 68a7922077a174ebf51e993f 000017166 3.00 -57.14 147.86 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20456 f545ebe9431a5abc2fb6ad2f31b9b8715124f06a77707a793e2f7867411cf60e 688b9500f7d4a3087cb8f87d 688b939d7cd0650800dda926 Donna Colville Donna Colville draye@comcast.net 017730 13 2025-08-25 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-14 16:52:47 1202.4 hrs 688b9500f7d4a3087cb8f87c 000014926 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20455 37ad54617726620ccff020c13f3255e1f55627bff42e36a95e17a43747eb2eb0 6877fff8f040d77fff5dd78a 67ced4b47abf9f3ed8fedde5 Donna Phelper Donna Phelper donnaphelper@comcast.net 011358 25 2025-08-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Ranjini Ridgway 2025-08-25 16:17:02 1.8 hrs 6877fff8f040d77fff5dd789 000013234 2.00 159.00 10.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20454 b165e1400480c6dc324c7c347f06dbea6271940e801e8d4b0c7614c0a11cd146 68a73053c928083f09a45c4f 67fe9a8ceb4d8b9c3a872c1a David Leach David Leach ur1ifim12@gmail.com 017059 33 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No John Phinney - Michelle W. 2025-08-25 13:08:10 -1.6 hrs 68a73053c928083f09a45c4e 000017026 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20453 9b04b389017871ffa2ac3fd5a1688ca320d671eece6830f417219a42d597b4c3 6899f99c8639e307d4de8736 688a83b37d0edf08a27c33e2 David Grant David Grant goblin8u2@gmail.com 017724 16 2025-08-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-25 14:29:33 -0.3 hrs 68ac93fce95cf780d171d0e2 000015876 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20452 1f141aed8a5abca72f71ae4a9434c8ce7df1d23ed2eb29862819f1c2b56be979 6893823edc7aae36c54205c5 688135b862118307fc72cb87 James Crowley James Crowley jamespcrowley@msn.com 017689 19 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No John Phinney 24+ - sc Sonya C. 2025-08-20 14:34:17 -120.2 hrs 6893823edc7aae36c54205c4 000015493 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20451 6391ff3bfebdcd9bf275668a50c19cd17cbe63637102b9547dca574510a56651 68a8187cb625571f00453609 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-08-25 New 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:13:00 -79.8 hrs 68a8187cb625571f00453608 000161027 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20450 518fbe0ea643e0d8515452ad89a38cc88d90038f89590860d6ad25fe9348d5b6 687176a151b98607c3490ee5 67ced5f17abf9f3ed8ff0d48 Callum Taylor Callum Taylor callumtaylor@me.com 015400 19 2025-08-25 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-25 13:00:16 -2.0 hrs 687176a151b98607c3490ee3 000012712 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20449 6b1df984879fac3d17d29cb521d8fa82c2ac2a74bd8554f25605a6b001f2b92c 686ea3f7b188220811803b5c 67ced3107abf9f3ed8fe720a Robin Davis Robin Davis rdavis5669@comcast.net 002157 126 2025-08-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Maia H. - Sophia L. 2025-08-25 14:58:32 -0.0 hrs 68ac8c99b83479879d0b5ab4 000012314 2.00 159.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20448 7e5b10385992fea1abba37286d7376e122ed95138d9cc9b0d73bfce414ba27a2 6862acf560cb0c85f00844df 67ced3657abf9f3ed8fe9294 Robert Filderman Robert Filderman rpforders@gmail.com 004933 79 2025-08-25 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-25 14:48:09 -0.2 hrs 68ac8cbb61fd2dcc67899468 000011266 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20447 b92b8812ca551b3d640126503c9f60785c142eb2317cb243782a71f19649230e 682658f44164890839b4e451 67ced5727abf9f3ed8fefbfd Charlotte Tuthill Charlotte Tuthill charlottletuthill1@gmail.com 013925 18 2025-08-25 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. - Allison Reyes 2025-06-26 20:12:21 -1434.8 hrs 682658f44164890839b4e450 000005858 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20446 fb55f6fcc8a52116b2319187ee90f0bed3b4f2efd5f306f550a1920976538618 689a305f8052f0ad4b4715f5 689a2fce4630d20e6a37d013 Robert Duran Robert Duran dha@duransgreenhouse.com 017780 6 2025-08-25 No Show 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-25 15:41:21 0.4 hrs 689a305f8052f0ad4b4715f4 000015943 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20445 1b6dce7bed34df621946dbfbadd4709e0917465356122b2a5dbfbfbfa8ce05ee 689266c3996734089678b54b 689264aa22e70f07b2aca32b Kumiko Pentz Kumiko Pentz jpentz1@gmail.com 017754 11 2025-08-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-08-25 15:17:27 0.0 hrs 68ac90bff9be8c89145939a9 000015423 4.00 92.00 92.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20444 438c28381190eb887d65b16e02e1fbce2bc9e8f188b747372eb550d0daead22e 686c3873fc443c63bddcc78f 68264c6fcbcec6dde9248465 Charlotte Haertling Charlotte Haertling charlotte.haertling@gmail.com 017243 9 2025-08-25 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 8/5 Sophia L. 2025-08-05 16:54:46 -478.3 hrs 686c3873fc443c63bddcc78e 000011941 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20443 343ee2adb05ffed750498008710f85ffe62ba0515cbecb4d2d23be6708fd6e48 6862a216c33102954c2840d7 68221b8507a60c078def4097 Sharon Martinez Sharon Martinez sharon.mama12@yahoo.com 017220 11 2025-08-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-25 16:46:13 1.5 hrs 6862a216c33102954c2840d6 000011257 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20442 60299f5b7123527b296a696fb84297ad833ef917e6b29b571bbd9822dda5fc5a 6880f8181712baf8b6644978 67ced51d7abf9f3ed8feef47 Maravene Roscow Maravene Roscow mroscow@icloud.com 012841 50 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-08-25 13:54:18 -1.6 hrs 6880f8181712baf8b6644977 000013943 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20441 7545db499e2f0b40ad92e025fbceaafc4bc6934575fd79f43f2fed1ddde132d6 687e6759b05d59cabb8849e1 687e6628566432084beb732f Patricia Pederson Patricia Pederson rpederson@comcast.net 017660 32 2025-08-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-08-25 15:35:54 0.1 hrs 68cc59c69bda9b1b90aab307 000013651 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20440 d9bea3a8d7feb8b0ab8c0a5939091586e650c7954e058349a6e118ac5220809b 6876d4ab5e37c3086a7e32bc 6876d34bef366199e4a75a6f Nilza Kallos Nilza Kallos nilza@comcast.net 017634 10 2025-08-25 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-08-14 17:16:03 -262.2 hrs 6876d4ab5e37c3086a7e32bb 000013119 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20439 7b062545bb1c5222b8bb0442352c3e0612cb900aa746229c90fdc69aedb247c8 68a8189fb625571f00454223 68a5df6f0a9ff4d6b25f77d0 Randall Harrison Randall Harrison rharri4145@gmail.com 017829 20 2025-08-25 New 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:13:35 -80.4 hrs 68a8189fb625571f00454222 000161076 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20438 7049b8c64509e519eae00542d6071d70fba8aef46293e4b11f2a9ef90a68142a 6862aa2196d1ff956e23217a 67ced2e77abf9f3ed8fe597d Lesley Bell Lesley Bell lesley@bell-realestate.net 000062 92 2025-08-25 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-25 13:20:03 -2.4 hrs 6862aa2196d1ff956e232179 000011263 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20437 c3900b21c1b4b15b4fd924ab14b9d948b4e04069e62c701dfc43a566c84f401f 6889364d2657b207f7088ef4 688934c28ddfd8b8e9b93d34 Catherine Ford Catherine Ford cathyfd13@gmail.com 017719 34 2025-08-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-25 16:48:28 0.8 hrs 68f26caade9669091c5e21f1 000014688 3.00 75.12 75.12 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20436 46d078ab28c8ede708802b335ec3c54fd1aaea4b8aa97f1a095b6322972e0f2c 6887e115ff7f7607d20a2499 6887e0669b77f5683408a822 Jack Miller Jack Miller jack.merrill.miller@gmail.com 017713 15 2025-08-25 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Sick Michelle Osgood 2025-08-25 16:14:20 0.2 hrs 6887e115ff7f7607d20a2493 000014520 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20435 94b858177ff16b287205ea775e34122144e7ebd7ecd4c486ccac27770b18a4ef 6883a4318fc8b2088042ed45 686558bb1fc573aa62e2de35 Ashley Molner Hagan Ashley Molner Hagan ashleymolner303@gmail.com 017562 21 2025-08-25 No Show 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Ranjini Ridgway - Sophia L. 2025-08-25 16:38:48 0.6 hrs 6883a4318fc8b2088042ed44 000014350 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34
20434 d01eb8e0b4824144e2723ed9f1fb095ba1d5ea1f20dafb07c46433979bf00ce9 68373b1edfffa1c91ab9432f 67ced3067abf9f3ed8fe6d57 Cheryl Bowman Cheryl Bowman chjbowman@gmail.com 001756 345 2025-08-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-25 15:50:55 -0.2 hrs 68cc4c0bf9e6edd69d78b429 000007224 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:20:14 2026-06-11 23:48:34