General Visit (PT Boulder API)

Total rows: 100,227
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
7019 5ae068717477b8ca1bd74fe83dea361b7e5fa72ea23b0da88a17f366ef0f7ff3 68dee81846c928549710d43f 67ced5177abf9f3ed8feee3c Stephen Roman Stephen Roman sa3roman@gmail.com 012752 48 2025-12-18 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-12-22 21:01:17 100.3 hrs 68dee81846c928549710d43e 000022100 5.00 -249.66 95.34 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7018 f9c5eca4c012a145d4340bacb3f4a99f1fece404d3cf0206c05a48992cdaa0ee 690cf7b561ddd8de320f47e6 690cf6f6d6030db8bbcd86d6 Kevin Herman Kevin Herman kevin.herman@gmail.com 020217 7 2025-12-18 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-12-18 17:01:44 0.0 hrs 6983ce551bc36a9dbabbf2d2 000026309 3.00 85.00 35.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7017 555aba9faf654d72a6c21714cc6a4c84b0decb9e76557c3c13bcc96c41282cad 690bb44baf1e368eafbacbcc 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-12-18 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ going out of town for the holidays -RC Renee Carr 2025-12-17 16:09:01 -24.8 hrs 690bb44baf1e368eafbacbcb 000026177 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7016 5d016d0d56d5b68381d344d2f3edd7986cc692f81224d22ba1f27582aad5135f 68c2e298fd23ee70e4ca2f2c 67ced35a7abf9f3ed8fe8eb9 Kamala Ghimire Kamala Ghimire kamalaghimire96@gmail.com 004604 137 2025-12-18 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-12-22 20:38:59 99.6 hrs 68c2e298fd23ee70e4ca2f23 000019500 2.00 80.00 80.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7015 118900b0fc7ee29e4d4f05ba08eaf5d88cee57098f075cb8c21dcb35a482738d 694057acba5de121257d0702 68c1999da635790853f11a23 Elizabeth Cleveland Elizabeth Cleveland elizcleve@gmail.com 019829 38 2025-12-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sophia L. 2025-12-18 17:17:53 0.0 hrs 694057acba5de121257d0701 000030785 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7014 3ab5819a5a05d067205a7097462d70efce9843c356664fd258cdc3cf2b36a06f 69248e598bf1ac6b2d4783db 67ced3bf7abf9f3ed8feac83 Cheryl Hogan Cheryl Hogan cherylahogan459@gmail.com 007146 182 2025-12-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-12-18 17:08:06 -0.1 hrs 69248e598bf1ac6b2d4783d9 000028182 2.00 49.88 39.74 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7013 41e3587efe5cf69f1cc8021d9233b6b5ea7a1f06f7987a8ca33a6fb356611427 691f4e324982dd5db991cffb 68ae092d30ddf028d3f10a68 Jan Steury Jan Steury jan@lpcnextlight.com 019746 14 2025-12-18 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-12-22 21:45:47 100.5 hrs 691f4e324982dd5db991cffa 000027904 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7012 aabaa13c6287213e44ae35bf9e230eb6b7ddd9c4a2ffa4306cc9f19a82ebb779 690a323f3cfcbaffaaf6f7c5 68c1999da635790853f11a23 Elizabeth Cleveland Elizabeth Cleveland elizcleve@gmail.com 019829 38 2025-12-18 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 12/15 Sophia L. 2025-12-15 18:11:01 -71.1 hrs 690a323f3cfcbaffaaf6f7c4 000025901 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7011 b218924135d1fca80faf6152c603a8a4d8da644865e2d7eaecfe80f98498f9bb 68ee83613737d109f705cff5 68a8152599c65c4a78a5f6b1 Mary Griffin Mary Griffin marymgriffin@comcast.net 018517 38 2025-12-18 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Primary - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-12-18 18:32:15 1.3 hrs 68ee83613737d109f705cff4 000023357 3.00 0.00 16.55 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7010 a6bef85a0a39e990efc22a4b4ee209a2d23f31b9ac7b113dc0580900aead5d9c 68e9431ec379ef09c1aaa490 68e942848b35a5064b6e9435 Louise Chawla Louise Chawla louise.chawla@colorado.edu 020045 13 2025-12-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-12-22 18:52:10 97.6 hrs 68e9431ec379ef09c1aaa48f 000023066 3.00 81.53 81.40 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7009 ade022747a4d5e43201cee6a732ab9027133b8bc3dfb7afad453d600ef55ba30 67e67138ceb9f104f028ad1b 67ced2ea7abf9f3ed8fe5b8a Andrew Bernstein Andrew Bernstein bernstein.andrew@gmail.com 000237 57 2025-12-18 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Dawn Singleton - Mark Leo Guevarra 2026-01-12 17:09:31 599.9 hrs 69863a71a23f2eeed5d25877 000151557 3.00 235.00 30.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7008 6c35ed4a2925afd9b3e4add8ffe8fcf37b08281660553105ef0b57f6e80cbabf 693c7f4a868b3a1f15699e4d 6913a982ac1f232ff731a1d7 Elizabeth Relin Elizabeth Relin lzrelin@owl.com 020233 20 2025-12-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Michelle W. 2025-12-18 17:45:29 0.3 hrs 693c7f4a868b3a1f15699e4c 000030666 2.00 57.06 57.06 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7007 c2612431a3b6eed5a7d76d0d096d24883ccac2d7472c7348704054b2dda1ca7d 6938a0826189e7eadef33674 68ed36642a8f7709bbb201e7 Sue Falls Sue Falls sllafs@live.com 020055 8 2025-12-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Marguerite Barth - Michelle W. 2026-02-09 20:05:03 1274.6 hrs 6938a0826189e7eadef33673 000030213 2.00 55.92 55.92 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7006 fb2ee3858ace61e865fe1a1f7297549fc3968b8810ec14170ab505228b9b84ee 693740640d408d48868e3446 68cb0ef8c84d7307914f70a2 Bradley Pospeck Bradley Pospeck bpospeck@gmail.com 019884 11 2025-12-18 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2026-01-12 16:17:41 598.8 hrs 693740640d408d48868e3445 000029997 2.00 82.00 81.70 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7005 91c24ebc7da27bbca95666fbe2f5fd97edb7a94ef36f79cc60b436b5c073e7dc 69092810dfef66eca17182e2 68a814f099c65c4a78a5ebce Nancy Babcock Nancy Babcock bab006156@yahoo.com 017976 40 2025-12-18 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sophia L. delete duplicate SL 11/3 Sophia L. 2025-11-03 22:11:56 -1075.3 hrs 69092810dfef66eca17182d7 000025811 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7004 0276cf44e1ecc99ffe74de550e068754a58eef217325daa5808d8d0c36fa1ed7 6909280efa0e16d5ea26fa06 68a814f099c65c4a78a5ebce Nancy Babcock Nancy Babcock bab006156@yahoo.com 017976 40 2025-12-18 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a90213226f6552a9bea KAISER FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sophia L. - Abyssel Gobris 2026-01-07 22:40:51 485.2 hrs 6909280efa0e16d5ea26f9fb 000025800 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7003 07589a9c42c5dc58f5f445b5dc329f4e13afe07c271822f5e0f384fc34029a51 68efd25792feca09ef2e12fd 6851a78603dd08c79cf7942c Alexandra King Alexandra King alexandrawaterman@gmail.com 017463 37 2025-12-18 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Primary - - Yes Sophia L. - Sonya C. 2025-12-18 17:29:20 -0.0 hrs 697a2f15dbf9a265942b9b0c 000023590 4.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7002 fa67cc37382f73f816e6b262b6accf1574e9556e9bec44ce8b31b18bf86d036c 68efbeacb4ee1e08836ee801 680921d215096f08a29be2ba Emily Masi Emily Masi emasi88@gmail.com 017114 31 2025-12-18 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ feeling great, don't need appt - RAR 12/4 Rosey Reed 2025-12-04 22:12:01 -331.3 hrs 68efbeacb4ee1e08836ee800 000023534 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7001 6a5da25f433bb64a92b3b6c6f437cc39ef1feed0e50b8a29b9f82bac04f22b51 689e17f8f68fc3089c11ff9d 67ced4637abf9f3ed8fecf89 Robert Owen Robert Owen robertbarryowen@icloud.com 010133 87 2025-12-18 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Paid - Primary - - Yes Sonya C. - Sophia L. 2025-12-18 17:43:17 0.2 hrs 689e17f8f68fc3089c11ff95 000016315 2.00 -100.20 45.25 - - - - - - - - 2026-02-19 22:42:30 2026-05-02 23:07:55
7000 b6787faddb69ec06433f615c32e8eb7902d87d5bd2238b8e8833aa03e9fae7a7 6925eee9bf962d7224ea0f1a 68d4ae7b8bf10c6d835d936c Amy Puls Amy Puls amylpuls@gmail.com 019929 42 2025-12-18 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Eva Tucker 2025-12-18 18:29:21 0.7 hrs 6925eee9bf962d7224ea0f19 000028564 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55
6999 7a1bf620c6de24b35d216e6249d4811516dd445cf7ed5066e095f99d233362c2 6920a3176e0c5c0784a35e36 69023d886142191bcc6de946 Robin Reese Robin Reese enoufstuf@gmail.com 020169 17 2025-12-18 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sophia L. 2025-12-18 17:42:42 -0.0 hrs 6920a3176e0c5c0784a35e35 000028044 2.00 54.29 54.29 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55
6998 9814bfd1009a3d7848c615b716a9e084b66b27ab55e0d7455b1c79d39cd02e5d 68f28403c15856b584d4c98d 68f28386406551e1679bfb35 Mackenzie Caldwell Mackenzie Caldwell mackenziec0108@gmail.com 020098 25 2025-12-18 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. sophia is out sick -mw Michelle W. 2025-12-18 15:27:55 -2.3 hrs 68f28403c15856b584d4c989 000023906 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55
6997 fdab4074559f7b3180e2080ef0d1b65b218d2a2f1791f74fdffb577c0dac1670 6941e494a6ed66737882f109 691f697da6990abd7016dcf4 Natalie Shaeffer Natalie Shaeffer natalie_shaeffer@icloud.com 020280 9 2025-12-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Renee Carr - Mark Leo Guevarra 2026-01-12 20:55:39 602.9 hrs 6941e494a6ed66737882f108 000031001 4.00 85.00 0.00 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55
6996 382089a358127ce7d34cfd71ca4c6ef58891e1d02ae63ab2e53e9e4403565fa6 69150a3b500c61da3b384db9 67ced5457abf9f3ed8fef541 Cynthia Ruggero Cynthia Ruggero cynthiaruggero@gmail.com 013351 76 2025-12-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-12-18 18:13:56 0.2 hrs 69150a3b500c61da3b384db8 000027034 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55
6995 687426800a025ef013aa8614568394c1053786a21c8fed1073aa6b342cedc179 6913b9d301d892d9ce7aa336 6913b8efd64433ccf6516654 Gayl Gamble Gayl Gamble gaylgamble1246@gmail.com 020234 6 2025-12-18 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Has developed Bell's Palsy and is unable to drive to her appointment. -RC Renee Carr 2025-12-17 20:52:48 -21.1 hrs 6913b9d301d892d9ce7aa335 000026874 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:42:16 2026-05-02 23:07:55