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
99953 ba518a0164ab363b7cd2eee434a1d4ef6a59b7e9ec797f09965c9192c285868f 69b86e3f52e3d83f8e0cdb9f 69b86d895557bfae1f1b8ee0 Frank Bowling Frank Bowling A76Buff@aol.com 020921 9 2026-04-30 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Laura Sage - Michelle W. 2026-04-30 21:04:26 0.1 hrs 69b86e3f52e3d83f8e0cdb9e 000041412 3.00 235.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99952 b1efc26ff1ccda597639cebbdad40a6a11f00d870ddd3b1077ada3ecabba7d45 69b07a6ba832c346f6307b22 69b0770a640c777592b34cfe Charles Swafford Charles Swafford swaffordc3@gmail.com 020888 21 2026-04-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Laura Sage - Mark Jerome Para-ase 2026-05-04 15:56:58 90.9 hrs 69b07a6ba832c346f6307b21 000040707 3.00 236.00 25.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99951 4ecca81864488f3250ba9efd3825339d5d1035511b28e4cf6347c506bdb1d261 69a07d1c82d6e69eb021a01d 69a079a7d2831eae76cf6d1f Makena Regan Makena Regan mskem0610@gmail.com 020830 18 2026-04-30 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Haley Paull do not accept ins 2/27 - HP Haley Paull 2026-02-27 16:36:28 -1492.4 hrs 69a07d1c82d6e69eb021a011 000039364 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99950 5c104bb982c9b40b2ed1a3e66e3623aa02cc215c5375a22ae4918903a1d9b2b1 69934eb9e9cb9b779f91e935 69370f228c4fd80468916cd1 Renee Wilkes Renee Wilkes brirenw@yahoo.com 020342 22 2026-04-30 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Haley Paull - Christian Kenneth Abungan 2026-05-06 14:57:30 138.0 hrs 69934eb9e9cb9b779f91e934 000037704 3.00 236.00 25.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99949 0eb0fb5eb075d79ef34b21d5e0abd211d804ae9e8d837c84a6e1d13fd210573f 69af0123085d9c638c8b91ad 67ced4d17abf9f3ed8fee2dd Nancy Pottoff Nancy Pottoff npottoff@hotmail.com 011782 539 2026-04-30 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Haley Paull - Sophia L. 2026-04-30 21:05:35 -0.2 hrs 69af0123085d9c638c8b91ac 000040496 2.00 80.00 80.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99948 eb51d2bb7504fa86916c51bd689bbe7dd4e821f87f624f6a12fd87c5333ed58f 698520b6dc0e10f82feaa914 68361a11c03fb8088a923089 Robert German Robert German rfgerman@icloud.com 017316 14 2026-04-30 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Michelle W. - Sophia L. 2026-04-30 21:15:29 0.0 hrs 69fb84b228e8411130145b13 000036783 3.00 234.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99947 6f9b383193e753766f658da76b2fcf20135181e174f9e86fd5833c5dc1cf317a 6972abbc2256f10b1a1ea69c 67ced4407abf9f3ed8fec8a7 Richard Montgomery Richard Montgomery rmont2u@yahoo.com 009546 99 2026-04-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Renee Carr - Haley Paull 2026-04-30 21:06:47 -0.1 hrs 6972abbc2256f10b1a1ea69b 000034992 3.00 83.38 66.44 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99946 459e6785a61d77540e462573e0899ffc6995c3c4741d403d60d75d2b4b0886df 69e66599ef62bb43942d4fa7 68a8153199c65c4a78a5f925 Brad Hoeben Brad Hoeben bhoeben@yahoo.com 018639 25 2026-04-30 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-05-04 17:25:50 91.9 hrs 69e66599ef62bb43942d4fa6 000045381 3.00 85.00 85.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99945 276d2c88596d7ee20fbec10c9f4b7ef01c70f799ac1cca66453fe2ee0c18eef3 69d8082bd02bcefbda61f415 69a70b4bf5b153a944301327 Deborah Tolejko Deborah Tolejko datolejko@gmail.com 020853 7 2026-04-30 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Pt says "she is cured - thank you" - sc Sonya C. 2026-04-27 16:52:23 -76.6 hrs 69d8082bd02bcefbda61f414 000044376 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99944 fe4e7e572362da290ff818d874abe7a184650b51446826cd45059b842fe9268a 69bad59d75c76825bb49ccdb 690cea8aebe679263bb3218c Megan Frisk Megan Frisk mfrisk91@gmail.com 020216 16 2026-04-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Christian Kenneth Abungan 2026-05-06 14:55:37 137.4 hrs 69bad59d75c76825bb49ccda 000041702 1.00 95.00 95.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99943 00ac0ed860d6cf939a86eb4e82a69154748796c7a9e0ea4f653c048b12dd211f 69b461181869171a6a5af27f 67ced3b67abf9f3ed8feaa28 Paula Hamlin Paula Hamlin bothofus@edwardhamlin.com 006945 21 2026-04-30 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Haley Paull - Sonya C. 2026-04-30 21:28:55 -0.0 hrs 69b461181869171a6a5af27e 000041266 4.00 95.95 95.95 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99942 4ea1428bd7dac844364befa59eed2cdfd1ca2faf94c5a34d221954b8786b9478 699892a994f0e08460d48039 696ff12a6050bdefafff1a97 Aimee Hansen Aimee Hansen aimee.hansen@live.com 020594 23 2026-04-30 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sophia L. 24+ scheduling conflict -mw Michelle W. 2026-04-28 17:24:21 -52.1 hrs 699892a994f0e08460d48038 000038459 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99941 fa83b876cca47f079fb92b4aaeab5e21997d36f1aee1bc1a9058a0ccf7d9da48 699393a0f4176874fc15d023 68af4369f2725b078f7fdf8c Kai Phinney Kai Phinney kai.phinney08@gmail.com 019761 13 2026-04-30 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt has been discharged - sc Sonya C. 2026-03-20 14:37:40 -990.9 hrs 699393a0f4176874fc15d01b 000037789 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99940 1ae1613d7c52bc7af74f516f76be9826de07bc17a232a6e9c703e123fadf8605 69e131ab8071f9590fa847be 6998d1dd75012cbc3c875f06 Timothy McDonald Timothy McDonald timromc@gmail.com 020802 19 2026-04-30 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2026-04-30 22:02:32 0.3 hrs 69e131ab8071f9590fa847bd 000045146 4.00 306.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99939 d03bb9fc73fd5e7602d42e9b6a279ceaaf325e4cdf08335e6fbcfef2000b034c 69b87abba8c2dcafb9726818 695d6fee91db33ce7f5143ed Kristine Hagemeyer Kristine Hagemeyer hagemeyer_kristine@svvsd.org 020464 17 2026-04-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Haley Paull - Sonya C. 2026-04-30 21:45:43 0.0 hrs 69b87abba8c2dcafb972680e 000041431 3.00 231.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99938 9fdaf61b479af6f942ed509317c8e6086329446bfaa63e5e744da23bc054edf9 69e665c8c0e46172ab42a54c 68a8153199c65c4a78a5f925 Brad Hoeben Brad Hoeben bhoeben@yahoo.com 018639 25 2026-04-30 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. too soon -mw Michelle W. 2026-04-20 17:46:24 -244.2 hrs 69e665c8c0e46172ab42a54b 000045382 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99937 bb1500347d7199b2ac1f8a0f328132c7f15266591942b4269acf4fe1f98dec65 69dd455547c6e4344d3ae623 69b853ce8d26340f85cd8e8c Ivy Villachica-Taylor Ivy Villachica-Taylor ivy.villachica@gmail.com 020918 9 2026-04-30 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2026-04-30 21:54:14 -0.1 hrs 69fb8ca84af72d8eb5fd5829 000044613 2.00 160.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99936 b4b1cd8468fcc3dcb091239a532ec266e117b5eb3c3fd94636c06381219812b7 69d6691433dda43150a661c0 69d6688460d6b846590cb835 Airi Brockbank Airi Brockbank cdbrockbank@gmail.com 021062 4 2026-04-30 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sophia L. Pt having anxiety and canceling all appts for now Eva Tucker 2026-05-01 13:01:18 15.0 hrs 69d6691433dda43150a661bf 000044135 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99935 12ab5d6f0c340bdbe8ae3de1ea8127d020d41d172481e403f3f0c5c81ef08839 69cd792fafb2187d54e99716 68a8153099c65c4a78a5f8e2 Dustin Higgins Dustin Higgins dustin.higgins@gmail.com 018626 8 2026-04-30 No Show 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Haley Paull - Michelle W. 2026-05-01 13:07:54 15.1 hrs 69cd792fafb2187d54e99715 000043421 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99934 bdccc524828f149f0bcd1b8f7300f04ef9834ced6d5431c30017112b78ebf00f 69c6e3ebdf6915dca38e5768 696fd9d7d149a60b7a9bd332 Seth Lentz Seth Lentz lentz.seth99@gmail.com 020590 25 2026-04-30 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt is discharged - sc Sonya C. 2026-04-02 23:00:00 -671.0 hrs 69c6e3ebdf6915dca38e5766 000042913 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99933 3384bcb4a859dc20ac18a0fbeefb2487b55a1874df2c5338964e48c6b6929bb4 69b884713c2464358a2adfb7 67ced4fa7abf9f3ed8fee989 Kate Riddle Kate Riddle riddle_kate@svvsd.org 012351 85 2026-04-30 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. switching to J.P. in Longmont 4/2 - HP Haley Paull 2026-04-02 20:31:39 -673.5 hrs 69b884713c2464358a2adfb2 000041440 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99932 bf3db215628a4c4509d02f9b29a065131f60f3b334d0a75b480bf100156ba467 69a078197a10e5b5bc1f0196 687fc387fc35fe079a7fcc66 Kate Spradling Kate Spradling kate.spradling4@gmail.com 017672 20 2026-04-30 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. She is ill - sc Sonya C. 2026-04-30 16:51:05 -5.1 hrs 69a078197a10e5b5bc1f0195 000039346 0.00 0.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99931 cdea4aff29a61a8e29fb2313ef48ba35834c61e2a79c1fc8f8f9cc9e3acbdfe1 69793fdbaec2421976a1a0c9 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2026-04-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Renee Carr - Haley Paull 2026-04-30 21:59:11 -0.0 hrs 69793fdbaec2421976a1a0c8 000035612 3.00 83.38 76.35 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99930 2e0e212f2061dbe6670e417f3851556e5a02ad2e31a9b7c20a513f5576bd08a1 6924f19fcb19dccbfb24ee6d 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2026-04-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Haley Paull 2026-04-30 21:59:21 -0.0 hrs 6924f19fcb19dccbfb24ee3a 000028413 5.00 390.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02
99929 3bed53b77cf875f3e1d2e6383e4d8adaade3ded85783454aabca4437a43205ae 69e10b9ba223815cdd3232b4 67ced3607abf9f3ed8fe90f0 Maria Fernandez Maria Fernandez orchidz90@aol.com 004793 38 2026-04-30 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Michelle Osgood 2026-04-30 22:59:11 0.7 hrs 69e10b9ba223815cdd3232b3 000045087 3.00 228.00 0.00 - - - - - - - - 2026-04-30 22:31:49 2026-06-11 22:40:02