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
19973 644d4fca6a1de6c65623a03684175a67a7fb1698e10f6e0df8c20c7a3094a6c7 6881124a52a32a07d514f845 67ced3707abf9f3ed8fe9648 Laurence Gorgemans Laurence Gorgemans laurie.marie375@gmail.com 005249 31 2025-08-27 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-22 17:13:28 -125.3 hrs 6881124a52a32a07d514f844 000014022 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19972 5339b792d16ce6323589d9ceec60f627c03c5da8e4a6451735628a4fa7c0b3d1 686d6f5145f3fbe43a172c2c 685d7e3c37e26aa9e5fbba45 Maritza De Mejia Maritza De Mejia demejia_maritza@svvsd.org 017531 6 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Maia H. - Ranjini Ridgway 2025-08-27 23:24:29 0.9 hrs 686d6f5145f3fbe43a172c2b 000012112 3.00 450.00 25.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19971 976f81ad84df0cb7b184c8fcb99e26c4a491de6abd0450cb00b4382094fec3a1 681d1f877a9079578faf6415 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2025-08-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-27 13:50:25 -8.9 hrs 681d1f877a9079578faf6411 000004963 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19970 da7af3feb829e2f7a2b1e8d7b237e1edf27af132821f4790853d89da6be3a1f4 687a9b334bcbfe083f9840a2 67ced3017abf9f3ed8fe6ae1 David Cavanaugh-Keyek David Cavanaugh-Keyek david.keyek@gmail.com 001546 60 2025-08-27 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Sarah Emrey 2025-08-21 13:48:26 -153.2 hrs 687a9b334bcbfe083f9840a1 000013586 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19969 87e00ea5820f68bb86e82f4efaad4c76eb504ae4d6ded7d21ddaed6dd1bd49cd 685d65c8f0e2a807759d8a18 685d640b138ccaa9326072d3 Rosemary Compston Rosemary Compston kristen.compston@gmail.com 017529 6 2025-08-27 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 8/20 Sophia L. 2025-08-20 23:04:41 -167.9 hrs 685d65c8f0e2a807759d8a17 000010890 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19968 7c68a8e379efbd3612dd8c1759342913e8f6efeb44f5bb4152585442ab403b5b 68ae1a28a23675335b190b02 67ced36d7abf9f3ed8fe9555 Nancy Fitzgerald Nancy Fitzgerald rjfnfitz@msn.com 005168 37 2025-08-27 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-08-27 23:14:50 -0.0 hrs 68ae1a28a23675335b190b01 000017631 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19967 d2ea756b4c60f8238035c09d6097ba3405bafc339e17bbf7ace587ab6c0821ec 6849d9593716fd0cb1f54ba7 6849bf71494094ca13513198 Tanya Sadler Tanya Sadler Tanya@ptboulder.com 017437 11 2025-08-27 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. SL 8/26 24+ pt conf cxl Sophia L. 2025-08-26 19:29:43 -27.8 hrs 6849d9593716fd0cb1f54ba6 000009048 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19966 e1218997bae45d8163d457601791390e479f47098af144c191c6de6822579405 685c65c54959ae459cdb266b 67ced3c77abf9f3ed8feae63 Tina Kasson Tina Kasson tinakkasson@gmail.com 007306 123 2025-08-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-08-30 21:34:17 70.1 hrs 68b36e6804f8d7e1f9f4dad5 000010828 2.00 54.52 47.44 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
19965 4e77eaf98351c29c62bfe9343bfd9064b344af25a14d8944b6a1e65a167d5a7c 6851a3d5ce527c07a17720c1 67ced4177abf9f3ed8fec099 Debra Mannon Debra Mannon shanemannon7@gmail.com 008859 19 2025-08-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Sophia L. 2025-06-24 18:52:31 -1540.6 hrs 6851a3d5ce527c07a17720c0 000009621 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:50 2026-06-11 23:47:19
20367 fbbd3bc1d83b38b9903c193ebc338e617725932f4f83cb1c5470ae4757e5c770 68910e1419c3e107a9fa348f 68128cf6c88f4807e49ed4ec Karen Shepard Karen Shepard kshepardinco@msn.com 017163 21 2025-08-26 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Samantha Saunders 2025-08-26 13:21:45 0.4 hrs 68add239ca160307acb9a31b 000015275 2.00 58.75 58.75 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20366 26ebfe722c8c4573b2597ba5878f7182acda134d8057f39037cd00d2508fa0a3 68a487b7564a3ec7538b4329 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-08-26 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Peter Gagnon - Ranjini Ridgway 2025-08-26 15:26:09 1.9 hrs 68a487b7564a3ec7538b4328 000016650 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20365 9a60229983b8032db3da4f8b739eedb6fa004e038da558680965e813d7e085fc 688a2d58700989078b69b52c 67ced3d97abf9f3ed8feb2c5 Robert Hunnes Robert Hunnes bob@hunnes.com 007680 29 2025-08-26 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Marguerite Barth - Michelle W. 2025-08-25 12:58:24 -24.5 hrs 688a2d58700989078b69b52b 000014752 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20364 1f5496b67b8a28a12527a3228312a6a918e94dcf78aa46792dd8840668106d8d 6866a00035dcbc087efdb02f 67ced5af7abf9f3ed8ff0484 Ellen Stothard Ellen Stothard erstothard@gmail.com 014652 28 2025-08-26 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Ranjini Ridgway - Sophia L. 2025-08-26 14:40:24 1.2 hrs 68add129c7870c078febdfe5 000011728 5.00 80.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20363 2cc5831b7e07e98d92742ba55e36c37335a3ffb8575f9210a65b647b6da15f4f 6848655257105c0812fa6f71 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-08-26 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Anne Majewski 2025-08-26 03:58:49 -9.5 hrs 6848655257105c0812fa6f70 000008870 3.00 234.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20362 d45e7fe10528ebf550ff550a5e21c9b53fa4a4f9a04f858e3e226c1ecea74e37 682f51c28df562d524f558c0 682f4fb6e960150854c84153 Rene Brodeur Rene Brodeur rpbrodeur@gmail.com 017288 9 2025-08-26 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-07-29 17:23:22 -668.1 hrs 682f51c28df562d524f558bf 000006599 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20361 345f8263471786be596d8d9abd126bd4bf8bf0ea92aaea484a21017b42c09004 68a640a792ca5eff7dcfffbf 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-08-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. cxl Sophia L. 2025-08-20 21:41:24 -136.1 hrs 68a640a792ca5eff7dcfffbe 000017016 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20360 d2cb8beb2b26e3f764f888f38e4d9b8c5085b223330081238feef4e86273603b 689df48541057e07794d4c52 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-08-26 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Sophia L. 2025-08-18 18:31:51 -187.2 hrs 689df48541057e07794d4c51 000016255 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20359 349660ad8ca7d07dc58525033f7de0529cd569d4b6e5705bd4956460171bd526 6883b23f1b09f4087c19edc1 6883b17496ddc907fc3d98be Owen Abila Owen Abila abilaowen@gmail.com 017706 6 2025-08-26 No Show 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Ranjini Ridgway 2025-08-27 12:20:45 22.6 hrs 6883b23f1b09f4087c19edbc 000014370 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20358 d62a224ff85106a2d1870b789c3802ed4671c6ba619fff3441a72a77bc7d3047 686c06cedf2ca508249d2fff 67ced3897abf9f3ed8fe9df8 Don Frasier Don Frasier dgaf76@gmail.com 005905 25 2025-08-26 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-26 15:16:59 1.5 hrs 686c06cedf2ca508249d2ffe 000011911 4.00 95.00 95.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20357 e61f11641695206f6d2892041f30cbd6f3bd289d451c13de498716fbedff5cbe 685d67a1485088a8edfe5db5 685d66ca138ccaa932608843 Conchetta Robinson Conchetta Robinson chettafifty@gmail.com 017530 6 2025-08-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/7 Sophia L. 2025-07-07 17:54:07 -1195.8 hrs 685d67a1485088a8edfe5db0 000010893 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20356 aad9a2c9a00ce6b4a4d7f42f8848cead6b1abf1a597f33050ce99d3f1c88c497 68431d28f46d860850439d86 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-08-26 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-08-26 13:44:45 -0.0 hrs 68431d28f46d860850439d82 000008577 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20355 4d7ee6533a24038d69b466d58bd59f2e01ae3e20738fbac1ce1569d587836c06 682e98ab5730c041a33e18f9 67ced3717abf9f3ed8fe967b Sheila Harrington Sheila Harrington harrington.sheila30@gmail.com 005266 123 2025-08-26 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Elizabeth Cousins 2025-08-26 16:28:35 2.7 hrs 682e98ab5730c041a33e18f8 000006535 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20354 05aacff35f2ca8e774b233fd0a19d5035dece3e1f08f2c38d464bee71487f510 689b6c41405475aec0182708 68489a57f839a307c1be27be Rita McCurry Rita McCurry mccurryrita@gmail.com 017434 18 2025-08-26 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes John Phinney - Sonya C. 2025-08-26 13:48:11 -0.2 hrs 689b6c41405475aec0182707 000015994 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20353 d721a8f4b46e2bce9b331bdb1455afa81adb7a2faf26b5caef7ed6f745538d67 689b500a66190e078a387687 683a0420c892ac65d5f92e16 Clara Draper Clara Draper clara.draper@gmail.com 017355 13 2025-08-26 No Show 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Peter Gagnon - Ranjini Ridgway 2025-08-26 21:37:34 7.6 hrs 689b500a66190e078a387686 000015978 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:20
20352 6316f2bd0c2e2750471e4aa79321c849ffe7a9882beef7a96859a7d6925cb0e6 68765e443bd4c807fc2a86a9 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-08-26 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-07-17 14:02:19 -960.0 hrs 68765e443bd4c807fc2a86a8 000012919 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-11 23:48:19