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
15816 eea7a65980af5a7238f90b7d65777aff5cf17096cbac5051985d816ed6de5184 68b084873e237c087be692a3 68a8156699c65c4a78a6037b Nellie M Parnell Nellie M Parnell robtandnell@comcast.net 019149 51 2025-10-02 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-10-02 18:29:38 1.5 hrs 68b084873e237c087be692a2 000017995 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15815 c05fb97598f1c6c7746cc0c60ccede0533c56c8cf5b885617eea38999f94e11f 68a8c929279bb6bfec6d2e21 67ced3e47abf9f3ed8feb577 Kelly Kling Kelly Kling klingfamily6@gmail.com 007910 20 2025-10-02 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sonya C. - Sophia L. 2025-10-02 17:37:10 0.6 hrs 68a8c929279bb6bfec6d2e20 000017312 3.00 237.00 37.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15814 77328baba54b61735c06b2d9b33b4a62331784cec5a910a47156636e40f0df31 68a500a1398d4e08954d3d27 67ced50e7abf9f3ed8feecdd Annabelle Rodriguez Annabelle Rodriguez annabelle.rodriguez@ptofboulder.com 012635 14 2025-10-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-10 16:30:29 191.5 hrs 68a500a1398d4e08954d3d26 000016822 3.00 82.00 92.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15813 ef000096cca3333620c4ccb6cff856dbc29d0fc31ac0b6e1a3b01e54b2682be2 688bc7e2f079fc3497974ffc 686542b06de526088c4c9127 Ann Firby Ann Firby ann@firby.us 017560 41 2025-10-02 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Elizabeth Cousins 2025-10-02 18:03:29 1.1 hrs 688bc7e2f079fc3497974ffb 000015041 4.00 103.85 103.85 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15812 ef64eae2bc9eb9041f8ac60c1212da03da0caaf19efd76acaf16b912f704724b 687fa7f32c635307e83e5007 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 73 2025-10-02 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2025-10-02 17:39:57 0.7 hrs 687fa7f32c635307e83e4fff 000013758 3.00 82.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15811 fa8f73c3bfbf6fb36cc942262d89708e715af3b803d4638fec20171a3518a019 68503419837be607f33614a6 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-02 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 18:11:24 -2206.8 hrs 68503419837be607f3361482 000009374 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15810 91eac8198f859c17b412db5c45543b906ebe37649f86cef96bb1b89fad0f3016 681cd1caa1cccbeccb5c6482 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-02 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 14:47:00 -2594.2 hrs 681cd1caa1cccbeccb5c6471 000004843 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15809 37e9b151b861122d2089aadf9c94b72af325033f4c3898c08e48c53c174cac4c 67e67187ceb9f104f028c2c2 67ced41a7abf9f3ed8fec126 Betrah Mignerey Betrah Mignerey davidandbea2022@gmail.com 008906 230 2025-10-02 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Sophia L. 2025-10-02 16:58:12 -0.0 hrs 692f33ec40be120aca1062e0 000151680 2.00 82.00 82.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15808 f760a521e835ca4de341d291b40de02359319594ab2f16714923085b602e8266 68d30f2fa836ecd5b3e05a1a 688116cef798cf324a799beb Melissa Reeve Melissa Reeve melissa.m.reeve@gmail.com 017684 4 2025-10-02 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-07 15:45:34 118.5 hrs 68d30f2fa836ecd5b3e05a19 000020740 4.00 82.00 81.60 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:30
15807 f5069b3fe869e6ebac3b57ee3f78d9fe90b20647073559bf511185fcfcad779f 68cc5c2b75fbc851f78b09bc 68af866abd212cfa6444c3c2 Kelly Blaski Kelly Blaski harmony303@mac.com 019768 13 2025-10-02 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Kenneth Dave Francisco 2025-10-08 15:32:39 142.3 hrs 68cc5c2b75fbc851f78b09bb 000020174 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15806 f51563c88c53d90cc5e198e5808cafe301df6bcde36c5f2d2f5c6b443dee6ca3 68af45bb909580082aecc6de 67ced37d7abf9f3ed8fe9a50 Eileen Graziani Eileen Graziani emg4294@gmail.com 005593 28 2025-10-02 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-02 17:40:21 0.4 hrs 68af45bb909580082aecc6dd 000017840 4.00 168.89 153.89 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15805 78434291558fdc5b801baacc1d2f1bf386002d811f67e51de1136d4590090d53 68af413a0234718675105876 68645e432e36c3085ae44305 Karen Barr Karen Barr kndbarr@comcast.net 017559 37 2025-10-02 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Dawn Singleton - Rayann Greer 2025-10-02 17:03:54 -0.2 hrs 68af413a0234718675105875 000017824 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15804 1c4c0c33342d91ecec7e80964270db0e50e1eb7454d2996cec9a37fd76789385 6876bedf117ba8089066a16b 680a6afe02392507eace7991 Karen Rosenschein Karen Rosenschein krosenschein@gmail.com 017126 18 2025-10-02 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-10-06 17:20:25 96.1 hrs 6876bedf117ba8089066a16a 000013098 3.00 130.00 130.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15803 7d03824de42fa40dce45a08b309d8ad9d4f038a0fafa95e1c7c8adc3f0959165 68b9ef8fbb9f601d40cd8401 67ced40c7abf9f3ed8febe36 Robert Lee Robert Lee rob.lee@gmail.com 008656 87 2025-10-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-06 15:16:45 93.8 hrs 68b9ef8fbb9f601d40cd8400 000018760 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15802 513be7c263a785682294dfd4225d40e4ef3ecb323245cb3c8bf5a05cc22d9189 68b88e4fe4595c07e39460e0 68b88d26081b35c31ca8c27b James Dowling James Dowling jd33431967@gmail.com 019792 5 2025-10-02 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-07 17:54:59 120.4 hrs 68b88e4fe4595c07e39460df 000018553 3.00 82.00 80.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15801 dd0ca599c971d5aeb723bd79138192238f98ab4adaf43f180e3a1580897b7a4b 68a7661ad0f366edf40a51ec 689d064b6695144eb379ffe6 Stacey Malik Stacey Malik stacey.Malik@colorado.edu 017794 6 2025-10-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. DELETE (should've been cxl'ed pt rxl'ed to next week already) SL 10/2 Sophia L. 2025-10-02 17:41:29 0.2 hrs 68a7661ad0f366edf40a51eb 000017119 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15800 7a1e3d7b42b588b0426ff16cd038c07e4b0331ec24986969e1e5064d0e31d37e 684b17b665f9be07a72f0e57 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-10-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-02 18:09:09 0.7 hrs 684b17b665f9be07a72f0e4c 000009154 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15799 f123f873736512c8a333d3490878d7729fc67a04d4438fed5007934eb9f36e2b 68dae78152cd8aca3ac3a5cd 68d16ae1d55d168d08c8d45f Mccall Laswell-Warneke Mccall Laswell-Warneke mdlwarneke@gmail.com 019909 33 2025-10-02 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Emmie Gebhardt 2025-10-02 17:43:11 -0.0 hrs 68dae78152cd8aca3ac3a5cc 000021493 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15798 41d1af67992b468a4c051d55c05de900a4eec86ce2524116a74d9d464ded7cdf 68cafcf6bfe88e6e0d3b2ade 67ced46c7abf9f3ed8fed124 Mary Moulton Mary Moulton mgmoulton@gmail.com 010270 57 2025-10-02 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Kenneth Dave Francisco 2025-10-06 18:24:29 96.7 hrs 68f6b011376f8c90fba2cb49 000020039 3.00 75.31 75.31 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15797 65a4e85e58bdd8acdcc0cdf4223f4a794593a13c6c863975f94aee6d7b1047fb 68ae43d27cee0a285369cf80 68a499beca96e381ab336765 Natalie St Denis Natalie St Denis natalie@stdenislong.net 017821 54 2025-10-02 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-10-02 18:29:42 0.7 hrs 68ae43d27cee0a285369cf7f 000017679 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15796 696218b1f106dd7db5ad3082540c2ebc10460d9323dc93b364565c33f5c65526 68a5e23416dfe607cc534164 67ced5cf7abf9f3ed8ff08e0 Thomas Sullivan Thomas Sullivan sullivanct@yahoo.com 015024 88 2025-10-02 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sonya C. - Sophia L. 2025-10-02 17:32:36 -0.2 hrs 69d847a87ab32f1ac7ba526c 000016855 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15795 4bbedcd6e6844cd1606c1bce4e128f46b7feb05282dfc537fad9ab7ca4ac4ed7 6852e7d822747fdb1786a9bf 6852e558aadef3077e1fb0f0 Steven Maxey Steven Maxey slmaxey@gmail.com 017470 15 2025-10-02 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ patient unable to make this appointment Elizabeth Cousins 2025-10-01 18:48:53 -22.9 hrs 6852e7d822747fdb1786a9b6 000009751 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15794 5d58b114f07049ea59f65e7186c963f5567cad3933c073fe2ee94eacb21c6a06 68d573a54abee55bf0ab4f54 68a5f331cc00ec0894e708c3 Sandra Squires Sandra Squires ssquires2@comcast.net 017835 32 2025-10-02 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - No Emmie Gebhardt - Emmie Gebhardt 2025-10-02 17:57:12 -0.0 hrs 68d573a54abee55bf0ab4f53 000021008 3.00 232.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15793 e4af6d388958958123a55658f415f02eb2f921ce4e569c7bef2221b68a34d395 68c0a9185a98060931d9cb8f 67ced4627abf9f3ed8fecf4a Michael Lovy Michael Lovy michaelrlovy@gmail.com 010112 37 2025-10-02 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/15 Sophia L. 2025-09-15 16:21:16 -409.6 hrs 68c0a9185a98060931d9cb87 000019314 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16
15792 f6a8dfd0701f0beb95e3e6d0c55d65c4466b02fefc9f99746476ee905f63fa94 68c0447940fc4f3c6d0f1f57 67ced3437abf9f3ed8fe86c9 Kristin Dugger Kristin Dugger kristindugger7@gmail.com 003927 55 2025-10-02 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-07 18:09:18 120.2 hrs 6904e431f3710f151b6413e2 000019164 3.00 82.00 98.00 - - - - - - - - 2026-02-19 23:07:05 2026-05-13 23:32:16