General Visit (PT Boulder API)

Total rows: 101,693
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
18536 e5d244044db0f9e27ef96578e60e3d0eddcabdeacf146002afdee1a9028fea7a 6851d2e5495c400822a4e765 67ced3017abf9f3ed8fe6acc Patricia Bosak Patricia Bosak tbosak1018@aol.com 001539 168 2025-09-10 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Rosey Reed 2025-09-10 18:28:08 -0.0 hrs 6851d2e5495c400822a4e761 000009661 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18535 aa65aa63ee2b1725c8519faeaf9c9fb3a38469a101cd74e51b0c69302c1d9bc3 6876c1cbaa89e207bcffa4ac 67ced5177abf9f3ed8feee3c Stephen Roman Stephen Roman sa3roman@gmail.com 012752 48 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Anne Palma 2025-09-11 16:21:22 21.6 hrs 6876c1cbaa89e207bcffa4ab 000013100 5.00 95.45 95.45 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18534 249a83beecd42f01270ac1ec893e7ad19393ae63c7d4a4d4a6caec0f75d8f288 68b1daab65022149ab0db601 68b1da9f777428f3f33f0405 Hannah Ardner Hannah Ardner hannah.ardner@gmail.com 019780 15 2025-09-10 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-10 19:46:49 0.8 hrs 68b1daab65022149ab0db600 000018191 3.00 70.36 38.36 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18533 fdb16b61c3119a1642555db089e80f170601b413414572162d0a7b81064fb9b9 68a4d303482471cb585f09ef 68a4d1cbb7a2ac08140d2bce Chelsea Hackett Chelsea Hackett chelsea.hackett@gmail.com 017825 16 2025-09-10 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. nln AM 24+ Anne Majewski 2025-08-29 19:13:09 -287.8 hrs 68a4d303482471cb585f09ee 000016749 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18532 0742ede67d9a4b9f0d1e14157910f09f8024e2ddc3d657f32ac3ebfcf1ef31b2 689d04488efd4b1a82a21aa1 68715c28bd72dd080830c7a6 Carol McCool Carol McCool mccool23@gmail.com 017612 8 2025-09-10 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-09-03 18:01:03 -169.0 hrs 689d04488efd4b1a82a21aa0 000016219 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18531 7aeb4d103306460459cc68db6cd9b8378099537d383631a38b63d416fab1c4cb 6887f78e03d9f1079f5da421 6887f54841dc4a3f61f0bab7 Charles Rhoades Charles Rhoades srhoades@stonecroftcapital.com 017715 7 2025-09-10 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Pt conflict Samantha Saunders 2025-09-10 14:10:47 -4.8 hrs 6887f78e03d9f1079f5da420 000014554 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18530 77a306ebc042f3636b825894b36f4a22a9f71fd88c8e25cf7f1bd185360cc724 68713e48bf71e50794b55d7a 67ced30a7abf9f3ed8fe6f70 Adam Chavez Adam Chavez adamjchavez@gmail.com 001935 67 2025-09-10 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-22 22:03:16 1011.1 hrs 68713e48bf71e50794b55d79 000012629 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18529 9974c72ed94552b54e018d338712023175f5a326f43e19d28f73096bb85efa7c 681cd0bb34703907b4e13a99 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-10 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 14:46:41 -2068.2 hrs 681cd0bb34703907b4e13a73 000004802 7.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18528 0f9dc907ab830f0295e27691d8302b2d68b236edd4b937f1b3345fa34df81960 67e671a9ceb9f104f028caeb 67ced5cf7abf9f3ed8ff08cb Michael Sullivan Michael Sullivan jazzdharma@comcast.net 015017 225 2025-09-10 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-09-10 19:07:15 0.1 hrs 67e671a9ceb9f104f028caea 000151731 1.00 35.16 28.01 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18527 64ea0f5c1264b1bae0646d18fc65e02f247093245b74b70600abca56f753a18d 688a57c41997c6086050df17 688a5714297fd59a76062d1a Agnieszka Magoye Agnieszka Magoye amagoye@gmail.com 017722 14 2025-09-10 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Primary - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-22 17:08:06 1005.9 hrs 6914f084b0a33bcf069106da 000014784 1.00 0.00 20.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18526 a28fe0b987c30b57c24310459db6b78eb8dadbdcb33159969a7d5d9f5c2ff72b 685f1e61b9b346567f081074 681b7df597c361e480a06d0f Chelsea Souza Chelsea Souza cjowell@gmail.com 017192 13 2025-09-10 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Miranda Samson - Michelle W. 2025-07-30 14:44:31 -1012.5 hrs 685f1e61b9b346567f081073 000011247 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18525 31d49230218a44005b7ebb5f0b2d7464565eb97ba06f9c9d5da865a24a38c855 68b9b35b119c6c0880ba8dfa 67ced5237abf9f3ed8fef031 Anita Schwartz Anita Schwartz cheer.anita@gmail.com 012919 38 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Elizabeth Cousins 2025-09-04 15:42:19 -147.8 hrs 68b9b35b119c6c0880ba8df9 000018672 4.00 133.86 133.86 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18524 597f271ff8b83dd822bad6747bf421071439098bc1a42e8c0accb564ab313c75 68af8af4556252a19e222f7c 6880e83200e54407d73eac1f Helen Vickery Helen Vickery hvickery62@hotmail.com 017676 11 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-10 19:29:11 -0.0 hrs 68af8af4556252a19e222f7b 000017925 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18523 72c37515809fc72c9c5a406b37bbf6522a71a31aed16f52aa4ef7adb6ff51771 68accf5736b9c5f1f5092626 687e75e40d5a13ac227d3ed0 Mary Kay Stewart Mary Kay Stewart mkwstew@gmail.com 017662 7 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-09-10 19:24:28 -0.1 hrs 68c777ab4370596cf755796f 000017477 4.00 156.40 64.85 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18522 4e69f132fbc53cdba6432d8447a6c38b0dd0eed38384716404b35c46c12504f2 68ac94abc2d5cf09021706bc 68ac93e9d2876dc47bcfa6f5 Katherine Gockel Katherine Gockel katherine.gockel@gmail.com 019738 5 2025-09-10 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 8/25 Sophia L. 2025-08-25 20:34:08 -382.9 hrs 68ac94abc2d5cf09021706bb 000017394 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18521 8ec2b2bc26b138fc71e0f2779921a5140019e6172f8f89c9c50fe3d66fcd053e 6894fdb89ee53907976a52bb 67ced3c57abf9f3ed8feadfd Beth Karpf Beth Karpf bethk@alum.mit.edu 007272 156 2025-09-10 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Samantha Saunders 2025-09-10 19:31:13 0.0 hrs 6894fdb89ee53907976a52ba 000015734 1.00 35.16 35.16 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18520 c2a9f009c42f40bd30cd81729241c4dfb50ff8b623bd449e1b91b02285cb2449 6893b68a55cc68342a09a773 67ced42e7abf9f3ed8fec51c John Miranda John Miranda flymiranda@gmail.com 009244 113 2025-09-10 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/10 Sophia L. 2025-09-10 19:50:59 0.3 hrs 6893b68a55cc68342a09a76e 000015566 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18519 71ca4c107d8b3c65f7a0a5011e8b1f96e3348d34cb3a700c2fb13388d12ef697 6891091dc1f7c6e6b3df8637 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-09-10 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Maia H. 24+ sc Sonya C. 2025-09-05 21:41:58 -117.8 hrs 6891091dc1f7c6e6b3df8636 000015272 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18518 8c402a0256869092a5dd8114689b8fa1b983341baf1b14e010a2239af76c118a 687fcc7f4e569afc314f9bb8 67ced4307abf9f3ed8fec579 Marilyn Martin Marilyn Martin marikaymartin@gmail.com 009275 33 2025-09-10 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-29 17:04:44 -290.4 hrs 687fcc7f4e569afc314f9bb5 000013851 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18517 cbb08db36e5f1d81f96f560a122de0bef74f8373c8232ef32b650c477eb0f6f3 6870172c45f3fbe43a24e182 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-09-10 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins Sept 8 appt Elizabeth Cousins 2025-08-25 16:25:09 -387.1 hrs 6870172c45f3fbe43a24e181 000012500 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18516 f71e60f60c599d24568171c107862f18fc2b8416b06d0867eab772a67626a2bd 685eae8f10ccb508672d1065 67ced3457abf9f3ed8fe8777 Dale Durland Dale Durland dale.durland@gmail.com 003985 111 2025-09-10 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-10 19:29:14 -0.0 hrs 685eae8f10ccb508672d1062 000011044 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18515 6e6a1098a96ac9787f64a32eaae8f9cd4b18b7bd1551f4a92927fc32e4c2847c 6894c6e352a39d080c03bbd1 681a708f5288e5729fbcf929 Cambria Klinger Cambria Klinger pyronymph@gmail.com 017187 17 2025-09-10 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-09-09 21:12:48 -22.5 hrs 6894c6e352a39d080c03bbd0 000015696 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18514 a8481220ea075aa62e8004096bcfd7549da33913a2f74983fb16a0b5e0592d38 68795c0e96007a17c1cf4fa4 68795a5ffee8dab7b5b8263d Reba Kahlon Reba Kahlon rebaKahlon@hotmail.com 017648 11 2025-09-10 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sonya C. - Anne Palma 2025-09-12 18:51:29 47.1 hrs 68795c0e96007a17c1cf4fa3 000013427 1.00 150.00 15.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18513 03cb1bafaeb9275b5f840c9c4bed3d98ec1c5e4db66906872e73f02d8cf09659 68b888059648d907a4b1175d 67ced2e97abf9f3ed8fe5aeb Charles Berginc Charles Berginc berginc4@gmail.com 000184 42 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-09-10 19:40:44 -0.3 hrs 68f8077f1c00dd0948df6abe 000018536 2.00 150.80 15.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42
18512 1bae0f47398d28cccb94d6577e376a87c766c6454a766bbf4d49c0693745ae30 68a8ca25fc757507747fd96b 68361569374e5dfd88833674 Sidney Wilder Sidney Wilder sidneywilder27@gmail.com 017315 31 2025-09-10 No Show 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Stephanie Braun - Sophia L. 2025-09-10 20:15:04 0.3 hrs 68a8ca25fc757507747fd96a 000017314 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:37 2026-05-14 23:40:42