General Visit (PT Boulder API)

Total rows: 101,008
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
15029 42051db5e5f4f4714d2c6ce9eeb552787a58c75cbc03d75fab5c92e68339868d 68d1cf33fdf047afde51fabe 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-10-09 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-14 22:35:08 128.6 hrs 68d1cf33fdf047afde51fabd 000020546 3.00 85.00 55.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15028 d69f3086785e54c41b8ccc0a92506a4a6e65179aa8990185612a2226f3c6bfce 68c87a39fcdd9c8269612325 67ced34d7abf9f3ed8fe8a33 Paula Gallup Paula Gallup paula.k.gallup@gmail.com 004218 24 2025-10-09 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt has shingles and is in pain - sc Sonya C. 2025-10-08 14:17:16 -23.7 hrs 68c87a39fcdd9c8269612324 000019820 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15027 96856a0f1d581b43591de9f2b60e2368d69878031e307c27dc399d96495a5119 68e4433a0998db2b7e1f54fe 68de96eeeece7a0874502215 Avery Van Riper Avery Van Riper the_ripers@hotmail.com 019975 10 2025-10-09 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-21 17:36:14 291.4 hrs 68e4433a0998db2b7e1f54fd 000022451 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15026 3ff1406ffc17482ed766cd31f05912fe9069e1c3e6d2e3861b448a2c5f8b78b1 68e004adc9928b2eac6f080f 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-10-09 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt conf cxl SL 10/3 - changed her mind can't make it in this day Sophia L. 2025-10-03 17:20:55 -140.9 hrs 68e004adc9928b2eac6f080e 000022187 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15025 612131a9c2a55db0d956c7214ffe603c9e680363a10fe04a4cf182b116bdf83b 681a46b43f39603d2a54a7a5 67ced5cf7abf9f3ed8ff08ce Julie Volckens Julie Volckens volckens@gmail.com 015018 94 2025-10-09 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - System 2026-02-02 07:01:01 2776.8 hrs 681a46b43f39603d2a54a7a3 000004457 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15024 4a996a131c814bd0f36aaee1fb8548831f897c488000c2c12495247ea447e709 68cdaed77e6ae9aedddef84e 68702d98ba2ff3b0f5bf6d28 Susan Rewinkel Susan Rewinkel susan.rewinkel@colorado.edu 017604 9 2025-10-09 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-15 15:42:21 145.2 hrs 68cdaed77e6ae9aedddef84d 000020348 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15023 8429564f5ed478ac1919b857c27b748a12a4d7a61b256f55a8dddb9e4d0083e0 68cc1c8130b577553417ecb4 687eb18de858562ab471871c Summer Pfluger-Prouting Summer Pfluger-Prouting summer.noelle23@gmail.com 017667 17 2025-10-09 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-10-09 14:40:52 0.2 hrs 68cc1c8130b577553417ecb0 000020106 3.00 85.00 59.50 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15022 de40c0a7db34fd962ccf596cd2a0a0c743c4e3f024d5f1aecca0027e26851cff 68c88311125d174a9d64c772 67ced2e97abf9f3ed8fe5a7f Susan Benson Susan Benson susan.benson52@yahoo.com 000148 116 2025-10-09 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-10-09 14:28:35 -0.0 hrs 68c88311125d174a9d64c76e 000019837 3.00 80.26 63.94 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15021 5cc97e6559f41e76120a153821a1bc1f23f81e560b0259e685862bc21e2b5e3f 68b9c55809a34b8b62d15335 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-10-09 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-09 14:24:01 -0.1 hrs 68b9c55809a34b8b62d15331 000018692 2.00 60.00 50.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15020 99e74d20bacf2a487466d8c3da2e09401547394517f8c6266aabd66b67dd15b1 6880fa497684779e6cc038f2 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-10-09 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-10-09 15:05:34 0.6 hrs 6880fa497684779e6cc038ea 000013954 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:05:05 2026-05-08 23:29:03
15019 7f042524fa0cc4907c5bade9b69935d801621128bb61139a6d3c37909a85b909 68dea29f6042fdf113b0efab 68dd78205b4918097240a97d Anne Paul Anne Paul annepaul34@icloud.com 019971 27 2025-10-09 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-10-09 14:43:00 -0.0 hrs 68dea29f6042fdf113b0efaa 000021996 4.00 91.83 91.83 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15018 c20fc5fef1119315acb9e5807ecaab2f2384539791b0a973f4221602c0d56def 689dfeed6695144eb37d70ea 67e1258a54aaaa3a80096c54 Lisa Darby Lisa Darby lisadarbywx@gmail.com 016740 36 2025-10-09 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-10-09 14:43:59 -0.0 hrs 689dfeed6695144eb37d70e9 000016296 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15017 0e47ba510e0d58e1747b860e26197d3fe00a693450b220b3c8fb5e637cb9786c 687fabd6c70e6307c2d5d75e 67ced6467abf9f3ed8ff1828 Blake Wollenberg Blake Wollenberg bwollenberg@gmail.com 016327 94 2025-10-09 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-10-09 14:26:10 -0.3 hrs 687fabd6c70e6307c2d5d75d 000013781 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15016 983efae20de72f87bd6698823d37e23a9694c48e9c1d76787d89ab3f0960c2cf 67e67181ceb9f104f028c10c 67ced30a7abf9f3ed8fe6f5e Mia Davies Mia Davies miadavies2705@gmail.com 001929 25 2025-10-09 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton SL 4/28 pt conf cxl (Terri Out) Sophia L. 2025-04-28 15:55:51 -3934.8 hrs 67e67181ceb9f104f028c10b 000151671 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15015 1deae977aecfeef8aac1ddf323e81fce0877c26561dcf8bd2f091f7ecfb1934d 68deaa514fe5dc6838915318 68d4ae7b8bf10c6d835d936c Amy Puls Amy Puls amylpuls@gmail.com 019929 42 2025-10-09 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Emmie Gebhardt - Emmie Gebhardt 2025-10-09 15:02:52 0.0 hrs 68deaa514fe5dc6838915317 000022006 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15014 6620223882b594cb7ee4a735a9df4eae2cb01d400448b6ff665539799f3f05c1 68d593e3e7cb52d6fa869f12 68c85de63fc016012b056010 Susan Rhine Susan Rhine susanlori@gmail.com 019854 18 2025-10-09 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Emmie Gebhardt - Kenneth Dave Francisco 2025-11-04 17:06:39 626.1 hrs 68d593e3e7cb52d6fa869f11 000021056 3.00 84.46 86.70 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15013 9a56fe6b909bf5d019b8f05e36e79955e9d8e374bf9ed14505976c58e3b584ce 68d2b5baacfd44a90546ba2c 68d2b51907213e079588f54d Christopher Walzer Christopher Walzer chriswalzer@comcast.net 019916 28 2025-10-09 Checked Out 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sophia L. - Sonya C. 2025-10-09 14:47:40 -0.2 hrs 68d2b5baacfd44a90546ba2b 000020572 5.00 189.65 151.11 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15012 136f75fa13ffc8ddb9876d81de27e3d98cd49611a13e1c36c8d308d7f78fa17e 68cc63ddb182cb1769b1cb01 68c9ae2ab1980b077ac60e90 Alyssa Grover Alyssa Grover ANKG@icloud.com 019872 10 2025-10-09 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-15 22:27:30 151.5 hrs 68cc63ddb182cb1769b1cb00 000020181 3.00 85.00 102.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15011 ae7ec94aad790af139eb8480c74d1d9f197c04c8cf15e192b6602e3322b68ea0 68c1de0dad9caa447e988a98 68c1dc28339acc472f869398 Christopher Duhon Christopher Duhon cbduhon@gmail.com 019835 19 2025-10-09 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Rosey Reed 24+ pt conf cxl SL 9/30 (Only keeping Tuesdays) Sophia L. 2025-09-30 15:29:31 -215.5 hrs 68c1de0dad9caa447e988a92 000019446 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15010 a6230037621c9bdef8124c713ef45ad413f5dfc5eb7c0bc1a7497941766d859a 68adf2fcc7870c078fed3c4c 6887e0ede865e4c32e1242ea Alice Ruppert Alice Ruppert aliceruppert@gmail.com 017714 8 2025-10-09 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2025-10-09 14:56:52 -0.1 hrs 68adf2fcc7870c078fed3c4b 000017582 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15009 d02ddd7970468d97573e9107f9eec5a9cbc022d3a01c99441ad970293ed0a263 687680115e37c3086a7b366c 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-10-09 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Maia H. - Kenneth Dave Francisco 2025-10-15 19:10:52 148.2 hrs 687680115e37c3086a7b366b 000012977 4.00 312.00 5.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15008 34d06dd8ea901562f3f4d17aea89108d2c142901e609dfd040ad2e8068daf49f 68d2f516cdc37d57055169a3 67ced3bb7abf9f3ed8feab84 Robert Joyet Robert Joyet robertajoyet@msn.com 007061 62 2025-10-09 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-09 15:16:48 0.0 hrs 68d2f516cdc37d570551699d 000020682 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15007 5f6da9f4d0ea8aa10a4a7096b9ea4a8575a69691b60d68f68737ec11da943cfb 68d1bd5223e1b1d239f5da18 68d0ce55b2306a20a239a871 Sara Roberts Sara Roberts sara@newagere.com 019905 35 2025-10-09 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 16:11:04 288.9 hrs 68d1bd5223e1b1d239f5da17 000020529 4.00 82.00 81.60 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15006 d4ad02da2994d7dc3434a9bcf4478b856d155dd1ce91d4ae72b511b8b6ef50d2 68c898e16357187d82548dca 67f68f3fa46f33086765ff96 Paul Encinias Paul Encinias e-boys@comcast.net 017018 25 2025-10-09 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Kenneth Dave Francisco 2025-10-15 16:06:31 144.9 hrs 68c898e16357187d82548dc9 000019852 3.00 81.43 81.43 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03
15005 a20404af8365336a75e939050fcc0fc784b472749424d46ef8d53616206feb2c 68bf051576245891222fe317 68a3774c23652c07d28dbd8e Kellee Rutz Kellee Rutz jake040117@hotmail.com 017815 29 2025-10-09 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Having injections and needs to wait awhile before beginning PT - sc Sonya C. 2025-09-23 17:19:49 -381.9 hrs 68bf051576245891222fe310 000019021 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:04:48 2026-05-08 23:29:03