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
38001 8fdf0be69ffd744bcc790786cc8752fd748d111993629738373bada05a0c4757 67e681b5ceb9f104f02cc88f 67ced49b7abf9f3ed8fed98e Doug Mehan Doug Mehan dougmehan@gmail.com 010988 44 2025-04-01 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton 24+ pt conf cxl SL 3/31 Sophia L. 2025-03-31 20:54:02 -25.1 hrs 67e681b5ceb9f104f02cc88e 000157195 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
38000 e996fea80d98c838f1cb8a9b301b3ab2d4277b7faea4cbbb32ea5e945b30dbdd 67e681b4ceb9f104f02cc84e 67ced3137abf9f3ed8fe73b4 Jennifer Brinker Jennifer Brinker jenrosebrinker@gmail.com 002299 40 2025-04-01 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Sophia L. 2025-04-01 22:03:38 0.1 hrs 67e681b4ceb9f104f02cc84d 000157194 2.00 100.00 100.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37999 2ad381f84a0b88f97f0bd2d174105cf5455c52f2280ce48c198b4d89ce9e24ef 67e681b3ceb9f104f02cc829 67ced3cc7abf9f3ed8feafd7 DUPLICATE DO NOT USE Houghton DUPLICATE DO NOT USE Houghton mthoughton@gmail.com 007430 57 2025-04-01 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton Wrong patient Dawn Singleton 2025-03-29 03:30:28 -90.5 hrs 67e681b3ceb9f104f02cc828 000157193 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37998 c38e37266462946bf80d68c1057ac6d74730989c8e1a5bdea4795b25e6fd4177 67e681b2ceb9f104f02cc808 67ced3cf7abf9f3ed8feb067 Avery Howard-Tollefson Avery Howard-Tollefson arhoward05@yahoo.com 007478 5 2025-04-01 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-04-01 22:05:14 0.1 hrs 67e681b2ceb9f104f02cc807 000157192 2.00 100.00 100.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37997 efb377d6e4aa4724927486d3fec07a545e9d7b1a4202a41e395f207f9c9f35f5 67e681b1ceb9f104f02cc7b4 67ced43c7abf9f3ed8fec7ff Brynn Moncur Brynn Moncur brynnmoncur@gmail.com 009490 18 2025-04-01 Checked Out 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Primary - - Yes Dawn Singleton - Ranjini Ridgway 2025-04-05 17:30:21 91.5 hrs 67f168bf694d281287d55fe0 000157190 3.00 237.00 10.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37996 9e7b6bc586267209ad31244aec8e94e43f04ee1183354b053314ec53f2cbffe8 67e681b0ceb9f104f02cc792 67ced5a17abf9f3ed8ff028d Laurey Van Wagner Laurey Van Wagner lvw4526@hotmail.com 014485 197 2025-04-01 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-04-01 22:15:00 0.0 hrs 67e681b0ceb9f104f02cc791 000157189 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37995 917cb0acfa2a87a901a85c7549ec98a58b0e4d5cb4ed6d3c3bc2c7b05f48d48c 67e681afceb9f104f02cc771 67ced3b57abf9f3ed8fea9d4 Carrie Hillman Carrie Hillman carrietimhillman@gmail.com 006917 38 2025-04-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-04-03 22:15:41 48.0 hrs 67e681afceb9f104f02cc770 000157188 3.00 80.00 80.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37994 ef4dc595ba2878876283b0b152f3b01866482415fff9c51e40810a0cfa6f6b57 67e74dfd9447ad4afc22d0dd 67ced5047abf9f3ed8feeb30 Fischer Robbins Fischer Robbins ekfulkerson@yahoo.com 012492 24 2025-04-01 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Ranjini Ridgway - Ranjini Ridgway 2025-04-01 22:31:16 0.0 hrs 67ed742bf91f18076ff2c2a0 000000276 4.00 95.53 95.53 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37993 6ecbbd1801bc0169c34acbfc288e29a49ad09029a8739a284313e1d5d82f1659 67e681adceb9f104f02cc735 67ced5bf7abf9f3ed8ff06ac Megan Snell Megan Snell meganmarie1@me.com 014836 4 2025-04-01 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-04-05 18:25:23 91.9 hrs 67e681adceb9f104f02cc734 000157186 3.00 80.00 80.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37992 569ca348af08cff864a1b43be3b439360487109d67a6aeb13e25f030f18c48f4 67e681adceb9f104f02cc714 67ced3e77abf9f3ed8feb63a Selene Knudson Selene Knudson selene.knudson@gmail.com 007975 14 2025-04-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-04-03 00:06:40 25.6 hrs 67e681adceb9f104f02cc713 000157185 3.00 105.00 105.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37991 8a61ed122c22a44f5bfcb6a787f48da9f9add2780ad9e26de4f8532ec198d235 67e681acceb9f104f02cc6f3 67ced5047abf9f3ed8feeb30 Fischer Robbins Fischer Robbins ekfulkerson@yahoo.com 012492 24 2025-04-01 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67cecf56790102035488b359 Pre-PtE Appt 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton WRONG PROVIDER Ranjini Ridgway 2025-03-29 01:33:16 -92.9 hrs 67e681acceb9f104f02cc6f2 000157184 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37990 b04712f85ea9958c48ef16be88a791b97a1ed34949069595510591750293ca07 67e681abceb9f104f02cc6d5 67ced3a37abf9f3ed8fea4fa Sarah Hernandez Sarah Hernandez hernandez_sarah@svvsd.org 006503 90 2025-04-01 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-04-01 22:48:11 0.1 hrs 67e681abceb9f104f02cc6d4 000157183 3.00 100.00 100.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37989 830d0090d598c4102e9db2726682a472ff0cc9a34810837135349375e4b9a369 67e681aaceb9f104f02cc6b4 67ced48a7abf9f3ed8fed6a0 Ava Nahan Ava Nahan rtnahan@gmail.com 010738 40 2025-04-01 Checked Out 67b50520db7c513ce9d80dd3 Daphne Ryan 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Dawn Singleton - Maia H. 2025-04-01 22:50:07 0.1 hrs 67f00e146c542afe0d911bff 000157182 3.00 239.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37988 8f23e5147ca84c89203b0416053943a25d24043a83eba439c7abaddfcf34a7ce 67e681a9ceb9f104f02cc693 67ced44c7abf9f3ed8fecb08 Eduardo Morales Eduardo Morales eduardomorales8217@hotmail.com 009749 9 2025-04-01 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-04-01 23:00:00 0.0 hrs 67e681a9ceb9f104f02cc692 000157181 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37987 3227ced2875cbdb0bd6ba6f5cbff678bb27190ff65dcd67c3d8cf4e663b1fbc4 67e681a8ceb9f104f02cc672 67ced5977abf9f3ed8ff013d Benjamin Valley Benjamin Valley bv@landgate.com 014373 7 2025-04-01 No Show 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Eva Tucker 2025-04-02 03:34:10 4.3 hrs 67e681a8ceb9f104f02cc671 000157180 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37986 2de71cce926009ef47cc52363909b870a8e994de9d53dd2c4e8516519eef51a9 67e681a8ceb9f104f02cc651 67ced6097abf9f3ed8ff1061 Benjamin Weber-Sparrow Benjamin Weber-Sparrow bwebersparrow@gmail.com 015664 26 2025-04-01 Checked Out 67b50520db7c513ce9d80dd3 Daphne Ryan 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Dawn Singleton - Sophia L. 2025-04-02 16:08:28 16.9 hrs 67f00f54c31a130882e3b1b2 000157179 3.00 239.00 35.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:31
37985 7d3e784e653c0dcae71377e6902986c29da0d26cccaeaaba3d5147335af3f168 67e681a7ceb9f104f02cc630 67ced54c7abf9f3ed8fef655 Ayush Shekhar Ayush Shekhar ayush.shekhar@ptboulder.com 013443 51 2025-04-01 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton wrong patient Ranjini Ridgway 2025-04-01 23:22:59 0.1 hrs 67e681a7ceb9f104f02cc62f 000157178 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:30
37984 cd2566455deb19ded850ce390dc0389c22e0734061cde8430928a1f0c79626e5 67e681a6ceb9f104f02cc60e 67ced6217abf9f3ed8ff1374 Marsha Wertzberger Marsha Wertzberger marshawertz@gmail.com 015926 166 2025-04-01 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Maia H. 2025-03-31 22:42:35 -24.8 hrs 67e681a6ceb9f104f02cc60d 000157177 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:30
37983 1e3946232bd8d077b900bfee507f92fc3a215dd680b3137e739d56fe0f35d17e 67e681a5ceb9f104f02cc5ee 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-04-01 No Show 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Ranjini Ridgway 2025-04-01 23:59:40 0.2 hrs 67e681a5ceb9f104f02cc5ed 000157176 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:10:23 2026-06-12 00:33:30
38292 aed28c27aa24a9cb01eef031a94ccc902900729f19f08b597aeb08fcafc87808 67e6829aceb9f104f02cf8fb 67ced2f97abf9f3ed8fe6601 Jodi Bogue Jodi Bogue boguejodi@gmail.com 001130 6 2025-03-31 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Dawn Singleton - Ranjini Ridgway 2025-03-31 12:59:25 -0.0 hrs 685dc6c1cbaf0d07749cc24d 000157463 4.00 317.00 0.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15
38291 88cd31878437b2141a33fd77e6e58f656de603bbc3f4b6ebc6dcf0596c991bf1 67e68299ceb9f104f02cf899 67ced3b57abf9f3ed8fea9ce Joshua Hamilton Joshua Hamilton joham06@gmail.com 006915 21 2025-03-31 Cancel 67ace27f67327b083edb451f Michelle Osgood 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-31 13:30:00 0.0 hrs 67e68299ceb9f104f02cf898 000157462 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15
38290 16339caa2a1c1f3d3c65e035a0022404a45ea52fbe2e3c04ec93601eecaff9d2 67e68298ceb9f104f02cf846 67ced4cd7abf9f3ed8fee247 Kristie Pone Kristie Pone kristiepone@yahoo.com 011732 11 2025-03-31 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-31 13:30:00 0.0 hrs 67e68298ceb9f104f02cf845 000157461 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15
38289 fd93fcc5fea34e6c896da57ba9a79d7ea27f0db32998788aa5b740a22fa26ba5 67e68296ceb9f104f02cf821 67ced31c7abf9f3ed8fe77e0 Juliet Brown Juliet Brown juliet.brown@comcast.net 002655 33 2025-03-31 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton 7:46am Juilet - got message from Dawn - she did cancel it - on 3/19 - apt on 3/31 was cxl -- sorry for confusion. Ranjini Ridgway 2025-03-31 14:02:08 0.5 hrs 67e68296ceb9f104f02cf820 000157460 2.00 0.00 0.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15
38288 d4905c89ff7b60b844696752e09613b69b15a167573a400213a0d5a730e6aaa2 67e68294ceb9f104f02cf7fd 67e1258654aaaa3a80096bca Doreen Davis Doreen Davis doreen.davis00@gmail.com 016694 12 2025-03-31 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-04-04 14:00:56 96.3 hrs 67e68294ceb9f104f02cf7fc 000157459 1.00 95.00 95.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15
38287 7a198fe9ef7e96060bb76e3587d52b15addd1c75743147938d68191d147190c8 67e68293ceb9f104f02cf7db 67ced44c7abf9f3ed8fecb1a Jonathan Morales Jonathan Morales johnny11447@gmail.com 009755 74 2025-03-31 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-03-31 13:41:28 -0.1 hrs 67ed7776feb6f9082d891c8f 000157458 3.00 143.00 143.00 - - - - - - - - 2026-02-20 00:11:15 2026-06-12 00:34:15