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
16598 a69bf9e69a753a8b24ebe815a64e6a6b931084fea1ac4cf40a9579e59c5fa860 689f624b78e25cfc4eed5498 67f00c9821f4ea11b3a88612 Hope Bartlett Hope Bartlett hope.bartlett05@outlook.com 016990 17 2025-09-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-25 19:48:56 0.1 hrs 689f624b78e25cfc4eed5497 000016415 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16597 593a5258b58e503dc59d25a7dcf311e326c5f46295e7189b98a53533c08c6d6e 688bd0108b03db56e58a7662 67fd4353b995a307d33e336a Anita Vair Anita Vair atvjazz@yahoo.com 017046 31 2025-09-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-09-25 19:28:18 -0.3 hrs 688bd0108b03db56e58a765c 000015055 4.00 310.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16596 6e61a792cfb105df138d436a2d64c1032c2ce049476ca0c0b94bf97325aca767 6822120de3c05b07deaa0914 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-09-25 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Ranjini Ridgway 24+ sc Sonya C. 2025-06-12 18:03:20 -2521.7 hrs 6822120de3c05b07deaa08fc 000005151 6.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16595 0c662850a5f506433a4f0655c854c0bb2bc2b80ca39b46d60d23681ddbe1da64 681bc3ac81e61e07b7b748e4 681bc031b1836d080ad0ba91 Carole Strong Carole Strong strongcwith3@gmail.com 017196 17 2025-09-25 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-12 17:56:29 -1057.8 hrs 681bc3ac81e61e07b7b748d9 000004692 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16594 f07d700c62a1227c70365430cfccaf6a627664e8f9cd73e3e64ee2acd67b8234 68bf390dab141fea3899770b 686d56d85f7dbb089aef31cd Rose Lynch Rose Lynch roselynch@comcast.net 017588 37 2025-09-25 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Emily Pickner - Mark Leo Guevarra 2025-09-26 17:12:46 21.2 hrs 68bf390dab141fea3899770a 000019096 3.00 80.85 70.85 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16593 612a17fda9c80b1bb3ba78f5d6ca187038241483360d50f35dd871ce0c99f12d 68af3b0ded830916f84d292d 67ced2f67abf9f3ed8fe6418 Glen Alleman Glen Alleman glen.alleman@niwotridge.com 000967 24 2025-09-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-09-25 19:53:52 -0.1 hrs 68af3b0ded830916f84d292c 000017810 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16592 526aaa4f39dd00258bc20c41e166b59cbe95e638328c6c8cc256a47daf861abc 68af38bc0ec9c93386f9c3e6 68af3766aeacebaa1f71bdc2 Glen DUPLICATE Alleman Glen DUPLICATE Alleman glenallema@niwotridge.com 019759 4 2025-09-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-08-27 17:05:59 -698.9 hrs 68af38bc0ec9c93386f9c3e5 000017803 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16591 9a01d7447b7c0fe4e9af1e6a8cf1e4f26961c630e4f6a11b74491091894c24b2 68a7697475693af155df5e43 68a62f716bb8b66ef8cf4e6c Ashley Hamm Ashley Hamm ashleyhamm@gmail.com 017866 22 2025-09-25 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Mark Leo Guevarra 2025-10-07 15:53:36 283.9 hrs 68a7697475693af155df5e42 000017123 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16590 2a972552ed90b019524b58ad6aa5e5a6f4c90ab3a916c153b12f58e6916d1039 68a5df95037824ee4a82b30a 67ced3717abf9f3ed8fe967b Sheila Harrington Sheila Harrington harrington.sheila30@gmail.com 005266 123 2025-09-25 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins LVM requesting we cxl appt - sc Sonya C. 2025-09-24 21:26:11 -22.6 hrs 68a5df95037824ee4a82b309 000016844 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16589 67c070b97e587a09e28a8eeb39102b98005a05102f974538b95e3ba832ba891a 6876b792b5983e078842fc84 67ced3737abf9f3ed8fe972c Anne Harris-Cross Anne Harris-Cross aharriscross30@gmail.com 005325 36 2025-09-25 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Mark Leo Guevarra 2025-09-26 15:43:23 19.7 hrs 6876b792b5983e078842fc83 000013062 3.00 160.00 160.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16588 4f568da16e5deaa7574d55543a804e3f0bfe4a6c085cc3ffe01aca60addf7274 686d4c50d3b662084956cb01 67ced47c7abf9f3ed8fed424 Victoria Parks Victoria Parks 23vparks@gmail.com 010526 437 2025-09-25 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-25 19:55:58 -0.1 hrs 686d4c50d3b662084956cb00 000012056 4.00 104.99 104.99 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16587 3e3623c98b86a3b30576b0969d18ae577c980c37370f526a70b497ca93d1e596 685d5f178de70b079e2d1c85 67ced3a77abf9f3ed8fea5e1 Judith Hersh Judith Hersh judyhersh@msn.com 006580 93 2025-09-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Rosey Reed 2025-09-25 19:58:29 -0.0 hrs 685d5f178de70b079e2d1c84 000010883 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16586 118a5295587a5b2e6b992445af37be718b7c84ede1a355b6be8c41f4c566d5f9 68c0a9185a98060931d9cb8c 67ced4627abf9f3ed8fecf4a Michael Lovy Michael Lovy michaelrlovy@gmail.com 010112 37 2025-09-25 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. Pt is stuck at Ortho dr appt - will call to rxl - sc Sonya C. 2025-09-25 17:26:46 -2.8 hrs 68c0a9185a98060931d9cb84 000019311 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16585 4d82e3d809cee538147138717a4dfbb4247803b2940a8834ebfbc7b0ba919903 68b0ce4867110b6a040fea40 685d5aff10240ca9c3528579 Robin Vaughan Robin Vaughan robinlv88@gmail.com 017528 71 2025-09-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-09-25 20:22:07 0.1 hrs 68b0ce4867110b6a040fea3f 000018104 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16584 0f1883d068ce276ebdc031da2710d883ada75765a79eeeae542ca70dbd6af37c 6866d8b1344854823c5e8b6b 67ced2fe7abf9f3ed8fe691c Howard Anderson Howard Anderson anderson7575@comcast.net 001395 122 2025-09-25 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-25 20:06:10 -0.1 hrs 6866d8b1344854823c5e8b66 000011777 2.00 55.92 55.92 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16583 a159f563020d257bcb291ee240ea51a372fd1e9fc0f8fa8754e2fac70f82eebe 68d2bddc8c72b8e028d1b318 67ced30e7abf9f3ed8fe7171 Kenneth Bray Kenneth Bray kibacat@icloud.com 002106 15 2025-09-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-06 22:13:23 265.7 hrs 68d2bddc8c72b8e028d1b317 000020600 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16582 650910d42f230c78f3e034c7ab09d6f9bb0647079d66d3cea43934abe1398db0 68cb0f9a1fa9462a1c02dba3 68cb0ef8c84d7307914f70a2 Bradley Pospeck Bradley Pospeck bpospeck@gmail.com 019884 16 2025-09-25 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-26 17:55:09 21.4 hrs 68cb0f9a1fa9462a1c02dba2 000020055 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16581 a1c37915b61ff94e0a13e77e452a7cd181154c276b2ad08842ee0b9618f61161 68adc465b5336a80a6e50b71 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-09-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-09-25 20:27:22 -0.0 hrs 68d6ec1fbe25ce7067d86912 000017501 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16580 bbf1b35c781ea1c078ce842f97676e04da84a75e6a242b21c3c84957dbf8629f 6887ae95ba3c3e08a28002a5 67ced45b7abf9f3ed8fecdfd Carol Morris Carol Morris morris3445@gmail.com 010001 141 2025-09-25 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ husband just got out of hospital -mw Michelle W. 2025-09-24 13:33:21 -30.9 hrs 6887ae95ba3c3e08a28002a4 000014475 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16579 6aa3fd2d942957a0546792b255dc3c2a58ddfc34550d684a1f22c89a39348c4c 685eee24719ddfa954cf0f77 685eec0ea88649740b79a68f Helen Andrews Helen Andrews alleycat@indra.com 017539 88 2025-09-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-09-25 20:41:58 0.2 hrs 685eee24719ddfa954cf0f76 000011163 3.00 232.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16578 ea35894e7e4e992ea25fe8435082d36bdfc7fbdaf16e9347e64982185b22a393 68b7551040f54d21c350ece2 67ced4857abf9f3ed8fed5ce Clark Myers Clark Myers myers.clark712@gmail.com 010668 97 2025-09-25 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt conf cxl- cut off the tip of his finger and is in the ER SL 9/25 Sophia L. 2025-09-25 19:24:37 -1.3 hrs 68b7551040f54d21c350ecd6 000018394 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16577 95d917362b649ba3c3a85a6d387d57fa866df36204b34d0dbc76f6ad0c8125e1 68b0ac2cf30e00082400e5da 68a6325b8653a1d856b5ecc6 Fen Lin Fen Lin cuiyeng2002@yahoo.com 017869 4 2025-09-25 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-10-07 16:00:50 283.3 hrs 68b0ac2cf30e00082400e5d9 000018067 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16576 fe22d7b192dd6ea8de46a69282d7ac19102af82cc6afd9ef6b700b1ce4980edb 68b0634d3e237c087be54d6b 68b06228db82a82b395da9b7 Renee Knutson Renee Knutson rjk3k@msn.com 019769 5 2025-09-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-10-06 21:55:44 265.2 hrs 68b0634d3e237c087be54d6a 000017933 6.00 80.00 160.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16575 b8f101038722293b1de1bc22333669fbec272c8e12d63c96b5fcca8b75694902 68d19b63fb7a9fd95a93cbec 68bb1405f45d4ebac1e95a47 Joelean Lambrecht Joelean Lambrecht jnjlambrecht@yahoo.com 019805 42 2025-09-25 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Emmie Gebhardt 2025-09-25 20:58:05 -0.0 hrs 68d19b63fb7a9fd95a93cbeb 000020497 3.00 83.74 83.74 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16574 7fa07b17226ebba3e3d927efce4daff4d18584d6686c1b97b80c9ce6d3a2d473 68b223ac1a0f3e07e78b6843 68a738db5ec5b01101fd8ea1 Peter Geiser Peter Geiser petegeiser@gmail.com 017875 35 2025-09-25 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-09-25 22:48:41 1.8 hrs 68b223ac1a0f3e07e78b6842 000018278 4.00 101.77 101.77 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35