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
20073 46174f0dbfe217490c2f75efc8529f61ab87f5cf1cbd279283f61a78818de4c9 68756718ce025607fd954022 68407dc4cf918e087b7eab3e Nancy McKenna Nancy McKenna 3@9.com 017385 17 2025-08-27 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Staying with Emily Emily Pickner 2025-08-14 22:21:25 -306.6 hrs 68756718ce025607fd954020 000012853 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20072 ba0e4e256837d34292a91d1f8533f30b2fffea7cae24f91865bf1a4e4f5ef4e8 6870298525de24078ecacaf3 685c13569b296107804f0caa Judith Jessup Judith Jessup judyejessup@gmail.com 017520 21 2025-08-27 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-27 23:44:37 6.7 hrs 6870298525de24078ecacaf2 000012534 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20071 dab492ea182f2a9ba8865bdedd66b040687ff2937f877f4d7b673793ca5ce3da 686692b6669847085f217558 6827b20625d7295ca3be3cfa Ronald Wodehouse Ronald Wodehouse ron.wodehouse@gmail.com 017257 9 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Ranjini Ridgway 2025-08-27 23:20:17 6.3 hrs 686692b6669847085f217557 000011718 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20070 ac3ecb4e02a2d8e1c165999af7529ddcfb69d92517fbeb68657fe01eeaa08205 68434a0174ac2507e725cb16 67ced5287abf9f3ed8fef0ee Kelly Scott Kelly Scott kellygirlscott@gmail.com 012982 241 2025-08-27 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-27 23:35:53 6.6 hrs 68af9667a5980479f73eeecf 000008644 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20069 928b95d90183974258caa04247937e2c86fe77e8fa631e2ddece533972ce14b9 683db5dff084b7081a624211 67ced35b7abf9f3ed8fe8f0a Eleanor Gibbs Eleanor Gibbs nora.gibbs@gmail.com 004631 41 2025-08-27 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Ranjini Ridgway 2025-08-27 23:42:23 6.7 hrs 683db5dff084b7081a624210 000007688 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20068 86248a80d76dd1633bcaeecfb31d7893d23ffaf0162da1bc235745267cc955d6 681cdb8ec65995082d88206b 681cdaedc1b786083001cf1e Diana Mapes Diana Mapes dianajoymapes@yahoo.com 017204 10 2025-08-27 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-08-27 17:14:09 0.2 hrs 681cdb8ec65995082d882066 000004880 5.00 154.16 154.16 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20067 f1128d3de7fa587708ce6a095384b0c647bab2be5d18b820e4119ee3532ff9dd 68810b666ef52407d670d13b 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2025-08-27 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-26 13:17:06 -28.0 hrs 68810b666ef52407d670d13a 000013996 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20066 4352c0075914692744f50380feff6100f8f9341d6f4ec81cc338fdccf57739d3 68a498a6482471cb585cf745 689f74cc6a0ec0080e404aa2 Gordon Laurens Gordon Laurens laurens_gordon@svvsd.org 017806 28 2025-08-27 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-27 17:22:48 -0.1 hrs 68af943226c9a3345f866c99 000016682 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20065 db0e3085a1c6629724c803055b6040fafda6f093237859123b12c97d91882ba6 68a342e54ab1d607af51ea57 67ced58c7abf9f3ed8feffba Evangella Sanders Evangella Sanders evgel.sand@gmail.com 014244 161 2025-08-27 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Marguerite Barth - Sophia L. 2025-08-27 17:29:53 -0.0 hrs 68a342e54ab1d607af51ea56 000016521 4.00 79.00 79.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20064 99e0937a95cf0d328eb691eed32dc2bef81eb12cf8709ad7e445d705fccaaaa1 688a8bb91609e8c26d61fa59 688a8ac7029a895ed5235cac Sandra Steele Sandra Steele 1cufan@comcast.net 017726 6 2025-08-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-27 23:28:16 6.0 hrs 688a8bb91609e8c26d61fa54 000014869 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20063 36516404ebc9b4d8e13ed05c13e13fa2fe39277a6eae94a544d1be2fa2f3cdd0 6887f7393dd0ec087d0b6adc 6887f54841dc4a3f61f0bab7 Charles Rhoades Charles Rhoades srhoades@stonecroftcapital.com 017715 7 2025-08-27 No Show 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Sophia L. 2025-08-27 18:13:54 0.7 hrs 6887f7393dd0ec087d0b6ada 000014552 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20062 cfce98664eaa2929f96a189ccfc53b4bf66f37f4b3d1ec84ed0203ebd4c73ca0 68828b630f811ac02ebf4e62 682b4b4e58a15d07739d2f13 Jessica Rothman-Church Jessica Rothman-Church Jessie.rothman@gmail.com 017259 31 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Anne Majewski - Sonya C. 2025-08-27 17:29:14 -0.0 hrs 68828b630f811ac02ebf4e61 000014273 3.00 94.00 94.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20061 b15b084f84cfa0c1b4011934ffc105e2af78fb0658dfb9d887eab30c0c6c582b 68795ec274b9ba918f4cacdb 67ced3da7abf9f3ed8feb331 Hamida Khanum Hamida Khanum hamida.khanum@ptofboulder.com 007716 70 2025-08-27 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Stephanie Braun - Michelle W. 2025-08-27 17:34:19 0.1 hrs 68795ec274b9ba918f4cacda 000013428 3.00 81.40 64.85 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20060 8b1d8af5aed470315388a1c813c9e609f370d5cfd1a856a2999194d8619b1e28 6877e90af83a450870bd9303 67ced3b07abf9f3ed8fea84e Teresa Higgins Teresa Higgins teresa.higgins@unco.edu 006787 131 2025-08-27 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-30 18:29:14 -671.0 hrs 6877e90af83a450870bd9301 000013212 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20059 df227af6aaf899786c4312ceedd6e9ebbb9369a708b9199a7f9248d17a6b16cf 685f130184569707c155fee3 685f1243fd9ef60781d87d8c Ryan Kelly Ryan Kelly ryke1106@colorado.edu 017543 6 2025-08-27 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sarah Emrey 2025-07-30 18:14:02 -671.3 hrs 685f130184569707c155fee2 000011244 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20058 e01656d2162274daab863065081de0fc0c4ea8654da287d216f6e1564fd62210 68518c5c04e3d769d5ae8c22 67ced38a7abf9f3ed8fe9e07 Gabriele Frasier Gabriele Frasier gabifrasier@protonmail.com 005910 28 2025-08-27 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-03 20:46:26 891.3 hrs 68518c5c04e3d769d5ae8c20 000009575 4.00 95.00 95.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20057 150a6664c103c274ead3f0a3a069299712624bcd5e5cde2780505c55d0de0731 68a6306c3dd18cf36799f39c 682750e4e1d78f96208ec404 Siri Cavanna Siri Cavanna siriloe2@gmail.com 017253 14 2025-08-27 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-08-27 17:55:40 0.2 hrs 68a6306c3dd18cf36799f39b 000016984 1.00 95.00 95.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20056 11094485de787b289a5a357701d1b19048ee70ea03723419a156cff59d3cb5d2 6859904a753cf607b0045bc6 67ced5437abf9f3ed8fef4f9 Elizabeth Shannon Elizabeth Shannon bdshannon@hotmail.com 013327 135 2025-08-27 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-27 17:42:24 -0.0 hrs 6859904a753cf607b0045bc5 000010314 3.00 85.61 35.61 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20055 be1089283869bfb33df13049a04633b9472f52375403785cc877b4212228a80a 689f8f56d774d307bba9e6a6 689f8f1c71452007b5c443d6 Ian Smith Ian Smith iancrochets@gmail.com 017809 7 2025-08-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-27 17:55:46 -0.1 hrs 689f8f56d774d307bba9e6a5 000016474 6.00 159.38 124.38 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20054 85854eb67b317f94e4fbb5f9a454d79030fcc2adcb3e513f6162078c6e2fb3ae 687e67760d5a13ac227cd72b 67ced53c7abf9f3ed8fef3df Molly Sessions Molly Sessions molly.sessions@ptofboulder.com 013233 8 2025-08-27 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Mom texted at 7:10am that Molly woke up sick. SB Stephanie Braun 2025-08-27 13:15:04 -4.7 hrs 687e67760d5a13ac227cd72a 000013654 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20053 a34531ba349fc49f2e10b60eb12ed98c69b5d83e491df197f5c8c5294305aebc 6859971a86524007d888a168 67ced5667abf9f3ed8fefa3a Joan Siebenaler Joan Siebenaler jms80304@gmail.com 013775 92 2025-08-27 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-27 18:18:56 0.1 hrs 6859971a86524007d888a167 000010340 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20052 6363ee05f9b9bf5b088dfdde1917bc00a7edec67058fda376c8fe89bd4449cf5 689f84d8b32aa320fc398893 67ced4767abf9f3ed8fed2fb Scott McGonigal Scott McGonigal mrscottmcgonigal@gmail.com 010427 41 2025-08-27 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-27 20:53:46 2.4 hrs 68af996263418c8472bb4353 000016449 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20051 8f79b29977f900395492155ddb99a072190acbf385d311ea3e7185b6c6a979b8 689a32f610880dd12b696aee 689a32aa60d4d6d5603d4ed3 Taylor Dufresne Taylor Dufresne taylordrewry1@gmail.com 017781 8 2025-08-27 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-27 23:36:14 5.1 hrs 689a32f610880dd12b696aed 000015949 4.00 95.65 95.65 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20050 110260f1a22ce4e0c7d216d7ef66afccece26d9e43b2f1e3cfc54484d4d36fd4 6892742984a794086c7a4984 689272e47f3e617ebd4cfbfe Bryce Miller Bryce Miller bryce@hatchboulder.com 017756 7 2025-08-27 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-27 23:34:22 5.1 hrs 68af9609d1be55c0eafe503d 000015440 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34
20049 16d4e4e987a4497730fa53ee23871245aabaeade44a0ee5eeff93f73c6ac2302 6883c693f2acb3078cb91fd8 6883c4bdb21796743258a24d Sally Anderson Sally Anderson sunrisesal@yahoo.com 017707 7 2025-08-27 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-27 23:39:09 5.2 hrs 68b1cce7426c5a086c823b82 000014400 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:19:07 2026-06-11 23:47:34