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
24449 89a84b1ace471c95c5430722bc3f7c642597c53079180bfed3e8e09373654df6 685d74cbfd70450877ec321b 67ced3157abf9f3ed8fe74c8 Barbara Brockman Barbara Brockman bigapplepappy@gmail.com 002391 19 2025-07-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Primary - - Yes Gillian B. - Laura Shove 2025-07-23 00:17:09 1.5 hrs 68e6bb416fc6580a095018d1 000010910 3.00 -234.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24448 93724378c240b09cb16627a29362e98433bfbbf7e5bc0eb80efcb02e64adfe20 683641b26160fb07ded49c35 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-07-22 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sarah Emrey 2025-07-22 23:48:54 1.1 hrs 68cd6a55d46aa3c8be99b6d2 000007145 3.00 79.00 79.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24447 b3ff4fc9e272a2ee76cbe6a7b374aaf02576a831c7c158ea813f5b9c6c99c7c9 6877c61d47f9f60860e90ff6 67ced3487abf9f3ed8fe887c Cheryl Edson Cheryl Edson capn.bob65@ptboulder.com 004072 174 2025-07-22 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Jack referred to home PT- sc Sonya C. 2025-07-18 20:37:39 -98.4 hrs 6877c61d47f9f60860e90ff5 000013146 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24446 3e188d3665f4e2f20253902cad6078e69154a5d0601622b779e02a8a81dea567 6859c62c7ebc6e3972499b12 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-07-22 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-07 15:35:02 1840.6 hrs 6888d4feb91e6537411e5693 000010412 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24445 705c9c6dc8017d6c5c39309c08ab36dbf813bd36c4e59b914722f635a546a02a 683f23499f8321086def9dc8 67ced3007abf9f3ed8fe69f4 Neil Anderson Neil Anderson 1973noa@gmail.com 001467 41 2025-07-22 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - James Fowlkes 2025-07-22 23:04:03 0.1 hrs 683f23499f8321086def9dc7 000007907 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24444 a95a9e2b823b1a0dcb02772ef5f8ced61a80e0dbc61ac18514cfa73a5d7e9d9d 6838d7bb5446f9089650bed4 6838d6f7dec53c07ddab1f11 Lillian McDonough Lillian McDonough lillyroseerling@gmail.com 017342 6 2025-07-22 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Anne Majewski 2025-07-22 17:20:14 -5.7 hrs 6880ee4dd3adb72210edec48 000007527 1.00 150.00 130.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24443 60131587968f6184c8bf96dad7c0f55acdab85aa0ce7b3d3fe44451014e8b93a 684b59e66405878af195e24f 67ced3077abf9f3ed8fe6dd2 Joseph Dascomb Joseph Dascomb jdascomb89@gmail.com 001797 58 2025-07-22 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Eva out sick today- sc Sonya C. 2025-07-22 14:17:05 -9.0 hrs 684b59e66405878af195e24e 000009241 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24442 9b97c6cc31a2b98513f3fc9b047c7e377ea3e93ef68520910d5ce9e173dcb19b 6877ffa47226ac1007bf95b5 67ced3c37abf9f3ed8fead61 Leah Kaplan Leah Kaplan leah@leahkaplan.com 007220 55 2025-07-22 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - James Fowlkes 2025-07-22 23:44:58 0.2 hrs 6877ffa47226ac1007bf95b3 000013231 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24441 5daf444d58dc2cdc7365668c27fec0fbdbf2f7219e80eefbacbdc4f6810cb3c8 6866f776bf205e0775c578f9 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-07-22 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-12-01 22:07:05 3166.6 hrs 6888d51a70b54993568f47d7 000011839 4.00 95.65 95.65 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24440 7ca26605e94cc178cb390b9e558601d09834846d48daa39178e13ae567cca2a2 685d6e1efd70450877ebe43a 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-07-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Michelle W. 2025-08-26 13:53:02 830.4 hrs 685d6e1efd70450877ebe439 000010908 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24439 2f8eeb39a4db59a052b195dc297f1c603844d427a724644e8eb5ace8dceb361d 683f065dda0b4d66f39be53d 6839bfee4bc12ac92a39b5c9 Donald Blunn Donald Blunn dablunn@yahoo.com 017343 12 2025-07-22 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 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:59 -179.2 hrs 683f065dda0b4d66f39be53c 000007864 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24438 5eb7ec56d4910c834dba86fd7fd784de6a3fda628afa695f669bf1f7c1d0ddd1 67fd2489e96368084a580ae1 67fd228eee2974394ca69bb8 Dawn Prudence Dawn Prudence Mistletoeroad@icloud.com 017042 10 2025-07-22 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Gillian B. 2025-04-25 20:29:04 -2115.0 hrs 67fd2489e96368084a580ae0 000002031 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24790 64d5f3961bde9a7cb650b30caa527ddceab4e39f4d8216fed3a4855a02d53ea9 685995eb5e59ef08298f97f9 683894c42f21dae449a884bc Erin Giveans Erin Giveans ekgiveans@gmail.com 017340 37 2025-07-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-21 13:57:33 1.0 hrs 685995eb5e59ef08298f97f5 000010330 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24789 333535cdcabe04a75447e02bde68c65f58be492feb3f60b1c1d7daabe0ef421d 6846f4b2eed7a107552096d2 6835d187c27824081ca6323e Jennifer Melius Jennifer Melius jenny.melius@gmail.com 017308 15 2025-07-21 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Elizabeth Cousins 2025-07-21 19:21:17 6.4 hrs 6846f4b2eed7a107552096d1 000008677 4.00 95.00 19.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24788 022b96b68b840c9b5c8435ae0860659111fc88f4c570db65e7a8c3fd41fe9be9 68000f338e2b1c95e8fa6e5d 67ced3117abf9f3ed8fe72dc Evan Christenson Evan Christenson evancolorado@msn.com 002227 56 2025-07-21 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Sonya C. - Samantha Saunders 2025-07-21 13:17:21 0.3 hrs 68bc6998b5e9db8bff3274ea 000002502 3.00 238.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24787 84e31560ad78dfd4cdd7d6cb4186c92907cd24f542d624e8a8f28a6444f812a1 6877d12fd6fce807f97aff1d 6877d0a077efbe083f08562b Joshua OCallaghan Joshua OCallaghan joshocal@hotmail.com 017637 6 2025-07-21 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Frances Lawrence 2025-09-26 17:17:45 1611.8 hrs 6877d12fd6fce807f97aff1c 000013174 4.00 95.45 95.45 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24786 9e48f4b2054696d4826acae4abaa3b8f318dcbd16e11de10f22276b3bf67af4d 686ecb58c59bf5ed90f17a3c 686bfeb00b871f888e59cf42 Tamsyn Waycott Tamsyn Waycott tamwayco@gmail.com 017578 10 2025-07-21 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per pt request, cancelling all FU appts - sc Sonya C. 2025-07-18 14:15:17 -71.2 hrs 686ecb58c59bf5ed90f17a3a 000012342 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24785 a9b4c61b48cfbfaf1c13e3d20cb1df8e93a54c146ef3ad6507e154e44d58b6f5 686553d0c27199952595995d 67ced5a77abf9f3ed8ff0368 Michelle Stoll Michelle Stoll michelle.stoll@gmail.com 014558 66 2025-07-21 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Pt is ill with food poisoning. No Fee. Michelle Osgood 2025-07-21 13:45:54 0.3 hrs 686553d0c27199952595995b 000011589 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24784 bfe7a0aace997a64c31d4ca413aa7a5c73ada3561dcdf57c7d4c2312138284f4 68251d7ba0a056f064220e70 67ced3697abf9f3ed8fe93e4 Jacob Hansen Jacob Hansen jrhansen1392@gmail.com 005045 102 2025-07-21 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. - Gillian B. 2025-06-25 21:48:05 -615.7 hrs 68251d7ba0a056f064220e6a 000005650 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24783 6c2c05e00e96cfd7ae493688a8e0ef867554b8e7f5663d65638ed7dd07a6cd00 686ea2c5e04d4b07f1e7e0ef 67ced3107abf9f3ed8fe720a Robin Davis Robin Davis rdavis5669@comcast.net 002157 126 2025-07-21 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-07-21 13:00:54 -0.7 hrs 686ea2c5e04d4b07f1e7e0ee 000012304 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24782 bae7e89ba89d4395cf402b5e930938a8141acd5aa7b0ec1bdac19177690567e8 6862b994f7b407081bf23668 6837463af6142b08391bddd6 Nancy McCoy Nancy McCoy annemccoy27@gmail.com 017327 48 2025-07-21 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-21 13:57:51 0.2 hrs 6862b994f7b407081bf23667 000011276 4.00 113.02 113.02 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24781 cf5873c1142fe6af9043f53418342c0da48e175eb608d24cc3e1da362163b506 686fe17445f839089419a91d 686fe09cf99b6908282cc31e Christine Broers Christine Broers tbroers@icloud.com 017601 8 2025-07-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-21 13:57:43 -0.0 hrs 6888db37e55f7107803053ab 000012425 4.00 100.63 100.63 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24780 da60e96de46fdab35f4d455e711fd4a73b3901909e6912350095e1d3bf810bab 6859669e4a975407ddad479d 67ea9a0249a1d40790cde82d Markos Wester Markos Wester markoswester@gmail.com 016920 9 2025-07-21 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Samantha Saunders - Maia H. 2025-07-17 17:43:45 -92.3 hrs 6859669e4a975407ddad479c 000010243 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24779 127f4354cb1746852873b7b50495f76917b8160f913714ce7a3189a5a59ca167 68504068a453a607cccd48eb 67ced3527abf9f3ed8fe8c13 Angelique Espinoza Angelique Espinoza espinoza.angelique@gmail.com 004378 34 2025-07-21 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-26 14:21:31 1608.4 hrs 68504068a453a607cccd48ea 000009432 3.00 81.15 81.15 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23
24778 9ecd12ee5678b2e8128497dc64e6b8adc3b27bac8817d3a66ad3bda9b43aab72 68432a883809ac07ae9afa40 684329e261683c082e122448 Wayne Howard Wayne Howard hyzinga@yahoo.com 017412 13 2025-07-21 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-21 14:01:57 0.0 hrs 68432a883809ac07ae9afa3b 000008599 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:32:49 2026-06-11 23:59:23