General Visit (PT Boulder API)

Total rows: 100,569
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
10006 9b7b7930654aaf7279d773e6b6f5941099d402bb4d1291dfcb206ab53039b13a 6913b0ac99782bd08c4373f0 68a8156d99c65c4a78a604b2 Kemah Plusk Kemah Plusk ltdgoldens@gmail.com 019208 28 2025-11-20 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Kenneth Dave Francisco 2025-11-24 20:36:04 99.1 hrs 6913b0ac99782bd08c4373ef 000026866 3.00 80.27 80.27 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10005 804788e86214610af4a2590a2127d175c4d4451a60fa0972a8647edaa9f892ea 69024b44785e6e0a11da2909 67ced5657abf9f3ed8fefa04 Kathryn Tucker Kathryn Tucker tuckerk7@gmail.com 013757 44 2025-11-20 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-11-27 19:16:26 169.8 hrs 69024b44785e6e0a11da2905 000025246 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10004 1b787149edb5c16c0a5d7a435f44303b5588059ed180525e20af67ceb08f65a5 69011df5eba41865eca4f580 69011bb60077f23a2c400d04 Francine Smith Francine Smith fszsmith@comcast.net 020159 43 2025-11-20 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Sonya C. - Sara Thompson 2025-11-20 16:19:04 -1.2 hrs 69011df5eba41865eca4f57f 000025101 3.00 82.00 81.60 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10003 83de28cf03e55c3fd82176c51b14128feabba68fef8c89689beef67fd6b9c9e1 68e7e71ca0a997f662e5555d 68a8157599c65c4a78a6064a Marie Rode Marie Rode rode.marie@yahoo.com 019286 32 2025-11-20 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence 24+ Schedule conflict Emmie Gebhardt 2025-10-28 20:31:27 -549.0 hrs 68e7e71ca0a997f662e5555c 000022930 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10002 e82afd6fa756f900aca78333adf8fb4ee1ea044676b177e22804fb8bd9082323 68d31de22c0f1108380e8fd8 67ced5a07abf9f3ed8ff026c Nicholas Van Someren Nicholas Van Someren nicko@nicko.org 014474 9 2025-11-20 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Sonya C. - Abyssel Gobris 2026-01-05 16:19:51 1102.8 hrs 68d31de22c0f1108380e8fd7 000020756 3.00 85.00 153.01 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10001 8fa725208019aa90ab82e02d397640f50bff7b6730c4229c832a28aadb339489 689e17f8f68fc3089c11ff9b 67ced4637abf9f3ed8fecf89 Robert Owen Robert Owen robertbarryowen@icloud.com 010133 87 2025-11-20 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Dawn Singleton 2025-11-20 17:36:18 0.1 hrs 689e17f8f68fc3089c11ff93 000016313 2.00 59.50 47.40 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10000 7884e5b18e5de8bb25ab329f281cad92d8df32af9ea76b558023eccbb2205936 691cc4e485b9630a29f8720a 67ced3887abf9f3ed8fe9daa Bruce Frantzis Bruce Frantzis bwalters246@gmail.com 005879 11 2025-11-20 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Sonya C. 2025-11-20 18:42:52 1.0 hrs 691cc4e485b9630a29f87209 000027646 4.00 171.76 171.76 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9999 2e4df5b8f1e672c67ad0963cb40a96544eac390e2fa19d86dba5f9809b38bbba 69151efb36e7925f2d965a80 68e02fca09b64c92f3b431ed Scott Kaufman Scott Kaufman dacat@duck.com 019990 6 2025-11-20 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle Osgood pt conf cxl SL 11/20 - has covid Sophia L. 2025-11-20 16:07:14 -1.6 hrs 69151efb36e7925f2d965a7f 000027060 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9998 270bdbefc9f8c60572446a585e614063460763e8bce44074a7b7d98568a72c6e 69151e7008b8af854a4eeddf 67ced3bd7abf9f3ed8feabf3 Scott Hoffenberg Scott Hoffenberg urbanfarmer1@gmail.com 007098 4 2025-11-20 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle Osgood error Michelle Osgood 2025-11-12 23:56:12 -185.8 hrs 69151e7008b8af854a4eedde 000027059 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9997 e6f5ddb8cd9311f96b6db0bb3ed67618e9f796aa8ea1b84cafc00fe34c2834c2 68f28403c15856b584d4c98a 68f28386406551e1679bfb35 Mackenzie Caldwell Mackenzie Caldwell mackenziec0108@gmail.com 020098 25 2025-11-20 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-11-27 21:30:29 171.8 hrs 68f28403c15856b584d4c986 000023903 4.00 95.53 95.53 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9996 7d78761a5ef0112b02d1f23d5e8a2c72c70b7274ab6fc50b5161f382b48b456b 68e54ebc257a9eda16b3aaba 68e54e0cfd4675efbbe9656f Bradley MacHamer Bradley MacHamer brad.machamer@gmail.com 020004 4 2025-11-20 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ sch conflict - sc Sonya C. 2025-11-19 18:50:37 -22.9 hrs 68e54ebc257a9eda16b3aab9 000022532 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9995 084be056997f91e03f63be3930aa482729ae7aafe6fc2b54170d1d54a5c28a32 68cd768c49bd99682c693ead 67ced6587abf9f3ed8ff1a56 Dean Zadak Dean Zadak deanzadak@gmail.com 016513 19 2025-11-20 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-20 22:11:40 4.4 hrs 68cd768c49bd99682c693ea8 000020304 4.00 102.16 102.16 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9994 6959cf750cd245f2dffe7961267b79ebccb4cae80e1815ac21777d6668085c27 68c308d775e1f4087db555bf 6880f0894e569afc31549824 Carol Murin Carol Murin cmmurin@att.net 017677 21 2025-11-20 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ per VM request - sc Sonya C. 2025-11-17 13:23:11 -76.4 hrs 68c308d775e1f4087db555be 000019546 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9993 44ae3a4a8ba4fd61d2699a22c02fa38c9fe3a9b34cb2718867ec1742e3f50505 68b712f42e9ccb7cc25e85c2 67ced3597abf9f3ed8fe8e7a Connie Farnbach Connie Farnbach the.farnbachs@comcast.net 004583 177 2025-11-20 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-20 17:50:32 0.1 hrs 68b712f42e9ccb7cc25e85bf 000018311 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9992 b28aeeab4125ecdc51d5baede1285302b45b7e666e209a302e245b0ea400f968 691b753c30f8d49c5b5b8bdf 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2025-11-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-11-20 18:02:00 0.0 hrs 691b753c30f8d49c5b5b8bde 000027445 2.00 58.75 58.75 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9991 d8e57e580c398660a2da27efab85aad76664b33c16bc263878bc30ad3c650696 69090c92fb9ff059f390d5ce 69090c84bde6301b6f678f98 Saundra Shaeffer Saundra Shaeffer shaeffer_saundra@svvsd.org 020190 23 2025-11-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayvee Totanes 2025-11-27 16:50:49 166.8 hrs 69090c92fb9ff059f390d5cd 000025755 5.00 82.00 82.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9990 e3db8543992ca71bc2ff9cf552bf64694bdbbe78ca1e5c353544f31ee056abf5 68ffe315f0962a099fdfe74e 67ced42d7abf9f3ed8fec501 Missy Minor Missy Minor pswmm@comcast.net 009235 6 2025-11-20 Cancel 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed 24+ pt conf rxl to 12/3 SL 11/3 Sophia L. 2025-11-03 19:05:50 -406.9 hrs 68ffe315f0962a099fdfe74d 000024963 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9989 16cd9dc50bbe35c859ab952f3e645fed03253cc99fde2f6335a9b3fcccc35dbb 68e7c653898cec0a5454a385 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-11-20 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ sc Out of town Sonya C. 2025-10-20 19:24:22 -742.6 hrs 68e7c653898cec0a5454a380 000022879 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9988 985f971616b27c5b566a1a426a41ff4d9e64b51353c64ae4fdb01a8c69f3b994 68debb967fa445b7bc92a1bd 68c9aa7853da969548ff0b62 Michaela Krna Michaela Krna Michaela.Krna@gmail.com 019870 7 2025-11-20 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-11-27 15:21:30 165.4 hrs 68debb967fa445b7bc92a1b8 000022033 3.00 82.00 137.40 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9987 e8cde1bdac08d79179127556a14a148d3cc1eff7877d054ca0ff515cf8d32806 68dc38bd2ab66d09992e69a7 68a8152599c65c4a78a5f6b1 Mary Griffin Mary Griffin marymgriffin@comcast.net 018517 38 2025-11-20 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Michelle W. - Frances Lawrence 2025-11-20 20:29:21 2.5 hrs 68dc38bd2ab66d09992e69a6 000021699 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9986 5ff28c0fe0342ebc8d3b680045a6d1111217ff6ba069dac36bd4fcad93bc5bc0 68d55e2d6eb3325c205a1752 67ced5d87abf9f3ed8ff0a00 Scott Sutton Scott Sutton sutton.scott.olin@gmail.com 015120 72 2025-11-20 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Jayvee Totanes 2025-11-27 21:42:03 171.7 hrs 68d55e2d6eb3325c205a1751 000020984 2.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9985 0c7a54a7e0ce08884bcc9beba688d0c2bf40e6d6ac4d782710908956a3b3add4 68d2c6a0101d7cada1b49474 67ced38c7abf9f3ed8fe9ea6 Kathleen Fredrickson Kathleen Fredrickson kfredric@gmail.com 005963 127 2025-11-20 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ per VM request- sc Sonya C. 2025-11-17 19:18:24 -70.7 hrs 68d2c6a0101d7cada1b49473 000020627 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9984 7055a315fc39b418315f933dbb4e5e7d1b40b915ed12d6d16572bf613eac5b65 68b859a3beb9fe07b3ab2347 67ced3397abf9f3ed8fe82d2 Kim Copeland Kim Copeland kccopeland28@gmail.com 003589 45 2025-11-20 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. pt work schl changed, she LVM days ago - RAR 11/6 Rosey Reed 2025-11-06 18:20:08 -335.7 hrs 68b859a3beb9fe07b3ab2342 000018489 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9983 36465a09ef89429806ed9d65cc7f3dac950bf8dd717e01174548895e6bb39900 68825e4c2372fb07c8111eed 67ced6447abf9f3ed8ff17f2 David Wolfe David Wolfe david.wolfe@ptofboulder.com 016309 4 2025-11-20 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins Delete created accidentally SL 7/24 wrong pt Sophia L. 2025-07-24 16:30:56 -2857.5 hrs 68825e4c2372fb07c8111eec 000014199 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
9982 8aeedb2e6f345ecd1d17d012d2eb53a99d7f16db453d63df917b1e3dcf95fd5a 68503419837be607f33614b4 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-11-20 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 18:11:24 -3383.8 hrs 68503419837be607f3361490 000009388 4.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23