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
18024 201b85b137d1721b12ede6fba19e0a85ff156732bf1c859830840fb33976476a 6864605cc5ec6007f6185079 68645e432e36c3085ae44305 Karen Barr Karen Barr kndbarr@comcast.net 017559 37 2025-09-15 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Dawn Singleton 2025-08-27 17:29:11 -455.8 hrs 6864605cc5ec6007f6185075 000011532 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:30 2026-05-14 23:39:24
18023 e093fd72f6d9256a4fd3e24c01f6188c1e5778746f918345bed8a4f1eb4e8e13 68c1a89418d95890db43ac33 6880f33f283f2e0843200752 Mandi Hutson Mandi Hutson mandihutson22@gmail.com 017678 13 2025-09-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-16 17:52:09 744.4 hrs 68c1a89418d95890db43ac32 000019391 3.00 233.00 20.00 - - - - - - - - 2026-02-19 23:13:30 2026-05-14 23:39:24
18022 07668e69adb4fa0049c289d64760dcfcc0e2d6468ea65d2ad36b289d23cb8179 68b74863f1184c07cdbae7a9 6892804cdc7aae36c53de6cf Deborah Mack Deborah Mack dmack9225@gmail.com 017758 7 2025-09-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Sonya C. 2025-09-15 17:31:22 0.0 hrs 68e830217b255af6244a5210 000018371 3.00 79.51 79.51 - - - - - - - - 2026-02-19 23:13:30 2026-05-14 23:39:24
18021 28f4b22e890d84685fe0c53c0e6b532315ddac9c688bd3c2f80adbd2ed56c674 68b081240576ba875dff00dd 67e1258854aaaa3a80096c03 Nina Nilsen Nina Nilsen ninarae21@gmail.com 016713 47 2025-09-15 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9.10 Sophia L. 2025-09-10 16:27:03 -121.0 hrs 68b081240576ba875dff00da 000017983 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:30 2026-05-14 23:39:24
18020 bbfdee5f959824ce43f58edb7dd95a80b1a84d738000145be1b64ed9707907ee 689bc6261cd63c07b7143995 689bc4d51cd63c07b71432cf Nicole Weber Nicole Weber nic.weber23@gmail.com 017788 6 2025-09-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Peter Gagnon 2025-09-15 19:33:22 2.1 hrs 689bc6261cd63c07b7143994 000016110 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:13:30 2026-05-14 23:39:24
18019 5972c3986701e6b75e3d298aa7eadc8b7a7c4d36045fb6c02065dd2585ec6e25 68b724111f3ba2a2923568ec 683e2243b8ecd2c9d651a06e Marshall Frech Marshall Frech mfrech@tec.org 017372 43 2025-09-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-09-15 18:03:35 0.3 hrs 68b724111f3ba2a2923568eb 000018349 3.00 83.74 83.74 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18018 b8cd659c0e164d976158822826f164de08343528c869f5a4ea5052f21ba68e71 68ac6e9a7c18ca215f79e55d 67ced6197abf9f3ed8ff1278 Alexandra Toland Alexandra Toland alexandrangary@gmail.com 015842 9 2025-09-15 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ can't find childcare- sc Sonya C. 2025-08-28 16:54:53 -432.8 hrs 68ac6e9a7c18ca215f79e55c 000017347 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18017 0466e7bdb1d812835b09710f3eed167c205a8f0f5a066e4d0e6a25ba30273526 68922b353cd9c10821d2d3f0 67f930bb1efdbe082144ceef Wendy Sewell Wendy Sewell wendysewell30@hotmail.com 017035 12 2025-09-15 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-16 19:22:58 745.6 hrs 68922b353cd9c10821d2d3ef 000015379 4.00 95.55 95.55 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18016 5f6c9318b78c988d9ab464de4ce318b047809a8028823bfbf471e4124b8f6a88 68b720057fb2a69d2f35bddc 67ced2ee7abf9f3ed8fe5ddc Raquel Cagan Raquel Cagan raquelsfishing@yahoo.com 000435 220 2025-09-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Michelle Osgood 2025-09-15 18:12:41 0.2 hrs 68b720057fb2a69d2f35bddb 000018344 3.00 66.44 66.44 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18015 121aafb8da9719436b6af861aec88f8cbaf0475d2d74a033674502f82b42b284 68a74decdc17cac45cc9eb62 68a5f331cc00ec0894e708c3 Sandra Squires Sandra Squires ssquires2@comcast.net 017835 32 2025-09-15 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Amie Russell 2025-09-15 02:59:07 -15.0 hrs 68a74decdc17cac45cc9eb61 000017069 3.00 75.05 75.05 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18014 232327c89dcb2154687f98e752113526745526d71a78999928d1d99fe923799f 68766249f040d77fff544d03 67ced3e67abf9f3ed8feb5f5 John Knight John Knight jknight2207@gmail.com 007952 52 2025-09-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-09-15 18:04:02 0.1 hrs 68e7dbf9af0c7dedfbde5a7d 000012934 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18013 978e544849ae512402754fafa14b9c248643edb64fa8b130e45e1c3b583468d5 68757ba79bfe5c07af7f24f8 67ced3067abf9f3ed8fe6d15 Deborah Appel Deborah Appel debbie2175@me.com 001734 90 2025-09-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-09-15 17:59:34 -0.0 hrs 68757ba79bfe5c07af7f24f7 000012879 3.00 81.40 64.85 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18012 edea0ce2a2bd3946c946dea49850915e140a52419ce73595c3d87e440df8f5a4 68a485604eb9b00d9157d7c2 67ced46a7abf9f3ed8fed0c7 Erris McCullough Erris McCullough errism@hotmail.com 010239 51 2025-09-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-15 18:08:38 -0.1 hrs 68a485604eb9b00d9157d7be 000016646 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18011 69b56f77646018f8b6c9a091e8f47140c18a1f0387973b0d8425c72db8e4c88d 68af32a2f7f9190791314370 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-09-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 9/2 Sophia L. 2025-09-02 16:15:54 -314.2 hrs 68af32a2f7f919079131436f 000017772 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18010 2670c8c2d5bceec3a0930e7d63b6ddc11046041556064d695f9c0356e1396169 68ae136e65f1522769631095 68ae120ff065ca9b12380486 Melinie Feldman Melinie Feldman melinie9@hotmail.com 019747 6 2025-09-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Michelle W. - Sonya C. 2025-09-15 18:27:28 -0.0 hrs 68ae136e65f1522769631094 000017623 4.00 95.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18009 2da50c722f3242b58ecda4af5861aa7b63df401951c05d3318cc37e0290545dd 68acb86ca843ece4c2207933 67ced3d37abf9f3ed8feb172 Melinda Kelsey Melinda Kelsey fmkelsey@icloud.com 007567 26 2025-09-15 Checked Out 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-09-15 18:23:22 -0.1 hrs 68acb86ca843ece4c2207932 000017439 5.00 189.65 189.65 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18008 0d66a6598c30b4a419bee84db52932af99f33c5d3148697d8fd99e4fbb7fea1e 689cfff2a4ac92110d30cb5e 689cff4d0ade0a0778a53f93 Fabio Stefani Fabio Stefani fabiostefani@yahoo.com 017793 7 2025-09-15 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 12:05 Patient cxl appt -eg Sonya C. 2025-09-15 18:06:45 -0.4 hrs 689cfff2a4ac92110d30cb59 000016214 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:24
18007 0b8ab23420b5244aab49960363cffbfbd22265fb3d00bb0aade569635ca258b2 6887bb3ab91e65374119de17 67ced5a37abf9f3ed8ff02d8 Aaron Stoddard Aaron Stoddard builderaaron@hotmail.com 014510 125 2025-09-15 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. cx Samantha Saunders 2025-09-08 20:33:12 -165.9 hrs 6887bb3ab91e65374119de0f 000014492 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18006 8fdfe16093de51b67be90a99c30645b4180a5c9896ab3a28461c26044ea04c92 688265a746f8d8088731ba01 688264075e8fbc07f3eb5175 Renee Shires Renee Shires reneeshires1@gmail.com 017698 5 2025-09-15 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 681139689cd6a804651d51e6 Medicare Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+- her daughter has stage 4 cancer and she only wants to focus on her - sc Sonya C. 2025-09-15 15:08:29 -3.4 hrs 688265a746f8d8088731ba00 000014225 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18005 e5e4c5570e4156ab54e560cc251edaf0e4bb2d619f24edc69e8e47825ef763b6 687fa52e75c94e089c6c3e79 67ced3587abf9f3ed8fe8e59 Rosemary Getsie Rosemary Getsie rgetsie@comcast.net 004572 33 2025-09-15 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-17 14:17:11 763.8 hrs 687fa52e75c94e089c6c3e78 000013755 3.00 83.15 103.15 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18004 8bf7933c4f6832d7c3fb67f11851594888d6be2c40802f250ce637afcb7be5c9 68b759f39fdd2fd411959b6c 68ae64da9fc64ffe78db79bd Amanda Cadran Amanda Cadran yourphdj@gmail.com 019751 7 2025-09-15 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Amie Russell - Frances Lawrence 2025-09-15 14:58:06 -3.8 hrs 68b759f39fdd2fd411959b6b 000018407 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18003 8e743c53728ecb269bb87570d05553d149334e0dd96530c025216687a8f12662 6876b835e3c34b077d805435 67ced3307abf9f3ed8fe7f45 William Burlage William Burlage burlagebill@gmail.com 003286 59 2025-09-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Peter Gagnon 2025-09-15 19:32:40 0.8 hrs 68c99da5a608d207f81a9915 000013065 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18002 50da9b281b37ddb46992ff97f36097edec574f5e7b7c6aaae2830d5597e56bc1 68b888205f1b5c0ef6eb8473 67ced2e97abf9f3ed8fe5aeb Charles Berginc Charles Berginc berginc4@gmail.com 000184 42 2025-09-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-15 18:47:07 -0.2 hrs 68e55a421d467808b50e996f 000018537 2.00 102.92 102.92 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18001 3904b8ec3b0be255067395da539f8b8d2aa10c2e74dd3f5e12cf27f383ab2293 68b09b3ded830916f854e5d1 688255ba5e228bca59d9813c Kelsey Mammen Kelsey Mammen kelseymammen@gmail.com 017697 15 2025-09-15 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-17 20:34:47 769.6 hrs 68b09b3ded830916f854e5d0 000018049 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09
18000 239c541dd3d083d6f2982a94984fa89e5ee4d0ba14b944d0994a9164314fef19 68ac843fd0ec2f07df6a5f9a 68ac83ebd0ec2f07df6a5cbf Paik Saber Paik Saber psaber@gmail.com 019735 7 2025-09-15 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Jayson Encarnacion 2025-09-25 17:33:42 238.6 hrs 68ac843fd0ec2f07df6a5f99 000017366 3.00 236.00 30.00 - - - - - - - - 2026-02-19 23:13:13 2026-05-14 23:39:09