General Visit (PT Boulder API)

Total rows: 100,569
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
10370 86d9b259c486f7eafc205a2f9c7ce8812f6ae3a0b6b68bc012350411b6b3f906 6904e396b92c2e09ff0f4057 6904dedbd40eff0953ee41ae Elizabeth Penziner Elizabeth Penziner elizabeth.penziner@gmail.com 020181 27 2025-11-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-28 20:21:50 242.6 hrs 6904e396b92c2e09ff0f4056 000025561 4.00 525.00 30.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10369 1d13bc19d382d192a1db64cda187d92dcd32efeaf09be81a44387c8bda8b785d 68e6b3192450310a7d3eaf5c 68e6b0c95aa64e099b35ea12 Janet Seston Janet Seston jseston@comcast.net 020019 29 2025-11-18 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-20 19:27:17 49.7 hrs 68e6b3192450310a7d3eaf58 000022768 1.00 150.00 10.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10368 f753334a76d60947ed6e34011b2fbef3592061f79749b28bfcd6ed6c9fd16fcf 68e3f11f576c7d08fef884ae 68b1e83ef391642b2654c4d7 Joyce Gordon Joyce Gordon jay_gee@comcast.net 019783 53 2025-11-18 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed 24+ per VM, has shingles and is not feeling well - sc Sonya C. 2025-11-10 14:32:55 -195.2 hrs 68e3f11f576c7d08fef884ad 000022338 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10367 6a42981e4f21451a4617ea5e4e95225555a9f5c86e4c5035542cf10527480194 68e3e37c37115fffc8f2a191 67ced5917abf9f3ed8ff0068 Milton Slater Milton Slater miltonslater@comcast.net 014302 14 2025-11-18 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Sophia L. 2025-11-18 18:30:29 0.8 hrs 68e3e37c37115fffc8f2a190 000022294 3.00 77.56 61.79 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10366 8d95676094398eb89e68c383ee173a604bc9369e69103e91b70c06766e6ee464 68c99002adf7a8077bcc215f 67ced5027abf9f3ed8feeaf4 Carly Rixham Carly Rixham carlyrixham@gmail.com 012472 105 2025-11-18 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed pt conf cxl SL 11/18 - pt's boyfriend broke his back Sophia L. 2025-11-18 15:17:55 -2.5 hrs 68c99002adf7a8077bcc215e 000019876 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10365 707af5b6c635ab8340a0a2fc74c19b8e8c7bd5eda3902fa7e396c1e503257590 681a469904b7fa080dd592e6 67ced59f7abf9f3ed8ff0257 Stanley Stjernholm Stanley Stjernholm bestjernholm@msn.com 014467 174 2025-11-18 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Michelle W. 2025-11-18 17:28:06 -0.3 hrs 681a469904b7fa080dd592e5 000004455 4.00 103.85 103.85 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10364 c09566c7f16c371b013a1b05680805585c71905060ef8ce970ab6ea20af47b40 691613e72b2cd4cc15394e98 68a8152599c65c4a78a5f67f Richard Green Richard Green hikingrich@gmail.com 018507 21 2025-11-18 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-11-18 18:58:58 1.0 hrs 691613e72b2cd4cc15394e97 000027106 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10363 f9abd30c9380082e419deec8a6a365e52b472ce2afd6955ccfcd770136b65ea0 68f15a5bc7ae4bfbd797ef48 68f156370ea67c08ac0d2131 Catherine Werner Catherine Werner catherinewerner5@gmail.com 020091 15 2025-11-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-18 18:06:31 0.1 hrs 68f15a5bc7ae4bfbd797ef47 000023819 9.00 100.00 100.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10362 637832d31e19ef28677518266a3a123b07a5d26d4363b4d8d32ffd0819ad76f0 68deba6a8f93f4fe07ba999c 68a8156699c65c4a78a6037b Nellie M Parnell Nellie M Parnell robtandnell@comcast.net 019149 51 2025-11-18 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Julie Petersen-Hanson taking a break from PT Frances Lawrence 2025-11-13 17:22:22 -120.6 hrs 68deba6a8f93f4fe07ba999b 000022022 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10361 ff752401a1a6d19cbd4f4126ff0f0707a88273d2fc0bc0b93b9fe0a249f7503f 68dd89bb78014a59b600d61b 68dd8707b3b61d09d5c699e5 Olivia Stafford Olivia Stafford oliviastafford2006@gmail.com 019973 14 2025-11-18 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-11-18 18:20:14 0.3 hrs 68dd89bb78014a59b600d61a 000021927 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10360 e4ab28e6d9ce7b04be8d2c5897cf4ea34cb5788e85de230a84efa7307f392600 68d55e0b859a7a5f8cf1ca8e 67ced5d87abf9f3ed8ff0a00 Scott Sutton Scott Sutton sutton.scott.olin@gmail.com 015120 72 2025-11-18 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed Unexpected work conflict - sc Sonya C. 2025-11-18 15:52:37 -2.1 hrs 68d55e0b859a7a5f8cf1ca8d 000020983 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10359 16fb47ef148160b09cf59ac3b10b86369c4ec5c92a003cd0bc29110bd89adf62 68503419837be607f33614b3 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-11-18 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 18:11:24 -3335.8 hrs 68503419837be607f336148f 000009387 4.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10358 788e5b826137810bbe8435f0c6c443c65e6c6c319daaf1c9b56120ff7c747381 69137590d9824600e44103b6 6900d44a029363c504d659d4 Tomi Rendell Tomi Rendell tomi.rendell@gmail.com 020154 3 2025-11-18 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Kenneth Dave Francisco 2025-11-28 18:53:09 240.6 hrs 69137590d9824600e44103b5 000026811 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10357 ce17d419b2bb13fb3b2375d48c6e135dcf085f1480fc17a78d9b8dd1c2e4073f 6900f0b0e7279d09b974ae3b 68a8153999c65c4a78a5faac Patricia Johnson Patricia Johnson pjmjohn14@gmail.com 018714 55 2025-11-18 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Emmie Gebhardt - Rayann Greer 2025-11-18 19:35:10 1.3 hrs 6900f0b0e7279d09b974ae3a 000025031 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10356 7bb63ea28681ecb85a741f082f79ae9a85e0bc341be669c878fe15f8a89bd13f 68f7d539823fa73a48e9493c 68a8156d99c65c4a78a604b2 Kemah Plusk Kemah Plusk ltdgoldens@gmail.com 019208 28 2025-11-18 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Michelle W. 2026-02-16 19:05:16 2160.8 hrs 68f7d539823fa73a48e9493b 000024258 3.00 80.27 80.27 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10355 2d45015610871fab7df7e49374171dd4043dcfb9392a5c71b1d0daa5af9b0b25 68f7b68c89833ac6d094da1b 68dc2d1d74d5c2b85eee42b5 Marianne Burnworth Marianne Burnworth larimer.2000@gmail.com 019959 10 2025-11-18 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 11/4 Sophia L. 2025-11-04 21:29:25 -332.8 hrs 68f7b68c89833ac6d094da1a 000024213 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10354 76c156626254f74c23bfd3dcf3418f745528ed316d678e63e589db337cf5d1e3 68d595da316f10cb68c9dbb6 67ced3377abf9f3ed8fe81f1 Roxana Bartlett Roxana Bartlett roxana.bartlett@gmail.com 003514 118 2025-11-18 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed - Michelle W. 2025-11-18 15:27:37 -2.8 hrs 68d595da316f10cb68c9dbb5 000021060 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10353 069d343714796157bdd15353dd9b8ec0389ea84b7d40d4496b630009980da5ba 688a5f3e99de3307937ad736 67e1258a54aaaa3a80096c69 Kenneth Chan Kenneth Chan kennethsaichan@gmail.com 016747 16 2025-11-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-18 18:16:47 0.0 hrs 688a5f3e99de3307937ad731 000014817 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:19
10352 89b8c166bc1238297f019c6de009f437afb73656a885f35dbf9cb511f25ce725 691223d79129bd2aad737b83 68470d0aeb7d482d9c8ba56d Cynnamon Kiser Cynnamon Kiser alpineteacup@gmail.com 017418 23 2025-11-18 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed 24+ per VM request - sc Sonya C. 2025-11-18 00:54:44 -17.6 hrs 691223d79129bd2aad737b82 000026519 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10351 0fe40b4dcc378f80bc2aa379c368b46287663dfc3b85f1a49a819738af4eca23 68f0172da01c5029634f9bb7 68f0168d7bd5c400e3c798e6 Patricia Nagy Patricia Nagy patsynagy47@gmail.com 020080 7 2025-11-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-11-18 18:23:12 -0.1 hrs 68f0172da01c5029634f9bb2 000023678 3.00 237.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10350 8b72b90465ccc19bbed4db8372aa8d8af5748d3376da95bbdff2650c40d849c1 68ee8701adc28a0a271fbeeb 68ee8678e8055eaf9ba01dd2 Mary Dahlstrom Mary Dahlstrom rojammer@gmail.com 020062 9 2025-11-18 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24 pt OOT - RAR 11/11 Rosey Reed 2025-11-11 18:23:34 -168.1 hrs 68ee8701adc28a0a271fbeea 000023362 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10349 4ff071f3b6f5e6ce51963908c579d368f351bfc200195a50b6f618826cb55df1 68e55ca69957ee09f0ccb822 68753655f040d77fff4e8a0b Genevieve Braus Genevieve Braus gen.braus@gmail.com 017624 22 2025-11-18 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-11-18 18:31:51 0.0 hrs 68e55ca69957ee09f0ccb821 000022556 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10348 52b2badbd81d641dde9e383d4a831d3f3d01c0cff1a364b6ab39f9ff12a48201 68d6e831e1cbd920b0ddf9a4 67ced57c7abf9f3ed8fefd65 Barbara Stephens Barbara Stephens barbaramstephens@gmail.com 014045 133 2025-11-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Pt called 11:13 cxl'ing appt today, she's been busy at work and now too tired to come in - sc Sonya C. 2025-11-18 18:14:27 -0.3 hrs 68d6e831e1cbd920b0ddf99e 000021239 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10347 9f3d9b435f067b350511a3671631ad740032c37a07c331fcc751d6ae58010fe3 68cc6e07dc0591c629ecd39f 68cb2a0dc84d730791505877 Michael Spotts Michael Spotts michaelspotts@mac.com 019885 10 2025-11-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Stephanie Braun 2025-11-18 18:30:03 0.0 hrs 68cc6e07dc0591c629ecd39e 000020201 1.00 32.39 32.39 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05
10346 4d0b14463922e56d9449ec65e2277106f321f8955f13cc310131a28d1bf19eb4 68c9babf601de7e5c9190f17 67ced3fe7abf9f3ed8febb36 Marcia Larson Marcia Larson larson4045@gmail.com 008400 52 2025-11-18 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 11/17 Sophia L. 2025-11-17 16:54:42 -25.6 hrs 68c9babf601de7e5c9190f16 000019925 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:10 2026-05-05 23:17:05