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
14645 01a54395ed0de26113583a25f2d97dca36f808061bab712d4778985d50b9728f 68b9d2a7fe5f00df0ba7effe 6890cded11a7af0803467727 Judy Hinks Judy Hinks hudy@ptboulder.com 017745 24 2025-10-13 No Show 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-10-13 21:34:36 0.8 hrs 68b9d2a7fe5f00df0ba7effa 000018718 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14644 3753a9d314e52677b2fb382d7506d0cb9bf4dff5ed9c7506a8c55deed09c02f0 68b8a1dc3958ce220ba0ed00 67ced6587abf9f3ed8ff1a62 Tracy Zaik Tracy Zaik tracyzaik@comcast.net 016517 55 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-13 20:47:20 0.0 hrs 68fff213f0962a099fe062e9 000018583 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14643 127dfa8963d49e52e47b872ce8e3b0f1e1cb29424300571b2e35d89089c55568 68e43c054bc6a3ea688cc12c 67ced4fe7abf9f3ed8feea3a Lelia Saunders Lelia Saunders lightascolor@gmail.com 012410 103 2025-10-13 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Sonya C. 2026-04-22 18:43:06 4581.7 hrs 68e43c054bc6a3ea688cc12b 000022447 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14642 4225e739adc1e8116f55e37bbb3f4ca2680f5b2baf6425e68f5298ea3f05b606 68dc4934dac4a84374f1e35e 68dc485c899c2e09550fcec4 Lisa Beshore Lisa Beshore lhbeshore@gmail.com 019961 18 2025-10-13 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Miranda Samson 2025-10-06 21:44:33 -167.3 hrs 68dc4934dac4a84374f1e35a 000021721 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14641 5fb304acc05841854c5f6206d2c234f0508bae52b15b071c73a65edbc78cbe1c 68b7551040f54d21c350ece7 67ced4857abf9f3ed8fed5ce Clark Myers Clark Myers myers.clark712@gmail.com 010668 97 2025-10-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-10-13 20:55:02 -0.1 hrs 68b7551040f54d21c350ecdb 000018399 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14640 dfc1fb775882f22070fc2ebae5981d26a7d447ad1e8308af48dffd1756378e65 688108747a52071948c6dbb6 67ced5857abf9f3ed8fefeaf Deborah Usrey Deborah Usrey dusrey2@msn.com 014155 14 2025-10-13 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. No longer need appt - sc Sonya C. 2025-09-29 21:35:02 -335.4 hrs 688108747a52071948c6dbb1 000013985 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14639 dfb300cc714b5e2f570a2a948393cdd2dc3e7380a25b5ddddb3314675147be94 68b9bfb5027ebb962ba36dd2 67ced38d7abf9f3ed8fe9f00 Julie Heins Julie Heins itnotpa@comcast.net 005993 68 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-10-13 21:15:45 0.0 hrs 68b9bfb5027ebb962ba36dd1 000018681 3.00 63.67 63.67 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14638 5e41c5c2b113f1f1a76330b46322091846730a53b99115daabf114238828b249 68c08e2c64ef093e06242e37 67ced6617abf9f3ed8ff1b76 Emily Zora Emily Zora emilysartgrove@gmail.com 016609 147 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-13 21:27:24 -0.0 hrs 68fbc63470557da9f00467df 000019266 3.00 82.00 73.80 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14637 f4e201eef6b34327fd2a8b3a8f29aad33ba5bae63ed33d19996294d8a77e1e6f 68a3a68870e497b94fda6c6f 67ced53c7abf9f3ed8fef3d9 Lauren Sessions Lauren Sessions sessions.lauren@gmail.com 013231 189 2025-10-13 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia Phillips 2025-09-22 21:17:39 -504.2 hrs 68a3a68870e497b94fda6c6e 000016632 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14636 01e2dcc7b59ce8b50330ffac1153cf479aaf8bc67cc20a5c62bfb97eef755a5e 68b7728d40f54d21c351f3b9 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-22 16:06:25 210.4 hrs 68b7728d40f54d21c351f3ad 000018448 4.00 95.33 95.33 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14635 066c646ee95c4840b55fd6a00bc97d93b2addff8119260aebe73b5de4de49ab7 68796e39cf7d36a70c8b755b 67ced2f77abf9f3ed8fe647b Patricia Carmichael Patricia Carmichael carmichael_patricia@svvsd.org 001000 32 2025-10-13 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 18:21:29 188.6 hrs 68796e39cf7d36a70c8b7556 000013457 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14634 88f5d715187bddc69573f58647bd2a5df6a59e697297f58fe517e0f24148e3d5 68d2b8b4eb1aaa08456dfb04 67ced32d7abf9f3ed8fe7df5 Jennifer Burak Jennifer Burak jenburak20@gmail.com 003174 101 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-21 18:33:14 188.6 hrs 68d2b8b4eb1aaa08456dfb03 000020587 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14633 2e6bf917f1670bbc602a78eea8a78bda84ccaae1f8d04a794b9d274a91c5c937 68c872b4dc0c7e372cc225b0 67ced37e7abf9f3ed8fe9a92 Nathan Hawkins Nathan Hawkins fourhawkins@gmail.com 005615 32 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-13 21:53:12 -0.1 hrs 68c872b4dc0c7e372cc225af 000019814 3.00 83.32 83.32 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14632 7e11d9c1bda69ee5c53b70a13c7cb776e55d35ef115cd6aceeab6d3a7eaf8766 68adf14f2bbd680767efbfc8 67ced3b27abf9f3ed8fea908 Veronica Johnston Veronica Johnston veronica.johnston@bvsd.org 006849 30 2025-10-13 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 10/6 Sophia L. 2025-10-06 20:42:16 -169.3 hrs 68adf14f2bbd680767efbfc5 000017573 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14631 c8f296c895c0ea82ef07418d0b29d59b012d20a801db70d0840e7a20413cade7 68952b75ddd8c20797ae72f3 689529ed1d2a819c6a5e57c6 Brittany Enterkin Brittany Enterkin enterkin@google.com 017769 6 2025-10-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-13 21:54:52 -0.1 hrs 68952b75ddd8c20797ae72f2 000015781 3.00 85.00 76.50 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14630 740d2fc6a103758255e384d91e18441c1df10fbd81f9f6a362abc5d0004e7144 6888eb4f80e08d0885e076e7 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-10-13 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ LS conflict - RAR 9/16 Rosey Reed 2025-09-16 21:43:41 -648.3 hrs 6888eb4f80e08d0885e076e3 000014572 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14629 fcc66d500c253075e3ce847a1d271f2e6358fcd312fc3087edd7594e11ce72d2 68e71b744c231627cb0f5710 68c96968fde2a18396e28210 Erin Johnson Erin Johnson erinhjohnson@gmail.com 019865 9 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Julie Petersen-Hanson - Mark Leo Guevarra 2025-10-22 16:08:07 209.6 hrs 68e71b744c231627cb0f570f 000022870 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14628 58651802b6788eb947a3a98d7ef8c1e8a9549bbe4cb59b46aa1e689110187ee0 68e6ea7776c2ba08a0b0fe7e 68e699563e8aa1fba7877eac Corey Dibianco Corey Dibianco dibiancocorey@gmail.com 020018 12 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-10-21 17:51:31 187.4 hrs 68e6ea7776c2ba08a0b0fe7d 000022864 4.00 82.00 108.80 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14627 4d7b93c58b37b7cb37b85531df7ddb3fef8c28a2ee5ed9b12030e2965592ef32 68c1d6ec9c003b3ecf18f012 68c1d59dbf83f0d7ca3d3603 Eric Schaetzel Eric Schaetzel evschaetzel@gmail.com 019834 11 2025-10-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-10-22 17:17:51 210.8 hrs 68c1d6ec9c003b3ecf18f00a 000019430 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14626 124544537a47d9446bdfd97125471138f148365603d07dc7ef15bbc04a2b25e6 68af33a015bc57af3470da84 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-10-21 18:37:58 188.1 hrs 68af33a015bc57af3470da83 000017789 3.00 75.82 60.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14625 0098632887fdd169db273ff26191602b9044b25ecfb4743e2c3fb6f25557eade 68c43e2f82720e38ba844227 68bb18cc70b80e99f4fd5e62 Marilyn Giglio Marilyn Giglio marilyngiglio1@me.com 019806 10 2025-10-13 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove PT Out Laura Shove 2025-09-16 20:32:43 -650.2 hrs 68c43e2f82720e38ba844226 000019644 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14624 70d2cc79447ade5acd8b19e2416a35704f2dd9411053251558c067df03a75cc5 688920020f95600f74c84f2c 67ced4ce7abf9f3ed8fee253 Andrea Poniers Andrea Poniers andrealeni@earthlink.net 011736 24 2025-10-13 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/12 Sophia L. 2025-09-12 17:14:49 -749.5 hrs 688920020f95600f74c84f28 000014629 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14623 517c7b5e13b1a23b0242b2cac1f69efd1e2419542cc4d35110f2bad1a8f3c96f 68ed8695edde99a4fc043d80 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Mark Leo Guevarra 2025-10-21 17:52:06 186.9 hrs 68ed8695edde99a4fc043d7f 000023272 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14622 2dec16a54d512fb5bfe0771d72e6f9f1d653fd06830fc35d9cde02ec60ab782c 68da911938c0030a2bd8f1dc 68af323a1a47a9255c6d0f67 Lynn Helmstetter Lynn Helmstetter lghelmstetter@gmail.com 019758 33 2025-10-13 No Show 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Emily Pickner 2025-10-14 12:55:31 13.9 hrs 68da911938c0030a2bd8f1db 000021279 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-06-11 23:33:55
14863 40aed2714c44dee33632c278f33ef0c65acea4d615dbd9c176c098030bc34f07 68e42ca06d0e660a096a7793 67ced3847abf9f3ed8fe9c87 Johanna Heart Johanna Heart jandsheart@msn.com 005782 59 2025-10-10 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Samantha Saunders 2025-10-10 13:06:37 0.1 hrs 68e42ca06d0e660a096a7792 000022432 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:04:00 2026-06-11 23:34:24