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
10212 beb828482d5d8a83863252d6d5087877d672d228b2b30c46030ddbace888c70f 68f69d37854d30096ad42cd5 68dd84844a7b4d7108459806 Meagan Wilmes Meagan Wilmes meg_rey01@yahoo.com 019972 10 2025-11-19 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - No Sonya C. - Jayson Encarnacion 2025-11-24 21:01:52 125.8 hrs 68f69d37854d30096ad42cd0 000024079 3.00 233.00 85.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10211 a22667d6450ab1019244285a7f4b7d22e3a52bc5f6ea555a30011a4b204c7b81 68ed3a172c60098c00f71178 68ed390fcb205bfd76bd76ce Hiromi Wiener Hiromi Wiener japantek@gmail.com 020056 5 2025-11-19 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt traveling - RAR 11/7 Rosey Reed 2025-11-07 20:05:10 -283.2 hrs 68ed3a172c60098c00f71174 000023195 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10210 dfa33756abe0c4112338b154b59d14740e3dbafe18283f192218d3a82a194a3f 68d6b56f1ae1fbc5e8da0b1a 67ced3eb7abf9f3ed8feb6e8 Mary A Kolbeck Mary A Kolbeck mariakolbeck@gmail.com 008033 48 2025-11-19 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-19 15:14:10 -0.0 hrs 68d6b56f1ae1fbc5e8da0b16 000021181 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10209 98b45a5f031800c35292b3f92dceaa0e658c911e141d9b78eb3f712f7711aa0e 691cbbdba5ef3db385e68232 68d5987de4b79f09d2a8f2d2 Sukru Ergin Sukru Ergin erginsukru@gmail.com 019933 24 2025-11-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Michelle Osgood 2025-11-19 16:12:45 0.7 hrs 6920ec4186985fcb871da450 000027623 3.00 90.40 90.40 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10208 d90b33c9685ec3f02d4d438602d22a73d707740977ee3832a6154ee015f7dd28 6908faaac727898c80d02e40 68d5987de4b79f09d2a8f2d2 Sukru Ergin Sukru Ergin erginsukru@gmail.com 019933 24 2025-11-19 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle Osgood 24+ scheduling conflict -mw Michelle W. 2025-11-18 17:31:19 -22.0 hrs 6908faaac727898c80d02e3f 000025739 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10207 a15b93d002d91ee0562fd616f738dcb34060e8ee1cff92f8d21e9c8f57ca8429 68f27d81d9447738ac9a4ad6 67ced6497abf9f3ed8ff1888 Laura Woods Laura Woods chancewoods1@gmail.com 016359 31 2025-11-19 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-11-19 15:39:40 0.2 hrs 68f27d81d9447738ac9a4ad5 000023886 3.00 75.12 75.12 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10206 a933844ae74c89910286bc37f39452a1d24b980f91b01404fae236443574a7d3 688d25e4b7b1ac21f18746dc 68234eb165215a088fcbc1ac Kelli Hintch Kelli Hintch khintch@bouldercounty.gov 017228 16 2025-11-19 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-11-19 15:23:51 -0.1 hrs 688d25e4b7b1ac21f18746d7 000015168 3.00 85.90 85.90 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10205 218d708ee4f983cf35e0ca96222e8862c7104b72c012ff605fd41a1fd544938a 68f131a1c7ae4bfbd79666f8 67ced50e7abf9f3ed8feece0 Amy Schlotthauer Amy Schlotthauer harmshauer@hotmail.com 012636 45 2025-11-19 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed 24+ coming on on 11*17 instead- sc Sonya C. 2025-11-17 17:32:58 -46.2 hrs 68f131a1c7ae4bfbd79666f7 000023775 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10204 ef52eb516b48144683e0ab4239d47308e38d3acd90ca4992255f6bc3d3794fa8 68efd4a238d4fa47e42a3dd7 686d48f1c68b4f6dd7327d26 Susan Bryant Susan Bryant shbryant@comcast.net 017586 15 2025-11-19 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ work conflict - sc Sonya C. 2025-11-11 22:00:19 -185.7 hrs 68efd4a238d4fa47e42a3dd6 000023601 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10203 61a443d82bd3b05a707bcb5814856a2a5a1283e125082c23e59927c6b89dca45 68ed1a7b8bc9f041e0712865 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Rosey Reed - Jayson Encarnacion 2025-11-24 18:50:18 123.1 hrs 68ed1a7b8bc9f041e0712864 000023150 3.00 237.00 15.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10202 618840e916cc1e41b520782672aec9398dc8ade5f9e960bd81cff4559c7a8881 68d2f62a1e44c9f888b38097 67ced3857abf9f3ed8fe9ca5 Marilyn Francois Marilyn Francois 2250fran@gmail.com 005792 17 2025-11-19 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayson Encarnacion 2025-11-21 21:59:22 54.2 hrs 68d2f62a1e44c9f888b38096 000020685 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:23:04
10201 6b0d227b5af246752d26c4d433423557701c140f8ce3f9f560ffa51b38585b74 68ae35910a19e69af2e98492 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-19 16:35:49 0.8 hrs 68ae35910a19e69af2e9848f 000017654 3.00 85.00 72.25 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10200 b1e2a34bccfe9f17b88cf66d1992258b56b20fa430a60f1cd424e2b1696ee5a2 68f7b0331ece9009eb463e5a 68a4e622dd3cb8f81a2b9dbe Vicki Gazdik Vicki Gazdik vickigazdik@gmail.com 017828 22 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 16:11:09 0.2 hrs 68f7b0331ece9009eb463e59 000024191 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10199 c34d3b154676dc136ae0a559e7f3378811f343c66e026a75b0d7a88879c9a881 68e6a68f0094c8c3e48d8160 67ced4557abf9f3ed8feccd0 Roberta Osborn Roberta Osborn osenbaugh@hotmail.com 009901 37 2025-11-19 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips 24+ sch conflict - sc Sonya C. 2025-11-17 16:23:11 -47.6 hrs 68e6a68f0094c8c3e48d815f 000022762 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10198 ceec85dd41348a3fb34370fce9e8fdcca35b9e9364700b9fbd2b9ba22408672c 68dd6d982050a909801ed908 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-11-19 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 16:59:57 49.0 hrs 68dd6d982050a909801ed900 000021885 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10197 c862c1567e599cf55da9b67cc70bcba92afc70ce883b0d6518d4b147ff86f4e3 68d41153744410099d1fedd9 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2025-11-19 No Show 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed - Sophia L. 2025-11-19 16:38:21 0.6 hrs 68d41153744410099d1fedd6 000020802 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10196 3343841d6b70b5ac3210df5ce9beb304ab3dd496fd5b684582ed9b8e56fe8f9a 68ff8cc4c9fd81098a46c6bf 67ced5d47abf9f3ed8ff0985 James Voss James Voss jim.voss@colorado.edu 015079 45 2025-11-19 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 16:11:02 -0.1 hrs 69c5cde24ae031e3572cc0d7 000024855 3.00 75.12 75.12 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10195 a8da45362a85bfe55a370c5cbda14bb4bd45dedf5da43f667c2d8481dcea3f77 68fbbc2aa0dc250911c57a7b 67ced2f87abf9f3ed8fe64e7 Rodney Allen Rodney Allen roddy.allen19@gmail.com 001036 19 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-11-19 16:10:34 -0.1 hrs 68fbbc2aa0dc250911c57a7a 000024748 3.00 83.09 66.20 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10194 f58d86090395f683b71c16599fa78c0aef03cf4c962e131b41026874af6c765c 68b8a2b85dfa4104558febef 6895234dd7634722d0f894e3 Julian Alexander Julian Alexander alexandrianlibrary1@msn.com 017768 16 2025-11-19 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt no showed Michelle W. 2025-11-19 16:49:48 0.6 hrs 68b8a2b85dfa4104558febee 000018595 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10193 bb298907d8e98154159c04575275bc2614c6e03b8ac08f38ff58a92cc50f4e4e 68b07b67ed830916f8539dc7 67ced34d7abf9f3ed8fe8a3c Barbara Eng Barbara Eng bbeng5843@aol.com 004221 154 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Sophia L. 2025-11-19 16:06:47 -0.1 hrs 6920fa086b9d0b21309c54b3 000017966 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10192 0e3d008690c65ce91fa0e6bd38bb38ec1bc113429929cf7162265cec38fb028f 68f27e749871e709add2f99a 68f246d958f71908e4de2f1b Andrew Grant Andrew Grant akgrant23@gmail.com 020094 6 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-20 00:05:42 7.6 hrs 68f27e749871e709add2f998 000023891 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10191 5f8f2e1798d161092a02c3e134d6ab8edc8659acf050f0127cb39db5df1ddff4 68ed285e5a964208e0bfc7c5 68ed27c339b9d509af18c579 Shoshana Chandler Shoshana Chandler shashachandler@gmail.com 020053 10 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-24 18:21:05 121.9 hrs 68ed285e5a964208e0bfc7c4 000023167 2.00 82.00 65.60 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10190 49a6f35b83c20363cc4fccb5bbcd8ee04d73731916e3e1e9bdfed001311ebe33 68e549fb8b2be4cde2f5121d 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-11-19 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 17:25:57 0.9 hrs 68e549fb8b2be4cde2f5121c 000022517 4.00 95.95 95.95 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10189 9c7c6fbbb4dcc55c5d8d1c126d6512c0fcd59730e15613752c938e2adb449c4a 68c1aba8810f1d6160ded8d7 67ced6407abf9f3ed8ff176a Kit Wise Kit Wise kitwise@comcast.net 016264 63 2025-11-19 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed sick Marguerite Barth 2025-11-19 16:16:27 -0.2 hrs 68c1aba8810f1d6160ded8d6 000019398 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10188 117255c33d87de678fbe3db754b35143a4df037776a9db5e4687d9b38b7b6dab 68f2667704cf6556cf256159 68f2666b866fbf5decd64a10 Mary Witcher Mary Witcher mollywitcher@yahoo.com 020097 12 2025-11-19 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-11-19 22:46:48 6.0 hrs 691e1ecbe992068770401875 000023874 4.00 171.76 171.76 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50