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
6193 87089149742013c9347035a291a57941e6b02ab934ed899cd77922befad6a100 6920ccb68731e3d19597bbf2 6920cbbb8cae0ac8ba3120bb Linda Erskine Linda Erskine lindalee0713@gmail.com 020288 9 2025-12-29 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. OOT - sc Sonya C. 2025-11-21 20:34:24 -910.9 hrs 6920ccb68731e3d19597bbea 000028100 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6192 9f8e3dd8e67953c5604e99e96fcc2bf355bffae3cd29b9480de6ac97a73a2e34 691dfd0be4c64d3e4f66a495 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-12-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ per email request, no reason given - sc Sonya C. 2025-12-29 04:38:04 -14.9 hrs 691dfd0be4c64d3e4f66a494 000027763 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6191 ccadd8510830dc69bf558eacd020aa655bad7672e3c72b73c6bb435694e2c888 691ca226407595510e2ea1ad 67ced6667abf9f3ed8ff1c0d Francesca Villalobos Francesca Villalobos fran.mueller31@gmail.com 016657 10 2025-12-29 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. pt sent email that she is sick -mw Michelle W. 2025-12-29 14:16:35 -5.2 hrs 691ca226407595510e2ea1ac 000027568 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6190 397e82d3c41cd2fde1521bbcb8b3c500ea2f42f00c9dedccb4a6a40f92d992f4 690d13110d01b036a3d373d0 690d118bbf8c8a2d0d3ea986 Patricia Bryant Patricia Bryant indymom929@aol.com 020219 6 2025-12-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-12-29 20:09:05 0.7 hrs 690d13110d01b036a3d373cb 000026331 3.00 60.46 30.46 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6189 af6bcf618a689980273b6f48c03cd1d3fb007b1ce2b4210f60cf819c62b98039 690a30eb1e054f10db400ae5 67ced47b7abf9f3ed8fed40f Dona Parks Dona Parks melissa.parks79@yahoo.com 010519 74 2025-12-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt has to have surgery Michelle W. 2025-11-19 16:56:15 -962.6 hrs 690a30eb1e054f10db400ae4 000025895 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6188 0cfb891564f78e00048e71914d76c719b0ce207dd62c38740357428f9826ab3c 6908ce77a5fd5a3a5fb47793 67ced3047abf9f3ed8fe6c2e Jojo Daneker Chard Jojo Daneker Chard jojo1209@msn.com 001657 17 2025-12-29 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ scheduled too many appts- sc Sonya C. 2025-12-04 17:08:48 -602.4 hrs 6908ce77a5fd5a3a5fb47792 000025650 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6187 32597e8e476960d40c7d837dd3804e265dc70116ff5fa3603f788627cb0b63b9 690109d6c9fd81098a51165a 690108753a7eb53473462a76 Brittany Altmann Brittany Altmann altmannbrittany@gmail.com 020158 11 2025-12-29 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ No longer needs appt - sc Sonya C. 2025-12-10 22:54:11 -452.6 hrs 690109d6c9fd81098a511659 000025079 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6186 cf0c3d53101edcbc174cb2c52943eef1d31d16bfee591f5a4a0eb97bac8e3c61 68fbe8f7381f10e86f50e00b 67ced3787abf9f3ed8fe98ca Erika Grant Erika Grant erikagrant834@gmail.com 005463 75 2025-12-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayvee Totanes 2026-01-06 22:04:52 194.6 hrs 695d873e7d7b8b43f95c2f07 000024813 4.00 82.00 162.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6185 3a9e852a0922286a0ca4a852f357efeb1875deca8b4657e89eae955bf1b4934c 68f670206f28b0cdd7f2db47 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-12-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Rosey Reed - Jayvee Totanes 2026-01-02 17:47:11 94.3 hrs 68f670206f28b0cdd7f2db46 000024015 3.00 -178.00 60.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6184 e3038eeda0cd2e4320ae096569dc66f040bfba07ead6c61dbb2407629199264f 68a380c148b50f077ee3f40d 67ced4707abf9f3ed8fed1ed Mary Ann Paliani Mary Ann Paliani paliani@msn.com 010337 63 2025-12-29 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ libby out of town--confirmed in person with pt on 11/17 Elizabeth Cousins 2025-11-17 19:40:23 -1007.8 hrs 68a380c148b50f077ee3f40a 000016570 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6183 859eb6bb903d97bf88c6edaa79cfdacb6003fa8a69d8bf706b374615f74873b7 692f32ad42e2d9cd3e3a6440 68e6ba677fe660097b92ecac Tucker Mills Tucker Mills tuckermills573@gmail.com 020020 21 2025-12-29 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Rosey Reed moving to Denver Frances Lawrence 2025-12-16 17:59:48 -313.8 hrs 692f32ad42e2d9cd3e3a643f 000029376 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6182 5bc548973e4f5a62401943916111161a9cd8e739036f5af851b2233843503298 69052e609876a409c94a42bf 67ced49f7abf9f3ed8feda3c Noel Nevers Noel Nevers noelsmiles@gmail.com 011046 27 2025-12-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Jayvee Totanes 2026-01-02 18:40:43 94.9 hrs 69052e609876a409c94a42be 000025635 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6181 61a4b3f81429b1b75b7bc8998ace03ef5cb7637c000adbe10001f4c773066965 6952a4e1f818ee31dc2b5cf3 69247a24ef5d509a4b3cb407 Joan Berman Joan Berman jody@bermaneditorial.com 020292 8 2025-12-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Michelle Osgood 2025-12-29 21:47:43 1.8 hrs 6952a4e1f818ee31dc2b5cf2 000031793 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6180 522d43a37c87eb7bb2a1d6473fec169c90ccdd2a599a03153523ce19b1d1a13c 69401b25a30d2b0e539d1e4d 67ced3847abf9f3ed8fe9c87 Johanna Heart Johanna Heart jandsheart@msn.com 005782 59 2025-12-29 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Samantha Saunders 24+ per VM - she is ill - sc Sonya C. 2025-12-29 04:02:36 -16.0 hrs 69401b25a30d2b0e539d1e4c 000030691 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6179 915de40c5c9b84b4a25c02e9a2f4c6923030d9b38dd1448b77f917817aa27821 693a01f53c18fb3083d7ac0c 67ced4567abf9f3ed8fecd13 Cheryl Osgood Cheryl Osgood hwhale36@yahoo.com 009923 8 2025-12-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Sick Michelle Osgood 2025-12-29 00:12:40 -19.8 hrs 693a01f53c18fb3083d7ac0b 000030436 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6178 57d5817cb028d4845c38115c3a899aad88837ed7b700cc24a1d139e1f412d8df 6939a8dc5d89cf017727732d 6939a7dedc0609d0272c186c Reshawn Martinez Reshawn Martinez rae.martinez241@icloud.com 020360 32 2025-12-29 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Michelle W. 2025-12-29 19:59:19 -0.0 hrs 6939a8dc5d89cf017727732b 000030310 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6177 121a20f26d9df2bb7b5288746d3cf9fc323e1d866366f51f599ee90b4b2c72a9 690b8d7900c010a6f1b061d8 68f7c62388ff4e8c9079da79 Griffin Maxwell Griffin Maxwell ashleybuck66@gmail.com 020113 48 2025-12-29 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Mom called @ 12:24 to cxl appt today due pt having a migraine- sc Sonya C. 2025-12-29 19:59:08 -0.0 hrs 690b8d7900c010a6f1b061d7 000026133 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6176 dd150242c083123d7a2f20344a2624281caa36499115b8382753a2e8de76603f 68f159dd97762f457e598158 67ced47b7abf9f3ed8fed3ee Sandra Parkes Sandra Parkes sandyparkes99@gmail.com 010508 27 2025-12-29 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Frances Lawrence - Sophia L. 2025-12-29 20:03:24 0.1 hrs 68f159dd97762f457e598157 000023817 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6175 1833d1eddf9d424f7865059f32a039671fbbdf1502ef6a3c090be07e9f6447de 685c5bd8a615c3da38b3d302 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-12-29 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ LS Off - RAR 9/23 Rosey Reed 2025-09-23 21:04:03 -2326.9 hrs 685c5bd8a615c3da38b3d301 000010819 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6174 313765a8c6c00676fb939e925993baf34b63b855e5844f7bf3137380317dbdad 681cd29ddf368a080575eb12 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-12-29 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 21:32:35 -4702.5 hrs 681cd29ddf368a080575eb0a 000004863 7.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6173 056faf343635d9f891e8702599a883389c5521dd7f2190878c52be17cdfa3151 69409aad9ab09ce83adede17 67ced3147abf9f3ed8fe7405 Monika Atkinson Monika Atkinson mazabkop@gmail.com 002326 80 2025-12-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Sonya C. 2025-12-29 20:12:45 -0.0 hrs 69409aad9ab09ce83adede16 000030854 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6172 c767f81a94baaa33fe0d24569621aedc91db17dd1afd7201e06981d8febb813a 6938ade1056d4307ed9ce535 67ced65e7abf9f3ed8ff1b2e Cathy Zimmerman Cathy Zimmerman cathyzimmerman9@gmail.com 016585 98 2025-12-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Renee Carr 2025-12-29 20:26:25 0.2 hrs 6938ade1056d4307ed9ce534 000030231 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:40:16 2026-05-01 23:06:35
6171 5e0a030c7cf100dfc4e0be2c7cc2302362a26c750db3e2e8ded92ce5c7c2c4d0 6920a36d939c307e453dfdb4 69023d886142191bcc6de946 Robin Reese Robin Reese enoufstuf@gmail.com 020169 17 2025-12-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-12-29 20:08:36 -0.1 hrs 6920a36d939c307e453dfdb3 000028046 2.00 54.29 54.29 - - - - - - - - 2026-02-19 22:40:15 2026-05-01 23:06:35
6170 641ecfc802a4d920484734aa0f7e7e8d0b592b11a10dc6be73e715760befa390 691b98bafbeb4d0a2910b5c3 691b97d26ba14de42aa63f07 Lynda Edgington Lynda Edgington lyndaedgington@yahoo.com 020257 9 2025-12-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Jayvee Totanes 2026-01-06 21:49:04 193.6 hrs 691b98bafbeb4d0a2910b5c2 000027517 4.00 140.71 140.71 - - - - - - - - 2026-02-19 22:40:15 2026-05-01 23:06:35
6169 5b90e541a5a7ecbaded7e9413b910ab196825ced5c6e5accdf71724dd2d308e5 6914ceeff21661b35376d4af 67ced4fe7abf9f3ed8feea3a Lelia Saunders Lelia Saunders lightascolor@gmail.com 012410 103 2025-12-29 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ will come back in the spring- sc Sonya C. 2025-12-01 22:19:16 -669.9 hrs 6914ceeff21661b35376d4aa 000026983 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:40:15 2026-05-01 23:06:35