General Visit (PT Boulder API)

Total rows: 104,153
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
320 94b368af70bd12e406f3fcd987b8e9999c4899e3ae36583477e7defd69feacb5 69724408195c0907092721e2 67ced4ec7abf9f3ed8fee772 Edwin Rehme Edwin Rehme erehme@outlook.com 012173 12 2026-02-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - John Reed 2026-02-18 17:49:28 0.8 hrs 69724408195c0907092721e1 000034810 3.00 85.12 85.12 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
319 7addc70c13392bc7ceac6744533121debe0b78b2723e0249264b5146b1c1966c 696fa9d626230bc598661ed0 696fa8b2d0e7c1a3bc319a3e Douglas Edwards Douglas Edwards q332@msn.com 020584 25 2026-02-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Renee Carr - Mark Jerome Para-ase 2026-02-20 18:11:56 49.2 hrs 69bc0b1d719ab376c2f92bd5 000034419 3.00 235.00 35.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
318 f62349c4448f280afc503b8f038b4177176402dbf284258c152f264c42aef6d7 6949bba70b310f2a2f683c18 67ced6567abf9f3ed8ff1a32 Thomas Young Thomas Young silvercloudstudio@gmail.com 016501 69 2026-02-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ cxl per voicemail request Michelle W. 2026-02-17 17:37:51 -23.4 hrs 6949bba70b310f2a2f683c17 000031565 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
317 94463edf5b65a7a0eecb0e18a8261b40771421455686c585a5afd59afbddcc77 6924ce43756f21cfc925275f 67ced3237abf9f3ed8fe7a05 Niko Dennis Niko Dennis kathyandtasshi@gmail.com 002838 19 2026-02-18 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-26 16:35:45 191.6 hrs 6924ce43756f21cfc9252759 000028253 4.00 313.00 20.50 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
316 d9648d6f2752ec81d6d3e22c1a550654479fb110471a4a7a43f79246e49b521b 6904f60ea50f5f08b1dce2b5 6904ce08a34eefb05698aed6 John Dorsey John Dorsey jdorsey6224@outlook.com 020179 12 2026-02-18 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Mark Jerome Para-ase 2026-02-19 18:23:13 25.4 hrs 6904f60ea50f5f08b1dce2b2 000025599 3.00 92.56 62.56 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
315 d940c305b79aef0f324e62da7e22591aa7b11f123541599f8d142aaa2d215c11 696960184c6f566cfe32b2fd 67ced4007abf9f3ed8febbae Michelle Laub Michelle Laub michelle.laub@bvsd.org 008440 56 2026-02-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2026-02-18 17:29:34 0.2 hrs 696960184c6f566cfe32b2fc 000033926 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
314 69a1f668f158ebb7011095592c4671f799760b96e750b4e40c4079f36ff749b4 693069c25f3e113623f3a2a9 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2026-02-18 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ per VM, pt is sick - sc Sonya C. 2026-02-18 12:53:29 -4.4 hrs 693069c25f3e113623f3a2a5 000029507 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
313 c9444a4e445b33fc6e0a86a51957a804352758fcda7abd1ceb7a1e3abbf50d0c 6925de3d80bb0e133753534e 67e6650befbf2c53d8d5d1b3 Rebecca Carson Rebecca Carson sullycarson@gmail.com 016799 48 2026-02-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-02-25 20:29:13 171.2 hrs 6925de3d80bb0e133753534d 000028538 3.00 79.93 79.93 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
312 df33442825c9129de59a6544d551a49019542ed59361b890a856ac07dbe4d8c3 6970fc4e4d996612b74aea8e 691cdc5b1396b7dfc5d13bb9 Gretel Botsch Gretel Botsch gretelbotsch@gmail.com 020264 7 2026-02-18 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr 2/17 24+ pt cxl, will f/u vis email with PJ, (pt is losing ins as of next week) LS Laura Sage 2026-02-17 18:16:21 -23.2 hrs 6970fc4e4d996612b74aea8d 000034624 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
311 cbf94ff5a97c4c92e91f30e46f2f71e7713b6d2dd76f8ec65c28d31f2a873e0d 694f00843a76f31534949c8a 68e3e626ab83a708b61f8a58 Jeffrey Sloan Jeffrey Sloan ksloan2@msn.com 019994 46 2026-02-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Anne Majewski - Laura Sage 2026-02-18 17:28:37 -0.0 hrs 6a15e95de4d58444fc4a17de 000031766 2.00 156.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
310 c075a35d1d35b21027a302c7d351042b142351b985cc721bb7e8367bbcc7a0ba 6938732cec8d36145ff75f03 67ced6627abf9f3ed8ff1baf William Zuromski William Zuromski bjzuromski@yahoo.com 016628 37 2026-02-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Mark Jerome Para-ase 2026-02-19 20:24:35 26.9 hrs 6938732cec8d36145ff75f02 000030132 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
309 ae214a5a5e3482a77ef20522ed9e950e48777cb2c8bd8d27e8b9f4fcfb99a941 69332c639686740995092b95 67ced64d7abf9f3ed8ff1906 Karl Wunderlich Karl Wunderlich karl_w@comcast.net 016401 50 2026-02-18 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Peter Gagnon 2026-02-04 20:23:43 -333.1 hrs 69332c639686740995092b94 000029806 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
308 e23f41fb51c795fc6a0b75704c802a6b4d4dc98865dafb014690d1fc00554959 6924caeab73f1935b8899697 6904e2ec7cb75608ed023624 Cassandra Higgins Cassandra Higgins cassy310@comcast.net 020182 28 2026-02-18 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Laura Sage 2026-02-18 17:34:50 0.1 hrs 6924caeab73f1935b8899691 000028244 3.00 78.35 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
307 9a75287bf35dc0a646ea2ef2ff5d70ffdfe1d3fec119f9896a9ead062eedfb33 698e668ef5f4d7ed350cbd09 68a8155e99c65c4a78a601fd Cian Nagle Cian Nagle maireadnagle@hotmail.com 019075 17 2026-02-18 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Mark Jerome Para-ase 2026-02-19 20:17:08 26.5 hrs 698e668ef5f4d7ed350cbd08 000037507 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
306 bf0fcf46883233cdc63a96133aaae07140695b55d92b1b0f3b657b59afe9a778 698cbc227f1878079589ffb1 698cba6347ba088b7fd1f800 Judi Morell Judi Morell jamorell63@gmail.com 020729 15 2026-02-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Haley Paull - Mark Jerome Para-ase 2026-02-20 19:39:05 49.9 hrs 698cbc227f1878079589ffb0 000037251 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:25:43 2026-06-11 22:58:58
305 df6812a3e5b620f7a646e7842bc8254a7826596ece74b35b0b00abfc883ced06 6967e08b070f41772051603e 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2026-02-18 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 2/11 Sophia L. 2026-02-11 15:59:45 -169.8 hrs 6967e08b070f41772051603d 000033682 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:42 2026-06-11 22:58:58
304 44320aafeeda1419d84b0bd332572f009100fa190dffd960f31d3723256bec9c 6941c24f536d5466200d46cc 691b6157de105feb8a9a2dfc Joyce Ochs Joyce Ochs vonwiggins@msn.com 020252 10 2026-02-18 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. 24+pt will not drive to another location Michelle W. 2026-01-16 18:00:45 -791.7 hrs 6941c24f536d5466200d46cb 000030961 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:42 2026-06-11 22:58:58
303 59d426d5286ebee502adf4c4fdff3ef3a71cf7274849ae0557f133a96934a8da 692df8622de5a82ec471905a 67ced34d7abf9f3ed8fe8a3c Barbara Eng Barbara Eng bbeng5843@aol.com 004221 154 2026-02-18 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. rxl'd for 2/17 @ 1:30pm (2/16 - HP) Haley Paull 2026-02-16 21:46:05 -44.0 hrs 692df8622de5a82ec4719059 000029171 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:42 2026-06-11 22:58:58
302 e02789473c5546f5f0f1e5b9d271bd25ee6bc4ebe675b510536ada175e49ca23 68f8fc5924430c3c15ce2624 67ced6407abf9f3ed8ff176a Kit Wise Kit Wise kitwise@comcast.net 016264 63 2026-02-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-18 17:45:42 0.0 hrs 68f8fc5924430c3c15ce2623 000024369 3.00 149.27 149.27 - - - - - - - - 2026-02-19 22:25:42 2026-06-11 22:58:58
301 e6f180412c57d7e9d154f39772963793b05ede142aed3f11fb36e2436e365a04 697a5114cc01b45ba05961f1 683e2243b8ecd2c9d651a06e Marshall Frech Marshall Frech mfrech@tec.org 017372 43 2026-02-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-19 20:38:21 26.6 hrs 697a5114cc01b45ba05961ec 000035724 3.00 81.91 76.91 - - - - - - - - 2026-02-19 22:25:42 2026-06-11 22:58:58
300 ea73c26e73159514656f393b0a6dc06bf7e45e58587136d1429371a46fdcef19 696eaf0bd469893b667d77d2 67ced3ee7abf9f3ed8feb7b4 Janet Kowall Janet Kowall janetckowall@yahoo.com 008101 42 2026-02-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Sage - Sonya C. 2026-02-18 18:01:11 0.0 hrs 699784cf9612c50e8f1dd879 000034345 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:25:28 2026-06-11 22:58:58
299 c30b513623f12ead0fba991fb88b3743a2429d2d7b5d80245730753a1e7535fe 6924d775159d16b4f806e1a4 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2026-02-18 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Sonya C. 2026-02-18 18:02:14 0.0 hrs 6924d775159d16b4f806e17c 000028273 5.00 390.00 0.00 - - - - - - - - 2026-02-19 22:25:28 2026-06-11 22:58:58
298 46277fb4f50bdfd689ff9eedf0e955ba4ccfc3a465ca153bf06f75f0bb28650f 68810d88b430e30821f6129c 67ced5497abf9f3ed8fef5ef SuAnne Shayer SuAnne Shayer suanne15@yahoo.com 013409 118 2026-02-18 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-07-23 16:29:59 -5041.5 hrs 68810d88b430e30821f61292 000014013 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:28 2026-06-11 22:58:45
297 a11f279766eba44b73382639a1e4d7cd5401d2b4c9c03f7a0b810f9b421199e9 697a5c08043b1845161fc54a 6818c9c4ea1e1c59d646b96a Lorena Finnigan Lorena Finnigan lorenafinnigan@gmail.com 017174 37 2026-02-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Renee Carr - Mark Jerome Para-ase 2026-02-19 16:58:13 22.7 hrs 697a5c08043b1845161fc549 000035746 2.00 85.00 30.00 - - - - - - - - 2026-02-19 22:25:28 2026-06-11 22:58:45
296 018181b92effd6b96a5a49a8211493a1e0081032798d23ae9dc4d01557c59218 69653c38cb908e16f01b0034 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2026-02-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Samantha Saunders decrease frequency Samantha Saunders 2026-02-11 18:08:58 -168.1 hrs 69653c38cb908e16f01b0033 000033329 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:28 2026-06-11 22:58:45