General Visit (PT Boulder API)

Total rows: 101,785
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
18528 0f9dc907ab830f0295e27691d8302b2d68b236edd4b937f1b3345fa34df81960 67e671a9ceb9f104f028caeb 67ced5cf7abf9f3ed8ff08cb Michael Sullivan Michael Sullivan jazzdharma@comcast.net 015017 225 2025-09-10 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-09-10 19:07:15 0.1 hrs 67e671a9ceb9f104f028caea 000151731 1.00 35.16 28.01 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18527 64ea0f5c1264b1bae0646d18fc65e02f247093245b74b70600abca56f753a18d 688a57c41997c6086050df17 688a5714297fd59a76062d1a Agnieszka Magoye Agnieszka Magoye amagoye@gmail.com 017722 14 2025-09-10 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Primary - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-22 17:08:06 1005.9 hrs 6914f084b0a33bcf069106da 000014784 1.00 0.00 20.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18526 a28fe0b987c30b57c24310459db6b78eb8dadbdcb33159969a7d5d9f5c2ff72b 685f1e61b9b346567f081074 681b7df597c361e480a06d0f Chelsea Souza Chelsea Souza cjowell@gmail.com 017192 13 2025-09-10 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Miranda Samson - Michelle W. 2025-07-30 14:44:31 -1012.5 hrs 685f1e61b9b346567f081073 000011247 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18525 31d49230218a44005b7ebb5f0b2d7464565eb97ba06f9c9d5da865a24a38c855 68b9b35b119c6c0880ba8dfa 67ced5237abf9f3ed8fef031 Anita Schwartz Anita Schwartz cheer.anita@gmail.com 012919 38 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Elizabeth Cousins 2025-09-04 15:42:19 -147.8 hrs 68b9b35b119c6c0880ba8df9 000018672 4.00 133.86 133.86 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18524 597f271ff8b83dd822bad6747bf421071439098bc1a42e8c0accb564ab313c75 68af8af4556252a19e222f7c 6880e83200e54407d73eac1f Helen Vickery Helen Vickery hvickery62@hotmail.com 017676 11 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-10 19:29:11 -0.0 hrs 68af8af4556252a19e222f7b 000017925 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18523 72c37515809fc72c9c5a406b37bbf6522a71a31aed16f52aa4ef7adb6ff51771 68accf5736b9c5f1f5092626 687e75e40d5a13ac227d3ed0 Mary Kay Stewart Mary Kay Stewart mkwstew@gmail.com 017662 7 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-09-10 19:24:28 -0.1 hrs 68c777ab4370596cf755796f 000017477 4.00 156.40 64.85 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18522 4e69f132fbc53cdba6432d8447a6c38b0dd0eed38384716404b35c46c12504f2 68ac94abc2d5cf09021706bc 68ac93e9d2876dc47bcfa6f5 Katherine Gockel Katherine Gockel katherine.gockel@gmail.com 019738 5 2025-09-10 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 8/25 Sophia L. 2025-08-25 20:34:08 -382.9 hrs 68ac94abc2d5cf09021706bb 000017394 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18521 8ec2b2bc26b138fc71e0f2779921a5140019e6172f8f89c9c50fe3d66fcd053e 6894fdb89ee53907976a52bb 67ced3c57abf9f3ed8feadfd Beth Karpf Beth Karpf bethk@alum.mit.edu 007272 156 2025-09-10 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Samantha Saunders 2025-09-10 19:31:13 0.0 hrs 6894fdb89ee53907976a52ba 000015734 1.00 35.16 35.16 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18520 c2a9f009c42f40bd30cd81729241c4dfb50ff8b623bd449e1b91b02285cb2449 6893b68a55cc68342a09a773 67ced42e7abf9f3ed8fec51c John Miranda John Miranda flymiranda@gmail.com 009244 113 2025-09-10 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/10 Sophia L. 2025-09-10 19:50:59 0.3 hrs 6893b68a55cc68342a09a76e 000015566 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18519 71ca4c107d8b3c65f7a0a5011e8b1f96e3348d34cb3a700c2fb13388d12ef697 6891091dc1f7c6e6b3df8637 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-09-10 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Maia H. 24+ sc Sonya C. 2025-09-05 21:41:58 -117.8 hrs 6891091dc1f7c6e6b3df8636 000015272 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18518 8c402a0256869092a5dd8114689b8fa1b983341baf1b14e010a2239af76c118a 687fcc7f4e569afc314f9bb8 67ced4307abf9f3ed8fec579 Marilyn Martin Marilyn Martin marikaymartin@gmail.com 009275 33 2025-09-10 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-29 17:04:44 -290.4 hrs 687fcc7f4e569afc314f9bb5 000013851 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18517 cbb08db36e5f1d81f96f560a122de0bef74f8373c8232ef32b650c477eb0f6f3 6870172c45f3fbe43a24e182 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-09-10 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins Sept 8 appt Elizabeth Cousins 2025-08-25 16:25:09 -387.1 hrs 6870172c45f3fbe43a24e181 000012500 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18516 f71e60f60c599d24568171c107862f18fc2b8416b06d0867eab772a67626a2bd 685eae8f10ccb508672d1065 67ced3457abf9f3ed8fe8777 Dale Durland Dale Durland dale.durland@gmail.com 003985 111 2025-09-10 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-10 19:29:14 -0.0 hrs 685eae8f10ccb508672d1062 000011044 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18515 6e6a1098a96ac9787f64a32eaae8f9cd4b18b7bd1551f4a92927fc32e4c2847c 6894c6e352a39d080c03bbd1 681a708f5288e5729fbcf929 Cambria Klinger Cambria Klinger pyronymph@gmail.com 017187 17 2025-09-10 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-09-09 21:12:48 -22.5 hrs 6894c6e352a39d080c03bbd0 000015696 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18514 a8481220ea075aa62e8004096bcfd7549da33913a2f74983fb16a0b5e0592d38 68795c0e96007a17c1cf4fa4 68795a5ffee8dab7b5b8263d Reba Kahlon Reba Kahlon rebaKahlon@hotmail.com 017648 11 2025-09-10 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sonya C. - Anne Palma 2025-09-12 18:51:29 47.1 hrs 68795c0e96007a17c1cf4fa3 000013427 1.00 150.00 15.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18513 03cb1bafaeb9275b5f840c9c4bed3d98ec1c5e4db66906872e73f02d8cf09659 68b888059648d907a4b1175d 67ced2e97abf9f3ed8fe5aeb Charles Berginc Charles Berginc berginc4@gmail.com 000184 42 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-09-10 19:40:44 -0.3 hrs 68f8077f1c00dd0948df6abe 000018536 2.00 150.80 15.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18512 1bae0f47398d28cccb94d6577e376a87c766c6454a766bbf4d49c0693745ae30 68a8ca25fc757507747fd96b 68361569374e5dfd88833674 Sidney Wilder Sidney Wilder sidneywilder27@gmail.com 017315 31 2025-09-10 No Show 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Stephanie Braun - Sophia L. 2025-09-10 20:15:04 0.3 hrs 68a8ca25fc757507747fd96a 000017314 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18511 e1e26df9d9a01df93b9b086489f163e1ae68e9b1bc3c622882ff64dde5d1dae2 68a5fda83dd18cf3679811a6 6887e0669b77f5683408a822 Jack Miller Jack Miller jack.merrill.miller@gmail.com 017713 15 2025-09-10 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ found PT that works w/his schedule- sc Sonya C. 2025-08-29 16:40:17 -291.3 hrs 68a5fda83dd18cf3679811a5 000016904 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18510 51574d5b0b52cc7f3948b649fdce33d726a478ceff11c423627c3e523b3506a3 68780b7f5e5c1c084cf2fe56 67ced45b7abf9f3ed8fecdfd Carol Morris Carol Morris morris3445@gmail.com 010001 141 2025-09-10 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 19:51:43 -0.1 hrs 68780b7f5e5c1c084cf2fe55 000013258 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18509 63a8e5369dabb23c6d9139269732044114d4103e666ab64d86d70783fdca79e3 6877e6c5f83a450870bd72df 67ced40c7abf9f3ed8febe2a Lelanda Lee Lelanda Lee lelandalee@gmail.com 008652 93 2025-09-10 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 20:29:11 0.5 hrs 6877e6c5f83a450870bd72db 000013206 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18508 7c6fa6879405fd8a30d9a451658981fe778ad9b134d8d4f1df26dc918c17811d 68a62d0aa55992b3c17a8f00 68a62c8604293bb08fd8f2f0 Sarveswara Kilaparti Sarveswara Kilaparti raok46@hotmail.com 017862 7 2025-09-10 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Joella Grace Salazar 2025-10-16 19:35:53 863.3 hrs 68a62d0aa55992b3c17a8eff 000016980 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18507 89bf72d005027af745d090c933d0205d38ee91c2b0e0ce41b42a15973cd3ef52 6883bd387c704207b4c31851 67ced3ba7abf9f3ed8feab0c Gail Hoag Gail Hoag gailhoag2010@gmail.com 007021 7 2025-09-10 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Patients states that PJ cancelled appt during their last visit - sc Sonya C. 2025-09-10 17:32:04 -2.7 hrs 6883bd387c704207b4c3184f 000014387 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:27
18506 0a8bfb31860ce4b427ead48047f1817b6f5c74cf3a8c88f76359c724882a58b5 686e89740fb4fb16d12ecd61 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-10-16 17:09:44 860.9 hrs 68c1e9171bcf475aa9286a58 000012251 5.00 95.95 95.95 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:27
18505 1e8c10f90fa4c5347eee007afb0649890005754578810151c8ec6ccc8a27b086 685c660020456edf6d42af11 67ced3c77abf9f3ed8feae63 Tina Kasson Tina Kasson tinakkasson@gmail.com 007306 123 2025-09-10 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-10-17 22:19:34 890.1 hrs 685c660020456edf6d42af0d 000010830 2.00 54.52 47.44 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:27
18504 26a01371e88ba7daf28754fd6bb35ba1f2a8abad8c64948206593063df8a803b 6840be11cd85667870996e06 67ced44b7abf9f3ed8fecaf0 Kent Opal Kent Opal kent.opal@yahoo.com 009741 237 2025-09-10 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-06-04 21:51:45 -2350.4 hrs 6840be11cd85667870996df7 000008326 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:27