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
17420 0c1a9b36f725483494085e66d55d2461a80bf7464ce8365d93e5065dc4615df3 68c1fc174be3c44267f5c5e9 67ced38f7abf9f3ed8fe9fa5 Christine French Christine French plumouttaideas@gmail.com 006048 43 2025-09-18 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Sophia L. 2025-09-18 22:08:13 -0.1 hrs 68c1fc174be3c44267f5c5e8 000019471 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:11:48 2026-05-14 23:37:50
17419 38566e630a7c4923244f8995287f02f7bc6b9038d48dbde3396c546ae87e86ec 68bb4de928fbe44856eebe4d 67f8174a7d103608033b63b1 Trisha Sarfaty Trisha Sarfaty sarfaty_trisha@svvsd.org 017031 20 2025-09-18 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-05 20:55:52 -313.3 hrs 68bb4de928fbe44856eebe4c 000018966 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17418 7a53d9cb4a3e2c0807915a51dd8975f019aa5de4d88d7931ac6c8a2cf1437711 68bb2c60a42ed1a54ff17f7c 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-09-18 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-17 17:51:24 691.6 hrs 69b9fe11bd1d12443ff61d00 000018951 4.00 381.00 50.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17417 14c2395aaba28d721cbe3572a1572b6cf513781ddbbf40737b5a76c616e1d63d 687fc82ba895c9080fae5f58 687fc387fc35fe079a7fcc66 Kate Spradling Kate Spradling kate.spradling4@gmail.com 017672 20 2025-09-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-18 22:13:57 -0.0 hrs 687fc82ba895c9080fae5f55 000013844 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17416 e863cd86b07546f7b6c8d2d3a2660fa1f6ac2f6603ad596ff51b2b69d3e4d13a 68b9998f238c0a077edd36a8 68af4369f2725b078f7fdf8c Kai Phinney Kai Phinney kai.phinney08@gmail.com 019761 13 2025-09-18 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ per John, Kai is feeling much better and no longer needs appt - sc Sonya C. 2025-09-16 20:13:33 -50.3 hrs 68b9998f238c0a077edd36a6 000018656 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17415 00342a72b4411aea6d2e2d6361dfdb6d720417918444be4384c0a1a3d5625f26 68b0930e03f9297bdea86610 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-09-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-30 15:00:02 280.5 hrs 68b0930e03f9297bdea8660f 000018041 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17414 597b86e78a79ddbecb7c7fe928606b1da648580bfa222b02fa55be97f489c9ba 68894b650f49f01f911b5098 67ced56d7abf9f3ed8fefb34 Brian Steege Brian Steege bsteege@gmail.com 013858 57 2025-09-18 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/18 Sophia L. 2025-08-18 15:05:12 -751.4 hrs 68894b650f49f01f911b5094 000014723 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17413 727a6e4d392696684277b68faac2c536ffab085933f7a5aff3a8e2d9d909bf9a 68b0d8c16f75d6d61c4aa88c 67ced54b7abf9f3ed8fef625 Jenna Shedd Jenna Shedd jen.e.shedd@gmail.com 013427 29 2025-09-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Mark Leo Guevarra 2025-10-08 15:55:28 473.2 hrs 68b0d8c16f75d6d61c4aa88b 000018128 2.00 85.00 145.94 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17412 2425713339ced8ac0403c5103c08b6826eee73a472e7e0afda312f0aa07711da 688b988801c6150846c3b9c4 6848895be76ec2076829f880 Britt Alstad Britt Alstad alstadb@proton.me 017433 21 2025-09-18 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-09-18 13:09:55 -9.6 hrs 688b988801c6150846c3b9c0 000014939 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17411 2b1bff95755db35f22ff90d27415fd70a08374ba13190d5f74c5534f97bc5c23 685eed90b6969f744f650e38 685eec0ea88649740b79a68f Helen Andrews Helen Andrews alleycat@indra.com 017539 88 2025-09-18 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-09-18 22:47:37 0.0 hrs 69f37951b838e51dbd688c99 000011159 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17410 dbc3863bfaf1eff239b452b99019de7e0fe321a3d6a97f643112ca4d6ec4cd35 68c056038a128a089e522e47 67ced32d7abf9f3ed8fe7df5 Jennifer Burak Jennifer Burak jenburak20@gmail.com 003174 101 2025-09-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-22 15:13:09 808.2 hrs 68c056038a128a089e522e46 000019190 3.00 85.00 115.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17409 b62cd6f454839fe7523abf050d4f3081bcd0afafc3f1406e3b37281fa3ef6286 6893cd5ac1f7c6e6b3edd7b4 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-09-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-18 22:59:09 -0.0 hrs 6893cd5ac1f7c6e6b3edd7b2 000015639 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17408 2df6fd9b4bd19146b9eaa9ed654c5e97c1ad018283c1675089e837b3b9db1dd6 688a588f3b68350808c9cfee 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-09-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - John Reed 2025-09-19 16:25:27 17.4 hrs 688a588f3b68350808c9cfe6 000014794 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:50
17407 63eb77c303390b32fcbbf21cbd885142e8590747237c4ffe6c30b6714a3b6a82 68c31f3a32c6ff08a1ac2db7 68b0c782e0928300d23f55be Dayna Sommer Dayna Sommer daynasommertime@gmail.com 019778 6 2025-09-18 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sara Thompson out sick today Frances Lawrence 2025-09-18 17:22:41 -5.9 hrs 68c31f3a32c6ff08a1ac2db6 000019569 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17406 4012f13d074ac57f261af4f18d0f0b608686317e4709c5fe6674283ea4f6c757 68c1bd15e65b605f63fd2bc8 68472194d172aa9bfb716478 Louise Grauer Louise Grauer louise.a.grauer@gmail.com 017421 11 2025-09-18 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Mark Leo Guevarra 2025-09-30 14:31:57 279.3 hrs 68c1bd15e65b605f63fd2bc7 000019413 3.00 234.00 35.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17405 7e931dcf46844d0b3de9d0a14ca90b48e719fbc0b3ccfc43b85a329ec327e6d3 68b0e5ec6f75d6d61c4ae17c 68a6289e3dd18cf367999e24 Stacie Tureson Stacie Tureson stacietureson5@gmail.com 017857 10 2025-09-18 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence - Frances Lawrence 2025-09-11 03:03:31 -188.2 hrs 68b0e5ec6f75d6d61c4ae17b 000018135 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17404 2bfa02fd7b83be7069afc2c9656490146b33f4bbd26f036abb14337de5bd5bfa 68a78cba461a24a1eb78343e 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-09-18 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove - Michelle W. 2025-09-09 19:59:41 -219.3 hrs 68a78cba461a24a1eb78343d 000017165 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17403 d5d4b3f1316f65f0f0b2ebd0a280814c251be7175f88bfb4f2d11ac0870c9273 68a623e916662a098626b493 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-09-18 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-29 19:44:37 -483.5 hrs 68a623e916662a098626b492 000016968 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17402 ff3a3f840155b3e889d3593b4e2e50cbadeb37b651321ada98c9fffc834a2d61 689b545f1cd63c07b7108a7a 67ced5677abf9f3ed8fefa67 Sara Ruwitch Sara Ruwitch sruwitch@gmail.com 013790 31 2025-09-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-29 16:52:34 257.4 hrs 68e81826c52d4709846eafa8 000015980 3.00 97.08 112.08 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17401 fd46f8741f55641a1d7455e5e33705c7fdd58018e5ee4e8012cc139416b2dc29 686d8ce6aee4b4086fcbb1b1 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-09-18 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-20 13:17:42 -706.2 hrs 686d8ce6aee4b4086fcbb1b0 000012174 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:11:32 2026-05-14 23:37:35
17749 a4d599733e47d81dc56e8299aa71056ef01376c1fb9fe5e533b29ce456faa895 68b76e10219ffa1fde4159a4 6875137f036b57078846c4ce Amber Mault Amber Mault amber.mault@gmail.com 017620 17 2025-09-17 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-17 13:28:15 0.5 hrs 68cd79f3c7a3275460e84b19 000018439 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:12:39 2026-05-14 23:38:37
17748 7ea8282b09630520e21627f52ceb55727f8f115267fb7a62fd55e30902fbc4bb 689f367d6a0ec0080e3e89cc 67ced3117abf9f3ed8fe72dc Evan Christenson Evan Christenson evancolorado@msn.com 002227 56 2025-09-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Samantha Saunders - Samantha Saunders 2025-09-17 13:06:48 0.1 hrs 689f367d6a0ec0080e3e89cb 000016373 3.00 238.00 0.00 - - - - - - - - 2026-02-19 23:12:39 2026-05-14 23:38:37
17747 f2ee9dca4ab7eaf84dedfac8be31aa5d3e841ae1ebf6abe07b658bd62fb53865 68653d9c3881600844161dfb 67e6661befbf2c53d8d5f340 Zaira Nevarez Zaira Nevarez zaira_0102@hotmail.com 016860 33 2025-09-17 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Michelle W. 2025-09-17 13:06:37 0.1 hrs 68653d9c3881600844161dfa 000011553 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:12:39 2026-05-14 23:38:37
17746 b23a93f813af4b4c9dda000ab23cc55e0809a19a6abe0407e5cb623dcfcd28e2 68c82ad55559d7079814f040 67ced34b7abf9f3ed8fe898b Avery Ellis Avery Ellis averyecological@gmail.com 004162 21 2025-09-17 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-29 18:51:08 293.4 hrs 68c82ad55559d7079814f03f 000019738 3.00 0.00 80.00 - - - - - - - - 2026-02-19 23:12:39 2026-05-14 23:38:37
17745 0ceb2c11c503a387dc0bf54edaf8124907223933129c9b56c42cb1bdaa0c83dc 68b851c581d6b507b2c048c3 6888e114dc80142d6a2c2097 TM Frey Morris TM Frey Morris drpiefrey@mac.com 017716 29 2025-09-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Rosey Reed 2025-09-17 15:01:50 1.5 hrs 68f25799acc1200a01f64c06 000018479 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:12:39 2026-05-14 23:38:37