General Visit (PT Boulder API)

Total rows: 101,693
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
17545 b1eb0a1f17dcafab9480cba0108a68f5cc349fe41831933a0253613940da6549 687e93dff244b1f8fbceb337 68753655f040d77fff4e8a0b Genevieve Braus Genevieve Braus gen.braus@gmail.com 017624 22 2025-09-18 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24 pt sick - RAR 9/17 Rosey Reed 2025-09-17 16:19:44 -22.9 hrs 687e93dff244b1f8fbceb336 000013688 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17544 404b8628da820c834843075a16cbda5aff87d51252c7adde8b24ba7165c9ac89 68767fd79836d408bb50ca1f 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-09-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-09-30 14:37:09 287.4 hrs 68767fd79836d408bb50ca1e 000012974 5.00 95.95 100.95 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17543 481db8cc16229490e29a957548e1d4af65ec32c74fac11c3aefeee3f10ee477b 68b083c5a5980479f742ad5e 68a8156699c65c4a78a6037b Nellie M Parnell Nellie M Parnell robtandnell@comcast.net 019149 51 2025-09-18 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-09-19 02:42:31 11.2 hrs 68b083c5a5980479f742ad5d 000017990 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17542 5902eb58721212c18fc16b1b2a8d3d0b8086429d4494880f7c2cca831ffd982c 689e25dcf53da207ce3d2486 67ced3487abf9f3ed8fe889d Megan Edwards Megan Edwards itsmeganedwards@gmail.com 004083 26 2025-09-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-29 20:45:07 269.3 hrs 689e25dcf53da207ce3d2482 000016336 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17541 a06d855774c284ab88ec12d31656d2fba56a0b9e1b1d95ed200c9688dab98e6b 689de4ac345ce71239a416b6 6839cb223c9b599869715ba7 Steven Dawson Steven Dawson steven.m.dawson49@gmail.com 017344 11 2025-09-18 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Emily Pickner - Sonya C. 2025-09-18 15:56:06 0.4 hrs 689de4ac345ce71239a416b5 000016238 3.00 84.18 84.18 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17540 4a30ea46d53a1f6af0546e146ce7add62a4892d5de26df6c44081cc00ff2a78d 689b5824ea0975d40b331bff 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-09-18 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-29 16:55:59 265.4 hrs 689b5824ea0975d40b331bfe 000015987 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17539 a02b241b2e21a7b1c27c4ebbb69b1439051412663e6455a74daaf5b4d0a45035 688ce9628622a89a23fd6048 688cd1f121922c08310374f4 Rickey Nobori Rickey Nobori rickeynobori@gmail.com 017737 16 2025-09-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-18 15:53:11 0.4 hrs 688ce9628622a89a23fd603d 000015118 4.00 115.34 115.34 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17538 b5db7c2bcab07f1ee7910120a51cb3ba5bd5c5e37caeedb9f35e8408bc3a07a1 6879490e65c6a256c63cd338 67ced3de7abf9f3ed8feb3fd Mallory Hutton Mallory Hutton mallory.hutton3@gmail.com 007784 56 2025-09-18 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Anne Palma 2025-09-19 18:15:43 26.8 hrs 6879490e65c6a256c63cd337 000013405 3.00 -78.00 120.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17537 b25c436f40f92802b3e92729309cdd87722109c64fb737d83ca7b98e9e85fe0a 67e6719cceb9f104f028c7cc 67ced3617abf9f3ed8fe9141 Gregory Glass Gregory Glass glass.greg@gmail.com 004820 11 2025-09-18 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Dawn Singleton - Sophia L. 2025-09-18 15:24:39 -0.1 hrs 67e6719cceb9f104f028c7cb 000151711 3.00 85.00 72.25 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17536 b6f9f07d571b28526604106a3d444db6f53e8728fbbd598bec2405a607bdcbd6 68c056e93541f208a5d92859 68bb1405f45d4ebac1e95a47 Joelean Lambrecht Joelean Lambrecht jnjlambrecht@yahoo.com 019805 42 2025-09-18 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Amie Russell 2025-09-18 15:40:43 -0.1 hrs 68c056e93541f208a5d92858 000019193 3.00 80.77 80.77 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17535 9a88676d859b9c2ad4a228f2d299aca98332c631532f1782680caf6c1e08e4db 6851a8eefebf870839f84770 6851a78603dd08c79cf7942c Alexandra King Alexandra King alexandrawaterman@gmail.com 017463 37 2025-09-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-16 17:00:33 673.3 hrs 6851a8eefebf870839f8476b 000009631 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17534 ab10e65c96a0758f54dd0ddaada75f82991f2a2ea8a99c2b08fb9d90e130aa9b 68cc229a2f8e8e088b7d8fc6 67ced35a7abf9f3ed8fe8eb9 Kamala Ghimire Kamala Ghimire kamalaghimire96@gmail.com 004604 137 2025-09-18 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-29 16:58:24 265.0 hrs 68cc229a2f8e8e088b7d8fc5 000020113 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17533 7a7a728d71265c8e4d5032ae34b2fa76b527355e3da053f7e86edc27fa52c2dd 68c8797023a386e1614ab214 68c87966ca5d6f84b32a08f6 Wahkuna Vega Wahkuna Vega wahkuna@wahkuna.com 019859 1 2025-09-18 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. John out sick - she has no FUs scheduled - sc Sonya C. 2025-09-18 18:02:41 2.0 hrs 68c8797023a386e1614ab213 000019816 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17532 a39ee27ce22757a22f3a4deae5ff7df009d5a2095352ff72e0dee9e1024f1041 689f87b09e365d6ea0cfa1e9 689f865f86088c9243dfeae8 Hollie Hardman Hollie Hardman holliehardman@gmail.com 017808 26 2025-09-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-06 18:55:53 1178.9 hrs 689f87b09e365d6ea0cfa1e7 000016469 3.00 81.81 81.81 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17531 4884e9079cf601be4a48e4a65ed3178bb6968d6953fc611b0ac76957f0d0a922 688ba9f05a743e084d2dffb4 685c3896f0873207fda55cbe Crystine Margolis Crystine Margolis margolismom@aol.com 017524 17 2025-09-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. cx w patient in clinic Samantha Saunders 2025-09-11 16:45:18 -167.2 hrs 688ba9f05a743e084d2dffb2 000014967 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17530 0e2630b23cf662baa16d147e3e8b4f81b41322b7d1bb7dc0c56b2ce26d3506b2 6865648abc63f807692f20a6 68656363018f70088cac4a88 JoAnn Wiley JoAnn Wiley peter_wiley@comcast.net 017563 6 2025-09-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-18 15:50:36 -0.2 hrs 6865648abc63f807692f20a5 000011608 4.00 101.70 101.70 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17529 3406b8eb21587ef4a2385d351f4d3715759384d070e5cc2a098024f3f9466a3e 68c0a7ec6c6fa1898d18a4f5 67ced4627abf9f3ed8fecf4a Michael Lovy Michael Lovy michaelrlovy@gmail.com 010112 37 2025-09-18 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Sara Thompson 2025-09-18 16:16:57 0.0 hrs 68c0a7ec6c6fa1898d18a4f4 000019301 3.00 77.82 77.82 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17528 1114be8aac10c7db7cee548a6d85232968d0a9d5844baac2b8bfa5db4c4281bf 68b9ec5f119c6c0880bcbe61 6841f90cc2a3f71e348b0ffb Juletta Frank Juletta Frank julettafrank@gmail.com 017402 9 2025-09-18 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Emily Pickner - Sonya C. 2025-09-18 16:15:34 0.0 hrs 68b9ec5f119c6c0880bcbe60 000018757 4.00 308.00 15.77 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17527 306bc01cd2e80a0f6c9d109a60bd6a40d893017f475aecc1061180b9bc78450a 68b70c863949f5c1068bdc8b 67ced36a7abf9f3ed8fe9426 Susan Fischer Susan Fischer suzefisch@gmail.com 005067 4 2025-09-18 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Jayvee Totanes 2025-10-22 20:30:55 820.3 hrs 68b70c863949f5c1068bdc8a 000018297 2.00 68.65 68.65 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17526 b2ffb2622a9df52a03ac92a920ffb2a5f9fc8f727273aa31f0b945ad43b95a74 68b1d6b1426c5a086c828e3e 68a8152599c65c4a78a5f6b1 Mary Griffin Mary Griffin marymgriffin@comcast.net 018517 38 2025-09-18 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-09-19 02:42:39 10.5 hrs 68b1d6b1426c5a086c828e3d 000018175 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17525 7ccb7680d44e548196818abab3ab16f0e2b33ac2ce8fa7d48ad14c7c74efa59d 6848653164b10172abd64958 67ced4557abf9f3ed8feccd0 Roberta Osborn Roberta Osborn osenbaugh@hotmail.com 009901 37 2025-09-18 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-14 15:20:36 1367.1 hrs 68ed0a9628e92d569fde7057 000008869 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17524 e9b1a7ae039f1bd085444f29aa61bf30d8b14610e0be13cf5bbfe50b101a13a0 67e6719bceb9f104f028c7ae 67ced5147abf9f3ed8feedc1 Rachel Schneider Rachel Schneider rachel.k.schneider0@gmail.com 012711 13 2025-09-18 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton Too far to go to Lafayette w/ her job - sc Sonya C. 2025-09-02 15:03:02 -385.2 hrs 67e6719bceb9f104f028c7ad 000151710 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17523 144d609988befac98bbfcd7f4aab26c1f97c56094a49236db32eb42d1921e363 68c1dd574be3c44267f4e849 68c1dc28339acc472f869398 Christopher Duhon Christopher Duhon cbduhon@gmail.com 019835 19 2025-09-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-13 15:59:17 1343.5 hrs 68c1dd574be3c44267f4e848 000019440 2.00 77.00 97.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17522 7613e56e6b92cb1d8573baccd63597af575e8d3ea66bd51e6350830148861fb8 68bb043e9d5364f1eaf2da0e 68388ff20c8650b262bb624b Jenifer Fischer Jenifer Fischer miamiu1981@aol.com 017339 22 2025-09-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Jayvee Totanes 2025-10-22 21:00:36 820.5 hrs 68bb043e9d5364f1eaf2da0d 000018882 2.00 85.00 153.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06
17521 9abeddaa2cdf8105ac3bbf2057057e6b90ce4aee611d6e2517de3588f55724f0 68a4c1abb7a2ac08140c9f3d 687e5f366a5c8908779e8d59 Eileen Koch Eileen Koch es.koch@comcast.net 017659 14 2025-09-18 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 9/9 Sophia L. 2025-09-09 17:41:06 -214.8 hrs 68a4c1abb7a2ac08140c9f3c 000016737 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:05 2026-05-14 23:38:06