General Visit (PT Boulder API)

Total rows: 101,344
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
14736 9e040c6b831b6613888ca209af605f3a10c2fcd55041b1f1578f6246cd2a2011 689f87d7d5baa307dfd0e662 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-13 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-13 14:35:38 0.1 hrs 689f87d7d5baa307dfd0e661 000016471 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14735 d8087a4d819fe4311cad37d57ea0794e2690f895591262f35aaada99c3a6cd84 688a4a2f99de3307937a0396 6837463af6142b08391bddd6 Nancy McCoy Nancy McCoy annemccoy27@gmail.com 017327 48 2025-10-13 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt having surgery- sc Sonya C. 2025-09-08 15:15:45 -839.2 hrs 688a4a2f99de3307937a0390 000014774 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14734 eb5f4f422d0321534fd4b80d9f57fee2d492ab72f242f4d65ab35de53f71fea5 6891295c680b2be6d5d950a9 67ced6447abf9f3ed8ff17e6 Richard Wolf Richard Wolf richwolf@infoscapes.com 016305 107 2025-10-13 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Libby will be out of office Elizabeth Cousins 2025-09-26 15:53:34 -406.9 hrs 6891295c680b2be6d5d950a8 000015337 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14733 7a66965b8553ad578fd51a25269bf4b06836454f6be72d67077530f24557f021 68e913dbcf6575099d895a3e 68dd4ad85586a80982267801 Deborah Correll Deborah Correll dbcorrell@yahoo.com 019966 21 2025-10-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-13 14:59:26 -0.0 hrs 68e913dbcf6575099d895a3d 000023010 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14732 f9dd2c452cfa4e0dfec541831c69a915ff84b482f0a67b8812c150522628db55 68d2ec6844c7854b95708bf4 68ae31c602a116dd897f1858 Lucia Karki Lucia Karki lucia.karki@hotmail.com 019749 13 2025-10-13 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Emmie Gebhardt - Mark Leo Guevarra 2025-10-17 21:50:46 102.8 hrs 68d2ec6844c7854b95708bf3 000020676 3.00 82.00 81.80 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14731 483b84c3ec3f5213f92775ca057ec1655c26274ad065b2db6d74cf0e6e7ac84b 68d17265152b0c07eaa0b7f3 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 15:59:20 217.0 hrs 68d17265152b0c07eaa0b7f2 000020424 3.00 82.00 77.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14730 bc977b3a34ba4086ff9cc0cd14c3e1b85369cc6a37cdc6066aa686484a3ad5a2 68cd8d23623f78d0557a8fee 68cd8c7944260a08a862447a Violet Helsing Violet Helsing nielsentina@yahoo.com 019898 9 2025-10-13 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt is not feeling well per Tina N -mw Michelle W. 2025-10-13 14:22:54 -0.6 hrs 68cd8d23623f78d0557a8fed 000020320 1.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14729 54d2c4a7e223da99bcf45500a9076690036ab97c894cdd135649f05556d5cc06 68bf3d8fe40c6bf26cc2e114 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-13 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Mark Leo Guevarra 2025-10-22 18:38:21 219.6 hrs 68bf3d8fe40c6bf26cc2e113 000019103 3.00 78.77 78.77 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14728 14d16139cd9ad0a4534263c249e2e0014b066da05ce38f5a84959ada0d5680ab 68ac8641c9c67989e1d00ca9 689264aa22e70f07b2aca32b Kumiko Pentz Kumiko Pentz jpentz1@gmail.com 017754 11 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-13 15:02:25 0.0 hrs 68ac8641c9c67989e1d00ca8 000017376 3.00 80.37 80.37 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14727 c4f927658e7e18b9e242515e455decbda604f5e11ad224ed4e2cd5ea653b8a98 68b9ad2f73eb2a0fe28c89ee 6840939c41546d0bc96f1398 Grace Keeling Grace Keeling keelings@gmail.com 017389 12 2025-10-13 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Per email request - sc Sonya C. 2025-10-13 03:03:23 -12.2 hrs 68b9ad2f73eb2a0fe28c89ed 000018665 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14726 e4823ff4c0ab59489fa41ea17637b5d5f16edc4c8a5e9d3a8812f5d1a5f9a623 68af2d04b3461907e3aa4d6d 68af2b6bacebc94ce8ed20e5 George Kretke George Kretke gkretke@msn.com 019756 25 2025-10-13 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Rosey Reed 2025-10-13 15:09:58 -0.1 hrs 68af2d04b3461907e3aa4d6c 000017755 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14725 4c7384cb2bd24b7f0c86f9eb508ae0bb08bd772174c990b0f2b0c7a4858262b0 68a3484ddde57e085fab1d99 67ced3107abf9f3ed8fe720a Robin Davis Robin Davis rdavis5669@comcast.net 002157 126 2025-10-13 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ - per VM request, she finished her work w/Dawn in Sept. - sc Sonya C. 2025-10-13 11:44:33 -3.5 hrs 68a3484ddde57e085fab1d98 000016526 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14724 e966d7b2d894cca5f774c4480fc6abfd3e456a5b1fe520564c3fac6882760ac8 6890f367c1f7c6e6b3decc64 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-21 17:49:31 194.6 hrs 6890f367c1f7c6e6b3decc60 000015248 3.00 60.00 65.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14723 60f01c2ba77beb5f758048ae409058c06c526656757c8f09b50f3d0e8db4f18e 687e6660564e4807cd3e2556 67ced3dc7abf9f3ed8feb382 Chet Kieffer Chet Kieffer chetkieffer@gmail.com 007743 116 2025-10-13 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Libby will be on Vacation Elizabeth Cousins 2025-09-08 15:57:06 -839.3 hrs 687e6660564e4807cd3e2551 000013644 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14722 114c035c1e90c50862df0292a343e6f2592e8b81c78ff6cbbd9d5990c18d593a 68d176a4152b0c07eaa0f1fc 68a7419f5ecac95c5376d4cb Regan Kline Regan Kline rak777@hotmail.com 017879 8 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 16:01:23 216.5 hrs 68d176a4152b0c07eaa0f1fb 000020439 3.00 85.00 110.50 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14721 ebf34376d05f0e5d615e88ebbb42a1b0e6cfd37abc4c1fcf9289a3eaeea870ca 68adf656344cc1979be976eb 68adf51e15d4d207dafad28b Susan Anderson Susan Anderson andersonsusane@msn.com 019745 6 2025-10-13 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Michelle W. - Sonya C. 2025-10-13 15:25:37 -0.1 hrs 69827bd3d9b499e49cd513e0 000017585 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14720 e8d2683c2b5463e3c110161f36d45d8ddbcd3694c6537c2a04de03f753a4ac36 68e809e884399a66c3eee983 68a5df6f0a9ff4d6b25f77d0 Randall Harrison Randall Harrison rharri4145@gmail.com 017829 20 2025-10-13 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Frances Lawrence - Emmie Gebhardt 2025-10-13 15:40:56 -0.1 hrs 68e809e884399a66c3eee982 000022959 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-05-12 23:29:25
14719 2490361ac3c6cf786e34ec0bd678245885fbc7510122d2a9e4e82658ccfdbb5a 68dad258e357404742a7b710 68a607e76f38194b967a4c7a Joe Garner Joe Garner joegarner51@gmail.com 017839 14 2025-10-13 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Emmie Gebhardt 2025-10-13 15:40:41 -0.1 hrs 68dad258e357404742a7b70f 000021389 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14718 41922dc2fdcbe49015bf16bc82b5531f170eb700c5fe016e9717b6c137e95bac 68d2b72f7c046808127f7dc3 68d2b6c2a59b20a62e165909 Pearl Crespin Pearl Crespin crespinpearl@gmail.com 019917 8 2025-10-13 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-20 21:48:00 174.1 hrs 68d2b72f7c046808127f7dc2 000020577 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14717 18f39349d467a93c7051588bcd6cbe9b3d2f319a5591ecc56c5e5d051bd6ccfa 68b1ec4c50b03f0801b27176 68b1e83ef391642b2654c4d7 Joyce Gordon Joyce Gordon jay_gee@comcast.net 019783 53 2025-10-13 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-13 15:44:09 -0.0 hrs 68b1ec4c50b03f0801b27171 000018220 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14716 e8bc76455dfa5adb47431c1335d1b78353f7b9046791df40bc4c49ae42762e4c 68dab4a9560e7bf8b52438ad 68bb234f83c31468e4f54258 Brian Hedstrom Brian Hedstrom brian.hedstrom@gmail.com 019811 9 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-10-13 16:00:42 0.0 hrs 68dab4a9560e7bf8b52438ac 000021354 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14715 eeb28a7b8dbc7ab7691c19e4ec7c6b19733d6851c02d5b9267d636aefb5fdf38 68d16b0f2f0cca730f177d25 684840b5f839a307c1ba93c5 David Wynja David Wynja chris@wynja.com 017425 13 2025-10-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - System 2025-12-08 07:00:47 1335.0 hrs 68d16b0f2f0cca730f177d24 000020395 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14714 90be64a8dcc6e441c98e0ad59a3b8da2e15234bf977f26a4688fd5fadfbd83af 68cae8241586771def448a8f 68cae7e256bd091ec769ba53 Kenneth Roth Kenneth Roth ken@kenrothassoc.com 019882 16 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 16:02:06 216.0 hrs 68cae8241586771def448a8e 000020025 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14713 0a1450fc22b34de2e6c769777718ec80e7b64030cfb1ee3ac88d7a4967d7fce1 68acb99d37ad47cec7242a70 67ced3d37abf9f3ed8feb172 Melinda Kelsey Melinda Kelsey fmkelsey@icloud.com 007567 26 2025-10-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-10-13 16:01:02 0.0 hrs 68ffcc6be6e58a089d235ca5 000017445 3.00 77.82 77.82 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25
14712 ed594a61a927f9db05e39e23c3f14701b2e90764f558dae96335ba7ac7097d38 689f9cbe6695144eb385fd58 6841aec869926f07c6a1ca4c Joseph Kurtz Joseph Kurtz joekurtz@indra.com 017394 16 2025-10-13 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins 24+ Libby on Vacation Elizabeth Cousins 2025-09-05 16:54:34 -911.1 hrs 689f9cbe6695144eb385fd57 000016487 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:15 2026-05-12 23:29:25