General Visit (PT Boulder API)

Total rows: 100,908
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
14193 8b7ddb014c7eef5ade1a31fac3fa759276d9feb97085cb585f0987df1a69b6a0 68dc11fe2ab66d09992cd541 68bc8214e8bd5ace48148121 Theodore Torrence Theodore Torrence ttorre22@icloud.com 019813 13 2025-10-16 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Emmie Gebhardt - Amie Russell 2025-10-16 16:37:05 0.1 hrs 68dc11fe2ab66d09992cd540 000021630 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14192 4e28cb41a33a1d65e8882fd2840b14f2d91b8fc1801f0a4350d4b1bb29f6c289 68d6fef32cd09670045e15d2 67ced3e27abf9f3ed8feb4ff Adam Klagsbrun Adam Klagsbrun aklags@gmail.com 007870 97 2025-10-16 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-10-16 16:34:11 0.1 hrs 68d6fef32cd09670045e15d1 000021263 2.00 119.25 119.25 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14191 f4c945fd5615566dff71b740b07fa7068197c51e1b794c87cedd3c832e60c353 68d440e1f8c41a0949062dcd 67ced4937abf9f3ed8fed847 Bonnie Neighbors Bonnie Neighbors neighbor@colorado.edu 010879 65 2025-10-16 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 10/13 Sophia L. 2025-10-13 19:48:00 -68.7 hrs 68d440e1f8c41a0949062dcc 000020865 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14190 2024aedbe69c1875a0f9a4d58286ddf2b92d530f6d3948c8927609de6b4f713b 68acaaca7db30e670926d03d 67ced3177abf9f3ed8fe75ee Susan Brooks Susan Brooks 2sbrooks@gmail.com 002489 39 2025-10-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-10-16 16:28:42 -0.0 hrs 68acaaca7db30e670926d03c 000017421 2.00 159.00 0.00 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14189 8adb3fcdfead78bdf4ba90018614f3ac188a32c8bb68db0e3836adccf58d853b 68e946eaa0b57508a76a0ca0 68cc5bde765d230582e6f788 Jeana Brammer Jeana Brammer jeana.brammer@gmail.com 019891 11 2025-10-16 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ scheduling conflict -mw Michelle W. 2025-10-13 15:56:30 -72.8 hrs 68e946eaa0b57508a76a0c9f 000023074 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14188 88d8195926fd9c7c0fc6a9806b56e517db6f29dbd097eebb289731ae87146761 68c860c43f24e7d98b3c52fb 68c85e7310ce867bf21a954a Nancy McNeill Nancy McNeill nancymcneill@mac.com 019855 35 2025-10-16 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-21 15:41:42 118.9 hrs 68c860c43f24e7d98b3c52fa 000019798 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:01:51 2026-05-07 23:27:57
14187 6ab90ebd7c92ebc4b3a926dda9444b072cc470c6cf1413f3be9a88aa62521716 68b711160a9465aa08e7ba31 67ced49f7abf9f3ed8feda42 Rodolfo Perez Rodolfo Perez rudy.perez97@gmail.com 011048 115 2025-10-16 No Show 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Rosey Reed 2025-10-16 18:15:13 1.5 hrs 68b711160a9465aa08e7ba30 000018301 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14186 024cb2b0da18645e5b969d59f42b65e0aa005ab8d1b53bbf6bee7b18de7ee530 6890f81374137e085eb91d58 67e6650befbf2c53d8d5d1b3 Rebecca Carson Rebecca Carson sullycarson@gmail.com 016799 48 2025-10-16 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-21 21:17:31 124.5 hrs 6890f81374137e085eb91d56 000015266 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14185 4a4498370c0e8de2fbefd6d9e6c6e259c8d94bb42979e48a1d7e97ca059345d3 68c86cab4948f4c9e89ba2d3 68c86ba8ac00672385161124 Anastazia Laubert Anastazia Laubert anastazija3@yahoo.com 019857 11 2025-10-16 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-22 16:50:10 143.8 hrs 68c86cab4948f4c9e89ba2ce 000019806 3.00 83.07 83.07 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14184 dd2fdd68b7b530fe9faaeb91333aceedcafd40d06600f6445d1783da24950610 68c309a8bc26280835c143f2 685c13569b296107804f0caa Judith Jessup Judith Jessup judyejessup@gmail.com 017520 21 2025-10-16 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Mark Leo Guevarra 2025-10-21 15:52:08 118.9 hrs 68c309a8bc26280835c143f1 000019548 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14183 ad31749084fd70ed0e97b8ce0eabef6d2c02512c316c29f397665167cb093b6d 687fa7f32c635307e83e500b 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 71 2025-10-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-16 17:26:11 0.4 hrs 68fbec26ae469ce1e5b923c6 000013762 3.00 82.00 65.60 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14182 44449ba222b2a9e20d6043fcba31762061e83e2799cdba9a4f6e54a12f8700c8 68503419837be607f33614aa 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-16 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 18:11:24 -2542.8 hrs 68503419837be607f3361486 000009378 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14181 d7dc3a988d19865c07f4330a409ba7bbc254d7b78f24ffacc79f704098b6017c 681cd1caa1cccbeccb5c6484 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-16 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 14:47:00 -2930.2 hrs 681cd1caa1cccbeccb5c6473 000004845 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14180 6a6f524555277b9cc4041d8e3af526754d447d9769dac933fa31a862757c82ee 67f80309fe9adc085a42c6f8 67ced5b57abf9f3ed8ff0562 Ann Strazdes Ann Strazdes ar-straz@comcast.net 014726 36 2025-10-16 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Jayvee Totanes 2025-10-22 15:31:56 142.5 hrs 67f80309fe9adc085a42c6f7 000001758 3.00 120.00 120.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14179 da03776edc077f55951f3518a9872723814e6bf974244363cad4f066b9717498 67e67177ceb9f104f028be4b 67ced41a7abf9f3ed8fec126 Betrah Mignerey Betrah Mignerey davidandbea2022@gmail.com 008906 230 2025-10-16 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton Pt conf cxl (Terri OUT) SL 5/2 Sophia L. 2025-05-02 16:25:21 -4008.6 hrs 67e67177ceb9f104f028be4a 000151654 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14178 67bb912a6565c8ae346109f8b24bc7f8fb0be984f73affb563195a492443575b 68db01d1f055f6a1acd406fe 67ced38d7abf9f3ed8fe9f00 Julie Heins Julie Heins itnotpa@comcast.net 005993 68 2025-10-16 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-10-16 17:23:29 0.1 hrs 68db01d1f055f6a1acd406fd 000021564 3.00 63.67 63.67 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14177 a9b7f6f842b4f415a89815019a73d4980f98a1905be201f164bd73ff9c55bb0a 68d5b7658f15a60a20f5aba1 68bb1405f45d4ebac1e95a47 Joelean Lambrecht Joelean Lambrecht jnjlambrecht@yahoo.com 019805 42 2025-10-16 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Amie Russell 2025-10-16 18:48:44 1.6 hrs 68d5b7658f15a60a20f5aba0 000021115 3.00 83.32 83.32 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14176 16bd2f67673adf0245ff931a5717bc21d6fde91c51f0235736fc3c256b37fafa 68d5836e60ea72f2ecd1feee 68645e432e36c3085ae44305 Karen Barr Karen Barr kndbarr@comcast.net 017559 37 2025-10-16 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Rayann Greer - Sophia L. 2025-10-17 15:10:40 21.9 hrs 68d5836e60ea72f2ecd1feed 000021041 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14175 f22029613845e17c2ccc34159ee3e4183921841482a64c590e4134bb6bd5bbe2 68d4326d3cda52f0bf26509f 67ced37d7abf9f3ed8fe9a50 Eileen Graziani Eileen Graziani emg4294@gmail.com 005593 28 2025-10-16 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-16 17:13:03 -0.0 hrs 68d4326d3cda52f0bf26509a 000020857 3.00 75.05 60.05 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14174 e2f456f630aa76f736a91b168fc43a4b2e0147a7157f62826003144418b43849 68c458b508d4084d87679228 67ced5e17abf9f3ed8ff0b2c Mary Walker Mary Walker mmwalker56@gmail.com 015220 55 2025-10-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-10-16 17:05:40 -0.2 hrs 68f139fb8be29c1be6843c4e 000019688 4.00 95.35 95.35 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14173 1cfe299fac5391cfcf1e50f29be5c3fef189654380d2fb68ecf7b3912c1a1419 68c2f1df32c6ff08a1aa6b5d 68c2f0a076aa2268b2f9d09d Samuel Dunlap Samuel Dunlap dunlapsamuel@gmail.com 019840 5 2025-10-16 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-21 17:20:15 120.1 hrs 68c2f1df32c6ff08a1aa6b5c 000019519 4.00 95.38 95.38 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14172 603d0a702c03277341ecdc335403eec233d1ef898bc008ce23e07e6089d4af99 687fb220b9dd07082f1d5e37 67ced5457abf9f3ed8fef541 Cynthia Ruggero Cynthia Ruggero cynthiaruggero@gmail.com 013351 76 2025-10-16 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-16 17:51:29 0.6 hrs 687fb220b9dd07082f1d5e31 000013796 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14171 ed1f816e1f65dc1a18455a97f26b4657a72e077097171fe55142233f30544be1 68d6eca2c33e1b22df1a48b2 68d6ebf70e300c08a947e01b Lauren Castleberry Lauren Castleberry luminescence.castleberry@gmail.com 019942 6 2025-10-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2025-10-16 18:00:50 0.5 hrs 68d6eca2c33e1b22df1a48ad 000021247 3.00 82.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14170 b46f6a22e0446ece1a3fa4e58cad69438744d75552a0ded32c55fc466cf47a2d 68b1fda920f9110849254db8 68b08a6f5b5e5507fe107464 Gay Hallaway Gay Hallaway gayhallaway@gmail.com 019773 9 2025-10-16 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 10/15 (waiting to see if her husband has covid) Sophia L. 2025-10-15 20:46:40 -20.7 hrs 68b1fda920f9110849254db7 000018236 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57
14169 d690a4daf837fa1a4d71476710d7720af6e947890190861c9ae424a7c86fdfa4 68af4a14ed830916f84dca45 682b4b4e58a15d07739d2f13 Jessica Rothman-Church Jessica Rothman-Church Jessie.rothman@gmail.com 017259 31 2025-10-16 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-16 17:51:25 0.4 hrs 68af4a14ed830916f84dca43 000017851 3.00 93.60 93.60 - - - - - - - - 2026-02-19 23:01:50 2026-05-07 23:27:57