General Visit (PT Boulder API)

Total rows: 100,726
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
12225 ca946aa6d861195fbc0459e8b94a9a0ed143eba79ff1d6ce61d43274e60c83ec 68e55f4d87beda41c8cc9426 68a782c73fb82189c2f53c94 Arthur Lieb Arthur Lieb ajlieb27@gmail.com 017891 22 2025-11-03 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Frances Lawrence will go to Boulder Frances Lawrence 2025-10-07 19:54:41 -644.8 hrs 68e55f4d87beda41c8cc9425 000022557 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12224 dc94c658e43964a530ed2278a8298eaa661c5ac19a4aa3a0c2991266d56de816 68a785409adc93369eca1bf1 686542b06de526088c4c9127 Ann Firby Ann Firby ann@firby.us 017560 41 2025-11-03 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Libby home with sick kid Elizabeth Cousins 2025-11-03 14:54:13 -1.8 hrs 68a785409adc93369eca1bf0 000017160 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12223 35eddba83728f1dd0f8fc48d7a4276bc4ef208026d3e0476d89326d75c50e1cb 68e9295700ec063ecc03b46f 67ced3cc7abf9f3ed8feafc8 Brigid Keating Brigid Keating brigid.keat@gmail.com 007425 30 2025-11-03 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-11 16:40:49 191.7 hrs 68e9295700ec063ecc03b46e 000023033 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12222 26aa867743d57a30209c9a21ba9fd6879a8400192ed8dcf90f5a10a163c29e64 68e3f7c4753b0509a0a19555 68e3f72a7f87d5594124ed13 Jennifer Burnsed Jennifer Burnsed gigijack@aol.com 019997 24 2025-11-03 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-10-06 17:09:36 -671.8 hrs 68e3f7c4753b0509a0a19550 000022365 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12221 3cc23b5c0329eb7f052c04802097e8bfe65ab63a6a39ee711994e966ee7f89c4 68e3f7c32f0f8408f097e617 68e3f72a7f87d5594124ed13 Jennifer Burnsed Jennifer Burnsed gigijack@aol.com 019997 24 2025-11-03 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-11-03 17:04:54 0.1 hrs 691266d15fc7cad375f9c4de 000022360 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12220 8e6247c67c7e69a230da500d0bf5135bcaa56a2c4671ac0c611a3d915f8afa74 68e3f609ac842209d092eb20 67ced6507abf9f3ed8ff1975 Julie Yang Julie Yang julie.yang@ptofboulder.com 016438 47 2025-11-03 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-11-03 17:03:29 0.1 hrs 68e3f609ac842209d092eb1f 000022353 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:56:30 2026-05-06 23:22:11
12219 85df42458b597f971ffbb05ee2c69a54972369f5d0e63fb2b05c6af8c70ac423 68e040737d0697a3fc2079ac 68e040340621200921f9094b Rosalind Hanckel Rosalind Hanckel rosalindhanckel@gmail.com 019991 4 2025-11-03 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. in ER due to gall bladder surgery Samantha Saunders 2025-11-03 17:12:30 0.2 hrs 68e040737d0697a3fc2079ab 000022248 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12218 71324c8281932580cb63c08d351cda6256e51b3dfca6f15d3cab40cb22984379 68dda25f53253addba44ee93 68a8152c99c65c4a78a5f805 Suzanne Harper Suzanne Harper sharper01@aol.com 018583 18 2025-11-03 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24 scheduling conflict Michelle W. 2025-10-09 19:00:50 -598.0 hrs 68dda25f53253addba44ee92 000021942 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12217 72f49121f7a8632e2a7fa57c539d10d2bd9323af0c890883a5b48c85861a035f 68dd5a8be67af7ae2e9fe4b9 67ced3d37abf9f3ed8feb172 Melinda Kelsey Melinda Kelsey fmkelsey@icloud.com 007567 26 2025-11-03 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. pt conf cxl SL 11/3 (getting over a virus) Sophia L. 2025-11-03 15:55:58 -1.1 hrs 68dd5a8be67af7ae2e9fe4b6 000021844 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12216 4b8d3f5b2f350778f91a3b75dc3097ca4d2e160d648afd6c066b1a919777e3d7 6902858a155e2d984043ff2d 68c992ae02a01e077f5346db Teresa Treto Teresa Treto teretreto7@yahoo.com 019867 13 2025-11-03 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-11 15:56:02 190.7 hrs 6902858a155e2d984043ff2c 000025340 1.00 130.00 150.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12215 edafe449e9216da28bc18ab7a343dbe6bec588b7fdbdb639747e29342e6b46e1 68dda1d153253addba44e6f9 67ced3877abf9f3ed8fe9d2c Rebecca Greig Rebecca Greig rebeccamjgreig@gmail.com 005837 6 2025-11-03 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ child broke leg, conflicting apt. SMP Sarah Patterson 2025-10-29 15:58:51 -121.3 hrs 68dda1d153253addba44e6f8 000021940 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12214 61f6e818d3b706328c4fab0ab00274789f2ea5c78cba59b8a57e54a92047dbe5 68b1ec4c50b03f0801b27179 68b1e83ef391642b2654c4d7 Joyce Gordon Joyce Gordon jay_gee@comcast.net 019783 53 2025-11-03 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-11-03 17:18:45 0.1 hrs 68b1ec4c50b03f0801b27174 000018223 2.00 56.80 56.80 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12213 e5cc5aa24a01c1e73cca9a7b039fa7867d155869d6843a08c00eb5f52dd26fc8 68acab74856e76c2c633270b 67ced3177abf9f3ed8fe75ee Susan Brooks Susan Brooks 2sbrooks@gmail.com 002489 39 2025-11-03 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-11-03 17:09:16 -0.1 hrs 68acab74856e76c2c6332707 000017426 2.00 159.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12212 d47f9fe82c74fd91d0ad2116016f7ba6fef497150d06824298048d5155630c53 690108500caa82196f59921d 68fa5ac3afe713099f497ade Maxwell Keirn Maxwell Keirn mkeirn@gmail.com 020134 6 2025-11-03 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Emmie Gebhardt - Amie Russell 2025-11-03 17:25:05 -0.1 hrs 690108500caa82196f59921c 000025071 2.00 156.00 0.00 - - - - - - - - 2026-02-19 22:56:14 2026-05-06 23:22:11
12211 3a51f03973755635fe8767f3e27095a7fa9b3d9c576e2cbff5475118c3371cf1 68e57ee927239409411bb9d1 68e57edc6bb8aab7fdd69bad Elizabeth Bahnsen Elizabeth Bahnsen eabahnsen@gmail.com 020009 15 2025-11-03 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-11-03 17:26:19 -0.1 hrs 68e57ee927239409411bb9d0 000022607 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12210 b925c2335495154b5d8d585ed250cd716e2875ca4c20366f10f0a6d6e5d3df89 68e3f5e3ab83a708b6202dcd 68b1cff1f01ec70834d44dcf Olivia Dent Olivia Dent luchysarah@gmail.com 019779 9 2025-11-03 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Emmie Gebhardt - Jayson Encarnacion 2025-11-11 16:23:06 190.9 hrs 68e3f5e3ab83a708b6202dcc 000022352 3.00 83.12 83.12 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12209 10749e28225fb024677de71181f693eabc48509e03828b4bfa73171d9ce08ea9 68ffa9324d42c76a78033c78 685c605620456edf6d427bd3 Walraven Ketellapper Walraven Ketellapper walraven@stillwaterresources.com 017525 17 2025-11-03 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Emmie Gebhardt - Jayson Encarnacion 2025-11-11 16:08:00 190.4 hrs 68ffa9324d42c76a78033c77 000024899 3.00 82.00 87.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12208 83c3398f05e342e958f11b53bda5269d0bcd9ce6ec623a58728bc9d869a4fed6 68fbae23761f9609f2b319f6 67ced3107abf9f3ed8fe721f Jeffrey Brenman Jeffrey Brenman jbrenman@pobox.com 002164 13 2025-11-03 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-11-03 17:07:07 -0.6 hrs 68fbae23761f9609f2b319f5 000024728 3.00 75.12 75.12 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12207 712cce9ccce808c97633c26128842570b13dda8dd14dc0a4e6a8cf42389dcefc 68e7e3fac5d8612b97832a1c 68e7e38b9dae9408d4c7f4ad Bonnie Schwartzburg Bonnie Schwartzburg suemills2020@gmail.com 020031 4 2025-11-03 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-11-03 17:43:40 -0.0 hrs 6914c38e99870f197c31a07e 000022911 4.00 171.76 171.76 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12206 0f83855b6e23134a5540c815f43ad561271e6729ee9f509fa428a842d3b55935 68e7c5dc3946c6ed220e1da1 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-11-03 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt doesn't want to do PT anymore - RAR 10/23 Rosey Reed 2025-10-23 22:55:54 -258.8 hrs 68e7c5dc3946c6ed220e1da0 000022874 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12205 7c04794e6483ea431e2ffc041046cef892ebecebcbfa5352595e8fc8b5e0775d 68e3d7f693a90a072c78e8ce 68e3d746a0128ea37f9a5425 Patricia Badeaux Patricia Badeaux badeauxpatricia@gmail.com 019992 11 2025-11-03 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-03 17:43:28 -0.0 hrs 68e3d7f693a90a072c78e8cd 000022273 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12204 c76f276aae56970170c6e4821e28eedeea02ac01395667a10551dcf4e336d73f 68df002c59de8d4e2990e3f5 68deffbf040cf06246ab7301 Abby Howard Abby Howard howard.abby@gmail.com 019984 7 2025-11-03 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ cxl all appts bc feeling better w/ exc - RAR 10/22 Rosey Reed 2025-10-22 20:11:52 -285.6 hrs 68df002c59de8d4e2990e3f4 000022126 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12203 b5885063c58406df6783c1ff4ad819f9914a3f2b3404d7e08d8018fe831b45ae 68d32716d4cf0e241a2adbb0 68407dc4cf918e087b7eab3e Nancy McKenna Nancy McKenna 3@9.com 017385 17 2025-11-03 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Emmie Gebhardt discharged Emily Pickner 2025-11-03 16:34:12 -1.2 hrs 68d32716d4cf0e241a2adbaf 000020769 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12202 32731b215dfc321d87d9de7cf11e683343b9d88b4a2192ec9b0055c94f746187 687fa83c95c6c05c50965af0 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 71 2025-11-03 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-03 18:21:15 0.6 hrs 687fa83c95c6c05c50965aee 000013766 3.00 82.00 65.60 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11
12201 7b17730144e93a6d1e2d79db3992277dd6a2d1c72f32630aebf003fc9bc69c03 6903ef12f06b28096a7d086e 67ced31c7abf9f3ed8fe77b3 Karin Delany Karin Delany karindelany@gmail.com 002640 82 2025-11-03 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Unidentified - - No Laura Shove - Rosey Reed 2025-11-03 17:58:40 -0.0 hrs 6903ef12f06b28096a7d086d 000025518 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:22:11