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
20944 6b56c6c17d234a3a51169ea074732bef1dc6c50eb755de343c7f76609301dcce 6870294ff3c238c3a3a87180 685c13569b296107804f0caa Judith Jessup Judith Jessup judyejessup@gmail.com 017520 21 2025-08-20 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-21 18:05:36 24.8 hrs 6870294ff3c238c3a3a8717f 000012533 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20943 158d8e61632c3255c3eb9e8e1cad1f2b440190264c1c6dc8b61c3a483bcb17c4 6852dd8d787df507b20fd4fc 67ced3c57abf9f3ed8feadfd Beth Karpf Beth Karpf bethk@alum.mit.edu 007272 156 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Ranjini Ridgway - Samantha Saunders 2025-08-20 17:17:12 0.0 hrs 68bb82296b3b68a74bd77905 000009733 3.00 79.51 79.51 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20942 9c5f03be84bc3f22651cb6df0a225fb3a6a5e913e701c5fadc1a0a3424ec0ce1 688a8bb91609e8c26d61fa58 688a8ac7029a895ed5235cac Sandra Steele Sandra Steele 1cufan@comcast.net 017726 6 2025-08-20 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-20 21:21:03 3.9 hrs 688a8bb91609e8c26d61fa53 000014868 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20941 3ba79a179f81e454268132e4a85ab5ee73bbf599fbf74a131d0ef96978c6fdfa 688a59c88b03db56e582ad6a 67ced4ec7abf9f3ed8fee75a Carolyn Regan Carolyn Regan carolynhregan@aol.com 012165 33 2025-08-20 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Maia H. - Ranjini Ridgway 2025-08-21 17:40:01 24.2 hrs 68a759fe425b108b27597c44 000014800 5.00 385.00 40.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20940 8a58c094d03144c17c3b9fe0ad121a7d2063056968eee18561ba381fedab2303 68518bfd977be607aa993686 67ced38a7abf9f3ed8fe9e07 Gabriele Frasier Gabriele Frasier gabifrasier@protonmail.com 005910 28 2025-08-20 No Show 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-20 18:05:04 0.6 hrs 68518bfd977be607aa993681 000009574 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20939 7895c7d030bc3454be66c667b49a83bfa55bdd2093ce87e41dc1ff8031ff2740 68a818c4b625571f00454e3f 6830b48e8df562d524fd9c8a Judith Oehler Judith Oehler judyo@hotmail.com 017304 20 2025-08-20 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:14:12 37.6 hrs 68a818c4b625571f00454e3e 000161130 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20938 1c129fc1d9017f8a98b4d6f39c125ff666a366917e7fca42581a00ecfb144a69 683db5b98f170c1f1fc7fc2f 67ced35b7abf9f3ed8fe8f0a Eleanor Gibbs Eleanor Gibbs nora.gibbs@gmail.com 004631 41 2025-08-20 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Ranjini Ridgway 2025-08-20 21:31:49 3.8 hrs 68a6148040e46ae1bb7c5c19 000007686 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20937 bdbb9c4045a88cbf70a3646c45fa60d772422337fec89d0eb29382a69b58cdfd 688a83c037f5b45dcdd2aec6 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-08-20 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-20 18:44:12 0.5 hrs 688a83c037f5b45dcdd2aebf 000014851 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20936 699db20d093ff9b147af41bea5d09bb7f494c9a043449371e1403c1213861a67 68a818abb625571f00454589 68a796bb39ecdd64116316fc Erik Jeannette Erik Jeannette ejeannette2020@gmail.com 017902 9 2025-08-20 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:13:46 36.9 hrs 68a818abb625571f00454588 000161094 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20935 883c23f616d94e8cec60b6f120412f571aeb1ca28c2559f7c9a393fc15ead73d 688a27ad6bc9ca9db4e21389 683894c42f21dae449a884bc Erin Giveans Erin Giveans ekgiveans@gmail.com 017340 37 2025-08-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-20 18:44:22 0.2 hrs 688a27ad6bc9ca9db4e21388 000014747 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20934 b1df41b5c8eddab57af266993f77bc8fb38661e25e20c911efcd67ef8445758e 6887d3bbc0ec8a07f86fa4f1 6887d31576cff4081a302582 John Harsh John Harsh john.harsh@colorado.edu 017710 7 2025-08-20 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Patient - - Yes Sonya C. - Eva Tucker 2025-08-20 19:13:03 0.7 hrs 6887d3bbc0ec8a07f86fa4f0 000014504 3.00 82.00 37.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20933 345964b1e72790ff0805c6543ea3bbcb6de3ffecdfed30bcb21d14cdf8e6ed33 688112ba4dc7900869c608e9 67ced57e7abf9f3ed8fefdb6 Jennifer Simpson Jennifer Simpson jlynphd@gmail.com 014072 16 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Samantha Saunders - Ranjini Ridgway 2025-08-20 21:29:25 3.0 hrs 688112ba4dc7900869c608e8 000014023 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20932 03b30bdc8fd65ab4a9c8f6980de68b00a5a4eadf6f63bbd7bc43d2aa73415cf1 686fd875c15eed8b13030662 686fd774b125e507e5bbfeeb Robin Selman Robin Selman robinselman1020@outlook.com 017600 6 2025-08-20 No Show 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Ranjini Ridgway 2025-09-03 17:14:07 334.7 hrs 686fd875c15eed8b1303065e 000012411 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20931 244f7dac5b3ae173cdc2a368c0c7d60640327e5e5b542192571b17cf1aa56a31 685ebe0eb66ef58aac696e47 67ced30a7abf9f3ed8fe6f49 Eiko Arentzen Eiko Arentzen eiko.arentzen@gmail.com 001922 131 2025-08-20 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-08-20 21:16:37 2.8 hrs 685ebe0eb66ef58aac696e41 000011073 2.00 157.00 10.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20930 230e189a779048e63f02f737a2f99c8e4f42bd8bcb2899f7887b78b709d53faa 685acb3ca9b4aa086d2400a1 68598a154349520843ad7c9e James Townsend James Townsend jdtownsend@comcast.net 017502 24 2025-08-20 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Ranjini Ridgway 2025-08-21 17:45:58 23.3 hrs 685acb3ca9b4aa086d2400a0 000010491 3.00 60.00 40.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20929 dfb941ff7455a2e44d95ba990af7803a0e154d8557dbbd3782050a7a36245247 68433f1c702da2ef4a4f1a76 67ced4b87abf9f3ed8fedea5 Allison Novak Allison Novak novak0319@gmail.com 011422 30 2025-08-20 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-20 18:44:32 0.2 hrs 68433f1c702da2ef4a4f1a75 000008620 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20928 3c57b083bf6d1436ea2a0e9c687ef37f5486404733d817f733367d8592312fdf 6809455915096f08a29d6229 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-08-20 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Maia H. 2025-08-20 19:22:11 0.6 hrs 6809455915096f08a29d6228 000003279 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20927 c6d770a2089b062389857a22a732f14319c630af85936eaadbd0d0957196ff78 68a818dbb625571f00455768 68a78ce7ebc257d19f0a55ea Heather Pujet Heather Pujet hpujet@yahoo.com 017895 39 2025-08-20 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:14:34 36.2 hrs 68a818dbb625571f00455767 000161164 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20926 f60b3ce8dc3a0bd6d64e2f797353d5956f3012b9a7a2665553b0cb65e241e227 689f5781f0acf817b10ca49f 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-08-20 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ not feeling well. Sonya C. 2025-08-20 14:40:54 -4.3 hrs 689f5781f0acf817b10ca49e 000016390 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:42 2026-06-10 23:49:58
20925 b98f2a6a07da6b7d3935cd3c283c793ceff81ab14f2e555e81624a66bd4dc1f0 68939166a6a76e082850ccfd 67ced36d7abf9f3ed8fe9555 Nancy Fitzgerald Nancy Fitzgerald rjfnfitz@msn.com 005168 37 2025-08-20 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Nancy F 9/10/65 apt tomorrow with Annie in Longmont, please cancel, Ranjini Ridgway 2025-08-20 12:57:13 -6.0 hrs 68939166a6a76e082850ccfc 000015515 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58
20924 6a0ae9e4f38e83e2bea4e9a2487edd76128b9925d8a55612d8dfd3e5d16a799e 6883c693f2acb3078cb91fd7 6883c4bdb21796743258a24d Sally Anderson Sally Anderson sunrisesal@yahoo.com 017707 7 2025-08-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-20 21:29:50 2.5 hrs 6883c693f2acb3078cb91fd5 000014399 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58
20923 ca5fccea2866f3d449c71dd5f5d5df80b54579b330f9c73177ed6998d85f68d4 6879359e64b40a0283746afe 67ced5277abf9f3ed8fef0c7 Debra Scott Debra Scott niwotskincare@yahoo.com 012969 8 2025-08-20 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Per Dr. - need to wait to do PT after MRI results are in- sc Sonya C. 2025-08-19 17:54:06 -25.1 hrs 6879359e64b40a0283746af9 000013383 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58
20922 4f8c26045fcaf7a658c3404125b22b410af78bc44a4aa7aebe7a3f7cbdae3053 68757fa00969bf84ec9c07da 67ced4927abf9f3ed8fed817 Dorothy Pecina Dorothy Pecina dorothypecina@gmail.com 010863 15 2025-08-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Unpaid - Secondary - - Yes Sonya C. - Sonya C. 2025-08-20 19:20:09 0.3 hrs 68c322ab5308af7a0e0f2b14 000012894 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58
20921 c692fcf955f76343508d88a70bb7c5f9dccafb6906dab5ee368bea1ad82a4108 6866de8509056d626dbf9bee 68433cce75c7b0f1beb7313c Neil Sherman Neil Sherman nsherman0@icloud.com 017413 56 2025-08-20 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sarah Emrey 2025-08-20 19:12:54 0.2 hrs 6866de8509056d626dbf9bec 000011800 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58
20920 ebe79b35affec678c6e374fffef47abde015e05e47ecc4213d7a72f637a2989d 685c0c1408f5690800ea32d1 6850478b57d8c2077bf17645 Anna Alford Anna Alford annaalford07@gmail.com 017451 7 2025-08-20 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-20 21:32:11 2.5 hrs 685c0c1408f5690800ea32d0 000010653 4.00 95.55 95.55 - - - - - - - - 2026-02-19 23:21:41 2026-06-10 23:49:58