General Visit (PT Boulder API)

Total rows: 101,513
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
17024 00cdc79a2c2ab05f7562c3fb2a54e69f6b80f4b17e405ad43a97f75dc9a60156 683f4520bc9ade076f22ba96 67ced5547abf9f3ed8fef77e Kate Shew Kate Shew kateshew28@gmail.com 013542 49 2025-09-23 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Anne Palma 2025-09-24 18:55:05 26.2 hrs 683f4520bc9ade076f22ba95 000007956 4.00 84.40 84.40 - - - - - - - - 2026-02-19 23:10:40 2026-05-13 23:35:32
17023 70d0971b4e9dcfe29cd4a4675def5326f2d8969618567584a946773b0d72a59d 68c84a09604ed3cf9e7d226c 68c84981fcdd9c82695f24b0 Michele Gerra Michele Gerra mike@mikegerra.com 019853 6 2025-09-23 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-06 15:16:30 310.3 hrs 68c84a09604ed3cf9e7d226b 000019770 3.00 133.36 133.36 - - - - - - - - 2026-02-19 23:10:40 2026-05-13 23:35:32
17022 95ed3149b7988dee6d7db4b16820a2e9f23ce18031f29dbcabe5ac5140407f92 68a818afb625571f004546e3 68a79c33baca600f3f73fee6 Phyllis Kerk Phyllis Kerk PhyllisKerk@PTBoulder.com 017904 12 2025-09-23 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Dawn Singleton - Julie Petersen-Hanson 2025-09-29 14:18:07 141.3 hrs 690378c592e8a79eb0f2f0b9 000161099 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:10:40 2026-05-13 23:35:32
17021 3cff0a7a292e1fd1f9c6206ec71e4ebbbe6320fdd66c15dbb18aaafca3330300 689f5887aef3094da56a2c77 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-09-23 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-23 17:00:32 0.0 hrs 689f5887aef3094da56a2c6f 000016399 3.00 80.65 80.65 - - - - - - - - 2026-02-19 23:10:40 2026-05-13 23:35:32
17020 c680a03ea4a5f2657925e8e49a612ede99cc17077e76636263adef7ec7eacc22 6893b5c07f3e617ebd5307f3 67ced42e7abf9f3ed8fec51c John Miranda John Miranda flymiranda@gmail.com 009244 113 2025-09-23 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-23 17:15:27 0.3 hrs 6893b5c07f3e617ebd5307ef 000015555 3.00 78.64 78.64 - - - - - - - - 2026-02-19 23:10:40 2026-05-13 23:35:32
17019 45a27816587c4c3812320885fa18ace7b5b16879518f888e077fcc745a3682cb 68503419837be607f33614a3 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-23 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 18:11:24 -1990.8 hrs 68503419837be607f336147f 000009371 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17018 2f3e3fbbf13dd28b8c1ab76e129cd3e46ee0d6013213b7cf1633586e6f88b22c 68d2c875c69b46089734dcc5 682f4fb6e960150854c84153 Rene Brodeur Rene Brodeur rpbrodeur@gmail.com 017288 9 2025-09-23 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Anne Palma 2025-09-24 18:27:42 25.2 hrs 68d2c875c69b46089734dcc4 000020630 3.00 83.23 81.63 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17017 18a1726fc6ec1e885aa7948ec3cc9f0e3ce540f1966cd1001a2fca14c5300dec 68d2bbf80b5638cea9ac154c 68c883ff031f66138546a9a6 Martin Coster Martin Coster mjcbvm@yahoo.com 019862 9 2025-09-23 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-09-29 16:44:23 143.5 hrs 68d2bbf80b5638cea9ac154b 000020599 3.00 80.00 110.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17016 1ee60766e9a5e11992f5aef0b74a22f4b9323d30d6c0c67a908c6acef2c15d12 68cc5b70f9594426dc3eab37 68af866abd212cfa6444c3c2 Kelly Blaski Kelly Blaski harmony303@mac.com 019768 13 2025-09-23 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Jayson Encarnacion 2025-09-29 20:29:10 147.2 hrs 68cc5b70f9594426dc3eab36 000020169 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17015 0c490225b257fad4cf77298c13736099edda75371910e7778f63322238e772dc 68b74d9730c785eff2f489cb 68b74d4202f89e173011e8f9 Kathryn Cross Kathryn Cross katecross372@gmail.com 019787 13 2025-09-23 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-23 17:16:20 0.0 hrs 68b74d9730c785eff2f489ca 000018378 5.00 95.83 83.98 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17014 2a951c74bd58928d59350f08c56378126755f15b927854d0ebfd96dffa076faf 68b0a2acbb5f3ff30df8872c 68a5ebe4867cb008473c08c7 Steve Bonneau Steve Bonneau sbonneau@gmail.com 017832 16 2025-09-23 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence - Frances Lawrence 2025-09-15 19:28:32 -189.8 hrs 68b0a2acbb5f3ff30df8872b 000018059 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17013 f1f66e6434c1f66cd8d16bcfab457f06870eae804b09d14f002ef7cccf19c621 68af40dfa1ee27080898189d 68645e432e36c3085ae44305 Karen Barr Karen Barr kndbarr@comcast.net 017559 37 2025-09-23 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 689983a679e412ce7c3dfcf6 Westminster Unpaid - Primary - - Yes Dawn Singleton - Sophia L. 2025-10-15 20:37:37 531.4 hrs 69cf0d2ae5267b4120a5843c 000017820 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17012 99d8f25a5ef296fbc2bc14020529a5458a91a8829ad51c32ed9e240288daca6d 689f9059c93793087b4e4a3e 689f8f1c71452007b5c443d6 Ian Smith Ian Smith iancrochets@gmail.com 017809 7 2025-09-23 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-23 17:45:40 0.5 hrs 689f9059c93793087b4e4a3a 000016478 4.00 95.60 60.60 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17011 b7bf69db5076e4054be13e0af417d5e3e87fb700a150b6da50f7df7f732fecf1 687694f85e37c3086a7c033f 684711efac738707f0582e76 Amelia Zutz Amelia Zutz mia.zutz@gmail.com 017419 6 2025-09-23 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. nln AM 24+ Anne Majewski 2025-09-02 19:01:09 -502.2 hrs 687694f85e37c3086a7c033e 000013000 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17010 cfeb30e41c2a21005fe1b1edf07c7eff0e6516d074ca0d085d75e3e563743cc9 686d35be37d21991da553856 67ced5457abf9f3ed8fef541 Cynthia Ruggero Cynthia Ruggero cynthiaruggero@gmail.com 013351 76 2025-09-23 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. pt in hospital - 9/22 6:35pm RAR Rosey Reed 2025-09-23 15:13:39 -2.0 hrs 686d35be37d21991da55384e 000012013 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17009 bc5c2b223e93edc6890d9ab26b47aa1ee5da213cedfc0dccd625e13b789d52f5 68cc1ecc463e38083a91519d 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-09-23 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. having car trouble- sc Sonya C. 2025-09-23 16:53:42 -0.6 hrs 68cc1ecc463e38083a91519c 000020111 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17008 df8115c4cff3db91ee97747749ec697f9b236dd4b5c6e8567217f97dc534adba 68ac9145b83479879d0b8280 68ac908c6cb0b7c04a3d2d1a Orlagh Lakings Orlagh Lakings orlaghlakings@me.com 019737 10 2025-09-23 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-23 17:49:27 0.3 hrs 68ac9145b83479879d0b827b 000017385 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:32
17007 365c6b26c88eff332a66e4ee24a5f1299eb407abefedbc5d7b466f60d273d9f1 689509cabc347a07c4bc02ff 67ced5267abf9f3ed8fef0a3 Richard Schwolsky Richard Schwolsky rickschwolsky@gmail.com 012957 27 2025-09-23 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Sophia L. 2025-09-23 17:28:51 -0.0 hrs 689509cabc347a07c4bc02fe 000015742 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17006 defa5a7cc61abdd8e4ed02609d35fec21d787824ffd472a1ed896cfd51a045c3 68922ca3e80392a1783795fa 68922a9a3a3b7207d85e5067 George Craft George Craft gcraft100@gmail.com 017750 15 2025-09-23 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Samantha Saunders 2025-09-22 18:53:52 -22.6 hrs 68922ca3e80392a1783795f6 000015387 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17005 42639bae488a4c1501f79698b732da8a378ca0d905c9c9073fb2f374f1af906d 684b0351c1f89e0826ca8d15 6848aca2134225ce208e65c6 Eve Pollak Eve Pollak movingvoice@me.com 017435 6 2025-09-23 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Gillian B. conflict Terri Nishimoto 2025-09-11 20:18:18 -285.2 hrs 684b0351c1f89e0826ca8d14 000009133 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17004 168f400e7c341e89dd763296d97051999a5f41b58df0b414f4c4f802892b67a2 681a8469d7b5b5085497322e 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-09-23 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ sc Sonya C. 2025-06-12 18:02:59 -2471.5 hrs 681a8469d7b5b5085497322d 000004547 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17003 34b14636a4a1725e24eec02be7cab7d405b85931e93970966ef60b18969cc950 68a793cd77a174ebf51ea6a2 68a79210787a59a3c10467de Tracy Brennan Tracy Brennan tracy.brennan@comcast.net 017899 16 2025-09-23 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-23 18:29:41 0.7 hrs 68d2ee1578cb5010b3fe4d0f 000017170 3.00 70.36 19.36 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17002 503ff4e053b74b3f6a73a3d7dcdbeb3886b5f40cdb6225cd10686f7e96f9e791 6866d9b2c99f0507aa7a9467 67ced2fe7abf9f3ed8fe691c Howard Anderson Howard Anderson anderson7575@comcast.net 001395 122 2025-09-23 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-23 17:50:52 0.1 hrs 6866d9b2c99f0507aa7a9466 000011781 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17001 326770df33e8e95c3b35a027d42b40898317f8abe224b0828a0322ffd2205e3b 68cb360cf983cf3bbf432b28 68ae31c602a116dd897f1858 Lucia Karki Lucia Karki lucia.karki@hotmail.com 019749 13 2025-09-23 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-09-29 16:47:39 142.8 hrs 68cb360cf983cf3bbf432b27 000020096 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18
17000 828281134cee3d8d8b725d54f9d3fa30a091edd92d17570d606484106bb28a6e 68c0a91722d9df01d7871f0a 67ced4627abf9f3ed8fecf4a Michael Lovy Michael Lovy michaelrlovy@gmail.com 010112 37 2025-09-23 No Show 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. - Sara Thompson 2025-09-23 19:50:22 1.8 hrs 68c0a91722d9df01d7871f02 000019303 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:24 2026-05-13 23:35:18