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
17694 bd2b0a192688bf5e923a1158de14859c9bddc6ed6ac61bfa01173260d0ee3dda 68a62d91740f01d71660d389 68a62c8604293bb08fd8f2f0 Sarveswara Kilaparti Sarveswara Kilaparti raok46@hotmail.com 017862 7 2025-09-17 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ OOT- eg Sonya C. 2025-09-10 20:09:28 -163.8 hrs 68a62d91740f01d71660d388 000016981 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:23 2026-05-14 23:38:22
17693 f51f669fb90f2ffe7f9c9162b382b01bb9b5fc5a2f0edce627b9a687a2e0d462 6887e115ff7f7607d20a249e 6887e0669b77f5683408a822 Jack Miller Jack Miller jack.merrill.miller@gmail.com 017713 15 2025-09-17 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-20 16:47:43 -671.2 hrs 6887e115ff7f7607d20a2498 000014525 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:23 2026-05-14 23:38:22
17692 f15dae46af5529c03b7587863fbe8efb64c11cb12f6992707ec0308d07eeee67 6883a611f2acb3078cb839e3 686558bb1fc573aa62e2de35 Ashley Molner Hagan Ashley Molner Hagan ashleymolner303@gmail.com 017562 21 2025-09-17 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway cxl SL 8/27 Sophia L. 2025-08-27 15:38:04 -504.4 hrs 6883a611f2acb3078cb839e2 000014359 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:23 2026-05-14 23:38:22
17691 d26bdfd2e4cb87f05f2c4826c9fcfb666a99cb07904b59b12fec3c72fb62ae92 689e4467aef3094da565ec1b 689e43addbbb32078314153a Serena Parikh Serena Parikh serena.parikh@gmail.com 017801 6 2025-09-17 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-22 17:13:22 841.0 hrs 689e4467aef3094da565ec16 000016352 4.00 85.00 30.00 - - - - - - - - 2026-02-19 23:12:23 2026-05-14 23:38:22
17690 ed95d717272acde6db7e24f0be4dbe3e8d9cdbd78c9031aa19191c8e0a995bd0 68964f7d7b1ecd8e1e9f0b22 67ced4ad7abf9f3ed8fedcb2 Janis Peterson Janis Peterson janpeterson999@gmail.com 011256 87 2025-09-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-09-17 16:15:19 0.0 hrs 68964f7d7b1ecd8e1e9f0b21 000015851 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:12:23 2026-05-14 23:38:22
17689 5659221d5ee9368ae49fe7aa889e2314972e722da9b4f2cbacdcfd861c8be30c 68962d6600ab350851b9cd7f 680bde8d57993d49943a47b6 Joyce Craig Joyce Craig joycecraig0@icloud.com 017136 9 2025-09-17 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Anne Palma 2025-09-18 15:56:50 23.7 hrs 68962d6600ab350851b9cd7e 000015813 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17688 5738924afd3e4767b00de4bfcbd5160f4532dc7a16dd5578ccbc545edc699353 68813a2db430e30821f77770 67ced3757abf9f3ed8fe97aa Margaret Harsh Margaret Harsh aharsh@comcast.net 005367 152 2025-09-17 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-17 16:12:01 -0.0 hrs 68813a2db430e30821f7776f 000014072 4.00 119.56 119.56 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17687 53a8bb0e3033e7c17335b0c0e827b8fc0d948c4cad8f20c82eb3515522cd029b 687024464dfe9f080b049484 67ced2f87abf9f3ed8fe651a Bruce Carpenter Bruce Carpenter bruceacarp@hotmail.com 001053 125 2025-09-17 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Peter Gagnon 2025-09-17 20:35:11 4.3 hrs 687024464dfe9f080b04947c 000012522 4.00 104.99 104.99 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17686 ee2b650f0d8903478dfbd0185e3a6b497b443b57f9a60c33ac14122a0d66d87a 681d30957a9079578faff6a8 681d2f9b3cdcef7020e41713 Andrea Hsue Andrea Hsue andrea.hsue@gmail.com 017207 7 2025-09-17 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-06 16:45:54 -1007.5 hrs 681d30957a9079578faff6a3 000004986 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17685 4008892fd56f1c56db1e4d02623e956c2f06f0d08a7baff9123b70fff937d25e 68a391252db0500861e6d492 68a390322dac430785c21ed1 Serena Randolph Serena Randolph serena.randolph@gmail.com 017817 16 2025-09-17 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-19 20:15:42 -692.2 hrs 68a391252db0500861e6d48e 000016588 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17684 502189241fcb695d8b3ae4b233ee1ac1244dae1074a3d3eb2dbf57db16f78fb3 6895099333db0507968ac661 67ced5267abf9f3ed8fef0a3 Richard Schwolsky Richard Schwolsky rickschwolsky@gmail.com 012957 27 2025-09-17 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Michelle W. - Sophia L. 2025-09-17 16:19:00 -0.2 hrs 6895099333db0507968ac660 000015741 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17683 f50c1e8f46202a20f4f378ee11eb3e2dfb29e645b006857653d2112ddbfb5f83 68892fe8206b14081a47adb8 67ced3d37abf9f3ed8feb184 Christine Kemp Christine Kemp christywkemp@gmail.com 007573 138 2025-09-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-26 21:47:11 221.3 hrs 68892fe8206b14081a47adb0 000014663 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17682 74de2fd7f8e97eab657b2bae9b855de44570ec10e53ce7ab82096d6452533542 685c12ba483c0807ae1dee3e 67ced3027abf9f3ed8fe6b77 Brenda Damek Brenda Damek 9bdamek@gmail.com 001596 117 2025-09-17 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Anne Palma 2025-09-19 16:51:45 48.4 hrs 685c12ba483c0807ae1dee35 000010677 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17681 46dbdde47f9d219644a79662a6cb6d4357bd940228b46a19a6ba2476f8319680 688b95d770b54993569cc825 688b939d7cd0650800dda926 Donna Colville Donna Colville draye@comcast.net 017730 13 2025-09-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-17 16:43:19 -0.0 hrs 688b95d770b54993569cc824 000014929 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17680 27dfb8c39a348a3e3ba62b3c16abfc97b22b5b9fe386a45ba2f154a24af6e26b 686c2022b3bb996dd0be45f3 67ced52e7abf9f3ed8fef1db Andrea Sedlmayr Andrea Sedlmayr andreasedlmayr@gmail.com 013061 92 2025-09-17 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Rosey Reed 2025-09-17 16:46:15 0.0 hrs 686c2022b3bb996dd0be45f2 000011926 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17679 c38c79254a7738ee846bfecc8e566a2ef13dc32022616c9cda431ed3ccf5b710 68a4eb933547c7f87936f32e 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-09-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-26 22:12:51 221.2 hrs 68a4eb933547c7f87936f32c 000016800 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17678 3c57f4075f3b6f8cbcaade53b2ec17e1de029ef38f3125ba5293fbdf585e3ead 68936759e6efb17aca77c2f8 689365ced7634722d0ef3bf4 Elizabeth Patterson Elizabeth Patterson betsy@b2bdirect-shop.com 017760 12 2025-09-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-17 17:05:16 0.1 hrs 68f7b889145c70536f2c8239 000015477 2.00 60.00 40.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17677 bb53fdd105a8f31a487f5744eb6d013cac6893ae3cbf45d0d7a425468a34ed1a 688253c32483cc07c80de5f8 67ced4a77abf9f3ed8fedbb6 Anne Peters Anne Peters annep@indra.com 011172 36 2025-09-17 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Ranjini Ridgway - Rosey Reed 2025-09-17 17:03:26 0.1 hrs 688253c32483cc07c80de5f7 000014179 3.00 85.00 55.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17676 12d4788e1a542a7b69eb155566382661251cc24cbdd91a4f99d333a4855463d4 687967fbcf7d36a70c8b54ab 67ced3637abf9f3ed8fe9201 Kelsey Goeke Kelsey Goeke kj.goeke@gmail.com 004884 55 2025-09-17 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Sophia L. 2025-09-17 16:58:25 -0.0 hrs 687967fbcf7d36a70c8b54aa 000013443 3.00 74.12 74.12 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17675 77966dc4508c086c7bae263aacb2a66278affdb7a4f406822427845983701bab 686576993d3d9107ae11f5bf 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-17 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Michelle W. 2025-09-15 17:37:11 -47.4 hrs 686576993d3d9107ae11f5b3 000011637 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17674 04d0104d75c34eb0d3013bbafc891fb9df8ae1189543aef13a48f42c2c266e17 68654db36a815107e43464dd 68654cf5f52fec1ae7e5a0a4 Selene Luna Selene Luna selenelh@gmail.com 017561 9 2025-09-17 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per email request - she is ill - sc Sonya C. 2025-09-17 14:49:44 -2.2 hrs 68654db36a815107e43464d8 000011580 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17673 175aacf860d9b6f82ad6e7bc0590b4f11abfe5a8070f3787e2fc070b680fc17b 68b9cdb883a4e3d02532d1f9 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2025-09-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-09-17 17:11:57 -0.1 hrs 68b9cdb883a4e3d02532d1f8 000018712 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17672 986b37c2d8a3d4f869451e9e3d471c6078daed6b38bce9fa0e269e2ca394f26d 68a4c82a5a7df808732b5b18 687f9c7e8a0f42fc75c880a5 Miriam Glick Miriam Glick miapta@me.com 017669 11 2025-09-17 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt confirmed CXL, RXL to 10/1 - RAR 9/4 Rosey Reed 2025-09-04 17:28:44 -311.8 hrs 68a4c82a5a7df808732b5b17 000016739 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17671 8aba89a1dad80f61dd8d4c0b819b3f0d385b57cb7f1dc806f05f4bde9dfe1476 687029ec3f99eb652ea21bfe 685c13569b296107804f0caa Judith Jessup Judith Jessup judyejessup@gmail.com 017520 21 2025-09-17 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 21:09:22 843.9 hrs 687029ec3f99eb652ea21bfd 000012537 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22
17670 a274a9611a88d9b27832f74fd42bad11af3eff6cc2316af3e6684164e04cc238 68c1c22b03e7bfb450ea370c 68a8156c99c65c4a78a604a3 Michael Platt Michael Platt mnmplatt@comcast.net 019205 4 2025-09-17 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Jayson Encarnacion 2025-09-25 19:35:28 194.1 hrs 68c1c22b03e7bfb450ea370b 000019415 3.00 85.00 110.50 - - - - - - - - 2026-02-19 23:12:22 2026-05-14 23:38:22