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
10187 07156cc9713cebd0f2cf194b6a126291c32e53a5f76c9e27d763d52bce6d6c9d 68f1691a97762f457e59fce3 67ced5877abf9f3ed8fefefd Robert Sinton Robert Sinton bsinton@mac.com 014181 37 2025-11-19 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-19 21:36:41 4.9 hrs 68f1691a97762f457e59fce2 000023837 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10186 1e7cc384125d48a36bd57bb34dcee2317f4e8d7e8243783f826f644d3f7b11e9 690d1682d987e9909559a632 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-11-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-19 16:51:32 -0.1 hrs 6920ed8986985fcb871db4ac 000026336 4.00 100.00 100.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10185 7ccfcefffd9ed659e63f3c2d90b695bd83c8b5ecfc8dc003981a735d34ffcd88 68fa85209efb790a07b62d0d 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-11-19 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ stated that she needs to go back to surgeon- sc Sonya C. 2025-11-03 21:05:40 -379.9 hrs 68fa85209efb790a07b62d08 000024583 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10184 d2d49178e32494e42f0d389522b66f2d1c71b1b0e687f9ac8e3d8eb55f885c1f 68f66f49034fe7acc450ef10 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Rosey Reed - Jayson Encarnacion 2025-11-24 19:09:31 122.2 hrs 68f66f49034fe7acc450ef0f 000024010 3.00 238.00 10.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10183 769a144d27e554ed1e6366a7c7689cdf8613a80ac3cf9fde6baf2d5d23be4af8 68f12dacc7ae4bfbd7964231 68c85e7310ce867bf21a954a Nancy McNeill Nancy McNeill nancymcneill@mac.com 019855 41 2025-11-19 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-24 19:25:18 122.4 hrs 68f12dacc7ae4bfbd7964230 000023770 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10182 d518ed387bb79553773c5d66712c97ac1efa491cad87cf7d3621ca49a92236fe 68dd60bc4a7b4d7108443697 67ced6627abf9f3ed8ff1baf William Zuromski William Zuromski bjzuromski@yahoo.com 016628 37 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 18:47:29 49.8 hrs 68dd60bc4a7b4d7108443693 000021853 3.00 82.00 16.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10181 6f9aa1e9067000fce8db76a487cff7c7a2a822db5991cc286b7b840477a321bf 689cc2fec55113080d93c310 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-19 17:09:45 0.2 hrs 689cc2fec55113080d93c30d 000016170 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10180 f13e85bf13a4fb912be08c41f86d28265474e037143b016c917d77e360532d8d 69024490490c1c0997bafd1d 68c9bf5f0a0dc60c1d045231 Amber Williams Amber Williams ambyrlight@gmail.com 019876 11 2025-11-19 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 19:27:13 50.2 hrs 69024490490c1c0997bafd1c 000025229 4.00 310.00 30.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10179 21ef43b1e1d9733750edf270b2520de9664e7bc3eeec0a41c485f6a54c1cc68f 68e68cba3e8aa1fba7870d28 68e68c236fc6580a094e37ee Marlene Yates Marlene Yates eaglecloudfarms@yahoo.com 020016 11 2025-11-19 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. pt conf cxl - sick SL 11/19 Sophia L. 2025-11-19 15:03:56 -2.2 hrs 68e68cba3e8aa1fba7870d27 000022745 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10178 1d7d28b2763aea6e3f9911aa2a0c8613722a5cea0a38eea4012935d620a1d9b6 68d6fa0ac2de82138a948b19 67ced32d7abf9f3ed8fe7dce Susan Barber Susan Barber sbarberphd@yahoo.com 003161 81 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-19 17:08:51 -0.1 hrs 68d6fa0ac2de82138a948b14 000021261 2.00 59.46 59.46 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10177 85a817f3753b1f2107c4eb3842e54302ed5456b04236fa12f3e0049448de2586 68b06f4e84c5c307bbca59db 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2025-11-19 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-19 17:39:11 0.4 hrs 68b06f4e84c5c307bbca59d7 000017947 4.00 81.40 81.40 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10176 9d884a208e1f3b1a0716dd2b4421a3308354077afb3e2203a4ca42ec7b7ee7b8 69024b4ab4a8c018e07cb1b8 68d0ce55b2306a20a239a871 Sara Roberts Sara Roberts sara@newagere.com 019905 35 2025-11-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-21 22:41:12 53.2 hrs 6920eb127c92d271563894d1 000025249 3.00 -67.00 147.20 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10175 28637f1d08a64512e45422b7220480843e9470182e1f3efd4faff71392e2f2ec 68efd45e478934a8f631c9b2 68c880399ec5d41f375d6e58 Lynn Hildebrand Lynn Hildebrand lynn.hildebrand@colorado.edu 019861 17 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 18:55:37 49.4 hrs 68efd45e478934a8f631c9b1 000023598 3.00 235.00 20.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10174 8e2ebd5b5da021247a01d9d95a2d2ef543eb3a9612eeb5195b344ecd59bf8ef5 68e6849ac19fd087b386c406 67ced3c57abf9f3ed8feadfd Beth Karpf Beth Karpf bethk@alum.mit.edu 007272 156 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-11-19 17:35:13 0.1 hrs 68e6849ac19fd087b386c405 000022725 3.00 79.51 79.51 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10173 ca3b9acfeaf9c9b6699d1a60ef147fec67d622d03dae6fc9a74791daf5461c80 68d5b552eb306b28542935f2 68d5b41d53299b3d94238649 Robin Reddick Robin Reddick robinsterner@gmail.com 019936 11 2025-11-19 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 17:27:53 -0.0 hrs 68d5b552eb306b28542935f1 000021109 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10172 55ba9b9fc1147dff166b55a804f3ff12c3a9939e6d7410ad15a9580838e444c7 6908fc053220950fe9fa4ced 67ced4de7abf9f3ed8fee50b Donna Racette Donna Racette donnaracette@yahoo.com 011968 89 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Peter Gagnon - Sophia L. 2025-11-19 17:47:53 0.0 hrs 6908fc053220950fe9fa4cec 000025743 2.00 59.50 47.40 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10171 0a167da4e5fa2349bfb9bc8de772e133ef005980a888e883352f05e18fb4bb11 68eff68d89b34108efd6ca1b 68eff5e25e3d13094ff5701f Jane Elvins Jane Elvins drjane99@yahoo.com 020076 14 2025-11-19 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 681139689cd6a804651d51e6 Medicare Pelvic Floor Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. pt was more than 15 mins late for this appt -mw Michelle W. 2025-11-19 18:01:27 0.3 hrs 68eff68d89b34108efd6ca16 000023647 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10170 b2478121966cf6ab2e729e12bb8b2a40df7371d0b8ac5a50c7ee1440348d8312 691610151657addeea597d8c 68a746a730f2e93c52681c6a Jacqueline Riseman Detsky Jacqueline Riseman Detsky drjackiesy@yahoo.com 017882 45 2025-11-19 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-11-19 20:48:27 2.8 hrs 691610151657addeea597d8b 000027092 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10169 b5c930f46afeff20a0a87fe02409835f3dcd5ac0620eda37a0a48da228445e1a 690295a02d3d7c0add6cdba9 68017885831990d97bdb1b73 James Lewis James Lewis jimlewis8128@gmail.com 017083 57 2025-11-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Sophia L. 2025-11-19 17:58:00 -0.0 hrs 6939f99af46293a770f447dc 000025357 4.00 79.00 79.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10168 2eff30b77a23b9bc6f72b1db9e722a8ce24a6dda8f8d22c563841bc7687c2af8 68fba7abf3160709b12c139c 67ced5527abf9f3ed8fef72d Judy Sherman Judy Sherman flowergirl6334@gmail.com 013515 17 2025-11-19 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Michelle W. 2025-11-19 22:46:45 4.8 hrs 68fba7abf3160709b12c139b 000024726 2.00 59.50 59.50 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10167 3912c635c00661280d9ffe48b3cdd95a755b7ea8035ce02b6ed24ba7517f2f6e 68ed18790a7aaad4c36f7674 68c47e778ddde062ad6a73c8 Jeanne Visvader Jeanne Visvader jpvisvader@gmail.com 019849 22 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 18:53:07 48.9 hrs 68ed18790a7aaad4c36f7671 000023147 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10166 b53284109fe37ae3f31d44aa25e6256560ec07bb048763266e39edec2532940e 6893db3e00b25407968aeaab 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2025-11-19 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. pt conf cxl SL 11/19 Sophia L. 2025-11-19 17:19:08 -0.7 hrs 6893db3e00b25407968aeaaa 000015676 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10165 f76fb1066da4c74175277efd83486e129c13b6979571f6c48df7d1a74899ca9d 688ba47f8d6ba90844b98a44 67ced56f7abf9f3ed8fefb79 Mary Ellen Steele Mary Ellen Steele maryellen.steele@gmail.com 013881 236 2025-11-19 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-19 18:03:09 0.1 hrs 6920f0a668af808e00aab57e 000014957 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10164 da811090d3b3560e0fbfe70b4c51de3888e7706985a2fd7e145e00bcb0b719eb 68eea4a46175fb091a8f4b79 67ced37d7abf9f3ed8fe9a47 Jeffrey Foster Jeffrey Foster jeffoster1@gmail.com 005590 56 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-19 18:11:02 -0.1 hrs 68eea4a46175fb091a8f4b78 000023416 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50
10163 6c0733fe769e6161162e78fb68c704fae5c57cf22ee0101bcc47dc1b546fc368 68e41782ac842209d0948193 68e4165d3b8c4a09adb5fc36 Lisa Selhorn Lisa Selhorn lisa.ritacco@gmail.com 020000 15 2025-11-19 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-01-09 18:18:02 1224.1 hrs 68e41782ac842209d094818e 000022404 4.00 95.57 95.57 - - - - - - - - 2026-02-19 22:50:37 2026-06-11 23:22:50