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
2673 af72d42683ece7d4fc592124ecf7ba65b1385ec7508fdd32db567706d737499e 69690f57158f2ac0992d2178 68a5f6f868325698c0b4fea1 Keith Roehr Keith Roehr karoehr81@gmail.com 017837 16 2026-01-29 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-02-02 20:34:32 101.3 hrs 69690f57158f2ac0992d2177 000033806 3.00 82.00 72.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2672 49eac0044bef947ec6f8ac2dab3d5cbd14b2af64fadfaa60f46e1fc2bef928ed 6966ac4efd9713779a579867 6966ab069fec46064ef60c45 Shawn Connell Shawn Connell shawn.p.connell@gmail.com 020504 9 2026-01-29 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67ab091753108089752a5 RTM READY 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-05 16:20:49 169.1 hrs 6966ac4efd9713779a579864 000033532 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2671 3ada2baadfef36a778ba61ecf2e97f32df737a1b33ba97f8729b719744ccd5e6 6953f195eec7bf3e815fbb8b 67ced2f47abf9f3ed8fe6265 Mary Crawford Mary Crawford mrmlcrawford@gmail.com 000822 28 2026-01-29 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. pt woke up sick -mw Michelle W. 2026-01-29 13:56:57 -1.3 hrs 6953f195eec7bf3e815fbb8a 000031960 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2670 87de25aa9749cfabe24a507b2e58a360caab20ebab09080e0d3d7ce76d759bb9 6952b81c7f64e5e3da321e65 6952b67cfcef0d4d685a8b5b Julie Devlin Julie Devlin juliedevlindds@yahoo.com 020421 5 2026-01-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-01-30 17:54:52 26.7 hrs 6952b81c7f64e5e3da321e64 000031817 4.00 95.45 95.45 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2669 601ee2cfc1f70006e8564e8c15d622d6f65eed364381b1c4a2b94e66dce4a29b 6942e1ea5c5001f47f145d07 67ced3ce7abf9f3ed8feb05b Tanya Howard Tanya Howard tanyahoward@hotmail.com 007474 16 2026-01-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2026-01-30 16:49:38 25.6 hrs 6942e1ea5c5001f47f145d06 000031049 4.00 95.45 95.45 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2668 c53ab3a47da5f5ebde91599aade8486becc66979ed054a1cdf6c068f722102b8 6930b35485355e8ce19fd6f9 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2026-01-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2026-01-29 15:28:21 0.2 hrs 697cdaaa7fbcdbd26a1a31f0 000029584 4.00 100.00 100.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2667 2b7142a1e9a955fb3aa897cc04e208a3ebda7815abb9ec4c868926c736d3bcaf 6903d91a4d6d839d533bf890 67ced6467abf9f3ed8ff1828 Blake Wollenberg Blake Wollenberg bwollenberg@gmail.com 016327 94 2026-01-29 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2026-01-30 16:35:36 25.3 hrs 6903d91a4d6d839d533bf88d 000025489 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2666 b192ece83739cbd429e7fd0eb2df137d0243952579181b1ed27434c230ce627e 69724930d3a8b769c8748aa3 6939aab5ecda4e31f9aac6a0 John Henri John Henri johnthenry@gmail.com 020361 23 2026-01-29 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2026-01-29 15:53:22 0.4 hrs 69724930d3a8b769c8748aa2 000034816 3.00 104.20 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2665 4909099d4bf5ec726cae1f980bb135cfd9bc70e9af6ce65563276d76aae1c12c 6966ce8ff2c2534d968be132 683db477b8ecd2c9d64de725 Jamie Wolff Jamie Wolff jamie.kay.wolff@gmail.com 017359 14 2026-01-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Anne Majewski - Mark Jerome Para-ase 2026-02-02 17:04:34 97.6 hrs 6966ce8ff2c2534d968be131 000033589 3.00 84.08 95.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2664 a0e0326791e07b250fd2fa4eb5103995c2017cfe537817f25a8175b6905c3dba 6952a43cad4617f34e9dff7c 67ced33a7abf9f3ed8fe8347 Carol Batrus Carol Batrus carolbatrus@gmail.com 003628 105 2026-01-29 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Renee Carr 24+ cxl per pt request Michelle W. 2026-01-07 16:39:27 -526.8 hrs 6952a43cad4617f34e9dff7b 000031788 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2663 74ac54f6b0c90ec8b8c66b93acbc5ef79b67b4b5bdedb06e3a0b0875065a9998 68d574cd02ad2861335c5b07 67ced3817abf9f3ed8fe9b76 Janet Meehl Fox Janet Meehl Fox jbfox09@gmail.com 005691 30 2026-01-29 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2026-01-30 17:56:07 26.4 hrs 68d574cd02ad2861335c5b06 000021020 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2662 e086b134b0325bf13b10ec136f9aee1ed386fc1508511942e8228ba978717de7 696557280b7a59c340b95cf6 6965566ca4cb1ba4b7c51207 Jamie Louth Jamie Louth jlouth5@gmail.com 020496 13 2026-01-29 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-02-02 20:44:19 101.0 hrs 696557280b7a59c340b95cf5 000033367 4.00 95.35 95.35 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2661 a6700ac13a239e5f0ec574c3da91be910a431f951095f32f02bb684837b8ea3e 695ee49a3a1d4675d397d6de 67ced49c7abf9f3ed8fed9b5 Laura Mehringer Laura Mehringer lrmehringer@gmail.com 011001 24 2026-01-29 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Mark Jerome Para-ase 2026-02-04 20:00:35 148.3 hrs 695ee49a3a1d4675d397d6dd 000032991 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2660 d542145393fb55d8a276a929034ffa0eeac75e1760aa28d013cea4983b5af99d 695407f3d247da45ba57fa03 69401ffd7971f292744976fc Sheila Gracey Sheila Gracey sheilagracey@gmail.com 020376 26 2026-01-29 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Sophia L. - Sophia L. 2026-01-29 15:39:53 -0.1 hrs 695407f3d247da45ba57fa02 000032000 5.00 109.41 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2659 f7e9541fe5a4ec75386b5698e8571485763079cd8e4cedb3f3b2a169f6008ddd 6953f7028024201f7e4752e1 67e1258c54aaaa3a80096ca8 Michael Keilly Michael Keilly mkeilly@gmail.com 016768 36 2026-01-29 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ LVM to cancel this appointment. -RC Renee Carr 2026-01-06 21:00:07 -546.7 hrs 6953f7028024201f7e4752e0 000031982 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2658 9e0b2980350fe9395e3a9d5e1da68662d10fdea59b02f1aecbfb41f9182bddfc 6939c5d49992ebbbaf44e844 67ced5ad7abf9f3ed8ff0447 Ryan Stong Ryan Stong rvanstong@gmail.com 014632 51 2026-01-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2026-01-29 15:44:29 -0.0 hrs 698609f7c1ed5b52ba3a4a1e 000030369 4.00 72.14 72.14 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2657 54be70a88e1f30588e891d8ccd64a672346d245bdb8b94b052fe3d1b98135eae 6900ec32789b0904ef7b048d 68bb0f15110c67ad4e1a523d Carden White Carden White raphune.hill.vi57@gmail.com 019804 13 2026-01-29 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. clinic cxl - multiple no shows. SL 12/29 Sophia L. 2025-12-29 21:15:44 -738.5 hrs 6900ec32789b0904ef7b048c 000025024 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2656 5dfb2e6dcb3e1b11d0f990acc5ab862f36d4a4b21fda8f0306d426e54053b711 68e967211c977309947fe769 67ced5bd7abf9f3ed8ff0679 Robert Verfurth Robert Verfurth robertverfurth@gmail.com 014819 59 2026-01-29 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. leaving town Anne Majewski 2026-01-13 16:19:35 -383.4 hrs 68e967211c977309947fe765 000023116 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2655 2395dd911ec1e6deb910c0e0e5f0cbdd4fdb96015df93cc57377d198dd4100a4 69668e58a1a5b70efaee4ba8 68a4d1cbb7a2ac08140d2bce Chelsea Hackett Chelsea Hackett chelsea.hackett@gmail.com 017825 16 2026-01-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Anne Majewski - Mark Jerome Para-ase 2026-02-12 16:18:02 336.3 hrs 69668e58a1a5b70efaee4ba7 000033504 4.00 121.98 117.77 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2654 c97c4b90d02506c75941ed6e5c5d6beb05177ce703eee3bedd94b665b6a37b78 695d339591db33ce7f46c26d 695c223d440a1f0153ad93fb Peggy Fay Peggy Fay pfay5775@hotmail.com 020452 18 2026-01-29 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Michelle W. - Mark Jerome Para-ase 2026-01-30 18:22:59 26.4 hrs 69d432f3f5e58b032d61b21c 000032622 4.00 312.00 40.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2653 294af6949634f7a4d65f7f23604ede4bcd7e6e1505731ae8584ea1c771846fbf 695c05196820f8cc97504f0c 68cc5d362b0d092abe0e26c9 Larry Strear Larry Strear bisonlarry@gmail.com 019892 49 2026-01-29 Checked Out 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-01-29 15:58:09 -0.0 hrs 698215dedc0962525fa0c475 000032467 3.00 148.01 148.01 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2652 724aba2c1fcb8908e198825035944edc970327983777b320dc34a37f9167a6fa 6940234c1fda59098dfb1dda 68e554179957ee09f0cc7118 Kristen Brohm Kristen Brohm kristenbrohm@gmail.com 020005 35 2026-01-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2026-01-30 16:47:22 24.8 hrs 6940234c1fda59098dfb1dd9 000030709 3.00 85.00 17.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2651 aafeaa1c0457f32b46b453b60cbee4f97fd8eb8d073580e1d2e54ebd3cdc3992 6939aab3ef757510fb5fc932 6939a7dedc0609d0272c186c Reshawn Martinez Reshawn Martinez rae.martinez241@icloud.com 020360 32 2026-01-29 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-03 20:28:07 124.5 hrs 6939aab3ef757510fb5fc92e 000030327 4.00 95.55 95.55 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2650 2c0641c745e375f1b982c79ce2de0fafa71e45ddd4cd8ac63d482e5f3a55ff59 69388dfb3160501669178289 67ced5167abf9f3ed8feee2d Alan Schoenfeld Alan Schoenfeld alan0524@gmail.com 012747 21 2026-01-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2026-01-30 17:29:59 25.5 hrs 69388dfb3160501669178288 000030191 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28
2649 97cbc55fc9bbbad7500285092025b8bf89009fb750d1a81693aed1bc342fe925 6930885513ce455b2684667c 693087a91204618aaa041d01 Ellen Strait Ellen Strait xlandellie@yahoo.com 020324 18 2026-01-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Mark Jerome Para-ase 2026-01-30 16:15:00 24.3 hrs 6930885513ce455b2684667b 000029543 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:31:33 2026-06-11 23:04:28