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
16741 0df3ea1c3dbb9689e432cc5b4f9d2c5db7e8a9ee15e169ea4cd60bbbac6c55df 68b9eeeddf173f0e609eb03b 67ced40c7abf9f3ed8febe36 Robert Lee Robert Lee rob.lee@gmail.com 008656 87 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-09-25 17:28:05 20.5 hrs 68b9eeeddf173f0e609eb03a 000018758 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16740 336700f928abec277d8b527a212938badd438bbcc56772d117d68a0693605d6d 68a7825fc482418b478c6f8a 67ced4937abf9f3ed8fed847 Bonnie Neighbors Bonnie Neighbors neighbor@colorado.edu 010879 68 2025-09-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Samantha Saunders pushed back to the next week Samantha Saunders 2025-09-04 14:47:42 -486.2 hrs 68a7825fc482418b478c6f89 000017158 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16739 042666713a773e4e00c1332fbb5c67897470b963159639deefe9b4efaf13139f 68a62dc9e41064d554db0741 68a62c8604293bb08fd8f2f0 Sarveswara Kilaparti Sarveswara Kilaparti raok46@hotmail.com 017862 7 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sophia L. - Mark Leo Guevarra 2025-09-25 18:30:49 21.5 hrs 68a62dc9e41064d554db0740 000016982 3.00 235.00 20.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16738 6b68782c77e30394a16438d2195ea139bf51a6204140810e7d7911f2eaa98cb8 6893d5b2e6efb17aca7b2265 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-24 21:02:04 0.0 hrs 6893d5b2e6efb17aca7b2264 000015659 2.00 66.06 66.06 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16737 825d8c9bc65fd6e9a092ca1bc5a54d4fe7da7a2c9b4c97c7a87c59b4065daf22 67e67194ceb9f104f028c5bb 67ced5bb7abf9f3ed8ff0628 Rebekah Venturella Rebekah Venturella beka.venturella@pm.me 014792 112 2025-09-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-09-24 21:40:13 0.7 hrs 67e67194ceb9f104f028c5ba 000151699 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16736 a28bba98a49953ccdf870a6b036fde051a5b5e5aaf20ac8cbb3df193d2a8b35e 68c33563242f902570f1986d 67ced5907abf9f3ed8ff0026 Nancy Stevens Nancy Stevens av8ors1@comcast.net 014280 46 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-09-24 21:17:19 0.0 hrs 68c33563242f902570f1986c 000019600 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16735 3bead8f2c06ff0702ca2bf5da6e9a31b652800b3aa7a3c3ad340ddaaba4abb07 689cb45ffce9e5085f9b1660 687f9e82b97ebc089bb4e419 Robert Glick Robert Glick rglick@kaufmanrossin.com 017670 15 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-06 19:00:43 285.8 hrs 689cb45ffce9e5085f9b165e 000016149 3.00 81.46 80.29 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16734 6f3060cbc4b79683272b253ab9f2ce28dada90333e0b279148b21a07344cd3ff 68af28436d5d6587269b92ca 68af26869840478ac34147ca Karlota Estevan Karlota Estevan karlesbee@gmail.com 019755 19 2025-09-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-24 22:21:13 0.9 hrs 68af28436d5d6587269b92c6 000017746 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16733 9b79f596dcb65ba4801a91e59461bdbcd97429a939623914b7f995888431f2f3 689510071d2a819c6a5dd906 67ced33b7abf9f3ed8fe83c2 Brandon Cornacchione Brandon Cornacchione mscornacchione1963@gmail.com 003669 115 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-24 21:32:39 0.0 hrs 689510071d2a819c6a5dd905 000015757 1.00 76.00 92.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16732 8d4835040f3f43cf1dc337ae3c84bdd1c99135f94dd19855c502f461dce87c9e 687a6877131290f381d5828b 67ced65e7abf9f3ed8ff1b2e Cathy Zimmerman Cathy Zimmerman cathyzimmerman9@gmail.com 016585 99 2025-09-24 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conflict - RAR 9/22 Rosey Reed 2025-09-22 14:46:00 -54.7 hrs 687a6877131290f381d5828a 000013486 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16731 e4c16238afb09d8e5428d8939a950f4b41a17128bcd278ec54468def923b5d81 68236e6a9e4bc9d0a4a1cd3d 67ced4d67abf9f3ed8fee3a9 Benjamin Prieb Benjamin Prieb benprieb@gmail.com 011850 123 2025-09-24 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-09-15 14:15:02 -223.2 hrs 68236e6a9e4bc9d0a4a1cd3c 000005365 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16730 682c5947252e665879440142b77ab2be8306c1444333bfc552460db403d82b82 683f7e03c24621080614c3d4 67ced5937abf9f3ed8ff0095 Mikayla Sanford Mikayla Sanford mandarava1616@yahoo.com 014317 21 2025-09-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-04-16 15:34:53 4889.8 hrs 683f7e03c24621080614c3d3 000008076 4.00 95.00 95.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16729 161dbbc91548e12e88aeae909c63cc00b2cf482fcf548174a5c538d94f7dafb3 68cb483320b7377d32ee6226 68a78ce7ebc257d19f0a55ea Heather Pujet Heather Pujet hpujet@yahoo.com 017895 39 2025-09-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Partially Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-09-25 18:48:13 20.8 hrs 68e92b5e1265100918c0155d 000020098 3.00 80.00 64.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16728 4af9ae2eb24c2ea0c585ac833b71efbd3ca64a25582234b34ad99812fea7016e 68af32f49cee45616790ce1f 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Jayson Encarnacion 2025-09-29 22:26:14 120.4 hrs 68af32f49cee45616790ce1e 000017780 3.00 38.45 60.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16727 1f3e670d3278c8e2aa8f725adf869122bf598a8a28fcedd36e7b279ffdc04da4 689cb4c93e4d6e07cc0db470 687f9e82b97ebc089bb4e419 Robert Glick Robert Glick rglick@kaufmanrossin.com 017670 15 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-06 21:26:54 287.4 hrs 689cb4c93e4d6e07cc0db46f 000016151 3.00 83.53 81.85 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16726 e4cd390cf35f317fde260704e1af321676b1b9199b07691febd839e3bfa260a2 688157cc03a4d7344f53e14e 67ced5ff7abf9f3ed8ff0f01 Mike Watson Mike Watson watsonnmw@gmail.com 015547 58 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 22:07:30 0.1 hrs 68e3e18a93a90a072c7954fa 000014136 2.00 56.79 56.79 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16725 b98f18ea1c5c6ffaf8f16bc07d5ec673d3927703c3cd4d90a69a67ed196a915a 688157708ab3740e35e5971a 67ced5fb7abf9f3ed8ff0e8c Mark Warter Mark Warter wartersrmark@yahoo.com 015508 41 2025-09-24 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-23 21:44:16 -1512.3 hrs 688157708ab3740e35e59717 000014133 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16724 0235994be896e16c42adcb8a3411d14d5f8e88dfe10256313bbee404b8c3ad39 687fb4ba714ebffc971aa874 67ed60f7a96d94932e899c54 Sheila Freehill Sheila Freehill scf429@gmail.com 016962 27 2025-09-24 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. patient going to every other week John Phinney 2025-09-17 22:30:50 -167.5 hrs 687fb4ba714ebffc971aa86f 000013808 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16723 01c935dcd24383a4423d4e9584c73aa07fa2f8258f2a30b8630bc330af189ebb 68a79bfbc482418b478d2902 67ced3b87abf9f3ed8feaa94 Alisa Hammond Alisa Hammond ali.hammond10@gmail.com 006981 16 2025-09-24 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips 24+ dealing w/ dog emergency- sc Sonya C. 2025-09-23 22:50:51 -23.4 hrs 68a79bfbc482418b478d2901 000017173 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16722 107a0a97842e634b8e79096b5df15e07550fbf77957cf5e8a9539b01b3f784f8 68cdb17ba295d1fb954b6e32 68927a5581dca5077cc2ae98 Dianne Inglis Dianne Inglis Diannecinglis@icloud.com 017757 30 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Peter Gagnon - Rosey Reed 2025-09-24 22:31:11 0.0 hrs 68cdb17ba295d1fb954b6e31 000020352 3.00 85.58 64.31 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16721 a060bf10f7d1c53cd7007fc372fdac4b9ea408e61dc99a8f50180fc5e29d4f52 68ba0689b7c6a220e8b922dd 67ced4de7abf9f3ed8fee50b Donna Racette Donna Racette donnaracette@yahoo.com 011968 89 2025-09-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Laura Shove - Laura Shove 2025-09-24 22:57:59 0.5 hrs 68ba0689b7c6a220e8b922dc 000018799 3.00 78.70 69.59 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16720 24cd956aa7d68030c74ae88638a1d79f68bd1f47aeb6ee34372fb7bed54f491e 68b761d22258772b59f0549f 682b8a7975b13d086afa7ef7 Gayla Weber Gayla Weber rjgdw83@gmail.com 017263 17 2025-09-24 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. not needed Michelle Osgood 2025-09-22 20:23:53 -50.1 hrs 68b761d22258772b59f0549e 000018416 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16719 2543413b226e9a6301e10d4ef506e2838c2033fcf8742c4874cf85098d958304 68b0b53ce0928300d23ebf23 67ced3ac7abf9f3ed8fea74f Jodi Hai Jodi Hai jodihai@mac.com 006702 12 2025-09-24 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ due to infection from foot surgery- sc Sonya C. 2025-09-22 14:14:38 -56.3 hrs 68b0b53ce0928300d23ebf22 000018069 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-05-13 23:34:47
16718 61573538b93c8f182db3629426b595648c9d8acd1d27a563f5b2e44c203cd498 689280597f3e617ebd4d4e64 67ced3a37abf9f3ed8fea4fa Sarah Hernandez Sarah Hernandez hernandez_sarah@svvsd.org 006503 90 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 23:12:43 0.7 hrs 689280597f3e617ebd4d4e63 000015449 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:34 2026-05-13 23:34:47
16717 1132fa3c0640862c8fb5de106a76911a488e8ed2231bccfd7045c9f2e3354fb1 68791899028afa590ad56061 67ced35a7abf9f3ed8fe8f01 Marilyn Fausset Marilyn Fausset mbrownfausset@comcast.net 004628 32 2025-09-24 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. surgery Laura Shove 2025-08-12 20:54:01 -1033.6 hrs 68791899028afa590ad56060 000013321 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-05-13 23:34:46