General Visit (PT Boulder API)

Total rows: 101,008
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
14650 444572e26934e3a798a3b2baaa45fccca2cdcc594e0187c10221afd8ee35c35e 68cae0dc56bd091ec7697add 681a708f5288e5729fbcf929 Cambria Klinger Cambria Klinger pyronymph@gmail.com 017187 17 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Primary - - Yes Sophia L. - Michelle Osgood 2025-10-13 21:06:01 0.6 hrs 68cae0dc56bd091ec7697adc 000020020 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-08 23:28:04
14649 63ac544a34fd62ab19085ee51e13d5de4affe5257dcdd820060a233d19d4f7ce 68c9b500afc8d122902862a2 68bf03dfde8c04a3661d1586 Madelyn Hernandez Madelyn Hernandez madelyndiana.4@gmail.com 019817 5 2025-10-13 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed - Sonya C. 2025-09-25 20:48:39 -431.7 hrs 68c9b500afc8d122902862a1 000019915 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-08 23:28:04
14648 eee678da77a0e166ec3685d28c40153077f20d9425825ddad062821beaa18968 68bb28049397f98692b4c6f3 689df1c5d4bed0085e0d7339 Kenton Younkin Kenton Younkin kent.younkin@gmail.com 017796 7 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-10-22 16:05:24 211.6 hrs 68bb28049397f98692b4c6f2 000018941 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-08 23:28:04
14647 085658665da6eb0c50e0082424068e8a68188e303d52b6a8f96f36fe48af6a34 6894e6a9ae3e2a08951a5442 67ced5197abf9f3ed8feeea2 Joe Romig Joe Romig jromig@ponderosa-assoc.com 012786 15 2025-10-13 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. LS OOT - RAR 9/26 Rosey Reed 2025-09-26 19:50:47 -408.7 hrs 6894e6a9ae3e2a08951a5441 000015725 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-08 23:28:04
14646 cb2a3d6a6869dfc28a044c0844153992f4bb28e7613c849b749f21fae01b2d65 68c880f67459679ef1935734 68c8801510ce867bf21bf761 Craig Glover Craig Glover crgglover@gmail.com 019860 5 2025-10-13 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 16:17:44 187.5 hrs 68c880f67459679ef1935733 000019826 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
14636 01e2dcc7b59ce8b50330ffac1153cf479aaf8bc67cc20a5c62bfb97eef755a5e 68b7728d40f54d21c351f3b9 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 117 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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04
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-05-08 23:28:04