General Visit (PT Boulder API)

Total rows: 100,380
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
8789 2687041845a628a01261b290cf17ea8215afede5e32fa7e441ec92895dd7643a 68f02278fd28a112b9dc57f9 67ced4867abf9f3ed8fed5dd Rachel Mclaughlin Rachel Mclaughlin rleighmac@gmail.com 010673 49 2025-12-03 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed <24 snowed into house - RAR 12/3 Rosey Reed 2025-12-03 23:27:16 0.5 hrs 68f02278fd28a112b9dc57f8 000023688 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8788 5a6bc6cd261f16a69c0d05254130a164045a84399403f7a3d57a382f518b791f 691e63feb287efddc7e1a0d9 68a78ce7ebc257d19f0a55ea Heather Pujet Heather Pujet hpujet@yahoo.com 017895 39 2025-12-03 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Partially Paid - Patient - - Yes Julie Petersen-Hanson - Kenneth Dave Francisco 2025-12-08 21:54:11 118.7 hrs 69374936d50c3a96b0b41932 000027866 3.00 82.00 81.60 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8787 a7fe115db5acfa9642e2bc12922d2f7c35e18c7d131eafb54901230169c29d05 692fb29bbc49f7c22ef4ff32 67ced58b7abf9f3ed8feff8a Rocio Sanchez Rocio Sanchez chiosanchez009@icloud.com 014228 4 2025-12-03 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Peter Gagnon - Mark Leo Guevarra 2026-01-09 15:34:09 880.1 hrs 692fb29bbc49f7c22ef4ff31 000029485 4.00 313.00 55.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8786 e9c86d1848656b883bc721b14b1c17d5ef479130b4b27cdaa96f8d3154541fcc 6914eced64449147db06d869 67ced5797abf9f3ed8fefd02 Theresa Simmons-Smith Theresa Simmons-Smith smithtess444@aol.com 014012 102 2025-12-03 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed <24 pt concerned about snow (no fee) - RAR 12/3 Rosey Reed 2025-12-03 19:23:34 -4.1 hrs 6914eced64449147db06d868 000027011 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8785 b6d37811d5610c37b20864c784eb4aea7bd4eb5f454d0dfa089450cd4e862d75 690b7b844e3dafd57beb7d37 68c305022f90278f35c47313 Glenn Lieberman Glenn Lieberman glennlieberman@gmail.com 019841 17 2025-12-03 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed pt ok's the cxl via text --mw Michelle W. 2025-11-19 21:20:24 -338.2 hrs 690b7b844e3dafd57beb7d36 000026107 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8784 1fd869b368625089da192554076c44dc8ad333af10761a88dda10025c2753189 68e5816f87beda41c8cdfd4b 67ced5d87abf9f3ed8ff0a06 Djenita Svinjar Djenita Svinjar djenitasvinjar@gmail.com 015122 26 2025-12-03 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed <24 pt sick - RAR 12/3 Rosey Reed 2025-12-03 19:13:32 -4.3 hrs 68e5816f87beda41c8cdfd4a 000022619 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
8783 b3120c059a6538cc044917a19e587273b926cb9997385ef68c493f0482a1f8e7 68f935c08d45872989f106fb 68f93537df9ca66caffc6b37 Elizabeth Basiliere Elizabeth Basiliere ewarfield21@yahoo.com 020129 8 2025-12-03 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-12-08 17:24:11 113.7 hrs 68f935c08d45872989f106fa 000024433 3.00 130.00 130.00 - - - - - - - - 2026-02-19 22:46:46 2026-05-04 23:12:14
9128 f9f5403b905698de427092292ef0fc4b6381ecacee0ac30974acaf753356254d 6924aedddad60887a09df101 69160f6351c428d308c9ac08 Norman Chapin Norman Chapin machisapin@gmail.com 020240 20 2025-12-02 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Mark Leo Guevarra 2026-01-09 14:58:14 927.0 hrs 6924aedddad60887a09df100 000028211 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9127 ac73c2fe26e8d68b4e580ce7d20fce5e4373370439d6dd111f0502358e4e9d99 68f262ffae502f08ad734607 68f2621eb72986f10f1c33e8 Sina Anderson Sina Anderson neil.anderson@bvsd.org 020096 11 2025-12-02 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per VM - school conflict - sc Sonya C. 2025-12-01 22:06:08 -1.9 hrs 68f262ffae502f08ad7345fe 000023872 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9126 c323fdf584c1d2282beaf3a13448fdc8fa0250c43b3dfa49ffb76f47fa58e922 68ed7eca2d650ff5a2a86ae7 68ded20454a35609b86ec324 Claudina Chun Claudina Chun anjelsmom@gmail.com 019979 9 2025-12-02 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 11/25 Sophia L. 2025-11-25 15:31:39 -166.5 hrs 68ed7eca2d650ff5a2a86ae2 000023263 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9125 7c2b0f1a679b17fbf010b28fbde3563c05a441d7cd76d67f353969abebdeb560 68e81bedfbf1fa711696ed8c 68e81a8fab9a7ae9c33ea0cd Malia Eastman Malia Eastman mgeas@umich.edu 020039 4 2025-12-02 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 10/9 (got in at another PT Sooner) Sophia L. 2025-10-09 21:39:00 -1288.3 hrs 68e81bedfbf1fa711696ed8b 000022978 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9124 2779b967f261595ac8fed6c79585ff288c977a2dfe7680f258f80c3a44fc86eb 69262556138a0db7c19cbdc5 68e57af5c6de800a27aad5e0 Ronald Richter Ronald Richter ron.richter4353@gmail.com 020008 6 2025-12-02 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-12-04 21:48:46 55.6 hrs 69262556138a0db7c19cbdc4 000028895 3.00 93.89 93.89 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9123 25db1197870a628ab166ff82867068113ca1362165e946e4abcbd2af57885ad8 690a59fff620b15c07474643 67ced5057abf9f3ed8feeb78 Scott Schaefle Scott Schaefle sschaefle@hotmail.com 012516 22 2025-12-02 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Terri Nishimoto - Jayson Encarnacion 2025-12-08 19:46:00 149.5 hrs 690a59fff620b15c07474642 000026010 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9122 43ff327b5204137c1127849f1f58a1511087859c777c2846f9ed6bf46f476fb0 6900c96ee143c708f31ccd14 67ced3847abf9f3ed8fe9c87 Johanna Heart Johanna Heart jandsheart@msn.com 005782 59 2025-12-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Samantha Saunders 2025-12-02 14:41:29 0.4 hrs 6900c96ee143c708f31ccd13 000024995 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9121 29bad88ac321c9df6aed9fdbf9b872d56aa129b2a85d8fde7e5eae45e2952c54 691ddabf5fe65968213fcdbb 68c1dc28339acc472f869398 Christopher Duhon Christopher Duhon cbduhon@gmail.com 019835 19 2025-12-02 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-12-05 22:48:50 80.3 hrs 691ddabf5fe65968213fcdba 000027704 4.00 85.00 105.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9120 86b5e563bc251fedf4af8938cd3643417ba5485a7e174172b8012f027ebaa02d 690b8699baaaae6a179c20fa 6849f7006ff022082b99f459 Julie Chang Julie Chang changj@groudan.net 017439 10 2025-12-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed out of town Michelle Osgood 2025-11-18 16:03:09 -334.4 hrs 690b8699baaaae6a179c20f9 000026122 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9119 3578cbfa1c435c81842249a511c77b5e4fcb7d8faf3ddd01244cf71a6b75d7fd 6900ca0be8d8cb095c428210 67ced3f57abf9f3ed8feb95c Stefanie Kyser Stefanie Kyser steffpedals@gmail.com 008242 51 2025-12-02 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Jayson Encarnacion 2025-12-08 18:30:19 148.0 hrs 6937197d0d408d488687c2b6 000024998 1.00 80.00 80.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9118 43655d8226b31d3dbe0d211f838b463ea49ab55dcb7d7856fbc473bf38d2d056 68e964f8298ec2097844ab5c 67ced5bd7abf9f3ed8ff0679 Robert Verfurth Robert Verfurth robertverfurth@gmail.com 014819 59 2025-12-02 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-12-02 15:44:22 1.2 hrs 68e964f8298ec2097844ab5b 000023101 3.00 147.42 147.42 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9117 f1b60c79a5b69cff774e550a5da9a29f442c40547d4a00e73c1d1c11fdce8aeb 68d45ad1a5c7e586abe121f0 6830d97a8a3a1f52914c8969 Ara Springer Ara Springer noelnevers@gmail.com 017307 22 2025-12-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-12-04 19:14:43 52.7 hrs 68d45ad1a5c7e586abe121ef 000020907 2.00 85.00 85.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9116 433fda9f5a593357f7de58c6d9df8a6f31a164dea0642272c74ef4e901b217d3 68c0a233346696080b218f42 68c0a13d27222324e91d5889 Valerie Baughman Valerie Baughman valcmansour@gmail.com 019826 6 2025-12-02 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-12-05 19:50:01 77.3 hrs 69333781031757322761bf7d 000019289 4.00 95.41 95.41 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9115 b4ac39d6eba280288199aff34568e3a562eb0018ed35e038425c158ee520bbe4 690a202a007aed0c7caf34b9 690a200e58a9641f56ed400a Samantha Strife Samantha Strife samanthastrife@gmail.com 020192 9 2025-12-02 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-12-04 21:53:12 55.1 hrs 690a202a007aed0c7caf34b8 000025855 5.00 85.00 12.75 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9114 a3b6266b1af0d440c271991c65c3854ed19f8129292efddd0cc081a6b403189c 6908d63cac23683dcb0e8ea2 67ced2f47abf9f3ed8fe626e Bryan Alders Bryan Alders bryanalders@gmail.com 000825 25 2025-12-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-12-02 14:51:44 0.1 hrs 6908d63cac23683dcb0e8ea1 000025670 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9113 339c7a4ecb3b1c2c08fa21b5b925455edda4094a30212c4ddb896c3eb0b0ce26 68c03e60cb34102eb3dbad99 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-12-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. oot Michelle W. 2025-09-12 19:07:06 -1939.6 hrs 68c03e60cb34102eb3dbad98 000019149 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9112 dddbdf7ac905271912a6bfb9791a151d056ba075618333d87831648633bfe913 69121c6222fea104144e4810 690134300caa82196f5b48c3 Eileen Conway Eileen Conway conwayeg@gmail.com 020163 40 2025-12-02 No Show 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed - Sophia L. 2025-12-02 15:19:34 0.3 hrs 69121c6222fea104144e480f 000026507 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09
9111 c61523ffc9c067d17d479d47f922955b3ac2e261d65f5d4e74c1120bf3b379ef 68ee75105b0702f7f8aae901 67ced31e7abf9f3ed8fe781c Robert Clevenger Robert Clevenger bobby727@hotmail.com 002675 104 2025-12-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-12-02 15:16:58 0.3 hrs 693884a43796fc8ceaf81216 000023311 2.00 67.56 67.56 - - - - - - - - 2026-02-19 22:47:45 2026-05-04 23:13:09