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
9607 93da52274390e5de2c696de112b48a7507e12afa21f3d93b7ce9e388e2c0fd2e 68ff90585db4b50989b3c6fa 68ff8f8aefad4a0948c0a5fd Jeremy Smythe Jeremy Smythe jeremysmythe@mac.com 020144 5 2025-11-24 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 11/4 Sophia L. 2025-11-04 17:57:51 -483.3 hrs 68ff90585db4b50989b3c6f9 000024860 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9606 a4b7fc3307dc596c71b43de1f670c4afedb329c5bd58453293786a28abd3fcd0 68faa307e3b958d3abb9c5ef 67ced37b7abf9f3ed8fe9984 Suzanne Forrester Suzanne Forrester suzanne@sgforrester.com 005525 16 2025-11-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-11-24 21:06:03 -0.1 hrs 68faa307e3b958d3abb9c5ee 000024617 3.00 81.76 81.76 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9605 07d92d42bb6bd68e886f5481e67c450bfe53761587476e50f0c764541ca81626 68532288e00ede65c54bf399 67ced4207abf9f3ed8fec27c Gail Miller Gail Miller gemiller07@gmail.com 009020 240 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-24 21:34:48 0.3 hrs 68532288e00ede65c54bf398 000009819 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9604 9de715ea238793b2584f112b56192f45cb00e02956fb226b27853b4b4337aa5d 690d0702ec5c678e02b05733 6908dc9de1ae78de1ef3be43 Eric Warneke Eric Warneke warneke@gmail.com 020184 15 2025-11-24 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Sara Thompson 2025-11-23 22:13:06 -23.3 hrs 690d0702ec5c678e02b05732 000026314 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9603 9df5639fa617660237077a5343f2828798339092e475ea7c25e9ad41d8fb493c 6909160bb84cbd6e683b4df6 684855e5778dab0797732b59 Patrick Hiester Patrick Hiester patrickhiester@gmail.com 017427 21 2025-11-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Kenneth Dave Francisco 2025-11-27 16:11:25 66.7 hrs 6909160bb84cbd6e683b4df5 000025768 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9602 a277957a9b9fabc593de79ca4cf6fa3d8a6936f543d57eee1989d4e66cbf0e6f 68f6a32abcca3c7e5b30ed74 67ced65f7abf9f3ed8ff1b37 Joan Zimmerman Joan Zimmerman jczimmny@gmail.com 016588 32 2025-11-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Elizabeth Cousins - Sophia L. 2025-11-24 21:34:57 0.1 hrs 68f6a32abcca3c7e5b30ed73 000024094 2.00 59.50 59.50 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9601 35df866c740d4dbed27ce7a729d1fe68cbeb54ad0c0890e33cc6d3e0908b5368 68f022efa3f1311d22e49b26 67ced3f97abf9f3ed8feba07 Joanna Lamb Joanna Lamb joannalamb7@gmail.com 008299 15 2025-11-24 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 10/22 -OON Sophia L. 2025-10-22 17:52:30 -795.6 hrs 68f022efa3f1311d22e49b25 000023692 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:59 2026-05-04 23:14:06
9600 f7643b1bfd6c0868a00c17212d1f7fa02efefa1e729014e4dadf43fe6545e0b9 68e94a9a967404094b3280e1 68e94953fb957d093a4bf16e Dave Laub Dave Laub dlaub72@gmail.com 020046 11 2025-11-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Frances Lawrence 2025-11-25 01:57:35 4.5 hrs 68e94a9a967404094b3280dc 000023084 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9599 3f2c7b02410b0c9cc0606ad00dcb7b170dc67b41064f16804439abc779b7c920 68f7abb6864099126084e4d7 67ced56f7abf9f3ed8fefb7f Matthew Saaks Matthew Saaks mattsaaks@gmail.com 013883 138 2025-11-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-26 17:15:55 43.5 hrs 68f7abb6864099126084e4d6 000024169 3.00 85.00 93.50 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9598 0ea08b6c5f9ae85d319d93fff83ea58209517412252353b6c87e3f5d7f67dc91 690bb7db1edf6c76de8ea43f 68630c2f21d25807d2553e56 Lawrence Stuckenbruck Lawrence Stuckenbruck lstuckenbruck@hotmail.com 017551 11 2025-11-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Sophia L. 2025-11-24 22:01:18 0.0 hrs 690bb7db1edf6c76de8ea43e 000026180 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9597 ddeeeac0c21089b837e2abfa8944869db7ca0bdea458841765888e17e03d27a6 68f7c8b818404f099cbc8578 68f7c62388ff4e8c9079da79 Griffin Maxwell Griffin Maxwell ashleybuck66@gmail.com 020113 48 2025-11-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-24 22:01:02 0.0 hrs 68f7c8b818404f099cbc8577 000024240 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9596 8e2ebde76d02f435069bf96375096b9313ca1104a424508bf604eb19d23b4033 68f652e19146528abfb11650 67ced5d97abf9f3ed8ff0a15 Virginia Wadsworth Virginia Wadsworth vawads@gmail.com 015127 188 2025-11-24 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ will be OOT- sc Sonya C. 2025-11-04 21:33:07 -480.4 hrs 68f652e19146528abfb1164f 000023979 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9595 60ee33a2b7f9cc50c93a4a0bdc427d66be61168d3edb8abc1f8c6a2346ab0f0b 68d5570e50ec630905c80b7b 68752052c763f808867f129e Glenda Dye Glenda Dye gdye.1937@gmail.com 017622 12 2025-11-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-26 22:37:04 48.6 hrs 68d5570e50ec630905c80b77 000020968 1.00 150.00 10.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9594 4eb25e5bf0c8470f83bc8f5604d6a224cfc1d81472d3bbcf63a2fc9258f6b8da 68b7728d40f54d21c351f3bf 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 117 2025-11-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-12-02 22:38:45 192.6 hrs 68b7728d40f54d21c351f3b3 000018454 4.00 95.49 95.49 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9593 7a519afbc709d3149f8099d2a113e6fc3fe3b7413dc4ece4b44348d096f7a6a5 6893c3394b76da5b183eb35d 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Sophia L. 2025-11-24 22:11:30 0.2 hrs 69499cec2fe58128fb05c327 000015594 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9592 71e617631d3963e3b9d0e5695148382ea7d31c2be0f0489a1c58d98c58f4fc9b 690d28fa949883b791eea5d7 68af4ba0023471867510ced6 Braedi Tagart Braedi Tagart tagarts@comcast.net 019764 17 2025-11-24 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Sara Thompson 2025-11-23 22:24:08 -23.8 hrs 690d28fa949883b791eea5d6 000026361 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9591 a5f46f0768f6a4988ebd95fc6062736808cea47d5b415093b0cfeadecdba3491 68f107f1406551e167932d28 68d6b6dd81f7d675e614c847 Stephanie Maltarich Stephanie Maltarich smaltarich@gmail.com 019940 17 2025-11-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Jayson Encarnacion 2025-11-26 21:37:12 47.4 hrs 68f107f1406551e167932d27 000023731 4.00 85.00 85.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9590 794b98e84920d4dab618cdc3d8d69f8d3bca8cd2569093f9840a0f015f53ad38 68eeaf8b2c60098c0000a8e4 67ced3737abf9f3ed8fe972c Anne Harris-Cross Anne Harris-Cross aharriscross30@gmail.com 005325 36 2025-11-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-26 16:34:32 42.3 hrs 68eeaf8b2c60098c0000a8e3 000023436 3.00 82.00 52.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9589 d1d91cb011126ed534506cbc9bfaef45da14ab006a234a01d53d3bd6ff9b5307 691260e7f4dc2cfafbda5432 68e96b0678a5da0a09c42b09 Deborah Cusa Deborah Cusa debcusa@gmail.com 020049 2 2025-11-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Julie Petersen-Hanson - Kenneth Dave Francisco 2025-12-03 18:41:49 211.9 hrs 691260e7f4dc2cfafbda5431 000026615 3.00 85.00 35.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9588 a64a9185ba2c1ffe3069ba14f06cc5d346888726ca68fcf81c3dab18f61b3768 68f67bcfcc243d5953849ea8 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-11-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Rosey Reed - Sophia L. 2025-11-24 22:48:31 0.1 hrs 69c5cd3165b49a253967c85e 000024051 3.00 237.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9587 c3c2c1f4a7f22e10d018a116a98ab14a484337103e71dfa2334737a65509cb9f 68df0092f60dfe34406e2fb5 68deffbf040cf06246ab7301 Abby Howard Abby Howard howard.abby@gmail.com 019984 7 2025-11-24 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt doesn't need weekly appts - RAR 10/15 Rosey Reed 2025-10-15 21:54:52 -960.8 hrs 68df0092f60dfe34406e2fb0 000022129 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9586 c12b946fb0ee4b32808847b28584bd2ad9434e6a21706dde741aeba90caa76ad 68def062fd11d9d469938a1f 67ced49e7abf9f3ed8feda36 Elizabeth Nevers Elizabeth Nevers eileenlistens@gmail.com 011044 128 2025-11-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Emmie Gebhardt - Sonya C. 2025-11-24 22:32:48 -0.2 hrs 68def062fd11d9d469938a1e 000022112 1.00 32.46 32.46 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9585 55cd13b70a206c858fbbe9ca20db797e38c1d03a586ed5f0bea24234cba52ce0 68f79a14ee2e3f08e5e09aa7 67ced5f77abf9f3ed8ff0dff Molly Teas Molly Teas mmteas@gmail.com 015461 121 2025-11-24 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 11/20 - can't make it from Denver in time Sophia L. 2025-11-20 16:15:50 -102.7 hrs 68f79a14ee2e3f08e5e09aa6 000024137 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9584 f288f60fcf161e92a2a9af2ecceef8790ec2bc8fee07aa972fe4c340d4d4ea17 68ed80b5d91182f959804684 67ced2f77abf9f3ed8fe647b Patricia Carmichael Patricia Carmichael carmichael_patricia@svvsd.org 001000 32 2025-11-24 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-10-13 22:44:27 -1008.3 hrs 68ed80b5d91182f959804682 000023268 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9583 3e657f35cbea8385ca9e6262447ec32724baf5f1b96293487e0048bfabb797af 68cc5c0f8a4df7d262e17db7 67ced3017abf9f3ed8fe6a63 Dundeen Catlin Dundeen Catlin dundeen.catlin@gmail.com 001504 239 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Sophia L. 2025-11-25 22:19:33 23.3 hrs 68cc5c0f8a4df7d262e17db6 000020173 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06