General Visit (PT Boulder API)

Total rows: 100,227
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
7541 98910847b0eb1dd0cd75dba6adb0bea6f7e4b28dbfc61e86930f23f984b1b28a 68f66fd22362a9bc8592533b 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-12-15 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2026-01-12 16:37:40 670.9 hrs 68f66fd22362a9bc8592533a 000024013 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7540 549102147f79c7e02187b6d12a045c607085e43d5f0c96bdfc29e715f29a2399 6931a4e026d01fb655fe55b1 68927a5581dca5077cc2ae98 Dianne Inglis Dianne Inglis Diannecinglis@icloud.com 017757 30 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Renee Carr 2025-12-15 17:59:19 -0.0 hrs 6931a4e026d01fb655fe55b0 000029617 3.00 86.11 86.11 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7539 566c220a3151e1352e303c5b12be607f72486a4ad4cfcc6d47dbab7975475c8c 690e73c54b17bb6cc9528c00 67ced52c7abf9f3ed8fef178 Redema Seals Redema Seals gigi33@comcast.net 013028 37 2025-12-15 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt doing well, no need for appt - RAR 12/3 Rosey Reed 2025-12-03 23:49:36 -282.2 hrs 690e73c54b17bb6cc9528bff 000026469 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7538 69566d58036a99557c5134fe9174cf793d3c1b06b5b7e1bc86da2df681309948 68825b9ec821f807f19f3678 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-12-15 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Renee Carr 2025-12-15 18:02:03 0.0 hrs 68825b9ec821f807f19f3677 000014196 5.00 390.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7537 844480626da55ea7a46137a5fa3e6c351ed52a10cdd19538ce4e4434b827def0 6859c9fe2991f7076ec80f38 67ced5a17abf9f3ed8ff0296 Jane Stockebrand Jane Stockebrand wjstockebrand@yahoo.com 014488 122 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Renee Carr 2025-12-15 18:17:28 0.3 hrs 6859c9fe2991f7076ec80f33 000010429 2.00 59.50 59.50 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7536 5d9f5ec33b047f02ea333dbf709a42d3f02fb78a6297221fc9c6329a4530170d 693714f14089bea6c4ba8994 68cae7e256bd091ec769ba53 Kenneth Roth Kenneth Roth ken@kenrothassoc.com 019882 16 2025-12-15 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-12-19 20:05:46 97.8 hrs 693714f14089bea6c4ba8993 000029929 3.00 80.00 80.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7535 514418f85d335ff6cc6ce99fcb02f48cb53cad71418d587fe70474fcf8bf74db 692f0e195f2107a35274afea 67ced5807abf9f3ed8fefdec Tammy Salazar Tammy Salazar tsalazar@cochlear.com 014090 18 2025-12-15 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Eva Tucker 2025-12-15 18:51:19 0.6 hrs 692f0e195f2107a35274afe8 000029279 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7534 40af13917a67b2ae6549e692b956fd1448129a6db739d95605abf3bed957a9be 690cdfa481f38df65e6ca3f5 689f865f86088c9243dfeae8 Hollie Hardman Hollie Hardman holliehardman@gmail.com 017808 26 2025-12-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2026-01-12 15:47:33 669.5 hrs 690cdfa481f38df65e6ca3f1 000026284 4.00 95.77 91.85 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7533 2a8533714ce7e65d9e32de0134fe070ad7d4af3efdba38e1f1c8fd67c7d54c3f 690a32293cfcbaffaaf6f0b9 68c1999da635790853f11a23 Elizabeth Cleveland Elizabeth Cleveland elizcleve@gmail.com 019829 38 2025-12-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sophia L. 2025-12-15 18:10:26 -0.1 hrs 690a32293cfcbaffaaf6f0b8 000025900 2.00 59.50 59.50 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7532 0d1244b4eb68010883cb988d7383fa6cc61c5a5afedb97f8820f83777c400d81 6904e49278ff5e098ce2f0b5 6904e2ec7cb75608ed023624 Cassandra Higgins Cassandra Higgins cassy310@comcast.net 020182 28 2025-12-15 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-12-15 18:17:15 0.0 hrs 6904e49278ff5e098ce2f0b4 000025568 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7531 10af9f418075f6483a521e00e56dcfa9cc093bafd06dd688470f67fd1d1069e3 6902591c6142191bcc6f19fa 67ced38d7abf9f3ed8fe9f00 Julie Heins Julie Heins itnotpa@comcast.net 005993 68 2025-12-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-12-15 18:50:14 0.6 hrs 695d2c964102b5cb2e75bbd6 000025275 4.00 97.16 97.16 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7530 ce8bf940f61ca8ce23290b26365254ce960ef3d6b023bfa2218f5bc8b4f42730 68e927b3c379ef09c1a9aa10 68e926bac379ef09c1a9a263 Cherryllean Shuler Cherryllean Shuler cherryscheesecakes@icloud.com 020042 7 2025-12-15 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 12/8 Sophia L. 2025-12-08 18:08:42 -168.1 hrs 68e927b3c379ef09c1a9aa0b 000023030 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7529 e548aef73f56c3f19759e1147667e9d039a5a7102a83302a7aa990279a1da041 68c84eb7abfa37bc25da56e9 67ced2f67abf9f3ed8fe63be Ellen Blockhus Ellen Blockhus emblockhus@comcast.net 000937 74 2025-12-15 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2026-01-12 16:38:49 670.4 hrs 68c84eb7abfa37bc25da56e8 000019775 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7528 916ebc3c7988c7aeefb2646c9546ee8de42c991f899880d6756e2c0dfad81afb 691e255d1fa7417b2bbd8942 691e24ffe88b91852894e217 Lindsey Ray Lindsey Ray lindseytray@gmail.com 020270 9 2025-12-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-12-19 18:04:28 95.6 hrs 691e255d1fa7417b2bbd8941 000027829 3.00 85.00 100.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7527 7260227193ee3256bbb1b45dbaba93fda20cb6c48da8b44f05f5484b1f085a69 690d199b7fac63df6bd1ffde 690d18e24c287684fd9ab0f4 Douglas Hoeprich Douglas Hoeprich doug.hoeprich@comcast.net 020220 9 2025-12-15 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sonya C. - Michelle W. 2025-12-15 18:25:19 -0.1 hrs 69c1e10beb6daac5875651b4 000026351 3.00 233.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7526 b80d4c2c85f1cc3fcadc35bbd8413fda6c23d50a731f1238d5ca1e1b68c779eb 690cdc6422fb2b09f05bcea9 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 40 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2026-01-06 16:32:48 526.0 hrs 6940623d11cabd9514343c56 000026268 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7525 5f6c1c0d68d0004c90052fa93e411d2df64cc22d42b6ce5c8b38bdf5e5330de7 692f3e33d436047521db8c9d 67ced3b77abf9f3ed8feaa6d Ronald Jones Ronald Jones jonesey.boulder@comcast.net 006968 60 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-12-19 23:05:06 100.3 hrs 6945da4969f3656d532818ff 000029422 4.00 188.00 204.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7524 194b341a7cc02993ed09f9b9129afe531350d65192ce02d5049e46819ee00137 69012e53458ab9097f3943fe 69012dfc789b0904ef7db9c7 Reis O'Neill Reis O'Neill reisponsive@gmail.com 020161 6 2025-12-15 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. Car is not starting - RC Renee Carr 2025-12-15 19:10:12 0.4 hrs 69012e53458ab9097f3943fd 000025135 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7523 b9220e6aac40848479bcbc384e647f0e5c281da547f86879de6484325bb6b84a 68502ef59189370889e4ade7 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-12-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. 24+ dup appt- sc Sonya C. 2025-11-24 21:54:24 -501.1 hrs 68502ef59189370889e4add3 000009359 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7522 e4a2a23b040c6133b58299492d68a36bc28797038e976d70c206c14604840fd6 68dad6a97ec86a28cd12b204 67ced46a7abf9f3ed8fed0c7 Erris McCullough Erris McCullough errism@hotmail.com 010239 46 2025-12-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-12-15 20:02:04 0.8 hrs 68dad6a97ec86a28cd12b202 000021397 3.00 80.26 63.94 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7521 4c06d5f88252022632661752796832ab27f66af3082f6dfb07575d396bdb9c5a 692deea343817f3a00a6db5a 67ced6057abf9f3ed8ff0fc2 Karen Weaver Karen Weaver karen.ececonsulting@gmail.com 015611 71 2025-12-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ changing to 45 min appt on Friday - 12/8 RAR Rosey Reed 2025-12-08 17:08:06 -170.4 hrs 692deea343817f3a00a6db59 000029160 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7520 3d59ff33929a764f3c851a53833de37a1c221cbe26abc54df5100da6d1b31ebe 6920ccb68731e3d19597bbef 6920cbbb8cae0ac8ba3120bb Linda Erskine Linda Erskine lindalee0713@gmail.com 020288 9 2025-12-15 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Sonya C. - Mark Leo Guevarra 2025-12-19 18:55:45 95.4 hrs 6920ccb68731e3d19597bbe7 000028097 3.00 232.00 15.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7519 faa112b13c61dd9d275c9e6fc63b196ae6a705c3fd0c647bbc14910dffe6fb93 69209d35e1cdc3abf3962eb8 689df568fb4c9607d3cd73e1 Emily Baldwin Emily Baldwin baldwinemb@gmail.com 017797 22 2025-12-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sophia L. 2025-12-15 20:03:13 0.6 hrs 69209d35e1cdc3abf3962eb7 000028039 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7518 7646bdab1982f4ce266e3208fe65f46e36656804b83ac0a99b8e265c1c6cfce1 691de5e756b854cae7b77d57 67ced4567abf9f3ed8feccf5 Margarita Delopez Margarita Delopez xelajuj@icloud.com 009913 124 2025-12-15 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ we are OON with her ins Michelle W. 2025-11-19 22:20:48 -621.2 hrs 691de5e756b854cae7b77d56 000027710 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04
7517 3bbc541a57cd9ad2a1509453f01baaa4982f52dc530dd6bafa37c684cc490f3b 691cbbf3eac50e1a5618ae70 6904dedbd40eff0953ee41ae Elizabeth Penziner Elizabeth Penziner elizabeth.penziner@gmail.com 020181 27 2025-12-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Jayvee Totanes 2026-01-16 22:01:19 770.5 hrs 696ab554699b37523cbd2b46 000027624 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:43:45 2026-05-02 23:09:04