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
25463 ca003136a0ea0cd7861ea474b9ce447c593fc4b15c5dc1eb159a55c8d840fdaa 685d5ccde6dd200873a6d24d 685d5aff10240ca9c3528579 Robin Vaughan Robin Vaughan robinlv88@gmail.com 017528 71 2025-07-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-07-15 21:58:25 0.2 hrs 68796e99ff1aa208036f3cdd 000010874 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25462 3471f9b70fcdb42c10771bd4ff4a6d3d3dbd3c82e598809dc8302c50360e157b 685b1c8d6a1a8508135b26b8 67e1258a54aaaa3a80096c54 Lisa Darby Lisa Darby lisadarbywx@gmail.com 016740 36 2025-07-15 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Maia H. 2025-07-15 22:06:23 0.4 hrs 685b1c8d6a1a8508135b26b7 000010609 2.00 56.80 56.80 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25461 0a1d117a1a34f0589c342d56d994f8a17bf52b787faab7f250766c9019a79ed0 6850382ee1988b077a96b354 685036ee837be607f336383d Shiv Sharma Shiv Sharma swami.shivbharti@gmail.com 017449 11 2025-07-15 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-07-01 22:38:26 -335.1 hrs 6850382ee1988b077a96b350 000009408 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25460 222f46d1f96a58f086d287798a65c2af55e551a36595ff8a9db5dd828e2337db 68718a81ad6433f68d48691e 6865a9ab6cf1465927ef7a25 Ekaterina Tulchinsky Ekaterina Tulchinsky etulchinsky@gmail.com 017566 7 2025-07-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Ranjini Ridgway 2025-07-17 21:33:03 47.6 hrs 68796c2a6180b007ba259bec 000012741 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25459 f92a9f336e42ac9cfbb52a427a19de16704ce8c9bd416ae347fe5d6bc6d4edaa 6841e335fa1523077a920b1d 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2025-07-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. moved earlier Laura Shove 2025-07-11 00:30:27 -117.5 hrs 6841e335fa1523077a920b1c 000008461 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25458 7b3bad0aa4e99415f5f8f46fa8bb82012dfac08c0731a15a94ad88ec5ddc1aa1 68387712aec4ff75e03d6364 683875e39c35ce07e0f71fc9 Julia Moritz Julia Moritz julia.moritz@gmail.com 017334 11 2025-07-15 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/9 Sophia L. 2025-07-09 15:04:07 -150.9 hrs 68387712aec4ff75e03d635d 000007408 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25457 00486a21a5e7dda3d1498628b747b9f0a7f99e3d9e5527fe0e9a51bc843cfc93 683765b7aaae2f07a2218662 67ced3e17abf9f3ed8feb4cc Jennifer Kirk Jennifer Kirk jenniferjkirk@comcast.net 007853 24 2025-07-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-15 23:43:04 1.7 hrs 6876e7974c34528b34b69646 000007282 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25456 0d1ff9f3d3312022732086f66c551d66fc45b076ed1362dc5b560bc53f510bf2 6823c118a6f48da6fc2bde7e 67ced62c7abf9f3ed8ff14df Ryan Wienpahl Ryan Wienpahl rwienpahl@gmail.com 016047 11 2025-07-15 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Allison Reyes - Maia H. 2025-07-14 22:37:41 -23.4 hrs 6823c118a6f48da6fc2bde7d 000005466 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25455 fe008e9e663c90ad0d71dc4d8d99a5bf96bd0ae006ce0ef8da6603e5068ca3f2 6851a317c7f0e6f784ec04d0 6851a127a7ebe634b70909f1 Susan Cousins Susan Cousins susancousins@hotmail.com 017461 7 2025-07-15 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Maia H. 2025-07-15 22:04:03 -0.2 hrs 687aecb603126bb93bd3738c 000009617 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25454 569eea2f89873d8fca20cf34004b0ad7cfce3ee8344a43564116632492277036 6830d4660d3dfb08294912f8 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-07-15 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Maia H. 2025-07-15 22:14:08 -0.0 hrs 6830d4660d3dfb08294912f3 000006856 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25453 7eea68ac6eb3ab135edb536852e6d0b7b8c73e28adb294bd50548e6a0f17d0bb 682b96419f0b2a500809b9c5 681256076bfc3f0865dbd1be Michelle Olaya Michelle Olaya meesholiya@gmail.com 017158 8 2025-07-15 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Michelle O Fri, Jul 11, 3:20 PM (2 days ago) to me Hello, Please cancel all remaining appointments July 15 August 5 Thank you, Michelle Ranjini Ridgway 2025-07-13 15:13:28 -55.0 hrs 682b96419f0b2a500809b9c4 000006135 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25452 05652196d41017d736619a275cae6086987007eb9470e739ce9a05f0d4ffd94d 6871471118f3cc3c599c49ba 687146ecc3183c08531254d6 Tiffany Yie Tiffany Yie tiffany.yie5@gmail.com 017611 11 2025-07-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a6789a294b1b37ef18be50 AIM OT/PT Initial Evaluation - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2025-07-15 22:31:54 0.0 hrs 6871471118f3cc3c599c49b9 000012645 4.00 85.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25451 a0bc2ad732f2ca0224288f5c4b8f7d062a97220ae114687e1edaf441e447f403 686d6b8de16b3d089327f695 67ced3627abf9f3ed8fe9186 Stephen Glennon Stephen Glennon glennon@gridvisibility.com 004843 22 2025-07-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Ranjini Ridgway 2025-07-15 23:43:26 1.2 hrs 686d6b8de16b3d089327f694 000012104 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25450 888e86b205655fe360da72e9f73002c7a936f1fa2f689c5f3f68b6e235360702 685444b6c4acfac7f74f9a44 6835dc433e74d508214726a7 Gregory Ingraham Gregory Ingraham gregoryingraham0@gmail.com 017309 9 2025-07-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-15 22:32:01 0.0 hrs 687bc6256daa9af369f41d0d 000009949 3.00 81.96 81.96 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25449 c3ca49c2611793079360eab31d52928230f6138794697ac161c053aed7c06073 68486a1a81e9a72d5811164f 67ced36a7abf9f3ed8fe9429 Darcy Gonzales Darcy Gonzales gonzalesdarcy@yahoo.com 005068 10 2025-07-15 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Darcy Gonzales 2025-10-19 21:25:41 2302.9 hrs 68486a1a81e9a72d5811164e 000008876 3.00 -84.54 138.21 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25448 47c4a87559350d1ffba37ad84403aa904a92ef9a7297081c3f24d7bf40690056 6838e088ac697244b656f3ab 67ced30b7abf9f3ed8fe6f7c Allen Chavez Allen Chavez allen.chavez@bvsd.org 001939 101 2025-07-15 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia L. 2025-07-02 18:38:02 -315.9 hrs 6838e088ac697244b656f3aa 000007539 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25447 8e2b5e07ded930815b45d507829e3f042d4431a849b62a81cdae22c5f42ebd87 683622762a6dd40784d973fe 67ced56d7abf9f3ed8fefb34 Brian Steege Brian Steege bsteege@gmail.com 013858 57 2025-07-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-15 22:31:37 0.0 hrs 683622762a6dd40784d973f6 000007081 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25446 b445fa284577b7a120ada095932b1a6b6a4921b215a8df4df62a1873ca326506 67fd2466e96368084a58071c 67fd228eee2974394ca69bb8 Dawn Prudence Dawn Prudence Mistletoeroad@icloud.com 017042 10 2025-07-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ sch conflict - sc Sonya C. 2025-07-14 21:21:24 -25.1 hrs 67fd2466e96368084a58071b 000002030 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25445 44360c81db1f41292f32163b0ab19c9e8f0c69d5d061437fd937f21271b35a24 683641b26160fb07ded49c34 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-07-15 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sarah Emrey 2025-07-08 23:09:57 -167.6 hrs 683641b26160fb07ded49c31 000007144 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25444 010c55a54f568a0c3c79506b897be8108852d5e2b8de18f5dc8d12bd8436b12f 6859c62c7ebc6e3972499b11 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-07-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-07-22 22:30:03 167.5 hrs 688010f8714ebffc971d8ec6 000010411 3.00 232.00 25.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25443 91ad78a7621c7b433a26b968990d560dc09cbb50f4a458407a66a7b084607ade 6838d7bb5446f9089650bed3 6838d6f7dec53c07ddab1f11 Lillian McDonough Lillian McDonough lillyroseerling@gmail.com 017342 6 2025-07-15 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-07-15 19:27:04 -3.5 hrs 6838d7bb5446f9089650bece 000007526 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25442 4b6711bcea4a61446ed05142c19f2b44f18396d3ee6e4523e2bd619d761e8d16 68430bd2fd0eb0076c555bac 68430a198c453108154a9837 Eve Beilovei Eve Beilovei evebeilovei@gmail.com 017409 9 2025-07-15 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - James Fowlkes 2025-07-16 00:04:13 0.8 hrs 68430bd2fd0eb0076c555bab 000008546 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25441 beff381ad68b1b7ebd12d8711aa6e7010a073fa95513737281d9f0bfcc81cb1b 681a940a3f39603d2a57ac41 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-07-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sonya C. 2025-09-26 21:02:45 1749.8 hrs 681a940a3f39603d2a57ac40 000004574 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25440 ef01657f064291221e36005f630993b197a601c09892ac7090d4d1eef32117f5 6866f74d6b309b081bfbb16e 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-07-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-15 23:26:32 -0.1 hrs 68824c1ce44dc5081768c014 000011838 3.00 79.29 79.29 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10
25439 2bbd69c2a6a81dc295d263d21c5073ac1b183e1fafc5a7b72115dc44c875b8e4 683f0642a25bbb0879f962c9 6839bfee4bc12ac92a39b5c9 Donald Blunn Donald Blunn dablunn@yahoo.com 017343 12 2025-07-15 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. Mon 5:36pm Don Blunn apt tomorrow with Sarah - needs to cancel it. His mom passed away last week. Cancel the next three and when he can r/s, he’ll call us back. Ranjini Ridgway 2025-07-15 12:19:54 -11.2 hrs 683f0642a25bbb0879f962c8 000007863 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:34:31 2026-06-12 00:01:10