General Visit (PT Boulder API)

Total rows: 104,153
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
13037 a537b68a64fe7bcd087d4d9fb010f201cbef778da4cd4eb87e97f76f52934134 68a8c45cfc757507747faf52 68927a5581dca5077cc2ae98 Dianne Inglis Dianne Inglis Diannecinglis@icloud.com 017757 30 2025-10-27 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 10/27 - dizzy and unwell Sophia L. 2025-10-27 15:21:38 -1.6 hrs 68a8c45cfc757507747faf51 000017308 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13036 a1187d60fd76b00849bee60fbfe86970b19f46b484479b703f8bf36a777049d2 68893155337f8b083fabe10f 67ced4d77abf9f3ed8fee3f1 Gail Promboin Gail Promboin burnboin@msn.com 011874 124 2025-10-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Unidentified - - No Maia H. - Rosey Reed 2025-10-27 16:50:00 -0.2 hrs 68893155337f8b083fabe10e 000014673 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13035 c43e2f22c3489ce090940c08115304d3000e7b5dda31b547057d0eb75d27250e 68657762d5b0000c266761fa 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-27 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 19:33:52 -2805.4 hrs 68657762d5b0000c266761ee 000011655 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13034 76d238c7b7f556e8312d528ad643e9aae5fb2210c951652627a0447e466cbecf 68502ef59189370889e4ade0 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-27 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Gillian B. - Rosey Reed 2025-10-27 17:04:18 0.1 hrs 68502ef59189370889e4adcc 000009352 5.00 390.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13033 a4791ea86a18b0bf75e7f69cf8b329512e4324cf4231a295920f2ef0b5c14ab9 68ff928d45427708eb7cd9b1 6830b48e8df562d524fd9c8a Judith Oehler Judith Oehler judyo@hotmail.com 017304 20 2025-10-27 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Frances Lawrence - Anne Palma 2025-10-30 19:06:19 73.9 hrs 68ff928d45427708eb7cd9b0 000024868 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13032 742c61b43b47de62ea5f734545173fcee076baba685eb4ca5d799fb880c94351 68ed298bf50c6ec0a455f263 684840b5f839a307c1ba93c5 David Wynja David Wynja chris@wynja.com 017425 13 2025-10-27 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - System 2025-11-17 07:00:44 493.8 hrs 68ed298bf50c6ec0a455f262 000023172 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13031 dd92b702632fa483a12e5834e0de01a4754a54fd649e2035a3229a6abc8b3a5d 68e43ef13b8c4a09adb7823b 67ced2f87abf9f3ed8fe651a Bruce Carpenter Bruce Carpenter bruceacarp@hotmail.com 001053 125 2025-10-27 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Peter Gagnon 2025-10-30 15:55:24 70.7 hrs 68e43ef13b8c4a09adb7823a 000022449 3.00 81.40 64.85 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13030 101d85c15257a0107c3be2c4e823679ffa4934fed9ec994b14e87e0abfbb479e 68dfdb7afbc56209797b2c95 67ced2f87abf9f3ed8fe64e7 Rodney Allen Rodney Allen roddy.allen19@gmail.com 001036 19 2025-10-27 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-27 17:16:25 0.0 hrs 69024547e5287c11309f948c 000022140 4.00 103.39 82.37 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13029 b2034ece3099d4d139aa3fefde32000f255ce8f3453225a35dc78a1dc801846d 68d5b7cca9040793a65bc78f 68bb1405f45d4ebac1e95a47 Joelean Lambrecht Joelean Lambrecht jnjlambrecht@yahoo.com 019805 42 2025-10-27 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sara Thompson scheduling conflict, will reschedule Frances Lawrence 2025-10-26 13:28:46 -27.8 hrs 68d5b7cca9040793a65bc78e 000021119 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13028 45df610f6135a25d03dd136dc4e7cf3fd09a2a301ab0fbd882048d61b091698b 68b9c3b372432b0784f9aa66 6893cf46991c8a07b5078073 Denise Froning Denise Froning denisefroning@yahoo.com 017764 15 2025-10-27 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 17:12:01 -0.0 hrs 68b9c3b372432b0784f9aa62 000018687 4.00 95.48 95.48 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13027 d4629064f0ed0d4ce730713245e27263dce837c6c9191d35352c3180a0fd562e 6883ba9c66b5e807d7a63602 67ced50e7abf9f3ed8feece0 Amy Schlotthauer Amy Schlotthauer harmshauer@hotmail.com 012636 45 2025-10-27 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Miranda Samson 2025-10-27 18:46:24 1.5 hrs 6904fd8ac66c580a118ccf75 000014382 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13026 72722694ada551e654560a34f233cf0c9539ba9ad224db8f27013a5c77a34233 68ed69019dc06508a42f3dc3 68a8153699c65c4a78a5fa31 Charles Izurieta Charles Izurieta charles.izurieta@gmail.com 018691 18 2025-10-27 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Sophia out of office-sc Sonya C. 2025-10-27 13:18:52 -4.2 hrs 68ed69019dc06508a42f3dc2 000023240 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13025 afb5ba3d6b327740bff89a1da2936aabae8429c5ead500e822be8fcada7cd467 68daa2d72690198acf02f24f 68d5987de4b79f09d2a8f2d2 Sukru Ergin Sukru Ergin erginsukru@gmail.com 019933 24 2025-10-27 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-27 17:35:05 0.1 hrs 68daa2d72690198acf02f24a 000021295 5.00 154.00 154.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13024 501b6be652a25cd14dcc073df76f9e69c57b02aa4efb0c5fd8da9627d1b92ffd 68d18730c3c70408c5612206 68221b8507a60c078def4097 Sharon Martinez Sharon Martinez sharon.mama12@yahoo.com 017220 11 2025-10-27 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia Phillips 2025-10-13 14:20:34 -339.2 hrs 68d18730c3c70408c5612205 000020474 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13023 b84a57f32a3cdb483b5f850d4cc28da92a89917c4750d9db647e91db8055489b 688a5f3e99de3307937ad733 67e1258a54aaaa3a80096c69 Kenneth Chan Kenneth Chan kennethsaichan@gmail.com 016747 16 2025-10-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 17:31:36 0.0 hrs 688a5f3e99de3307937ad72e 000014814 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13022 25e34b89d6a0d1d36232ce720090440d01f2c5aea25155f5b4bc9df172ddbfe1 6894e6e19e87024d9e1f2028 67ced5197abf9f3ed8feeea2 Joe Romig Joe Romig jromig@ponderosa-assoc.com 012786 15 2025-10-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-10-27 17:44:20 -0.0 hrs 6894e6e19e87024d9e1f2027 000015727 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13021 338b46d93f21c3b7a4602afba2230dd859cbba667265fd78f2fabd6ce2b99801 68f688b2a12b4908bc29ac15 67ced5917abf9f3ed8ff005c Sally Sandusky Sally Sandusky sally@csico.net 014298 35 2025-10-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-28 13:57:09 19.7 hrs 68f688b2a12b4908bc29ac14 000024059 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13020 ee0d4c0d9afafccce6567fc8c16bf64a326da299d4a9645926ab3ac7bbb6a6c9 68daa8aab76a99c70e9b2127 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-27 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Mark Leo Guevarra 2025-10-29 20:38:06 50.4 hrs 68daa8aab76a99c70e9b2126 000021319 3.00 82.90 82.90 - - - - - - - - 2026-02-19 22:58:44 2026-06-11 23:30:01
13019 c5bc6d1f610f41b119a1a7b11ecbb1a470eeeb4d1da3d8cab4ebb491616a8b06 68cc6c52c06536085e885dae 67ced5917abf9f3ed8ff005c Sally Sandusky Sally Sandusky sally@csico.net 014298 35 2025-10-27 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ Out of town - sc Sonya C. 2025-10-20 19:06:54 -167.1 hrs 68cc6c52c06536085e885dad 000020193 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13018 7aaae4a4be2a5d44084320613c1cf54be8797b356ddb6563a53805f7952c9a37 6893da994b76da5b183f4014 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2025-10-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Per email - "My mom (Susan) still has fluid on her lungs" - sc , Sonya C. 2025-10-27 11:57:28 -6.3 hrs 6893da994b76da5b183f4013 000015669 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13017 22aee2ea0f353f3f2258963a8f05ae21d67b04286cd820652b1a6a18019bc3d8 68ff94abbd229708adbc1477 67ced4f37abf9f3ed8fee87d Henry Reynolds Henry Reynolds nedheadd@gmail.com 012262 15 2025-10-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-05 19:08:44 216.6 hrs 68ff94abbd229708adbc1476 000024871 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13016 475eb9b66c3727138bcf15afaa22ad6e7ccd1f9d48689d159aa2e644292148f1 68fa6b35657cca0941b09ded 68a4e622dd3cb8f81a2b9dbe Vicki Gazdik Vicki Gazdik vickigazdik@gmail.com 017828 22 2025-10-27 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 18:32:04 0.0 hrs 68fa6b35657cca0941b09dec 000024550 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13015 ab98f48c6f6a9e971f6c8a0645d33289c45830a7bf92ea9806023f6e3c828e3f 68efb108d7d5eb09ac980bf3 683894c42f21dae449a884bc Erin Giveans Erin Giveans ekgiveans@gmail.com 017340 37 2025-10-27 Cancel 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 10/23 (son had medical emergency- hasn't gotten Rx) Sophia L. 2025-10-23 17:13:37 -97.3 hrs 68efb108d7d5eb09ac980bf2 000023514 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13014 ba0300fc2998470a9d07ad6d549d409c784558785e485d774666844c1ae78480 68e6d5522dc66d08b89c42c6 68e6d52515f6aeaeb5b0b9e6 Yayoi Ide Yayoi Ide marchhare.ide@gmail.com 020024 6 2025-10-27 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 18:32:13 0.0 hrs 68e6d5522dc66d08b89c42c5 000022838 5.00 463.00 82.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01
13013 9723aecb5eb4007cc43e9ebf8028a65f21399d96d8840d4668f10c85cd14e120 68dc1a00ae378b0a2270b316 67ced6017abf9f3ed8ff0f3d Terrie Thal Terrie Thal terriethal@yahoo.com 015567 25 2025-10-27 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-11-03 17:27:36 167.0 hrs 68dc1a00ae378b0a2270b315 000021640 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:58:28 2026-06-11 23:30:01