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
16548 e67064a52cb587957b9778ff45e6098a3fd5f7289c1323c8279330fd255d06e2 689bc03de20335078b5ee8ee 67ced3617abf9f3ed8fe915c Kelly Fertitta Kelly Fertitta kellyfertitta@icloud.com 004829 23 2025-09-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ sch conflict - sc Sonya C. 2025-09-19 19:26:06 -147.1 hrs 689bc03de20335078b5ee8ed 000016099 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16547 d3fef6194faff382f4c8b690f7348a1b0dcb79f4222baf95c4e55f0f82ddcbd4 68894bf87fe700b76ee1a2c5 67ced30b7abf9f3ed8fe6f7c Allen Chavez Allen Chavez allen.chavez@bvsd.org 001939 101 2025-09-25 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-25 22:37:22 0.1 hrs 68894bf87fe700b76ee1a2c4 000014724 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16546 2bdfbe9ca6d42eada853e2e63eae049ba8799760fba206dbad3aa6ee490fe2e9 688b988801c6150846c3b9c5 6848895be76ec2076829f880 Britt Alstad Britt Alstad alstadb@proton.me 017433 21 2025-09-25 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Stuck at Dr. appt - sc Sonya C. 2025-09-25 22:36:07 -0.1 hrs 688b988801c6150846c3b9c1 000014940 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16545 d253ed61b48763a18273420c89c1388f82795eb844dfd5e0fca2dc5be96be4e9 685c5a928e230c4bb43a843d 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-09-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-25 22:28:49 -0.3 hrs 685c5a928e230c4bb43a8436 000010793 3.00 79.29 79.29 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16544 599a47fe26d8f338b5d8616a8ef696938c9b11c4c538479fd59269c3da8ef8df 68c0aaeeb9c23e1bdfc62de0 68a89a2b8f892d07ede2fd3b Sean Kemp Sean Kemp jskemp7602@gmail.com 019727 36 2025-09-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-25 22:53:27 -0.1 hrs 68c0aaeeb9c23e1bdfc62ddf 000019321 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16543 0bbdd1750fc1c77e2d300e91279e78c30d92f765d44d732755bac31e463a3c79 68a39297a80a15fc4d5ef7a1 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-09-25 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-09-25 22:57:16 -0.0 hrs 68a39297a80a15fc4d5ef7a0 000016591 3.00 233.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16542 adc20afbb34b5b46ba6de8bd0d9e8054bf7d1a5bab97f6b57e173f8fee72516d 688a588f3b68350808c9cff0 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-09-25 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. teacher conferences - sc Sonya C. 2025-08-05 23:02:35 -1224.0 hrs 688a588f3b68350808c9cfe8 000014796 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16541 0ba3f6937ecb4f5dd2eb53779aa4c2513e47fa473d2599e81cc4bf48ce332653 68a5e4fd7784df07fca8ca3c 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-09-25 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-17 18:01:54 522.8 hrs 69b9ffecd828ca96901b3e7a 000016861 3.00 233.00 50.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16540 cb091d6c2f091a8187c454bafa461014caf0e47a2de5a0e42e3e20b1c10ffe96 68c3515dbcb2c63da0a709c8 67eab3a06cfbde087431910a Jeniffer Grodberg Jeniffer Grodberg jeniffer@jeniffergrodberg.com 016934 15 2025-09-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Laura Shove 2025-09-26 00:43:44 1.2 hrs 68c3515dbcb2c63da0a709c7 000019619 3.00 79.29 79.29 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16539 adfb8b12f3d12d68e42cae4a06b9fed654046dc116809c858e0a744852693d73 6876bad55049a707fd2fc497 67ced5117abf9f3ed8feed40 Amy Schmidthuber Amy Schmidthuber aschmidty17@comcast.net 012668 133 2025-09-25 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. conflict Laura Shove 2025-08-29 00:13:38 -671.3 hrs 6876bad55049a707fd2fc496 000013081 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16891 2c1d23b2ebc19b135dbc787ede3d9017a2bb054ebbecd7a3e79779b69a08bf2a 68bf12d68a24528a27dc14fc 68bf0a6aa864912cce335d8d Connor Bettencourt Connor Bettencourt cbettencourt04@gmail.com 019818 6 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 15:20:15 26.3 hrs 68bf12d68a24528a27dc14fb 000019044 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16890 faeeae83c467bc0349249c11076c184e868634ace22b41ebe73d630076dc807a 68b0d28f282bd73c1aab7556 67ced5087abf9f3ed8feebd5 Kenneth Robinson Kenneth Robinson bruceliz2014@gmail.com 012547 16 2025-09-24 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-28 22:07:04 -638.9 hrs 68b0d28f282bd73c1aab7551 000018118 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16889 21f024f7e7a02b55c27fe1c4152af0f7769c5a042b6a085292f98ee85138c2d7 68b0d28d720f99e560bdcb82 67ced5087abf9f3ed8feebd5 Kenneth Robinson Kenneth Robinson bruceliz2014@gmail.com 012547 16 2025-09-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-09-24 13:56:23 0.9 hrs 68b0d28d720f99e560bdcb7d 000018113 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16888 5ec26020197e78b36e72afd3bd9289bfd65ae133889ca7565a6716cf01d7eaba 68a38f3715b0d2599b975676 68a38e7aba796dc7de088f3a Kerstin Dickson Kerstin Dickson kl.dickson@comcast.net 017816 28 2025-09-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-09-25 19:59:13 31.0 hrs 68a38f3715b0d2599b975675 000016583 3.00 85.91 85.91 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16887 f2a939d209144f8c4380e30730b86a47d480244ee443cc99f1445818f437c43d 688d2f8cd75f05b79efa5cfe 67ced3217abf9f3ed8fe791b Lana Clymore Lana Clymore lclymore@gmail.com 002760 66 2025-09-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 1x/week Samantha Saunders 2025-09-08 13:23:15 -383.6 hrs 688d2f8cd75f05b79efa5cfd 000015182 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16886 dfaf481a775e8fcbdf855106d3d119ac785c7b572e987f62ddc9ac545a50f6c6 68cdb0cdb56e37085de23bbe 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Mark Leo Guevarra 2025-09-25 21:16:41 31.8 hrs 68cdb0cdb56e37085de23bbd 000020351 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16885 d553f5f0b993b59512d25a9b1a1a7bf827cd1c71c92f3284f118d6c94a91f15d 68cac0897a5d2f4622cf3e9b 67ced5a77abf9f3ed8ff0368 Michelle Stoll Michelle Stoll michelle.stoll@gmail.com 014558 66 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Jayson Encarnacion 2025-09-29 22:30:48 129.0 hrs 68cac0897a5d2f4622cf3e9a 000019991 3.00 85.00 85.01 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16884 0bf803760175aeb0d4c7e056677c02bf4f76c506f101d6a5aed10cbecac8831c 68bf4f4c49b1200cdfbc350d 68bb234f83c31468e4f54258 Brian Hedstrom Brian Hedstrom brian.hedstrom@gmail.com 019811 9 2025-09-24 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt down to 1x per week - RAR 9/15 Rosey Reed 2025-09-15 16:46:22 -212.7 hrs 68bf4f4c49b1200cdfbc3509 000019125 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16883 57d9ddbe1260b5ee50cc8092ef1cf89e4cf6c7fce2fae0b7b32ca499aff726fe 68a61f6bbbabc467db42d6df 67ced4647abf9f3ed8fecfa7 Caroline McClurg Caroline McClurg mcclurg.caroline@gmail.com 010143 34 2025-09-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-24 15:02:38 1.5 hrs 68a61f6bbbabc467db42d6de 000016956 4.00 105.64 64.78 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16882 a12d75feb8cfb3f75d915de6e91477f3f68a12570162ad422c3f59878bd1eb8f 6893733cb489dd089f141460 67ced5b67abf9f3ed8ff0586 Robin Smith Robin Smith robins@gmx.us 014738 21 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 18:14:17 28.7 hrs 6893733cb489dd089f14145f 000015485 4.00 95.95 120.95 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16881 e5e5ea5f838dcfb208cc120b71b567b7e6f487dce73f273c2a6836ff6c9cf908 688a92fba015c50e743bf3a3 67ced3847abf9f3ed8fe9c87 Johanna Heart Johanna Heart jandsheart@msn.com 005782 59 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Samantha Saunders 2025-09-24 13:36:34 0.1 hrs 688a92fba015c50e743bf3a2 000014885 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16880 ed6849acf79fdf1d16f4c9f8076901a189c8ac13af0e6f59ea317e36cbc3c03b 68714c86a86c0b082f53dea4 67ced54b7abf9f3ed8fef625 Jenna Shedd Jenna Shedd jen.e.shedd@gmail.com 013427 29 2025-09-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-09-25 20:02:20 30.5 hrs 68714c86a86c0b082f53dea3 000012660 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16879 07400148779851de091af880b0387d8fac016370beaf8c3db0ff7bd6b69ca959 68308098297bbfda698d4c46 67ced3c77abf9f3ed8feae75 Martina Kastengren Martina Kastengren kastengrenm@gmail.com 007312 39 2025-09-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Marguerite Barth 24+ due to work schedule - sc Sonya C. 2025-08-12 15:48:33 -1029.7 hrs 68308098297bbfda698d4c45 000006756 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16878 22b4f2278468136d725751382bb47cfad62fdf3e6499ecec4b6a0434f8bb4312 68af821b512c7eacf715da76 67ced2f57abf9f3ed8fe639d Christopher Crisman-McQuarrie Christopher Crisman-McQuarrie cammcq86@gmail.com 000926 14 2025-09-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Mark Leo Guevarra 2025-09-25 18:40:00 28.9 hrs 68af821b512c7eacf715da75 000017915 4.00 85.00 157.25 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19
16877 4d6513a943c071a09197c8768956160489999071daf3257c9c1629d0b572aa04 68922207a7813c083f0e85da 67ced3f57abf9f3ed8feb95c Stefanie Kyser Stefanie Kyser steffpedals@gmail.com 008242 51 2025-09-24 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia Phillips 2025-09-11 18:33:45 -307.2 hrs 68922207a7813c083f0e85d9 000015358 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-06-11 23:39:19