General Visit (PT Boulder API)

Total rows: 101,513
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
15563 76167111eae1064be283513efdc51b12f88e463cf5021314a1df9e3574bfaa68 689a21de235a96077c176677 689a215725ee00a9358909d3 Louise Pearson Louise Pearson wingedpickle@mac.com 017776 6 2025-10-06 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-06 14:52:47 1.1 hrs 689a21de235a96077c176672 000015926 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15562 9e4c9346d34a5dbd810ae128b6a2c70ed6856a2606606bd08eab8eb1e4ca3943 68d2be7fa59b20a62e16a5ea 67ced30e7abf9f3ed8fe7171 Kenneth Bray Kenneth Bray kibacat@icloud.com 002106 15 2025-10-06 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Sonya C. 2025-10-06 13:55:56 -0.1 hrs 6986145677332c038626b64b 000020601 3.00 85.00 76.50 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15561 fd8cd9118312e697f4e633af0a09589307d67c0dcd1d126b5d93cf6f8fac51e5 68d1cf0afdf047afde51f90d 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-10-06 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-10-06 14:43:07 0.7 hrs 68fa63d5a05a0409d75dc236 000020545 3.00 85.00 55.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15560 1a80c255332704b6095448164fbbd5e9184682c1c9a457a3d5dfc71c5efb7c91 68c9ab47f4e3fe9a8e8070d3 68489a57f839a307c1be27be Rita McCurry Rita McCurry mccurryrita@gmail.com 017434 18 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-10-06 13:56:01 -0.1 hrs 68c9ab47f4e3fe9a8e8070d2 000019906 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15559 0be7d9d8976a9e2321f46af7a62c48ac558997eac5dadb95468f6c2edf560587 6880faf92ef7fc084ca29314 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-10-06 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Per VM request - sc Sonya C. 2025-10-06 12:45:52 -1.2 hrs 6880faf92ef7fc084ca2930f 000013966 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15558 c60bc5b2aa0bd4ef4f6e5bff060dfe8f2b9ce6004629a50cca6d928a24da875c 68c32425261e6880cf7c3ac2 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Michelle Osgood 2025-10-06 14:44:00 0.5 hrs 68c32425261e6880cf7c3ac1 000019580 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15557 fd6947e4ce63e4ce1b60b017dfcab87f309e229bb1fe85c2695a62e927761ee2 68912808648c3739cee9b282 67ced6447abf9f3ed8ff17e6 Richard Wolf Richard Wolf richwolf@infoscapes.com 016305 107 2025-10-06 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67875c9d2cdd464578564 ACN OT/PT Initial Evaluation - GET FORM AND OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-06 14:47:11 0.5 hrs 68fa658ed427c109fd8a0ebd 000015333 4.00 171.67 171.67 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15556 aa8bd63ab49b07da90d3c85bd252a83f1e5d07cb23397f3e5f23608a8a332c3b 68cc7eba83e3b403863014f6 67ced5f17abf9f3ed8ff0d48 Callum Taylor Callum Taylor callumtaylor@me.com 015400 19 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-08 22:15:58 55.8 hrs 68cc7eba83e3b403863014f5 000020252 3.00 82.00 80.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15555 724af099374334fbeb21dbbcc9448d8471c9790a50bef2a7403ae2d53f04c2af 68c48ce0bf1056ce4f9345da 68a8bf075260c9e13f76eb8b Marlene Redman Marlene Redman marlenesredman@gmail.com 019732 11 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-09 15:46:19 73.3 hrs 68c48ce0bf1056ce4f9345d9 000019730 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15554 c0189563fce8c1539503ffa734ed9996ed7bb59e15c144f24ea711a941943560 68a633db4ce27b21b366da59 68a6315c85a86b3c4dee85e1 Alan Sorota Alan Sorota sorota12@aol.com 017867 18 2025-10-06 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-06 14:42:35 0.2 hrs 68a633db4ce27b21b366da57 000017009 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15553 bdddab0bea3a5e36ab0d2f2314f27d9ef7c93a723d8c87a8bf7ab6184a87e0f2 689f873bc93793087b4e15a9 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-06 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-06 15:20:15 0.8 hrs 689f873bc93793087b4e15a8 000016466 3.00 -70.82 83.09 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15552 810c907e16dcdd8bab024ee314d7cdc6961b04c793d7f338b1ba81897cb67a1d 688a4a2f99de3307937a0395 6837463af6142b08391bddd6 Nancy McCoy Nancy McCoy annemccoy27@gmail.com 017327 48 2025-10-06 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt having surgery- sc Sonya C. 2025-09-08 15:15:45 -671.2 hrs 688a4a2f99de3307937a038f 000014773 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15551 07743c94d25bbe7c899af34f09a4dc877e00a12be7c38548996a654824e1d4e0 68dad290e357404742a7b9a5 67ced3a17abf9f3ed8fea4ac Kristina Jensen Kristina Jensen kgraceco@icloud.com 006477 7 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 19:40:15 76.9 hrs 68dad290e357404742a7b9a4 000021391 4.00 70.45 70.45 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15550 2947971874d1b1b55fa19cf791d98edc78ec4df8498efb44c420c179ef467458 68d2b548b09dd7080599a505 68d2b51907213e079588f54d Christopher Walzer Christopher Walzer chriswalzer@comcast.net 019916 28 2025-10-06 Cancel 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ still in a lot of pain,- sc Sonya C. 2025-10-06 14:14:20 -0.5 hrs 68d2b548b09dd7080599a504 000020571 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15549 36e3336178b3e165390cea3b396c616edfddf872261bedd38f3bcdb9095bb814 68c0443840fc4f3c6d0f1cc2 67ced3a17abf9f3ed8fea4a9 Daniel Hernandez Daniel Hernandez hernandez_daniel@svvsd.org 006476 48 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 14:40:10 -0.1 hrs 68c0443840fc4f3c6d0f1cbe 000019160 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15548 f96d740ff68f62f92f22dcd7cab5d2d2128a53ed804859bb9f7f80553eddd426 68e03c92eb9e3909a7498730 67ced35a7abf9f3ed8fe8efb Stephen Fausett Stephen Fausett cafsaf1964@gmail.com 004626 6 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-10-06 14:37:07 -0.4 hrs 68e03c92eb9e3909a749872f 000022245 4.00 170.07 170.07 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15547 65cc6c27da3082bc69710a1af57e3a9e3fb256d505b4815407f64f3b612299c3 68cad6b4b01f4a9d28bec013 68cad6a481d753083e522003 Stephen Fausett Stephen Fausett steve@ptob.com 019881 1 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. (duplicate pt accidentally scheduled here) Sophia L. 2025-10-03 21:13:38 -65.8 hrs 68cad6b4b01f4a9d28bec012 000020005 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15546 d67b44e0472d4a8f03bf4fc001af21c439a3b00d46f5b618a693ce0b4f0c1f2b 68bf3d793621154d6cd15080 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-06 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Primary - - Yes Amie Russell - Kenneth Dave Francisco 2025-10-10 15:33:18 96.6 hrs 68bf3d793621154d6cd1507f 000019102 3.00 0.00 25.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15545 376af86e7328a77563aeef0898d1083f04275d2f26a0521c5be4574dcdd0ea0c 68af1c5e06a0ec9bb6989f91 68af1b04a23675335b1d3864 Janet Branham Janet Branham jbran281@gmail.com 019753 6 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-08-28 18:57:09 -932.0 hrs 68af1c5e06a0ec9bb6989f90 000017711 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15544 ebc2b8342a3f832f1dfedd464cd8a2945c5dfd3e007c42367cac36bc4630e385 68ac860df16e7507d3e746ff 689264aa22e70f07b2aca32b Kumiko Pentz Kumiko Pentz jpentz1@gmail.com 017754 11 2025-10-06 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Sees PA-C next day. Michelle Osgood 2025-09-29 15:18:50 -167.7 hrs 68ac860df16e7507d3e746fe 000017375 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15543 07db4cb34ec1cf5cc7792b12a5410768f384bdd47081866d404c3ee4cfcafedc 68dab491560e7bf8b52437cb 68bb234f83c31468e4f54258 Brian Hedstrom Brian Hedstrom brian.hedstrom@gmail.com 019811 9 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-10-06 15:12:44 -0.0 hrs 68dab491560e7bf8b52437ca 000021353 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15542 7746e22501a06ab4fe8143a56e36b03d0568874b1aa810b381ed346357600c6e 68befc42904934661d947614 68befb23347a016661c952ea Kathryn Heien Kathryn Heien borkheien@msn.com 019815 9 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 15:52:09 72.6 hrs 68befc42904934661d947613 000019007 4.00 315.00 10.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:39
15541 8c445ff8af74317bce7a8b6b78710ed46e7777776888637ec24544f76709ac79 68af2ce1acebc94ce8ed38e4 68af2b6bacebc94ce8ed20e5 George Kretke George Kretke gkretke@msn.com 019756 25 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-10-06 15:10:18 -0.1 hrs 68af2ce1acebc94ce8ed38e3 000017754 5.00 75.00 75.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:25
15540 fc7046474e73a3864c232076caee5eac30da764f50dd6601590f7708d5bd45fc 68a8808ca3aeb40777b6fde0 681924f2b2c8fc7022464a1f Michael Livesay Michael Livesay michaellivesay2@gmail.com 017179 44 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 16:00:00 0.8 hrs 68a8808ca3aeb40777b6fdd9 000017195 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:25
15539 3f60b55b13bb30c3277c5c94e58fb91325aea1e8d04f622a5790b297be1f7ce4 6890f367c1f7c6e6b3decc63 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-10-06 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-21 17:43:41 362.5 hrs 6890f367c1f7c6e6b3decc5f 000015247 3.00 60.00 65.00 - - - - - - - - 2026-02-19 23:06:31 2026-05-12 23:31:25