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
16263 36c223ba1f93df12e3ed384b9392dceb56a838651006add3176fa4e1bc67076f 68c8a052b824708ae64501b9 6893957feff6e30874fe94cf Sierra Lastine Sierra Lastine lastksierra@gmail.com 017763 6 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Peter Gagnon - Rosey Reed 2025-09-29 22:24:35 -0.1 hrs 68c8a052b824708ae64501b8 000019856 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16262 d6dcd9637ea54bcb2d11c92ca9049c79059d23bcd93841bc7550c31ccf328762 68c1caad5f2984c80cf0fa01 689272e47f3e617ebd4cfbfe Bryce Miller Bryce Miller bryce@hatchboulder.com 017756 7 2025-09-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle Osgood Discharged Michelle Osgood 2025-09-17 18:34:24 -291.9 hrs 68c1caad5f2984c80cf0fa00 000019417 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16261 378b9426dceed151be166d8622605a947a04fbac93bf8fa870511c959e74169f 68b9cbce5c1242bc4aa0a20b 67ced36c7abf9f3ed8fe94c5 Jean Goodall Jean Goodall jj.goodall54@gmail.com 005120 16 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Jayson Encarnacion 2025-09-30 17:58:11 19.5 hrs 68b9cbce5c1242bc4aa0a20a 000018699 3.00 233.00 10.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16260 1896544337ad49cb871608050e00fed1e3d9ab138fb7f1654118fc566295b627 68af331d05575547df2f5c13 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-09-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 9/2 Sophia L. 2025-09-02 16:19:29 -654.2 hrs 68af331d05575547df2f5c12 000017781 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16259 c1d1d3496000094266979f0c4528956db3030cf0ce587f009ecd6082415887e0 6888eaf280e08d0885e07142 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Laura Shove 2025-09-29 22:51:09 0.1 hrs 6888eaf280e08d0885e07141 000014570 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16258 c648956ce18d03ff34f8bc331e7ef05945b5b2e587605297f0b95dc2d68192a4 68c34fd139f3ff70addaf607 67ced5997abf9f3ed8ff0170 Wendi Stewart Wendi Stewart stewart.wendi@gmail.com 014390 43 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-29 22:42:22 -0.3 hrs 68c34fd139f3ff70addaf606 000019617 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16257 e4d044a46efbe7813dce7b6aa7d600aced929da7e655fb05034845b271b33ca6 6876bb1c6fd3104c8004144e 67ced5117abf9f3ed8feed40 Amy Schmidthuber Amy Schmidthuber aschmidty17@comcast.net 012668 133 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-09-30 19:36:38 20.1 hrs 6876bb1c6fd3104c8004144d 000013083 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:08:27 2026-05-13 23:33:31
16538 45619ac2057337215437957e2027a3d0353e4f8e4cd04a17618559a9dc94db04 68c0ac9da6d1eabe12edc4cd 67ced3017abf9f3ed8fe6ae1 David Cavanaugh-Keyek David Cavanaugh-Keyek david.keyek@gmail.com 001546 60 2025-09-26 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-29 14:53:12 73.9 hrs 68c0ac9da6d1eabe12edc4cc 000019332 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16537 4a76e8fd02dbbcfeb684a83ebe047e06c4ddb71d74163001d152707b6c2fd166 68a8993378b59aaf6b1e9389 686e9ea42f735407e832c269 Jiayin Wang Jiayin Wang janejiayin16@gmail.com 017597 21 2025-09-26 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - John Reed 2025-09-26 15:25:05 2.4 hrs 697c092779fbdf85b5000548 000017238 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16536 1560b1df4a4b499880c7a3b692cdba6ade6b4ecd5a680eb11027a10f3b4ac5b4 686e80bd49baba9102de18ef 67ced3407abf9f3ed8fe85b8 Kimberly Becker Kimberly Becker kimberly.beckr@gmail.com 003836 55 2025-09-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-26 14:07:12 1.1 hrs 686e80bd49baba9102de18ee 000012232 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16535 b1b4c18b96fee5c3aa0bc342226cfb4c4ee333834281b916c26ede05706607de 68ac74a7c403c07edfa6f9d2 688a83b37d0edf08a27c33e2 David Grant David Grant goblin8u2@gmail.com 017724 16 2025-09-26 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-26 13:30:01 0.0 hrs 68ac74a7c403c07edfa6f9ce 000017354 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16534 38908f618bd5c01f0b936d8c9beb58d6cf9cba892a21c8a2b2b3be800a7551ee 68a8c8d5aa868ee185986915 67ced3e47abf9f3ed8feb577 Kelly Kling Kelly Kling klingfamily6@gmail.com 007910 20 2025-09-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Michelle W. 2025-09-26 13:26:54 -0.1 hrs 68a8c8d5aa868ee185986914 000017311 3.00 76.23 62.23 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16533 3f9fcffd83589693d9154e4b8547c12ceb6043d35426983402ba4b7236113005 6893c3869f3b3bae810161e2 68486ad848ba666f630450b0 Jessica Burchfield Jessica Burchfield burchfield9724@gmail.com 017431 16 2025-09-26 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-29 15:13:25 73.7 hrs 6893c3869f3b3bae810161df 000015601 3.00 130.00 130.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16532 f46f97ac81586f010444056783b3fe9432a3789a348eeebdee38e9ced18b3c4d 688d3214e0520e80d8708c3b 67ced4877abf9f3ed8fed616 Deanna Patton Deanna Patton dleet1951@gmail.com 010692 97 2025-09-26 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. scheduling conflict SB Stephanie Braun 2025-09-19 14:20:31 -167.2 hrs 688d3214e0520e80d8708c37 000015186 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16531 f2fe613d76833051a9b61e6abb31c26837dfc09f2cb3ff2cc81619cc0f59e8bf 689cb29b0ade0a0778a2de33 689cb1d90a037ce085bec243 Erica Clarke Erica Clarke ericasandman@yahoo.com 017790 9 2025-09-26 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-09-29 14:22:05 72.6 hrs 689cb29b0ade0a0778a2de32 000016146 4.00 95.56 95.56 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16530 3ca603de459c0f9685eb25886d96801425db0a5ce6dc22404ca0bc2ec32cd022 688a4ee0029a895ed5216fed 67ced3ae7abf9f3ed8fea7cd Mazin Hakeem Mazin Hakeem mazhak@aol.com 006744 30 2025-09-26 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. pt conf - 9/19 RAR Rosey Reed 2025-09-19 14:17:16 -167.5 hrs 688a4ee0029a895ed5216feb 000014780 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16529 e971847c15c1e26e1664d15bccc511128a78646d8ce12c23f9f4d65ca52f9ac4 68c1a8f16bee0ad7960eb5c4 6880f33f283f2e0843200752 Mandi Hutson Mandi Hutson mandihutson22@gmail.com 017678 13 2025-09-26 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-09-29 17:44:19 75.7 hrs 68c1a8f16bee0ad7960eb5c3 000019394 2.00 53.64 53.64 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16528 c8af2b80b75ed1f9d6a2344ebd52b0203b300b882a73f591aba7c0bb4293e331 68a4995af518b20487bc5bb6 67ced3107abf9f3ed8fe7249 Walter Davis Walter Davis wsdavisdds@comcast.net 002178 143 2025-09-26 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins 24+ Elizabeth Cousins 2025-08-19 15:35:01 -910.7 hrs 68a4995af518b20487bc5bb5 000016688 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16527 e7bb59153e7d3524faf899190c5898b4053164d3f92666642264ac485a3ab8ec 689a0cb8415516077db4d5e8 67ced3527abf9f3ed8fe8c13 Angelique Espinoza Angelique Espinoza espinoza.angelique@gmail.com 004378 34 2025-09-26 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Maia H. - Rosey Reed 2025-09-26 14:28:23 0.2 hrs 689a0cb8415516077db4d5e7 000015903 4.00 95.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16526 1a32120e74ea42a26fc0de7256e127e8e2f8624be4c92490c0b57b556bad55a8 6893863fcf55ab0806450668 68938556431f72084b4993c3 Thomas Sheldon Thomas Sheldon tsheldond@aol.com 017762 26 2025-09-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-26 14:15:16 0.0 hrs 6893863fcf55ab0806450660 000015500 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16525 9655c61e1437d3510e9b308be9703a86057fb661aba299d3e819dd2b0ca0ccbd 68839392bbb6995d0377db4b 67ced4d87abf9f3ed8fee421 Richard Przywitowski Richard Przywitowski dick_lois@comcast.net 011890 83 2025-09-26 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-26 14:17:01 0.0 hrs 68839392bbb6995d0377db37 000014327 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16524 bcb71ab22bef2f30bb94c1f2bb67e184acd8fa5a5f05726e193a54f9ff095953 68d428738bf10c6d835941f5 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2025-09-26 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-29 14:21:35 71.9 hrs 68d428738bf10c6d835941f4 000020845 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16523 657f1fdb4507e3b245734ee74747cfec2cc7163c82644098bc49f82f06b49054 68c0c4396c6fa1898d19697c 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-09-26 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove 24 + scheduling conflict -mw Michelle W. 2025-09-24 13:11:01 -49.3 hrs 68c0c4396c6fa1898d19697b 000019341 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16522 ea5c264fa8c80c26c4ad69c8a5026e6d3aed2faa1759f570881cd8ba7f22a2c0 68b1dfd08b12a1b08603fdf3 68b1def83d7ce44aab14b66c Matthew Laws Matthew Laws laws1212@comcast.net 019781 12 2025-09-26 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-09-29 14:48:56 72.3 hrs 68b1dfd08b12a1b08603fdf2 000018204 4.00 95.71 135.71 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16
16521 92450c7f9bf6649af5bd3f95b1440118a78144f97a27eb2ed1e804d45fc57bd8 68b1c0ca1080ee07dc2409ba 6893cf46991c8a07b5078073 Denise Froning Denise Froning denisefroning@yahoo.com 017764 15 2025-09-26 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-26 14:31:20 0.0 hrs 68b1c0ca1080ee07dc2409b9 000018141 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:09:17 2026-05-13 23:34:16