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
17143 96b2f880b1d35e5ff10237885fed4c4b65606489fc37bdceb8946a394a22ebab 68c084ad346696080b209908 683e2243b8ecd2c9d651a06e Marshall Frech Marshall Frech mfrech@tec.org 017372 43 2025-09-22 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-22 21:53:37 1.9 hrs 68c084ad346696080b209905 000019247 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17142 ae9952332045ea9efb64a6c5f7e0475d7582817519d219defec77c5d08efcb37 68bf1ed7102bd7ac0b754085 68bf1ece4c373c9c32dc0a2d Benjamin Mcchesney Benjamin Mcchesney kmcchesn@gmail.com 019819 40 2025-09-22 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Michelle W. 2025-09-22 19:56:37 -0.1 hrs 692e2487a6459343c0d7a3ce 000019045 3.00 232.00 80.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17141 55a6604b37deb5f383212212bca497cd657a6990b303ca07dc07da93e541769f 68a4d8aeca96e381ab35ae08 68599286ed08c1df3c5041eb Katherine Robertson - Mazur Katherine Robertson - Mazur katie.jay3@gmail.com 017504 43 2025-09-22 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Emily Pickner 2025-09-22 20:01:24 0.0 hrs 69386c8617620f51e99830bc 000016757 4.00 80.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17140 fef631660b16e28b10ebde9864fe9a4b725585045b0b712a2159e9c521fe4003 689cef1aefeb2eca4de4e405 67ced33b7abf9f3ed8fe839b Jeannine Corey Jeannine Corey wrcjac60@gmail.com 003656 22 2025-09-22 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. sch conflict - sc Sonya C. 2025-08-25 16:06:07 -675.9 hrs 689cef1aefeb2eca4de4e401 000016207 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17139 2bd583fceb442996c4bf9cfa27676fb9cf4a686d509ec5da85c9e7f8c9232899 688929150f49f01f911a74bd 6821fb1a6f66d9077f1fe22e James Voogt James Voogt jimvoogt@yahoo.com 017217 25 2025-09-22 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ per Miranda- sc Sonya C. 2025-09-08 20:26:15 -335.6 hrs 688929150f49f01f911a74bc 000014644 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17138 effdeca5f5508f46046629c77f1018a7f79da0181a2ea84913e3369c3bae0382 68cadda2d8af319cc7d8371e 67ced4ae7abf9f3ed8fedd00 Sara Noah Sara Noah tuxedocat333@yahoo.com 011282 10 2025-09-22 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6789a294b1b37ef18be50 AIM OT/PT Initial Evaluation - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-22 20:18:50 0.1 hrs 68cadda2d8af319cc7d8371d 000020011 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17137 4a62cdebbfd2db05271b06553f5ac55886c4fa69be9ca7aeaa2c86d62da2998a 689b7683a01043086fdcfb96 689b7487d5e35daf6d4beb8f Ryan Muela Ryan Muela rymu2503@colorado.edu 017783 21 2025-09-22 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. cx 1x/week Samantha Saunders 2025-09-19 17:44:44 -74.5 hrs 689b7683a01043086fdcfb95 000016008 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17136 bc3330495284a17bc3483bd676b42d9d846407b14079c6f8088126ecdce86706 68950fc5ddd8c20797add111 67ced33b7abf9f3ed8fe83c2 Brandon Cornacchione Brandon Cornacchione mscornacchione1963@gmail.com 003669 115 2025-09-22 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. pt's dad said he has another appt-mw Michelle W. 2025-09-22 13:31:45 -6.7 hrs 68950fc5ddd8c20797add110 000015756 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17135 3e8e45b424f16d4eb3b2b667fc7c1fc6884d88dacd588b22ad3b4acdebddd2cf 68756d5ddd4ecb081a7df7b3 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2025-09-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-22 21:28:07 1.2 hrs 68756d5ddd4ecb081a7df7b0 000012862 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17134 c98c27d759ad977eee75796ad59e300773036bd5bdb9ba66fd939f8a43a367aa 680946a0129314954c9f8444 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-09-22 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sonya C. - Rosey Reed 2025-09-22 21:03:59 0.8 hrs 680946a0129314954c9f8443 000003281 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17133 dfeb19792e3777c509e632ee115f215bd8d7b1ca6adef859892aec37f3d4eefe 68b8c7eefc529a47d1001eca 68b8c7962457491acc740e21 Marc Alber Marc Alber dralber@alberdentalstudio.com 019795 5 2025-09-22 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-09-22 21:00:02 0.5 hrs 68b8c7eefc529a47d1001ec9 000018649 4.00 180.00 180.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17132 cae6f6d1d73f89d2778dcf725424233e58ab4568d77da6d55ca0fcde1ea5c31f 689df2901987a508098b93cd 689df1c5d4bed0085e0d7339 Kenton Younkin Kenton Younkin kent.younkin@gmail.com 017796 7 2025-09-22 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Anne Palma 2025-09-23 21:38:57 25.1 hrs 689df2901987a508098b93cc 000016254 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17131 9cc66ac70a41def1ada1e7a5b87f9b9c6ccb8bba9da1076ebcd0482384177df3 6890d061d346a90826cfca1f 6890cded11a7af0803467727 Judy Hinks Judy Hinks hudy@ptboulder.com 017745 24 2025-09-22 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-09-22 20:33:41 0.1 hrs 6890d061d346a90826cfca1b 000015210 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17130 ee52a155c59259a38d361fdb13ea2cafefa7dbfc0fe39bdec5463675185e43f6 6875790f0969bf84ec9bd552 67ced5b07abf9f3ed8ff04b7 Kayla Smith Kayla Smith thekaylajsmith@gmail.com 014669 28 2025-09-22 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-16 19:30:12 575.0 hrs 6875790f0969bf84ec9bd551 000012874 3.00 83.44 118.44 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17129 846b5a4e73b199ecf50dc48e369802dc6ef2c31ba6d57d8e4fd44fe9b7f3128f 68c99900e1579c149c0f965d 68c998ea02a01e077f53910a Danette Anderson Danette Anderson danette@cdgga.com 019868 6 2025-09-22 Checked Out 67c8f28f945598c08d4245c7 John Phinney 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-09-22 20:34:56 -0.2 hrs 68c99900e1579c149c0f965c 000019886 3.00 144.16 144.16 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17128 66dc917f595ae7b8eaa4407ac6f8c0b7b99484aaa6d6e480c944ecb6497f3af1 68a752e28c25008810cfa401 67ced2e97abf9f3ed8fe5a7f Susan Benson Susan Benson susan.benson52@yahoo.com 000148 116 2025-09-22 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ family in town - sc Sonya C. 2025-09-15 21:16:30 -167.5 hrs 68a752e28c25008810cfa400 000017090 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17127 5cc5526ef36d47d3d4aec054b9c004eb828c3b6411577197e8d6f120d9fd9a99 689a2d2587b65508179807f6 689a2bda5d092ad91d386d85 Elisabeth White Elisabeth White ehwhite@yahoo.com 017779 6 2025-09-22 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-09-16 13:22:44 -151.4 hrs 689a2d2587b65508179807f5 000015939 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17126 6c96b2a3991d99ba78311e00ea45676ab61750985b8271072f9a00a02ffe0a32 68c8324c4180f48c0c1baa59 6823b00248048d03791a9751 Cheryl Barnes Cheryl Barnes revcheryl.barnes@gmail.com 017233 26 2025-09-22 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-09-22 21:03:29 0.1 hrs 68c8324c4180f48c0c1baa58 000019747 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:03
17125 06a92ed388d2d363589b0e32cf01a40a0b49825da7f160549ec6fbb6337fa848 68b7551040f54d21c350ece1 67ced4857abf9f3ed8fed5ce Clark Myers Clark Myers myers.clark712@gmail.com 010668 97 2025-09-22 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-22 20:55:03 -0.1 hrs 68b7551040f54d21c350ecd5 000018393 4.00 104.99 104.99 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17124 e93020069fd48da1b1ba64aa8a1be083be7cdebdd4414021ff759016d4fdc62e 68a49c28678a9f0838f71445 68a499beca96e381ab336765 Natalie St Denis Natalie St Denis natalie@stdenislong.net 017821 54 2025-09-22 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-22 20:53:45 -0.1 hrs 68a49c28678a9f0838f71442 000016693 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17123 3b045a318b56a5b246df5e1bc798e5182c5290cc2259779b6b250e9a1ac5168c 6893905a7f3e617ebd51cd2b 67ced3547abf9f3ed8fe8cc4 Jennifer Evans Jennifer Evans jennifer_evans@comcast.net 004437 134 2025-09-22 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-09-15 13:39:32 -175.3 hrs 6893905a7f3e617ebd51cd2a 000015514 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17122 6cc680fc0aed9a5d2b6647dfe75aad6855ec5382a836e624f679b46e5848d255 688108747a52071948c6dbb3 67ced5857abf9f3ed8fefeaf Deborah Usrey Deborah Usrey dusrey2@msn.com 014155 14 2025-09-22 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Anne Palma 2025-09-23 18:27:54 21.5 hrs 688108747a52071948c6dbae 000013982 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17121 7c1f200be758b5b92095e1870f3f2a04b1c2b8d8a20d8787a75976ac0dd2955f 6877d62f03b3760782913945 67ced42c7abf9f3ed8fec4c2 Deborah Martin Deborah Martin dmartin0811@gmail.com 009214 67 2025-09-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-22 21:28:10 0.5 hrs 6877d62f03b3760782913940 000013191 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17120 5eae1986e0ccc94e035b59bca62f31270ea0e57d472d1f200388d1f24f0cb7c6 68ba01b1fbbbe6085617849d 68a8153699c65c4a78a5fa31 Charles Izurieta Charles Izurieta charles.izurieta@gmail.com 018691 18 2025-09-22 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-16 19:31:09 574.0 hrs 68ba01b1fbbbe6085617849b 000018794 4.00 95.71 91.01 - - - - - - - - 2026-02-19 23:10:57 2026-06-11 23:40:02
17119 908312a9995308687cb4fbc784690dac0ecb8e3d72cc0427ca897085bba460aa 68c884db474854526f4f18d5 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-09-22 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Samantha Saunders - Rosey Reed 2025-09-22 21:45:47 0.0 hrs 68daf17019cd4c6c782f0051 000019841 3.00 85.00 55.00 - - - - - - - - 2026-02-19 23:10:41 2026-06-11 23:40:02